Disk full (/var/tmp/#sql_251d_0); waiting for someone to free some space...
query=SELECT *,IF( products.price2_1 > 0, products.price2_1, products.price1_1 ) AS Saleprice from prodcat_weight LEFT JOIN products ON (prodcat_weight.prod_id=products.prod_id) WHERE prodcat_weight.cat_id='700' OR prodcat_weight.cat_id IN (707,708,709,710,715,716,717,744,758) and prodcat_weight.hidden='0' order by prodcat_weight.weight ASC LIMIT 0, 16