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 's shirts' AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product' at line 15]
SELECT product.product_id, product.post_id FROM ec_product as product 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.model_number = 'men's shirts' 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 's shirts' AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product' at line 29]
SELECT product.*, manufacturer.name as manufacturer_name, ec_product_google_attributes.attribute_value as google_attributes, AVG( ec_review.rating ) as review_average, wp_h82xkbbh7g_posts.guid FROM ec_product AS product LEFT JOIN wp_h82xkbbh7g_posts ON wp_h82xkbbh7g_posts.ID = product.post_id 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.model_number = 'men's shirts' AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.product_id