(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 '%Samalander%') 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
Big H is a watchface that shows the hour and minutes in big numbers, the weekday with the dates of 3 days before and after, the full date and a seconds indicator with minimal battery impact.
Hours in big numbers in the top center (12-hour & 24-hour formats)Minutes in big numbers in the bottom centerWeekday indicator column on the left side of the screen7 numbers shown; top slot is for Sunday, last slot is SaturdayCurrent date is in reverse color (black on white) in the appropriate slot for its day3 days before and after the current day are shownArrow drawing indicates the break between the past 3 days and the future 3 daysFull date is written in the rightmost columnIf watch is set to 12-hour format, the date will show as MM-DD-YYYYOtherwise, the date will be formatted as YYYY-MM-DDSeconds indicator is in the center, between the hour and minutesEmpty bar is 0 secondsFull bar is 59 secondsIndicators are present to indicate 15s, 30s and 45sSeconds indicator only uses 2 lines so very battery efficient but still visibleIf the watch is in 12-hour format:AM is indicated by a small arrow pointing up over the center of the seconds barPM is indicated by the small arrow pointing down under the center of the seconds bar
Many settings are now available to customize this watchface when compiling. See the alternate versions and the description at the source-code link for more details. If you can't compile yourself and want a specific combo of settings, let me know in the comments and I'll see if I can help. :)
Licensed under the LGPLv3.
created by - Samalander
Description
Alternate version of the "Big H" watchface that removes the seconds indicator. It therefore only updates once a minute to eke out more battery life.
created by - Samalander
Description
Alternate version of the "Big H" watchface that shows the leading zero on the hour display.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the weekday display so that Monday comes at the top of the column and Sunday is at the bottom.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the weekday display for the spelled-out weekday names in English.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the weekday display for the spelled-out weekday names in French.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the weekday display for the spelled-out weekday names in Spanish.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the date format to always be "YYYY-MM-DD" regardless of the 24-hour setting.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the date format to always be "MM/DD/YYYY" regardless of the 24-hour setting.
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the date format to always be "DD-MM-YYYY".
created by - Samalander
Description
Alternate version of the "Big H" watchface that changes the date format to always be "MM/DD/YYYY" and displays the weekdays in English.
created by - Samalander
