Query: #SELECT * FROM `ean` WHERE MATCH (hauptcatid) AGAINST ('248149011') AND farbe  LIKE 'schwarz (blk/arctc pnk-fchs frc-fchs fr)'   limit 1000#