1De─čil SELECT t_veris.*, t_icerik_turs.Klasor, COALESCE((SELECT Ad FROM t_veri_lang WHERE LangAydi = '2' AND DataAydi = t_veris.Aydi), t_veris.Kod) AS dataAd, COALESCE((SELECT Baslik FROM t_veri_lang WHERE LangAydi = '2' AND DataAydi = t_veris.Aydi), t_veris.Kod) AS dataBaslik, COALESCE((SELECT Yazi FROM t_veri_lang WHERE LangAydi = '2' AND DataAydi = t_veris.Aydi),t_veris.Kod) AS dataYazi, COALESCE((SELECT Yazi2 FROM t_veri_lang WHERE LangAydi = '2' AND DataAydi = t_veris.Aydi),t_veris.Kod) AS dataYazi2, COALESCE((SELECT Ad FROM t_veri_lang WHERE LangAydi = 1 AND DataAydi = t_veris.Aydi), t_veris.Kod) AS dataAd1, (SELECT Pretty FROM t_veri_lang WHERE LangAydi = 1 AND DataAydi = t_veris.Aydi) AS dataPretty1, COALESCE((SELECT Ad FROM t_veri_lang WHERE LangAydi = 2 AND DataAydi = t_veris.Aydi), t_veris.Kod) AS dataAd2, (SELECT Pretty FROM t_veri_lang WHERE LangAydi = 2 AND DataAydi = t_veris.Aydi) AS dataPretty2 FROM t_veris INNER JOIN t_icerik_turs ON t_icerik_turs.Aydi = t_veris.IcerikTurAydi WHERE t_veris.Aktifmi = 1 AND t_veris.Aydi = '278' ORDER BY Sira ASC