snoyes

SELECT 
  article_id,
  sum_votes, 
  avg_rating
FROM 
  articles_tagged AS at
  JOIN articles USING (article_id)
WHERE 
  tag_name = 'linux'
  AND published = 'Yes' 
  AND enabled = 'Yes'
ORDER BY avg_rating DESC, sum_votes DESC