1Değil SELECT t_uruns.*, t_icerik_turs.Klasor,
			COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = '2' AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd,
			COALESCE((SELECT Baslik FROM t_urun_lang WHERE LangAydi = '2' AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataBaslik,
			COALESCE((SELECT Yazi FROM t_urun_lang WHERE LangAydi = '2' AND DataAydi = t_uruns.Aydi),t_uruns.Kod) AS dataYazi,
			COALESCE((SELECT Yazi2 FROM t_urun_lang WHERE LangAydi = '2' AND DataAydi = t_uruns.Aydi),t_uruns.Kod) AS dataYazi2, COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = 1 AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd1, (SELECT Pretty FROM t_urun_lang WHERE LangAydi = 1 AND DataAydi = t_uruns.Aydi) AS dataPretty1, COALESCE((SELECT Ad FROM t_urun_lang WHERE LangAydi = 2 AND DataAydi = t_uruns.Aydi), t_uruns.Kod) AS dataAd2, (SELECT Pretty FROM t_urun_lang WHERE LangAydi = 2 AND DataAydi = t_uruns.Aydi) AS dataPretty2,
		COALESCE(t_uruns.Resim1, t_uruns.Resim2, t_urun_kategoris.Resim1, t_urun_kategoris.Resim2) AS dataResim,
		(SELECT Resim1 FROM t_icerik_turs WHERE t_icerik_turs.Aydi=3) AS Resim1,
		COALESCE((SELECT Ad FROM t_urun_marka_lang WHERE t_urun_marka_lang.LangAydi= '2' AND t_urun_marka_lang.DataAydi = t_urun_markas.Aydi),t_urun_markas.Kod) AS dataMarka,
        COALESCE((SELECT Ad FROM t_urun_kategori_lang WHERE t_urun_kategori_lang.LangAydi= '2' AND t_urun_kategori_lang.DataAydi = t_urun_kategoris.Aydi),t_urun_kategoris.Kod) AS dataKategori,
        (SELECT t_urun_dovizs.Sembol FROM t_urun_dovizs WHERE t_uruns.DovizAydi = t_urun_dovizs.Aydi) AS dataDoviz,
        COALESCE((SELECT Ad FROM t_ulke_lang WHERE t_ulke_lang.LangAydi= '2' AND t_ulke_lang.DataAydi = t_ulkes.Aydi),t_ulkes.Kod) AS dataUlke,
        (SELECT Resim1 FROM t_icerik_turs WHERE t_icerik_turs.Aydi=3) AS Resim1
        
			FROM t_uruns
			INNER JOIN t_icerik_turs ON t_icerik_turs.Aydi = t_uruns.IcerikTurAydi
			INNER JOIN t_urun_kategoris ON t_urun_kategoris.Aydi = t_uruns.KategoriAydi
            LEFT JOIN t_urun_markas ON t_urun_markas.Aydi = t_uruns.MarkaAydi
            LEFT JOIN t_urun_dovizs ON t_urun_dovizs.Aydi = t_uruns.DovizAydi
            LEFT JOIN t_ulkes ON t_ulkes.Aydi = t_uruns.BayrakAydi
			WHERE t_uruns.Aktifmi = 1 AND t_uruns.Aydi = '29' ORDER BY Sira ASC