(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 '%Robert%') 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
Packers G Face
Description
Green Bay Packers "G" logo watch face with digital time and date.
Other Versions
Packers Analog
Description
Analog watch on the Green Bay Packers text logo.
Other Versions
Packers G white
Description
Green Bay Packers "G" logo, white
Other Versions
TextWatch SK
Description
Text Watch in Slovak language - with accented characters.
This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...).
Variant tags:
- N = no hourly vibrations
- C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours)
- U = no animation
- R = reverse colours
v1.0
+ added vibration every hour
+ added more watchface variants
v0.5
+ added animations from PebbleTextWatch
+ created alternative without animations
v0.4
- slightly bigger fonts
v0.3 changes
- fixed declension near number 4 (štyri minút -> štyri minúty)
v0.2 changes:
- new menu icon
- some text changes to limit empty spaces and lines
- basic declension
- now using SDK 1.1
- reduction of needed font characters (the size was cut in a half)
TextWatch SK N
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK U
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK R
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK C
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK NU
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK CR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK NR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK UR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK NUR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
