Qrong query!: Disk full (/tmp/#sql_1_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT tb1.* FROM `a_items` tb1 LEFT JOIN `a_gallery` as tb2 ON tb1.`id`=tb2.`parent` AND tb2.`id` IS NOT NULL LEFT JOIN `a_catalog` AS cat ON cat.`id` = tb1.`parent` WHERE tb1.`status`='enabled' AND tb1.`instock`='enabled' AND tb2.`id` IS NOT NULL AND tb1.`item-1c`='enabled' AND cat.`id` IN('1108','1250','1251','1427','1507') AND cat.`status` = 'enabled' GROUP BY tb1.`id` ORDER BY RAND() LIMIT 20