Coger info + count

[minkweb]

Código MySQL:

SELECT t1.topic_id, count(t1.topic_id) AS total, t2.nombre AS nombre
FROM tabla_1 AS t1 
INNER JOIN tabla_2 AS t2 ON t2.topic_id=t1.topic_id 
GROUP BY t1.topic_id
ORDER BY total DESC
LIMIT 5
 

Prueba Asi