Show filters

(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 '%aadebe%') 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  
  • Too Much Info

    Description

    ---
    version history
    1.1 - decreased (just a little) the TIME font to fit PM notification all the time...
    1.0 - initial release
    ---

    Too Much Info

    Main thing of course is the actual... TIME

    But if there's need for some more info, this one also provides:
    - Day of the week, short named (eg. Wed)
    - Date with short name for Month (eg. 01 May 2013)
    - TIME (incl. 12h and 24h support)
    - Year (eg. 2013)
    - Week number (eg. W:18)
    - Day number (eg. D:121)

    See if you like it, let me know when you like it changed or tweaked...

    created by - aadebe
  • Jump Ball

    Description

    Jump Ball

    Never lose track of whose turn it is, to have the Possession with the next Jump Ball!

    The alternating Possession Arrow rule went into effect in college basketball in 1981 as a replacement for the Jump Ball...

    Most competitions other than the NBA (entire game) and the UAAP (in the final two minutes of a game and overtime in UAAP only) use the alternating possession rule to settle all jump ball situations after the opening tip. This uses a Possession Arrow on the scorekeeper's table. Whenever such a jump ball situation occurs, the team whose basket that the Possession Arrow is currently pointing to gets the ball. The arrow then swaps to point to the other team. At the start of the game, the arrow points to the team that lost the opening tip.
    ---
    see also http://en.wikipedia.org/wiki/Jump_ball

    created by - aadebe

QR code for

Keep track of any updates for this App by signing in

×