SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641OBKEV58AA000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 105 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641OBKEV42AA000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 104 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK46N00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 81 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK46B00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 80 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK35BNPACK" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 79 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK35BN0000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 78 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK35BBPACK" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 77 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK35BB0000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 76 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK33N00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 75 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GTRK33B00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 74 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKN58B0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 72 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKN58A0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 71 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKN42B0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 70 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKN42A0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 69 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKEV58B000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 68 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKEV58A000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 67 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKEV42B000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 66 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKEV42A000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 65 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GDLM46B00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 54 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GDLM46A00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 53 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GDLM30B00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 53 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GDLM30B00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 53 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GDLM30A00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 53 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GDLM30A00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 53 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GALP44B00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 38 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GALP44A00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 37 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GALA56B00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 36 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GALA56A00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 35 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GALA44B00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 34 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GALA44A00000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640OBKEVS33BR0" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEVS33BR0" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640OBKEVS33AR0" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEVS33AR0" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640OBKEV48AAR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEV48AAR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640OBKEV48AAL00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEV48AAL00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640OBKEV37AAR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEV37AAR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640OBKEV37AAL00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEV37AAL00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GV37NT000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 33 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GV37NNT00000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 32 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GV37NN000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GV37N0000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 30 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GV35NT000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 29 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GV35N0000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 28 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN48BR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN48BR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN37AR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN37AR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN37AL000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN37AL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV48BR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV48BR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV48BL00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV48BL00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV48AR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV48AR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV48AL00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV48AL00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV37BR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV37BR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV37BL00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV37BL00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV37AR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV37AR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKEV37AL00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEV37AL00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKES33BR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKES33BR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKES33AR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKES33AR00" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE37BR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE37BR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE37AR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE37AR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE37AL000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE37AL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 27 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GE22N0000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 27 TOT:214 / 81 / 133
