| ID | tur | ad | sorgu | cat | marka | grup | kelime | fiyat | stok | aktif | tekrardakika | dosyaadi | fiyatalan | indirimlifiyatalan | scriptname | bayifiyat | alisfiyat | bayi_fiyat_arttirma | 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) | | | | | 0 | 0 | 0 | 1440 | http://www.yeppuda.com/images/exports/merchant.xml | 1 | 1 | ent_googlemerchant.asp | 0 | 0 | 0 | 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) | | | | | 0 | 0 | 0 | 1440 | http://www.yeppuda.com/images/exports/Akakce.xml | 1 | 1 | ent_akakce.asp | 0 | 0 | 0 | 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) | | | | | 0 | 0 | 0 | 1440 | http://www.yeppuda.com/images/exports/sitemap.xml | 1 | 1 | ent_google_sitemap.asp | 0 | 0 | 0 | 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) | | | | | 0 | 0 | 0 | 1440 | http://www.yeppuda.com/images/exports/facebook.xml | 1 | 1 | ent_facebookpixel.asp | 0 | 0 | 0 | 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 |