WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.prod...' 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 MariaDB server version for the right syntax to use near ') AND ( product.role_id = 0 OR product.role_id = -1 ) GROUP BY product.prod...' at line 30]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_posts.guid
FROM ec_product AS product
LEFT JOIN wp_posts ON wp_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 product.sort_position ASC, product.price ASC LIMIT 0, 25