SELECT DISTINCT(node.nid) AS nid,
   node.title AS node_title,
   node_data_field_event_year.field_event_year_value AS node_data_field_event_year_field_event_year_value,
   node_data_field_event_year.nid AS node_data_field_event_year_nid,
   node_node_data_field_performance_date.type AS node_node_data_field_performance_date_type
 FROM node node 
 LEFT JOIN content_field_performance_date node_data_field_performance_date ON node.vid = node_data_field_performance_date.vid
 LEFT JOIN node node_node_data_field_performance_date ON node_data_field_performance_date.field_performance_date_nid = node_node_data_field_performance_date.nid
 LEFT JOIN content_field_event_year node_data_field_event_year ON node_node_data_field_performance_date.vid = node_data_field_event_year.vid
 WHERE (node.status <> 0)
 AND (node.type in ('artist'))
 AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_event_year.field_event_year_value, '%Y-%m-%dT%T'), '%Y') <= '2000' AND DATE_FORMAT(STR_TO_DATE(node_data_field_event_year.field_event_year_value, '%Y-%m-%dT%T'), '%Y') >= '2000'))