Query failed: MySQL client ran out of memory -> Query:
SELECT
CONCAT(measure_type , ' ' , measure_num) AS bill_num,
bill_tbl.session_year,
bill_tbl.session_num,
session_num,
CONCAT(bill_tbl.measure_type,' ',bill_tbl.measure_num) AS bill,
name AS lead_author,
t1.subject,
measure_state,
location_code_tbl.description AS location,
current_secondary_loc,
current_house,
current_status,
UNIX_TIMESTAMP(t1.bill_version_action_date) AS action_date,
bill_tbl.bill_id,
t1.vote_required,
t1.appropriation,
t1.fiscal_committee,
t1.local_program,
t1.urgency,
t1.taxlevy,
t1.bill_xml,
t1.substantive_changes,
t1.bill_version_action,
t1.version_num
FROM bill_version_tbl AS t1
JOIN bill_tbl ON t1.bill_id = bill_tbl.bill_id
JOIN bill_version_authors_tbl ON ( bill_version_authors_tbl.bill_version_id = bill_tbl.latest_bill_version_id and bill_version_authors_tbl.contribution = 'LEAD_AUTHOR' )
LEFT JOIN location_code_tbl ON location_code_tbl.location_code = bill_tbl.current_location
LEFT JOIN bill_version_tbl AS t2 ON (t1.bill_id = t2.bill_id AND t1.trans_update < t2.trans_update )
WHERE t2.bill_version_id IS NULL and
t1.bill_id = '200920107SB5'
