select * FROM

content_type_venue

/* association table*/
LEFT JOIN content_field_event_ref_venue
ON content_field_event_ref_venue.field_event_ref_venue_nid = content_type_venue.nid

/* join the event to the association tab;e*/
LEFT JOIN node n_event
ON n_event.nid = content_field_event_ref_venue.nid

/* load event table */
LEFT JOIN event event
ON event.nid = n_event.nid

WHERE (
content_type_venue.field_venue_status_value='1'
AND
content_type_venue.field_venue_livewire_yesno_value='1'
AND
event.nid is not null
)