Query: #SELECT * FROM `ean` WHERE MATCH (hauptcatid) AGAINST ('3024171031') AND farbe  LIKE 'core black footwear white signal coral'   limit 1000#