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 ') GROUP BY wp_braapf_product_variation_attributes.post_id ) as filtered_post INN' at line 1]
SELECT filtered_post.id, filtered_post.out_of_stock, COUNT(filtered_post.ID) as post_count FROM ( SELECT filtered_post.*, max_filtered_post.max_meta_count, IF(max_filtered_post.max_meta_count != filtered_post.meta_count OR stock_table.out_of_stock_init = 1, 1, 0) as out_of_stock FROM ( SELECT wp_braapf_product_variation_attributes.post_id as var_id, wp_braapf_product_variation_attributes.parent_id as ID, COUNT(wp_braapf_product_variation_attributes.post_id) as meta_count FROM wp_braapf_product_variation_attributes WHERE wp_braapf_product_variation_attributes.meta_value_id IN (0,348,) GROUP BY wp_braapf_product_variation_attributes.post_id ) as filtered_post INNER JOIN ( SELECT post_id as ID, COUNT(post_id) as max_meta_count FROM wp_braapf_variation_attributes WHERE taxonomy IN ('pa_model') GROUP BY post_id ) as max_filtered_post ON max_filtered_post.ID = filtered_post.ID LEFT JOIN ( SELECT wp_braapf_product_stock_status_parent.post_id as id, IF(wp_braapf_product_stock_status_parent.stock_status = 1, 0, 1) as out_of_stock_init FROM wp_braapf_product_stock_status_parent GROUP BY id ) as stock_table ON filtered_post.var_id = stock_table.id GROUP BY filtered_post.ID, out_of_stock ) as filtered_post GROUP BY filtered_post.ID HAVING post_count = 1 AND out_of_stock = 1

Truck Parts & Accessories – RECON - Suburban

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 ') GROUP BY wp_braapf_product_variation_attributes.post_id ) as filtered_post INN' at line 1]
SELECT filtered_post.id, filtered_post.out_of_stock, COUNT(filtered_post.ID) as post_count FROM ( SELECT filtered_post.*, max_filtered_post.max_meta_count, IF(max_filtered_post.max_meta_count != filtered_post.meta_count OR stock_table.out_of_stock_init = 1, 1, 0) as out_of_stock FROM ( SELECT wp_braapf_product_variation_attributes.post_id as var_id, wp_braapf_product_variation_attributes.parent_id as ID, COUNT(wp_braapf_product_variation_attributes.post_id) as meta_count FROM wp_braapf_product_variation_attributes WHERE wp_braapf_product_variation_attributes.meta_value_id IN (0,348,) GROUP BY wp_braapf_product_variation_attributes.post_id ) as filtered_post INNER JOIN ( SELECT post_id as ID, COUNT(post_id) as max_meta_count FROM wp_braapf_variation_attributes WHERE taxonomy IN ('pa_model') GROUP BY post_id ) as max_filtered_post ON max_filtered_post.ID = filtered_post.ID LEFT JOIN ( SELECT wp_braapf_product_stock_status_parent.post_id as id, IF(wp_braapf_product_stock_status_parent.stock_status = 1, 0, 1) as out_of_stock_init FROM wp_braapf_product_stock_status_parent GROUP BY id ) as stock_table ON filtered_post.var_id = stock_table.id GROUP BY filtered_post.ID, out_of_stock ) as filtered_post GROUP BY filtered_post.ID HAVING post_count = 1 AND out_of_stock = 1