%entities; %constants; ]>

SELECT family_events.followid AS followid , family_events.intid AS intid , family_events.eid AS eid , family_events.e_mompid AS e_mompid , family_events.e_infantpid AS e_infantpid , family_events.e_sibpid AS e_sibpid , family_events.e_nonfocalpid AS e_nonfocalpid , family_events.date AS date , family_events.time AS time , family_events.mom AS mom , family_events.infant AS infant , family_events.infant2 AS infant2 , family_events.sib AS sib , family_events.sib2 AS sib2 , family_events.behavior AS behavior , family_events.position AS position , family_events.uncertain AS uncertain

, family_events.e_mom AS e_mom , family_events.e_mompart AS e_mompart , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_eats.foodpart ELSE NULL END AS e_mom_foodpart , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_eats.foodkind ELSE NULL END AS e_mom_foodkind , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_fished.foodpart ELSE NULL END AS e_mom_fishpart , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_fished.foodkind ELSE NULL END AS e_mom_fishkind , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_fished.result ELSE NULL END AS e_mom_fishresult , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_vocs.vocalization ELSE NULL END AS e_mom_voc , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_plays.play ELSE NULL END AS e_mom_play , CASE WHEN family_events.e_mom IS NOT NULL THEN mom_rests.rest ELSE NULL END AS e_mom_rest

, family_events.e_infant AS e_infant , family_events.e_infantpart AS e_infantpart , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_eats.foodpart ELSE NULL END AS e_infant_foodpart , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_eats.foodkind ELSE NULL END AS e_infant_foodkind , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_fished.foodpart ELSE NULL END AS e_infant_fishpart , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_fished.foodkind ELSE NULL END AS e_infant_fishkind , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_fished.result ELSE NULL END AS e_infant_fishresult , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_vocs.vocalization ELSE NULL END AS e_infant_voc , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_plays.play ELSE NULL END AS e_infant_play , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_rides.ride ELSE NULL END AS e_infant_ride , CASE WHEN family_events.e_infant IS NOT NULL THEN inf_rests.rest ELSE NULL END AS e_infant_rest

, family_events.e_sib as e_sib , family_events.e_sibpart AS e_sibpart , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_eats.foodpart ELSE NULL END AS e_sib_foodpart , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_eats.foodkind ELSE NULL END AS e_sib_foodkind , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_fished.foodpart ELSE NULL END AS e_sib_fishpart , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_fished.foodkind ELSE NULL END AS e_sib_fishkind , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_fished.result ELSE NULL END AS e_sib_fishresult , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_vocs.vocalization ELSE NULL END AS e_sib_voc , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_plays.play ELSE NULL END AS e_sib_play , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_rides.ride ELSE NULL END AS e_sib_ride , CASE WHEN family_events.e_sib IS NOT NULL THEN sib_rests.rest ELSE NULL END AS e_sib_rest

, family_events.e_nonfocal AS e_nonfocal , family_events.e_nonfocalpart as e_nonfocalpart , family_events.e_baboon AS e_baboon , family_events.e_baboonpart AS e_baboonpart , family_events.e_comment AS e_comment , family_events.i_comment AS i_comment

FROM family_events LEFT OUTER JOIN vocs AS mom_vocs ON (mom_vocs.eid = family_events.eid AND family_events.e_mom IS NOT NULL) LEFT OUTER JOIN plays AS mom_plays ON (mom_plays.eid = family_events.eid AND family_events.e_mom IS NOT NULL) LEFT OUTER JOIN rests AS mom_rests ON (mom_rests.eid = family_events.eid AND family_events.e_mom IS NOT NULL) LEFT OUTER JOIN eats AS mom_eats ON (mom_eats.eid = family_events.eid AND family_events.e_mom IS NOT NULL) LEFT OUTER JOIN fished AS mom_fished ON (mom_fished.eid = family_events.eid AND family_events.e_mom IS NOT NULL) LEFT OUTER JOIN vocs AS inf_vocs ON (inf_vocs.eid = family_events.eid AND family_events.e_infant IS NOT NULL) LEFT OUTER JOIN plays AS inf_plays ON (inf_plays.eid = family_events.eid AND family_events.e_infant IS NOT NULL) LEFT OUTER JOIN rides AS inf_rides ON (inf_rides.eid = family_events.eid AND family_events.e_infant IS NOT NULL) LEFT OUTER JOIN rests AS inf_rests ON (inf_rests.eid = family_events.eid AND family_events.e_infant IS NOT NULL) LEFT OUTER JOIN eats AS inf_eats ON (inf_eats.eid = family_events.eid AND family_events.e_infant IS NOT NULL) LEFT OUTER JOIN fished AS inf_fished ON (inf_fished.eid = family_events.eid AND family_events.e_infant IS NOT NULL) LEFT OUTER JOIN vocs AS sib_vocs ON (sib_vocs.eid = family_events.eid AND family_events.e_sib IS NOT NULL) LEFT OUTER JOIN plays AS sib_plays ON (sib_plays.eid = family_events.eid AND family_events.e_sib IS NOT NULL) LEFT OUTER JOIN rides AS sib_rides ON (sib_rides.eid = family_events.eid AND family_events.e_sib IS NOT NULL) LEFT OUTER JOIN rests AS sib_rests ON (sib_rests.eid = family_events.eid AND family_events.e_sib IS NOT NULL) LEFT OUTER JOIN eats AS sib_eats ON (sib_eats.eid = family_events.eid AND family_events.e_sib IS NOT NULL) LEFT OUTER JOIN fished AS sib_fished ON (sib_fished.eid = family_events.eid AND family_events.e_sib IS NOT NULL);

The DATASHEET_EVENTS view ER diagram intentionally omitted due to query size.