require('../includes/codes.php'); require('../includes/mysqli.php'); require('../includes/ads.php'); $sql="SELECT C.category_id, C.category, S.subcat_id, S.subcat" ." FROM SubCategory S" ." INNER JOIN Category C ON C.category_id=S.category_id" ." WHERE C.category_id<>'JOB' AND C.active=1 AND S.active=1" ." ORDER BY C.category, S.subcat"; $result = SqlQuery($sql); //Top 5 articles /*$date_from=date("Y-m-d", time()-(60*60*24*180)); // 6 months $sql="SELECT A.article_id, A.url, A.title,sum(AT.viewed) AS cnt" ." FROM ArticleStat AT" ." INNER JOIN Article A ON A.article_id=AT.article_id" ." WHERE AT.date_view > '".$date_from."'" ." AND A.url NOT LIKE '/newsletter/%'" ." AND A.article_type='DESIGN'" ." GROUP BY A.article_id" ." ORDER BY cnt DESC" ." LIMIT 5"; $result2 = SqlQuery($sql);*/ ?>