SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230134703K00L" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 25 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230134703K00M" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 24 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230134703K00S" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 23 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230134703K0XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 22 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230134703K2XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 21 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230134703K3XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 20 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019210U100L" AND
( LOWER(filter.Leiras) LIKE '%uv%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019210U100L" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019210U100M" AND
( LOWER(filter.Leiras) LIKE '%uv%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019210U100M" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019210U100S" AND
( LOWER(filter.Leiras) LIKE '%uv%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019210U100S" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019210U10XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019210U10XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019210U12XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019210U12XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019210U13XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019210U13XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230192207300L" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 12 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230192207300M" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 11 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "1230192207300S" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 10 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019220730XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 9 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019220732XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 8 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123019220733XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 7 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "123ECS220730XL" AND
( LOWER(filter.Leiras) LIKE '%sixgear%' )
;
M 6 TOT:96 / 25 / 71