(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 '%newsome%') 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
This is digital face with two big music notes at the top. It has a dial-type battery indicator in the upper right hand corner and the time in the bottom center with the day/month/date/year underneath. A clean face for any musician or music lover.
created by - newsome
-
Description
This is an Atlanta Falcons helmet logo analog face. It has a battery indicator in the upper right hand corner and a bluetooth connection indicator in the upper left hand corner. At the bottom center is the digital time with the month/date underneath. A must-have for any Falcons fan!
created by - newsome
-
Description
This is an analog Atlanta Falcons logo using the text logo. It has a battery indicator in the upper right hand corner, a bluetooth connection indicator in the upper left hand corner, and the month/date on the "5" of the face. A great face for an Falcons fan!
created by - newsome
-
Description
This is a Mickey Mouse outline logo analog face. It has a battery indicator in the upper right hand corner and a bluetooth connection indicator in the upper left hand corner. At the bottom center is the month/date.
created by - newsome
-
Description
"I find your like of time disturbing." This is a Darth Vader face with both analog hands and digital time in the lower left hand corner. The month/date is in the lower left hand corner, the battery indicator in the upper right hand, and the bluetooth connection status in the upper left hand corner. Lots of information, but still a clean face for all Star Wars fans!
created by - newsome
-
Description
This is an Atlanta Braves logo analog face with the tomahawk as the line in the "A". It has a battery indicator in the upper right hand corner and a bluetooth connection indicator in the upper left hand corner. At the bottom center is the month/date.
created by - newsome
-
Description
What time is it? It's *always* time to jam! This is a white watch face with the digital time, date, and a battery meter.
created by - newsome
-
Description
A nice musical watchface featuring a saxophone player and a music line. Includes digital time with day/date and a battery meter.
created by - newsome
-
Description
A nice clean image of an orchestra conductor with analog hands over the top and the date in the lower right hand corner.
created by - newsome
