Cita: tabla noticia (idnoticia,...,...)
tabla lecturas(idnoticia,leido)
A ver si esto:
SELECT n.idnoticia, count(l.idnoticia) as total FROM noticia n INNER JOIN lecturas l ON n.idnoticia = l.idnoticia GROUP BY n.idnoticia ORDER BY total DESC LIMIT 10