Tel: +31(0)184-61 22 27

Uitgebreid zoeken?
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY product.list_price ASC LIMIT 0,51' at line 1
Error No: 1064
SELECT product.productid,product_language.product,product_language.rewrite,product.list_price,product.aanbieding,product.btwID,product_language.fulldescr FROM product LEFT OUTER JOIN product_language ON product_language.productid=product.productid LEFT OUTER JOIN product_merk ON product_merk.productid=product.productid LEFT OUTER JOIN product_categorie ON product_categorie.productid=product.productid WHERE product_merk.categoryid = '4' AND product.forsale='Y' AND product_language.language_id='2' GROUP BY product.productid ORDER BY product.list_price ASC LIMIT 0,51 ORDER BY product.list_price ASC LIMIT 0,51