(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 (ak_pebble_authorName LIKE '%Jennik%') 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 0,56
-
-
Description
Does this watchface resemble some very expensive swiss watches? Not a coincidence :)
This sub-version includes day number.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
Description
Not accidentally this watchface resembles one of the most beautiful and expensive watches any aviation enthusiast would love to have. So, here are them ;)
This watch face is compatible with Pabble SDK v2.0 only.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
Description
Not accidentally this watchface resembles one of the most beautiful and expensive watches any aviation enthusiast would love to have. So, here are them ;)
This watch face is compatible with Pabble SDK v2.0 only.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
Description
Hi there! Newer version of my altimeter style watchface arrives. This time filling whole display of your pebble and therefore looking much more like normal watch actually. However, those nice details of numerical altitude (time) and air pressure settings (date) remained. Whole date is being displayed on the bottom part and with SDK v2 now come battery and bluetooth indicators. Enjoy! :)
Created with help of http://www.watchface-generator.de
created by - Jennik
-
Description
This is the next contribution to my aircraft-themed watch faces. It mimics classic vertical card precision compass found on the panel of most of aircraft. While main NESW letters stood on the face, digits has been converted into time format because of better time readability.
This watch face is compatible with Pabble SDK v2.0 only.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
Description
This is the next contribution to my aircraft-themed watch faces. It mimics classic vertical card precision compass found on the panel of most of aircraft. While main NESW letters stood on the face, digits has been converted into time format because of better time readability.
Pebble SDK v2.0 features:
- Bluetooth connection indication with vibration when lost
- Battery status indicator
This watch face is compatible with Pabble SDK v2.0 only.
Generated by: http://www.watchface-generator.de
created by - Jennik
-
-
-
-
-
Description
This time we move even more into the past – year 1987 when the second version of Windows was released. Personally, I like these more then the latter in Win 3+.
For those who remember. Enjoy!
Created with help of http://www.watchface-generator.de
created by - Jennik
-
Description
This watchface has been made in style of the famous Franck Müller analogue watches.
This new version features smoother roman numbers, better inner circles and finally, the date number at the bottom.
Created with help of http://www.watchface-generator.de
created by - Jennik
-
Description
This watchface has been made in style of the famous Franck Müller analogue watches.
New version features more smooth roman numbers and inner circles.
Also, this version has seconds hand. Thanks to it, this watchface might deplete your Pebble battery much sooner then the minute–only version.
Created with help of http://www.watchface-generator.de
created by - Jennik
-
Description
Year 1989 – 4th generation of Flight simulator game arrived on Mac. Enjoy the detail of instrument panel reproduced 1:1 in pebble display pixels. There are watches in the up right altimeter gauge actually. :)
created by - Jennik
-
-
-
-
Description
White version
Created with help of http://www.watchface-generator.de
created by - Jennik
-
-
Description
This is a classic aircraft panel altimeter gauge changed to 12 clock layout. Digital time situated in place of numeric altitude value, date at the bottom in place of air pressure HG mm number. There might be more versions coming shortly, stay tuned!
Created with help of http://www.watchface-generator.de
created by - Jennik
Description
This is a classic aircraft panel altimeter gauge changed to 12 clock layout. Digital time situated in place of numeric altitude value, date at the bottom in place of air pressure HG mm number. There might be more versions coming shortly, stay tuned!
Created with help of http://www.watchface-generator.de
created by - Jennik
-
-
-
-
-
-
