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 85 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 85 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 85 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 85 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 85 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 85 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 85 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 85 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 85 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 85 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 85 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 70 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 70 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 70 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 70 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 56 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 56 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 56 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 56 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 50 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 50 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 50 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 50 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 50 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 50 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 50 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEVS33BR0" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 50 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKEVS33AR0" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 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 50 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640GOBKE37BL000" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 50 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 50 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 50 TOT:118 / 47 / 71