SELECT web_termek_torzs.TermekKod    FROM   
				`web_termek_torzs` 
				LEFT  OUTER JOIN web_keszlet as keszlet ON (keszlet.CegKod = web_termek_torzs.CegKod AND keszlet.TermekKod = web_termek_torzs.TermekKod AND keszlet.Raktar = 0),   
				`web_termek_szovegek`,
				`web_listaar`, `web_termek_kategoria`    WHERE   
				 web_termek_torzs.CegKod = "GNT" 
				 AND web_termek_szovegek.CegKod = "GNT" 
				 AND web_listaar.CegKod = "GNT"  
				 AND web_termek_kategoria.CegKod = "GNT" 
			  
				 AND LENGTH(web_termek_torzs.TermekKod) > 2
				 AND web_termek_torzs.TermekKod = web_termek_szovegek.TermekKod 
				 AND web_termek_torzs.TermekKod = web_listaar.TermekKod 
				 AND web_termek_torzs.TermekKod = web_termek_kategoria.TermekKod 
				 AND web_listaar.DevizaNem = "HUF"  
				 AND web_listaar.AlapAr > 0 
			  
				 AND web_termek_szovegek.Nyelv = "HUN" 
				 AND web_termek_torzs.Statusza IN ('N','R','U','V','Z') 
			     AND ( web_termek_torzs.TermekKod IN ('KRFPCMPUF0002','KRFPCMPUF0001','KRFPCMPAF0010','KRFPCMPAF0009VZ','KRFPCMPAF0009VO','KRFPCMPAF0009SZ','KRFPCMPAF0009SK','KRFPCMPAF0009SA','KRFPCMPAF0009PI','KRFPCMPAF0009NA','KRFPCMPAF0008MZ','KRFPCMPAF0008MP','KRFPCMPAF0008ML','KRFPCMPAF0008MK','KRFPCMPAF0008FZ','KRFPCMPAF0009KE','KRFPCMPAF0009LI','KRFPCMPAF0009FH','KRFPCMPAF0009FK','KRFPCMPAF0009BA','KRFPCMPAF0008FS','KRFPCMPAF0008FP','KRFPCMPAF0008FN','KRFPCMPAF0007ZO','KRFPCMPAF0007VK','KRFPCMPAF0007SZ','KRFPCMPAF0007SP','KRFPCMPAF0007SK','KRFPCMPAF0007SA','KRFPCMPAF0007PI','KRFPCMPAF0007NA','KRFPCMPAF0007KE','KRFPCMPAF0007LI','KRFPCMPAF0007FK','KRFPCMPAF0007FH','KRFPCMPAF0007CS','KRFPCMPAF0007EZ','KRFPCMPAF0007BA','KRFPCMPAF0007AR','KRFPCMPAF0006ZO','KRFPCMPAF0006SK','KRFPCMPAF0006SA','KRFPCMPAF0006PI','KRFPCMPAF0006NA','KRFPCMPAF0006LI','KRFPCMPAF0006FK','KRFPCMPAF0006KE','KRFPCMPAF0006FH','KRFPCMPAF0006EZ','KRFPCMPAF0006BA','KRFPCMPAF0006AR','KRFPCMPAF000801','KRFPCMPAF0004','KRFPCMPAF0003','KRFPCMPAF0002','KRFPCMPAF0001','KRFFGRSFV0006','KRFFGRSFV0007','KRFFGRSFV0008','KRFFGRSFV0005','ISEFCMP0025','ISEFCMP0026','KRFFGRSFA0003','ISZSCMP0010','ISZSCMP0009','ISZSCMP0008','ISZSCMP0007','ISZSCMP0006','ISZSCMP0004','ISZSCMP0005','ISZSCMP0003','ISZSCMP0002','ISZSCMP0001','ISVFCMP000714','ISVFCMP000715','ISVFCMP000716','ISVFCMP000710','ISVFCMP000711','ISVFCMP000712','ISVFCMP000713','ISVFCMP000707','ISVFCMP000708','ISVFCMP000709','ISVFCMP000703','ISVFCMP000704','ISVFCMP000705','ISVFCMP000706','ISVFCMP000701','ISVFCMP000702','ISVFCMP0005','ISVFCMP0002','ISVFCMP0004','ISVFCMP0006','ISVFCMP0003','ISVFCMP0001','ISVFCMP0001E','ISTECMP0009ZO','ISTECMP0009LI','ISTECMP0009PI','ISTECMP0009RE','ISTECMP0009SA','ISTECMP0009SK','ISTECMP0009AR','ISTECMP0009EZ','ISTECMP0008','ISTECMP0007','ISTECMP0006','ISTECMP0005ZO','ISTECMP0005VZ','ISTECMP0005VR','ISTECMP0005VL','ISTECMP0005UK','ISTECMP0005TU','ISTECMP0005SG','ISTECMP0005SB','ISTECMP0005SA','ISTECMP0005RO','ISTECMP0005PI','ISTECMP0005OK','ISTECMP0005NA','ISTECMP0005MA','ISTECMP0005LI','ISTECMP0005FH','ISTECMP0005FE','ISTECMP0003A','ISTECMP000313','ISTECMP000312','ISTECMP000311','ISTECMP0005EZ','ISTECMP0005CS','ISTECMP0005CK','ISTECMP000310','ISTECMP000309','ISTECMP000308','ISTECMP000307','ISTECMP000306','ISTECMP000305','ISTECMP0005CI','ISTECMP0005BO','ISTECMP0005BA','ISTECMP000304','ISTECMP000303','ISTECMP000302','ISTECMP000301','ISTECMP0003','ISTECMP0002','ISTECMP0005AR','ISTECMP0004F','ISTECMP0004','ISTECMP000201','ISTECMP0001ZZ','ISTECMP0001ZO','ISTECMP0001VZ','ISTECMP0001VL','ISTECMP0001UK','ISTECMP0001TU','ISTECMP0001TS','ISTECMP0001SP','ISTECMP0001SB','ISTECMP0001SA','ISTECMP0001RO','ISTECMP0001PI','ISTECMP0001OK','ISTECMP0001NA','ISTECMP0001LI','ISTECMP0001KE','ISTECMP0001FK','ISTECMP0001FH','ISTECMP0001EZ','ISTECMP0001CS','ISTECMP0001CI','ISTECMP0001BA','ISTECMP0001AR','ISTECMP000106','ISTECMP0001','ISRACMP0005','ISRACMP0003','ISRACMP0004','ISRACMP0002','ISRACMP0001','ISKRCMP0005','ISKRCMP0006','ISKRCMP0004','ISKRCMP0003P10','ISKRCMP0003P','ISKRCMP0002P10','ISKRCMP0002P','ISKRCMP0002C','ISKRCMP0001P15','ISKRCMP0002','ISKRCMP000124','ISKRCMP0001','ISGYCMP0011TE','ISGYCMP0011FH','ISGYCMP0010','ISGYCMP0009','ISGYCMP0008','ISGYCMP0007','ISGYCMP0006','ISGYCMP0005','ISGYCMP0004','ISGYCMP0003','ISGYCMP0002','ISGYCMP0001ZO','ISGYCMP0001SZ','ISGYCMP0001RO','ISGYCMP0001SA','ISGYCMP0001PI','ISGYCMP0001NA','ISGYCMP0001KE','ISGYCMP0001FK','ISGYCMP0001BA','ISGYCMP0001','ISEFCMP0004','ISEFCMP0005','ISEFCMP0003','ISEFCMP0006','ISEFCMP0002','ISEFCMP0007','ISEFCMP0001','IRTECMP0001','IRSCCMP0019','IRSCCMP0020','IRSCCMP0018M','IRSCCMP0018F','IRSCCMP001523','IRSCCMP001524','IRSCCMP0016','IRSCCMP0017','IRSCCMP001522','IRSCCMP001521','IRSCCMP001519','IRSCCMP001520','IRSCCMP001518','IRSCCMP001517','IRSCCMP001516','IRSCCMP001514','IRSCCMP001515','IRSCCMP001513','IRSCCMP001512','IRSCCMP001511','IRSCCMP001510','IRSCCMP001509','IRSCCMP001508','IRSCCMP001505','IRSCCMP001506','IRSCCMP001507','IRSCCMP001502','IRSCCMP001503','IRSCCMP001504','IRSCCMP001501','IRSCCMP0014','IRSCCMP0013','IRSCCMP0011','IRSCCMP0012','IRSCCMP0010','IRSCCMP0009','IRSCCMP0008','IRSCCMP0007','IRSCCMP0005','IRSCCMP0006','IRSCCMP0004','IRSCCMP0003','IRSCCMP0002','IRSCCMP0001','IRFTCMP0010','IRFTCMP0007','IRFTCMP0008','IRFTCMP0009','IRFTCMP0006','IRFTCMP0005','IRFTCMP0004','IRFTCMP0003','IRFTCMP0002','IRFTCMP0001','VTTECMP0001','KRFPCMPAF000802','KRFPCMPAF000803','KRFPCMPAF000804','KRFPCMPAF000805','KRFPCMPAF000806','KRFPCMPAF000807','KRFPCMPAF000808','KRFPCMPAF000809','KRFPCMPAF000810','KRFPCMPAF000811','KRFPCMPAF000812','KRFPCMPAF000813','KRFPCMPAF000814','KRFPCMPAF000815','KRFPCMPAF000816','KRFPCMPAF000817','KRFPCMPAF000818','KRFPCMPAF000819','KRFPCMPAF000820','KRFPCMPAF000821','KRFPCMPAF000822','ISEFCMP0008','ISEFCMP0009','ISEFCMP0010','ISEFCMP0011','ISEFCMP0012','ISEFCMP0013','ISEFCMP0014','ISEFCMP0015','ISEFCMP0016','ISEFCMP0017','ISEFCMP0018','ISEFCMP0019','ISEFCMP0020','ISEFCMP0021','ISEFCMP0022','ISEFCMP0023','ISEFCMP0027','ISEFCMP0028','ISEFCMP0029','KRFFCMPFA0001','KRFFGRSFV0009','KRFFGRSFV0010','ISVFCMP000717','ISVFCMP000718','ISVFCMP0007GT') )  AND (web_listaar.Eng_ar*((web_termek_torzs.Afa/100)+1)) >= "0"  AND (web_listaar.Eng_ar*((web_termek_torzs.Afa/100)+1)) <= "999999"    GROUP BY TermekKod  ORDER BY web_termek_torzs.TermekKod ASC   LIMIT  0,20  

Erre keresett: primo

281 darab termék

Filc készlet 10 db, PRIMO 610PENDP10, vízbázisú, kétvégű

Cikszám: IRFTCMP0001
Vonalkód: 8006919006104
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Filc készlet 12 db, PRIMO 603JUMBO12, vízbázisú, vastagtestű

Cikszám: IRFTCMP0002
Vonalkód: 8006919006036
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Filc készlet 12 db, PRIMO 605PEN12B, vízbázisú

Cikszám: IRFTCMP0003
Vonalkód: 8006919006050
Márka: PRIMO
Készlet: Nincs raktáron
Mennyiségi kedvezmény

Filc készlet 24 db, PRIMO 606PEN24B, vízbázisú

Cikszám: IRFTCMP0004
Vonalkód: 4006272006067
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Filc készlet 24 db, PRIMO 603JUMBO24 vízbázisú, vastagtestű.

Cikszám: IRFTCMP0005
Vonalkód: 8006919006043
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Színes ceruza 12 db, PRIMO 515TRIS12, háromszögű + hegyező

Cikszám: IRSCCMP0001
Vonalkód: 8006919005152
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Színes ceruza 12 db, PRIMO 503MAT12E, hatszögletű testtel.

Cikszám: IRSCCMP0002
Vonalkód: 8006919005039
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Színes ceruza 12 db, PRIMO 510MAXI12E, vastagtestű, hatszögű

Cikszám: IRSCCMP0003
Vonalkód: 8006919005107
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Színes ceruza 12 db, PRIMO vastag, háromszögű + 2hegyező + radír,

Cikszám: IRSCCMP0004
Vonalkód: 8006919005183
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Színes ceruza 24 db, PRIMO 504MAT24E, hatszögletű test

Cikszám: IRSCCMP0005
Vonalkód: 8006919005046
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény

Színes ceruza 36 db, PRIMO 502MAT36E, hatszögletű test

Cikszám: IRSCCMP0006
Vonalkód: 8006919005022
Márka: PRIMO
Készlet: Raktáron
Mennyiségi kedvezmény