(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 784,56
The Amazing Spider-Man 2
Description
TASM 2 watchface, for all you spidey lovers out there! I will do custom watchfaces! Just comment what you want, and I'll upload it.
Swiss White sdk 2 (no configuration)
Description
- Base on Swiss by zalewszczak
- Run on SDK 2.0
- No configuration required
- make date easy to read
- improve designing, hour, minute, second show current time exactly
- optimized code, removed many line code.
- vibration hour from 8am to 11pm
- version has second hand. If you want save pebble battery, this one is removed second hand: http://www.mypebblefaces.com/apps/23794/10840/10841/
http://tigerkidshop.com
Swiss White sdk 2 (no second hand - no configuration)
Description
- Base on Swiss by zalewszczak - Run on SDK 2.0 - No configuration required - make date easy to read - improve designing, hour, minute, second show current time exactly - optimized code, removed many line code. - vibration hour from 8am to 11pm - version has no second hand. If you want second hand: http://www.mypebblefaces.com/apps/23794/10840/ http://tigerkidshop.com
HiDensity
Description
- time
- day
- date (European format)
- 12h / 24h format
Other Versions
HiDensity US
Description
- time - day - date (US format) - 12h / 24h format
Other Versions
HiDensity Plus
Description
My first watchface.
It shows the time, seconds, day, date (European format).
Supports 12h/24h time format.
Other Versions
HiDensity Plus US
Description
- time - seconds - day - date (US format) - 12h / 24h format
Other Versions
TeCH Watch
Description
This was created using the awesome watch face generator, I just wanted something that looked a little different and a bit nerdy...
It does have a working Bluetooth connection and Battery indicator as well as the usual time and date.
If anyone knows how to do animation I would love to animate some of the "led's" on the side.
Beer Time
Description
Screen saver you can use not only to save you battery but also to let others know that you do not care about time because it is beer time!
Shmu IIO M White
Description
Made with http://www.watchface-generator.de
Other Versions
Shmu IIO S White
Description
Made with www.watchface-generator.de
Other Versions
Shmu IIO M Black
Description
Made with http://www.watchface-generator.de
Other Versions
Shmu IIO S Black
Description
Made with www.watchface-generator.de
Other Versions
Triforce
Description
Just a pic of the Triforce. I really wanted it for myself so I made it. I hope you enjoy it too.
WatchPony
Description
Yet another generated My Little Pony watch face, with analog clock Mark, digital time and date.
Made using the Watchface Generator (http://www.watchface-generator.de/index.php). Doctor Whooves vector by TheEvilFlashAnimator (http://theevilflashanimator.deviantart.com/).
LV2
Description
Basic Louis Vouitton watchface with Analog/Digital clock! Enjoy
Maurice White sdk 2 (no configuration)
Description
- Base on Maurice by zalewszczak
- Run on SDK 2.0
- No configuration required
- make date easy to read
http://tigerkidshop.com
Boss Invert sdk 2 (no configuration)
Description
- Base on Boss by zalewszczak
- Adjust a little bit
- Run on SDK 2.0
- No configuration required
- make date easy to read
http://tigerkidshop.com
Boss White sdk 2 (no configuration)
Description
- Base on Boss by zalewszczak
- Adjust a little bit
- Run on SDK 2.0
- No configuration required
- make date easy to read
http://tigerkidshop.com
Maurice Black sdk 2 (no configuration)
Description
- Base on Maurice by zalewszczak
- Run on SDK 2.0
- No configuration required
- make date easy to read
http://tigerkidshop.com
Circuit
Description
An elegent watchface that displays 24h format time, day, date, battery status, and bluethooth connection.
Doctor Whooves - Minimalistic
Description
An outline of Doctor Whooves aka Time Turner, by MrFugums on DeviantArt.
Created using Watchface Generator.
My Little Pony and all characters therein are copyright of Hasbro Entertainment.
(how appropriate right? with the hourglass added in ^.^ and all)
V2
Samus Aran
Description
Everyone's favourite bounty hunter! Now on your wrist in all her glory!
Past Events
Description
Ever want to quickly record something so that you can remember it for later? Look no further, Past Events is here to save you.
Enter 5 characters, and it saves the time and date of recording along with that string so you can look at it later and remember what you wanted to remember!
Bundled with animations and settings, Past Events is the app for anyone looking to jot something down.
Horlogo_d
Description
Esperanto text watch with date and day of week.
Based on http://github.com/dearmash/PebbleTextWatchWithDate
Updated fonts (with Esperanto special characters) ,watch battery status and alert on bluetooth disconnect.
Horlogo
Description
Esperanto version of the Text Watch.
Based on Pebble Text Watch by Wearwip:
http://github.com/wearewip/PebbleTextWatch
(My contribution is simple text translation from English to Esperanto)
Kansas State(Analog)
Description
Analog clock with large Power Cat. Essential for any K-State fan.
Kansas State(Digital)
Description
Digital clock with large Power Cat. Essential for any K-State fan.
The Tandem - PerCP/Cy5.5
Description
Last season's winners of The Tandem. PerCP wooed Cy5.5 and the couple have been together ever since. They recently appeared on the current season of The Tandem in Episode 3. They gave PE useful advice as to what he should look for in a tandem partnership.
http://www.biolegend.com/the_tandem
BioLegend develops world-class, cutting-edge antibodies and reagents for biomedical research, manufactured in our state-of-the-art facility in San Diego, CA. Our mission is to accelerate research and discovery by providing the highest quality products at an outstanding value, along with superior customer service and technical support.
Our product areas include cell immunophenotyping, cytokines and chemokines, adhesion, cancer research, T regulatory cells, stem cells, innate immunity, cell-cycle analysis, apoptosis, and modification-specific antibodies. All of BioLegend's reagents are supported by superior customer service and come with a quality guarantee. Our aggressive product development program, through technology licensing, collaborations, and internal hybridoma development, produces strategic reagents for use in a variety of applications including:
Flow cytometry and mass cytometry
ELISA and ELISPOT
Immunoprecipitation and ChIP
Western blotting
Immunofluorescence microscopy
Immunohistochemistry
In vitro or in vivo functional assays.
BioLegend offers the broadest selection of fluorochrome conjugates for multi-color flow cytometry. With an experienced biochemistry team, BioLegend is well positioned to offer a wide range of custom conjugation services to meet our customers' specific needs.
Incorporated in June 2002, BioLegend is located in San Diego, in the midst of one of the nation’s largest and fastest growing biotechnology clusters.
The Tandem - Cy5.5
Description
Cy5.5 was the fluor on last season's The Tandem. She was wooed by APC, PE (this season's fluor) and ultimately fell in love with PerCP. The wo are still together and still very much in love. She recently appeared with PerCP in Episode 3 of this season of The Tandem.
http://www.biolegend.com/the_tandem
BioLegend develops world-class, cutting-edge antibodies and reagents for biomedical research, manufactured in our state-of-the-art facility in San Diego, CA. Our mission is to accelerate research and discovery by providing the highest quality products at an outstanding value, along with superior customer service and technical support.
Our product areas include cell immunophenotyping, cytokines and chemokines, adhesion, cancer research, T regulatory cells, stem cells, innate immunity, cell-cycle analysis, apoptosis, and modification-specific antibodies. All of BioLegend's reagents are supported by superior customer service and come with a quality guarantee. Our aggressive product development program, through technology licensing, collaborations, and internal hybridoma development, produces strategic reagents for use in a variety of applications including:
Flow cytometry and mass cytometry
ELISA and ELISPOT
Immunoprecipitation and ChIP
Western blotting
Immunofluorescence microscopy
Immunohistochemistry
In vitro or in vivo functional assays.
BioLegend offers the broadest selection of fluorochrome conjugates for multi-color flow cytometry. With an experienced biochemistry team, BioLegend is well positioned to offer a wide range of custom conjugation services to meet our customers' specific needs.
Incorporated in June 2002, BioLegend is located in San Diego, in the midst of one of the nation’s largest and fastest growing biotechnology clusters.
The Tandem - PerCP
Description
PerCP was the winner of the previous season of The Tandem. He wooed Cy5.5 to beat out other fluors such as APC and this seasons' contestant PE. The two are still together and recently appeared in Episode 3 of the current season of The Tandem.
http://www.biolegend.com/the_tandem
BioLegend develops world-class, cutting-edge antibodies and reagents for biomedical research, manufactured in our state-of-the-art facility in San Diego, CA. Our mission is to accelerate research and discovery by providing the highest quality products at an outstanding value, along with superior customer service and technical support.
Our product areas include cell immunophenotyping, cytokines and chemokines, adhesion, cancer research, T regulatory cells, stem cells, innate immunity, cell-cycle analysis, apoptosis, and modification-specific antibodies. All of BioLegend's reagents are supported by superior customer service and come with a quality guarantee. Our aggressive product development program, through technology licensing, collaborations, and internal hybridoma development, produces strategic reagents for use in a variety of applications including:
Flow cytometry and mass cytometry
ELISA and ELISPOT
Immunoprecipitation and ChIP
Western blotting
Immunofluorescence microscopy
Immunohistochemistry
In vitro or in vivo functional assays.
BioLegend offers the broadest selection of fluorochrome conjugates for multi-color flow cytometry. With an experienced biochemistry team, BioLegend is well positioned to offer a wide range of custom conjugation services to meet our customers' specific needs.
Incorporated in June 2002, BioLegend is located in San Diego, in the midst of one of the nation’s largest and fastest growing biotechnology clusters.
ALX Modern Watch EN
Description
Just what you need ...
You can switch between colors.
You can choose a personal location instead of using your GPS.
The weather is updated every hour (by default), so you keep a very great battery life. But you can change it between 10 minutes to 1 hour.
ALX Modern Montre FR
Description
Simple, sobre, juste ce qu'il faut.
Alterne toutes les minutes entre date et ville.
Choix de la couleur de l'interface de la montre Noir/Blanc ou Blanc/Noir.
Possibilité de choisir une ville fixe pour les données météorologiques au lieu d'utiliser les données GPS du téléphone.
La météo est mis à jour toutes les heures (par défaut) pour conserver une très bonne autonomie. Ce réglage est modifiable entre 10 minutes et 1 heure.
SEVILLA F.C.
Description
Un guiño a mi equipo. Nada especial solo es precioso. Para decirles la hora exacta en la que los mandamos al mamaero!!
Atletico de Madrid
Description
Para los colchoneros y seguidores del Atletico de Madrid aquí teneis vuestro WatchFace para el Pebble.
Real Madrid
Description
Para los merengues y seguidores del Real Madrid aquí tienen su watchface para el Pebble.
Futbol Club Barcelona
Description
Para los cules y seguidores del Barça aquí tienen su WatchFace para el Pebble.
Weathercube
Description
Say Hello to Weathercube, the sexiest weather and calendar app available for your Pebble.
- 26 icons for every weathertype
- Your next appointment at the flick of your wrist
- Updates every 15 minutes
- 12hr and 24hr clock support
Requires the award winning Weathercube iOS app. Get it now for free! http://app.weathercube.com
More details here: http://weathercube.com/pebble/
