(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 '%peaz%') 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
Inspired by Pebble's Fuzzy Time.
Included a top bar to display the day and date and a bottom bar to display the 24 hour time with a second ticker and the day of the year.
Updated version of the original Fuzzy Time +, now using a smaller font to fit an all text time display.
created by - peaz
-
Description
Military time in in English text!
Basically a military time version of my SplitText watch (http://j.mp/splittext2). Has the same top bar with day and date and a bottom bar with a 12 hour clock with a second counter and the Week of the year display.
created by - peaz
-
Description
Inspired by Fuzzy Time and extended to display the day, date and month, 24 hour time display and the week #
The hour text display inverts depending on AM or PM. Vibes on every new hour
created by - peaz
-
Description
Right-aligned version of SplitText v2.
Inspired by Pebble's Text Watch. I added a top bar showing the date and a footer bar showing the day, a 24H clock, and the week number. Now with animation! The hour is in a white background and the minute in black (thus the name SplitText) to make it clearer to read.
V2.1 Update:
- No longer pulses by the hour (please request if you want it to)
- Fixed week number to reflect ISO standards
- 24H display includes a second tick
Left aligned version available as well (SplitText v2)
created by - peaz
-
Description
Text Watch style watchface. Added Day and Date display. No animation implemented yet.
created by - peaz
-
Description
Inspired by Pebble's Text Watch. I added a top bar showing the date and a footer bar showing the day, a 24H clock, and the week number. Now with animation!
The hour is in a white background and the minute in black (thus the name SplitText) to make it clearer to read.
V2.1 update:
- No longer pulses (please request if you want it to pulse)
- Fixed the Week number to follow ISO standards.
- 24H watch now has a second tick.
Right-aligned version available as well (SplitText v2 Right-aligned)
created by - peaz
