Veri GÃ¶rÃ¼ntÃ¼leme

Tablo: kmp_liste

KayÄ±t SayÄ±sÄ±: 16 | Sayfa 1 / 2

ID	aktif	ad	adet1	adet2	indirim	islem	bonusislem	oncelik	maxsayac	t1	t2	sorgu1	sorgu2	paket	del	sepetID	sepetID2	prodID	prodID2	aciklama	aciklama2	bundle	yalnizkampanya	tumurunler	alinacakfiyat	aciklama3	Ä°ÅŸlem
16	True	4 al 2 öde tek	4	2	100	%	-	0	100000	1.04.2023	30.04.2023	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 '%tekmelik%' or prods.model like '%tekmelik%' ) and ((prods.fiyat+(prods.fiyatprods.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 '%tekmel%' or prods.model like '%tekmel%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	1	null	null	null	null		null	False	True	False	1	null	DÃ¼zenle
15	True	4 al 2 öde eşofman	4	2	100	%	-	1	100000	1.04.2023	30.04.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 (1)) and (prods.name like '%eşofman takımı 18/19%' or prods.model like '%eşofman takımı 18/19%' ) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and (prods.name like '%eşofman takımı 18/19%' or prods.model like '%eşofman takımı 18/19%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	1	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle
14	False	2 al 1 öde ant. tişört	2	1	100	%	-	11	100000	1.04.2023	30.04.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 (1)) and (prods.name like '%brç antrenman t-s%' or prods.model like '%brç antrenman t-s%' ) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and (prods.name like '%brç antrenman t-s%' or prods.model like '%brç antrenman t-s%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	0	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle
13	False	2 al 1 öde ant. yağmurluk	2	1	100	%	-	9	100000	1.04.2023	30.04.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 (1)) and (prods.name like '%brç antrenman yağmur%' or prods.model like '%brç antrenman yağmur%' ) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and (prods.name like '%brç antrenman yağmur%' or prods.model like '%brç antrenman yağmur%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	0	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle
12	False	2 al 1 öde ant. eşofman	2	1	100	%	-	7	100000	1.04.2023	30.04.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 (1)) and (prods.name like '%brç antrenman eşofman%' or prods.model like '%brç antrenman eşofman%' ) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and (prods.name like '%brç antrenman eşofman%' or prods.model like '%brç antrenman eşofman%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	0	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle
11	False	2 al 1 öde tekmelik	2	1	100	%	-	5	100000	1.04.2023	30.04.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 (1)) and (prods.name like '%tekmel%' or prods.model like '%tekmel%' ) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and (prods.name like '%tekme%' or prods.model like '%tekme%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	0	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle
10	False	2 al 1öde yağ	2	1	100	%	-	3	100000	1.04.2023	30.04.2023	SELECT prods.ID FROM prods left outer join makes ON prods.make = makes.ID where prods.del = 0 and prods.catid > 0 and prods.catid = 4995 and ((prods.fiyat+(prods.fiyatprods.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 (1)) and (prods.name like '%yağmurluk 18/19%' or prods.model like '%yağmurluk 18/19%' ) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	0	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle
9	True	4 al 2 öde	4	2	100	%	-	0	100000	1.04.2023	30.04.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 (1)) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	1	null	null	null	null		null	False	True	False	1	null	DÃ¼zenle
8	True	Test 2 al 1 Öde	2	1	100	%	-	13	100000	1.04.2023	30.04.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 (1)) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	1	null	null	null	null	test	null	False	True	False	1	null	DÃ¼zenle
7	True	Yağmurluk 2 al 1 öde	2	1	100	%	-	3	100000	1.04.2023	30.04.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 (1)) and ((prods.fiyat+(prods.fiyatprods.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 (1)) and ((prods.fiyat+(prods.fiyatprods.kdv/100))(select kur from para where para.ID=prods.pbir)) between 0 and 999999	null	1	null	null	null	null		null	False	False	False	1	null	DÃ¼zenle

Ä°leri »