(mysqlt): select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and (ak_pebble_authorName LIKE '%ArnIIe%') and (p1.cID!='128') and cvName != '' and pt.ctID = '10' and (ak_exclude_page_list = 0 OR ak_exclude_page_list is null) and PagePaths.cPath like '/apps/%' and PagePaths.ppIsCanonical = '1' and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ((select count(cID) from PagePermissionAssignments ppa1 inner join PermissionAccessList pa1 on ppa1.paID = pa1.paID where ppa1.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and pa1.accessType = 10 and pa1.pdID in (0)
and pa1.peID in (2) and (if(pa1.peID = 4 and p1.uID <>0, false, true)) and (ppa1.pkID = 1 and cv.cvIsApproved = 1)) > 0
or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL)) and ((select count(cID) from PagePermissionAssignments ppaExclude inner join PermissionAccessList paExclude on ppaExclude.paID = paExclude.paID where ppaExclude.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and accessType = -1 and pdID in (0)
and paExclude.peID in (2) and (if(paExclude.peID = 4 and p1.uID <>0, false, true)) and (ppaExclude.pkID = 1 and cv.cvIsApproved = 1)) = 0) and ak_pebble_flag = '0' and ak_pebble_subApp = '0' and p1.cIsActive = '1' order by ak_pebble_dateAdded desc limit 0,56
-
Description
For the full version with loads more facts, to impress your friends with, go to: http://pebblebarn.com/shop/fact-a-minute/
The facts have been taken from reliable sources and each one checked via multiple locations and can be given true fact status –
so confident am I, that a full refund will be granted for anyone that can disprove any facts shown in the paid version.
What better than a bit of trivia every time you check your watch!
This is a slight modification of the simplicity watchface.
created by - ArnIIe
-
-
Description
Possibly the hardest to read pebble watchface ever!
Based on fuzzy time, this is cockney time!
Any comments or suggestions, please use the comments box.
If you'd like to donate, any contributions welcome! Also happy to take requests for fuzzy time style watchfaces (like cockney or bingo time): http://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=5V2EG7NTSXAA6
If it helps:
1 - Lost (and won)
2 - Bottle (of glue)
3 - Holy (see)
4 - Stand (in awe)
5 - Scuba (dive)
6 - Fiddle (-sticks)
7 - Exeter (in devon)
8 - Far too (late)
9 - Coal (mine)
10 - Foxes (den)
11 - Hell (and heaven)
12 - Deep (delve)
13 - Hurt (and be mean)
14 - (Sortin) letters
15-19 - ?
20 - Mussels (aplenty)
21-29 - ?
30 - Herdy
40 - Gory
50 - Nifty
60 - Styx tea
70 - Heaven Tea
80 - Baity
90 - God (almighty)
created by - ArnIIe
-
Description
Probably the hardest to read pebble watchface of all time!
Based on Fuzzy time, this is the cockney equivalent.
If it helps:
1 - Lost (and won)
2 - Bottle (of glue)
3 - Holy (see)
4 - Stand (in awe)
5 - Scuba (dive)
6 - Fiddle (-sticks)
7 - Exeter (in devon)
8 - Fartoo (late; another explanation is that "far" is supposed to be "four" and "too" is supposed to be two - four times two is eight. But I believe it's rather the first explanation)
9 - Coal (mine)
10 - Foxes (den)
11 - Hell (and heaven)
12 - Deep (delve)
13 - Hurt (and be mean)
14 - (Sortin) letters
15-19 - (Can't find) If you know then put a comment and I'll change it!
20 - Mussels (aplenty)
30 - Herdy
40 - Gory
50 - Nifty
60 - Styx tea
70 - Heaven Tea
80 - Baity
90 - God (almighty)
created by - ArnIIe
-
-
-
Description
An app to generate your winning (hopefully!) UK national lotto numbers.
My first pebble app utilising cloudpebble.
UPDATE/CHANGELOG:
Version 2: You can use the 'up' button to refresh your chosen numbers
Made by ArnIIe
created by - ArnIIe
