(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 '%thesk8ingtoad%') 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
-Simple, minimalist, animated watch face
-Includes watch face for both Pebble Time (anti-aliasing) and Pebble/Pebble Steel (without AA)
-Based on ks-clock-face for Pebble Time by Matthew Tole
-Thanks to Pebble Forum user, Colin01 for aplite line width code
-I don't yet own a Pebble, so if you like it and want to contribute to my Pebble fund, feel free to donate BTC to 18pGbZcP89wzcaibHQ1QyRUHR7G6JU4wEa
-If you'd like the dial, but would like an image in the background, comment below and I'll see what I can do!
-Enjoy!
created by - thesk8ingtoad
-
Description
-Simple, animated watch face featuring the official seal of the University of Southern California, USC. Go Trojans!
-Includes watch face for both Pebble Time (color face) and Pebble/Pebble Steel (B&W)
-Based on ks-clock-face for Pebble Time by Matthew Tole
-Thanks to Pebble Forum user, Colin01 for aplite line width code
-I don't yet own a Pebble, so if you like it and want to contribute to my Pebble fund, feel free to donate BTC to 18pGbZcP89wzcaibHQ1QyRUHR7G6JU4wEa
-Let me know in the comments if you'd like a version with another image in the background
created by - thesk8ingtoad