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 WHERE tb1.`status`='enabled' AND tb2.`id` IS NOT NULL AND tb1.`is-arhiv`='disabled' AND tb1.`instock`='enabled' AND tb1.`recomended` ='enabled' AND tb1.`is-hide`='disabled' GROUP BY tb1.`id` ORDER BY RAND() LIMIT 12