SELECT node.nid AS nid,
   node_data_field_name.field_name_value AS node_data_field_name_field_name_value,
   node_node_data_field_athlete.nid AS node_node_data_field_athlete_nid,
   node_node_data_field_athlete.type AS node_node_data_field_athlete_type,
   node_node_data_field_athlete.vid AS node_node_data_field_athlete_vid,
   node_data_field_name.field_height_value AS node_data_field_name_field_height_value,
   node_data_field_name.field_jersey_value AS node_data_field_name_field_jersey_value,
   node_data_field_name.field_position_value AS node_data_field_name_field_position_value,
   node_data_field_name.field_handed_value AS node_data_field_name_field_handed_value,
   node_data_field_gp.field_gp_value AS node_data_field_gp_field_gp_value,
   node_users.nid AS node_users_nid,
   node_users.type AS node_users_type,
   node_users.vid AS node_users_vid,
   node_data_field_gp.field_goals_value AS node_data_field_gp_field_goals_value,
   node_data_field_gp.field_ppg_value AS node_data_field_gp_field_ppg_value,
   node_data_field_gp.field_pims_value AS node_data_field_gp_field_pims_value,
   node_data_field_gp.field_points_value AS node_data_field_gp_field_points_value,
   node_data_field_gp.field_shg_value AS node_data_field_gp_field_shg_value
 FROM node node
 LEFT JOIN content_field_athlete node_data_field_athlete ON node.vid = node_data_field_athlete.vid
 LEFT JOIN node node_node_data_field_athlete ON node_data_field_athlete.field_athlete_nid = node_node_data_field_athlete.nid
 INNER JOIN users users ON node.uid = users.uid
 LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'stats'
 INNER JOIN content_field_season node_data_field_season ON node.vid = node_data_field_season.vid
 LEFT JOIN content_field_season node_data_field_season_value_0 ON node_users.vid = node_data_field_season_value_0.vid AND node_data_field_season_value_0.field_season_nid = '57'
 LEFT JOIN content_field_team node_data_field_team ON node.vid = node_data_field_team.vid
 LEFT JOIN content_type_athlete node_data_field_name ON node_node_data_field_athlete.vid = node_data_field_name.vid
 LEFT JOIN content_type_stats node_data_field_gp ON node_users.vid = node_data_field_gp.vid
 WHERE (node.status <> 0) AND (node.type in ('roster')) AND (node_data_field_season.field_season_nid = '57') AND (node_data_field_season_value_0.field_season_nid = '57') AND (node_data_field_team.field_team_nid = 536)