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 'product.activate_in_store = 1 AND product.show_on_startup = 1 AND ( ec_categ...' at line 1]SELECT COUNT( DISTINCT product.product_id ) FROM ec_product AS product LEFT JOIN ec_categoryitem AS ec_categoryitem_0 ON ec_categoryitem_0.product_id = product.product_idWHERE product.activate_in_store = 1 AND product.show_on_startup = 1 AND ( ec_categoryitem_0.category_id IN (84,80,27,69)) AND ( product.role_id = 0 OR product.role_id = -1 )
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 'product.activate_in_store = 1 AND product.show_on_startup = 1 AND ( ec_categ...' at line 3]SELECT product.*, NULL AS role_price, NULL AS manufacturer_name, ec_product_google_attributes.attribute_value AS google_attributes, wp_posts.guid FROM ec_product AS product
LEFT JOIN wp_posts ON wp_posts.ID = product.post_id
LEFT JOIN ec_product_google_attributes ON ec_product_google_attributes.product_id = product.product_id LEFT JOIN ec_categoryitem AS ec_categoryitem_0 ON ec_categoryitem_0.product_id = product.product_idWHERE product.activate_in_store = 1 AND product.show_on_startup = 1 AND ( ec_categoryitem_0.category_id IN (84,80,27,69)) 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