I think the below Query should work.(For a very large dataset there could a performance issue without proper indexing)

select languagetype

,Indication

...