| Query | SELECT SQL_CALC_FOUND_ROWS * , MATCH (ps.fullTitle) against ("love" IN BOOLEAN MODE) as score0, MATCH (ps.composer,ps.instruments,ps.categories) against ("love" IN BOOLEAN MODE) as cscore, MATCH (ps.fullTitle) against ("bites" IN BOOLEAN MODE) as score1, MATCH (ps.composer,ps.instruments,ps.categories) against ("bites" IN BOOLEAN MODE) as cscore FROM m_piecesearch15 ps WHERE ( MATCH (ps.fullTitle,ps.instruments,ps.categories) against ("love bites " IN BOOLEAN MODE) ) ORDER BY score0 desc, score1 desc,cscore desc, ranking ASC LIMIT -50,25 |
