Disk full (/tmp/#sql_424_4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")(No Description) sql: SELECT p.*, o.price + o.amountsaved as originalprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0 AND offers > 0 AND o.percentagesaved > 0 AND o.price > 200 AND p.id IN (SELECT product_id FROM products_categories) AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY o.percentagesaved DESC, p.salesrank DESC LIMIT 6