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('1347','1359','1360','1361','1363','1365','1436','1437','1509','1618','1366','1386','1387','1388','1442','1413','1419','1438','1491','1501','1514','1606','1719','1743') AND cat.`status` = 'enabled' GROUP BY tb1.`id` ORDER BY RAND() LIMIT 20