Google Correlate
Instructions

Export data from Mysql and correlate with Google Correlate: 

1. Run query
2. In Sequel Pro click on the sprocket icon below the results pane and select "export results".
3. Save as a csv file.
4. Important: you will need to go into a text editor or Excel and make sure that the first row of your exported data is a date and value. It must NOT be titles for the columns. 
4. Go to: http://www.google.com/trends/correlate/ and select "Enter your own data" next to the search field
5. Click "choose file" and select your file, give it a moment to load.
6. Enter a name for the Time Series.
7. Hit Search.


https://docs.google.com/spreadsheet/ccc?key=0AiOWmapLqW9hdE5NWWY0cE5lTWQ5VDljaWRab1ZyblE&hl=en_US#gid=1

SELECT DATE_FORMAT(cout, '%Y-%m-%d') as cout, count(barcode) FROM inraw WHERE (title LIKE '%Toy Story%' OR subj LIKE '%Toy Story%' ) AND YEAR(cout) > '2005' GROUP BY DATE_FORMAT(cout, '%Y-%m-%d');

SELECT DATE_FORMAT(cout, '%Y-%m-%d') AS checkoutDate, count(barcode) FROM inraw WHERE (title LIKE '%olympics%' OR subj LIKE '%olympics%') AND YEAR(cout) > '2005' GROUP BY DATE_FORMAT(cout, '%Y-%m-%d');