SELECT news_view.news_id, count(news_view.id_view) AS count_view, article_list.n_topic
FROM article_list INNER JOIN news_view ON (article_list.n_id = news_view.news_id) WHERE article_list.c_id = '1'
GROUP BY news_view.news_id, article_list.n_topic
order by count_view desc limit 0,5 File './db_1_kru_asean/news_view.MYD' not found (Errcode: 30)