| ID | aktif | ad | adet1 | adet2 | toplamtutar | indirim | islem | bonustutar | bonusislem | oncelik | sayac | maxsayac | t1 | t2 | sorgu1 | sorgu2 | paket | paytypeID | del | sepetID | sepetID2 | prodID | prodID2 | simge | kucuksimge | aciklama | aciklama2 | bundle | yalnizkampanya | tumurunler | uyeID | f1 | f2 | alinacakfiyat | aciklama3 | Ä°ÅŸlem |
|---|
| 1020 | False | halil deneme | 1 | 1 | 0 | 20 | % | 0 | - | 0 | 0 | 100000 | 28.12.2023 | 30.12.2023 | SELECT prods.ID FROM prods LEFT outer JOIN makes ON prods.make = makes.ID INNER JOIN ozel_urunler ON prods.ID = ozel_urunler.prodID where prods.del = 0 and prods.catid > 0 and (ozel_urunler.catID IN (18)) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | SELECT prods.ID FROM prods LEFT outer JOIN makes ON prods.make = makes.ID INNER JOIN ozel_urunler ON prods.ID = ozel_urunler.prodID where prods.del = 0 and prods.catid > 0 and (ozel_urunler.catID IN (19)) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | null | | 0 | null | null | null | null | | | 2.ürün indirim | null | False | False | False | 0 | 0 | 0 | 1 | null | Düzenle |
| 1019 | False | Deneme | 1 | 1 | 1 | 35 | - | 0 | - | 99 | 0 | 1 | 9.03.2020 | 25.06.2020 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%1024%' or prods.model like '%1024%' or prods.ID like '%1024%') and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%1029%' or prods.model like '%1029%' or prods.ID like '%1029%') and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | null | 1,54,56,52, | 0 | null | null | null | null | | | | | False | True | False | 0 | 0 | 0 | 1 | | Düzenle |
| 1018 | True | Yuzde indirim | 1 | 1 | 1 | 50 | % | 1 | - | 99 | 0 | 1 | 8.08.2018 | 31.08.2018 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%353430842%' or prods.model like '%353430842%' or prods.ID like '%353430842%') and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%STK02%' or prods.model like '%STK02%' ) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | null | 1,54,56,52, | 1 | null | null | null | null | | | 6 | 5 | False | True | False | 0 | 0 | 0 | 1 | 7 | Düzenle |
| 1015 | True | Test kampanya | 1 | 1 | 0 | 50 | % | 0 | - | 99 | 0 | 1 | 8.08.2018 | 31.08.2018 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%MSIGP421%' or prods.model like '%MSIGP421%' ) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%363457506%' or prods.model like '%363457506%' or prods.ID like '%363457506%') and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | null | 1,54,52, | 1 | null | null | null | null | | | Test 2 | Test 1 | False | True | False | 0 | 0 | 0 | 1 | Test 3 | Düzenle |
| 1013 | True | Yeni 50% | 1 | 1 | 50 | 50 | % | 0 | - | 99 | 0 | 1 | 1.08.2018 | 31.08.2018 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%STK02%' or prods.model like '%STK02%' ) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%363969680%' or prods.model like '%363969680%' or prods.ID like '%363969680%') and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | null | 1,47,48,52, | 1 | null | null | null | null | | | | | False | True | False | 0 | 0 | 0 | 1 | | Düzenle |
| 1012 | True | 50% indirim | 1 | 1 | 10 | 50 | % | 0 | - | 99 | 0 | 1 | 1.08.2018 | 31.08.2018 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%STK01%' or prods.model like '%STK01%' ) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and (prods.name like '%STKLA005%' or prods.model like '%STKLA005%' ) and ((prods.fiyat+(prods.fiyat*prods.kdv/100))*(select kur from para where para.ID=prods.pbir)) between 0 and 999999 | null | 1,47,48,52, | 1 | null | null | null | null | | | | | False | True | False | 0 | 0 | 0 | 1 | | Düzenle |
| 1011 | False | 2 Bunle | 2 | 2 | 0 | 0 | - | 50 | % | 99 | 0 | 3 | 26.07.2018 | 25.08.2018 | | | null | 1,47,48,50,51, | 1 | null | null | 7 | 8 | | | 353430842 free | APPTL205 al | True | False | False | 0 | 0 | 0 | 1 | freee | Düzenle |