(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 '%SuperBen%') 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 black and white image of the left side of the Union Flag, with a big digital clock in the middle, and date at the bottom.
Features a pebble battery indicator and bluetooth connection status icon on the screen.
Watchface will invert colours when bluetooth connection is lost.
For Pebble 2.0 software.
created by - SuperBen
-
Description
I pity the fool who doesn't use this watchface.
featuring a silhouette of Mr. T's famous hair and facial hair, with a digital clock within his face.
created by - SuperBen
-
Description
Featuring the original Gameboy design with a digital clock in the Gameboy's screen
created by - SuperBen
-
-
Description
Plain black and white stripes, with full time and full date within the stripes.
Stylish, subtle and straight-forward.
created by - SuperBen
-
Description
A black and white image of the left side of the Union Flag, with a big digital clock in the middle, and date at the bottom.
created by - SuperBen
-
-
Description
Featuring the logo of the British and Irish Lions rugby side, with a digital clock and day/month at the bottom of the watchface.
created by - SuperBen
-
Description
Manchester United watchface, featuring the Red Devil logo and a large digital clock on a white background.
created by - SuperBen
-
Description
Such a wasted talent, a future MotoGP star, who's bright career was ended on the track.
Ciao Marco.
created by - SuperBen
-
-
-
-
-
Description
Famous Stars and Straps logo with the ska-check pattern, a clock on the right hand side.
created by - SuperBen
-
Description
Featuring a plain picture of Ralph Wiggum from the TV series 'The Simpsons', with the time on his belly.
created by - SuperBen
-
Description
Featuring the loveable little penguin Pingu, with the time in his his belly.
created by - SuperBen
-
Description
Featuring the logo of Canadian band Alexisonfire prominantly in the centre, with the time in the bottom left, and the day in the bottom right.
created by - SuperBen
-
Description
I'm Ron Burgundy?
Celebrate the release of Anchorman 2, or just marvel at the wonder of Ron Burgundy with this watchface.
created by - SuperBen
-
Description
Black details on a plain white background, the time is featured in the top half, and Rossi's VR 46 logo featured on the bottom.
If anyone's interested I can make an inverted version (White image on a black background)
created by - SuperBen
-
Description
Knowing me, knowing you, A-ha!
A watchface featuring North Norfolk's finest radio DJ, Alan Partridge.
A digital clock is at the bottom right of this face.
created by - SuperBen
-
Description
Featuring an image of hip-hop producer and rapper Andre Young, aka Dr. Dre.
The simple time is featured in the bottom right hand corner
created by - SuperBen
-
Description
A simple design, featuring the Chicago 3-piece's skull/heart logo, and the time at the top of the face.
White imagery on a black background.
Updated version sees the logo drop a little bit lower, and clock size grow larger.
created by - SuperBen
-
Description
A subtle but definite tribute to England's greatest football club, Manchester United.
A white outline of United's famous red devil features in the centre of a black background, with the time at the top of the watch-face, and the day and date in the correct English format is included at the bottom.
If there's much interest for an inverted version of this (black time and image, white background) I'll upload that too, let me know if you'd be interested in that.
created by - SuperBen
