SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000U522XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000U520XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000U520XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000U5200S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000U5200M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000U5200L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000L730XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000L730XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000L7300S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000L7300M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "21832000L7300L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320004532XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320004530XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320004530XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200045300S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200045300M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200045300L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000M92XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000M90XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000M90XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000M900S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000M900M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000M900L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000562XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000560XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000560XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200005600S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200005600M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200005600L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000542XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000540XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000540XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200005400S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200005400M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200005400L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000M2XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000M0XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000M0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000M00S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000M00M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000M00L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000052XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000050XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000050XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000500S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000500M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000500L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000032XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000030XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000030XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000300S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000300M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000300L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000022XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000020XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218320000020XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000200S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000200M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2183200000200L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218228025410XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218228025410XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2182280254100S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2182280254100M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2182280254100L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2182280225R0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2182280225R00L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1444 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M72XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M70XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M70XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M700S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M700M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M700L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M22XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M20XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M20XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M200S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M200M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228432000M200L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2284320000M2XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2284320000M0XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2284320000M0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2284320000M00S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2284320000M00M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2284320000M00L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228356000M70XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228356000M70XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "228356000M700S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2283560000M2XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2283560000M0XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2283560000M0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 1018 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000M52XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000M50XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000M50XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000M500S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000M500M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000M500L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000412XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000410XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000410XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550004100S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550004100M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550004100L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000M2XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000M0XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000M0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000M00S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000M00M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000M00L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000052XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000050XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000050XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000500S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000500M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000500L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000022XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000020XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238355000020XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000200S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000200M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2383550000200L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 734 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484200000M2XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484200000M0XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484200000M0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484200000M00S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484200000M00M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484200000M00L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "248419002142XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "248419002140XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "248419002140XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190021400S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190021400M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190021400L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190000M2XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190000M0XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190000M0XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190000M00S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190000M00M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2484190000M00L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 543 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26843100000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26843000000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26842900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26842800000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26842700000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26842600000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26835800000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26835700000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26834200000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26834100000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26834000000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26833900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26833800000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26832500000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26832400000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26832300000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26826900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26826800000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26826700000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26823900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26816900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26800639000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26800631000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "26800605000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 382 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29836200000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29836100000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29835000000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834800000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834700000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834600000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834500000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834400000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29834300000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29832900000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29832800000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29832700000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29832600000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29824200000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29824100000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29816600000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "298165000000XS" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "298165000000XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981650000000S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981650000000M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981650000000L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981620000000L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "298161000000XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981610000000S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981610000000M" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981610000000L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "298160000000XL" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "2981600000000L" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29815700000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "29815600000000" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 313 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "238ECS0004100S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 203 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "218ECS0005400S" AND
( LOWER(filter.Leiras) LIKE '%jet%' )
;
M 200 TOT:1449 / 195 / 1254
