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'
