1Değil SELECT t_urun_kategoris.*, t_icerik_turs.Klasor,
			COALESCE((SELECT Ad FROM t_urun_kategori_lang WHERE LangAydi = '2' AND DataAydi = t_urun_kategoris.Aydi), t_urun_kategoris.Kod) AS dataAd,
			COALESCE((SELECT Baslik FROM t_urun_kategori_lang WHERE LangAydi = '2' AND DataAydi = t_urun_kategoris.Aydi), t_urun_kategoris.Kod) AS dataBaslik,
			COALESCE((SELECT Yazi FROM t_urun_kategori_lang WHERE LangAydi = '2' AND DataAydi = t_urun_kategoris.Aydi),t_urun_kategoris.Kod) AS dataYazi,
			COALESCE((SELECT Yazi2 FROM t_urun_kategori_lang WHERE LangAydi = '2' AND DataAydi = t_urun_kategoris.Aydi),t_urun_kategoris.Kod) AS dataYazi2, COALESCE((SELECT Ad FROM t_urun_kategori_lang WHERE LangAydi = 1 AND DataAydi = t_urun_kategoris.Aydi), t_urun_kategoris.Kod) AS dataAd1, (SELECT Pretty FROM t_urun_kategori_lang WHERE LangAydi = 1 AND DataAydi = t_urun_kategoris.Aydi) AS dataPretty1, COALESCE((SELECT Ad FROM t_urun_kategori_lang WHERE LangAydi = 2 AND DataAydi = t_urun_kategoris.Aydi), t_urun_kategoris.Kod) AS dataAd2, (SELECT Pretty FROM t_urun_kategori_lang WHERE LangAydi = 2 AND DataAydi = t_urun_kategoris.Aydi) AS dataPretty2,t_urun_kategoris.Resim1 
		FROM t_urun_kategoris
		INNER JOIN t_icerik_turs ON t_icerik_turs.Aydi = t_urun_kategoris.IcerikTurAydi
		
		WHERE t_urun_kategoris.Aktifmi = 1 AND t_urun_kategoris.Aydi = '68' ORDER BY Sira ASC