SELECT i.incident_id, i.inc_report_number, isupp.supp_agency_code "AGNCY_CD_AGENCY_CODE", i.report_date, i.start_date, i.end_date, isupp.isc_status_code "STATUS", isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, i.summary, a.address_id, a.street_number, a.dirct_cd_direction_code, a.street_name, a.street_cd_street_type_code, a.addr_sc_address_subtype_code, a.sub_number, a.beat, a.sub_beat, a.city, a.state_cd_state_code, a.zip5, a.zip4, a.latitude, a.longitude, a.geo_city, i.internal_incident, v.vehicle_id, v.vma_vehicle_make_code, v.vmo_vehicle_model_code, v.vst_vehicle_style_code, v.YEAR, v.vtc_type_code, vd.lic_type_code, vd.lic_state_code, vd.lic_year, vd.lic_number, vd.misc_id, iv.role_code, iv.status_code, iv.date_recovered, a.cnty_cd_county_code, a.intrsect1_street_number, a.intrsect1_dir, a.intrsect1_name, a.intrsect1_street_type_code, a.intrsect1_dir_suffix, a.direct_suffix FROM vehicles v, incident_vehicles iv, vehicle_descriptions vd, addresses a, incidents i, incident_supplements isupp WHERE isupp.inc_incident_id = i.incident_id AND iv.incident_id = i.incident_id AND iv.supp_seq = isupp.supp_seq AND v.vehicle_id = iv.vehicle_id AND vd.vehicle_id = v.vehicle_id AND iv.address_id = a.address_id AND vd.date_of_info <= iv.date_recovered