1Değil SELECT t_uruns.*, t_icerik_turs.Klasor,
			COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = 1 AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd,
			(SELECT Baslik FROM t_urun_lang WHERE LangAydi = 1 AND DataAydi = t_uruns.Aydi) AS dataBaslik,
			(SELECT Yazi FROM t_urun_lang WHERE LangAydi = 1 AND DataAydi = t_uruns.Aydi) AS dataYazi, COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = 1 AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd1
			FROM t_uruns
			INNER JOIN t_icerik_turs ON t_icerik_turs.Aydi = t_uruns.IcerikTurAydi
			WHERE t_uruns.Aktifmi = 1 AND t_uruns.Aydi = '93' ORDER BY Sira ASC