1De─čil SELECT t_veris.*, t_icerik_turs.Klasor, COALESCE((SELECT Ad FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi), t_veris.Kod) AS dataAd, (SELECT Baslik FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi) AS dataBaslik, (SELECT Yazi FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi) AS dataYazi, (SELECT Yazi2 FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi) AS dataYazi2, (SELECT Resim1 FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi) AS dataResim1, 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 = '226' ORDER BY Sira ASC