SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "182010270013XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 48 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "181010280014XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 47 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "181010280013XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 46 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "181010280012XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 45 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1810102800100S" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 44 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1810102800100L" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 43 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "181010280010XS" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 42 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "182010270010XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 41 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "181010280010XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 40 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1820102700100S" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 39 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1820102700100L" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 38 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1810102800100M" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 37 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "182010270014XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 36 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1820102700100M" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 35 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "182010270012XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 34 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "182010270010XS" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 33 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%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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 = "13" AND
filter.TermekKod = "1230192207300L" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
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 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1230192207300M" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 13 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 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "1230192207300S" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 13 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 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019220730XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 13 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 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019220732XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 13 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 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123019220733XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 13 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 13 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "13" AND
filter.TermekKod = "123ECS220730XL" AND
( LOWER(filter.Leiras) LIKE '%uv%' OR LOWER(filter.Leiras) LIKE '%zöld%' )
;
M 13 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 13 TOT:96 / 48 / 48
