SELECT count(*) FROM blocks WHERE findtime BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) AND NOW() AND miner LIKE "%hamsterpool%" = 28 SELECT 144/100*(avg(("poolhash"/"nethash")*100)) FROM "stats" WHERE timestamp BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) and now() = 28.749

^^ to calculate the efficiency of the pool. does that make sense to you?

i mostly mean the second query.

It would be more accurate to count the shares from mrplow

I guess the pool hash is based on that

yes