(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 '%JStheoriginal%') 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
Fuzzy Text "after" (Left-Justified) White
Description
GET THE BLACK VERSION HERE: http://www.mypebblefaces.com/apps/142/5626/5629/
This version replaces the word "past" with "after" in all cases except "half past". In my part of the world, it's more common to say "twenty five after nine" instead of "twenty five past nine". It's just odd to say "half after nine" so that's why I've kept that as "past". Enjoy!
Credit goes to this original source: http://github.com/Sarastro72/Swedish-Fuzzy-Text-watch/tree/lang_english
which can be downloaded here: http://www.mypebblefaces.com/apps/6331/5612/
Big Time Harry P.
Description
A version of Big Time using a free Harry Potter font.
Big Time Typewriter
Description
A version of Big Time using a free typewriter font.
Big Time AngryBirds
Description
A version of Big Time with a free AngryBirds font.
Big Time Transformers
Description
A version of Big Time that uses a free Transformers font.
Big Time Sketch Block
Description
A version of Big Time using the free Sketch Block font.
Big Time Mickey (Black)
Description
A version of Big Time using Mickey fonts!
Big Time Mickey (Inverted)
Description
The inverted version of Big Time Mickey so the shadows of the font are actually black!
Big Time Mickey (Black) with 0
Description
As requested, a version with a leading zero on the first line for hours 9 and under. i.e. 02 35 vs 2 35
Fuzzy Text (Left-Justified)
Description
left-justified text version of this watch face here: http://www.mypebblefaces.com/apps/6331/5612/
NEW: Get this same left-justified version but with the word "past" replaced with "after" for all instances but "half past": http://www.mypebblefaces.com/apps/142/5626/5629/
NEW: White version of the "after" version added here: http://www.mypebblefaces.com/apps/142/5820/
Fuzzy Text "after" (Left-Justified) Black
Description
GET THE WHITE VERSION HERE: http://www.mypebblefaces.com/apps/142/5820/ This version replaces the word "past" with "after" in all cases except "half past". In my part of the world, it's more common to say "twenty five after nine" instead of "twenty five past nine". It's just odd to say "half after nine" so that's why I've kept that as "past". Enjoy! Credit again goes to this original source: https://github.com/Sarastro72/Swedish-Fuzzy-Text-watch/tree/lang_english which can be downloaded here: http://www.mypebblefaces.com/apps/6331/5612/
Text with Oh and Small Date White
Description
This is a variation of this super watch face: http://www.mypebblefaces.com/apps/1585/1350/
This version:
- inverts the colours to black text on white background
- increases the font size of the date lines to 18 from 14 so they are more legible
Text with Oh and Small Date Black
Description
Same as (http://www.mypebblefaces.com/apps/142/5622/) but with the original black background of (http://www.mypebblefaces.com/apps/1585/1350/). Therefore the only difference vs. the original is now that the date lines are 18pt instead of 14pt so they're easier to read, yet still small.
