1Değil SELECT t_veris.*, t_icerik_turs.Klasor,
         COALESCE((SELECT Ad FROM t_icerik_tur_lang WHERE LangAydi = '1' AND DataAydi = t_icerik_turs.Aydi), t_icerik_turs.Kod ) AS dataIcerikAd,
         (SELECT Baslik FROM t_icerik_tur_lang WHERE LangAydi = '1' AND DataAydi = t_icerik_turs.Aydi) AS dataIcerikBaslik,
         (SELECT Yazi FROM t_icerik_tur_lang WHERE LangAydi = '1' AND DataAydi = t_icerik_turs.Aydi) AS dataIcerikYazi,
			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,
         COALESCE((SELECT Resim1 FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi),t_veris.Resim1) AS dataResim1,COALESCE((SELECT Resim2 FROM t_veri_lang WHERE LangAydi = '1' AND DataAydi = t_veris.Aydi),t_veris.Resim2) AS dataResim2,COALESCE((SELECT Resim1 FROM t_icerik_tur_lang WHERE LangAydi = '1' AND DataAydi = t_icerik_turs.Aydi), t_icerik_turs.Resim1 ) AS dataIcerikResim1,
              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 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 = '52' ORDER BY Sira ASC