SELECT * FROM articles INNER JOIN comments ON articles.artid = comments.artid ORDER BY MAX(comments.artid) LIMIT 10
I am trying to fetch top 10 articles that have higher comments
But this fetch only one records
