SELECT DISTINCT merkitys_left.merkitys
			  , kieli_left.nimi
              , ilmentyma_left.ilmentyma_p
              , kieli_right.nimi
              , ilmentyma_right.ilmentyma_p
              
              , ilmentyma_right.ortognro
              , ilmentyma_left.ortognro
              , ilmentyma_right.ilmentyma
              , ilmentyma_left.ilmentyma
              , kieli_left.lyhenne
              , kieli_right.lyhenne
FROM (
    `ilmentyma` AS ilmentyma_left
    
    LEFT JOIN `lekseemi` AS lekseemi_left
        ON ilmentyma_left.lekseemi_id = lekseemi_left.id
    LEFT JOIN `kieli` as kieli_left
    	ON lekseemi_left.kieli_id = kieli_left.id
    LEFT JOIN `merkitys` as merkitys_left
        ON merkitys_left.lekseemi_id = lekseemi_left.id
    
    LEFT JOIN `merkitys` as merkitys_right
        ON merkitys_left.merkitys = merkitys_right.merkitys
     
    LEFT JOIN `ilmentyma` AS ilmentyma_right
        ON merkitys_right.lekseemi_id = ilmentyma_right.lekseemi_id
    LEFT JOIN `lekseemi` AS lekseemi_right
        ON ilmentyma_right.lekseemi_id = lekseemi_right.id
    LEFT JOIN `kieli` as kieli_right
        ON lekseemi_right.kieli_id = kieli_right.id
)
WHERE (
         ilmentyma_left.ortognro = 2
     AND ilmentyma_right.ortognro = 2
     AND kieli_left.lyhenne = "lu"
     AND kieli_right.lyhenne = "po"
     AND merkitys_left.merkitys <>''
)
;
