Clicks and 90 day survey responses

queries.sql

# (Below are the queries that generated these files, for my reference)

SELECT `247_response`. * , `247_contract`.`title` 
FROM `247_response` 
LEFT JOIN `247_contract` ON `247_response`.`contract_id` = `247_contract`.`contract_id` 
ORDER BY `response_id` DESC 

# ^ Survey Responses

SELECT `247_click`. * , `247_contract`.`title` 
FROM `247_click` 
LEFT JOIN `247_contract` ON `247_click`.`contract_id` = `247_contract`.`contract_id` 
ORDER BY `click_id` DESC 

# ^ Link Clicks