SELECT base_table.vid AS vid, base_table.nid AS nid
FROM
node base_table
INNER JOIN node_field_data node_field_data ON node_field_data.nid = base_table.nid
INNER JOIN node__field_event_tags node__field_event_tags ON node__field_event_tags.entity_id = base_table.nid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data ON taxonomy_term_data.tid = node__field_event_tags.field_event_tags_target_id
INNER JOIN taxonomy_term_field_data taxonomy_term_field_data ON taxonomy_term_field_data.tid = taxonomy_term_data.tid
LEFT JOIN node__field_event_audience node__field_event_audience ON node__field_event_audience.entity_id = base_table.nid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = node__field_event_audience.field_event_audience_target_id
LEFT JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = taxonomy_term_data_?.tid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = node__field_event_audience.field_event_audience_target_id
LEFT JOIN taxonomy_term__parent taxonomy_term__parent ON taxonomy_term__parent.entity_id = taxonomy_term_data_?.tid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = taxonomy_term__parent.parent_target_id
LEFT JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = taxonomy_term_data_?.tid
INNER JOIN node_field_data node_field_data_? ON node_field_data_?.nid = base_table.nid
INNER JOIN node__field_event_tags node__field_event_tags_? ON node__field_event_tags_?.entity_id = base_table.nid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = node__field_event_tags_?.field_event_tags_target_id
INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_? ON taxonomy_term_field_data_?.tid = taxonomy_term_data_?.tid
INNER JOIN node_field_data node_field_data_? ON node_field_data_?.nid = base_table.nid
INNER JOIN node__field_event_audience node__field_event_audience_? ON node__field_event_audience_?.entity_id = base_table.nid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = node__field_event_audience_?.field_event_audience_target_id
INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_? ON taxonomy_term_field_data_?.tid = taxonomy_term_data_?.tid
INNER JOIN node__field_event_audience node__field_event_audience_? ON node__field_event_audience_?.entity_id = base_table.nid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = node__field_event_audience_?.field_event_audience_target_id
INNER JOIN taxonomy_term__parent taxonomy_term__parent_? ON taxonomy_term__parent_?.entity_id = taxonomy_term_data_?.tid
LEFT OUTER JOIN taxonomy_term_data taxonomy_term_data_? ON taxonomy_term_data_?.tid = taxonomy_term__parent_?.parent_target_id
INNER JOIN taxonomy_term_field_data taxonomy_term_field_data_? ON taxonomy_term_field_data_?.tid = taxonomy_term_data_?.tid
INNER JOIN node_field_data node_field_data_? ON node_field_data_?.nid = base_table.nid
INNER JOIN node_field_data node_field_data_? ON node_field_data_?.nid = base_table.nid
WHERE ((node_field_data.status = :db_condition_placeholder_?) AND (taxonomy_term_field_data.name LIKE :db_condition_placeholder_? ESCAPE ?) AND ((taxonomy_term_data_?.uuid IN (:db_condition_placeholder_?)) OR (taxonomy_term_data_?.uuid IN (:db_condition_placeholder_?)))) AND (node_field_data_?.status = :db_condition_placeholder_?) AND (taxonomy_term_field_data_?.status = :db_condition_placeholder_?) AND (node_field_data_?.status = :db_condition_placeholder_?) AND (taxonomy_term_field_data_?.status = :db_condition_placeholder_?) AND (taxonomy_term_field_data_?.status = :db_condition_placeholder_?) AND (node_field_data_?.status = :db_condition_placeholder_?) AND (node_field_data_?.type = :db_condition_placeholder_?)
GROUP BY base_table.vid, base_table.nid
LIMIT ? OFFSET ?