Counterweight Bar Kubota R070 and R090

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 ')) ) ORDER BY FIELD(pm2.meta_value, 'products', 'categories') AS...' at line 13]
SELECT p.ID FROM wp_posts AS p LEFT JOIN wp_postmeta AS pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_pricing_discount_status' LEFT JOIN wp_postmeta AS pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_dynamic_pricing_discounts_display' LEFT JOIN wp_postmeta AS pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_product_pricing_discount_ids' LEFT JOIN wp_term_relationships AS tr ON p.ID = tr.object_id LEFT JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'product_cat' WHERE p.post_type = 'em_pricing_discount' AND p.post_status = 'publish' AND pm1.meta_value = 'yes' AND ( (pm2.meta_value = 'products' AND pm3.meta_value LIKE '%197869%') OR (pm2.meta_value = 'categories' AND tt.term_id IN ()) ) ORDER BY FIELD(pm2.meta_value, 'products', 'categories') ASC, p.menu_order ASC, p.post_date DESC LIMIT 1