Error: Disk full (/tmp/#sql_47b_1); waiting for someone to free some space...
Error No: 1021
SELECT * FROM product LEFT OUTER JOIN product_language ON product_language.productid=product.productid LEFT OUTER JOIN product_merk ON product_merk.productid=product.productid WHERE product_merk.categoryid = '150' AND product_language.rewrite!='' AND product_language.language_id='2' AND product.forsale='Y' GROUP BY product.productid ORDER BY product.kortingID ASC,product.add_date DESC