(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 3416,56
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Description
Digital version (SmartStatus-op) available here: http://www.mypebblefaces.com/apps/3027/6714/
This is an analog version of my SmartStatus-op app (http://www.mypebblefaces.com/apps/3027/6714/), itself a modified version of the SmartStatus watch app by Robert Hesse. It only works in conjunction with the Smartwatch+ iOS app available on the Apple App Store: http://itunes.apple.com/us/app/id711357931?mt=8
On screen info:
- time and date (month and day only)
- status information showing the connectivity status with the phone app
- battery indication (icon only, no text)
- current day's weather icon and current temperature
- next day's forecast icon and min/max
- artist and title info/street and city name
- next appointment
Notifications:
- vibes on time of currently displayed appointment
Buttons:
- middle: play/pause on short press, find-my-phone on long press
- up/down: volume up/down
Known issue:
Some times the communication with the phone stops on a timeout error and never recovers. It seems that the BT communication of the watch dies and you need to reset the Pebble. It looks like the Pebble might be resetting once or twice a day while the app is running.
created by - opasco
-
-
-
-
Description
This is a meme watch-face with digital time.
Hope you enjoy it.
Cédric D.
created by - CedricD
-
-
-
-
-
-
-
Description
***WORKS WITH PEBBLE 2.0***
Exactly like the black face but with a white background.
A tribute to Mishawaka, IN's 103.9 The Bear
Made with Pebble Watchface Creator
created by - searay345
-
Description
***WORKS WITH PEBBLE 2.0***
A tribute to 103.9 The Bear in Mishawaka, IN.
Made with Pebble Watchface creator
created by - searay345
-
Description
A simple 12/24hr watchface with bars that grow to represent the time. Hours/minutes are displayed at the top of the bars.
To-do: add animation to the hour transitions.
created by - BobTheMadCow
-
-
Description
Just a LOL-Face with Time :D
Hope you enjoy this simple watchface.
Cédric D.
created by - CedricD
-
Description
Here is a watch face fashioning the I-State Logo for Iowa State University (ISU).
created by - cjwers
-
-
Description
Reloj digital con icono del sindicato al que pertenezco y con calendario con dias y meses en castellano
sdk 2.0
created by - panzer222
-
Description
Simple watchface that displays the time and the current selling value of bitcoin.
The bitcoin value is updated every minute.
Available in EUR and USD versions.
Httpebble app is required on the phone.
created by - JeroenDG
-
Description
Simple watchface that displays the time and the current selling value of bitcoin.
The bitcoin value is updated every minute.
Available in EUR and USD versions.
Httpebble app is required on the phone.
created by - JeroenDG
-
-
Description
This digital watch face has number segments formed using clock hands.
Looks great on pebble watch.
-12Hr format, No Date,.
created by - bmachine
-
Description
A digital watch with large digits using iOS 7 number font.
Watch face looks great on pebble.
12 Hr, No date, Inverted.
created by - bmachine
-
Description
Starring Rainbow Dash from My Little Pont (MLP). Feel free to comment. I wish I could have the animation of Rainbow Dash actually flying, but that is above my knowledge.
created by - cjwers
-
Description
This is my third watch face creation loaded with a bunch of information, yet looks rather simple. It stars Rainbow Dash from My Little Pony (MLP)
created by - cjwers
-
Description
This was the first watch face I've made starring Vinyl Scratch from My Little Pony (MLP).
created by - cjwers
-
-
-
-
Description
This watchface features Mac Man, Champion Macrophage!
Learn more about Macrophages here: http://www.biolegend.com/macrophages
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.
http://www.biolegend.com/
created by - BioLegend
-
Description
This watchface is the cover of The LEGENDeers debut single "Antibodies are so Cool".
Check out the video here: http://youtu.be/WoZgRmjIUA4
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.
http://www.biolegend.com/
created by - BioLegend
-
-
-
-
-
-
-
-
