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_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 FIELD( product.model_number, 'solar-hard-hat-white', 'pwca-solar-hard-hat-green', 'pwca-solar-hard-hat-orange', 'pwca-solar-hard-hat-yellow', 'lady-cowboy-w-scarf', 'ladys-cowboy-solar-straw-hat-w-headband', 'ladys-thurman-solar-straw-hat-w-scarf', 'ladys-thurman-solar-straw-hat-w-headband', 'job-site-binder', 'pwca-crush-it-prevailing-wage-beginner-webinar', 'pwca-crush-it-pw-seminar', 'pwca-crush-it-certified-payroll-seminar', 'talk-text', 'pwca-crush-it-customized-one-on-one' ) LIMIT 0, 25
We support Samaritan’s Purse’s Operation Heal Our Patriots