mysql全文搜索排序最佳结果然后再按其他项排序

Question

"SELECT *, 
    MATCH(md.keywords) AGAINST('$meta[keywords]') AS score
    FROM 
        meta_data AS md 
    INNER JOIN
        sites AS si ON md.domain = si.domain
    WHERE
        MATCH(md.keywords) AGAINST('$meta[keywords]')
    ORDER BY score DESC
    LIMIT 25"

I generated this query to find best matching results with fulltext keyword search. Now I want to sort these results again by most viewed entries. The views are also stored inside the mysql database in sites (si.views).

How can I first sort my results by best matching score and then sort these 25 best results by views? I think this will be done somehow with Grouping but I don't know how to get this working. Help would be appreciated. Thanks,

Answer 1

select * from 
(
    SELECT *, 
    MATCH(md.keywords) AGAINST('$meta[keywords]') AS score
    FROM 
        meta_data AS md 
    INNER JOIN
        sites AS si ON md.domain = si.domain
    WHERE
        MATCH(md.keywords) AGAINST('$meta[keywords]')
    ORDER BY score DESC
    LIMIT 25
) x
order by x.views