SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "651GWL900_00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 120 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GWL901B00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 119 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GWL901000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 118 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58WLTD0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 117 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 116 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58NNTB0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 115 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58NNT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 114 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58NNG00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 113 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58NNB00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 112 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58NN000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 111 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV58N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 110 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV56NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 109 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV56NNT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 108 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV56NN000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 107 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV56N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 106 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV47NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 105 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV47NNT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 104 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV47NN000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 103 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV47N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 102 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV45NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 101 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV45N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 100 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV40NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 99 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GV40N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 98 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK52N00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 97 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK52BB0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 96 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK52B00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 = "14" AND
filter.TermekKod = "641GTRK46N00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK46B00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK35BNPACK" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK35BN0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK35BBPACK" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK35BB0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK33N00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 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 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GTRK33B00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 95 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE4700N00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 82 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE46NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 81 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE46NB000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 80 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE46N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 79 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE455NT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 77 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE455N000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 76 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE450NT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 75 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE4500N00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 74 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE370NT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 73 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 73 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE360N000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 73 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE340NT20000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 72 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE340N200000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 71 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE340N000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 70 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE300NT2B000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 69 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GE300N2B0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 68 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 66 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 65 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GC30NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 63 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GC3000000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 62 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB47NTML0000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 61 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB47NML00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 60 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB4700NTML00" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 59 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB4700NML000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 58 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB4500000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 57 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB37NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 56 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB37N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 55 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB360NT20000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 54 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB360N200000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 53 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB32N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 52 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB29NT200000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 51 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "641GB29N2000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 50 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 44 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 43 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 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GV37NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 42 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 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GV37NNT00000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 42 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 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GV37NN000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 42 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 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GV37N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 42 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 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GV35NT000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 42 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 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GV35N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 42 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 42 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 41 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 40 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 39 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 38 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 37 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 36 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 35 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 34 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 33 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 32 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 = "8" AND
filter.TermekKod = "640GOBKEV37BL00" 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 = "640GOBKEV37AR00" 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 = "640GOBKEV37AL00" 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 = "640GOBKES33BR00" AND
( LOWER(filter.Leiras) LIKE '%oldaldoboz%' )
;
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 26 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 25 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 24 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 23 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 22 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 21 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 20 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 19 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 18 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GE22N0000000" AND
( LOWER(filter.Leiras) LIKE '%műanyag%' )
;
M 18 TOT:242 / 114 / 128
