<font color="red">
	    	<b>Qrong query: Disk full (/tmp/#sql_355_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")</b>
	    	<br />
	    	SELECT SQL_CALC_FOUND_ROWS tb1.*, 
					CASE 
						WHEN ((`old-price` &gt; '0' OR `issale` = 'enabled') AND `isnew` = 'enabled') THEN 10
						WHEN (`isnew` = 'enabled') THEN 20
						WHEN (`old-price` &gt; '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 (2217) 
			ORDER BY tb1.`instock` ASC  , `typeorder` ASC ,tb2.`order` ASC
			LIMIT 0,20
	    </font>