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 '%Papua% New% Guinea%'
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 '%Papua% New% Guinea%' order by spcode, comname, rating DESC LIMIT 100
638 Images found.
|
Dwarf Cassowary Casuarius bennetti |
 g22/5/013 Dwarf Cassowary |  g22/5/016 Dwarf Cassowary |  g22/5/019 Dwarf Cassowary |  g22/5/020 Dwarf Cassowary |
 g22/5/014 Dwarf Cassowary |  g22/5/015 Dwarf Cassowary |  g22/5/017 Dwarf Cassowary |  g22/5/018 Dwarf Cassowary |
|
Human Homo sapiens |
 g22/5/001 Human |  g22/5/002 Human |  g22/5/003 Human |  g22/5/004 Human |
 g22/5/006 Human |  g22/5/007 Human |  g22/5/010 Human |  t08/15/347 Human |
 t08/15/348 Human |  t08/15/350 Human |  t08/15/351 Human |  t08/15/355 Human |
 g22/3/003 Human |  g22/3/004 Human |  g22/5/005 Human |  g22/3/005 Human |
 g22/3/006 Human |  g22/3/007 Human |  g22/5/008 Human |  g22/5/009 Human |
 d20/1/001 Human |
Yellow Bittern Ixobrychus sinensis |
 h27/1/013 Yellow Bittern |
Spotted Whistling-Duck Dendrocygna guttata |
 e09/5/072 Spotted Whistling-Duck |
Green Pygmy-Goose Nettapus pulchellus |
 b59/3/010 Green Pygmy-Goose |  d20/1/002 Green Pygmy-Goose |
Whistling Kite Haliastur sphenurus |
 r16/3/066 Whistling Kite |
White-bellied Sea-Eagle Haliaeetus leucogaster |
 b59/3/008 White-bellied Sea-Eagle |
Doria's Goshawk Megatriorchis doriae |
 e09/5/039 Doria's Goshawk |
Australian Goshawk Accipiter fasciatus |
 p06/7/006 Australian Goshawk |  p06/7/007 Australian Goshawk |  p06/7/008 Australian Goshawk |
Black-mantled Goshawk Accipiter melanochlamys |
 p06/4/032 Black-mantled Goshawk |
Gray-headed Goshawk Accipiter poliocephalus |
 d20/1/003 Gray-headed Goshawk |  p06/4/045 Gray-headed Goshawk |
New Guinea Eagle Harpyopsis novaeguineae |
 b59/3/012 New Guinea Eagle |
Eastern Marsh Harrier Circus spilonotus |
|
Nankeen Kestrel Falco cenchroides |
 p06/7/101 Nankeen Kestrel |  p06/7/102 Nankeen Kestrel |  p06/7/105 Nankeen Kestrel |
Brown Falcon Falco berigora |
 p06/7/018 Brown Falcon |  p06/7/020 Brown Falcon |  p06/7/035 Brown Falcon |  p06/7/037 Brown Falcon |
 p06/7/039 Brown Falcon |  p06/7/051 Brown Falcon |  p06/7/053 Brown Falcon |  p06/7/054 Brown Falcon |
 p06/7/060 Brown Falcon |  p06/7/061 Brown Falcon |  p06/7/070 Brown Falcon |  p06/7/074 Brown Falcon |
 p06/7/077 Brown Falcon |  p06/7/078 Brown Falcon |  p06/7/080 Brown Falcon |
Melanesian Scrubfowl Megapodius eremita |
 v12/2/034 Melanesian Scrubfowl |  v12/2/035 Melanesian Scrubfowl |  v12/2/036 Melanesian Scrubfowl |  v12/2/037 Melanesian Scrubfowl |
 v12/2/038 Melanesian Scrubfowl |  v12/2/039 Melanesian Scrubfowl |  v12/2/040 Melanesian Scrubfowl |  v12/2/041 Melanesian Scrubfowl |
 v12/2/042 Melanesian Scrubfowl |  v12/2/043 Melanesian Scrubfowl |
Brolga Grus rubicunda |
 b59/3/011 Brolga |
Bare-eyed Rail Eulabeornis plumbeiventris |
 p06/4/054 Bare-eyed Rail |
White-browed Crake Poliolimnas cinereus |
 h27/1/026 White-browed Crake |
Beach Thick-knee Esacus magnirostris |
 h27/11/003 Beach Thick-knee |
Pink-breasted Cuckoo-Dove Macropygia amboinensis |
 p06/5/001 Pink-breasted Cuckoo-Dove |
Emerald Ground-Dove Chalcophaps indica |
 p06/5/002 Emerald Ground-Dove |
Bar-shouldered Dove Geopelia humeralis |
 p06/7/107 Bar-shouldered Dove |  p06/7/109 Bar-shouldered Dove |  p06/7/111 Bar-shouldered Dove |  p06/7/114 Bar-shouldered Dove |
|
White-breasted Ground-Dove Gallicolumba jobiensis |
 d20/1/004 White-breasted Ground-Dove |
Western Crowned-Pigeon Goura cristata |
 s66/1/383 Western Crowned-Pigeon |  s66/1/384 Western Crowned-Pigeon |
Southern Crowned-Pigeon Goura scheepmakeri |
 b59/3/014 Southern Crowned-Pigeon |
Victoria Crowned-Pigeon Goura victoria |
 g22/3/025 Victoria Crowned-Pigeon |