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('1085','1222','1223','1235','1081','1624','1625','1694','1695','1236','1337','1339','1340','1341','1342','1343','1457','1623','1434','1461','1626','1257','1258','1259','1260','1261','1262','1264','1265','1266','1268','1645','1267','1270','1271','1272','1693','1766','1305','1306','1307','1308','1309','1310','1311','1312','1313','1314','1315','1316','1317','1318','1319','1320','1321','1322','1323','1324','1333','1334','1335','1336','1450','1451','1462','1463','1476','1565','1566','1630','1635','1668','1739','1325','1326','1650','1651','1652','1653','1654','1655','1656','1658','1665','1799','1327','1328','1329','1464','1465','1466','1467','1483','1659','1660','1661','1662','1663','1664','1666','1722','1590','1721','1723','1724','1725','1726','1727','1728','1734','1742','1744') AND cat.`status` = 'enabled' GROUP BY tb1.`id` ORDER BY RAND() LIMIT 20