(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 392,56
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Description
Im kinda got trouble for looking some christmas watchface on the internet
so i am making this simple christmast tree watchface to all of you
hope u can enjoy it
and wearing it on Christmas party
if you really are tag me on instragram with #Christmaswatchface
Enjoy
created by - inward
-
-
-
-
-
-
-
-
-
Description
Watch face featuring the Otacon sprite from Metal Gear Solid 2. Includes time, date, connection indicator, and battery indicator.
created by - Silverblade
-
-
-
Description
This is the original Flanders Field poem reformed as a pebble watchapp especially for Remembrance Day and the Royal British Legion. Support the fallen! Use website link below!
It is a plain text, that supports scrolling!
created by - connorypebble
Description
Wear your virtual poppy! A watch poppy for your smartwatch! Support the fallen from WW1. Sponsored by the Royal British Legion. Remember to donate at website! Colours invert when Bluetooth is disconnected!
created by - connorypebble
-
-
-
Description
A derivation of TextWatch in Bahasa Malaysia. Typeface size is reduced to cater few numbers in Bahasa Malaysia like "Sembilan" instead of "Nine".
Any comment and suggestion is much appreciated.
*Forked on GitHub at : http://github.com/wearewip/PebbleTextWatch
**Anda faham Bahasa Malaysia, dan reti bagaimana nak mengaturcara dalam C atau JS? Nah boleh fork terus dari sini : http://github.com/nurfaizfoat/PebbleTextWatch
V1.0.1
======
- Earliest version. Watchface crash when Pebble lost connection with mobile device.
- No menu image and no App Locker thumbnail.
- Font might be too small. Will looking for a more suitable size.
created by - nurfaizfoat
-
-
-
Description
Omega style inspired face with month, date and day. Connection and battery indicator. (NB In no way associated or connected with Omega and its products).
created by - Paul123
-
-
Description
Omega style inspired face with month, date and day. Connection and battery indicator. (NB In no way associated or connected with Omega and its products).
created by - Paul123
-
Description
Omega style inspired face with month, date and day. Connection and battery indicator. (NB In no way associated or connected with Omega and its products).
created by - Paul123
-
-
-
Description
FitFace is a new Fitbit watchface for pebble!
It shows:
-Calories burned
-Active minutes
-Steps taken
-Distance
-Calories eaten
-Calories left
Has some cool animations, and features such as BT/battery status.
This watchface will be supported continuously, so if it breaks or the site breaks, I will be repairing it. Please email me if you experience issues.
created by - EdwinForTheWin
-
-
-
-
-
Description
Simple digital face with month, date, day. With battery and connection indicator.
created by - Paul123
-
Description
A bigger central circle showing the hours, a smaller circle showing minutes revolving around the hour circle. A battery bar (a thin line at the very bottom) shows charge, date number shown in the lower right.
created by - Prieni
-
Description
Why settle for earthly weather when your watchface can display space weather!
The sunshine analog watchface provides near real-time views of the Sun's corona (coronagraph), as imaged by the LASCO instrument on the SOHO (NASA & ESA) spacecraft [1].
Sunshine also lists the class and time of the most recent solar flare (bottom right).
1. http://sohowww.nascom.nasa.gov
created by - afourney
-
-
-
Description
This watch display rotates as compass and always points to the north.
By Pedrolane & Ron64.
You may need to face north to be able to read the time easily.
created by - ron64
-
-
Description
Does this watchface resemble some very expensive swiss watches? Not a coincidence :)
This sub-version includes day number.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
Description
Watchface in style gta:
+ Time - current time;
+ Health - pebble battery;
+ Money - current date or manual text (numbers);
+ Stars - current week day (from monday to friday) or bluetooth connection state (where 1 and 5 - double vibration);
+ Status pebble battery charging;
+ The date format change;
+ Changing weapons, depends on the day of the week;
+ Invert color;
+ "Settings" button.
created by - vdm
-
-
Description
Not accidentally this watchface resembles one of the most beautiful and expensive watches any aviation enthusiast would love to have. So, here are them ;)
This watch face is compatible with Pabble SDK v2.0 only.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
Description
Not accidentally this watchface resembles one of the most beautiful and expensive watches any aviation enthusiast would love to have. So, here are them ;)
This watch face is compatible with Pabble SDK v2.0 only.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
-
Description
**Please VOTE and FAVORITE my watch face!** Your support is appreciated!
A watchface for all Batman fans. This watchface currently includes the Dark Knight Logo along with time, date, weather, and battery gauge. Future updates will include weather condition icons, bluetooth notifications (to warn you've left phone behind), and app settings to include Celsius.
created by - Fwbrown23
