10 articles from the last month containing the phrase `climate change’ with the highest `fear’ rating.
rossetti@Wakatipu:~/door$ sqlite3 door_wordlist.db "SELECT ratings_1.q3, articles.title FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id where articles.date_utc > date(2008-5-7) AND articles.content LIKE '%climate change%' ORDER BY ratings_1.q3 DESC LIMIT 10;"
0.685783020643|Blogwatch: the La Nina situation
0.488184223473|White House thaws over polar bear
0.47334045077|Your Views: Â What MPs drive
0.467275269602|More than a billion trees planted this year: UN
0.459957990744|Water plan speech not criticism, says Treasury boss
0.455275970518|Millions of 'climate change migrants' will overwhelm Europe, says report
0.453333437261|Norway to show US global warming affect on Arctic islands
0.45237335196|'Out of ideas' - PM fails to catch Labor
0.445142297835|NZ forests falling
0.443097177169|River report points to dam trouble
And results for the word `weather’
0.546797083867|Climate change set to erode house values
0.483457646351|Photos: First snow brings chaos to London, across Europe
0.476200389826|Wild weather chaos in New South Wales
0.469760177924|Flood emergency eases in Hunter Valley
0.433045967141|Premier confident of power availability
0.424738123771|Black ice in south, gale warning for north
0.423129126153|Two dead in European mudslides, floods: reports
0.4219486054|Pasha report blames poor seamanship
0.414978076786|Bad weather: more ships issue distress calls
0.413745027142|Rare Snowstorm