(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 1792,56
SDK2 Pebble Steel "Studio Clock" Aerospace
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f
All credit to Watchface Generator and the concept watchface.
SDK2 Pebble Steel "Studio Clock" Aerospace -US
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f All credit to Watchface Generator and the concept watchface.
SDK2 Pebble Steel "Studio Clock" Aerospace TME/DTE
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f All credit to Watchface Generator and the concept watchface. Added TME/DTE text.
SDK2 Pebble Steel "Studio Clock" Aerospace TME/DTE - US
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f All credit to Watchface Generator and the concept watchface. Added TME/DTE text. US date format.
Pebble Steel "Studio Clock" Aerospace US with TME/DTE
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f
All credit to Watchface Generator and the concept watchface.
TME/DTE text; US date format
Pebble Steel "Studio Clock" Aerospace with TME/DTE
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f All credit to Watchface Generator and the concept watchface.
Read !!! Iqraa
Description
calligraphy once again ! it's the same word in a pattern it means : READ !
Pebble Steel "Studio Clock" Aerospace
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f
All credit to Watchface Generator and the concept watchface.
Pebble Steel "Studio Clock" Aerospace US format
Description
In response to the interest in the Pebble Steel "Studio Clock" watchface (actually a concept watchface from http://forums.getpebble.com/discussion/4172/watch-face-flight-a-watch-for-pilots-with-f All credit to Watchface Generator and the concept watchface.
Doctrine Man 2
Description
The U.S. Army's foremost superhero. Google "The Adventures of Doctrine Man" to follow our intrepid hero and his ne're-do-wells as they comment on political and military issues of the day.
Doctrine Man
Description
The U.S. Army's foremost superhero. Google "The Adventures of Doctrine Man" to follow our intrepid hero and his ne're-do-wells as they comment on political and military issues of the day.
Arabic Besmellah
Description
Square arabic calligraphy
V0.2 updated with date and analog.
MeteoQueixans CAT
Description
Data i hora amb el logo de MeteoQueixans (http://www.meteoqueixans.com). En català, també disponible en castellà.
MeteoQueixans ES
Description
Fecha y hora con logo de MeteoQueixans (http://www.meteoqueixans.com). En castellano, también disponible en catalán.
Sickbeard
Description
Show your recent Sickbeard downloaded and upcoming shows on your Pebble.
It is required that your Sickbeard is reachable through the internet. (So that the watchface can be updated when on 3G)
Get your Sickbeard API key from "general > config" in Sickbeard
Set your Sickbeard address and api key in the configuration screen.
Classic Roman
Description
A very classical clock that we've all seen in Christian Churches
Vasarely Zebras
Description
Another watch face based on work of the great op art artist Victor Vasarely. More should follow.
Other Vasarely watch faces:
Vasarely: http://www.mypebblefaces.com/apps/8276/9372/
Vasarely inverted: http://www.mypebblefaces.com/apps/8276/9373/
Learn more about Victor Vasarely: http://www.google.com/search?q=victor+vasarely
Created with help of http://www.watchface-generator.de
Archery score
Description
Archery score
Simple sum of score values
UP or DOWN to choose point (1,2,3,...10)
MIDDLE to add
MIDDLE long press to delete last entry
Top Gear 2
Description
A new watch face featuring our three presenters, Jeremy, Richard and James, from my favorite show on BBC 2 - Top Gear.
Disk Clock
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
Disk Clock (white background, SDK2)
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
Disk Clock (SDK2)
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
Disk Clock (day/month)
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
Dark Future
Description
Future styles in dark theme
http://www.watchface-generator.de/watchfaces/20140109/dark_future/
Texas State Bobcats Watch
Description
Bobcat Logo with Eat 'Em Up Cats. Black Background. Includes Date
Big Blocks
Description
A Pebble face where large blocks build up around the edge of the watch as the hours tick along.
Colors can be inverted, and display of the full time, hour, or minute can be set by accessing the settings in the Pebble application.
http://www.WeAreWearable.com
Supports 2.0 SDK
Daylight
Description
A Pebble watch face that shows the daylight as it streaks across the globe.
Land masses can be shown or hidden by accessing the settings in the Pebble application.
http://www.WeAreWearable.com
Supports 2.0 SDK
Flying Blind
Description
A Pebble watch face that vibrates the time. Optionally vibrates every half or quarter-hour. Shake your wrist to briefly see the time.
Colors can be inverted and vibration intervals can be set by accessing the settings in the Pebble application.
http://www.WeAreWearable.com
Supports 2.0 SDK
Islamic Shahada
Description
A very beautiful and elegant arabic calligraphy with simple time & date fonts.
King Crimson
Description
Great band and iconic album cover. Simple digital with time and date.
Sideswipe Basic
Description
A nice and simple watch face for those that favor a more minimalist design.
Manchester United Devil WatchFace
Description
A watchface that is based on the famous Manchester United's 2007/2008 t-shirt logo..
A problem was found in the previous Manchester United Devil Watchface and this one replaces it, sorry for the inconvenience..
Jewish Clock
Description
Features:
- Gregorian & Jewish date
- Moon phase
- Number of Zman/jewish hour, and time until next
- Sun/Day Graph
- Sunrise (Netz), mid-day(Hatzot) & Sunset (Skhia)
- Mincha Alerts (vibration and message) for Mincha Gdola, Ktana, Plag & 18 mn before Shkia/Sunset.
- Battery and Bluetooth status, vibrates if Bluetooth connection is lost.
Bible
Description
The full Bible strapped to your wrist.
Navigate the entire Bible using fast book and chapter selection. Read chapters of the Bible right on your Pebble. Bible version is the New English Translation.
Bible API provided by Bible.org, Copyright ©1996-2006 Bible.org, reprinted with permission
Time (Date and Time)
Description
Lost time is never found again. This quote is a reminder that every you must use every second of your life if the way that would make you have lived a fulfilling life. You may deviate, but time will not.
Vasarely inverted
Description
Second version of simple analogue watch face which has been inspired by work of the great op art artist Victor Vasarely. More should follow.
Original version: http://www.mypebblefaces.com/apps/8276/9372/
More about Victor Vasarely: http://www.google.com/search?q=victor+vasarely
Created with help of http://www.watchface-generator.de
Vasarely
Description
This simple analogue watchface has been inspired by work of the great op art artist Victor Vasarely. More should follow.
More about Victor Vasarely: http://www.google.com/search?q=victor+vasarely
Created with help of http://www.watchface-generator.de
Intervals [SDK2.0]
Description
Helper app for training using intervals.
Use the up arrow to set walk (rest) interval in seconds, down arrow for run (work) interval and select to start/stop.
A short vibrate means start running, long vibrate means start walking.
League of Legends Solo Queue Display
Description
League of Legends
Solo Queue Watch App
**PEBBLE FIRMWARE 2.0**
http://github.com/PyroZeroX/soloqueuewatch
This watch app lets you view your League of Legends ranked solo queue statistics where ever you are! Just configure the app to point to your Summoner name and away you go.
Known Issues / Bugs / Quirks
----
User Configuration:
- *** Summoner name is case sensitive!! ***
API:
- Can take a long time (upwards of 7sec), this out of my control.
Future Plans:
- Implement tier images
- Implement more depth in statistics (KDA/Fav champ etc)
- Implement ranked decay warning (If you have been inactive for a while)
Noningstyle ENG
Description
Noningstyle ENG is an easy to read Watchface in English date format.
Noningstyle SWE
Description
Noningstyle SWE is an easy to read Watchface in Swedish date format.
Modernize 2
Description
Modern with lines on top & bottom. Square numbers, hands, LED short-date. Enjoy!
Magic Eight Ball
Description
Simulates a magic 8-ball. Shake your pebble and have one of twenty answers appear from the darkness, lending you supreme wisdom.
Compiled for Pebble Firmware v2.0 BETA
Based off of: http://www.mypebblefaces.com/apps/4678/4196/