Versiering per kleur

SELECT meta_value FROM wp_postmeta WHERE post_id IN (SELECT post_id FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'ywdpd_discount' ) AND meta_value LIKE '%"5473"%' AND meta_key = '_rule_for_tags_list' ) and meta_key = 'rules'