All pastes #926605 Raw Edit

Speed up, please

public sql v1 · immutable
·published 2008-03-03 19:38 UTC
rendered paste body
SELECT DISTINCT stkno as st, (SELECT COUNT(`stkno`) FROM partners_downloads WHERE `status` = 'Done' AND stkno = st GROUP BY stkno) as `done`, (SELECT COUNT(`stkno`) FROM partners_downloads WHERE `status` = 'InProcess' AND stkno = st GROUP BY stkno) as `inprocess`, (SELECT COUNT(`stkno`) FROM partners_downloads WHERE `status` = 'Pending' AND stkno = st GROUP BY stkno) as `pending` FROM partners_downloads pd ORDER BY `done` DESC