(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 '%ocuser01%') 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 is the Tagalog version of WordSquare. Similar to all WordSquare versions, the time only refreshes every 5 minutes. Image is a posterized picture.
created by - ocuser01
-
Description
This is a french version of the WordSquare watchface. As with all the WordSquare watchfaces, time changes only every 5 mins. Image is a posterized picture.
created by - ocuser01
-
Description
This is a countdown app (vs watchface) for Pasko - Philippines. It can be accessed through applications and exits through back button. An update was made to change the target hour to 0 hr instead of 12 hr.
created by - ocuser01
-
Description
This is a cross-breed of Timely Calendar and Text in French with a twist on Month and Year. The hour is combined on the first line and set as "heure(s)" so it is applicable to "une heure" or "deux hueres" and so on.
created by - ocuser01
-
Description
This is a cross-breed between Text and Timely Calendar with a twist of Month and Year right aligned on top of Calendar. This is the English version which was updated to increase the character size limitation on line 2.
created by - ocuser01
Description
Feeling Patriotic as an American, this version includes the American Flag on top of the Year.
created by - ocuser01
-
Description
This watchface is a cross-breed of the Timely calendar and Text with a twist of the month and year aligned to the right on top of the Calendar - in Pilipino (spelled as spoken). This version has the original text format in 3 lines.
created by - ocuser01
Description
Feeling patriotic as a Filipino. This version includes the Philippine Flag Sun and Stars.
created by - ocuser01
-
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Canada-Vancouver. All offsets are based on Canada-Vancouver time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
-
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Philippines. All offsets are based on Philippine time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
-
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as New York. All offsets are based on New York time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
-
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as California. All offsets are based on California time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as New York. All offsets are based on New York time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Philippines. All offsets are based on Philippine time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
Description
A 4 time zone watchface including California, New York, Pilipinas and Canada-Vancouver with region base as Canada-Vancouver. All offsets are based on Canada-Vancouver time. Thanks to Ryan Hutchinson for base codes. Black on white are day times while white on black are night times.
created by - ocuser01
-
Description
This is a language specific TextWatch+date watchface with animation using PILIPINO spelled as spoken. Just for Fun as a modification to original by Paul Pullen.
created by - ocuser01
Description
This is a language specific TextWatch+date watchface with animation using PILIPINO spelled as spoken. Just for Fun as a modification to original by Paul Pullen.
This version includes the Day, Month Year and Date. Only addition is Year
created by - ocuser01
