(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 '%Shirk%') 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 german watchface resembling a film poster.
Inspired and based on 'Filmplakat' for SDK 1.x
After the watchface becomes visible you can for five seconds:
... flick your wirst to toggle the battery / bluetooth status
... shake your arm up / down to invert the display
Or just use the Pebble-App's config option for even more settings..
See http://vimeo.com/81829802 for a Demo.
Requires SDK2 Beta 5 FW or newer.
DE
Ein deutsches Watchface im Filmplakat-Look.
Inspiriert vom originalen 'Filmplakat' für SDK 1.x
Nachdem das Watchface sichtbar wird kann man für 5 Sekunden:
... das Handgelenk schütteln um den Batterie / Bluetooth-Status ein oder aus zu blenden
... den Arm schnell nach oben / unten bewegen um das Display zu invertieren
Oder einfach die Konfiguration via Pebble-App verwenden...
Hier im Video als Demo: http://vimeo.com/81829802
Es wird die SDK2 Beta 5 FW or neuer benötigt.
----
Dank an lastfuture für das großartige originale Filmplakat ohne welches
dieses Watchface nicht möglich gewesen wäre.
created by - Shirk