SELECT o.*,COUNT(c.ID) COM FROM `org` o 
LEFT OUTER JOIN `comments` c ON (o.ID=c.OID AND c.CAT='1')
GROUP BY o.ID ORDER BY o.R0 DESC LIMIT 50,10: Disk full (/var/tmp/#sql_4f9a_1); waiting for someone to free some space...