: SELECT articles.* FROM rel_cat_art LEFT OUTER JOIN articles ON rel_cat_art.article_id=articles.article_id WHERE cat_id='1' ORDER by article_counter DESC;.