Олег Колтунов

SELECT * 
FROM wp_postmeta 
WHERE post_id in (
		SELECT id FROM wp_posts p
		LEFT JOIN wp_term_relationships r ON p.ID =r.object_id
		LEFT JOIN wp_term_taxonomy t ON r.term_taxonomy_id = t.term_taxonomy_id
		WHERE p.post_type = 'water'
		AND t.taxonomy = 'menu'
		AND t.term_id = 22
	) 
AND meta_value LIKE "field\_%" AND meta_key LIKE "%sku%"