Ett oväntat fel inträffade: Unknown column 'ratio' in 'order clause'
SQL: /* soek ny */ SELECT /* index */ paper.url as purl, paper.id as pid, paper.shortname as pname, article.date as adate, article.link as alink, article.id as aid, article.title as atitle, article.description as adesc, paper.show_description as show_desc, article.date_unixtime AS date_unixtime, SUM(vote.weight) AS votes, COUNT(article.id) as artiklar_antal FROM article LEFT JOIN paper ON(paper.id = article.paperid) LEFT JOIN vote ON (vote.article = article.id) WHERE article.id IN (0,9978710,9978696,9965774,9949894,9949889,9937197,9934201,9934139,9915743,9911504,9905513,9900166,9886771,9864314,9864205,9853492,9841553,9841226,9841145,9840885,9840848,9840710,9840691,9840692,9840582) GROUP BY article.title ORDER BY ratio, adate DESC