WordPress database 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 ') AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.product' at line 17]SELECT product.product_id, product.post_id, ec_roleprice.role_price
FROM ec_product as product
LEFT JOIN ec_roleprice ON ( ec_roleprice.product_id = product.product_id AND ec_roleprice.role_label = '' )
LEFT JOIN ec_manufacturer as manufacturer ON manufacturer.manufacturer_id = product.manufacturer_id
LEFT JOIN ec_categoryitem ON ec_categoryitem.product_id = product.product_id
LEFT JOIN ec_menulevel1 ON ( ec_menulevel1.menulevel1_id = product.menulevel1_id_1 OR ec_menulevel1.menulevel1_id = product.menulevel2_id_1 OR ec_menulevel1.menulevel1_id = product.menulevel3_id_1 )
LEFT JOIN ec_menulevel2 ON ( ec_menulevel2.menulevel2_id = product.menulevel1_id_2 OR ec_menulevel2.menulevel2_id = product.menulevel2_id_2 OR ec_menulevel2.menulevel2_id = product.menulevel3_id_2 )
LEFT JOIN ec_menulevel3 ON ( ec_menulevel3.menulevel3_id = product.menulevel1_id_3 OR ec_menulevel3.menulevel3_id = product.menulevel2_id_3 OR ec_menulevel3.menulevel3_id = product.menulevel3_id_3 )
WHERE product.activate_in_store = 1 AND ec_categoryitem.category_id IN () AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.product_id
WordPress database 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 ') AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.product' at line 31]SELECT
product.*, ec_roleprice.role_price, manufacturer.name as manufacturer_name,
ec_product_google_attributes.attribute_value as google_attributes,
AVG( ec_review.rating ) as review_average,
wp_jhzpg0mrq1_posts.guid
FROM ec_product AS product
LEFT JOIN wp_jhzpg0mrq1_posts ON wp_jhzpg0mrq1_posts.ID = product.post_id
LEFT JOIN ec_roleprice ON ( ec_roleprice.product_id = product.product_id AND ec_roleprice.role_label = '' )
LEFT JOIN ec_manufacturer AS manufacturer ON manufacturer.manufacturer_id = product.manufacturer_id
LEFT JOIN ec_categoryitem ON ec_categoryitem.product_id = product.product_id
LEFT JOIN ec_product_google_attributes ON ec_product_google_attributes.product_id = product.product_id
LEFT JOIN ec_menulevel1 ON ( ec_menulevel1.menulevel1_id = product.menulevel1_id_1 OR ec_menulevel1.menulevel1_id = product.menulevel2_id_1 OR ec_menulevel1.menulevel1_id = product.menulevel3_id_1 )
LEFT JOIN ec_menulevel2 ON ( ec_menulevel2.menulevel2_id = product.menulevel1_id_2 OR ec_menulevel2.menulevel2_id = product.menulevel2_id_2 OR ec_menulevel2.menulevel2_id = product.menulevel3_id_2 )
LEFT JOIN ec_menulevel3 ON ( ec_menulevel3.menulevel3_id = product.menulevel1_id_3 OR ec_menulevel3.menulevel3_id = product.menulevel2_id_3 OR ec_menulevel3.menulevel3_id = product.menulevel3_id_3 )
LEFT JOIN ec_review ON ( ec_review.product_id = product.product_id AND ec_review.approved = 1 )
WHERE product.activate_in_store = 1 AND ec_categoryitem.category_id IN () AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.product_id ORDER BY FIELD( product.model_number, '3421360', '4594982', '3291667', '2152597', '8667347', '3104914', '4863487', '5442297', '1475932', '2338237', '3576809', '8944354', '3319748', '4033324', '8939947', '4019777', '8803102', '8257876' ) LIMIT 0, 25