SELECT `articles`.*, `priorities`.position
FROM `articles`
LEFT OUTER JOIN `priorities` ON priorities.article_id = articles.id
WHERE (`articles`.`status` = 1)
ORDER BY priorities.position ASC, created_at DESC LIMIT 0, 20