SELECT pc.comment_id, pc.product_id, pc.good_percent, pc.cdate, pc.header, pc.comment, pc.mark, p.rating, p.alias AS alias, pc.account_id, p.title, p.first_foto_id, p.category_id AS category_id, p.alias AS alias, acc.fname, acc.lname, acc.login, acc.alias AS acc_alias FROM `catalog_product_comment` AS pc JOIN `catalog_product` AS p ON (pc.product_id = p.product_id) JOIN `catalog_category` AS c ON (p.category_id = c.category_id) JOIN `account` AS acc ON (pc.account_id = acc.account_id) WHERE pc.is_approved = 1 AND p.is_active = 1 AND c.category_id IN (30) ORDER BY pc.good_percent DESC LIMIT 2

MYSQL 1021: Disk full (/tmp/#sql_618_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")