missing releases

gistfile1.sql

set search_path to 'aatams', 'public';

select transmitter_id, scientific_name from animal_release
join project on project_id = project.id
join surgery on animal_release.id = surgery.release_id
join device tag on surgery.tag_id = tag.id
join sensor on tag.id = sensor.tag_id
join animal on animal_id = animal.id
join species on animal.species_id = species.id

where project.name = 'CSIRO: Animal Tagging'
and scientific_name in ('Cephaloscyllium laticeps', 'Mustelus antarcticus', 'Platycephalus richardsoni', 'Platycephalus speculator')
order by transmitter_id