Free Shipping 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 wp_posts.post_status = 'publish' AND wp_posts.post_type = 'co...' at line 10]
SELECT count( wp_postmeta.post_id ) as count_number, wp_postmeta.meta_value FROM wp_postmeta WHERE wp_postmeta.post_id IN ( SELECT DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON(wp_posts.ID = wp_postmeta.post_id) LEFT JOIN wp_term_relationships ON(wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON( wp_term_taxonomy.term_id = wp_terms.term_id ) WHERE wp_terms.term_id = AND wp_posts.post_status = 'publish' AND wp_posts.post_type = 'coupon' ) AND wp_postmeta.meta_key = '_wpc_coupon_type' GROUP BY wp_postmeta.meta_value