SELECT path, title, obj_id, img_id, doc_id, description, content_fields, ehg, (  CASE WHEN title LIKE '%Kokenmühle%' THEN CASE WHEN keywords LIKE '%Kokenmühle%' THEN 10.5 ELSE 0.5 END ELSE CASE WHEN keywords LIKE '%Kokenmühle%' THEN 10 ELSE 0 END END +  relevance ) AS relevanz FROM custom_searchindex WHERE (MATCH (title,content_full,keywords) AGAINST ('*"Kokenmühle"*' IN BOOLEAN MODE) OR title LIKE '%Kokenmühle%') AND ehg LIKE '2%' ORDER BY relevanz DESC LIMIT 31