SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND product.madetoorder=0 AND product.qty>0 ORDER BY pro' at line 5
Oh!SELECT * FROM product JOIN productimage ON product.id = productimage.productid AND position = 1 WHERE active = 1 AND product.qty > 0 AND merchantid = AND product.madetoorder=0 AND product.qty>0 ORDER BY product.id, dateadded, categoryid, views DESC