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('1090','1091','1092','1094','1095','1420','1096','1097','1098','1099','1100','1101','1102','1104','1493','1494','1495','1500','1105') AND cat.`status` = 'enabled' GROUP BY tb1.`id` ORDER BY RAND() LIMIT 20