string(678) "
				SELECT CI.*,
				CM.name as manufacturer, CM.country as manufacturer_country, ( SELECT max(CIQ.price) FROM catalogue_item_quantity as CIQ WHERE CIQ.FK_sku=CI.sku AND CIQ.price>0) as max_price
				FROM catalogue_item CI
				LEFT JOIN catalogue_manufacturer CM ON CI.FK_manufacturer_code=CM.code
                LEFT JOIN catalogue_item_quantity IQ ON IQ.FK_sku = CI.sku
				
				WHERE
				    CI.FK_category IN (78)
				    AND CI.deleted IS NULL 
				    AND CI.visible=1
				    AND IQ.quantity>0 AND IQ.price>0
				    -- AND count(IQ.FK_sku)>0
				GROUP BY CI.sku ORDER BY title LIMIT 0,8  [nativecode=1 ** Can't create/write to file '/tmp/#sql_a24_0.MAI' (Errcode: 28)]"