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