(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 '%Sarastro%') 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
I wanted to combine the nice layout and the animation of the Text Watch with the fuzzy time and natural language of the Fuzzy Time watch face.
Fuzzy time, in this case, means that the watch has a 5 minute accuracy. It does however change three minutes ahead so you should still be able to get to your appointments on time. (Example, it changes from "five to nine" to "nine o'clock" at 08:57)
Features:
- Fuzzy time in natural language. (English)
- The large and easy to read fonts of the original Text Watch
- Nice staggered animation
- Between one and four lines of text, depending on need.
- Text is centered both vertically and horizontally.
- Smaller words may share a single line (such as "five to")
- Refactored code for better flexibility/rewriteability
A demo video of the app is available here:
http://youtu.be/ITMfgJvkwzc
Change log:
1.2e First English version.
I was going to add a left justified version but JStheoriginal beat me to it. Get it here:
http://www.mypebblefaces.com/apps/142/5626/
Swedish version of this watchface can be found here:
http://www.mypebblefaces.com/apps/6331/5237/
created by - Sarastro
-
Description
I wanted to combine the nice layout and the animation of the Text watch with the fuzzy time and natural language of the Fuzzy time watch face. This is the Swedish version, for English, see the end of this text.
Fuzzy time, in this case, means that the watch has a 5 minute accuracy. It does however change three minutes ahead so you should still be able to get to your appointments on time. (Example, it changes from "five to nine" to "nine o'clock" at 08:57)
Features:
- Fuzzy time in natural language. (Swedish)
- The large and easy to read fonts of the original Text Watch
- Nice staggered animation
- Between one and four lines of text, depending on need.
- Text is centered both vertically and horizontally.
- Smaller words may share a single line (such as "fem i")
- Refactored code for better flexibility/rewriteability
A demo video of the left justified version is available here:
http://www.youtube.com/watch?v=ccubUg9Hp5Y
Change log:
1.0 First version.
1.1 Allowed composite lines to be longer so "kvart i" and "tjugo i" fits on one line
English version of this app can be found here:
http://www.mypebblefaces.com/apps/6331/5612/
created by - Sarastro
Description
I wanted to combine the nice layout and the animation of the Text watch with the fuzzy time and natural language of the Fuzzy time watch face.
Fuzzy time, in this case, means that the watch has a 5 minute accuracy. It does however change three minutes ahead so you should still be able to get to your appointments on time. (Example, it changes from "five to nine" to "nine o'clock" at 08:57)
Features:
- Fuzzy time in natural language. (Swedish)
- The large and easy to read fonts of the original Text Watch
- Nice staggered animation
- Between one and four lines of text, depending on need.
- Text is always centered vertically.
- Smaller words may share a single line (such as "fem i")
- Refactored code for better flexibility/rewriteability
A demo video of the left justified version is available here:
https://www.youtube.com/watch?v=ccubUg9Hp5Y
Change log:
1.0 First version.
1.1 Allowed composite lines to be longer so "kvart i" and "tjugo i" fits on one line
Future plans:
English translation
created by - Sarastro
