(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 '%mybucketz%') 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
The mybucketz watch application allows you to view the 10 most recent posts from your Twitter and/or Facebook feed. The application integrates with the free web based social media aggregator http://www.mybucketz.com.
Steps to get started with the mybucketz watch app:
1) Sign-up or Log-In at http://www.mybucketz.com and on the "Connections" screen connect mybucketz to your Facebook and/or Twitter account.
2) Install the httpebble application on your iPhone or Android device (required as a bridge between the mybucketz watch app and mybucketz server).
3) Install the mybucketz watch app (make sure you choose the correct version based on if you have an iPhone or Android device).
4) On the initial opening of the mybucketz watch app you will be displayed your unique Pebble ID. Enter this ID as well as your Pebble feed option into the "Pebble" screen on http://www.mybucketz.com.
5) Close and re-open the mybucketz watch app. It will take a brief moment to connect to the server and will then pass back your Facebook/Twitter feeds! You can scroll up/down through the posts using the top and bottom buttons on the right hand side of the watch. The feed is refreshed each time you open the app.
Check it out and spread the word to help unify your social media! http://www.mybucketz.com
created by - mybucketz
Description
The mybucketz watch application allows you to view the 10 most recent posts from your Twitter and/or Facebook feed. The application integrates with the free web based social media aggregator www.mybucketz.com.
Steps to get started with the mybucketz watch app:
1) Sign-up or Log-In at www.mybucketz.com and on the "Connections" screen connect mybucketz to your Facebook and/or Twitter account.
2) Install the httpebble application on your iPhone or Android device (required as a bridge between the mybucketz watch app and mybucketz server).
3) Install the mybucketz watch app (make sure you choose the correct version based on if you have an iPhone or Android device).
4) On the initial opening of the mybucketz watch app you will be displayed your unique Pebble ID. Enter this ID as well as your Pebble feed option into the "Pebble" screen on www.mybucketz.com.
5) Close and re-open the mybucketz watch app. It will take a brief moment to connect to the server and will then pass back your Facebook/Twitter feeds! You can scroll up/down through the posts using the top and bottom buttons on the right hand side of the watch. The feed is refreshed each time you open the app.
Check it out and spread the word to help unify your social media! www.mybucketz.com
created by - mybucketz
