title: Use order by DESC and ASC with Group By
body: <p>Here is my sql statement</p>
  
  <pre><code> SELECT DISTINCT article_categories.category_id, 
     article_id,article_title,article_intro,article_content,
     category_name_ar 
   FROM articles,article_categories 
   WHERE articles.category_id=article_categories.category_id 
     AND article_type='admin' 
     AND category_case='active' 
   GROUP BY article_categories.category_id 
   ORDER BY article_categories.category_id ASC,
            article_date,article_time DESC 
   LIMIT 10
  </code></pre>
  
  <p>I would like to retrieve the first DISTINCT 10 categories. In addition I would like to retrieve the equivalent articles where the articles.category_id equals article_categories.category_id. So far the result is good but what I am looking for is to order the result by category_id and in the same time order the result by the article_date,article_time DESC.</p>
  
  <p>Any assistance will be appreciated in advance </p>