select X.name as all1, Y.name as top5, Z.name as top3, concat(X.id, ",", Y.id, ",", Z.id) as ids
from full_thesaurus_origin as A 
                    join full_thesaurus_concept as X on A.global_concept = X.id 
join full_top5_origin as B on B.lang = A.lang and B.local_concept = A.local_concept 
                    join full_top5_concept as Y on B.global_concept = Y.id 
join full_top3_origin as C on C.lang = A.lang and C.local_concept = A.local_concept 
                    join full_top3_concept as Z on C.global_concept = Z.id 
where A.lang = "en" 
    and (X.name != Y.name or X.name != Z.name) 
--    and (X.name != Y.name) 
limit 5\G

select X.name as all1, Y.name as top5, Z.name as top3, concat(X.id, ",", Y.id, ",", Z.id) as ids
from full_thesaurus_origin as A 
                    join full_thesaurus_concept as X on A.global_concept = X.id 
left join full_top5_origin as B on B.lang = A.lang and B.local_concept = A.local_concept 
                    left join full_top5_concept as Y on B.global_concept = Y.id 
left join full_top3_origin as C on C.lang = A.lang and C.local_concept = A.local_concept 
                    left join full_top3_concept as Z on C.global_concept = Z.id 
where A.lang = "de" and A.local_concept_name = "Eigenschaft" \G

select L.language, L.target 
from full_thesaurus_origin as O 
join full_thesaurus_langlink as L on L.concept = O.global_concept 
where O.lang = "simple" and O.local_concept_name = "Medicine_man"; 