--------------------- SELECT DISTINCT post_id FROM `wp_postmeta` AS pm JOIN wp_posts AS p ON p.id = pm.post_id AND p.post_status='publish'
WHERE meta_value = (SELECT meta_value FROM wp_postmeta WHERE post_id = 2961 AND meta_key='nemzetseg' LIMIT 1) AND post_id <> 2961SELECT meta_value FROM `wp_postmeta`
WHERE meta_key ='latin_nev'
AND post_id=2924 Lamium album SELECT meta_value FROM `wp_postmeta`
WHERE meta_key ='a_virag_neve'
AND post_id=2924 Fehér árvacsalán SELECT meta_value FROM `wp_postmeta`
WHERE meta_key ='latin_nev'
AND post_id=2955 Scutellaria hastifolia L. SELECT meta_value FROM `wp_postmeta`
WHERE meta_key ='a_virag_neve'
AND post_id=2955 Dárdás csukóka SELECT meta_value FROM `wp_postmeta`
WHERE meta_key ='latin_nev'
AND post_id=4129 Viola pumila SELECT meta_value FROM `wp_postmeta`
WHERE meta_key ='a_virag_neve'
AND post_id=4129 Réti ibolya 3 VAN BLOKK
