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 95 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 94 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 93 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 92 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 91 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 90 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 89 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 88 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 86 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 85 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 84 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 83 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 82 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 81 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 80 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 79 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKE58B0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 78 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKE58A0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 77 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKE42B0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 76 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GOBKE42A0000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 75 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "641GE360N000000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
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 58 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 57 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 57 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 57 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 57 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 57 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 42 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 41 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 40 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 39 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 38 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 37 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 37 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 37 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 37 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 37 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 37 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 36 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 35 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 34 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 33 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 32 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 31 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 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN48BL000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN48BL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN48AR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN48AR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN48AL000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN48AL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKN37BR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKN37BR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE48BR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE48BR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE48BL000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE48BL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE48AR000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE48AR000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "8" AND
filter.TermekKod = "640GOBKE48AL000" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
M 31 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE48AL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 31 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 31 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 31 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 31 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 31 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 31 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 31 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 31 TOT:242 / 92 / 150
