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 29
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 28
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 27
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 26
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 25
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 24
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 23
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 22
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 21
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 20
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 19
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 18
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 17
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 16
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 15
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 14
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
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 7
TOT:58 / 30 / 28