Query 2: select submission_id from submission_files where submission_file_id=788 and file_stage=10
select current_publication_id from submissions where submission_id=301 SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='' and country_id='A1' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='' and country_id='AU' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='Beijing' and country_id='CN' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='Southend' and country_id='GB' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='' and country_id='IN' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='' and country_id='KE' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='' and country_id='ZA' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city='Waverly' and country_id='ZA' order by country_id SELECT SUM(metric) as downloads FROM metrics where submission_id=301 and assoc_id=788 and city is NULL and country_id='ZZ' order by country_id
Cooperative breeding in the African Paradise Flycatcher
Unknown City Unkown Country 1
Unknown City Australia 1
Beijing China 1
Southend United Kingdom 25
Unknown City India 2
Unknown City Kenya 1
Unknown City South Africa 2
Waverly South Africa 1
Unknown City Unkown Country 3
    37