# Fields

_browse:
SELECT Taxa.[Code] as [Code], Taxa.Taxon, Taxa.Vernacular, [Sites].Name & ' (' & [Sites].OSGridRef & ')' AS Site, Records.Quantity, iif(Records.DateTo - Records.Date < 27, Format(Records.Date, 'dd mmm yyyy'), iif(Records.DateTo - Records.Date > 32, Format(Records.Date, 'yyyy'), Format(Records.Date, 'mmm yyyy'))) as [Date], Recorders.Name as [Recorder], Methods.Method, Records.Comment as [Comments], Records.[_guk]
FROM (((Records INNER JOIN Taxa ON Records.[*Taxon] = Taxa.[_guk]) INNER JOIN Sites ON Records.[*Site] = Sites.[_guk]) INNER JOIN Methods ON Records.[*Method] = Methods.[_guk]) INNER JOIN Recorders ON Records.[*Recorder] = Recorders.[_guk]


_hint:
Name & iif((OSGridRef <> '') And (Name <> OSGridRef), '  (' & OSGridRef & ')', '')


_hint:
iif([_guk] <> [**RefersTo], '=', '') & Taxon & iif(Vernacular <> '', ' (' & Vernacular & ')', '')


# Filters

_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=32 Or [**Parent]='rf8t51z1' Or [**Parent]='rf8t51zj' Or [**Parent]='u02261z1' Or [**Parent]='u02271z1' Or [**Parent]='u02281z1' Or [**Parent]='u02291z1' Or [**Parent]='u02301z1' Or [**Parent]='u02311z1' Or [**Parent]='u02321z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [Sites].[**Parent] = 'y6d3s1zz' OR [Sites].[**Parent] = 'u02551z1' OR [Sites].[**Parent] = 'k8sgm1zz' OR [Sites].[**Parent] = 'h6sfq1zz' OR [Sites].[**Parent] = 'u02611z1' OR [Sites].[**Parent] = 'u00101z1' OR [Sites].ViceCounty = 22


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=15 Or [ViceCounty]=16 Or [**Parent]='0onnn1z1' Or [**Parent]='0onnn1zj' Or [**Parent]='u01641z1' Or [**Parent]='u01651z1' Or [**Parent]='u01661z1' Or [**Parent]='u01671z1' Or [**Parent]='u01681z1' Or [**Parent]='u01691z1' Or [**Parent]='u01701z1' Or [**Parent]='u01711z1' Or [**Parent]='u01721z1' Or [**Parent]='u01731z1' Or [**Parent]='u01741z1' Or [**Parent]='u01751z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rr8cf1zj' Or [**Parent]='rr8cf1z1' Or ([_xo]>=112840 And [_xi]<=340240 And [_yo]>=739760 And [_yi]<=976840)


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=66 Or [**Parent]='w295i1z1' Or [**Parent]='w295i1zj' Or [**Parent]='u00641z1' Or [**Parent]='u00651z1' Or [**Parent]='u00661z1' Or [**Parent]='u00671z1' Or [**Parent]='u00681z1' Or [**Parent]='u00691z1' Or [**Parent]='u00701z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=53 Or [ViceCounty]=54 Or [**Parent]='siluc1z1' Or [**Parent]='siluc1zj' Or [**Parent]='u01961z1' Or [**Parent]='u01971z1' Or [**Parent]='u01981z1' Or [**Parent]='u01991z1' Or [**Parent]='u02001z1' Or [**Parent]='u02011z1' Or [**Parent]='u02021z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=58 Or [**Parent]='7zp7q1z1' Or [**Parent]='7zp7q1zj' Or [**Parent]='u00211z1' Or [**Parent]='u00221z1' Or [**Parent]='u00231z1' Or [**Parent]='u00241z1' Or [**Parent]='u00251z1' Or [**Parent]='u00261z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE Sites.[**Parent] = '25jft1z1' Or Sites.[10kSquare]='SD82' Or Sites.[10kSquare]='SD92' Or Sites.[10kSquare]='SE01' Or Sites.[10kSquare]='SE00' Or Sites.[10kSquare]='SK09' Or Sites.[10kSquare]='SK08' Or Sites.[10kSquare]='SD51' Or Sites.[10kSquare]='SD61' Or Sites.[10kSquare]='SD71' Or Sites.[10kSquare]='SD81' Or Sites.[10kSquare]='SD91' Or Sites.[10kSquare]='SD50' Or Sites.[10kSquare]='SD60' Or Sites.[10kSquare]='SD70' Or Sites.[10kSquare]='SD80' Or Sites.[10kSquare]='SD90' Or Sites.[10kSquare]='SJ59' Or Sites.[10kSquare]='SJ69' Or Sites.[10kSquare]='SJ79' Or Sites.[10kSquare]='SJ89' Or Sites.[10kSquare]='SJ99' Or Sites.[10kSquare]='SJ68' Or Sites.[10kSquare]='SJ78' Or Sites.[10kSquare]='SJ88' Or Sites.[10kSquare]='SJ98' Or [**Parent]='u01291z1' Or [**Parent]='u01301z1' Or [**Parent]='u01311z1' Or [**Parent]='u01321z1' Or [**Parent]='u01331z1' Or [**Parent]='u01341z1' Or [**Parent]='u01351z1' Or [**Parent]='u01361z1' Or [**Parent]='u01371z1' Or [**Parent]='u01381z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='r5usm1zz' Or [**Parent]='5usm1zj' Or [**Parent]='r5usm1z1' Or [ViceCounty]=85


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=39 Or [**Parent]='wvl511z1' Or [**Parent]='wvl511zj' Or [**Parent]='u02731z1' Or [**Parent]='u02741z1' Or [**Parent]='u02751z1' Or [**Parent]='u02761z1' Or [**Parent]='u02771z1' Or [**Parent]='u02781z1' Or [**Parent]='u02791z1' Or [**Parent]='u02801z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=17 Or [**Parent]='4kbcg1z1' Or [**Parent]='4kbcg1zj' Or [**Parent]='u02891z1' Or [**Parent]='u02901z1' Or [**Parent]='u02911z1' Or [**Parent]='u02921z1' Or [**Parent]='u02931z1' Or [**Parent]='u02941z1' Or [**Parent]='u02951z1' Or [**Parent]='u02961z1' Or [**Parent]='u02971z1' Or [**Parent]='u02981z1' Or [**Parent]='u02991z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=30 Or [**Parent]='d00rj1z1' Or [**Parent]='d00rj1zj' Or [**Parent]='u00041z1' Or [**Parent]='u00051z1' Or [**Parent]='u00061z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [Eorg]>=283600 And [Eext]<=325960 And [Norg]>=160200 And [Next]<=185440


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=14 Or [**Parent]='85wwv1z1' Or [**Parent]='u00711z1' Or [**Parent]='u00721z1' Or [**Parent]='u00731z1' Or [**Parent]='u00741z1' Or [**Parent]='u00751z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=40 Or [**Parent]='9oorm1z3' Or [**Parent]='c3hzo1z1' Or [**Parent]='c3hzo1zj' Or [**Parent]='u02561z1' Or [**Parent]='u02571z1' Or [**Parent]='u02581z1' Or [**Parent]='u02591z1' Or [**Parent]='u02601z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=23 Or [**Parent]='7gord1z1' Or [**Parent]='7gord1zj' Or [**Parent]='u02471z1' Or [**Parent]='u02481z1' Or [**Parent]='u02491z1' Or [**Parent]='u02501z1' Or [**Parent]='u02511z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [Eorg]>=240440 And [Eext]<=292360 And [Norg]>=181840 And [Next]<=213720


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=62 Or [ViceCounty]=65 Or [**Parent]='4pikk1z1' Or [**Parent]='u02191z1' Or [**Parent]='u02201z1' Or [**Parent]='u02211z1' Or [**Parent]='u02221z1' Or [**Parent]='u02231z1' Or [**Parent]='u02241z1' Or [**Parent]='u02251z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=63 Or [ViceCounty]=64 Or [ViceCounty]=65 Or [**Parent]='l3hi01z1' Or [**Parent]='u03301z1' Or [**Parent]='u03311z1' Or [**Parent]='u03321z1' Or [**Parent]='u03331z1' Or [**Parent]='u03341z1'


_filterSql:
Select Sites.* From Sites Where ([ViceCounty] Between 1 And 34) Or ([ViceCounty] Between 36 And 40) Or ([ViceCounty] Between 53 And 71)


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=35 Or ([ViceCounty] Between 41And 52)


_filterSql:
Select Sites.* From Sites Where ([ViceCounty] Between 72 And 112)


_filterSql:
Select Sites.* From Sites Where [ViceCounty]>200


_filterSql:
Select Sites.* From Sites Where ([ViceCounty] Between 1 And 112)


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=52


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=8


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=9


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=10


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=11


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=12


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=57


_filterSql:
SELECT Sites.* FROM Sites WHERE Sites.[ViceCounty] = 5


_filterSql:
SELECT Sites.* FROM Sites WHERE Sites.[ViceCounty] = 6


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=7 Or [ViceCounty]=8 Or [**Parent]='u2ffq1z1' Or [**Parent]='u2ffq1zj' Or [**Parent]='u03361z1' Or [**Parent]='u03371z1' Or [**Parent]='u03381z1' Or [**Parent]='u03391z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [2kSquare]='ST45W'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=33 Or [ViceCounty]=34 Or [**Parent]='361tu1z1' Or [**Parent]='am1281zz' Or [**Parent]='u00901z1' Or [**Parent]='u00911z1' Or [**Parent]='u00921z1' Or [**Parent]='u00931z1' Or [**Parent]='u00941z1' Or [**Parent]='u00951z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=25 Or [ViceCounty]=26 Or [**Parent]='pcm031z1' Or [**Parent]='pcm031zj' Or [**Parent]='u02821z1' Or [**Parent]='u02831z1' Or [**Parent]='u02841z1' Or [**Parent]='u02851z1' Or [**Parent]='u02861z1' Or [**Parent]='u02871z1' Or [**Parent]='u02881z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=27 Or [ViceCounty]=28 Or [**Parent]='ztkf61z1' Or [**Parent]='ztkf61zj' Or [**Parent]='u02121z1' Or [**Parent]='u02131z1' Or [**Parent]='u02141z1' Or [**Parent]='u02151z1' Or [**Parent]='u02161z1' Or [**Parent]='u02171z1' Or [**Parent]='u02181z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=29 Or [**Parent]='3w7n61z1' Or [**Parent]='am0481zz' Or [**Parent]='u00161z1' Or [**Parent]='u00171z1' Or [**Parent]='u00181z1' Or [**Parent]='u00191z1' Or [**Parent]='u00201z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=11 Or [ViceCounty]=12 Or [**Parent]='b6fi11z1' Or [**Parent]='b6fi11zj' Or [**Parent]='u01411z1' Or [**Parent]='u01421z1' Or [**Parent]='u01431z1' Or [**Parent]='u01441z1' Or [**Parent]='u01451z1' Or [**Parent]='u01461z1' Or [**Parent]='u01471z1' Or [**Parent]='u01481z1' Or [**Parent]='u01491z1' Or [**Parent]='u01501z1' Or [**Parent]='u01511z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=59 Or [ViceCounty]=60 Or [**Parent]='2ndkf1z1' Or [**Parent]='2ndkf1zj' Or [**Parent]='u01761z1' Or [**Parent]='u01771z1' Or [**Parent]='u01781z1' Or [**Parent]='u01791z1' Or [**Parent]='u01801z1' Or [**Parent]='u01811z1' Or [**Parent]='u01821z1' Or [**Parent]='u01831z1' Or [**Parent]='u01841z1' Or [**Parent]='u01851z1' Or [**Parent]='u01861z1' Or [**Parent]='u01871z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=56 Or [**Parent]='u02391z1' Or [**Parent]='7o72m1z1' Or [**Parent]='7o72m1zj' Or [**Parent]='u02401z1' Or [**Parent]='u02411z1' Or [**Parent]='u02421z1' Or [**Parent]='u02431z1' Or [**Parent]='u02441z1' Or [**Parent]='u02451z1' Or [**Parent]='u02461z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=20 Or [**Parent]='36odt1z1' Or [**Parent]='36odt1zj' Or [**Parent]='u01521z1' Or [**Parent]='u01531z1' Or [**Parent]='u01541z1' Or [**Parent]='u01551z1' Or [**Parent]='u01561z1' Or [**Parent]='u01571z1' Or [**Parent]='u01581z1' Or [**Parent]='u01591z1' Or [**Parent]='u01601z1' Or [**Parent]='u01611z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=1 Or [ViceCounty]=2 Or [**Parent]='r036r1z1' Or [**Parent]='r036r1zj' Or [**Parent]='u00281z1' Or [**Parent]='u00291z1' Or [**Parent]='u00301z1' Or [**Parent]='u00311z1' Or [**Parent]='u00321z1' Or [**Parent]='u00331z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [Sites].[**Parent] = 'u00121z1' OR [Sites].[**Parent] = 'u00131z1' OR [Sites].[**Parent] = 'u00141z1' OR [Sites].[**Parent] = 'u00151z1'


_filterSql:
Select Sites.* From Sites Where [10kSquare]='SV80' Or [10kSquare]='SV90' Or [10kSquare]='SV81' Or [10kSquare]='SV91'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=55 Or [**Parent]='u01881z1' Or [**Parent]='mpgji1z1' Or [**Parent]='mpgji1zj' Or [**Parent]='u01891z1' Or [**Parent]='u01901z1' Or [**Parent]='u01911z1' Or [**Parent]='u01921z1' Or [**Parent]='u01931z1' Or [**Parent]='u01941z1' Or [**Parent]='u01951z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=38 Or [**Parent]='7t1nf1z1' Or [**Parent]='7t1nf1zj' Or [**Parent]='u03101z1' Or [**Parent]='u03111z1' Or [**Parent]='u03121z1' Or [**Parent]='u03131z1' Or [**Parent]='u03141z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=13 Or [**Parent]='p06s51z1' Or [**Parent]='u03231z1' Or [**Parent]='u03241z1' Or [**Parent]='u03251z1' Or [**Parent]='u03261z1' Or [**Parent]='u03271z1' Or [**Parent]='u03281z1' Or [**Parent]='u03291z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=105


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=106


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=107


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=108


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=109


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=110


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=111


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=112


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=113


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=3 Or [ViceCounty]=4


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=5 Or [ViceCounty]=6


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=7 Or [ViceCounty]=8


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=11 Or [ViceCounty]=12


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=18 Or [ViceCounty]=19


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date < 36526


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 36526


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date > 36525 And Records.DateTo < 36892


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 36892 And Records.DateTo <= 37256


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 37257 And Records.DateTo <= 37621


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 37622 And Records.DateTo <= 37986


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk]


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 37987 And Records.DateTo <= 38352


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date=38129


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 38038 Or Records.Date = 38066 Or Records.Date = 38094 Or Records.Date = 38129 Or Records.Date = 38157 Or Records.Date = 38185 Or Records.Date = 38123 Or Records.Date = 38241 Or Records.Date = 38276 Or Records.Date = 38304 Or Records.Date = 38332


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=214


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=208 Or [**Parent]='ix0141z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=240


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=224 Or [**Parent]='ix0151z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=231 Or [**Parent]='ix0161z1'


_filterSql:
Select Sites.* From Sites [ViceCounty]=222 Or [**Parent]='ire981z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=232 Or [**Parent]='ix0171z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=215 Or [ViceCounty]=216 Or [ViceCounty]=217 Or [**Parent]='ire991z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=218


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=225 Or [**Parent]='ix0191z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=228 Or [**Parent]='ix0201z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=201 Or [ViceCounty]=202 Or [**Parent]='ire251z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=207 Or [ViceCounty]=210 Or [**Parent]='ire261z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=236 Or [**Parent]='ix0211z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=206 Or [**Parent]='ix0221z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=203 Or [ViceCounty]=204 Or [ViceCounty]=205 Or [**Parent]='ire291z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=223


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=212 Or [**Parent]='ix0241z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=220 Or [**Parent]='ix0251z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2231zz' OR [**Parent]='am2241zz' OR [**Parent]='am1661zz' OR [**Parent]='am1671zz' OR [**Parent]='am0491zz' OR [**Parent]='am0501zz' OR [**Parent]='am2681zz' OR [**Parent]='am2691zz' OR [**Parent]='am0371zz' OR ([**Parent]='am0451zz' AND [ViceCounty]=41) OR [10kSquare]='ST26' OR [**Parent]='am1851zz' OR [**Parent]='u02111z1' OR [**Parent]='am2591zz' OR [**Parent]='am2601zz'


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=41


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=1


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=2


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=3


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=4


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=7


_filterSql:
Select Sites.* From Sites Where ViceCounty=59 Or ViceCounty=60


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=1 Or [ViceCounty]=2


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=25 Or [ViceCounty]=26


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=27 Or [ViceCounty]=28


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=29 Or [ViceCounty]=31


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=36 Or [ViceCounty]=37


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=53 Or [ViceCounty]=54


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=66 Or [ViceCounty]=67 Or [ViceCounty]=68


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=67 Or [ViceCounty]=68


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=69 Or [ViceCounty]=70


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=44 Or [ViceCounty]=45 Or [ViceCounty]=46


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=42 Or [ViceCounty]=43 Or [ViceCounty]=47


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=48 Or [ViceCounty]=49 Or [ViceCounty]=52


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=50 Or [ViceCounty]=51


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=10 Or [ViceCounty]=11


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=71 Or [**Parent]='dlhdn1z1'


_filterSql:
Select Sites.* From Sites Where [10kSquare]='ST35' Or [10kSquare]='ST45' Or [10kSquare]='ST55' Or [10kSquare]='ST65' Or [10kSquare]='ST75' Or [10kSquare]='ST36' Or [10kSquare]='ST46' Or [10kSquare]='ST56' Or [10kSquare]='ST66' Or [10kSquare]='ST76' Or [10kSquare]='ST37' Or [10kSquare]='ST47' Or [10kSquare]='ST57' Or [10kSquare]='ST67' Or [10kSquare]='ST77' Or [10kSquare]='ST87' Or [10kSquare]='ST58' Or [10kSquare]='ST68' Or [10kSquare]='ST78' Or [10kSquare]='ST88' Or [10kSquare]='ST59' Or [10kSquare]='ST69' Or [10kSquare]='ST79' Or [10kSquare]='ST89'


_filterSql:
Select Sites.* From Sites Where [10kSquare]='ST46' Or [10kSquare]='ST56' Or [10kSquare]='ST66' Or [10kSquare]='ST47' Or [10kSquare]='ST57' Or [10kSquare]='ST67' Or [10kSquare]='ST58' Or [10kSquare]='ST68'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=13


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=14


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=16


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=17


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=18


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=19


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=20


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=21


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=22


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=23


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=24


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=25


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=26


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=27


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=28


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=29


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=30


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=31


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=32


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=33


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=34


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=35


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=36


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=37


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=38


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=39


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=40


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=42


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=43


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=44


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=45


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=46


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=47


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=48


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=49


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=50


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=51


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=53


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=54


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=55


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=56


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=3 Or [ViceCounty]=4 Or [**Parent]='y7r2s1z1' Or [**Parent]='u00501z1' Or [**Parent]='u00511z1' Or [**Parent]='u00521z1' Or [**Parent]='u00531z1' Or [**Parent]='u00541z1' Or [**Parent]='u00551z1' Or [**Parent]='u00561z1' Or [**Parent]='u00571z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=9 Or [**Parent]='e6rqq1z1' Or [**Parent]='e6rqq1zj' Or [**Parent]='u00581z1' Or [**Parent]='u00591z1' Or [**Parent]='u00601z1' Or [**Parent]='u00611z1' Or [**Parent]='u00621z1' Or [**Parent]='u00631z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=5 Or [**Parent]='0001v1z1' Or [**Parent]='0001v1zj' Or [**Parent]='u02621z1' Or [**Parent]='u02631z1' Or [**Parent]='u02641z1' Or [**Parent]='u02651z1' Or [**Parent]='u02661z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=67 Or [ViceCounty]=68 Or [**Parent]='l1gtm1z1' Or [**Parent]='l1gtm1zj' Or [**Parent]='am2041zz' Or [**Parent]='u02331z1' Or [**Parent]='u02341z1' Or [**Parent]='u02351z1' Or [**Parent]='u02361z1' Or [**Parent]='u02371z1' Or [**Parent]='u02381z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=57 Or [**Parent]='lc4b51z1' Or [**Parent]='lc4b51zj' Or [**Parent]='am0851zz' Or [**Parent]='u00421z1' Or [**Parent]='u00431z1' Or [**Parent]='u00441z1' Or [**Parent]='u00451z1' Or [**Parent]='u00461z1' Or [**Parent]='u00471z1' Or [**Parent]='u00481z1' Or [**Parent]='u00491z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=70 Or [**Parent]='m7ipk1z1' Or [**Parent]='u00341z1' Or [**Parent]='u00351z1' Or [**Parent]='u00361z1' Or [**Parent]='u00371z1' Or [**Parent]='u00381z1' Or [**Parent]='u00391z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=36 Or [**Parent]='1l4g61z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='9oorm1z3' Or [**Parent]='am2901zz' Or [ViceCounty]=112


_filterSql:
SELECT Sites.* FROM Sites WHERE Sites.[**Parent] = 'w3r1e1z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=239 Or [**Parent]=ix0011z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=237 Or [**Parent]='ix0021z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=213 Or [**Parent]='ix0031z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=230 Or [**Parent]='ix0041z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=209 Or [**Parent]='ix0051z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=238 Or [**Parent]='ix0071z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=221 Or [**Parent]='ix0081z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=234 Or [ViceCounty]=235 Or [**Parent]='ire081z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=226 Or [ViceCounty]=227 Or [**Parent]='ire091z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=233 Or [**Parent]='ix0091z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=219 Or [**Parent]='ix0101z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=211 Or [**Parent]='ix0111z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=10 Or Sites.[**Parent]='f3wjq1zj'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=229 Or [**Parent]='ix0131z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=15


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=58


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=59


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=60


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=61


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=62


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=63


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=64


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=65


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=66


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=67


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=68


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=69


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=70


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=71


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=72


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=73


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=74


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=75


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=76


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=77


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=78


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=79


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=80


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=81


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=82


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=83


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=84


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=85


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=86


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=87


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=88


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=89


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=90


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=91


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=92


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=93


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=94


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=95


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=96


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=97


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=98


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=99


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=100


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=101


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=102


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=103


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=104


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=72


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=61 or [ViceCounty]=63 Or [**Parent]='2qo9c1z1' Or [**Parent]='u02671z1' Or [**Parent]='u02681z1' Or [**Parent]='u02691z1' Or [**Parent]='u02701z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=18 Or [ViceCounty]=19 Or [**Parent]='ofw941z1' Or [**Parent]='ofw941zj' Or [**Parent]='u00771z1' Or [**Parent]='u00781z1' Or [**Parent]='u00791z1' Or [**Parent]='u00801z1' Or [**Parent]='u00811z1' Or [**Parent]='u00821z1' Or [**Parent]='u00831z1' Or [**Parent]='u00841z1' Or [**Parent]='u00851z1' Or [**Parent]='u00861z1' Or [**Parent]='u00871z1' Or [**Parent]='u00881z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=10 Or [ViceCounty]=11 Or [ViceCounty]=12


_filterSql:
Select Sites.* From Sites Where [10kSquare]='ST65' Or [2kSquare]='ST55W' Or [2kSquare]='ST55X' Or [2kSquare]='ST55Y' Or [2kSquare]='ST55Z' Or [2kSquare]='ST64P' Or [2kSquare]='ST64U' Or [2kSquare]='ST66A' Or [2kSquare]='ST66F' Or [2kSquare]='ST66K' Or [2kSquare]='ST75A' Or [2kSquare]='ST75B' Or [2kSquare]='ST75C' Or [2kSquare]='ST75D' Or [2kSquare]='ST75E' Or [2kSquare]='ST75F' Or [2kSquare]='ST75G' Or [2kSquare]='ST75H' Or [2kSquare]='ST75I' Or [2kSquare]='ST75J' Or [2kSquare]='ST75L' Or [2kSquare]='ST75M' Or [2kSquare]='ST75N' Or [2kSquare]='ST75P' Or [2kSquare]='ST75S' Or [2kSquare]='ST75T' Or [2kSquare]='ST75U' Or [2kSquare]='ST76A' Or [2kSquare]='ST76F' Or [2kSquare]='ST76K' Or [2kSquare]='ST76Q'


_filterSql:
SELECT Sites.* FROM Sites WHERE (Sites.ViceCounty = 5) Or (Sites.ViceCounty = 6) Or (Sites.[**Parent] = '0001v1z1')


_filterSql:
SELECT Sites.* FROM Sites WHERE Sites.[**Parent] = 'ztkf61z1' Or [ViceCounty]=27 Or [ViceCounty]=28


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=201


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=202


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=203


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=204


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=205


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=206


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=207


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=208


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=209


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=210


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=211


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=212


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=213


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=214


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=215


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=216


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=217


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=218


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=219


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=220


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=221


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=222


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=223


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=224


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=225


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=226


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=227


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=228


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=229


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=230


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=231


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=232


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=233


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=234


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=235


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=236


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=237


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=238


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=239


_filterSql:
Select Sites.* From Sites Where Sites.[ViceCounty]=240


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=6 Or [ViceCounty]=34


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=15 Or [ViceCounty]=16


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=33 Or [ViceCounty]=34


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=59 Or [ViceCounty]=60


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=61 Or [ViceCounty]=62 Or [ViceCounty]=63 Or [ViceCounty]=64 Or [ViceCounty]=65


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=87 Or [ViceCounty]=88 Or [ViceCounty]=89


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=92 Or [ViceCounty]=93


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=105 Or [ViceCounty]=106


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=107 Or [ViceCounty]=108


_filterSql:
Select Sites.* From Sites Where [10kSquare]='TQ19'


_filterSql:
Select Sites.* From Sites Where [Xpos]<264081 And [Xpos]>220439 And [Ypos]>361719 And [Ypos]<395601


_filterSql:
Select Sites.* From Sites Where [**Parent]='0413p1z1' Or [**Parent]='am0371zz' Or [**Parent]='am0491zz' Or [**Parent]='am0501zz' Or [**Parent]='87som1z1' Or [**Parent]='rourr1z1' Or [**Parent]='am1591zz' Or [**Parent]='am1661zz' Or [**Parent]='am1671zz' Or [**Parent]='53b9l1z1' Or [**Parent]='am1841zz' Or [**Parent]='am1851zz' Or [**Parent]='am2161zz' Or [**Parent]='am2231zz' Or [**Parent]='am2241zz' Or [**Parent]='am2261zz' Or [**Parent]='kn6vs1z1' Or [**Parent]='am2591zz' Or [**Parent]='am2601zz' Or [**Parent]='am2681zz' Or [**Parent]='am2691zz' Or [**Parent]='0413p1z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2841zz' or [ViceCounty]=37 Or [**Parent]='u03411z1' Or [**Parent]='u03421z1' Or [**Parent]='u03431z1' Or [**Parent]='u03441z1' Or [**Parent]='u03451z1' Or [**Parent]='u03461z1'


_filterSql:
SELECT Sites.* FROM Sites WHERE [ViceCounty]=11 Or [ViceCounty]=12 Or [**Parent]='b6fi11z1' Or [**Parent]='b6fi11zj' Or [ViceCounty]=10 Or Sites.[**Parent]='f3wjq1zj' Or [**Parent]='u01411z1' Or [**Parent]='u01421z1' Or [**Parent]='u01431z1' Or [**Parent]='u01441z1' Or [**Parent]='u01451z1' Or [**Parent]='u01461z1' Or [**Parent]='u01471z1' Or [**Parent]='u01481z1' Or [**Parent]='u01491z1' Or [**Parent]='u01501z1' Or [**Parent]='u01511z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='7zp7q1z1' Or [**Parent]='7zp7q1zj' Or ViceCounty=58


_filterSql:
Select Sites.* From Sites Where [**Parent]='e2kdi1zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='y6d3s1zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='j4jdw1zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='h6sfq1zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='7dv201zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='k8sgm1zz'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=59 Or [ViceCounty]=60 Or [ViceCounty]=63 Or [ViceCounty]=64 Or [ViceCounty]=65 Or [ViceCounty]=69


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=240 Or [**Parent]='ix0061z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=214 Or [**Parent]='ix0121z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=223 Or [**Parent]='ix0231z1'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=218 Or [**Parent]='ix0181z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0591zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0611zz' Or [**Parent]='am0971zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0621zz' Or [**Parent]='am0631zz' Or [**Parent]='u00761z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0641zz' Or [**Parent]='am0651zz' Or [**Parent]='u00891z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0661zz' Or [**Parent]='am0671zz' Or [**Parent]='am0681zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0841zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0911zz' Or [**Parent]='am0921zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0931zz' Or [**Parent]='am0941zz' Or [**Parent]='2dh861z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1011zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1041zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1081zz' Or [**Parent]='am1061zz' Or [**Parent]='am1071zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1101zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1111zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0021zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00011z1' Or [**Parent]='am0031zz' Or [**Parent]='am0601zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0041zz' Or [**Parent]='am0051zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0101zz' Or [**Parent]='am0091zz' Or [**Parent]='am0111zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0151zz' Or [**Parent]='am0161zz' Or [**Parent]='am0171zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0261zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0331zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0371zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0381zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0431zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0451zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0501zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0521zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0551zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1191zz' Or [**Parent]='am1201zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='01hb11z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1321zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1401zz' Or [**Parent]='am1391zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1481zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1671zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1691zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1701zz' Or [**Parent]='am1711zz' Or [**Parent]='am1721zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1761zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1771zz' Or [**Parent]='am1781zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1851zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1871zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1911zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1941zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1961zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03091z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03151z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03351z1' Or [**Parent]='am2791zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00271z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00401z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00411z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03401z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03471z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00031z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00071z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00081z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00091z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00101z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u00111z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1971zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1981zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2121zz' Or [**Parent]='am2131zz' Or [**Parent]='am2141zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2191zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2201zz' Or [**Parent]='am2211zz' Or [**Parent]='am2221zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2241zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='3qkit1z1' Or [**Parent]='am2341zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2401zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2411zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2431zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2501zz' Or [**Parent]='am2521zz' Or [**Parent]='am2521zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2531zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2601zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2641zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2691zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2751zz' Or [**Parent]='am2761zz' Or [**Parent]='am2771zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2851zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='wgc631zj'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u01621z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u01881z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02031z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02041z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02101z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02111z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02391z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02521z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02531z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02541z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02551z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02611z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02711z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02721z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u02811z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03011z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03021z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='u03031z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='gqjrr1zj' Or [**Parent]='gqjrr1zz' Or [ViceCounty]=111


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=13 Or [ViceCounty]=14


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1851zz' OR [**Parent]='u02111z1' OR [**Parent]='am2591zz' OR [**Parent]='am2601zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2231zz' OR [**Parent]='am2241zz' OR [**Parent]='am1661zz' OR [**Parent]='am1671zz' OR [**Parent]='am0491zz' OR [**Parent]='am0501zz' OR [**Parent]='am2681zz' OR [**Parent]='am2691zz' OR [**Parent]='am0371zz' OR ([**Parent]='am0451zz' AND [ViceCounty]=41) OR [10kSquare]='ST26'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=41


_filterSql:
Select Taxa.* From Taxa Where ([**Parent]='mf004tmf' Or [**Parent]='mf007tmf' Or [**Parent]='mf013tmf' Or [**Parent] ='mf017tmf' Or [**Parent]='mf020tmf' Or [**Parent]='mf023tmf' Or [**Parent]='mf025tmf' Or [**Parent]='mf028tmf' Or [**Parent]='mf030tmf' Or [**Parent]='mf033tmf' Or [**Parent]='mf037tmf' Or [**Parent]='mf043tmf' Or [**Parent]='mf048tmf' Or [**Parent]='mf051tmf' Or [**Parent]='mf054tmf' Or [**Parent]='mf067tmf' Or [**Parent]='mf069tmf' Or [**Parent]='mf072tmf' Or [**Parent]='mf076tmf' Or [**Parent]='mf080tmf' Or [**Parent]='mf082tmf' Or [**Parent]='mf084tmf' Or [**Parent]='mf087tmf' Or [**Parent]='mf091tmf' Or [**Parent]='mf093tmf' Or [**Parent]='mf096tmf' Or [**Parent]='mf099tmf' Or [**Parent]='mf107tmf' Or [**Parent]='mf120tmf' Or [**Parent]='mf122tmf' Or [**Parent]='mf133tmf' Or [**Parent]='mf137tmf' Or [**Parent]='mf139tmf' Or [**Parent]='mf149tmf' Or [**Parent]='mf155tmf' Or [**Parent]='mf157tmf' Or [**Parent]='mf159tmf' Or [**Parent]='mf162tmf' Or [**Parent]='mf165tmf' Or [**Parent]='mf172tmf' Or [**Parent]='mf175tmf' Or [**Parent]='mf178tmf' Or [**Parent]='mf184tmf' Or [**Parent]='mf187tmf' Or [**Parent]='mf192tmf' Or [**Parent]='mf195tmf' Or [**Parent]='mf199tmf' Or [**Parent]='mf204tmf' Or [**Parent]='mf207tmf' Or [**Parent]='mf209tmf' Or [**Parent]='mf223tmf' Or [**Parent]='mf225tmf' Or [**Parent]='mf234tmf' Or [**Parent]='mf236tmf' Or [**Parent]='mf238tmf' Or [**Parent]='mf240tmf' Or [**Parent]='mf242tmf' Or [**Parent]='mf244tmf' Or [**Parent]='mf246tmf' Or [**Parent]='mf257tmf' Or [**Parent]='mf260tmf' Or [**Parent]='mf269tmf' Or [**Parent]='mf272tmf' Or [**Parent]='mf275tmf' Or [**Parent]='mf277tmf' Or [**Parent]='mf279tmf' Or [**Parent] ='mf281tmf' Or [**Parent]='mf284tmf' Or [**Parent]='mf286tmf' Or [**Parent]='mf295tmf' Or [**Parent]='mf302tmf' Or [**Parent]='mf308tmf' Or [**Parent]='mf312tmf' Or [**Parent] ='mf314tmf' Or [**Parent]='mf318tmf' Or [**Parent]='mf320tmf' Or [**Parent]='mf326tmf' Or [**Parent]='mf334tmf' Or [**Parent]='mf336tmf' Or [**Parent]='mf339tmf' Or [**Parent]='mf342tmf' Or [**Parent]='mf344tmf') And  Not (Taxa.[_guk] Between '003001z1' And '003561z1')


_filterSql:
Select Taxa.* From Taxa Where ([**Parent] Like 'avf2*') Or ([**Parent] Like 'p40*')


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz101z0' Or [**Parent]='zzz431z0' Or [**Parent]='zzz441z0' Or [**Parent]='zzz121z0' Or [**Parent]='zzz111z0' Or [**Parent]='zzz131z0' Or [**Parent]='zzz171z0' Or [**Parent]='zzz151z0' Or [**Parent]='zzz141z0' Or [**Parent]='zzz291z0' Or [**Parent]='s2020370' Or [**Parent]='zzz191z0' Or [**Parent]='zzz271z0' Or [**Parent]='zzz231z0' Or [**Parent]='zzz321z0' Or [**Parent]='zzz261z0' Or [**Parent]='zzz201z0' Or [**Parent]='s2020371' Or [**Parent]='zzz341z0' Or [**Parent]='zzz221z0' Or [**Parent]='zzz241z0' Or [**Parent]='zzz251z0' Or [**Parent]='zzz281z0' Or [**Parent]='zzz311z0' Or [**Parent]='zzz211z0' Or [**Parent]='zzz331z0' Or [**Parent]='s2020372' Or [**Parent]='zzz361z0' Or [**Parent]='zzz371z0' Or [**Parent]='zzz381z0' Or [**Parent]='s2020373' Or [**Parent]='zzz401z0' Or [**Parent]='zzz391z0' Or [**Parent]='s2020374' Or [**Parent]='zzz421z0' Or [**Parent]='zzz411z0' Or [**Parent]='s96411z1' Or [**Parent]='zzz0f1z0' Or [**Parent]='s2020375' Or [**Parent]='dvm4n1z1' Or [**Parent]='s2020376' Or [**Parent]='s2020377' Or [**Parent]='s2020378' Or [**Parent]='s2020379' Or [**Parent]='zzz031z0' Or [**Parent]='zzz041z0' Or [**Parent]='zzz061z0' Or [**Parent]='acu001z0' Or [**Parent]='zzz081z0' Or [**Parent]='zzz0c1z0' Or [**Parent]='zzz0d1z0' Or [**Parent]='zzz0e1z0' Or [**Parent]='s2020380' Or [**Parent]='zzz0g1z0' Or [**Parent]='zzz0h1z0' Or [**Parent]='meg031z0' Or [**Parent]='xye011z0' Or [**Parent]='xip041z0' Or [**Parent]='ten121z0' Or [**Parent]='sir051z0' Or [**Parent]='oru061z0' Or [**Parent]='dip111z0' Or [**Parent]='cim101z0' Or [**Parent]='cep071z0' Or [**Parent]='bla091z0' Or [**Parent]='arg081z0' Or [**Parent]='pam021z0' Or [**Parent]='s2020175'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='s96411z1' Or [**Parent]='zzz0f1z0' Or [**Parent]='s2020375' Or [**Parent]='dvm4n1z1' Or [**Parent]='s2020376' Or [**Parent]='s2020377' Or [**Parent]='s2020378' Or [**Parent]='s2020379' Or [**Parent]='zzz031z0' Or [**Parent]='zzz041z0' Or [**Parent]='zzz061z0' Or [**Parent]='acu001z0' Or [**Parent]='zzz081z0' Or [**Parent]='zzz0c1z0' Or [**Parent]='zzz0d1z0' Or [**Parent]='zzz0e1z0' Or [**Parent]='s2020380' Or [**Parent]='zzz0g1z0' Or [**Parent]='zzz0h1z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='arg081z0' Or [**Parent]='bla091z0' Or [**Parent]='cep071z0' Or [**Parent]='cim101z0' Or [**Parent]='dip111z0' Or [**Parent]='meg031z0' Or [**Parent]='oru061z0' Or [**Parent]='pam021z0' Or [**Parent]='s2020175' Or [**Parent]='sir051z0' Or [**Parent]='ten121z0' Or [**Parent]='xip041z0' Or [**Parent]='xye011z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='d05fj1zj'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent] = 'az026zzz' OR [**Parent] = 'zxz171' OR [**Parent] = 'zxz221' OR [**Parent] = 'zxz321' OR [**Parent] = 'zxz361' OR [**Parent] = 'zxz381'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]=' mi1io1zb' Or [**Parent]='358b51zb' Or [**Parent]='3izj31zb' Or [**Parent]='nf0ob1zb' Or [**Parent]='ob2w21zb' Or [**Parent]='kru6l1zb' Or [**Parent]='dwdon1zb' Or [**Parent]='s93081z1' Or [**Parent]='s93091z1' Or [**Parent]='s93101z1' Or [**Parent]='s93111z1' Or [**Parent]='38wzm1zb' Or [**Parent]='sp1io1zb' Or [**Parent]='dff681zb' Or [**Parent]='89d4b1zb' Or [**Parent]='orzm41zb' Or [**Parent]='nfpkv1zb' Or [**Parent]='p8wi51zb' Or [**Parent]='gwcqt1zb' Or [**Parent]='cilgh1zb' Or [**Parent]='zgsv01zb' Or [**Parent]='b45511zb' Or [**Parent]='icnjm1zb' Or [**Parent]='eu1io1zb' Or [**Parent]='6m1wb1zb' Or [**Parent]='dn2zk1zb' Or [**Parent]='t8ugu1zb' Or [**Parent]='p88o51zb' Or [**Parent]='lwnvc1zb' Or [**Parent]='nqvqw1zb' Or [**Parent]='07i5l1zb' Or [**Parent]='li1io1zb' Or [**Parent]='jvi3r1zb' Or [**Parent]='ps1io1zb' Or [**Parent]='s92301zb' Or [**Parent]='wvvij1zb' Or [**Parent]='sgqqd1zb' Or [**Parent]='l9hod1zb' Or [**Parent]='dr1io1zb' Or [**Parent]='4otkz1zb' Or [**Parent]='bw2u41zb' Or [**Parent]='5njg21zb' Or [**Parent]='0dero1zb' Or [**Parent]='cdftt1zb' Or [**Parent]='t125q1zb' Or [**Parent]='iis821zb' Or [**Parent]='ly1io1zb' Or [**Parent]='g608q1zb' Or [**Parent]='769uq1zb' Or [**Parent]='102002xh' Or [**Parent]='nzfww1zb' Or [**Parent]='pn3cc1zb' Or [**Parent]='i6wvw1zb' Or [**Parent]='w5b9g1zb' Or [**Parent]='c888m1zb' Or [**Parent]='qgtow1zb' Or [**Parent]='9uop41zb' Or [**Parent]='195kf1zb' Or [**Parent]='zopvq1zb' Or [**Parent]='s92321zb' Or [**Parent]='61vpk1zb' Or [**Parent]='5kk3j1zb' Or [**Parent]='0kate1zb' Or [**Parent]='kr76v1zb' Or [**Parent]='0both1zb' Or [**Parent]='dtdnb1zb' Or [**Parent]='s92341zb' Or [**Parent]='7zb7r1zb' Or [**Parent]='jk09t1zb' Or [**Parent]='88qpk1zb' Or [**Parent]='la1io1zb' Or [**Parent]='k8oz81zb' Or [**Parent]='cum901zb' Or [**Parent]='528mi1zb' Or [**Parent]='415ks1zb' Or [**Parent]='i07up1zb' Or [**Parent]='qz2ik1zb' Or [**Parent]='9phub1zb' Or [**Parent]='w78ds1zb' Or [**Parent]='6gw4p1zb' Or [**Parent]='r080r1zb' Or [**Parent]='my1io1zb' Or [**Parent]='py1io1zb' Or [**Parent]='bvtl41zb' Or [**Parent]='sa1io1zb' Or [**Parent]='8blsj1zb' Or [**Parent]='orj3p1zb' Or [**Parent]='urt8i1zb' Or [**Parent]='006691zb' Or [**Parent]='s92351zb' Or [**Parent]='s92361zb' Or [**Parent]='mi7ko1zb' Or [**Parent]='ne1io1zb' Or [**Parent]='k3tc11zb' Or [**Parent]='1k07f1zb' Or [**Parent]='s92371zb' Or [**Parent]='55onj1zb' Or [**Parent]='s92381zb' Or [**Parent]='0dryo1zb' Or [**Parent]='0erir1zb' Or [**Parent]='0ayam1zb' Or [**Parent]='bq18o1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE Taxa.[**Parent] = 'jhnz51z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz361' Or [**Parent]='zxz171' Or [**Parent]='zxz381' Or [**Parent]='zxz321' Or [**Parent]='az026zzz' Or [**Parent]='zxz221' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='zxz161' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz361' Or [**Parent]='zxz171' Or [**Parent]='zxz381' Or [**Parent]='zxz321' Or [**Parent]='az026zzz' Or [**Parent]='zxz221' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [_guk]='3zmjc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='zxz161' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='dg1jv1z1' Or [**Parent]='gl4651z1' Or [**Parent]='m00021zz' Or [**Parent]='m00031zz' Or [**Parent]='m00041zz' Or [**Parent]='m00051zz' Or [**Parent]='m00061zz' Or [**Parent]='m00071zz' Or [**Parent]='m00081zz' Or [**Parent]='m00091zz' Or [**Parent]='m00101zz' Or [**Parent]='m00121zz' Or [**Parent]='m00131zz' Or [**Parent]='m00141zz' Or [**Parent]='m00151zz' Or [**Parent]='m00161zz' Or [**Parent]='m00171zz' Or [**Parent]='dqkcs1z1' Or [**Parent]='0godg1z1' Or [**Parent]='2urqq1z1' Or [**Parent]='pbmr61z1' Or [**Parent]='8hphi1z1' Or [**Parent]='jqg601z1' Or [**Parent]='so9f51z1' Or [**Parent]='96udj1z1' Or [**Parent]='1h7ff1z1' Or [**Parent]='540ok1z1' Or [**Parent]='4w7hp1z1' Or [**Parent]='p26jd1z1' Or [**Parent]='s0002903' Or [**Parent]='s0002991' Or [**Parent]='s9670008'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='pf0091zj' Or [**Parent]='n1jrl1za' Or [**Parent]='2lkkr1za' Or [**Parent]='pf01g1zj' Or [**Parent]='di7791za' Or [**Parent]='oscrw1za' Or [**Parent]='pf01p1zj' Or [**Parent]='l5flf1za' Or [**Parent]='i0j181za' Or [**Parent]='lvh3c1za' Or [**Parent]='b6vww1za' Or [**Parent]='c8i8f1za' Or [**Parent]='64n5w1za' Or [**Parent]='ltv001za' Or [**Parent]='bjiql1za' Or [**Parent]='bsbmz1za' Or [**Parent]='i5hn21za' Or [**Parent]='c3vkc1za' Or [**Parent]='tnznd1za' Or [**Parent]='bf4bs1za' Or [**Parent]='9m1ww1za' Or [**Parent]='hbvl71za' Or [**Parent]='m012l1za' Or [**Parent]='pf0081zj' Or [**Parent]='pf00j1zj' Or [**Parent]='7cgwt1za' Or [**Parent]='n0d2p1za' Or [**Parent]='pf0191zj' Or [**Parent]='mbctz1za' Or [**Parent]='pf01i1zj' Or [**Parent]='sl37c1za' Or [**Parent]='sjjut1za' Or [**Parent]='wn8on1za' Or [**Parent]='pf00b1zj' Or [**Parent]='fpgff1za' Or [**Parent]='7qd131za' Or [**Parent]='of1s11za' Or [**Parent]='pcow01za' Or [**Parent]='4gcu91za' Or [**Parent]='z15q51za' Or [**Parent]='v4q9r1za' Or [**Parent]='pf00k1zj' Or [**Parent]='pf00d1zj' Or [**Parent]='fdgrr1za' Or [**Parent]='3fczu1za' Or [**Parent]='86kk41za' Or [**Parent]='pf01n1zj' Or [**Parent]='7zhbq1za' Or [**Parent]='7jhs01za' Or [**Parent]='ngr8w1za' Or [**Parent]='pf00y1zj' Or [**Parent]='pf01h1zj' Or [**Parent]='p2t8m1za' Or [**Parent]='kdu5g1za' Or [**Parent]='pf00f1zj' Or [**Parent]='pf00q1zj' Or [**Parent]='313j51za' Or [**Parent]='bw89k1za' Or [**Parent]='4kdv21za' Or [**Parent]='h9fd51za' Or [**Parent]='ictgk1za' Or [**Parent]='pf00r1zj' Or [**Parent]='fdwr71za' Or [**Parent]='pf01l1zj' Or [**Parent]='6vm7z1za' Or [**Parent]='3055f1za' Or [**Parent]='80s2v1za' Or [**Parent]='pf00c1zj' Or [**Parent]='o4dq81za' Or [**Parent]='nsisw1za' Or [**Parent]='m86dk1za' Or [**Parent]='pf0071zj' Or [**Parent]='pf00v1zj' Or [**Parent]='srnc01za' Or [**Parent]='w6iuk1za' Or [**Parent]='fls5u1za' Or [**Parent]='pf00m1zj' Or [**Parent]='1qi7u1za' Or [**Parent]='uwkji1za' Or [**Parent]='tv36c1za' Or [**Parent]='pf01m1zj' Or [**Parent]='hhc3c1za' Or [**Parent]='rcjq71za' Or [**Parent]='8qvi41za' Or [**Parent]='pf00p1zj' Or [**Parent]='oundo1za' Or [**Parent]='pf01f1zj' Or [**Parent]='0g5tj1za' Or [**Parent]='2qod01za' Or [**Parent]='mh4s21za' Or [**Parent]='pf0121zj' Or [**Parent]='pf0111zj' Or [**Parent]='9vn9z1za' Or [**Parent]='gt2sh1za' Or [**Parent]='pf00x1zj' Or [**Parent]='5pgf21za' Or [**Parent]='pf01d1zj' Or [**Parent]='49dt21za' Or [**Parent]='if10l1za' Or [**Parent]='uvwio1za' Or [**Parent]='qugvn1za' Or [**Parent]='6qffn1za' Or [**Parent]='pf00a1zj' Or [**Parent]='diqlv1za' Or [**Parent]='89dfs1za' Or [**Parent]='jqd5r1za' Or [**Parent]='pf01b1zj' Or [**Parent]='0qo491za' Or [**Parent]='mnmfi1za' Or [**Parent]='szrpu1za' Or [**Parent]='slu2f1za' Or [**Parent]='pf00z1zj' Or [**Parent]='pf00t1zj' Or [**Parent]='pf00g1zj' Or [**Parent]='wikjp1za' Or [**Parent]='pf00u1zj' Or [**Parent]='pf0141zj' Or [**Parent]='pf01k1zj' Or [**Parent]='57p9l1za' Or [**Parent]='pqgtr1za' Or [**Parent]='4ir3g1za' Or [**Parent]='jh1zh1za' Or [**Parent]='t761m1za' Or [**Parent]='drduo1za' Or [**Parent]='pf00l1zj' Or [**Parent]='gmpnq1za' Or [**Parent]='pf00h1zj' Or [**Parent]='pf00w1zj' Or [**Parent]='0jh681za' Or [**Parent]='pf00e1zj' Or [**Parent]='c3w371za' Or [**Parent]='kv9pv1za' Or [**Parent]='9rv7p1za' Or [**Parent]='1gf3r1za' Or [**Parent]='fbbuq1za' Or [**Parent]='pf01o1zj' Or [**Parent]='1ns8f1za' Or [**Parent]='c8rz51za' Or [**Parent]='vlifr1za' Or [**Parent]='pf00s1zj' Or [**Parent]='thj2f1za' Or [**Parent]='jdc9d1za' Or [**Parent]='trq5f1za' Or [**Parent]='rr9r51za' Or [**Parent]='lm0061za' Or [**Parent]='ru3zt1za' Or [**Parent]='pf01a1zj' Or [**Parent]='n79i91za' Or [**Parent]='pf0151zj' Or [**Parent]='pf0181zj' Or [**Parent]='pf00n1zj' Or [**Parent]='msi4s1za' Or [**Parent]='pf01j1zj' Or [**Parent]='scmfm1za' Or [**Parent]='sh9or1za' Or [**Parent]='wmi1l1za' Or [**Parent]='fwtwu1za' Or [**Parent]='pf0171zj' Or [**Parent]='pf00o1zj' Or [**Parent]='pf0131zj' Or [**Parent]='fhgu71za' Or [**Parent]='pf01c1zj' Or [**Parent]='6wzmj1za' Or [**Parent]='dn89j1za' Or [**Parent]='802i41za' Or [**Parent]='omgs41za' Or [**Parent]='7ivvt1za' Or [**Parent]='nnm091za' Or [**Parent]='pf0161zj' Or [**Parent]='pf01e1zj' Or [**Parent]='kdk5l1za' Or [**Parent]='9b59o1za' Or [**Parent]='pf00i1zj' Or [**Parent]='pf0061zj' Or [**Parent]='gmz1h1za' Or [**Parent]='pc0021zz' Or [**Parent]='s0034981' Or [**Parent]='s0066977' Or [**Parent]='s0065977' Or [**Parent]='s0064977' Or [**Parent]='wn8on1hb' Or [**Parent]='009011z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent] = 'pg40q1z6' OR [**Parent] = '1iouh1z6' OR [**Parent] = 'ucqpv1z6' OR [**Parent] = 'v7wct1z6' OR [**Parent] = 'qfcgb1z6' OR [**Parent] = 'h227t1z6' OR [**Parent] = 'dcq3n1z6' OR [**Parent] = '8z5ub1z6' OR [**Parent] = 'o48k81z6' OR [**Parent] = '79wvq1z6' OR [**Parent] = 'icf081zz' OR [**Parent] = 's6340021' OR [**Parent] = 's6340022'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz101z0' Or [**Parent]='zzz431z0' Or [**Parent]='zzz441z0' Or [**Parent]='zzz121z0' Or [**Parent]='zzz111z0' Or [**Parent]='zzz131z0' Or [**Parent]='zzz171z0' Or [**Parent]='zzz151z0' Or [**Parent]='zzz141z0' Or [**Parent]='zzz291z0' Or [**Parent]='s2020370' Or [**Parent]='zzz191z0' Or [**Parent]='zzz271z0' Or [**Parent]='zzz231z0' Or [**Parent]='zzz321z0' Or [**Parent]='zzz261z0' Or [**Parent]='zzz201z0' Or [**Parent]='s2020371' Or [**Parent]='zzz341z0' Or [**Parent]='zzz221z0' Or [**Parent]='zzz241z0' Or [**Parent]='zzz251z0' Or [**Parent]='zzz281z0' Or [**Parent]='zzz311z0' Or [**Parent]='zzz211z0' Or [**Parent]='zzz331z0' Or [**Parent]='s2020372' Or [**Parent]='zzz361z0' Or [**Parent]='zzz371z0' Or [**Parent]='zzz381z0' Or [**Parent]='s2020373' Or [**Parent]='zzz401z0' Or [**Parent]='zzz391z0' Or [**Parent]='s2020374' Or [**Parent]='zzz421z0' Or [**Parent]='zzz411z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz081z0'


_filterSql:
Select * From Taxa Where [**Parent]='spr011z0' Or [**Parent]='spr021z0' Or [**Parent]='spr031z0' Or [**Parent]='spr041z0' Or [**Parent]='spr051z0' Or [**Parent]='spr061z0' Or [**Parent]='spr071z0' Or [**Parent]='spr081z0' Or [**Parent]='spr091z0' Or [**Parent]='spr101z0' Or [**Parent]='spr111z0' Or [**Parent]='spr121z0' Or [**Parent]='spr131z0' Or [**Parent]='spr141z0' Or [**Parent]='spr151z0' Or [**Parent]='spr171z0' Or [**Parent]='spr181z0' Or [**Parent]='spr191z0' Or [**Parent]='spr201z0' Or [**Parent]='spr211z0' Or [**Parent]='spr221z0' Or [**Parent]='spr231z0' Or [**Parent]='spr241z0' Or [**Parent]='spr251z0' Or [**Parent]='spr261z0' Or [**Parent]='spr271z0' Or [**Parent]='spr281z0' Or [**Parent]='spr291z0' Or [**Parent]='spr301z0' Or [**Parent]='spr311z0' Or [**Parent]='spr321z0' Or [**Parent]='sp8011zj' Or [**Parent]='sp8001zj' Or [**Parent]='s8002zzz' Or [**Parent]='s8000zzz' Or [**Parent]='s8001zzz' Or [**Parent]='s8002zzz' Or [**Parent]='1020t1z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz171z0' Or [**Parent]='zzz151z0' Or [**Parent]='zzz141z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz291z0' Or [**Parent]='s2020370' Or [**Parent]='zzz191z0' Or [**Parent]='zzz271z0' Or [**Parent]='zzz231z0' Or [**Parent]='zzz321z0' Or [**Parent]='zzz261z0' Or [**Parent]='zzz201z0' Or [**Parent]='s2020371' Or [**Parent]='zzz341z0' Or [**Parent]='zzz221z0' Or [**Parent]='zzz241z0' Or [**Parent]='zzz251z0' Or [**Parent]='zzz281z0' Or [**Parent]='zzz311z0' Or [**Parent]='zzz211z0' Or [**Parent]='zzz331z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='amp0c1z0' Or [**Parent]='amp0e1z0' Or [**Parent]='amp0d1z0' Or [**Parent]='amp0f1z0' Or [**Parent]='amp0g1z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='rep0c1z0' Or [**Parent]='rep0d1z0' Or [**Parent]='rep0b1z0' Or [**Parent]='rep0e1z0' Or [**Parent]='002791z1' Or [**Parent]='002811z1' Or [**Parent]='002861z1'


_filterSql:
Select * From Taxa Where [**Parent]='opo231z0' Or [**Parent]='opo241z0' Or [**Parent]='opo251z0' Or [**Parent]='opo261z0' Or [**Parent]='opo271z0' Or [**Parent]='opo321z0' Or [**Parent]='s1803024'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='emp051zj'


_filterSql:
Select * From Taxa Where [**Parent]='psp301z0' Or [**Parent]='psp291z0' Or [**Parent]='psp281z0' Or [**Parent]='psp271z0' Or [**Parent]='psp301z0' Or [**Parent]='psp311z0' Or [**Parent]='psp411z0'


_filterName:
Mollusca: Terrestrial and Freshwater molluscs

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='mzt011z0' Or [**Parent]='mzt021z0' Or [**Parent]='mzt031z0' Or [**Parent]='mzt041z0' Or [**Parent]='mzt051z0' Or [**Parent]='mzt061z0' Or [**Parent]='mzt071z0' Or [**Parent]='mzt081z0' Or [**Parent]='mzt091z0' Or [**Parent]='mzt101z0' Or [**Parent]='mzt111z0' Or [**Parent]='mzt121z0' Or [**Parent]='mzt131z0' Or [**Parent]='mzt141z0' Or [**Parent]='mzt151z0' Or [**Parent]='mzt161z0' Or [**Parent]='mzt171z0' Or [**Parent]='mzt181z0' Or [**Parent]='mzt191z0' Or [**Parent]='mzt201z0' Or [**Parent]='mzt211z0' Or [**Parent]='mzt221z0' Or [**Parent]='mzt231z0' Or [**Parent]='mzt241z0' Or [**Parent]='mzt251z0' Or [**Parent]='mzt261z0' Or [**Parent]='mzt271z0' Or [**Parent]='mzt281z0' Or [**Parent]='mzt291z0' Or [**Parent]='mzt301z0' Or [**Parent]='mzt311z0' Or [**Parent]='mzt321z0' Or [**Parent]='mzt331z0' Or [**Parent]='mzt341z0' Or [**Parent]='mzt351z0' Or [**Parent]='mzt361z0' Or [**Parent]='mzt371z0' Or [**Parent]='mzt381z0' Or [**Parent]='mzt391z0' Or [**Parent]='mzt401z0' Or [**Parent]='mzt411z0' Or [**Parent]='s9670011' Or [**Parent]='mzt311z0' Or [**Parent]='mzt131z0' Or [**Parent]='mzt781z0' Or [**Parent]='mzt351z0' Or [**Parent]='mzt221z0' Or [**Parent]='mzt391z0' Or [**Parent]='mzt381z0' Or [**Parent]='mzt361z0' Or [**Parent]='s9670011' Or [**Parent]='mzt331z0' Or [**Parent]='mzt321z0' Or [**Parent]='mzt771z0' Or [**Parent]='mzt761z0' Or [**Parent]='mzt301z0' Or [**Parent]='mzt291z0' Or [**Parent]='mzt281z0' Or [**Parent]='mzt751z0' Or [**Parent]='mzt741z0' Or [**Parent]='mzt261z0' Or [**Parent]='mzt251z0' Or [**Parent]='mzt411z0' Or [**Parent]='mzt731z0' Or [**Parent]='mzt721z0' Or [**Parent]='mzt231z0' Or [**Parent]='mzt211z0' Or [**Parent]='mzt201z0' Or [**Parent]='mzt711z0' Or [**Parent]='mzt701z0' Or [**Parent]='mzt691z0' Or [**Parent]='mzt681z0' Or [**Parent]='mzt181z0' Or [**Parent]='mzt671z0' Or [**Parent]='mzt171z0' Or [**Parent]='mzt161z0' Or [**Parent]='mzt151z0' Or [**Parent]='mzt141z0' Or [**Parent]='mzt121z0' Or [**Parent]='mzt111z0' Or [**Parent]='mzt661z0' Or [**Parent]='mzt101z0' Or [**Parent]='mzt091z0' Or [**Parent]='mzt651z0' Or [**Parent]='mzt081z0' Or [**Parent]='mzt071z0' Or [**Parent]='mzt041z0' Or [**Parent]='mzt021z0' Or [**Parent]='mzt031z0' Or [**Parent]='mzt371z0' Or [**Parent]='mzt341z0' Or [**Parent]='mzt631z0' Or [**Parent]='mzt271z0' Or [**Parent]='mzt191z0' Or [**Parent]='mzt621z0' Or [**Parent]='mzt061z0' Or [**Parent]='mzt051z0' Or [**Parent]='mzt611z0' Or [**Parent]='mzt401z0' Or [**Parent]='mzt011z0' Or [**Parent]='mzt241z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='emp041zj' Or [**Parent]='emp031zj' Or [**Parent]='emp021zj' Or [**Parent]='emp011zj' Or [**Parent]='s93001z1'


_filterSql:
Select Taxa.* From Taxa Where [*Reference]='p3000zzz'


_filterSql:
Select Taxa.* From [Taxa] Where [**Parent]='8hphi1z1' Or [**Parent]='jqg601z1' Or [_guk]='s0003903'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='zxz411' Or [**Parent]='zxz401' Or [**Parent]='zxz561'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz521' Or [**Parent]='zxz521' Or [**Parent]='zxz241' Or [**Parent]='zxz131' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz031' Or [**Parent]='zxz051' Or [**Parent]='zxz151' Or [_guk]='lx0013fz' Or [**Parent]='zxz261' OR ([**Parent]='l951m1z1' AND Taxon Like 'Cosmopterix *') Or [_guk]='s7150001' Or [_guk]='s6340002' Or [_guk]='b001003'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent] = 'zxz101'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz361' Or [**Parent]='zxz171' Or [**Parent]='zxz381' Or [**Parent]='zxz321' Or [**Parent]='az026zzz' Or [**Parent]='zxz221' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1') And ([*Status] = '8fzkg1z1' Or [*Status] = 'klkkj1z1' Or [*Status]='r52sq1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz361' Or [**Parent]='zxz171' Or [**Parent]='zxz381' Or [**Parent]='zxz321' Or [**Parent]='az026zzz' Or [**Parent]='zxz221' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1') And ([*Status] = '0gdrs1z1' Or [*Status] = '1buqu1z1' Or [*Status] = '5mwip1z1' Or [*Status] = '8qj1w1z1' Or [*Status] = '9ug4g1z1' Or [*Status] = 'bu1t41z1' Or [*Status] = 'cdt1d1z1' Or [*Status] = 'drl9l1z1' Or [*Status] = 'flq851z1' Or [*Status] = 'gn2of1z1' Or [*Status] = 'imcpi1z1' Or [*Status] = 'jfgb31z1' Or [*Status] = 'l4uw31z1' Or [*Status] = 'r8i2s1z1' Or [*Status] = 'ubhr41z1' Or [*Status] = 'vsm2u1z1' Or [*Status] = 'zumuc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='5t7sk1z1' Or [**Parent]='8325l1z1' Or [**Parent]='98un41z1' Or [**Parent]='lz8rq1z1' Or [**Parent]='nr13n1z1' Or [**Parent]='o4fvi1z1' Or [**Parent]='pgh531z1' Or [**Parent]='rh9t31z1' Or [**Parent]='wtk3n1z1'


_filterSql:
SELECT Taxa.* FROM Taxa INNER JOIN BAPP ON Taxa.[_guk] = BAPP.[_guk] WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz361' Or [**Parent]='zxz171' Or [**Parent]='zxz381' Or [**Parent]='zxz321' Or [**Parent]='az026zzz' Or [**Parent]='zxz221' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='cl42t1z1' Or [**Parent]='fo5mt1z1' Or [**Parent]='h417f1z1' Or [**Parent]='lumlc1z1' Or [**Parent]='ovmts1z1' Or [**Parent]='ruqb51z1' Or [**Parent]='vf7b31z1' Or [**Parent]='zlfw31z1' Or [**Parent]='zlfxi1z1' Or [**Parent]='zxgxi1z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='30fjr1z1' Or [**Parent]='9bzqn1z1' Or [**Parent]='bf7nz1z1' Or [**Parent]='mc8c91z1' Or [**Parent]='n40us1z1' Or [**Parent]='ssgrc1z1' Or [**Parent]='wiuoi1z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='fnihf1z1' Or [**Parent]='isp791z1' Or [**Parent]='s9206070'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='4bmvz1z1' Or [**Parent]='ct7zu1z1' Or [**Parent]='j918u1z1' Or [**Parent]='s9206065'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='0t1hk1z1' Or [**Parent]='2fjgr1z1' Or [**Parent]='87t3l1z1' Or [**Parent]='mg9vp1z1' Or [**Parent]='own0g1z1' Or [**Parent]='n00011zj'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='56pb81z1' Or [**Parent]='g67t51z1' Or [**Parent]='sdh771z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='s7150009' Or [**Parent]='s7150010' Or [**Parent]='1c13t1z1' Or [**Parent]='czlqt1z1' Or [**Parent]='i09791z1' Or [**Parent]='qgvmv1z1' Or [**Parent]='6osb21z1' Or [**Parent]='dn1h11z1' Or [**Parent]='8pn1z1z1' Or [**Parent]='o2nbk1z1' Or [**Parent]='02qb41z1' Or [**Parent]='2vf8f1z1' Or [**Parent]='pwqrq1z1' Or [**Parent]='l4vm71z1' Or [**Parent]='ssv171z1' Or [**Parent]='1mllt1z1' Or [**Parent]='3g6i31z1' Or [**Parent]='bpn3p1z1' Or [**Parent]='4rqsl1z1' Or [**Parent]='hfth51z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='1u2qt1z1' Or [**Parent]='21gh51z1' Or [**Parent]='2ost71z1' Or [**Parent]='372631z1' Or [**Parent]='73tu31z1' Or [**Parent]='7u5wq1z1' Or [**Parent]='f4l9m1z1' Or [**Parent]='gwsi01z1' Or [**Parent]='ksns21z1' Or [**Parent]='pt0mu1z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='d2p3z1zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='d05fj1zj' Or [**Parent]='df0011zj' Or [**Parent]='df0021zj' Or [**Parent]='df0031zj' Or [**Parent]='df0041zj' Or [**Parent]='df0051zj' Or [**Parent]='df0061zj' Or [**Parent]='df0071zj' Or [**Parent]='df0081zj' Or [**Parent]='df0091zj' Or [**Parent]='df0101zj' Or [**Parent]='df0111zj' Or [**Parent]='df0121zj' Or [**Parent]='df0131zj' Or [**Parent]='df0141zj' Or [**Parent]='df0151zj' Or [**Parent]='df0161zj' Or [**Parent]='df0171zj' Or [**Parent]='df0181zj' Or [**Parent]='df0191zj' Or [**Parent]='df0201zj' Or [**Parent]='df0211zj' Or [**Parent]='df0221zj' Or [**Parent]='df0231zj' Or [**Parent]='df0241zj' Or [**Parent]='df0251zj' Or [**Parent]='df0291zj' Or [**Parent]='df0301zj' Or [**Parent]='df0311zj' Or [**Parent]='df0321zj' Or [**Parent]='d2p3z1zj' Or [**Parent]='df0341zj' Or [**Parent]='df0351zj' Or [**Parent]='df0361zj' Or [**Parent]='df0411zj' Or [**Parent]='df0421zj' Or [**Parent]='df0431zj' Or [**Parent]='df0441zj' Or [**Parent]='df0451zj' Or [**Parent]='df0471zj' Or [**Parent]='df0481zj' Or [**Parent]='df0491zj' Or [**Parent]='df0501zj' Or [**Parent]='df0511zj' Or [**Parent]='df0521zj' Or [**Parent]='df0531zj' Or [**Parent]='df0551zj' Or [**Parent]='df0561zj' Or [**Parent]='df0571zj' Or [**Parent]='df0581zj' Or [**Parent]='df0591zj' Or [**Parent]='df0601zj' Or [**Parent]='df0621zj' Or [**Parent]='df0631zj' Or [**Parent]='df0641zj' Or [**Parent]='df0651zj' Or [**Parent]='df0661zj' Or [**Parent]='df0671zj' Or [**Parent]='df0681zj' Or [**Parent]='df0691zj' Or [**Parent]='df0701zj' Or [**Parent]='df0711zj' Or [**Parent]='df0721zj' Or [**Parent]='df0731zj' Or [**Parent]='df0741zj' Or [**Parent]='df0751zj' Or [**Parent]='df0761zj' Or [**Parent]='df0771zj' Or [**Parent]='df0781zj' Or [**Parent]='df0791zj' Or [**Parent]='df0801zj' Or [**Parent]='df0811zj' Or [**Parent]='df0821zj' Or [**Parent]='df0831zj' Or [**Parent]='df0841zj' Or [**Parent]='df0851zj' Or [**Parent]='df0861zj' Or [**Parent]='df0871zj' Or [**Parent]='df0881zj' Or [**Parent]='df0891zj' Or [**Parent]='df0901zj' Or [**Parent]='df0911zj' Or [**Parent]='df0921zj' Or [**Parent]='df0931zj' Or [**Parent]='df0941zj' Or [**Parent]='df0951zj' Or [**Parent]='df0961zj' Or [**Parent]='df0971zj' Or [**Parent]='df0981zj' Or [**Parent]='df0991zj' Or [**Parent]='df1001zj' Or [**Parent]='df1011zj' Or [**Parent]='df1021zj' Or [**Parent]='dpi011zj' Or [**Parent]='dpi021zj' Or [**Parent]='dpi031zj' Or [**Parent]='emp011zj' Or [**Parent]='emp021zj' Or [**Parent]='emp031zj' Or [**Parent]='emp041zj' Or [**Parent]='emp051zj' Or [**Parent]='jhnz51z1' Or [**Parent]='dpi031z0' Or [**Parent]='se0201z1' Or [**Parent]='s93001z1' Or [**Parent]='d81011zj' Or [**Parent]='d81021zj' Or [**Parent]='d81031zj' Or [**Parent]='d81041zj' Or [**Parent]='d81051zj' Or [**Parent]='d81061zj'Or [**Parent]='s2020140' Or [**Parent]='s2020141' Or [**Parent]='df1101zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zcp051zj' Or [**Parent]='zcp061zj' Or [**Parent]='zcp071zj' Or [**Parent]='zcp081zj' Or [**Parent]='zcp091zj' Or [**Parent]='zcp101zj' Or [**Parent]='zcp111zj' Or [**Parent]='zcp121zj' Or [**Parent]='zcp131zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zmp071zj' Or [**Parent]='zmp081zj' Or [**Parent]='zmp091zj' Or [**Parent]='zmp101zj' Or [**Parent]='zmp111zj' Or [**Parent]='zmp121zj' Or [**Parent]='zmp131zj' Or [**Parent]='zmp141zj' Or [**Parent]='zmp151zj' Or [**Parent]='zmp161zj' Or [**Parent]='zmp171zj' Or [**Parent]='zmp181zj' Or [**Parent]='zmp191zj' Or [**Parent]='zmp201zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='dpi011zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='dpi021zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='dpi031zj' Or [**Parent]='dpi031z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='6libp1zb' Or [**Parent]='e0i6u1zb' Or [**Parent]='qn77i1zb'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rwc001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbp001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhv001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmy001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='raw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlf001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfy001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rri001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcy001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='roz001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rot001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rse001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmo001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcf001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbz001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='roa001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbg001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rkk001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rdi001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfs001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbo001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbd001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbt001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rrh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbj001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rag001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rof001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rwv001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rli001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rdv001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsb001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlt001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rft001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rvi001z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0011zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0011zj' Or [**Parent]='df0021zj' Or [**Parent]='df0031zj' Or [**Parent]='df0041zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0051zj' Or [**Parent]='df0061zj' Or [**Parent]='df0071zj' Or [**Parent]='df0081zj' Or [**Parent]='df0091zj' Or [**Parent]='df0101zj' Or [**Parent]='df0111zj' Or [**Parent]='df0121zj' Or [**Parent]='df0131zj' Or [**Parent]='df0141zj' Or [**Parent]='df0151zj' Or [**Parent]='df0161zj' Or [**Parent]='df0171zj' Or [**Parent]='df0181zj' Or [**Parent]='df0191zj' Or [**Parent]='df0201zj' Or [**Parent]='df0211zj' Or [**Parent]='df0221zj' Or [**Parent]='df0231zj' Or [**Parent]='df0241zj' Or [**Parent]='df0251zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='dpi011zj' Or [**Parent]='dpi021zj' Or [**Parent]='dpi031zj' Or [**Parent]='df0291zj' Or [**Parent]='df0301zj' Or [**Parent]='df0311zj' Or [**Parent]='df0321zj' Or [**Parent]='d2p3z1zj' Or [**Parent]='df0341zj' Or [**Parent]='df0351zj' Or [**Parent]='df0361zj' Or [**Parent]='dpi031z0'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0421zj' Or [**Parent]='df0431zj' Or [**Parent]='df0441zj' Or [**Parent]='df0451zj' Or [**Parent]='jhnz51z1' Or [**Parent]='df0471zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0481zj' Or [**Parent]='df0491zj' Or [**Parent]='df0501zj' Or [**Parent]='df0511zj' Or [**Parent]='df0521zj' Or [**Parent]='df0531zj' Or [**Parent]='d05fj1zj' Or [**Parent]='df0551zj' Or [**Parent]='df0561zj' Or [**Parent]='df0571zj' Or [**Parent]='df0581zj' Or [**Parent]='df0591zj' Or [**Parent]='df0601zj' Or [**Parent]='emp051zj' Or [**Parent]='df0621zj' Or [**Parent]='df0631zj' Or [**Parent]='df0641zj' Or [**Parent]='df0651zj' Or [**Parent]='df0661zj' Or [**Parent]='df0671zj' Or [**Parent]='df0681zj' Or [**Parent]='df0691zj' Or [**Parent]='df0701zj' Or [**Parent]='df0711zj' Or [**Parent]='df0721zj' Or [**Parent]='df0731zj' Or [**Parent]='df0741zj' Or [**Parent]='df0751zj' Or [**Parent]='df0761zj' Or [**Parent]='df0771zj' Or [**Parent]='df0781zj' Or [**Parent]='df0791zj' Or [**Parent]='df0801zj' Or [**Parent]='df0811zj' Or [**Parent]='df0821zj' Or [**Parent]='df0831zj' Or [**Parent]='df0841zj' Or [**Parent]='df0851zj' Or [**Parent]='df0861zj' Or [**Parent]='df0871zj' Or [**Parent]='df0881zj' Or [**Parent]='df0891zj' Or [**Parent]='df0901zj' Or [**Parent]='df0911zj' Or [**Parent]='se0201z1' Or [**Parent]='d81011zj' Or [**Parent]='d81021zj' Or [**Parent]='d81031zj' Or [**Parent]='d81041zj' Or [**Parent]='d81051zj' Or [**Parent]='d81061zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0921zj' Or [**Parent]='df0931zj' Or [**Parent]='df0941zj' Or [**Parent]='df0951zj' Or [**Parent]='df0961zj' Or [**Parent]='df0971zj' Or [**Parent]='df0981zj' Or [**Parent]='df0991zj' Or [**Parent]='df1001zj' Or [**Parent]='df1011zj' Or [**Parent]='df1021zj'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='pf0091zj' Or [**Parent]='n1jrl1za' Or [**Parent]='2lkkr1za' Or [**Parent]='pf01g1zj' Or [**Parent]='di7791za' Or [**Parent]='oscrw1za' Or [**Parent]='pf01p1zj' Or [**Parent]='l5flf1za' Or [**Parent]='i0j181za' Or [**Parent]='lvh3c1za' Or [**Parent]='b6vww1za' Or [**Parent]='c8i8f1za' Or [**Parent]='64n5w1za' Or [**Parent]='ltv001za' Or [**Parent]='bjiql1za' Or [**Parent]='bsbmz1za' Or [**Parent]='i5hn21za' Or [**Parent]='c3vkc1za' Or [**Parent]='tnznd1za' Or [**Parent]='bf4bs1za' Or [**Parent]='9m1ww1za' Or [**Parent]='hbvl71za' Or [**Parent]='m012l1za' Or [**Parent]='pf0081zj' Or [**Parent]='pf00j1zj' Or [**Parent]='7cgwt1za' Or [**Parent]='n0d2p1za' Or [**Parent]='pf0191zj' Or [**Parent]='mbctz1za' Or [**Parent]='pf01i1zj' Or [**Parent]='sl37c1za' Or [**Parent]='sjjut1za' Or [**Parent]='wn8on1za' Or [**Parent]='pf00b1zj' Or [**Parent]='fpgff1za' Or [**Parent]='7qd131za' Or [**Parent]='of1s11za' Or [**Parent]='pcow01za' Or [**Parent]='4gcu91za' Or [**Parent]='z15q51za' Or [**Parent]='v4q9r1za' Or [**Parent]='pf00k1zj' Or [**Parent]='pf00d1zj' Or [**Parent]='fdgrr1za' Or [**Parent]='3fczu1za' Or [**Parent]='86kk41za' Or [**Parent]='pf01n1zj' Or [**Parent]='7zhbq1za' Or [**Parent]='7jhs01za' Or [**Parent]='ngr8w1za' Or [**Parent]='pf00y1zj' Or [**Parent]='pf01h1zj' Or [**Parent]='p2t8m1za' Or [**Parent]='kdu5g1za' Or [**Parent]='pf00f1zj' Or [**Parent]='pf00q1zj' Or [**Parent]='313j51za' Or [**Parent]='bw89k1za' Or [**Parent]='4kdv21za' Or [**Parent]='h9fd51za' Or [**Parent]='ictgk1za' Or [**Parent]='pf00r1zj' Or [**Parent]='fdwr71za' Or [**Parent]='pf01l1zj' Or [**Parent]='6vm7z1za' Or [**Parent]='3055f1za' Or [**Parent]='80s2v1za' Or [**Parent]='pf00c1zj' Or [**Parent]='o4dq81za' Or [**Parent]='nsisw1za' Or [**Parent]='m86dk1za' Or [**Parent]='pf0071zj' Or [**Parent]='pf00v1zj' Or [**Parent]='srnc01za' Or [**Parent]='w6iuk1za' Or [**Parent]='fls5u1za' Or [**Parent]='pf00m1zj' Or [**Parent]='1qi7u1za' Or [**Parent]='uwkji1za' Or [**Parent]='tv36c1za' Or [**Parent]='pf01m1zj' Or [**Parent]='hhc3c1za' Or [**Parent]='rcjq71za' Or [**Parent]='8qvi41za' Or [**Parent]='pf00p1zj' Or [**Parent]='oundo1za' Or [**Parent]='pf01f1zj' Or [**Parent]='0g5tj1za' Or [**Parent]='2qod01za' Or [**Parent]='mh4s21za' Or [**Parent]='pf0121zj' Or [**Parent]='pf0111zj' Or [**Parent]='9vn9z1za' Or [**Parent]='gt2sh1za' Or [**Parent]='pf00x1zj' Or [**Parent]='5pgf21za' Or [**Parent]='pf01d1zj' Or [**Parent]='49dt21za' Or [**Parent]='if10l1za' Or [**Parent]='uvwio1za' Or [**Parent]='qugvn1za' Or [**Parent]='6qffn1za' Or [**Parent]='pf00a1zj' Or [**Parent]='diqlv1za' Or [**Parent]='89dfs1za' Or [**Parent]='jqd5r1za' Or [**Parent]='pf01b1zj' Or [**Parent]='0qo491za' Or [**Parent]='mnmfi1za' Or [**Parent]='szrpu1za' Or [**Parent]='slu2f1za' Or [**Parent]='pf00z1zj' Or [**Parent]='pf00t1zj' Or [**Parent]='pf00g1zj' Or [**Parent]='wikjp1za' Or [**Parent]='pf00u1zj' Or [**Parent]='pf0141zj' Or [**Parent]='pf01k1zj' Or [**Parent]='57p9l1za' Or [**Parent]='pqgtr1za' Or [**Parent]='4ir3g1za' Or [**Parent]='jh1zh1za' Or [**Parent]='t761m1za' Or [**Parent]='drduo1za' Or [**Parent]='pf00l1zj' Or [**Parent]='gmpnq1za' Or [**Parent]='pf00h1zj' Or [**Parent]='pf00w1zj' Or [**Parent]='0jh681za' Or [**Parent]='pf00e1zj' Or [**Parent]='c3w371za' Or [**Parent]='kv9pv1za' Or [**Parent]='9rv7p1za' Or [**Parent]='1gf3r1za' Or [**Parent]='fbbuq1za' Or [**Parent]='pf01o1zj' Or [**Parent]='1ns8f1za' Or [**Parent]='c8rz51za' Or [**Parent]='vlifr1za' Or [**Parent]='pf00s1zj' Or [**Parent]='thj2f1za' Or [**Parent]='jdc9d1za' Or [**Parent]='trq5f1za' Or [**Parent]='rr9r51za' Or [**Parent]='lm0061za' Or [**Parent]='ru3zt1za' Or [**Parent]='pf01a1zj' Or [**Parent]='n79i91za' Or [**Parent]='pf0151zj' Or [**Parent]='pf0181zj' Or [**Parent]='pf00n1zj' Or [**Parent]='msi4s1za' Or [**Parent]='pf01j1zj' Or [**Parent]='scmfm1za' Or [**Parent]='sh9or1za' Or [**Parent]='wmi1l1za' Or [**Parent]='fwtwu1za' Or [**Parent]='pf0171zj' Or [**Parent]='pf00o1zj' Or [**Parent]='pf0131zj' Or [**Parent]='fhgu71za' Or [**Parent]='pf01c1zj' Or [**Parent]='6wzmj1za' Or [**Parent]='dn89j1za' Or [**Parent]='802i41za' Or [**Parent]='omgs41za' Or [**Parent]='7ivvt1za' Or [**Parent]='nnm091za' Or [**Parent]='pf0161zj' Or [**Parent]='pf01e1zj' Or [**Parent]='kdk5l1za' Or [**Parent]='9b59o1za' Or [**Parent]='pf00i1zj' Or [**Parent]='pf0061zj' Or [**Parent]='gmz1h1za' Or [**Parent]='vm0011zj' Or [**Parent]='vm0021zj' Or [**Parent]='vm0031zj' Or [**Parent]='pc0021zz' Or [**Parent]='s0034981' Or [**Parent]='s0066977' Or [**Parent]='s0065977' Or [**Parent]='s0064977' Or [**Parent]='wn8on1hb' Or [**Parent]='009011z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='k00251zj' Or [**Parent]='k00261zj' Or [**Parent]='k00271zj' Or [**Parent]='k00281zj' Or [**Parent]='k00291zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df1011zj'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='sdh771z1' Or [**Parent]='g67t51z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='0t1hk1z1' Or [**Parent]='2fjgr1z1' Or [**Parent]='87t3l1z1' Or [**Parent]='dgsi11z1' Or [**Parent]='mg9vp1z1' Or [**Parent]='own0g1z1' Or [**Parent]='th5f51z1' Or [**Parent]='n00011zj' Or [**Parent]='sdh771z1' Or [**Parent]='g67t51z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='th5f51z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='dgsi11z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0061zj' Or [**Parent]='df0071zj' Or [**Parent]='df0081zj' Or [**Parent]='df0091zj' Or [**Parent]='df0101zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0411zj' Or [_guk]='ez3841zj' Or [_guk]='ez3851zj' Or [_guk]='ez3861zj'


_filterName:
Insecta: Diptera: Small Acalypterate families

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0481zj' Or [**Parent]='df0491zj' Or [**Parent]='df0501zj' Or [**Parent]='df0511zj' Or [**Parent]='df0521zj' Or [**Parent]='df0531zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0421zj' Or [**Parent]='df0431zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0551zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0601zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0661zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0671zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0831zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0951zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0251zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0191zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df0471zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='a03791zj' Or [**Parent]='a03801zj' Or [**Parent]='a03811zj' Or [**Parent]='a03821zj' Or [**Parent]='a03831zj' Or [**Parent]='a03841zj' Or [**Parent]='a03851zj' Or [**Parent]='a03871zj' Or [**Parent]='s9600001'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='h0022100'


_filterSql:
Select Taxa.* From Taxa Where ([*Reference]='bryx2021' Or [*Reference]='bryo2009') And [*TaxonType]<>'wcj591z1'


_filterSql:
Select Taxa.* From Taxa Where ([*Reference]='bryx2021' Or [*Reference]='bryo2009') And [*TaxonType]<>'wcj591z1' And [Code] Like 'H*'


_filterSql:
Select Taxa.* From Taxa Where ([*Reference]='bryx2021' Or [*Reference]='bryo2009') And [*TaxonType]<>'wcj591z1' And [Code] Like 'M*'


_filterSql:
Select Taxa.* From Taxa Where ([*Reference]='bryx2021' Or [*Reference]='bryo2009') And [*TaxonType]<>'wcj591z1' And [Code] Like 'L*'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='hf0371zz' Or [**Parent]='hf0141zz' Or [**Parent]='hf0311zz' Or [**Parent]='hf0211zz' Or [**Parent]='hf0061zz' Or [**Parent]='hf0241zz' Or [**Parent]='hf0261zz' Or [**Parent]='hf0011zz' Or [**Parent]='hf0221zz' Or [**Parent]='hf0301zz' Or [**Parent]='hf0041zz' Or [**Parent]='hf0331zz' Or [**Parent]='hf0021zz' Or [**Parent]='hf0131zz' Or [**Parent]='hf0101zz' Or [**Parent]='hf0111zz' Or [**Parent]='hf0161zz' Or [**Parent]='hf0271zz' Or [**Parent]='hf0091zz' Or [**Parent]='hf0181zz' Or [**Parent]='hf0191zz' Or [**Parent]='hf0201zz' Or [**Parent]='hf0051zz' Or [**Parent]='hf0031zz' Or [**Parent]='hf0071zz' Or [**Parent]='hf0361zz' Or [**Parent]='hf0251zz' Or [**Parent]='hf0081zz' Or [**Parent]='hf0281zz' Or [**Parent]='hf0231zz' Or [**Parent]='hf0321zz' Or [**Parent]='hf0151zz' Or [**Parent]='hf0351zz' Or [**Parent]='hf0291zz' Or [**Parent]='hf0341zz' Or [**Parent]='hf0171zz' Or [**Parent]='hf0121zz' Or [**Parent]='h00492xh'


_filterSql:
Select Taxa.* From Taxa Where ([**Parent]='s96411z1' Or [**Parent]='zzz0f1z0' Or [**Parent]='s2020375' Or [**Parent]='dvm4n1z1' Or [**Parent]='s2020376' Or [**Parent]='s2020377' Or [**Parent]='s2020378' Or [**Parent]='s2020379' Or [**Parent]='zzz031z0' Or [**Parent]='zzz041z0' Or [**Parent]='zzz061z0' Or [**Parent]='acu001z0' Or [**Parent]='zzz081z0' Or [**Parent]='zzz0c1z0' Or [**Parent]='zzz0d1z0' Or [**Parent]='zzz0e1z0' Or [**Parent]='s2020380' Or [**Parent]='zzz0g1z0' Or [**Parent]='zzz0h1z0') And Taxa.[_guk]=Taxa.[**RefersTo] And Taxa.[_guk]<>'h32071zj'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='icf0c1zz' Or [**Parent]='icf0b1zz' Or [**Parent]='icf0a1zz' Or [**Parent]='icf091zz' Or [**Parent]='icf081zz' Or [**Parent]='icf071zz' Or [**Parent]='icf061zz' Or [**Parent]='icf051zz' Or [**Parent]='icf041zz' Or [**Parent]='icf031zz' Or [**Parent]='icf021zz' Or [**Parent]='icf011zz' Or [**Parent]='pg40q1z6' Or [**Parent]='1iouh1z6' Or [**Parent]='ucqpv1z6' Or [**Parent]='v7wct1z6' Or [**Parent]='qfcgb1z6' Or [**Parent]='h227t1z6' Or [**Parent]='dcq3n1z6' Or [**Parent]='8z5ub1z6' Or [**Parent]='o48k81z6' Or [**Parent]='79wvq1z6'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='icf011zz'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='icf021zz'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='icf031zz' Or [**Parent]='icf041zz' Or [**Parent]='icf051zz' Or [**Parent]='icf061zz' Or [**Parent]='icf071zz'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='icf091zz' Or [**Parent]='icf0a1zz' Or [**Parent]='icf0b1zz' Or [**Parent]='icf0c1zz'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='m00021zz' Or [**Parent]='m00031zz' Or [**Parent]='m00071zz' Or [**Parent]='m00091zz' Or [**Parent]='m00131zz' Or [**Parent]='m00141zz' Or [**Parent]='m00171zz'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='m00021zz' Or [**Parent]='m00031zz' Or [**Parent]='m00071zz' Or [**Parent]='m00091zz' Or [**Parent]='m00131zz' Or [**Parent]='m00141zz' Or [**Parent]='m00171zz' Or [**Parent]='4w7hp1z1' Or [**Parent]='m00121zz'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='dg1jv1z1' Or [**Parent]='gl4651z1' Or [**Parent]='dqkcs1z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='m00121zz' Or [**Parent]='m00161zz' Or [**Parent]='96udj1z1' Or [**Parent]='1h7ff1z1' Or [**Parent]='540ok1z1' Or [**Parent]='4w7hp1z1' Or [**Parent]='s9670008'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='2urqq1z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='dwdon1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='006691zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='s92351zb' OR [**Parent]='s92361zb' OR [**Parent]='mi7ko1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='jk09t1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='ne1io1zb' OR [**Parent]='k3tc11zb' OR [**Parent]='s92371zb' OR [**Parent]='55onj1zb' OR [**Parent]='s92381zb' OR [**Parent]='0dryo1zb' OR [**Parent]='0erir1zb' OR [**Parent]='0ayam1zb' OR [**Parent]='bq18o1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='gwcqt1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='orzm41zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='b45511zb' Or [**Parent]='zgsv01zb' Or [**Parent]='cilgh1zb' Or [**Parent]='icnjm1zb'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='psf011zz' Or [**Parent]='psf021zz' Or [**Parent]='psf031zz' Or [**Parent]='psf041zz' Or [**Parent]='psf051zz' Or [**Parent]='psf061zz' Or [**Parent]='psf071zz' Or [**Parent]='psf081zz' Or [**Parent]='psf091zz' Or [**Parent]='psf101zz' Or [**Parent]='psf111zz' Or [**Parent]='psf121zz' Or [**Parent]='psf131zz' Or [**Parent]='psf141zz' Or [**Parent]='psf151zz' Or [**Parent]='psf171zz' Or [**Parent]='psf181zz' Or [**Parent]='psf191zz' Or [**Parent]='s03801z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='lx0051zz' Or [**Parent]='lx0061zz' Or [**Parent]='lx0071zz' Or [**Parent]='lx0081zz'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='c00102fz' Or [**Parent]='c00112fz' Or [**Parent]='c00122fz' Or [**Parent]='c00132fz' Or [**Parent]='c00142fz' Or [**Parent]='c00152fz' Or [**Parent]='c00162fz' Or [**Parent]='c00172fz' Or [**Parent]='c00182fz' Or [**Parent]='c00192fz' Or [**Parent]='c00202fz' Or [**Parent]='c00212fz' Or [**Parent]='c00222fz'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]>='ba0402fz' And [**Parent]<='ba1662fz'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='h0053100'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN Clng(DateSerial(2020, 1, 1)) AND Clng(DateSerial(2020, 12, 31))


_filterSql:
Select Taxa.* From Taxa Where [*Reference]='bryo2009'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz431z0'


_filterSql:
Select Taxa.* From Taxa Where (([**Parent] Like 'avf2*') Or ([**Parent] Like 'p40*')) And ([*Reference] <> 'p3000zzz')


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='sf0013fz' Or [**Parent]='sf0023fz' Or [**Parent]='sf0033fz' Or [**Parent]='sf0043fz' Or [**Parent]='sf0053fz' Or [**Parent]='sf0063fz'


_filterSql:
SELECT * FROM Taxa WHERE (((Taxa.[**Parent]='spr011z0' Or Taxa.[**Parent]='spr021z0' Or Taxa.[**Parent]='spr031z0' Or Taxa.[**Parent]='spr041z0' Or Taxa.[**Parent]='spr051z0' Or Taxa.[**Parent]='spr061z0' Or Taxa.[**Parent]='spr071z0' Or Taxa.[**Parent]='spr081z0' Or Taxa.[**Parent]='spr091z0' Or Taxa.[**Parent]='spr101z0' Or Taxa.[**Parent]='spr111z0' Or Taxa.[**Parent]='spr121z0' Or Taxa.[**Parent]='spr131z0' Or Taxa.[**Parent]='spr141z0' Or Taxa.[**Parent]='spr151z0' Or Taxa.[**Parent]='spr171z0' Or Taxa.[**Parent]='spr181z0' Or Taxa.[**Parent]='spr191z0' Or Taxa.[**Parent]='spr201z0' Or Taxa.[**Parent]='spr211z0' Or Taxa.[**Parent]='spr221z0' Or Taxa.[**Parent]='spr231z0' Or Taxa.[**Parent]='spr241z0' Or Taxa.[**Parent]='spr251z0' Or Taxa.[**Parent]='spr261z0' Or Taxa.[**Parent]='spr271z0' Or Taxa.[**Parent]='spr281z0' Or Taxa.[**Parent]='spr291z0' Or Taxa.[**Parent]='spr301z0' Or Taxa.[**Parent]='spr311z0' Or Taxa.[**Parent]='spr321z0' Or Taxa.[**Parent]='sp8011zj' Or Taxa.[**Parent]='sp8001zj' Or Taxa.[**Parent]='s8001zzz' Or Taxa.[**Parent]='s8002zzz' Or Taxa.[**Parent]='s2020001' Or [**Parent]='1020t1z1') And (Taxa.[_guk]=Taxa.[**RefersTo] And Not Taxa.Taxon Like '*f.*' And Not Taxa.Taxon Like '*var.*' And Not Taxa.Taxon Like '* sp.*' And Taxa.[*Status]<>'ftztt1z1' And Taxa.[*Status]<>'u8nn11z1' And Taxa.[*Status]<>'klkkj1z1') Or Taxa.[_guk]='sp7871zj' Or Taxa.[_guk]='sp7801zj' Or Taxa.[_guk]='sp7791zj' Or Taxa.[_guk]='sp3261zj' Or Taxa.[_guk]='sp3271zj' Or Taxa.[_guk]='sp4181zj' Or Taxa.[_guk]='s8004zzz' Or Taxa.[_guk]='s8010zzz') And (Taxa.[_guk]<>'sp7081zj' And Taxa.[_guk]<>'sp7761zj' And Taxa.[_guk]<>'sp7631zj' And Taxa.[_guk]<>'sp7361zj' And Taxa.[_guk]<>'sp7451zj' And Taxa.[_guk]<>'sp7581zj' And Taxa.[_guk]<>'sp7421zj' And Taxa.[_guk]<>'sp7071zj' And Taxa.[_guk]<>'sp7601zj' And Taxa.[_guk]<>'sp7551zj' And Taxa.[_guk]<>'sp0451zj' And Taxa.[_guk]<>'sp2671zj' And Taxa.[_guk]<>'sp3251zj' And Taxa.[_guk]<>'sp7751zj' And Taxa.[_guk]<>'sp7871zj' And Taxa.[_guk]<>'s0002602')) Or (Taxa.[**Parent]='opo231z0' Or Taxa.[**Parent]='opo241z0' Or Taxa.[**Parent]='opo251z0' Or Taxa.[**Parent]='opo261z0' Or Taxa.[**Parent]='opo271z0' Or Taxa.[**Parent]='opo321z0' Or Taxa.[**Parent]='s1803024')


_filterName:
Vertebrata: Birds BOU A-C (excluding sub-species)

_filterSql:
Select Taxa.* From Taxa Where [*Reference]='p3000zzz' And [*TaxonType]='l7df61z1'


_filterSql:
Select Taxa.* From Taxa Where (([**Parent] Like 'avf2*') Or [**Parent]='psf161zz') And Taxa.[*TaxonType]<>'obitb1z1'


_filterSql:
Select Taxa.* From Taxa Where Taxa.[_guk] Between '003001z1' And '003561z1' Or ([_guk]='mf008tmf' Or [_guk]='mf009tmf' Or [_guk]='mf077tmf' Or [_guk]='mf081tmf' Or [_guk]='mf100tmf' Or [_guk]='mf101tmf' Or [_guk]='mf134tmf' Or [_guk]='mf166tmf' Or [_guk]='mf167tmf' Or [_guk]='mf168tmf' Or [_guk]='mf176tmf' Or [_guk]='mf213tmf' Or [_guk]='mf237tmf' Or [_guk]='mf289tmf' Or [_guk]='mf309tmf' Or [_guk]='mf310tmf')


_filterSql:
Select Taxa.* From [Taxa] Where [**Parent]='002791z1' Or [**Parent]='002811z1' Or [**Parent]='002861z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='jh1zh1za'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='s002905'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 38353 And Records.DateTo <= 38717


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0121zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0181zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0191zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0241zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0251zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0271zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0291zz' Or [**Parent]='am0301zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0421zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0461zz' Or [**Parent]='am0471zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0691zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0701zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0771zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0781zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0791zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0961zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am0981zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1051zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1121zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1151zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1301zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1311zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1411zz' Or [**Parent]='am1421zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1451zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1461zz' Or [**Parent]='am1471zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1491zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1501zz' Or [ViceCounty]=73


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1511zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1521zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1541zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1601zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1731zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1801zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1821zz' Or [**Parent]='am1831zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1901zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am1931zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2081zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2281zz' Or [**Parent]='am2291zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2301zz' Or [**Parent]='am2311zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2351zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2371zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2491zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2551zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2571zz' Or [**Parent]='am2581zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2651zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2821zz' Or [**Parent]='am2831zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='9oorm1z3' Or [**Parent]='am2901zz'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfa001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rde001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rti001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rei001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rnu001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcp001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbe001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rso001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rke001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rpr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbc001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rno001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rrt001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsa001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rln001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rad001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlu001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rvn001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rnm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbf001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='ric001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rar001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcc001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rba001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rle001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rld001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rco001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rho001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlc001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rab001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgk001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rul001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbl001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rnh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rdu001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbk001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rem001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rst001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlo001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgs001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmi001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rwy001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='ray001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rna001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rma001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlv001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcu001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rtu001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rls001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rry001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rtr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsk001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rra001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsn001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhd001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='riv001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcq001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlk001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rki001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rin001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='ril001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfo001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rpb001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='res001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rrm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rcl001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfg001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgb001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgc001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rms001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgn001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsl001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rci001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmt001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rty001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rgl001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsi001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmv001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfe001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='ris001z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='s0002903'


_filterSql:
SELECT Sites.* FROM Sites WHERE [Sites].[**Parent] = 'y6d3s1zz' OR [Sites].[**Parent] = 'u02551z1' OR [Sites].[**Parent] = 'k8sgm1zz' OR [Sites].[**Parent] = 'h6sfq1zz' OR [Sites].[**Parent] = 'u02611z1' OR [Sites].[**Parent] = 'u00101z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rfd001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rrs001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='roy001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rwm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rou001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rne001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rws001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhm001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rpa001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rnw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlg001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='ryh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhb001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlr001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rch001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rva001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rlw001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rpi001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rte001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='roh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rga001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhi001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rub001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmu001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rsf001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbh001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rbn001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rai001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rla001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rah001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rhy001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rpo001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rmz001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='rex001z1'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='amp0c1z0' Or [**Parent]='amp0e1z0' Or [**Parent]='amp0d1z0' Or [**Parent]='amp0f1z0' Or [**Parent]='amp0g1z0' Or [**Parent]='rep0c1z0' Or [**Parent]='rep0d1z0' Or [**Parent]='rep0b1z0' Or [**Parent]='rep0e1z0' Or [**Parent]='002791z1' Or [**Parent]='002811z1' Or [**Parent]='002861z1'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 38542


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='s0002991'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]>='h0001621' And [**Parent]<='h0257621'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 38718 And Records.DateTo <= 39082


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]>='h0001621' And [**Parent]<='h0257621') Or ([**Parent]>='ba0402fz' And [**Parent]<='ba1662fz')


_filterSql:
Select Sites.* From Sites Where [**Parent]='am2151z1'


_filterSql:
SELECT Taxa.* FROM Taxa INNER JOIN BPGSChecklist ON Taxa.[_guk] = BPGSChecklist.[_guk]


_filterSql:
SELECT Taxa.* FROM Taxa WHERE (Taxa.[**Parent] = 'az026zzz' Or Taxa.[**Parent] = 'zxz171' OR Taxa.[**Parent] = 'zxz221' OR Taxa.[**Parent] = 'zxz321' OR Taxa.[**Parent] = 'zxz361' OR Taxa.[**Parent] = 'zxz381') AND (Taxa.[*TaxonType] ='l7df61z1') AND (Taxa.[*Status] <> 'klkkj1z1') AND (Taxa.[_guk]=[Taxa].[**RefersTo]) AND (Taxa.[*Status]<>'o2squ1zj')


_filterSql:
SELECT Taxa.* FROM Taxa WHERE (Taxa.[**Parent] = 'az026zzz' Or Taxa.[**Parent] = 'zxz171' OR Taxa.[**Parent] = 'zxz221' OR Taxa.[**Parent] = 'zxz321' OR Taxa.[**Parent] = 'zxz361' OR Taxa.[**Parent] = 'zxz381') AND (Taxa.[*TaxonType]='l7df61z1') AND (Taxa.[*Status]<>'klkkj1z1') AND (Taxa.[*Status]<>'r52sq1z1') AND (Taxa.[*Status]<>'h5kzq1z1') AND (Taxa.[*Status]<>'o2squ1zj') AND (Taxa.[_guk]<>'s0011943') AND (Taxa.[_guk]=[Taxa].[**RefersTo])


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 38983


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz361' Or [**Parent]='zxz171' Or [**Parent]='zxz381' Or [**Parent]='zxz321' Or [**Parent]='az026zzz' Or [**Parent]='zxz221' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1') And [*TaxonType]='l7df61z1' And [_guk]=[**RefersTo]


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=79 Or [ViceCounty]=80


_filterSql:
Select Sites.* From Sites Where [**Parent]='trp001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='msn001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='hvi001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='van001z1'


_filterSql:
Select Sites.* From Sites Where [**Parent]='wcm001z1'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 39305


_filterSql:
SELECT Taxa.* From Taxa WHERE [**Parent]='df0581zj' Or [**Parent]='df0591zj' Or [**Parent]='df0561zj'


_filterSql:
Select Taxa.* From Taxa Where Taxa.[_guk]='as1571z1'


_filterSql:
Select Taxa.* From Taxa Where Taxa.[_guk]='as2971z1'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 39083 And Records.DateTo <= 39447


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 39448 And Records.DateTo <= 39813


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 40074 OR Records.Date = 40075


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date >= 39814 And Records.DateTo <= 40178


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 39606


_filterName:
Insecta: Diptera: Empid and Doli Recording Scheme

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='s93001z1' Or [**Parent]='emp041zj' Or [**Parent]='emp021zj' Or [**Parent]='emp011zj' Or [**Parent]='emp031zj' Or [**Parent]='df0411zj'


_filterName:
Insecta: Diptera: Empididae (sensu stricto)

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='emp011zj'


_filterName:
Insecta: Diptera: Hybotidae (sensu stricto)

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='emp021zj'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='k8oz81zb' Or [**Parent]='cum901zb' Or [**Parent]='528mi1zb' Or [**Parent]='415ks1zb' Or [**Parent]='i07up1zb' Or [**Parent]='qz2ik1zb' Or [**Parent]='9phub1zb' Or [**Parent]='w78ds1zb' Or [**Parent]='6gw4p1zb' Or [**Parent]='r080r1zb' Or [**Parent]='my1io1zb' Or [**Parent]='py1io1zb' Or [**Parent]='bvtl41zb' Or [**Parent]='sa1io1zb' Or [**Parent]='8blsj1zb' Or [**Parent]='orj3p1zb' Or [**Parent]='urt8i1zb'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='pf0091zj' Or [**Parent]='n1jrl1za' Or [**Parent]='2lkkr1za' Or [**Parent]='pf01g1zj' Or [**Parent]='di7791za' Or [**Parent]='oscrw1za' Or [**Parent]='pf01p1zj' Or [**Parent]='l5flf1za' Or [**Parent]='i0j181za' Or [**Parent]='lvh3c1za' Or [**Parent]='b6vww1za' Or [**Parent]='c8i8f1za' Or [**Parent]='64n5w1za' Or [**Parent]='ltv001za' Or [**Parent]='bjiql1za' Or [**Parent]='bsbmz1za' Or [**Parent]='i5hn21za' Or [**Parent]='c3vkc1za' Or [**Parent]='tnznd1za' Or [**Parent]='bf4bs1za' Or [**Parent]='9m1ww1za' Or [**Parent]='hbvl71za' Or [**Parent]='m012l1za' Or [**Parent]='pf0081zj' Or [**Parent]='pf00j1zj' Or [**Parent]='7cgwt1za' Or [**Parent]='n0d2p1za' Or [**Parent]='pf0191zj' Or [**Parent]='mbctz1za' Or [**Parent]='pf01i1zj' Or [**Parent]='sl37c1za' Or [**Parent]='sjjut1za' Or [**Parent]='wn8on1za' Or [**Parent]='pf00b1zj' Or [**Parent]='fpgff1za' Or [**Parent]='7qd131za' Or [**Parent]='of1s11za' Or [**Parent]='pcow01za' Or [**Parent]='4gcu91za' Or [**Parent]='z15q51za' Or [**Parent]='v4q9r1za' Or [**Parent]='pf00k1zj' Or [**Parent]='pf00d1zj' Or [**Parent]='fdgrr1za' Or [**Parent]='3fczu1za' Or [**Parent]='86kk41za' Or [**Parent]='pf01n1zj' Or [**Parent]='7zhbq1za' Or [**Parent]='7jhs01za' Or [**Parent]='ngr8w1za' Or [**Parent]='pf00y1zj' Or [**Parent]='pf01h1zj' Or [**Parent]='p2t8m1za' Or [**Parent]='kdu5g1za' Or [**Parent]='pf00f1zj' Or [**Parent]='pf00q1zj' Or [**Parent]='313j51za' Or [**Parent]='bw89k1za' Or [**Parent]='4kdv21za' Or [**Parent]='h9fd51za' Or [**Parent]='ictgk1za' Or [**Parent]='pf00r1zj' Or [**Parent]='fdwr71za' Or [**Parent]='pf01l1zj' Or [**Parent]='6vm7z1za' Or [**Parent]='3055f1za' Or [**Parent]='80s2v1za' Or [**Parent]='pf00c1zj' Or [**Parent]='o4dq81za' Or [**Parent]='nsisw1za' Or [**Parent]='m86dk1za' Or [**Parent]='pf0071zj' Or [**Parent]='pf00v1zj' Or [**Parent]='srnc01za' Or [**Parent]='w6iuk1za' Or [**Parent]='fls5u1za' Or [**Parent]='pf00m1zj' Or [**Parent]='1qi7u1za' Or [**Parent]='uwkji1za' Or [**Parent]='tv36c1za' Or [**Parent]='pf01m1zj' Or [**Parent]='hhc3c1za' Or [**Parent]='rcjq71za' Or [**Parent]='8qvi41za' Or [**Parent]='pf00p1zj' Or [**Parent]='oundo1za' Or [**Parent]='pf01f1zj' Or [**Parent]='0g5tj1za' Or [**Parent]='2qod01za' Or [**Parent]='mh4s21za' Or [**Parent]='pf0121zj' Or [**Parent]='pf0111zj' Or [**Parent]='9vn9z1za' Or [**Parent]='gt2sh1za' Or [**Parent]='pf00x1zj' Or [**Parent]='5pgf21za' Or [**Parent]='pf01d1zj' Or [**Parent]='49dt21za' Or [**Parent]='if10l1za' Or [**Parent]='uvwio1za' Or [**Parent]='qugvn1za' Or [**Parent]='6qffn1za' Or [**Parent]='pf00a1zj' Or [**Parent]='diqlv1za' Or [**Parent]='89dfs1za' Or [**Parent]='jqd5r1za' Or [**Parent]='pf01b1zj' Or [**Parent]='0qo491za' Or [**Parent]='mnmfi1za' Or [**Parent]='szrpu1za' Or [**Parent]='slu2f1za' Or [**Parent]='pf00z1zj' Or [**Parent]='pf00t1zj' Or [**Parent]='pf00g1zj' Or [**Parent]='wikjp1za' Or [**Parent]='pf00u1zj' Or [**Parent]='pf0141zj' Or [**Parent]='pf01k1zj' Or [**Parent]='57p9l1za' Or [**Parent]='pqgtr1za' Or [**Parent]='4ir3g1za' Or [**Parent]='jh1zh1za' Or [**Parent]='t761m1za' Or [**Parent]='drduo1za' Or [**Parent]='pf00l1zj' Or [**Parent]='gmpnq1za' Or [**Parent]='pf00h1zj' Or [**Parent]='pf00w1zj' Or [**Parent]='0jh681za' Or [**Parent]='pf00e1zj' Or [**Parent]='c3w371za' Or [**Parent]='kv9pv1za' Or [**Parent]='9rv7p1za' Or [**Parent]='1gf3r1za' Or [**Parent]='fbbuq1za' Or [**Parent]='pf01o1zj' Or [**Parent]='1ns8f1za' Or [**Parent]='c8rz51za' Or [**Parent]='vlifr1za' Or [**Parent]='pf00s1zj' Or [**Parent]='thj2f1za' Or [**Parent]='jdc9d1za' Or [**Parent]='trq5f1za' Or [**Parent]='rr9r51za' Or [**Parent]='lm0061za' Or [**Parent]='ru3zt1za' Or [**Parent]='pf01a1zj' Or [**Parent]='n79i91za' Or [**Parent]='pf0151zj' Or [**Parent]='pf0181zj' Or [**Parent]='pf00n1zj' Or [**Parent]='msi4s1za' Or [**Parent]='pf01j1zj' Or [**Parent]='scmfm1za' Or [**Parent]='sh9or1za' Or [**Parent]='wmi1l1za' Or [**Parent]='fwtwu1za' Or [**Parent]='pf0171zj' Or [**Parent]='pf00o1zj' Or [**Parent]='pf0131zj' Or [**Parent]='fhgu71za' Or [**Parent]='pf01c1zj' Or [**Parent]='6wzmj1za' Or [**Parent]='dn89j1za' Or [**Parent]='802i41za' Or [**Parent]='omgs41za' Or [**Parent]='7ivvt1za' Or [**Parent]='nnm091za' Or [**Parent]='pf0161zj' Or [**Parent]='pf01e1zj' Or [**Parent]='kdk5l1za' Or [**Parent]='9b59o1za' Or [**Parent]='pf00i1zj' Or [**Parent]='pf0061zj' Or [**Parent]='gmz1h1za' Or [**Parent]='pc0021zz' Or [**Parent]='h0022100' Or [**Parent]='s0034981' Or [**Parent]='s0066977' Or [**Parent]='s0065977' Or [**Parent]='s0064977' Or [**Parent]='wn8on1hb' Or [**Parent]='009011z1'


_filterSql:
Select Taxa.* From [Taxa] Where [**Parent]='ta0051zz' Or [**Parent]='ta0061zz' Or [**Parent]='ta0071zz' Or [**Parent]='ta0081zz' Or [**Parent]='ta0091zz' Or [**Parent]='ta0101zz' Or [**Parent]='ta0111zz' Or [**Parent]='ta0121zz' Or [**Parent]='ta0131zz' Or [**Parent]='ta0141zz' Or [**Parent]='ta0151zz' Or [**Parent]='ta0161zz' Or [**Parent]='ta0171zz' Or [**Parent]='ta0181zz' Or [**Parent]='ta0191zz' Or [**Parent]='ta0201zz' Or [**Parent]='ta0211zz' Or [**Parent]='ta0221zz' Or [**Parent]='ta0231zz' Or [**Parent]='ta0241zz' Or [**Parent]='ta0261zz'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = 40313


_filterName:
Vascular Plants (microspecies) and Charophytes

_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='pf0091zj' Or [**Parent]='n1jrl1za' Or [**Parent]='2lkkr1za' Or [**Parent]='pf01g1zj' Or [**Parent]='di7791za' Or [**Parent]='oscrw1za' Or [**Parent]='pf01p1zj' Or [**Parent]='l5flf1za' Or [**Parent]='i0j181za' Or [**Parent]='lvh3c1za' Or [**Parent]='b6vww1za' Or [**Parent]='c8i8f1za' Or [**Parent]='64n5w1za' Or [**Parent]='ltv001za' Or [**Parent]='bjiql1za' Or [**Parent]='bsbmz1za' Or [**Parent]='i5hn21za' Or [**Parent]='c3vkc1za' Or [**Parent]='tnznd1za' Or [**Parent]='bf4bs1za' Or [**Parent]='9m1ww1za' Or [**Parent]='hbvl71za' Or [**Parent]='m012l1za' Or [**Parent]='pf0081zj' Or [**Parent]='pf00j1zj' Or [**Parent]='7cgwt1za' Or [**Parent]='n0d2p1za' Or [**Parent]='pf0191zj' Or [**Parent]='mbctz1za' Or [**Parent]='pf01i1zj' Or [**Parent]='sl37c1za' Or [**Parent]='sjjut1za' Or [**Parent]='wn8on1za' Or [**Parent]='pf00b1zj' Or [**Parent]='fpgff1za' Or [**Parent]='7qd131za' Or [**Parent]='of1s11za' Or [**Parent]='pcow01za' Or [**Parent]='4gcu91za' Or [**Parent]='z15q51za' Or [**Parent]='v4q9r1za' Or [**Parent]='pf00k1zj' Or [**Parent]='pf00d1zj' Or [**Parent]='fdgrr1za' Or [**Parent]='3fczu1za' Or [**Parent]='86kk41za' Or [**Parent]='pf01n1zj' Or [**Parent]='7zhbq1za' Or [**Parent]='7jhs01za' Or [**Parent]='ngr8w1za' Or [**Parent]='pf00y1zj' Or [**Parent]='pf01h1zj' Or [**Parent]='p2t8m1za' Or [**Parent]='kdu5g1za' Or [**Parent]='pf00f1zj' Or [**Parent]='pf00q1zj' Or [**Parent]='313j51za' Or [**Parent]='bw89k1za' Or [**Parent]='4kdv21za' Or [**Parent]='h9fd51za' Or [**Parent]='ictgk1za' Or [**Parent]='pf00r1zj' Or [**Parent]='fdwr71za' Or [**Parent]='pf01l1zj' Or [**Parent]='6vm7z1za' Or [**Parent]='3055f1za' Or [**Parent]='80s2v1za' Or [**Parent]='pf00c1zj' Or [**Parent]='o4dq81za' Or [**Parent]='nsisw1za' Or [**Parent]='m86dk1za' Or [**Parent]='pf0071zj' Or [**Parent]='pf00v1zj' Or [**Parent]='srnc01za' Or [**Parent]='w6iuk1za' Or [**Parent]='fls5u1za' Or [**Parent]='pf00m1zj' Or [**Parent]='1qi7u1za' Or [**Parent]='uwkji1za' Or [**Parent]='tv36c1za' Or [**Parent]='pf01m1zj' Or [**Parent]='hhc3c1za' Or [**Parent]='rcjq71za' Or [**Parent]='8qvi41za' Or [**Parent]='pf00p1zj' Or [**Parent]='oundo1za' Or [**Parent]='pf01f1zj' Or [**Parent]='0g5tj1za' Or [**Parent]='2qod01za' Or [**Parent]='mh4s21za' Or [**Parent]='pf0121zj' Or [**Parent]='pf0111zj' Or [**Parent]='9vn9z1za' Or [**Parent]='gt2sh1za' Or [**Parent]='pf00x1zj' Or [**Parent]='5pgf21za' Or [**Parent]='pf01d1zj' Or [**Parent]='49dt21za' Or [**Parent]='if10l1za' Or [**Parent]='uvwio1za' Or [**Parent]='qugvn1za' Or [**Parent]='6qffn1za' Or [**Parent]='pf00a1zj' Or [**Parent]='diqlv1za' Or [**Parent]='89dfs1za' Or [**Parent]='jqd5r1za' Or [**Parent]='pf01b1zj' Or [**Parent]='0qo491za' Or [**Parent]='mnmfi1za' Or [**Parent]='szrpu1za' Or [**Parent]='slu2f1za' Or [**Parent]='pf00z1zj' Or [**Parent]='pf00t1zj' Or [**Parent]='pf00g1zj' Or [**Parent]='wikjp1za' Or [**Parent]='pf00u1zj' Or [**Parent]='pf0141zj' Or [**Parent]='pf01k1zj' Or [**Parent]='57p9l1za' Or [**Parent]='pqgtr1za' Or [**Parent]='4ir3g1za' Or [**Parent]='jh1zh1za' Or [**Parent]='t761m1za' Or [**Parent]='drduo1za' Or [**Parent]='pf00l1zj' Or [**Parent]='gmpnq1za' Or [**Parent]='pf00h1zj' Or [**Parent]='pf00w1zj' Or [**Parent]='0jh681za' Or [**Parent]='pf00e1zj' Or [**Parent]='c3w371za' Or [**Parent]='kv9pv1za' Or [**Parent]='9rv7p1za' Or [**Parent]='1gf3r1za' Or [**Parent]='fbbuq1za' Or [**Parent]='pf01o1zj' Or [**Parent]='1ns8f1za' Or [**Parent]='c8rz51za' Or [**Parent]='vlifr1za' Or [**Parent]='pf00s1zj' Or [**Parent]='thj2f1za' Or [**Parent]='jdc9d1za' Or [**Parent]='trq5f1za' Or [**Parent]='rr9r51za' Or [**Parent]='lm0061za' Or [**Parent]='ru3zt1za' Or [**Parent]='pf01a1zj' Or [**Parent]='n79i91za' Or [**Parent]='pf0151zj' Or [**Parent]='pf0181zj' Or [**Parent]='pf00n1zj' Or [**Parent]='msi4s1za' Or [**Parent]='pf01j1zj' Or [**Parent]='scmfm1za' Or [**Parent]='sh9or1za' Or [**Parent]='wmi1l1za' Or [**Parent]='fwtwu1za' Or [**Parent]='pf0171zj' Or [**Parent]='pf00o1zj' Or [**Parent]='pf0131zj' Or [**Parent]='fhgu71za' Or [**Parent]='pf01c1zj' Or [**Parent]='6wzmj1za' Or [**Parent]='dn89j1za' Or [**Parent]='802i41za' Or [**Parent]='omgs41za' Or [**Parent]='7ivvt1za' Or [**Parent]='nnm091za' Or [**Parent]='pf0161zj' Or [**Parent]='pf01e1zj' Or [**Parent]='kdk5l1za' Or [**Parent]='9b59o1za' Or [**Parent]='pf00i1zj' Or [**Parent]='pf0061zj' Or [**Parent]='gmz1h1za' Or [**Parent]='vm0011zj' Or [**Parent]='vm0021zj' Or [**Parent]='vm0031zj' Or [**Parent]='pc0021zz' Or [**Parent]='h0022100' Or [**Parent]='s0034981' Or [**Parent]='s0066977' Or [**Parent]='s0065977' Or [**Parent]='s0064977' Or [**Parent]='wn8on1hb' Or [**Parent]='009011z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='2lkkr1za' Or [**Parent]='l5flf1za' Or [**Parent]='n1jrl1za' Or [**Parent]='i0j181za' Or [**Parent]='c3vkc1za' Or [**Parent]='tnznd1za' Or [**Parent]='lvh3c1za' Or [**Parent]='9m1ww1za' Or [**Parent]='bsbmz1za' Or [**Parent]='bf4bs1za' Or [**Parent]='pf0061zj' Or [**Parent]='ltv001za' Or [**Parent]='hbvl71za' Or [**Parent]='b6vww1za' Or [**Parent]='m012l1za' Or [**Parent]='bjiql1za' Or [**Parent]='pf0071zj' Or [**Parent]='64n5w1za' Or [**Parent]='i5hn21za' Or [**Parent]='c8i8f1za'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2010


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='201000zz'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='215270zz' Or [**Parent]='215280zz' Or [**Parent]='215290zz'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE ([**Parent]='3zmjc1z1' Or [**Parent]='zxz251' Or [**Parent]='zxz081' Or [**Parent]='zxz161' Or [**Parent]='zxz281' Or [**Parent]='zxz351' Or [**Parent]='zxz151' Or [**Parent]='az013zzz' Or [**Parent]='zxz191' Or [**Parent]='az025zzz' Or [**Parent]='zxz521' Or [**Parent]='zxz391' Or [**Parent]='zxz511' Or [**Parent]='3hm761z1' Or [**Parent]='7qqlh1z1' Or [**Parent]='zxz131' Or [**Parent]='zxz541' Or [**Parent]='az030zzz' Or [**Parent]='az023zzz' Or [**Parent]='zxz121' Or [**Parent]='az014zzz' Or [**Parent]='zxz241' Or [**Parent]='az024zzz' Or [**Parent]='zxz141' Or [**Parent]='az015zzz' Or [**Parent]='az028zzz' Or [**Parent]='zxz031' Or [**Parent]='07knb1z1' Or [**Parent]='zxz341' Or [**Parent]='az016zzz' Or [**Parent]='az020zzz' Or [**Parent]='az022zzz' Or [**Parent]='az018zzz' Or [**Parent]='zxz091' Or [**Parent]='l951m1z1' Or [**Parent]='zxz101' Or [**Parent]='8w69n1z1' Or [**Parent]='zxz611' Or [**Parent]='zxz051' Or [**Parent]='az021zzz' Or [**Parent]='zxz261' Or [**Parent]='zxz581' Or [**Parent]='az029zzz' Or [**Parent]='zxz451' Or [**Parent]='zxz561' Or [**Parent]='zxz401' Or [**Parent]='az027zzz' Or [**Parent]='zxz071' Or [**Parent]='zxz591' Or [**Parent]='zxz531' Or [**Parent]='zxz621' Or [**Parent]='20190050' Or [**Parent]='zxz461' Or [**Parent]='zxz211' Or [**Parent]='zxz551' Or [**Parent]='lepf1zzz' Or [**Parent]='zxz411' Or [**Parent]='az017zzz' Or [**Parent]='20190051' Or [**Parent]='zxz041' Or [**Parent]='zxz201' Or [**Parent]='zxz061' Or [**Parent]='zxz421' Or [**Parent]='zxz471' Or [**Parent]='zxz111' Or [**Parent]='zxz311' Or [**Parent]='az019zzz' Or [**Parent]='zxz291' Or [**Parent]='zxz301' Or [_guk]='3zmjc1z1') And [*TaxonType]='l7df61z1' And [_guk]=[**RefersTo]


_filterSql:
Select * From Taxa Where [**Parent]='opo231z0' Or [**Parent]='opo241z0' Or [**Parent]='opo251z0' Or [**Parent]='opo261z0' Or [**Parent]='opo271z0' Or [**Parent]='opo321z0' Or [**Parent]='psp301z0' Or [**Parent]='psp291z0' Or [**Parent]='psp281z0' Or [**Parent]='psp271z0' Or [**Parent]='psp301z0' Or [**Parent]='psp311z0' Or [**Parent]='psp411z0' Or [**Parent]='spr011z0' Or [**Parent]='spr021z0' Or [**Parent]='spr031z0' Or [**Parent]='spr041z0' Or [**Parent]='spr051z0' Or [**Parent]='spr061z0' Or [**Parent]='spr071z0' Or [**Parent]='spr081z0' Or [**Parent]='spr091z0' Or [**Parent]='spr101z0' Or [**Parent]='spr111z0' Or [**Parent]='spr121z0' Or [**Parent]='spr131z0' Or [**Parent]='spr141z0' Or [**Parent]='spr151z0' Or [**Parent]='spr171z0' Or [**Parent]='spr181z0' Or [**Parent]='spr191z0' Or [**Parent]='spr201z0' Or [**Parent]='spr211z0' Or [**Parent]='spr221z0' Or [**Parent]='spr231z0' Or [**Parent]='spr241z0' Or [**Parent]='spr251z0' Or [**Parent]='spr261z0' Or [**Parent]='spr271z0' Or [**Parent]='spr281z0' Or [**Parent]='spr291z0' Or [**Parent]='spr301z0' Or [**Parent]='spr311z0' Or [**Parent]='spr321z0' Or [**Parent]='sp8011zj' Or [**Parent]='sp8001zj' Or [**Parent]='s2020001' Or [**Parent]='s8000zzz' Or [**Parent]='s8001zzz' Or [**Parent]='s8002zzz' Or [**Parent]='s1803024'  Or [**Parent]='1020t1z1'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='1u2qt1z1' Or [**Parent]='21gh51z1' Or [**Parent]='2ost71z1' Or [**Parent]='372631z1' Or [**Parent]='73tu31z1' Or [**Parent]='7u5wq1z1' Or [**Parent]='f4l9m1z1' Or [**Parent]='gwsi01z1' Or [**Parent]='ksns21z1' Or [**Parent]='pt0mu1z1' Or [**Parent]='fnihf1z1' Or [**Parent]='isp791z1' Or [**Parent]='4bmvz1z1' Or [**Parent]='ct7zu1z1' Or [**Parent]='j918u1z1' Or [**Parent]='k00251zj' Or [**Parent]='k00261zj' Or [**Parent]='k00271zj' Or [**Parent]='k00281zj' Or [**Parent]='k00291zj' Or [**Parent]='s9206065' Or [**Parent]='s9206070'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2012


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2011


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='s9600009'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2013


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='hf0021zz' Or [**Parent]='hf0031zz' Or [**Parent]='hf0041zz' Or [**Parent]='hf0051zz' Or [**Parent]='hf0061zz' Or [**Parent]='hf0071zz' Or [**Parent]='hf0081zz' Or [**Parent]='hf0091zz' Or [**Parent]='hf0101zz' Or [**Parent]='hf0111zz' Or [**Parent]='hf0121zz' Or [**Parent]='hf0131zz' Or [**Parent]='hf0141zz' Or [**Parent]='hf0151zz'


_filterName:
Terrestrial Heteroptera: Plant bugs & allies

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='hf0011zz' Or [**Parent]='hf0171zz' Or [**Parent]='hf0181zz' Or [**Parent]='hf0191zz' Or [**Parent]='hf0201zz' Or [**Parent]='hf0211zz' Or [**Parent]='hf0221zz' Or [**Parent]='hf0231zz' Or [**Parent]='hf0241zz' Or [**Parent]='hf0251zz' Or [**Parent]='hf0261zz' Or [**Parent]='hf0271zz'


_filterName:
Terrestrial Heteroptera: Shieldbugs & allies

_filterSql:
Select Taxa.* From Taxa Where [**Parent]='Parent' Or [**parent]='hf0281zz' Or [**parent]='hf0291zz' Or [**parent]='hf0301zz' Or [**parent]='hf0311zz' Or [**parent]='hf0321zz' Or [**parent]='hf0331zz' Or [**parent]='hf0341zz' Or [**parent]='hf0351zz' Or [**parent]='hf0361zz' Or [**parent]='hf0371zz'


_filterSql:
Select Taxa.* From [Taxa] Where [**Parent]='v3013001' Or [**Parent]='v3013002' Or [**Parent]='v3013003'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent]='5968003a' Or [**Parent]='5968004a'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='59690004'


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='zzz441z0'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2014


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2015


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2016


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date = BETWEEN 42257 AND 42259


_filterSql:
SELECT Sites.* FROM Sites WHERE [Sites].[**Parent] = 'u00121z1' OR [Sites].[**Parent] = 'u00131z1' OR [Sites].[**Parent] = 'u00141z1' OR [Sites].[**Parent] = 'u00151z1' OR [Sites].[**Parent] = 'wgc631zj'


_filterSql:
SELECT Sites.* FROM Sites WHERE [Sites].[**Parent] = 'u00121z1' OR [Sites].[**Parent] = 'u00131z1' OR [Sites].[**Parent] = 'u00141z1' OR [Sites].[**Parent] = 'u00151z1' OR [Sites].[**Parent] = 'wgc631zj' OR [Sites].ViceCounty = 24


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN 42530 AND 42532


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent] = 'df0711zj'


_filterSql:
SELECT Taxa.* FROM Taxa WHERE [**Parent] = 'a03791zj' Or [**Parent] = 'a03801zj' Or [**Parent] = 'a03811zj' Or [**Parent] = 'a03821zj' Or [**Parent] = 'a03831zj' Or [**Parent] = 'a03841zj' Or [**Parent] = 'a03851zj' Or [**Parent] = 'a03871zj' Or [**Parent] = 's9600001'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2017


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN 43020 AND 43022


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2018


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN 43265 AND 43267


_filterSql:
Select Taxa.* From Taxa Where [*Reference]='p3001zzz'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN Clng(DateSerial(2020, 8, 27)) AND Clng(DateSerial(2020, 8, 29))


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN Clng(DateSerial(2017, 1, 1)) AND Clng(DateSerial(2019, 12, 31))


_filterSql:
Select Taxa.* From Taxa Where [**Parent]='df1101zj'


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Right(Records.[_guk],3)='1an'


_filterSql:
Select Sites.* From Sites Where [ViceCounty]=85 Or [ViceCounty]=87


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Records.Date BETWEEN Clng(DateSerial(2021, 7, 8)) AND Clng(DateSerial(2021, 7, 10))


_filterSql:
Select Taxa.* From Taxa Where ([*Reference]='bryx2021' Or [*Reference]='bryo2009') And [*TaxonType]<>'wcj591z1' And ([Code] Like 'L*' Or [Code] Like 'M*' Or [Code] Like 'H*')


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2019


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2020


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2021


_filterSql:
SELECT Records.* FROM (Records INNER JOIN [Taxa\Filter] ON Records.[*Taxon] = [Taxa\Filter].[_guk]) INNER JOIN [Sites\Filter] ON Records.[*Site] = [Sites\Filter].[_guk] WHERE Year(Records.Date)=2022


# RecordStatus

Status:
2.5 Low vegetation (<20cm): varied mosaic


Status:
4.5 Shrub/low canopy to 5m: varied mosaic


Description:
Number of young fledged per pair.  Use only for annual breeding totals.

UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Birds RSPB,Barn Owl Scheme,Great Bustard Group


Description:
Birds flying over and not using the site.


UsedBy:
Birds,Birds BOU A-C,Barn Owl Scheme,Great Bustard Group


UsedBy:
Mammals,Birds,Birds BOU A-C,Birds RSPB Red and Amber


UsedBy:
Birds,Vertebrata: Birds Gulls,Vertebrata: Birds Waders,Vertebrata: Birds Wildfowl,Vertebrata: Birds Raptors,Great Bustard Group,Birds BOU A-C,Birds RSPB Red and Amber,Birds RSPB


Description:
observed in suitable nesting Habitats (possible breeder)


Description:
Pair in suitable nesting habitat (probable breeder)


Description:
courtship and Display (probable breeder)


Description:
visiting probable Nest site (probable breeder)


Description:
adults carrying Faecal sac or Food for young (confirmed breeder)


Description:
Nest containing Eggs (confirmed breeder)


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Lepidoptera,Insecta,Vertebrata,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Vascular Plants,Vascular Plants (plus microspecies)


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Barn Owl Scheme,Great Bustard Group


Description:
Native (N) - Botanical Status Classification

UsedBy:
Vascular Plants,Vascular Plants (plus microspecies),Vascular Plants and Charophytes,Vascular Plants (microspecies) and Charophytes,Hymenoptera


Description:
Established (E) - Botanical Status Classification

UsedBy:
Vascular Plants,Vascular Plants (plus microspecies),Vascular Plants and Charophytes,Vascular Plants (microspecies) and Charophytes


Description:
Surviving (S) - Botanical Status Classification


Description:
Casual (C) - Botanical Status Classification


Description:
Planted (P) - Botanical Status Classification


Description:
Alien (A) - Botanical Status Classification


Description:
Occurance due to means other than self dispersal (see also Vagrant)

UsedBy:
Lepidoptera,Insecta,Uniramia,Isopoda,Vertebrata,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme


UsedBy:
Lepidoptera,Insecta,Uniramia,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme


UsedBy:
Birds,Lepidoptera,Insecta,Uniramia,Isopoda,Vertebrata,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Lepidoptera,Insecta,Uniramia,Isopoda,Vertebrata,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Barn Owl Scheme,Great Bustard Group


Description:
Recorded as a vagrant or accidental occurance (non-breeding)

UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Lepidoptera,Insecta,Uniramia,Isopoda,Vertebrata,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme


UsedBy:
Birds,Vertebrata: Birds Gulls,Vertebrata: Birds Waders,Vertebrata: Birds Wildfowl,Vertebrata: Birds Raptors,Great Bustard Group


Description:
brood patch of Incubating bird (probable breeder)


Description:
nest Building or excavating (probable breeder)


Description:
Used Nest or eggshells found from this season (confirmed breeder)


Description:
recently Fledged young or downy young (confirmed breeder)


Description:
adults entering or leaving an Occupied Nest (confirmed breeder)


Description:
Nest with Young seen or heard (confirmed breeder)


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber


# SRSHabitats

Item:
Gorse (*record as sub-habitat if part of main habitat) [07]


Item:
Wetland, edges of lakes, ponds, rivers and streams [29]


Item:
Post-industrial, mineral extraction sites/spoil heaps [33]


Item:
Scrub (*record as sub-habitat if part of main habitat) [17]


Item:
Wasteground (*record as 33 or 34 if possible) [22]


# TaxonSex

Description:
Gynandrous, mixed sex or sexual mosaic example(s)


# TaxonStage

Description:
A newly emerged adult, without the full coloration of the mature adult
adult.


UsedBy:
Vertebrata,Birds,Birds BOU A-C,Birds RSPB Red and Amber,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Lepidoptera,Insecta,Uniramia,Vertebrata,Hymenoptera,Isopoda,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Spider Recording Scheme,Dragonfly Recording Network,British Plant Gall Society


UsedBy:
Birds,Lepidoptera,Insecta,Amphibians,Marine Fish,Reptiles,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Spider Recording Scheme,Barn Owl Scheme,Great Bustard Group


UsedBy:
Lepidoptera,Insecta,Hymenoptera,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Dragonfly Recording Network,British Plant Gall Society


UsedBy:
Lepidoptera,Insecta,Hymenoptera,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,British Plant Gall Society


UsedBy:
Amphibians,Vertebrata: Amphibians and Reptiles,Amphibians and Reptiles


UsedBy:
Ephemeroptera,Orthoptera,Insecta,Insecta: Hemiptera: Heteroptera,Insecta: Hemiptera: Auchenorrhyncha


UsedBy:
Vascular Plants,Vascular Plants (plus microspecies),Vascular Plants and Charophytes,Vascular Plants (microspecies) and Charophytes


UsedBy:
Vertebrata,Barn Owl Scheme,Great Bustard Group


UsedBy:
Hymenoptera,Birds,Birds BOU A-C,Birds RSPB Red and Amber,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Bats,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Arachnida,Isopoda,Uniramia,Spider Recording Scheme,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Arachnida,Spider Recording Scheme,Barn Owl Scheme,Great Bustard Group


UsedBy:
Arachnida,Spider Recording Scheme,Odonata,Insecta,Dragonfly Recording Network


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Lepidoptera,Insecta,Vertebrata,Hymenoptera,Mollusca,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Spider Recording Scheme,British Plant Gall Society


UsedBy:
Birds,Birds BOU A-C,Birds RSPB Red and Amber,Lepidoptera,Insecta,Vertebrata,Hymenoptera,Arachnida,National Leaf Miner Scheme,National Gelechiid Plus Scheme,National Pyralid and Plume Scheme,Crustacea,Spider Recording Scheme


UsedBy:
Vascular Plants,Vascular Plants (plus microspecies),Vascular Plants and Charophytes,Vascular Plants (microspecies) and Charophytes,Bryophytes


Description:
Use when taxonomic variety not available


Description:
The stage immediately after hatching when the larva is still enclosed in a membrane


UsedBy:
Birds,Barn Owl Scheme,Great Bustard Group


UsedBy:
Birds,Vertebrata: Birds Gulls,Vertebrata: Birds Waders,Vertebrata: Birds Wildfowl,Vertebrata: Birds Raptors,Barn Owl Scheme,Great Bustard Group


# TaxonStatus

Description:
Previously considered RDB1 to 3 but now out of danger


Description:
Not falling in RDB1 or 2 but is very restricted in numbers or distribution - known from 15 or less 10km squares


Description:
A vulnerable species likely to move into RDB1 if current adverse factors continue


Description:
A species in danger of extinction or believed to be extinct already - known from less than 5, 10km squares


Description:
Provisionally RDB Appendix - considered possibly extinct


Description:
Alien taxon now naturalised using an alien host


Description:
Taxon is known to be a vagrant or accidental release / importation


Description:
Taxon is presumed (but not confirmed as) extinct


Description:
Taxon considered endangered but does not have an RDB category


Description:
There is no evidence this taxon is native


Description:
Re-introduced (non-native form) of an extinct taxon


Description:
Now extinct, was associated with, or dependant on, man


Description:
Wild or released, previously domestic, taxon


Description:
Designated as a Biodiversity Action Plan (BAP) species (may also be RDB or Notable)


Description:
Extinct and Endemic (was restricted to a particular geographic region)


Description:
Original record is unconfirmed - status unknown.


Description:
Status is Local, taxon requires an alien foodplant


Description:
Status is Common, taxon requires an alien foodplant


Description:
Taxon has no documented RDB or Notable Status


Description:
Considered either Na or Nb but uncertain which


Description:
Notable and Endemic (restricted to a particular geographic region)


Description:
RDBI and Endemic (restricted to a particular geographic region)


Description:
RDB1 and Endemic (restricted to a particular geographic region)


Description:
RDB2 and Endemic (restricted to a particular geographic region)


Description:
RDBK and Endemic (restricted to a particular geographic region)


Description:
RDB3 and Endemic (restricted to a particular geographic region)


Description:
Na and Endemic (restricted to a particular geographic region)


Description:
Possible RDB species but not sufficiently known


Description:
BOU Category A: Species which have been recorded in an apparently natural state at least once since 1 January 1950.


Description:
BOU Category B: Species which were recorded in an apparently natural state at least once up to 31 December 1949, but have not been recorded subsequently.


Description:
BOU Category C: Species that, although originally introduced by man, either deliberately or accidentally, have established breeding populations derived from introduced stock, that maintain themselves without necessary recourse to further introduction.


Description:
BOU Category C1: Naturalised introductions.  Species that have occurred only as a result of introduction.


Description:
BOU Category C2: Naturalised establishments.  Species with established populations as a result of introduction by Man, but which also occur in an apparently natural state.


Description:
BOU Category C3: Naturalised re-establishments.  Species with populations successfully re-established by Man in areas of former occurrence.


Description:
BOU Category C4: Naturalised feral species.  Domesticated species with populations established in the wild.


Description:
BOU Category C5: Vagrant naturalised species.  Species from established naturalised populations abroad.


Description:
BOU Category D: Species that would otherwise appear in Categories A or B except that there is reasonable doubt that they have ever occurred in a natural state.


Description:
BOU Category E: Species that have been recorded as introductions, transportees or escapees from captivity, and whose breeding populations (if any) are thought not to be self sustaining.


Description:
Status is unknown or uncertain (Use 'None' is there is No known status)


Description:
Taxon is know to be migratory (may also be a temporary resident)


Description:
Regionally notable species (Avoid using this status if possible)


Description:
Nationally notable species - known from less than 100, 10km squares


Description:
Nationally notable species - known from 30 or less 10km squares


Description:
Endemic (restricted to a particular geographic region)


Description:
Taxon is an adventive - see also Vagrant/Accidental


Description:
Found only in Ireland (status uncertain)


