Veri GÃ¶rÃ¼ntÃ¼leme

Tablo: xml

KayÄ±t SayÄ±sÄ±: 5 | Sayfa 1 / 1

ID	tur	ad	sorgu	tekrardakika	dosyaadi	fiyatalan	indirimlifiyatalan	scriptname	sorgu_sayisi	Ä°ÅŸlem
3005	merchant.xml	GoogleMerchantCenter	select p.model,m.mname,c.catname,p.ozelfiyat2,p.ozelfiyat1,p.ozelfiyat3,p.kargogun,'https://www.yeppuda.com//prod.asp?id='+cast(p.ID as varchar) as url,'https://www.yeppuda.com//images/prod/'+cast(p.ID as varchar)+'.jpg' as resim, p.name, p.catid as KategoriId, p.supplier, p.make, p.ID , adbir, p.stok, p.fiyat, p.bayifiyat, p.ozelfiyat1, p.ozelfiyat2, p.eskifiyat, p.kdv, p.oiv, p.pbir, p.desi, p.sdescr,p.descr, p.metakey, p.metadesc, p.editoryorumu,p.keyword, ou.catID from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join makes m on m.ID = p.make left join cat c on c.ID=p.catid Where p.del=0 and p.catid>0 and (p.del = 0 and p.catid > 0)	1440	http://www.yeppuda.com/images/exports/merchant.xml	1	1	ent_googlemerchant.asp	select count(*) as toplam_sonuc from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join makes m on m.ID = p.make left join cat c on c.ID=p.catid Where p.del=0 and p.catid>0 and (p.del = 0 and p.catid > 0)	DÃ¼zenle
3004	Akakce.xml	Akakce	select p.model, name, catid, ((select catname from cat where ID=c.ustID) + ' > ' + c.catname) as catname, m.mname, make, p.ID , adbir, stok, p.fiyat, p.bayifiyat, p.ozelfiyat1, p.ozelfiyat2, eskifiyat, kdv, oiv, pbir, desi,kargogun, sdescr,descr, p.metakey, p.metadesc, editoryorumu, keyword, 'https://www.yeppuda.com//images/prod/'+cast(p.ID as varchar)+'.jpg' as resim, 'https://www.yeppuda.com//prod.asp?id='+cast(p.ID as varchar) as url, ou.catID from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join cat c on c.ID=p.catid left join makes m on m.ID=p.make Where p.del=0 and p.catid<>0 and (p.del = 0 and p.catid > 0)	1440	http://www.yeppuda.com/images/exports/Akakce.xml	1	1	ent_akakce.asp	select count(*) as toplam_sonuc from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join cat c on c.ID=p.catid left join makes m on m.ID=p.make Where p.del=0 and p.catid<>0 and (p.del = 0 and p.catid > 0)	DÃ¼zenle
3003	cimri.xml	Cimri.xml	select p.model, name, catid as KategoriId, ((select catname from cat where ID=c.ustID) + ' > ' + c.catname) as catname, ureticikodu, m.mname, make, p.ID , adbir, stok, p.fiyat, p.bayifiyat, p.ozelfiyat1, p.ozelfiyat2, eskifiyat, kdv, oiv, pbir, desi,kargogun, sdescr,descr, p.metakey, p.metadesc, editoryorumu, keyword, 'https://www.yeppuda.com//images/prod/'+cast(p.ID as varchar)+'.jpg' as resim, 'https://www.yeppuda.com//prod.asp?id='+cast(p.ID as varchar) as url, ou.catID from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join cat c on c.ID=p.catid left join makes m on m.ID=p.make Where p.del=0 and p.catid<>0 and (p.del = 0 and p.catid > 0)	1440	http://www.yeppuda.com/images/exports/cimri.xml	1	1	ent_cimri.asp	select count(*) as toplam_sonuc from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join cat c on c.ID=p.catid left join makes m on m.ID=p.make Where p.del=0 and p.catid<>0 and (p.del = 0 and p.catid > 0)	DÃ¼zenle
1002	sitemap.xml	Sitemap	select p.ID, name, p.model from prods p Where del=0 and (p.del = 0 and p.catid > 0)	1440	http://www.yeppuda.com/images/exports/sitemap.xml	1	1	ent_google_sitemap.asp	select count(*) as toplam_sonuc from prods p Where del=0 and (p.del = 0 and p.catid > 0)	DÃ¼zenle
2	facebook.xml	Facebook	select p.model,m.mname,c.catname,p.ozelfiyat2, p.catid as KategoriId, p.supplier, p.ozelfiyat1,p.ozelfiyat3,p.kargogun,'https://www.yeppuda.com//prod.asp?id='+cast(p.ID as varchar) as url,'https://www.yeppuda.com//images/prod/'+cast(p.ID as varchar)+'.jpg' as resim, p.name, p.catid, p.make, p.ID , adbir, p.stok, p.fiyat, p.bayifiyat, p.ozelfiyat1, p.ozelfiyat2, p.eskifiyat, p.kdv, p.oiv, p.pbir, p.desi, p.sdescr,p.descr, p.metakey, p.ureticikodu, p.metadesc, p.editoryorumu,p.keyword, ou.catID from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join makes m on m.ID = p.make left join cat c on c.ID=p.catid Where p.del=0 and p.catid>0 and (p.del = 0 and p.catid > 0)	1440	http://www.yeppuda.com/images/exports/facebook.xml	1	1	ent_facebookpixel.asp	select count(*) as toplam_sonuc from prods p left join (SELECT prodID, MIN(catID) AS catID FROM ozel_urunler GROUP BY prodID) AS ou on p.ID = ou.prodID left join makes m on m.ID = p.make left join cat c on c.ID=p.catid Where p.del=0 and p.catid>0 and (p.del = 0 and p.catid > 0)	DÃ¼zenle