Qrong query!: Can't create/write to file '/tmp/MYeX8MX9' (Errcode: 28 - No space left on device)
SELECT tb1.*,IF(cl.`instock` IS NULL,tb1.`instock`,cl.`instock`) as 'n-instock',IF(cl.`order` IS NULL,tb1.`order`,cl.`order`) as 'n-order' FROM `a_items` tb1 LEFT JOIN `a_gallery` as tg ON tb1.`id`=tg.`parent` LEFT JOIN `a_items` as cl ON tb1.`source`=cl.`id` WHERE tb1.`status` IN ('enabled','clone') AND (cl.`is-arhiv`='disabled' OR (cl.`is-arhiv` IS NULL AND tb1.`is-arhiv`='disabled')) AND tg.`id` IS NOT NULL AND tb1.`parent`='1083' GROUP BY tb1.`id` ORDER BY `n-instock` DESC,`n-order` ASC LIMIT 72,24