Query: #SELECT * FROM `ean` WHERE MATCH (hauptcatid) AGAINST ('248161011') AND farbe  LIKE 'siehe abbildung'   limit 1000#