Black Friday Coupons & Promo Codes

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 wpbv_posts.post_status = 'publish' AND wpbv_posts.post_type = '' at line 10]
SELECT count( wpbv_postmeta.post_id ) as count_number, wpbv_postmeta.meta_value FROM wpbv_postmeta WHERE wpbv_postmeta.post_id IN ( SELECT DISTINCT wpbv_posts.ID FROM wpbv_posts LEFT JOIN wpbv_postmeta ON(wpbv_posts.ID = wpbv_postmeta.post_id) LEFT JOIN wpbv_term_relationships ON(wpbv_posts.ID = wpbv_term_relationships.object_id) LEFT JOIN wpbv_term_taxonomy ON(wpbv_term_relationships.term_taxonomy_id = wpbv_term_taxonomy.term_taxonomy_id) LEFT JOIN wpbv_terms ON( wpbv_term_taxonomy.term_id = wpbv_terms.term_id ) WHERE wpbv_terms.term_id = AND wpbv_posts.post_status = 'publish' AND wpbv_posts.post_type = 'coupon' ) AND wpbv_postmeta.meta_key = '_wpc_coupon_type' GROUP BY wpbv_postmeta.meta_value