SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "654GST606000000" AND
( LOWER(filter.Leiras) LIKE '%givi%' )
;
M 6 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "654GGRT71900000" AND
( LOWER(filter.Leiras) LIKE '%givi%' )
;
M 6 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "654GEA148B00000" AND
( LOWER(filter.Leiras) LIKE '%givi%' )
;
M 6 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "654GEA129B00000" AND
( LOWER(filter.Leiras) LIKE '%givi%' )
;
M 6 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "654GEA104C00000" AND
( LOWER(filter.Leiras) LIKE '%givi%' )
;
M 6 SELECT * FROM web_termek_kieg as filter
WHERE
filter.CegKod = "SHOX" AND
filter.KiegKod = "26" AND
filter.TermekKod = "654GCRM10100000" AND
( LOWER(filter.Leiras) LIKE '%givi%' )
;
M 6 TOT:10 / 6 / 4
