pool.shares queries

gistfile1.sql

SELECT username as address, 
       ((COUNT(*) * POW(2,32))/900) as hashrate 
  FROM shares 
 WHERE our_result <> 'N' 
   AND UNIX_TIMESTAMP(time) BETWEEN (UNIX_TIMESTAMP(NOW())-900) 
   AND UNIX_TIMESTAMP(NOW()) 
 GROUP BY address;

SELECT username as address, 
       ((COUNT(*) * POW(2,32))/10800) as hashrate 
  FROM shares 
 WHERE our_result <> 'N' 
   AND UNIX_TIMESTAMP(time) BETWEEN (UNIX_TIMESTAMP(NOW())-10800) 
   AND UNIX_TIMESTAMP(NOW()) 
 GROUP BY address;