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 107 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 107 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 76 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 76 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 76 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 76 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 76 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 76 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 76 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 76 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 66 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 66 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 66 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 66 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 52 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 52 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 52 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 52 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 52 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 52 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 52 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 52 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "14" AND
filter.TermekKod = "640OBKEVS33AAR0" AND
( LOWER(filter.Leiras) LIKE '%alumínium%' )
;
M 52 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 52 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 52 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 52 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 52 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 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 46 TOT:109 / 43 / 66
