(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 '%AgentSquirrel%') 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
A second style of the stylized version of Vytis with the word Lietuva (Lithuania) above the Vytis. This one shows the markers around the analog clock.
Includes both Analog and Digital time as well as the date. Also shows your battery and bluetooth status.
The Vytis, which means "hero", is a knight mounted on a charging horse. Its intent was to not only honor the Lithuanian nobility (who could easily identify itself with a knighted rider), but also the common Lithuanian soldier who did well in battle. Vytis is now Lithuania's national emblem.
created by - AgentSquirrel
-
Description
A stylized version of Vytis with the word Lietuva (Lithuania) above the Vytis.
Includes both Analog and Digital time as well as the date. Also shows your battery and bluetooth status.
The Vytis, which means "hero", is a knight mounted on a charging horse. Its intent was to not only honor the Lithuanian nobility (who could easily identify itself with a knighted rider), but also the common Lithuanian soldier who did well in battle. Vytis is now Lithuania's national emblem.
created by - AgentSquirrel
-
Description
A second edition of my stylized version of Vytis.
Includes Analog time as well as the date. Also shows your battery and bluetooth status.
The Vytis, which means "hero", is a knight mounted on a charging horse. Its intent was to not only honor the Lithuanian nobility (who could easily identify itself with a knighted rider), but also the common Lithuanian soldier who did well in battle. Vytis is now Lithuania's national emblem.
created by - AgentSquirrel
-
Description
A stylized version of Vytis.
Includes both Analog and Digital time as well as the date. Also shows your battery and bluetooth status.
The Vytis, which means "hero", is a knight mounted on a charging horse. Its intent was to not only honor the Lithuanian nobility (who could easily identify itself with a knighted rider), but also the common Lithuanian soldier who did well in battle. Vytis is now Lithuania's national emblem.
created by - AgentSquirrel
-
Description
A watchface for fans of Sasquatch (Bigfoot). This is an analog face with digital time and date at the bottom. This has been designed to work with the Pebble SDK 2.0.
If you like it, please give it a favorite mark and let me know via Twitter @Agent_Squirrel. If you have any suggestions, please let me know via Twitter.
created by - AgentSquirrel
-
Description
Zombie Emergency Response Team analog watchface for Pebble SDK 2.0. I can't believe I hadn't made this earlier. It is my favorite Zombie Response image. I can't remember where I found it.
If you like it, please give it a favorite mark and let me know via Twitter @Agent_Squirrel. If you have any suggestions, please let me know via Twitter.
created by - AgentSquirrel
-
Description
An update to my Minion Time watchface for the Pebble. Minion is pointing to the time and date. This has been updated to work with the Pebble SDK 2.0.
If you like it, please give it a favorite mark and let me know via Twitter @Agent_Squirrel. If you have any suggestions, please let me know via Twitter.
created by - AgentSquirrel
-
Description
An update to my Minion Time's Up watchface for the Pebble. Minion is pointing to the time and date. This has been updated to work with the Pebble SDK 2.0.
If you like it, please give it a favorite mark and let me know via Twitter @Agent_Squirrel. If you have any suggestions, please let me know via Twitter.
created by - AgentSquirrel
-
-
-
-
