Subversion Repositories computer_asset_manager_v1

select 

   backups_run.* 

from 

   backups_run 

   join backups using( backups_id) 

   join device using (device_id) 

where 

   device.name like '%lakewood%'  

   and report_date >= 20160709;