SELECT h_a_w.*, hatch_n.*, h_a_s_d.*, h_a_e_d.*, h_a_no.*, h_a_nat.*, h_a_t.*, h_a_f_s.*, h_a_f.*, f_i.*, i_i.*, f_insect.*, f_fly.filename AS fly_img, node_fly.title AS fly_title, node_fly.nid AS fly_nid, w_node.title AS w_title, w_node.created AS w_created, w_node.nid AS w_nid, node_insect.title AS insect_title, i_s.field_insect_stage_value AS insect_stage, hatch_n.nid AS hid
FROM
{users} u
LEFT OUTER JOIN {field_data_field_user_waters} u_w ON u.uid = u_w.entity_id
LEFT OUTER JOIN {node} w_node ON u_w.field_user_waters_nid = w_node.nid
LEFT OUTER JOIN {field_data_field_hatch_alert_water} h_a_w ON u_w.field_user_waters_nid = h_a_w.field_hatch_alert_water_nid
LEFT OUTER JOIN {node} hatch_n ON h_a_w.entity_id  = hatch_n.nid
LEFT OUTER JOIN {field_data_field_hatch_alert_start_date} h_a_s_d ON h_a_w.entity_id = h_a_s_d.entity_id
LEFT OUTER JOIN {field_data_field_hatch_alert_end_date} h_a_e_d ON h_a_w.entity_id = h_a_e_d.entity_id
LEFT OUTER JOIN {field_data_body} h_a_no ON h_a_w.entity_id = h_a_no.entity_id
LEFT OUTER JOIN {field_data_field_hatch_alert_natural} h_a_nat ON h_a_w.entity_id = h_a_nat.entity_id
LEFT OUTER JOIN {field_data_field_hatch_alert_type} h_a_t ON h_a_w.entity_id = h_a_t.entity_id
LEFT OUTER JOIN {field_data_field_hatch_alert_fly_size} h_a_f_s ON h_a_w.entity_id = h_a_f_s.entity_id
LEFT OUTER JOIN {field_data_field_hatch_alert_fly} h_a_f ON h_a_w.entity_id = h_a_f.entity_id
LEFT OUTER JOIN {field_data_field_fly_image} f_i ON h_a_f.field_hatch_alert_fly_nid = f_i.entity_id
LEFT OUTER JOIN {file_managed} f_fly ON f_i.field_fly_image_fid  = f_fly.fid
LEFT OUTER JOIN {node} node_fly ON h_a_f.field_hatch_alert_fly_nid = node_fly.nid
LEFT OUTER JOIN {field_data_field_hatch_alert_natural} h_a_nat_2 ON h_a_w.entity_id = h_a_nat.entity_id
LEFT OUTER JOIN {field_data_field_insect_image} i_i ON h_a_nat.field_hatch_alert_natural_nid = i_i.entity_id
LEFT OUTER JOIN {field_data_field_insect_stage} i_s ON h_a_nat.field_hatch_alert_natural_nid = i_s.entity_id
LEFT OUTER JOIN {file_managed} f_insect ON i_i.field_insect_image_fid = f_insect.fid
LEFT OUTER JOIN {node} node_insect ON h_a_nat.field_hatch_alert_natural_nid = node_insect.nid
WHERE  (u.uid = '8') AND (hatch_n.uid = '8') AND (h_a_e_d.field_hatch_alert_end_date_value > '2012-02-06T00:00:00-08:00')