(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 112,56
-
Description
This watchface is taken from the album artwork for 'Far Nearer' by Jamie xx, with the help of watchface-generator, I have taken this artwork and made it into a simple, minimal watchface.
created by - notsamkerr
-
Description
As a huge browncoat, I was disappointed to find a lack of Firefly faces. This is just a simple attempt to remedy that.
created by - JacobT15
-
-
-
-
-
-
-
-
-
Description
I created this app hoping it would help students, scientists, and anyone interested in science learn/have a reference of the periodic table of elements.
There does seem to be another app similar to mine in the store, but I can promise you mine has more features. :)
If you believe I made any mistakes in the app, please don't hesitate to contact me, I don't want to be giving anyone false information! Also contact me if you have some improvements you think I should make. :)
Thanks.
created by - GRA0007
-
-
-
-
-
-
Description
A binary clock is a clock that displays the time of day in a binary format.
created by - delda
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Description
Watchface that displays username, total reputation, and daily reputation gain of any StackOverflow user.
created by - tinydev
-
Description
A watchface that shows time, date and weather using sketchy style.
Always will notify you when bluetooth connection lost by vibration and when the battery is low by showing icon.
- Current weather of your location or any custom location you entered in the settings;
- Temperature in Fahrenheit or Celsius as you decide;
- Two weather servers: YahooWeather and OpenWeatherMap;
- Time in 12h or 24h format based on your watch's preference;
- Current date.
You can also setup to show always bluetooth status and battery charge if want.
Just try. You'll like it!
created by - Trua
-
Description
For all the people I've let down by not having a webserver for a RE:Evolution config page.
created by - RooGuru
-
-
-
Description
Individual is a watch face that shows the hours in the top left and the minutes on the bottom right
created by - digitzz
-
-
-
-
-
-
Description
This face is from an old watch that Apple once made.
It should run on 2.0 and 3.0 in color and black and white.
Who needs to spend money on an Apple Watch when you can get this one free?
created by - PiwwowPants
-
Description
A simple Chinese character only watchface, created via Watchface Generator by Paul Rode.
created by - ClieOS
-
Description
Pebble watchface with digits made out of tetriminos.
When time changes, old digit vanishes and new digit is reassembled out of falling tetriminos.
Optionally shows date and weekday. Supports battery and bluetooth connection status. Can be configured to vibrate on bluetooth disconnection/reconnection.
Press 'Settings' button in Pebble app to configure the watchface to your liking.
NOTE! This application uses javascript. iOS users won't be able to use this version and should download it from pebble app store instead.
created by - vflashm
-
Description
A realtime 3D first person engine running at 30fps.
Control with the accelerometer. Start by holding the Pebble flat (face up) and move by tilting the pebble: forward and back to walk and side to side to rotate. Hold the bottom button to strafe instead of rotate. Press the center button to remove walls. Press the up button to generate a new maze map.
This is just a demo. There is no goal or objective other than to move around and bump into walls. A single sprite has been added to demonstrate sprite rendering.
The source code has been provided so anyone can use this to create their own game or other 3D application.
created by - robisodd
-
Description
Replica of the gold Electronica 5 digital watch. Simple and clean design. It tells the time.
created by - jbarnatt
-
-
Description
Hebrew Fuzzy watch with Torah(Ashkenaz) font.
This app is HEAVILY based on heb-text-pebble by Kalugny which was SDK 1.0
This version is SDK 2.0 and 3.0 compatible
created by - kaaspad
-
Description
PebbleQuest http://davidcdrake.com/pebblequest/ is a 3D fantasy action-RPG, the first of its kind ever developed for a smartwatch! Explore dungeons, slay monsters, level up, and wield Pebbles of Power to cast spells or enchant your weapons and armor. How long will you last in the dark, cavernous depths of PebbleQuest?
UP: Press/hold to step forward. Press twice to turn left.
SELECT: Press to use your current weapon/spell.
DOWN: Press/hold to step back. Press twice to turn right.
created by - theDrake
-
Description
Watch face using imagery from the the Sega CD game Snatcher. Clock is on the right incorporated into the graphic. Battery gauge on the bottom left. Bluetooth connection indicator bottom right.
created by - jbarnatt
-
Description
A simple modern watchface with date, month, BT and battery status, created via Watchface Generator by Paul Rode.
Based on modified 'Supreme' font.
created by - ClieOS
-
Description
A simple modern watchface with date, BT and battery status, created via Watchface Generator by Paul Rode.
Based on modified 'Supreme' font.
created by - ClieOS
-
Description
Ingress Community is a customisable watchface for both Enlightened and Resistance factions. It allows you to display your local community's name and motto on your wrist.
Due to limited display size, community name field is truncated at 16 characters, and motto field is truncated at 17 characters. Part of your message may not be visible depending on the width of each character.
created by - LachyTech
-
Description
A simple modern black watchface with date, month, BT and battery status, created via Watchface Generator by Paul Rode.
created by - ClieOS
-
Description
A simple modern white watchface with date, month, BT and battery status, created via Watchface Generator by Paul Rode.
created by - ClieOS
