Query: #SELECT * FROM `ean` WHERE MATCH (hauptcatid) AGAINST ('12471295031') AND farbe  LIKE 'bc6-04'   limit 1000#