(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 (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 1904,56
-
Description
Who doesn't love Bettie Page? As a big fan of pin-ups and WWII nose art, I thought a few of these would be appropriate.
Another classic pose with white background.
created by - Rowdy
-
Description
Who doesn't love Bettie Page? As a big fan of pin-ups and WWII nose art, I thought a few of these would be appropriate.
Another classic pose with white background.
created by - Rowdy
-
-
-
-
-
Description
This watchface shows a world map with the current sunlight coverage, along with the time and date. Watch daylight pass across the earth as the day goes by, and see how the sun hits the earth at different times of the year.
Here is another screenshot for a different time of year: http://i.imgur.com/5ewBSfN.png
The map is redrawn every 15 minutes.
(The time and date shown on the watch are local time. To draw the map UTC time must be known, and the phone must be queried to determine which time zone the watch is in. This happens once and is automatic.)
Black on white version: http://www.mypebblefaces.com/apps/18667/9353/
Source code on github: http://github.com/davidfg4/pebble-day-night
created by - davidfg4
-
-
Description
Simple black analog watch face expressing a love for vinyl music.
created by - Rowdy
-
Description
Simple black analog watch face expressing a love for vinyl music.
created by - Rowdy
-
-
-
-
-
-
-
-
-
Description
Simply and clear date and time. Digital times and catalan months and date.
created by - Palleter
-
Description
From the game Grim Fandango, here is a watchface in the honor of Salvador Limones, late leader of the Lost Souls' Alliance.
"VIVA LA REVOLUCION!"
created by - Gnoupi
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Description
Digital watch face with date and time using Jonzy's Hackintosh logo. Both black and white backgrounds available.
created by - Rowdy
-
Description
Everybody's favorite Star Wars 'droid. Digital with date on white background.
I originally replaced the SDK 1 version with the SDK 2 update, but decided that there may be some that are not upgrading, so see my SDK 2 version as well.
created by - Rowdy
-
Description
Another simple Roman Numeral watch face for SDK 2.0, based on an actual clock
created by - tjnyc
-
-
Description
Analog watch face with Sporting KC Logo on black background. Two stars indicate the team's two MLS championships, including 2013.
created by - Rowdy
-
Description
From the TV show Firefly.
Very simple time/date watchface using a modified Blue Sun Corporation logo. Since the regular logo is rectangular with large Chinese characters below the English lettering and sun, I added these characters overlaid on the sun to make room for the clock and calendar.
This is my first attempt at a watchface, which I built online using http://www.watchface-generator.de/
created by - Rowdy
-
Description
Who doesn't love Bettie Page? As a big fan of pin-ups and WWII nose art, I thought a few of these would be appropriate.
A more cartoonish bit of art with white background.
created by - Rowdy
-
Description
Who doesn't love Bettie Page? As a big fan of pin-ups and WWII nose art, I thought a few of these would be appropriate.
Another classic pose with white background.
created by - Rowdy
-
Description
Who doesn't love Bettie Page? As a big fan of pin-ups and WWII nose art, I thought a few of these would be appropriate.
Classic pose with white background.
created by - Rowdy
-
-
-
-
-
-
Description
Nokia's well known logo is now available as a watchface and without date!
created by - LMZR
-
Description
Nokia's well known logo is now available as a watch face!
Enjoy!
created by - LMZR
-
-
Description
Audi Old School logo. Watchface created using watchface-generator.de
created by - Ashdex
-
Description
Just a face I made for the Saskatchewan Roughriders, the CFL Grey Cup Champions of 2013!
I hope you enjoy it!
created by - Asmodath
