ShareGate

SELECT COUNT(id_word) AS word_count, SUM(word_count) AS word_sum, AVG(word_pos) AS word_avg, sg_link.id_link, sg_link.title, sg_host.title AS host, sg_link.size, sg_link.time FROM sg_link, (SELECT sg_index.id_link, sg_index.id_word, COUNT(*) AS word_count, MIN(position) AS word_pos FROM sg_dictionary, sg_index WHERE sg_dictionary.id_word = sg_index.id_word AND sg_dictionary.word IN ('ani') GROUP BY sg_index.id_link, sg_index.id_word) AS keywords LEFT JOIN sg_host ON sg_host.id_host=sg_link.host WHERE sg_link.id_link=keywords.id_link GROUP BY id_link ORDER BY word_count DESC, word_sum DESC, word_avg, sg_link.time DESC