SELECT B.cat_name as [cat_name],B.articles_count as [articles_count], B.cat_ID as [cat_ID],SUM(A.article_visit) AS [Article_Visit] FROM article_list A LEFT JOIN category B ON A.cat_ID = B.cat_ID WHERE A.article_status = 1 AND B.article_allow = 1 GROUP BY(B.cat_name,B.articles_count, B.cat_ID);
GROUP BY B.cat_name,B.articles_count, B.cat_ID ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)