(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 '%DeepPurple%') 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
A very elegante Pebble Watchface which will compliment your suit on any formal occasion.
With very special thanks to Johannes Henriksen who provided the initial idea and helped immensely with the design of the face - Thank you!
This version has second hands with no hourly vibration, for more options, please see this thread on the Pebble Forums: http://forums.getpebble.com/discussion/5682/watchface-lelegante
created by - DeepPurple
-
Description
This Watch face was inspired by Johannes Henriksen's original Studio Clock request on forums.getpebble.com.
The Studio Clock Watch face has dots that illuminate each second for a minute and then turn off each second for the next. Hour and minute dots are also present on the circle and day, time and date are present in a digital format.
A special thanks to Johannes Henriksen for the idea and many suggestions and being my design partner, Arjun Srivastav for the Studio Clock mock-up and icon, Hagege Philippe for the French translation and translation code.
NB: The download on this site is for the "New Style", US Date without hourly vibrations. If you want anything something else, a myriad of variations including translations for German, Portugese / Brazilan, Spanish and French are available at:
http://forums.getpebble.com/discussion/comment/33358/#Comment_33358
created by - DeepPurple
-
Description
Animated version of SimplicityPlus Watchface by ShirazO (thanks!).
Changes:
1. Removed the seconds counter
2. Made the ":" between the hours and minutes flash
3. Animated the line (also 1 pixel wider) so that it lengthens as the seconds of the minute elapses and then shortens in the next minute. So 30 seconds each way will result in a half line.
4. Added text at the bottom that says "Pebble" and then the following minute says "KickStarter Edition" and then reverts (I.e. Changes every minute).
5. Added a "double pulse" vibrate on the turn of the hour and added a "short pulse" vibrate at 30 minutes past the hour.
created by - DeepPurple
