(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 3920,56
Lobo Time
Description
New Mexico Lobos Watch Face
Everyone's a Lobo, Woof Woof Woof!
Digital watch (12 or 24 hour format) that displays a quick animation every 5 minutes.
Author: Joe Madrigal
Version 1.0
Initial Version
Version 1.1
Changed the font to Savings Bond font. This is close to the official font for UNM as I can find except that I'm not sure how to show in Italic. Anyone know how to do this?
Other Versions
Lobo Time (no animation)
Description
This version has no animation.
Other Versions
Digital+Analog+Date
Description
Simple watchface designed with http://www.watchface-generator.de/ That includes the digital time, an analog clockface and the Day Month Date.
Other Versions
digital+analog+date (inverted)
Description
Same as the original digital+analog+date (v2) but with an inverted color scheme.
Other Versions
Film Strip Watchface
Description
A watch face in the form of a 16mm film strip. Includes both a digital and analog clock as well as full date on bottom. Set life until the next life! Enjoy!
Texto del Año 2013 - Testigos de Jehová
Description
Sencillo watchface con el Texto del Año 2013 de los Testigos de Jehová. Generado con el generador de http://www.watchface-generator.de/
Set Life - Slate
Description
For the film makers out there comes a line of watch faces dedicated to cinema! In this face comes a clapboard background with Date and Time information. Enjoy!
Dual-Face
Description
A watch with dual-face.
Here some other new Watchfaces: http://adf.ly/XJi4y
Here my blog: http://adf.ly/XX5cv
***The Most Famous Watchfaces/Apps with modifications FOR ITALIANS pebblers principally on: http://allpebble.com/devs/Lombax ***
Colorado State University Rams Logo
Description
Thanks to Watch Face Generator http://www.watchface-generator.de/
Seattle Seahawks Black on White
Description
Seattle Seahawks NFL Team Watch face for Pebble
Sweclockers Analogue Digital
Description
Sweclockers Analogue & Digital watchface
Other Versions
Marvin - Hitchhiker's Guide to the Galaxy (seconds=42)
Description
Marvin, the original Paranoid Android with a brain the size of a planet from the classic 80's TV Series, Hitchhiker's Guide to the Galaxy.
Don't Panic.
There are three versions here - this one the seconds remain at, of course, 42.
Other two
One with seconds:
http://www.mypebblefaces.com/apps/7095/6074/
One with no seconds:
http://www.mypebblefaces.com/apps/7095/6077/
Generated using the brilliant watch face generator: http://www.watchface-generator.de
(this is not Marvin from the 2005 movie!)
Marvin - Hitchhiker's Guide to the Galaxy (no seconds)
Description
Marvin, the original Paranoid Android with a brain the size of a planet from the classic 80's TV Series, Hitchhiker's Guide to the Galaxy.
Don't Panic.
There are three versions here - this one has just hours and minutes, no seconds.
Other two -
One with seconds:
http://www.mypebblefaces.com/apps/7095/6074/
One where the seconds remain at, of course, 42:
http://www.mypebblefaces.com/apps/7095/6078/
Generated using the brilliant watch face generator: http://www.watchface-generator.de
(this is not Marvin from the 2005 movie!)
TeslaTime
Description
My first watch face!
Tesla Motors logo as a backdrop, with analog hands. Nothing fancy, but does look kinda cool.
Marvin - Hitchhiker's Guide to the Galaxy
Description
Marvin, the original Paranoid Android with a brain the size of a planet from the classic 80's TV Series, Hitchhiker's Guide to the Galaxy.
Don't Panic.
There are three versions here - this main one has Seconds.
Other two
One with no seconds:
http://www.mypebblefaces.com/apps/7095/6077/
One where the seconds remain at, of course, 42:
http://www.mypebblefaces.com/apps/7095/6078/
Generated using the brilliant watch face generator: http://www.watchface-generator.de
(this is not Marvin from the 2005 movie!)
Classic Simple
Description
Classic and simple quartz analog watchface with day of month.
The Last Of Us
Description
This is Ellie joel watchface from game The Last Of Us.
If you use it please hit like. If you want me to edit let me know.
I am making gaming related watch faces so if you have any request let me know.
Diesel Style White
Description
This one is made in style of the angular Diesel analogue watches.
Created with help of http://www.watchface-generator.de
Diesel Style White with black hands
Description
Black hands for better recognition.
Diesel Style White with black hands and seconds
Description
Black hands for better recognition and seconds added
Diesel Style Black
Description
This one is made in style of the angular Diesel analogue watches.
Created with help of http://www.watchface-generator.de
Other Versions
Diesel Style Black with seconds
Description
Only seconds hand added
Other Versions
Shimakaze
Description
Analog clock with Shimakaze from the popular PC game Kantai Collection
Note: The Japanese text in the original is written right to left in the old style but I wrote it left to right for the benefit of Japanese learners.
Created with the help of Watchface Generator
http://www.watchface-generator.de/
Textual Time
Description
You get a semi-accurate time displayed on the main area of the clock - five past ten, twenty to eleven, etc.
On the top bar you can see the date with day of the week, so you know if it's friday and you can celebrate :)
4TimeZones-Can
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Canada-Vancouver. All offsets are based on Canada-Vancouver time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
4TimeZones-PI
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Philippines. All offsets are based on Philippine time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
4TimeZones-NY
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as New York. All offsets are based on New York time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
4TimeZones
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as California. All offsets are based on California time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
Other Versions
4TimeZones-NY
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as New York. All offsets are based on New York time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
Other Versions
4TimeZones-PI
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Philippines. All offsets are based on Philippine time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
Other Versions
4TimeZones-Can
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Canada-Vancouver. All offsets are based on Canada-Vancouver time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
Other Versions
University of Tennessee Vols
Description
A digital watchface featuring the logo for the University of Tennessee Vols.
Pirate Party
Description
A little mixed mode watchface showing the Pirate Party logo. Weekday names are in German.
Am 22.09. Piraten wählen! :-)
Dots with Date
Description
Clock inspired by DotsAndPebble but with slightly different numbers and the ability to display the date as [day] [month]
Dots with Date (US Date Format)
Description
Same as Dots with Date but with US Date Format [month] [day]
Dots with Date (US Date Format + Leading Zero)
Description
This one has a leading zero when the hours < 10
Dots with Date (Leading Zero)
Description
Adds a leading zero to the hours field if hours < 10
Dots with Date (US Date Format + Leading Zero) (FIX ERROR)
Description
This version is here to make the app accessable again, because the main url leads to en error on this website
Tate -- vertical Japanese
Description
Time, day and weekday in Japanese text (kanji) with vertical writing.
2.0 compatible version:
http://gumroad.com/products/wKEe
TextWatch+date-PIL
Description
This is a language specific TextWatch+date watchface with animation using PILIPINO spelled as spoken. Just for Fun as a modification to original by Paul Pullen.
Other Versions
TextWatch-PNOY+DMDY
Description
This is a language specific TextWatch+date watchface with animation using PILIPINO spelled as spoken. Just for Fun as a modification to original by Paul Pullen. This version includes the Day, Month Year and Date. Only addition is Year
Other Versions
Gundam Unicorn
Description
A simple weekday, date, and time with the main mobile suit from Gundam Unicorn as the background.
Signa un VOT per la Independència - Digital
Description
Rellotge digital 24h amb data de Signa un VOT per la Independència
Digital 24h watch with date for Sign a Vote for the Independence of Catalonia background.
http://einesxestat.cat/
Signa un VOT per la Independència - Analògic
Description
Rellotge analògic amb data de Signa un VOT per la Independència de Catalunya
Analogue watch with date for Sign a Vote for the Independence of Catalonia background.
http://einesxestat.cat/
Xbox One Countdown
Description
Counts down to the release of the Xbox One at midnight on November 22, 2013.
- 12 or 24 hour mode supported.
- Reflects the countdown to Xbox One release in your time zone!
- KNOWN BUG: Time doesn't account for Daylight Savings Time. Actual countdown is one hour short until daylight savings time ends, at which point it will be accurate once your Pebble updates.
Coming soon:
- Daylight Savings Time fix (if not too complicated) - low priority
- Source code.
Marius Machts English Black Design
Description
A design with english week- and monthname in shortform.
Design by Marius Machts
http://www.facebook.com/MariusMachtsPhotographie
Marius Machts English White Design
Description
A design with english week- and monthname in shortform. Design by Marius Machts http://www.facebook.com/MariusMachtsPhotographie
Marius Machts German Black Design
Description
A design with german week- and monthname in shortform.
Design by Marius Machts
http://www.facebook.com/MariusMachtsPhotographie
Marius Machts German White Design
Description
A design with german week- and monthname in shortform. Design by Marius Machts https://www.facebook.com/MariusMachtsPhotographie
The Needle
Description
This is a variation on the Classic Marty Reisman face. I wasn't really happy with the first version because I don't think it was clear that the clock was now the "ball" in the photo. Also, I though that I should have included Marty's nickname, "The Needle." So this variation makes it more clear that the face is the table tennis ball and I've added the nickname. Unfortunately, the clock isn't as easy to read. That's why I didn't update the old face, but decided to add this as a third Reisman watchface.
GTA V
Description
This is GTA 5 watchface.
if you use it please hit like and leave a comment :-)
Attack on Titan: Scouting Legion Emblem
Description
Clock with Attack on Titan Scouting Legion emblem and text.
I also made a version of this watch face with no text, and just the emblem.
Created with help of http://www.watchface-generator.de
Attack on Titan: Scouting Legion Emblem (no text)
Description
No text version of the Attack on Titan: Scouting Legion Emblem watch face Made with help from Watchface Generator http://www.watchface-generator.de/
Very Fuzzy (sdk 1)
Description
It's eleven ... ish. The hours are still given as numbers, but everything else is "five or so", "past four", "almost ten" etc. It's how I'd describe time and I'm British, so it may not fit for others.
So from five to six we'd go through:
five
five ish
five or so
past five
well past five
almost half five
half five
half five ish
half five or so
past half five
getting on for six
almost six
six
This is the version for SDK 1 - for SDK 2 see http://www.mypebblefaces.com/apps/8300/8408/
Fem Via Catalana
Description
Rellotge analògic Fem Via Catalana
Let's do the Catalan Way Analogue watch.
Catalunya Estelada Rodona
Description
Rellotge analògic amb estelada rodona
Analogue watch with 'estelada'.