rossetti@Wakatipu:~/door$ sqlite3 -column door_wordlist.db 'SELECT ratings_1.q3, articles.date, articles.title FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id ORDER BY ratings_1.q3 DESC LIMIT 10;'
0.800 2007-04-24 Henry Porter: Islam must condemn the chlorine bombers
0.798 2007-07-09 Australian police could get more time to hold terror s
0.780 2007-07-24 NZ climber dies in French Alps
0.779 2007-05-10 Russian writer finds being rebellious can be dangerous
0.735 2007-11-14 MacCormack: Nats stick to the script, shameless pork h
0.725 2007-05-28 Dead teenagers named
0.691 2007-08-14 Bomb Derails Train in Russia
0.688 2007-11-08 Finland mourns teen’s ‘revolution’ massacre
0.682 2007-02-03 Hundreds protest against new desalination plants in Sy
0.673 2007-10-10 Wines vie for awards