Disk full (/var/tmp/#sql_248b_0); waiting for someone to free some space...
SELECT a.*, SUM(b.is_useful) AS cnt FROM SC_discussions AS a LEFT JOIN customer_discussions AS b ON (a.DID = b.DID) WHERE productID=15281 AND `show` = 1 GROUP BY a.DID LIMIT 0, 100