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('1190','1191','1192','1193','1194','1195','1389','1621','1622','1749','1767','1768','1769','1771','1772') AND cat.`status` = 'enabled'
GROUP BY tb1.`id` ORDER BY RAND() LIMIT 20