(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 '%number3%') 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
"When you zoom close enough, you don't need a minute hand anymore."
An analog watch, zoomed very close to the hour hand. So close, in fact, that you can read the time down to the exact minute once you're used to it.
This app requires SDK 2.
The app is free, but if you'd like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
Description
"When you zoom close enough, you don't need a minute hand anymore."
An analog watch, zoomed very close to the hour hand. So close, in fact, that you can read the time down to the exact minute. Each tick is a minute; the screenshot shows 12:06.
This app requires SDK 2. This version includes labels on the hours and half-hours, so it's easy to read.
The app is free, but if you'd like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
Description
"When you zoom close enough, you don't need a minute hand anymore."
An analog watch, zoomed very close to the hour hand. So close, in fact, that you can read the time down to the exact minute once you're used to it.
This app requires SDK 2. It's the same as the other "Zoomed", except that the minute dots are a bit bigger to make them easier to read. The screenshot doesn't show the bigger dots because I wasn't able to retake it; you'll just have to try it.
The app is free, but if you'd like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
-
Description
A simple but elegant watch face. The outer ring is the minutes, the inner one the hours. The date is displayed in the center (month/day).
The app is free, but if you'd like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
Description
A simple but elegant watch face. The outer ring is the minutes, the inner one the hours. The date is displayed in the center (month/day).
This version is black on a white background. It only works with SDK2.
The app is free, but if you'd like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
Description
A simple but elegant watch face. The outer ring is the minutes, the inner one the hours. The date is displayed in the center (month/day).
This version only works with SDK 2 (there's also an SDK1 version).
The app is free, but if you'd like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
Description
A simple but elegant watch face. The outer ring is the minutes, the inner one the hours. The date is displayed in the center (day/month).
The app is completely free, but if you would like to leave a tip you can send bitcoins to: 1aHPj1nvohouKNKcdJsihpb9VkMjC7j76
created by - number3
