From 924251897a538d22eb074716dd8edf6b13c7ae0f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 15 Oct 2025 01:38:45 +0000 Subject: [PATCH] Adjustments to the conversion to avoid loading of bad data Loads 2025-03-31 data dump. Up through conversion problem #54. --- conversion/clean.sql | 9 + conversion/load_biography.sql | 3 + conversion/load_community_membership.sql | 247 ++ conversion/load_follow_arrival.m4 | 3689 ++++++++++++++++++++++ conversion/load_follow_to_follows.sql | 112 +- 5 files changed, 4059 insertions(+), 1 deletion(-) diff --git a/conversion/clean.sql b/conversion/clean.sql index 37fdd4e..1fb885a 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -241,6 +241,15 @@ UPDATE follow -- Update the follow_arrival.fa_type_of_cycle -- +-- Females are not allowed to have a n/a code +-- Problem #50 +UPDATE follow_arrival + SET fa_type_of_cycle = '0' + FROM biography + WHERE follow_arrival.fa_type_of_cycle = 'NA' + AND biography.b_animid = follow_arrival.fa_b_arr_animid + AND biography.b_sex = 'F'; + -- There must be no NULL fa_type_of_cycle values. Problem #42. UPDATE follow_arrival SET fa_type_of_cycle = 'MISS' diff --git a/conversion/load_biography.sql b/conversion/load_biography.sql index bda92a2..03b6468 100644 --- a/conversion/load_biography.sql +++ b/conversion/load_biography.sql @@ -85,6 +85,9 @@ INSERT INTO biography_data( -- Discard b_departdateerror , b_departtype FROM clean.biography + + WHERE b_animid <> 'KAZ' + ; ANALYZE biography_data; diff --git a/conversion/load_community_membership.sql b/conversion/load_community_membership.sql index 52abc2c..80ae867 100644 --- a/conversion/load_community_membership.sql +++ b/conversion/load_community_membership.sql @@ -37,6 +37,253 @@ INSERT INTO comm_membs ( , cm_start_source , cm_end_source FROM community_membership + +WHERE +-- Problem #13 + cm_b_animid NOT IN ( + 'AL' +, 'AME' +, 'AND' +, 'AO' +, 'AP' +, 'APB1' +, 'APL' +, 'AQ' +, 'AR' +, 'ARI' +, 'BAL' +, 'BAS' +, 'BB' +, 'BH' +, 'BHA' +, 'BIB' +, 'BIMB1' +, 'BN' +, 'BRB' +, 'BRZ' +, 'CAD' +, 'CD1' +, 'CF' +, 'CHI' +, 'CL' +, 'CN' +, 'COC' +, 'CT' +, 'CT' +, 'DB' +, 'DBB1' +, 'DH' +, 'DIA' +, 'DL' +, 'DLB1' +, 'DM' +, 'DP' +, 'DUK' +, 'DYL' +, 'EBO' +, 'ECO' +, 'EDE' +, 'EDEB1' +, 'EME' +, 'EOW' +, 'ERI' +, 'ESP' +, 'EZA' +, 'FAD' +, 'FAH' +, 'FAL' +, 'FAM' +, 'FAN' +, 'FAT' +, 'FAY' +, 'FD' +, 'FED' +, 'FFT' +, 'FGO' +, 'FI' +, 'FIC' +, 'FIT' +, 'FLI' +, 'FLW' +, 'FLWB1' +, 'FM' +, 'FN' +, 'FNBABY' +, 'FND' +, 'FO' +, 'FOK' +, 'FOR' +, 'FR' +, 'FS' +, 'FT' +, 'FU' +, 'FUK' +, 'FUR' +, 'FUT' +, 'FX' +, 'GAB' +, 'GAB2' +, 'GAB3' +, 'GAL' +, 'GAN' +, 'GB' +, 'GD' +, 'GD1' +, 'GDL' +, 'GGL' +, 'GIM' +, 'GIZ' +, 'GL' +, 'GLA' +, 'GLD' +, 'GLI' +, 'GLIB1' +, 'GLO' +, 'GM' +, 'GMB1' +, 'GN' +, 'GO' +, 'GOD' +, 'GOM' +, 'GOS' +, 'GR' +, 'GRE' +, 'GT' +, 'GY' +, 'HA' +, 'HAP' +, 'HAZBABY' +, 'HB' +, 'HOB1' +, 'HP' +, 'ILA' +, 'ILO' +, 'IMA' +, 'IMAB1' +, 'IMAB2' +, 'IPO' +, 'JE' +, 'JFB1' +, 'JK' +, 'KAZ' +, 'KEA' +, 'KEAB1' +, 'KIG' +, 'KIN' +, 'KN' +, 'KOB' +, 'KOC' +, 'KOM' +, 'KR' +, 'KS' +, 'KUR' +, 'LAM' +, 'LIN' +, 'LO' +, 'LOL' +, 'LON' +, 'LORB1' +, 'LOSB1' +, 'LTT' +, 'MAI' +, 'MAKB2' +, 'MAL' +, 'MAM' +, 'MAU' +, 'MAY' +, 'ME' +, 'MER' +, 'MG' +, 'MIS' +, 'MIT' +, 'MKWB1' +, 'MLB2' +, 'MM' +, 'MO' +, 'MT' +, 'MU' +, 'MZ' +, 'MZB1' +, 'NJE' +, 'NT' +, 'NYO' +, 'OR' +, 'OT' +, 'PF' +, 'PIB1' +, 'PM' +, 'PMB1' +, 'PN' +, 'PSB1' +, 'PT' +, 'PX' +, 'RAFB2' +, 'RJ' +, 'RO' +, 'ROO' +, 'SA' +, 'SAF' +, 'SAL' +, 'SAM' +, 'SB1' +, 'SDB' +, 'SG' +, 'SG' +, 'SHA' +, 'SHO' +, 'SHU' +, 'SI' +, 'SIB1' +, 'SIR' +, 'SL' +, 'SN' +, 'SN1' +, 'SP' +, 'SPB1' +, 'SR' +, 'SR1' +, 'SS' +, 'SU' +, 'SV' +, 'SY' +, 'TAB' +, 'TB' +, 'TEM' +, 'TG' +, 'TI' +, 'TN' +, 'TOF' +, 'TOM' +, 'TT' +, 'TTB1' +, 'TUK' +, 'TUR' +, 'TZB1' +, 'TZB2' +, 'TZB3' +, 'TZN' +, 'VANB1' +, 'VIC' +, 'VIS' +, 'VL' +, 'WB' +, 'WEL' +, 'WF' +, 'YAM' +, 'YOY' +, 'ZEL' +, 'ZIN' +, 'ZS' +, 'ZUM' +) +AND +-- Problem #14 + cm_b_animid NOT IN ( +'MG' +, 'RO' +, 'WD' +) + -- Get a consistent ID generation ORDER BY cm_start_date, cm_end_date, cm_b_animid, cm_cl_community_id; diff --git a/conversion/load_follow_arrival.m4 b/conversion/load_follow_arrival.m4 index 0cbdb74..c89384c 100644 --- a/conversion/load_follow_arrival.m4 +++ b/conversion/load_follow_arrival.m4 @@ -47,6 +47,3695 @@ BEGIN FOR this_fa IN SELECT * FROM clean.follow_arrival + WHERE EXISTS -- Problem #43 + (SELECT 1 + FROM follows + WHERE follows.focal = follow_arrival.fa_fol_b_focal_animid + AND follows.date = follow_arrival.fa_fol_date) + AND NOT -- problem #41 + ((fa_fol_date = '1975-05-15' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SA') + OR (fa_fol_date = '1975-05-15' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '1982-08-31' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MM') + OR (fa_fol_date = '1988-10-26' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'GL') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2006-03-14' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2009-01-11' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'TB') + OR (fa_fol_date = '2011-12-26' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GA') + OR (fa_fol_date = '2011-12-26' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GGL')) + AND NOT -- Problem #44 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_entrydate > follow_arrival.fa_fol_date + -- order by biography.b_animid, follow_arrival.fa_fol_date; + ((fa_fol_date = '1973-01-04' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-09' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-26' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-29' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-29' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-01-29' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-01' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-03' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-04' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-05' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-07' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-11' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-14' + AND fa_fol_b_focal_animid = 'NV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-16' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-19' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-20' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-26' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-02-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-01' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-04' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-05' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-07' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-10' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-20' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-03-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-07' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-08' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'PL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'PS' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-19' + AND fa_fol_b_focal_animid = 'PS' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-20' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-20' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-24' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-04-25' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-01' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-02' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-03' + AND fa_fol_b_focal_animid = 'NV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-07' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-10' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-11' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-11' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-19' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-19' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-20' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-22' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-23' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-25' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-25' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-26' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-27' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-27' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-28' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-28' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-28' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-30' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-31' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-31' + AND fa_fol_b_focal_animid = 'HM' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-05-31' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-01' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-06' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-10' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-11' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-14' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-15' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-15' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-15' + AND fa_fol_b_focal_animid = 'PL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-17' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-17' + AND fa_fol_b_focal_animid = 'SH' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '1973-06-21' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'AP') + OR (fa_fol_date = '2005-12-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'BRZ') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1980-10-24' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1981-10-16' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-01-11' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1982-10-11' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'CT') + OR (fa_fol_date = '2004-06-13' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'EDE') + OR (fa_fol_date = '1974-05-30' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'GD1') + OR (fa_fol_date = '2011-07-10' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-10' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '1989-07-17' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KN') + OR (fa_fol_date = '2006-01-09' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2006-01-09' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2006-01-11' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2006-01-12' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'LOS') + OR (fa_fol_date = '2004-02-14' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-17' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-17' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-17' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-19' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-19' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-20' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2004-02-25' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAM') + OR (fa_fol_date = '2008-10-16' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'SAF') + OR (fa_fol_date = '2001-06-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SAM') + OR (fa_fol_date = '2001-06-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SAM') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1980-10-24' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-05-29' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-12' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-15' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1981-10-16' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-01-11' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-02' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1982-10-11' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '1984-05-03' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'SG') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '2004-08-26' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SHA') + OR (fa_fol_date = '1992-09-02' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SN1') + OR (fa_fol_date = '1992-09-03' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'SN1') + OR (fa_fol_date = '2012-10-07' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TAR') + OR (fa_fol_date = '2012-10-07' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TAR') + OR (fa_fol_date = '2012-10-07' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TAR') + OR (fa_fol_date = '2016-06-19' + AND fa_fol_b_focal_animid = 'MGF' + AND fa_b_arr_animid = 'VANB1')) + AND NOT -- Problem #46 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex <> 'F' + -- and follow_arrival.fa_type_of_cycle <> 'n/a' + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + -- Consistent error message + ((fa_fol_date = '1973-01-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'MGM') + OR (fa_fol_date = '1973-06-28' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'MK') + OR (fa_fol_date = '1973-08-21' + AND fa_fol_b_focal_animid = 'PL' + AND fa_b_arr_animid = 'MGM') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1984-03-11' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'SPB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-21' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-21' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-06-21' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'WN' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'WN' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-08' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-08-08' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-09-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-09-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-09-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-03' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-12' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-24' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-27' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-10-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-05' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-06' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-06' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-08' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-09' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-11' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '1988-11-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'JFB1') + OR (fa_fol_date = '2000-04-26' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-01' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-02' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-16' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-28' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-05-28' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-08' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2000-06-23' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'KIG') + OR (fa_fol_date = '2001-12-08' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'FO') + OR (fa_fol_date = '2007-01-02' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'GL') + OR (fa_fol_date = '2007-05-17' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'BIMB1') + OR (fa_fol_date = '2007-05-18' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'BIMB1') + OR (fa_fol_date = '2007-09-13' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-24' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-25' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-25' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-25' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-26' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-26' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-27' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-29' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-30' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LON') + OR (fa_fol_date = '2007-09-30' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-09-30' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-01' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-02' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-03' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-04' + AND fa_fol_b_focal_animid = 'MAK' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-06' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-06' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-06' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-08' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-09' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-09' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2007-10-10' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'SIB1') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'EDG') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'EDG') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'RUD') + OR (fa_fol_date = '2008-03-12' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'RUD') + OR (fa_fol_date = '2009-06-11' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-11' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-11' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-06-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-14' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-14' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-20' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-20' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-24' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-24' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-27' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-29' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-07-30' + AND fa_fol_b_focal_animid = 'TN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-12' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-18' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-08-28' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-01' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-01' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-11' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-09-18' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2009-10-07' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'MAKB2') + OR (fa_fol_date = '2010-11-05' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'SL') + OR (fa_fol_date = '2011-07-12' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'TZB1') + OR (fa_fol_date = '2011-07-12' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'TZB1') + OR (fa_fol_date = '2012-04-03' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '2012-10-30' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2015-07-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'IMAB2') + OR (fa_fol_date = '2016-06-19' + AND fa_fol_b_focal_animid = 'MGF' + AND fa_b_arr_animid = 'VANB1') + OR (fa_fol_date = '2016-06-28' + AND fa_fol_b_focal_animid = 'BAH' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-06-28' + AND fa_fol_b_focal_animid = 'BAH' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-06-30' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-06-30' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-02' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-03' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-03' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-04' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-04' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-07-14' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-08-01' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TZB3') + OR (fa_fol_date = '2016-08-01' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'TZB3')) + AND NOT -- Problem #47 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex = 'F' + -- and follow_arrival.fa_type_of_cycle = 'U' + -- and biography.b_birthdate + -- < (follow_arrival.fa_fol_date + -- - '5 years'::INTERVAL + -- ) + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1973-10-15' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'LO') + OR (fa_fol_date = '2016-10-09' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-09' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-11' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ESP') + OR (fa_fol_date = '2016-10-11' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ESP') + OR (fa_fol_date = '2016-10-11' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ESP') + OR (fa_fol_date = '2016-10-21' + AND fa_fol_b_focal_animid = 'GIM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-21' + AND fa_fol_b_focal_animid = 'GIM' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-23' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC') + OR (fa_fol_date = '2016-10-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'FIC')) + AND NOT -- Problem #48 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_departdate < follow_arrival.fa_fol_date + -- order by biography.b_animid, follow_arrival.fa_fol_date; + ((fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-01-09' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-09-29' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-09-29' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-11-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-11-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2014-12-22' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2015-04-08' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2015-04-08' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'AO') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '2003-08-10' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'AQ') + OR (fa_fol_date = '1986-01-02' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'CA') + OR (fa_fol_date = '1997-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'CF') + OR (fa_fol_date = '2005-02-19' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-02-19' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-02-19' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-08-03' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2005-08-24' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'EBO') + OR (fa_fol_date = '2016-05-10' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'EOW') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ERI') + OR (fa_fol_date = '2010-07-07' + AND fa_fol_b_focal_animid = 'LUC' + AND fa_b_arr_animid = 'EVA') + OR (fa_fol_date = '2012-05-18' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2012-05-18' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2012-05-18' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2013-11-28' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2013-11-28' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'FAM') + OR (fa_fol_date = '2016-10-03' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'FIT') + OR (fa_fol_date = '2017-01-16' + AND fa_fol_b_focal_animid = 'OTA' + AND fa_b_arr_animid = 'FIT') + OR (fa_fol_date = '2000-02-04' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'GD') + OR (fa_fol_date = '1986-04-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'GT') + OR (fa_fol_date = '1986-04-23' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'GT') + OR (fa_fol_date = '2016-04-06' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-01' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-20' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '2000-06-20' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'JK') + OR (fa_fol_date = '1994-03-06' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'KD') + OR (fa_fol_date = '1983-06-15' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '2013-08-13' + AND fa_fol_b_focal_animid = 'LOS' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-09-28' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-09-28' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-15' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-15' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-21' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-25' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-10-25' + AND fa_fol_b_focal_animid = 'AP' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-11-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-11-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-12-12' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-12-12' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2013-12-16' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-02-17' + AND fa_fol_b_focal_animid = 'YAM' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-08-19' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-10-27' + AND fa_fol_b_focal_animid = 'WEM' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-11-30' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2014-11-30' + AND fa_fol_b_focal_animid = 'MGA' + AND fa_b_arr_animid = 'LOD') + OR (fa_fol_date = '2003-06-16' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOL') + OR (fa_fol_date = '2003-06-16' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'LOL') + OR (fa_fol_date = '2015-06-29' + AND fa_fol_b_focal_animid = 'LOS' + AND fa_b_arr_animid = 'LOR') + OR (fa_fol_date = '2015-07-26' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'LTT') + OR (fa_fol_date = '2011-06-22' + AND fa_fol_b_focal_animid = 'LAM' + AND fa_b_arr_animid = 'LUC') + OR (fa_fol_date = '1995-09-03' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'ME') + OR (fa_fol_date = '1975-07-22' + AND fa_fol_b_focal_animid = 'GK' + AND fa_b_arr_animid = 'NV') + OR (fa_fol_date = '1998-02-23' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'PF') + OR (fa_fol_date = '1982-12-06' + AND fa_fol_b_focal_animid = 'LB' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1982-12-21' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '2014-07-17' + AND fa_fol_b_focal_animid = 'APL' + AND fa_b_arr_animid = 'RUD') + OR (fa_fol_date = '1998-08-19' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'SEF') + OR (fa_fol_date = '1998-08-19' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'SEF') + OR (fa_fol_date = '2015-10-12' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SIF') + OR (fa_fol_date = '2015-10-12' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'SIF') + OR (fa_fol_date = '1973-08-30' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '1973-08-30' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '1973-09-27' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '1973-09-28' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'STA') + OR (fa_fol_date = '2015-10-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2015-10-01' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2015-10-07' + AND fa_fol_b_focal_animid = 'IMA' + AND fa_b_arr_animid = 'TAB') + OR (fa_fol_date = '2015-11-27' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'TAB') + OR (fa_fol_date = '2015-11-27' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'TAB') + OR (fa_fol_date = '2015-12-07' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'TN') + OR (fa_fol_date = '2016-04-19' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'TN') + OR (fa_fol_date = '2014-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-11-01' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2014-11-03' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2016-02-06' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'TZN') + OR (fa_fol_date = '2002-01-09' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-04-28' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-07-01' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-07-07' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-07-16' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-08-18' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-09-08' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-10-14' + AND fa_fol_b_focal_animid = 'AQ' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2002-12-14' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-04-24' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-04-24' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-07-06' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-08-06' + AND fa_fol_b_focal_animid = 'VAN' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2003-09-09' + AND fa_fol_b_focal_animid = 'RUD' + AND fa_b_arr_animid = 'VID') + OR (fa_fol_date = '2001-05-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-18' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-19' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-20' + AND fa_fol_b_focal_animid = 'CD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-20' + AND fa_fol_b_focal_animid = 'CD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-21' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-22' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-22' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-23' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-28' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-28' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-05-28' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-06-04' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-06-04' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-01' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-01' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-14' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-07-15' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-08-15' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-08-15' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-05' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-05' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-05' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-10' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-10' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-24' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-24' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-24' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-25' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-27' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-28' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-29' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-09-30' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-01' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-01' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-10' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-10-10' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-04' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-12' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-13' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-15' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-16' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-17' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-19' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-21' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-22' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-24' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-27' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-28' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-28' + AND fa_fol_b_focal_animid = 'SW' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-02' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-22' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-23' + AND fa_fol_b_focal_animid = 'SIF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-24' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-25' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-26' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-12-27' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-05' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-06' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-06' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-06' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-07' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-07' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-07' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-10' + AND fa_fol_b_focal_animid = 'TB' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-11' + AND fa_fol_b_focal_animid = 'CD' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-12' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-13' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-14' + AND fa_fol_b_focal_animid = 'BE' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-16' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-18' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-19' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-19' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-19' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-20' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-01-25' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-19' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-19' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-20' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-20' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-25' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-25' + AND fa_fol_b_focal_animid = 'JF' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-02-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-03-07' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-03-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-03-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2002-11-24' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2003-01-20' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'WD') + OR (fa_fol_date = '2001-11-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WN') + OR (fa_fol_date = '2001-11-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WN') + OR (fa_fol_date = '2001-11-18' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'WN') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YAM') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YAM') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YOY') + OR (fa_fol_date = '2016-07-16' + AND fa_fol_b_focal_animid = 'FAN' + AND fa_b_arr_animid = 'YOY') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ZIN') + OR (fa_fol_date = '2013-10-12' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'ZIN')) + AND NOT -- Problem #49 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex = 'F' + -- and follow_arrival.fa_type_of_cycle = 'U' + -- and biography.b_birthdate + -- <= (follow_arrival.fa_fol_date + -- - '1 year'::INTERVAL + -- - '14 years'::INTERVAL + -- ) + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1973-05-06' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'GG') + OR (fa_fol_date = '1973-05-08' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-08' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-05-10' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'GG') + OR (fa_fol_date = '1973-05-13' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-14' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'AT') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'HG' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-05-16' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-05-17' + AND fa_fol_b_focal_animid = 'MK' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1973-05-18' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1973-05-21' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PL') + OR (fa_fol_date = '1973-05-23' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-05-24' + AND fa_fol_b_focal_animid = 'GK' + AND fa_b_arr_animid = 'DO') + OR (fa_fol_date = '1973-08-04' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'FF') + OR (fa_fol_date = '1973-08-04' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'WK') + OR (fa_fol_date = '1973-08-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1973-10-15' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'NP') + OR (fa_fol_date = '1973-10-16' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AT') + OR (fa_fol_date = '1973-10-16' + AND fa_fol_b_focal_animid = 'PS' + AND fa_b_arr_animid = 'PS') + OR (fa_fol_date = '1973-10-18' + AND fa_fol_b_focal_animid = 'SF' + AND fa_b_arr_animid = 'MB') + OR (fa_fol_date = '1973-10-20' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'AT') + OR (fa_fol_date = '1973-10-26' + AND fa_fol_b_focal_animid = 'FB' + AND fa_b_arr_animid = 'ML') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1985-06-10' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'SS') + OR (fa_fol_date = '1995-02-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '1995-02-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '1995-02-04' + AND fa_fol_b_focal_animid = 'PF' + AND fa_b_arr_animid = 'JF') + OR (fa_fol_date = '2001-07-14' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2001-10-23' + AND fa_fol_b_focal_animid = 'KS' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2001-10-24' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2001-10-25' + AND fa_fol_b_focal_animid = 'PX' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-04-29' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-04-29' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-04-29' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-09' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-10' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-12' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-12' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2002-11-24' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2003-08-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2003-11-15' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-18' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-20' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-20' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-20' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2003-11-21' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-10' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-01-12' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2004-01-12' + AND fa_fol_b_focal_animid = 'VIN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-02-20' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-02-20' + AND fa_fol_b_focal_animid = 'EDG' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-02-21' + AND fa_fol_b_focal_animid = 'FS' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-21' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-27' + AND fa_fol_b_focal_animid = 'VAN' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-29' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-07-30' + AND fa_fol_b_focal_animid = 'LOR' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-09-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-09-24' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2004-12-02' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'ECO') + OR (fa_fol_date = '2005-03-07' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'TG') + OR (fa_fol_date = '2005-05-25' + AND fa_fol_b_focal_animid = 'NAS' + AND fa_b_arr_animid = 'HO') + OR (fa_fol_date = '2005-06-08' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'BAH') + OR (fa_fol_date = '2005-07-11' + AND fa_fol_b_focal_animid = 'NUR' + AND fa_b_arr_animid = 'HO') + OR (fa_fol_date = '2005-07-12' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2005-07-30' + AND fa_fol_b_focal_animid = 'KP' + AND fa_b_arr_animid = 'PI') + OR (fa_fol_date = '2005-07-30' + AND fa_fol_b_focal_animid = 'KP' + AND fa_b_arr_animid = 'PI') + OR (fa_fol_date = '2005-08-21' + AND fa_fol_b_focal_animid = 'SR' + AND fa_b_arr_animid = 'BAH') + OR (fa_fol_date = '2006-09-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LUC') + OR (fa_fol_date = '2006-09-23' + AND fa_fol_b_focal_animid = 'KON' + AND fa_b_arr_animid = 'LUC') + OR (fa_fol_date = '2009-07-10' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2009-07-18' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SI') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SI') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SI') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-12' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'SW') + OR (fa_fol_date = '2012-08-15' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'BAH') + OR (fa_fol_date = '2012-08-20' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MKW') + OR (fa_fol_date = '2012-08-20' + AND fa_fol_b_focal_animid = 'ZS' + AND fa_b_arr_animid = 'MKW') + OR (fa_fol_date = '2012-08-25' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '2012-09-06' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'TG') + OR (fa_fol_date = '2012-09-06' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'TG') + OR (fa_fol_date = '2012-09-08' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GM') + OR (fa_fol_date = '2012-09-18' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '2012-09-18' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-20' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '2012-09-22' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'MKW') + OR (fa_fol_date = '2013-09-27' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'NUR') + OR (fa_fol_date = '2014-01-07' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2014-01-07' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-04-13' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-05-01' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-05-01' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-05-17' + AND fa_fol_b_focal_animid = 'SI' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-05-18' + AND fa_fol_b_focal_animid = 'SL' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-06-22' + AND fa_fol_b_focal_animid = 'FU' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-06-25' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-08-22' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'MGF2') + OR (fa_fol_date = '2016-09-27' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-09' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-09' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF') + OR (fa_fol_date = '2016-11-10' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'MGF')) + AND NOT -- Problem #51 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- where follow_arrival.fa_data_source <> 'Tiki' + -- and follow_arrival.fa_data_source <> 'Tiki_Mom' + -- and follow_arrival.fa_data_source <> 'Tiki_ID' + -- and follow_arrival.fa_data_source <> 'Brec' + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1982-02-12' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-12' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-13' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-13' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-14' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-14' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-15' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-15' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-16' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-16' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-17' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-17' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-18' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-18' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-23' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-23' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-25' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-26' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-02-26' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-02' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-02' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-03' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-03' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-04' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-04' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-04' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-06' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-06' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-09' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-09' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-11' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-11' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-12' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-12' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-13' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-13' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-18' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-18' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-18' + AND fa_fol_b_focal_animid = 'MF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-19' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-20' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-22' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-22' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-23' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-23' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'FG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-24' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-25' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-27' + AND fa_fol_b_focal_animid = 'AL' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-28' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-28' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-28' + AND fa_fol_b_focal_animid = 'MU' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-29' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-03-30' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-05' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-05' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-08' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-09' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-10' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-10' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-04-10' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-05-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-05-09' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-05-09' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-05-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-05-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-11' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-14' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-17' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-17' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-19' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-20' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-20' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-06-27' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-05' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-19' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-20' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-20' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-27' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-29' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-29' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-29' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-29' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-29' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-30' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-30' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-30' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-07-30' + AND fa_fol_b_focal_animid = 'GG' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-01' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-01' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-12' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-14' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-17' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-17' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-08-17' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-10' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-17' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-17' + AND fa_fol_b_focal_animid = 'ST' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-17' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-19' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-19' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-20' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-20' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-22' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-23' + AND fa_fol_b_focal_animid = 'EV' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-24' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-25' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-09-25' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-01' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-01' + AND fa_fol_b_focal_animid = 'WK' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-04' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-07' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-07' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-07' + AND fa_fol_b_focal_animid = 'PI' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-09' + AND fa_fol_b_focal_animid = 'PM' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-11' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-11' + AND fa_fol_b_focal_animid = 'AT' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-14' + AND fa_fol_b_focal_animid = 'JJ' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-10-16' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-16' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-10-16' + AND fa_fol_b_focal_animid = 'SS' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-11-10' + AND fa_fol_b_focal_animid = 'FF' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-12-06' + AND fa_fol_b_focal_animid = 'LB' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '1982-12-09' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'PX') + OR (fa_fol_date = '1982-12-21' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'KR') + OR (fa_fol_date = '2008-07-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GAB2') + OR (fa_fol_date = '2008-07-21' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GAB3') + OR (fa_fol_date = '2008-07-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GAB2') + OR (fa_fol_date = '2008-07-22' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GAB3') + OR (fa_fol_date = '2008-07-23' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GAB2') + OR (fa_fol_date = '2008-07-23' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GAB3') + OR (fa_fol_date = '2008-07-23' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GAB2') + OR (fa_fol_date = '2008-07-23' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GAB3') + OR (fa_fol_date = '2011-07-11' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-13' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-14' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-15' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-16' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-07-17' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-06' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-06' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-07' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-07' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-12' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-13' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-14' + AND fa_fol_b_focal_animid = 'TG' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-16' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-16' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-16' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-19' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-08-19' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-06' + AND fa_fol_b_focal_animid = 'TZN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-06' + AND fa_fol_b_focal_animid = 'TZN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-12' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-12' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-13' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-14' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-14' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-14' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-15' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-16' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-18' + AND fa_fol_b_focal_animid = 'FAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-22' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-23' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-23' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-23' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-23' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-25' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-25' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-26' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-26' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-30' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-30' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-09-30' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-01' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-02' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-02' + AND fa_fol_b_focal_animid = 'MAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-02' + AND fa_fol_b_focal_animid = 'SN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-07' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-07' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-07' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-07' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-08' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-09' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-09' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-09' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-10' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-11' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-11' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-11' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-11' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-11' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-11' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-12' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-14' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-15' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-16' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-16' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-16' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-17' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-17' + AND fa_fol_b_focal_animid = 'FAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-20' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-20' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-21' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-21' + AND fa_fol_b_focal_animid = 'SA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-21' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-22' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-22' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-22' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-22' + AND fa_fol_b_focal_animid = 'DL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-22' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-22' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-24' + AND fa_fol_b_focal_animid = 'FN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-25' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-25' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-27' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-27' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-27' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-10-27' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-07' + AND fa_fol_b_focal_animid = 'FAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-07' + AND fa_fol_b_focal_animid = 'FD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-08' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-11' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-11' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-12' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-12' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-12' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-12' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-13' + AND fa_fol_b_focal_animid = 'TZN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-13' + AND fa_fol_b_focal_animid = 'TZN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-17' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-17' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-18' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-18' + AND fa_fol_b_focal_animid = 'FE' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-22' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-22' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-22' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-23' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-23' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-23' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-24' + AND fa_fol_b_focal_animid = 'EOW' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-24' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-24' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-24' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-24' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-25' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-26' + AND fa_fol_b_focal_animid = 'MKW' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-26' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-26' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-26' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-27' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-28' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-28' + AND fa_fol_b_focal_animid = 'SAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-29' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-30' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-11-30' + AND fa_fol_b_focal_animid = 'TOM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-05' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-07' + AND fa_fol_b_focal_animid = 'TN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-07' + AND fa_fol_b_focal_animid = 'TN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-07' + AND fa_fol_b_focal_animid = 'TN' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-08' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-09' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-09' + AND fa_fol_b_focal_animid = 'TZ' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-09' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-14' + AND fa_fol_b_focal_animid = 'FAM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'AO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-15' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-17' + AND fa_fol_b_focal_animid = 'GA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-18' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-19' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-21' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-21' + AND fa_fol_b_focal_animid = 'GLI' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2011-12-26' + AND fa_fol_b_focal_animid = 'GLD' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-01' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-01' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-01' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-01' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-05' + AND fa_fol_b_focal_animid = 'FO' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-14' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-14' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-14' + AND fa_fol_b_focal_animid = 'SDB' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-15' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-15' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-15' + AND fa_fol_b_focal_animid = 'ZEL' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-16' + AND fa_fol_b_focal_animid = 'RUM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-17' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-17' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-17' + AND fa_fol_b_focal_animid = 'EZA' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-17' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-18' + AND fa_fol_b_focal_animid = 'GM' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-20' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1') + OR (fa_fol_date = '2012-01-20' + AND fa_fol_b_focal_animid = 'FND' + AND fa_b_arr_animid = 'GLIB1')) + AND NOT -- Problem #53 + fa_b_arr_animid IN ('AMA', 'OBE', 'UWE') + AND NOT -- Problem #13 + fa_b_arr_animid = 'KAZ' + AND NOT -- Problem #54 + -- select follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid + -- from clean.follow_arrival + -- join clean.biography + -- on (biography.b_animid = follow_arrival.fa_b_arr_animid) + -- where biography.b_sex = 'F' + -- and follow_arrival.fa_type_of_cycle <> '0' + -- and follow_arrival.fa_type_of_cycle <> 'U' + -- and follow_arrival.fa_type_of_cycle <> 'MISS' + -- and biography.b_birthdate + -- > (follow_arrival.fa_fol_date + -- - '8 years'::INTERVAL + -- ) + -- and follow_arrival.fa_b_arr_animid <> 'sdb_stranger_female' + -- and follow_arrival.fa_b_arr_animid <> 'sdb_stranger_female2' + -- and follow_arrival.fa_b_arr_animid <> 'sdb_stranger_female3' + -- order by follow_arrival.fa_fol_date + -- , follow_arrival.fa_fol_b_focal_animid + -- , follow_arrival.fa_b_arr_animid; + ((fa_fol_date = '1978-05-22' + AND fa_fol_b_focal_animid = 'ML' + AND fa_b_arr_animid = 'GM') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'DB' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '1988-08-01' + AND fa_fol_b_focal_animid = 'WN' + AND fa_b_arr_animid = 'FN') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'FS') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'FS') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'FS') + OR (fa_fol_date = '1991-08-07' + AND fa_fol_b_focal_animid = 'GB' + AND fa_b_arr_animid = 'TT') + OR (fa_fol_date = '1991-09-24' + AND fa_fol_b_focal_animid = 'GL' + AND fa_b_arr_animid = 'TT') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1992-10-30' + AND fa_fol_b_focal_animid = 'WL' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1994-02-04' + AND fa_fol_b_focal_animid = 'FR' + AND fa_b_arr_animid = 'DL') + OR (fa_fol_date = '1994-05-02' + AND fa_fol_b_focal_animid = 'SEF' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '1994-05-02' + AND fa_fol_b_focal_animid = 'SEF' + AND fa_b_arr_animid = 'VAN') + OR (fa_fol_date = '1994-11-30' + AND fa_fol_b_focal_animid = 'VID' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '1994-11-30' + AND fa_fol_b_focal_animid = 'VID' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '1994-11-30' + AND fa_fol_b_focal_animid = 'VID' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '1999-06-28' + AND fa_fol_b_focal_animid = 'BAH' + AND fa_b_arr_animid = 'BIM') + OR (fa_fol_date = '2015-09-30' + AND fa_fol_b_focal_animid = 'FLI' + AND fa_b_arr_animid = 'FIT') + OR (fa_fol_date = '2016-12-31' + AND fa_fol_b_focal_animid = 'BIM' + AND fa_b_arr_animid = 'MIS')) ORDER BY follow_arrival.fa_fol_date , follow_arrival.fa_fol_b_focal_animid , follow_arrival.fa_b_arr_animid diff --git a/conversion/load_follow_to_follows.sql b/conversion/load_follow_to_follows.sql index 8bce4f7..29bdf85 100644 --- a/conversion/load_follow_to_follows.sql +++ b/conversion/load_follow_to_follows.sql @@ -65,6 +65,58 @@ SELECT fol_b_animid , fol_date , '' FROM clean.follow + + WHERE + -- Problem #30 + NOT ((fol_date = '1973-02-25' + AND fol_b_animid = 'LON') + OR (fol_date = '1973-07-12' + AND fol_b_animid = 'GO') + OR (fol_date = '1973-07-13' + AND fol_b_animid = 'GO') + OR (fol_date = '1973-07-14' + AND fol_b_animid = 'GO') + OR (fol_date = '2006-04-11' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-01-20' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-02-11' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-03-12' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-03-16' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-03-23' + AND fol_b_animid = 'MGE') + OR (fol_date = '2014-04-19' + AND fol_b_animid = 'MGENI') + OR (fol_date = '2014-06-18' + AND fol_b_animid = 'MGENI2') + OR (fol_date = '2014-07-01' + AND fol_b_animid = 'MGENI2')) + + -- Problem #33 + AND (fol_b_animid NOT IN ( + 'MGE' +, 'MGEN' +, 'MGENI')) + -- Problem #34 + AND NOT ((fol_b_animid = 'SL' + AND fol_date = '2014-06-25') + OR (fol_b_animid = 'SN' + AND fol_date = '2013-02-05')) + -- Problem #35 + AND NOT ((fol_b_animid = 'LON' + AND fol_date = '1973-02-25') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-05-31') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-07-12') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-07-13') + OR (fol_b_animid = 'GO' + AND fol_date = '1973-07-14')) + ORDER BY fol_b_animid, fol_date; @@ -146,7 +198,65 @@ SELECT , 'UNK' , 'NONE' , 'NONE' - FROM clean.follow; + FROM clean.follow + WHERE + -- Problem #37 + (fol_date = '1974-01-10' AND fol_b_animid = 'SW') + OR (fol_date = '1974-01-18' AND fol_b_animid = 'PL') + OR (fol_date = '1974-08-13' AND fol_b_animid = 'PM') + OR (fol_date = '1974-12-18' AND fol_b_animid = 'HG') + OR (fol_date = '1975-01-08' AND fol_b_animid = 'NV') + OR (fol_date = '1975-01-15' AND fol_b_animid = 'ST') + OR (fol_date = '1975-01-16' AND fol_b_animid = 'FB') + OR (fol_date = '1975-02-05' AND fol_b_animid = 'GB') + OR (fol_date = '1975-04-20' AND fol_b_animid = 'LB') + OR (fol_date = '1977-08-03' AND fol_b_animid = 'ML') + OR (fol_date = '1977-09-21' AND fol_b_animid = 'ML') + OR (fol_date = '1977-12-02' AND fol_b_animid = 'HR') + OR (fol_date = '1978-04-14' AND fol_b_animid = 'SH') + OR (fol_date = '1978-05-16' AND fol_b_animid = 'HM') + OR (fol_date = '1978-06-05' AND fol_b_animid = 'FG') + OR (fol_date = '1978-06-28' AND fol_b_animid = 'MU') + OR (fol_date = '1978-07-05' AND fol_b_animid = 'FF') + OR (fol_date = '1978-07-06' AND fol_b_animid = 'FG') + OR (fol_date = '1978-07-10' AND fol_b_animid = 'GB') + OR (fol_date = '1978-07-24' AND fol_b_animid = 'GB') + OR (fol_date = '1978-08-11' AND fol_b_animid = 'GB') + OR (fol_date = '1978-12-30' AND fol_b_animid = 'EV') + OR (fol_date = '1979-03-02' AND fol_b_animid = 'HR') + OR (fol_date = '1979-03-14' AND fol_b_animid = 'FG') + OR (fol_date = '1979-04-14' AND fol_b_animid = 'FG') + OR (fol_date = '1979-04-26' AND fol_b_animid = 'SH') + OR (fol_date = '1980-10-27' AND fol_b_animid = 'ML') + OR (fol_date = '1980-10-31' AND fol_b_animid = 'ML') + OR (fol_date = '1981-07-22' AND fol_b_animid = 'MF') + OR (fol_date = '1981-07-26' AND fol_b_animid = 'MU') + OR (fol_date = '1981-07-27' AND fol_b_animid = 'MF') + OR (fol_date = '1981-08-17' AND fol_b_animid = 'MF') + OR (fol_date = '1981-08-18' AND fol_b_animid = 'MF') + OR (fol_date = '1982-02-09' AND fol_b_animid = 'EV') + OR (fol_date = '1982-08-13' AND fol_b_animid = 'ML') + OR (fol_date = '1984-02-08' AND fol_b_animid = 'FF') + OR (fol_date = '1984-05-27' AND fol_b_animid = 'GB') + OR (fol_date = '1984-05-28' AND fol_b_animid = 'GM') + OR (fol_date = '1984-06-06' AND fol_b_animid = 'ST') + OR (fol_date = '1984-08-28' AND fol_b_animid = 'GM') + OR (fol_date = '1986-03-20' AND fol_b_animid = 'FD') + OR (fol_date = '1987-09-19' AND fol_b_animid = 'PI') + OR (fol_date = '1988-07-21' AND fol_b_animid = 'ME') + OR (fol_date = '1988-09-06' AND fol_b_animid = 'GB') + OR (fol_date = '1989-01-09' AND fol_b_animid = 'AL') + OR (fol_date = '1993-04-01' AND fol_b_animid = 'PF') + OR (fol_date = '1995-05-19' AND fol_b_animid = 'TB') + OR (fol_date = '1998-07-13' AND fol_b_animid = 'WL') + OR (fol_date = '1998-09-28' AND fol_b_animid = 'SL') + OR (fol_date = '1999-01-03' AND fol_b_animid = 'FF') + OR (fol_date = '2012-08-27' AND fol_b_animid = 'KON') + OR (fol_date = '2014-10-27' AND fol_b_animid = 'WEM') + OR (fol_date = '2014-11-23' AND fol_b_animid = 'WEM') + OR (fol_date = '2014-12-23' AND fol_b_animid = 'EZA') + OR (fol_date = '2015-01-05' AND fol_b_animid = 'VAN') + OR (fol_date = '2015-01-17' AND fol_b_animid = 'SI'); ANALYZE follows -- 2.34.1