Qrong query: Disk full (/tmp/#sql_355_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT SQL_CALC_FOUND_ROWS tb1.*,
CASE
WHEN ((`old-price` > '0' OR `issale` = 'enabled') AND `isnew` = 'enabled') THEN 10
WHEN (`isnew` = 'enabled') THEN 20
WHEN (`old-price` > '0' OR `issale` = 'enabled') THEN 30
WHEN (`ishit`='enabled') THEN 40
ELSE 1000
END as 'typeorder'
FROM `a_products` tb1 LEFT JOIN `a_products-rels` tb2 ON tb1.`id`=tb2.`did` OR tb2.`id` IS NULL
WHERE tb1.`status`='enabled' AND tb1.`public`='enabled' AND tb2.`cid` IN (2155)
ORDER BY tb1.`instock` ASC , `typeorder` ASC ,tb2.`order` ASC
LIMIT 0,20