| Query | SELECT SQL_CALC_FOUND_ROWS * , MATCH (ps.fullTitle) against ("ludwig" IN BOOLEAN MODE) as score0, MATCH (ps.composer,ps.instruments,ps.categories) against ("ludwig" IN BOOLEAN MODE) as cscore, MATCH (ps.fullTitle) against ("van" IN BOOLEAN MODE) as score1, MATCH (ps.composer,ps.instruments,ps.categories) against ("van" IN BOOLEAN MODE) as cscore, MATCH (ps.fullTitle) against ("beethoven" IN BOOLEAN MODE) as score2, MATCH (ps.composer,ps.instruments,ps.categories) against ("beethoven" IN BOOLEAN MODE) as cscore FROM m_piecesearch15 ps WHERE ( MATCH (ps.fullTitle,ps.instruments,ps.categories) against ("ludwig van beethoven " IN BOOLEAN MODE) ) ORDER BY score0 desc, score1 desc, score2 desc,cscore desc, ranking ASC LIMIT 7700,25 |
