(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 '%chrisb%') 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
From one of Richard G's most excellent concept watchfaces.
Hands are bitmaps, so the rotation is a little less than satisfactory. May redo as paths at some point...
Version 1.1 updates the watchface to correct for hour 7 and 8 (had incorrect roman numeral).
For the various versions, I've given everything a distinct UUID so there should be no problem having different versions on the same watch.
Also for the name there will be an 'R', 'S', and/or 'D' for
R - Reversed bottom line
S - Seconds
D - Date
created by - chrisb
Description
Same thing, but without the second hand
Version 1.1 updates the watchface to correct for hour 7 and 8 (had incorrect roman numeral).
created by - chrisb
-
Description
The 'Russian' watch face is modeled after the Italian designed watch marketed in 1989 by Gruen. The original watch had a Soviet quartz movement (no date) and a military design. While the original watch came with a lapel pin, this watch comes with a date and several other different configurations.
Includes a second hand and day of the month.
An inverse version and all permutations are also here.
created by - chrisb
-
Description
Simple watchface with large Bauhaus Heavy numbers, minimal hands.
created by - chrisb
Description
Simple watchface with large Bauhaus Heavy numbers, minimal hands.
created by - chrisb
Description
Simple watchface with large Bauhaus Heavy numbers, minimal hands. Inverted
created by - chrisb
Description
Simple watchface with large Bauhaus Heavy numbers, minimal hands.
created by - chrisb
-
Description
An homage to Edward Gorey (code gratefully borrowed from Pebble's Simplicity watchface).
Font based on Edward Gorey's own hand lettered books. Bat based on one of his bats from "Edward Gorey's Dracula"
Updated to have different menu names for the Black (background) and White (background) versions. Also added deinitialization to free up resources when the watch face is closed/switched.
created by - chrisb
Description
An homage to Edward Gorey (code gratefully borrowed from Pebble's Simplicity watchface).
Font based on Edward Gorey's own hand lettered books. Bat based on one of his bats from "Edward Gorey's Dracula"
Updated to have different menu names for the Black (background) and White (background) versions. Also added deinitialization to free up resources when the watch face is closed/switched.
created by - chrisb
Description
A Big Time version with Gorey's distinctive Typography. For the hardcore Gorey fans
created by - chrisb
