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 4 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 4 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 4 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 4 TOT:9 / 4 / 5
