SELECT t_tag_scores.tag_id, t_tag_scores.score, t_tags.tag_title FROM rekrawl.t_tag_scores INNER JOIN rekrawl.t_tags ON t_tags.tag_id = t_tag_scores.tag_id INNER JOIN rekrawl.t_tagmap ON t_tagmap.tag_id = t_tag_scores.tag_id AND t_tagmap.group = t_tag_scores.group INNER JOIN phtorrent.torrents ON torrents.torrentid = t_tagmap.item_id WHERE t_tag_scores.group=2 AND t_tag_scores.score > 0 AND torrents.disabled = 0 GROUP BY t_tag_scores.tag_id ORDER BY t_tag_scores.score DESC LIMIT 0, 40