select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%Tristan% da% Cunha%'
select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%Tristan% da% Cunha%' order by spcode, comname, rating DESC LIMIT 100
|
Yellow-nosed Albatross Thalassarche chlororhynchos |
l20/1/005 Yellow-nosed Albatross | l20/1/006 Yellow-nosed Albatross | l20/1/007 Yellow-nosed Albatross | l20/1/008 Yellow-nosed Albatross |
l20/1/012 Yellow-nosed Albatross | w31/1/008 Yellow-nosed Albatross | w31/1/009 Yellow-nosed Albatross | w31/1/010 Yellow-nosed Albatross |
v12/1/005 Yellow-nosed Albatross | v12/1/007 Yellow-nosed Albatross | l20/1/010 Yellow-nosed Albatross | l20/1/011 Yellow-nosed Albatross |
l20/1/013 Yellow-nosed Albatross | v12/1/006 Yellow-nosed Albatross | v12/1/008 Yellow-nosed Albatross | v12/1/009 Yellow-nosed Albatross |
v12/1/010 Yellow-nosed Albatross | l20/1/009 Yellow-nosed Albatross | l20/1/014 Yellow-nosed Albatross |
Gray-headed Albatross Thalassarche chrysostoma |
v12/1/011 Gray-headed Albatross | v12/1/012 Gray-headed Albatross |
Sooty Albatross Phoebetria fusca |
v12/1/013 Sooty Albatross |
Northern Giant-Petrel Macronectes halli |
l20/1/015 Northern Giant-Petrel | l20/1/016 Northern Giant-Petrel |
Atlantic Petrel Pterodroma incerta |
w31/1/007 Atlantic Petrel |
Spectacled Petrel Procellaria conspicillata |
w31/1/064 Spectacled Petrel | w31/1/065 Spectacled Petrel | w31/1/066 Spectacled Petrel | w31/1/067 Spectacled Petrel |
w31/1/068 Spectacled Petrel | w31/1/069 Spectacled Petrel | w31/1/070 Spectacled Petrel | v12/1/020 Spectacled Petrel |
|
Rockhopper Penguin Eudyptes chrysocome |
v12/1/044 Rockhopper Penguin | l20/1/020 Rockhopper Penguin | l20/1/022 Rockhopper Penguin | l20/1/023 Rockhopper Penguin |
l20/1/024 Rockhopper Penguin | v12/1/046 Rockhopper Penguin | v12/1/047 Rockhopper Penguin | l20/1/021 Rockhopper Penguin |
l20/1/025 Rockhopper Penguin | l20/1/026 Rockhopper Penguin | l20/1/027 Rockhopper Penguin | l20/1/028 Rockhopper Penguin |
|
Southern Skua Stercorarius antarctica |
w31/1/060 Southern Skua | w31/1/061 Southern Skua | w31/1/062 Southern Skua |
Brown Skua Stercorarius lonnbergi |
l20/1/034 Brown Skua | l20/1/033 Brown Skua |
Antarctic Tern Sterna vittata |
w31/1/001 Antarctic Tern | w31/1/002 Antarctic Tern | w31/1/003 Antarctic Tern | w31/1/004 Antarctic Tern |
w31/1/005 Antarctic Tern | w31/1/006 Antarctic Tern | l20/1/035 Antarctic Tern |
Tristan Finch Nesospiza acunhae |
l20/1/036 Tristan Finch | l20/1/037 Tristan Finch |
Big-billed Bunting Nesospiza wilkinsi |
l20/1/039 Big-billed Bunting | l20/1/038 Big-billed Bunting |
Tristan Thrush Nesocichla eremita |
w31/1/079 Tristan Thrush | w31/1/080 Tristan Thrush | w31/1/081 Tristan Thrush | w31/1/076 Tristan Thrush |
w31/1/077 Tristan Thrush | w31/1/078 Tristan Thrush | l20/1/048 Tristan Thrush | l20/1/049 Tristan Thrush |
l20/1/050 Tristan Thrush | l20/1/054 Tristan Thrush | l20/1/051 Tristan Thrush | l20/1/052 Tristan Thrush |
l20/1/053 Tristan Thrush |