(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 '%robertvalik%') 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
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)