(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 4032,56
QR Signa un Vot per la Independència de Catalunya
Description
QR per fer difusió de la campanya Signa un Vot per la Independència de Catalunya:
http://signaunvot.assemblea.cat/
http://einesxestat.cat/
QR to publicize the campaign sign a vote for independence of Catalonia:
http://signaunvot.assemblea.cat/
Rellotge digital de 24h. Digital 24h watch.
QR Via Catalana de l'11 de setembre de 2013
Description
QR per la campanya de les inscripcions de la Via Catalana de l'11-9-2013:
http://via.assemblea.cat/
QR for the campaign to registration in the Catalan Way of 11-9-2013:
http://via.assemblea.cat/
Rellotge digital de 24h. Digital 24h watch.
Most interesting Cat
Description
Really interesting information ( hour and date) for cats and cat lovers
Watchface "Interesting Cat"
by Watchface-Generator for Pebble
created 05.09.2013, 15:31
Secrets Of Kaplan
Description
Secrets of Kaplan Band Logo Digital Watch Interface
'D' - Pebble DZ7044 Watch Face
Description
This is roughly based on my old Diesel DZ7044 digital watch, which is a great watch apart from the strap which only seems to last 6 months or so before I have to send it off for replacement.
So, here's a Pebble version instead!
It's a nice easy to read watch face, with am/pm and day/date/weekday displayed but it still manages to look unique and use all the available screen.
It's been coded to run efficiently and quickly - there is a seconds update but the code only re-draws the digits which have updated so it should be fine on battery even with the seconds display. (I saw one watch face which re-drew the am/pm indicator every second!)
This is my first watch face so please feel free to comment and make suggestions.
Cheers
http://www.hencam.co.uk
'D' - Pebble DZ7044 Watch Face - UK format date
Description
As requested, version with UK format dd/mm date, 12 hour format time.
'D' - Pebble DZ7044 Watch Face - 24 hour time format, UK format date
Description
As requested, version with UK format dd/mm date and 24 hour time.
'D' - Pebble DZ7044 Watch Face - US format date, 24 hour time format
Description
As requested, version with UK format dd/mm date.
Take a Break: Activity Timer (Light)
Description
Take a Break: Activity Timer is an easily customizable timer that gently reminds you to rest when participating in an engaging activity. By default, every 25 minutes you'll be encouraged to take a 5 minute break. You can set the Work Timer and Break Timers anywhere from 5 to 60 minutes. When it switches between timers, the Pebble will vibrate once to let you know. It also has a small digital clock so that you can use it like a Watchface.
Take a Break: Activity Timer (Dark)
Description
Take a Break: Activity Timer is an easily customizable timer that gently reminds you to rest when participating in an engaging activity. By default, every 25 minutes you'll be encouraged to take a 5 minute break. You can set the Work Timer and Break Timers anywhere from 5 to 60 minutes. When it switches between timers, the Pebble will vibrate once to let you know. It also has a small digital clock so that you can use it like a Watchface.
Take a Break: Activity Timer (Mixed)
Description
Take a Break: Activity Timer is an easily customizable timer that gently reminds you to rest when participating in an engaging activity. By default, every 25 minutes you'll be encouraged to take a 5 minute break. You can set the Work Timer and Break Timers anywhere from 5 to 60 minutes. When it switches between timers, the Pebble will vibrate once to let you know. It also has a small digital clock so that you can use it like a Watchface.
UW Badgers
Description
University of Wisconsin - Madison, analogue clock with date. Go Badgers!
Created with: http://watchface-generator.de/
Patriots watchface
Description
Watchface with date and time and patriots logo (white).
Yellow Sign
Description
"Tell Me, Have You Seen the Yellow Sign?"
"Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn"
Spaghet Time
Description
Hungry ? It's spaghet-time
Made with Watchface generator http://www.watchface-generator.de
Old Style Circle
Description
Old style numerals (text figures) in a circle layout. Includes date and seconds.
Other Versions
Old Style Circle (outline)
Description
Outline instead of solid circle. 2.0 compatible version: http://gumroad.com/products/tJOY
Other Versions
Chinese Geek
Description
Chinese (Japanese) geek watch face
Feathers:
1. Eight-Character (八字, a.k.a. Four-Column 四柱) solar clock (double-hour, date, month, and year)
2. Chinese quarter of hour (刻)
3. Yijing Hexagram (易经八卦图) as the binary representation of the 64ths of a quarter
4. Chinese traditional calendar date (农历)
5. Gregorgian year and date
6. Day of week
Warning: This is a beta version. The month and year columns of the 8-character clock have errors, but are accurate within a day.
Todo: Improve accuracy of month and year columns of the 8-character clock to minute position.
Wonkey White
Description
A brighter version of Wonkey.
Bitcoin: 1BC1mWfFyLRBHLJcMvua1AKSCA2APzkgM3
wonkey
Description
Analog watch face with shaded, offset numbers.
Made with watchface-generator.de
Bitcoin: 1BC1mWfFyLRBHLJcMvua1AKSCA2APzkgM3
Other Versions
Wonkey non shaded
Description
Wonkey analog watchface without shading.
Other Versions
Duca Time
Description
For Ducati aficionados only
Made with http://watchface-generator.de/
Thks to Paul R.
DucaTime Fr
Description
For french Ducati aficionados only
Made with http://watchface-generator.de/
Thks to Paul R.
Old Style
Description
Old style numerals (text figures). Time, day, date with superscript ordinals, month and year.
Other Versions
Old Style (inverted)
Description
White on black. 2.0 compatible version: http://gumroad.com/products/MxAi
Other Versions
Flemish Fuzzy Time
Description
Adapted "Dutch Fuzzy Time" to a Flemish version. Big thanks to MaikJoosten for sharing the code!
Volem cap a La Independència
Description
Watchface Oficial de Volem cap a La Independència.
Perquè un poble té dret a decidir, pacífica i civilitzadament.
+info: http://www.volemcapalaindependencia.com/
Felix Lion
Description
Nice Watchface with Digital Watch and Lion Tattoo.
Created by Felix.
Data i hora en Català
Description
Data i hora en Català. Rellotge digital de 24h. Data en text.
Catalan date and time. Digital 24h watch. Text date.
Need to Know
Description
Everything you need to know, Battery, Weather, Messages, Phone calls, and well the time.
Gravity
Description
I accidentally made the hands too big and heavy for the mechanism. So they get dragged down by gravity and move faster at the bottom.
Thought I could fix that by moving all the markings up a bit, but now they're starting to sag too...
(watch face looks considerably nicer than this app image, check forum thread at http://forums.getpebble.com/discussion/7291/watch-face-gravity for a photo. my kingdom for a good screen shooter!)
Antonio Weather
Description
A modified version of the Futura-Weather App by Niknam.
Two very basic customizations (for me):
-- date field shows numeric "month/day"
-- last successful weather data fetch time at bottom right
1.0 - see above
1.1 - fetch time sync-ed to exact weather update time (instead of 1 min after).
1.121 - remove "@ --:--" on inital startup
Developed on cloudpebble.
Github source code now available.
Note: requires httpebble from the app store.
Added daily min_max temps (Fahrenheit)
Description
Added daily min_max temps (Fahrenheit)
C3PO Watch
Description
I had a watch like this as a kid, and now I kinda do again.
Stargate
Description
Stargate Watchface
May update this one with a better image
Circle Clock
Description
An analog design that uses concentric circles to show hour and minute. Date is shown at the bottom.
Rolex with Date UPDATE
Description
First Attempt at watch face
DATE FORMAT UPDATE
