(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 '%mdonders%') 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
A more granular & accurate version of the original Holiday watch.
Shows "ish" time every 30 minutes when the exact time is not really much of your concern (ie. when you are on vacation).
created by - mdonders
-
Description
This watch app will easily allow you to find the closest & cheapest gas station to your current location.
Launch the app and it will start searching for the closest gas station - when found it will display the station name, distance & direction from your current location and regular, premium and diesel prices (if applicable).
It will then start to search for the cheapest gas station in a 10 mile radius and display the same information on the bottom half of the watch.
Note: Requires httpebble to be installed on your device. Please choose the watch app that applies to your phone.
Android users:
- Download and install 'Pebble Connect' from Google Play:
http://play.google.com/store/apps/details?id=com.lukekorth.httpebble
iOS users:
- Download and install 'httpebble' from the App Store: http://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8
created by - mdonders
Description
This watch app will easily allow you to find the closest & cheapest gas station to your current location.
Launch the app and it will start searching for the closest gas station - when found it will display the station name, distance & direction from your current location and regular, premium and diesel prices (if applicable).
It will then start to search for the cheapest gas station in a 10 mile radius and display the same information on the bottom half of the watch.
Note: Requires httpebble to be installed on your device. Please choose the watch app that applies to your phone.
This watch app will easily allow you to find the closest & cheapest gas station to your current location.
Launch the app and it will start searching for the closest gas station - when found it will display the station name, distance & direction from your current location and regular, premium and diesel prices (if applicable).
It will then start to search for the cheapest gas station in a 10 mile radius and display the same information on the bottom half of the watch.
Note: Requires httpebble to be installed on your device. Please choose the watch app that applies to your phone.
Android users:
- Download and install 'Pebble Connect' from Google Play:
https://play.google.com/store/apps/details?id=com.lukekorth.httpebble
iOS users:
- Download and install 'httpebble' from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8
created by - mdonders
Description
This watch app will easily allow you to find the closest & cheapest gas station to your current location.
Launch the app and it will start searching for the closest gas station - when found it will display the station name, distance & direction from your current location and regular, premium and diesel prices (if applicable).
It will then start to search for the cheapest gas station in a 10 mile radius and display the same information on the bottom half of the watch.
Note: Requires httpebble to be installed on your device. Please choose the watch app that applies to your phone.
Android users:
- Download and install 'Pebble Connect' from Google Play:
https://play.google.com/store/apps/details?id=com.lukekorth.httpebble
iOS users:
- Download and install 'httpebble' from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8
created by - mdonders
Description
This watch app will easily allow you to find the closest & cheapest gas station to your current location.
Launch the app and it will start searching for the closest gas station - when found it will display the station name, distance & direction from your current location and regular, premium and diesel prices (if applicable).
It will then start to search for the cheapest gas station in a 10 mile radius and display the same information on the bottom half of the watch.
Note: Requires httpebble to be installed on your device. Please choose the watch app that applies to your phone.
Android users:
- Download and install 'Pebble Connect' from Google Play:
https://play.google.com/store/apps/details?id=com.lukekorth.httpebble
iOS users:
- Download and install 'httpebble' from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8
created by - mdonders
