Could not successfully run query (select products.product_id, products.item_no, ifnull(products.description,'') as 'description', ifnull(products.blemish,'') as 'blemish', ifnull(products.luster,'') as 'luster', ifnull(products.metal_desc,'') as 'metal_desc', ifnull(products.stone,'None') as 'stone', ifnull(is_set,'') as 'is_set', products.create_date, ifnull(sort.category,'') as 'category', ifnull(type.type,'') as 'type', ifnull(products.color_desc,'') as 'color', ifnull(products.size_desc,'') as 'size', ifnull(products.shape_desc,'') as 'shape', ifnull(metal.metal,'') as 'metal', ifnull(products.grade_desc,'') as 'grade', ifnull(price_range.price_range,'') as 'price_range', ifnull(photos.img_path,'') as 'img_path' from products left outer join sort on products.sort = sort.id left outer join type on products.type = type.id left outer join metal on products.metal = metal.id left outer join price_range on products.price_range = price_range.id left outer join photos on products.product_id = photos.product_id where 1=1 and products.product_id = order by products.product_id, photos.photo_id) from DB: 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 products.product_id, photos.photo_id' at line 25