SELECT news_view.news_id, count(news_view.id_view) AS count_view, article_list.n_topic,c_id
FROM article_list LEFT JOIN news_view ON (article_list.n_id = news_view.news_id) WHERE n_id='260'
GROUP BY news_view.news_id, article_list.n_topic
order by count_view desc File './db_2_asean_news/news_view.MYD' not found (Errcode: 30)