SELECT 
 SUM(totalhands) AS HANDS,
 100.0*SUM(vpiphands)/SUM(totalhands) AS VPIP,
 100.0*SUM(pfrhands)/SUM(totalhands) AS PFR,
 1.0*SUM(totalbets)/SUM(totalcalls) AS AGG
 FROM compiledplayerresults 
  WHERE compiledplayerresults_id IN (
   SELECT compiledplayerresults_id FROM compiledresults
    WHERE player_id = 1234
    AND playeddate >= '2008-05-01 00:00:00');

SELECT player_id FROM players 
 WHERE playername = 'Your_Name'
 AND site_id = 0 //0 is Party, -1 is alias, just see table 'pokersites'

SELECT 
 SUM(totalhands) AS HANDS,
 100.0*SUM(vpiphands)/SUM(totalhands) AS VPIP,
 100.0*SUM(pfrhands)/SUM(totalhands) AS PFR,
 1.0*SUM(totalbets)/SUM(totalcalls) AS AGG
 FROM compiledplayerresults_month
  WHERE compiledplayerresults_id IN (
   SELECT compiledplayerresults_id FROM compiledresults_month
    WHERE player_id = 1234
    AND playedonmonth >= '200906');

def get_playernames_from_tablename(tablename, last_x_hands=5):
    """
    Get list of playernames from players dealt in to the last x hands at the table.

    Todo: Currently hard-coded to cash-only. Need to do the same but for 'tourneykeycolumns'
    """
    c = connection.cursor()
    q = """select distinct p.playername from playerhandscashkeycolumns kc join (
        select * from pokerhands ph
        inner join tables t on ph.table_id = t.table_id
        where t.tablename = %(tablename)s
        order by handtimestamp desc
        limit %(last_x_hands)s) as ph
        on kc.pokerhand_id = ph.pokerhand_id
        join players p on p.player_id = kc.player_id
        order by p.playername asc"""

    c.execute(q, locals())
    return [c[0] for c in c.fetchall()]