1Değil SELECT t_uruns.*, t_icerik_turs.Klasor,
			COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = '3' AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd,
			(SELECT Baslik FROM t_urun_lang WHERE LangAydi = '3' AND DataAydi = t_uruns.Aydi) AS dataBaslik,
			(SELECT Yazi FROM t_urun_lang WHERE LangAydi = '3' AND DataAydi = t_uruns.Aydi) AS dataYazi,
			(SELECT Yazi2 FROM t_urun_lang WHERE LangAydi = '3' AND DataAydi = t_uruns.Aydi) AS dataYazi2,
			(SELECT Resim1 FROM t_urun_lang WHERE LangAydi = '3' AND DataAydi = t_uruns.Aydi) AS dataResim1, COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = 3 AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd3, (SELECT Pretty FROM t_urun_lang WHERE LangAydi = 3 AND DataAydi = t_uruns.Aydi) AS dataPretty3
			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 = '1' ORDER BY Sira ASC