Show filters

(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 '%pinsch%') 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  
  • word natural

    Description

    Es demanded by you folks. The same as my word watchface only the other way around. Have fun!

    Simple clean and elegant watchface. Just one word is shown which shows you the time.

    The word shows you the hour. The place shows you the minute. If the hour is exactly in the middle its point the hour. Every minute it moves a little bit to the left until it disapears from the screen. When the present hour is exactly half way out of the screen (cut into half), and the next hour is exactly half way in on the screen its exactly half past. The next hour wanders into the middle of the screen. When the time is a.m. its black letters on white background, p.m. means white letters on black background.

    You will not be able to identify each minute, with a little pratice you will get it right on to 5 minutes up and down.

    created by - pinsch
  • word

    Description

    Simple clean and elegant watchface. Just one word is shown which shows you the time.

    The word shows you the hour. The place shows you the minute. If the hour is exactly in the middle its point the hour. Every minute it moves a little bit to the right until it disapears from the screen. When the present hour is exactly half way out of the screen (cut into half), and the next hour is exactly half way in on the screen its exactly half past. The next hour wanders into the middle of the screen. When the time is a.m. its black letters on white background, p.m. means white letters on black background.

    You will not be able to identify each minute, with a little pratice you will get it right on to 5 minutes up and down.

    created by - pinsch

QR code for

Keep track of any updates for this App by signing in

×