Show filters
Filter by:
Sort by :
Go
(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 '%mattmb%') 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  

    • LastTube

    Description

    I wrote this application to find the last tube at nearby stations in London.

    It finds your location and then finds the last tubes on all lines at the three nearest stations. It's pretty experimental, so let me know how you get on with it.

    Disclaimers: I wrote this for fun, it is not endorsed by TFL although it uses their data feeds. Don't trust this, the times may be wrong, especially on Bank Holidays or if engineering works are taking place. Also I can't guarantee the uptime of the API that this app relies on. If it proves popular I might move it to more reliable hosting. If you're interested in the API check out the source code http://github.com/mattmb/python-last-tube and host your own copy if you like.

    Thanks to Elzor for the icon.

    current version: 1
    view source
    InstallDownload Share view more
    QR Code
    created by - mattmb

QR code for

Keep track of any updates for this App by signing in

×

The original concept for mypebblefaces.com was based on RichardG's AWSOME Pebble Concepts site.

Thanks to Otto Greenslade (Chaotic) @chaotictm for the Pebble Watch artwork and many thanks to the Pebble team @pebble for the watch that we all love.

Our Terms and Conditions | Cookies Policy | Any problems contact admin at mypebblefaces dot com

This website has been created,administrated and hosted free of charge by Jason @slayer1551 of NMC Design and Print. NMC Design and Print is a social enterprise working for the benefit of The Neuromuscular Centre @nmcentre Winsford, Cheshire, UK. If you would like contribute to the site please consider making a donation below which will go towards funding the servers as the site grows and any left over will go to the NMC Charity!

For more information please visit www.nmcentre.com