(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 '%rma2398%') 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
This watch-face is that of a calendar page being displayed with the month at the top of the page. Then the day and date can be found at the very bottom of the page. Finally, there is the time being digitally displayed in-between everything. Thanks for downloading this watch-face, and there are many more to come!
created by - rma2398
-
Description
This watch-face is that of a calendar page being displayed with the month at the top of the page. Then the day and date can be found at the very bottom of the page. Finally, there is the time being digitally displayed in-between everything. Thanks for downloading this watch-face, and there are many more to come!
created by - rma2398
-
Description
This watch-face consists of both the digital and analogue time being displayed. Not only do you have the time being displayed in two different forms but the date is displayed with this watch-face, as well. Thanks for downloading this watch=face and there are many more to come!
created by - rma2398
-
Description
This here is my very own version of the original "Big Time" watch-face. So I do owe credit to the developer of the "Big Time" watch-face. I call it the "comic" watch-face because the font of the numbers is called "comic". Thanks for downloading and there are many more to come!
created by - rma2398
-
Description
This watch-face is of simply a ghostly ghoul with the time being digitally displayed in its mouth. Thanks for downloading and there are many more watch-faces to come!
created by - rma2398
-
Description
This watch-face consists of both the digital and analogue time being displayed. Not only do you have the time being displayed in two different forms but the date is displayed with this watch-face, as well. Thanks for downloading this watch=face and there are many more to come!
created by - rma2398
-
Description
This here is my very own version of the original "Big Time" watch-face. So I do owe credit to the developer of the "Big Time" watch-face. I call it the "Avenir" watch-face because the font of the numbers is called "avenir". Thanks for downloading and there are many more to come!
created by - rma2398
Description
This here is my very own version of the original "Big Time" watch-face. So I do owe credit to the developer of the "Big Time" watch-face. I call it the "Avenir" watch-face because the font of the numbers is called "avenir". Thanks for downloading and there are many more to come!
created by - rma2398
-
Description
This watch-face is that of the top of two sky-scrappers with the time being digitally displayed in-between the two. Like down below if you would also like to see the day and date come to this watch-face, as well. Thanks for downloading this watch-face and there are many more to come!
created by - rma2398
-
Description
This here is my very own version of the original "Big Time" watch-face. So I do owe credit to the developer of the "Big Time" watch-face. I call it the "Silom" watch-face because the font of the numbers is called "silom". Thanks for downloading and there are many more to come!
created by - rma2398
Description
This here is my very own version of the original "Big Time" watch-face. So I do owe credit to the developer of the "Big Time" watch-face. I call it the "Silom" watch-face because the font of the numbers is called "silom". Thanks for downloading and there are many more to come!
created by - rma2398
-
Description
This watch-face is that of a tablet with a analogue clock being displayed on its screen. Thanks for downloading this watch-face and there are many more to come!
created by - rma2398
Description
This watch-face is that of a tablet with a analogue clock being displayed on its screen. Thanks for downloading this watch-face and there are many more to come!
created by - rma2398
-
Description
This watch-face is that of simply of a man's face being portrayed as a digital watch. Then you have the man's nose replaced with the day of the week and the date. Thanks for downloading this watch-face and there are many more to come!
created by - rma2398
Description
This watch-face is that of simply of a man's face being portrayed as a digital watch. Then you have the man's nose replaced with the day of the week and the date. Thanks for downloading this watch-face and there are many more to come!
created by - rma2398
