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 '%Canada% Newfoundland%'
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 '%Canada% Newfoundland%' order by spcode, comname, rating DESC LIMIT 100
323 Images found.
|
Greater Shearwater Puffinus gravis |
f20/9/328 Greater Shearwater | f20/9/329 Greater Shearwater | f20/9/330 Greater Shearwater |
Sooty Shearwater Puffinus griseus |
f20/9/598 Sooty Shearwater | f20/9/599 Sooty Shearwater | f20/9/600 Sooty Shearwater | f20/9/601 Sooty Shearwater |
|
Great Cormorant Phalacrocorax carbo |
b57/16/218 Great Cormorant |
Northern Gannet Morus bassanus |
f20/9/452 Northern Gannet | b57/16/265 Northern Gannet | b57/18/034 Northern Gannet | b57/18/035 Northern Gannet |
b57/18/036 Northern Gannet | r05/1/015 Northern Gannet | l27/1/015 Northern Gannet | f20/9/448 Northern Gannet |
f20/9/449 Northern Gannet | f20/9/450 Northern Gannet | f20/9/451 Northern Gannet | f20/9/453 Northern Gannet |
v11/9/017 Northern Gannet | b57/16/262 Northern Gannet | b57/16/263 Northern Gannet | b57/16/264 Northern Gannet |
b57/16/266 Northern Gannet | b57/16/267 Northern Gannet | b57/16/268 Northern Gannet | b57/16/269 Northern Gannet |
b57/16/270 Northern Gannet | b57/16/271 Northern Gannet | b57/16/272 Northern Gannet | b57/16/273 Northern Gannet |
b57/16/274 Northern Gannet | b57/16/275 Northern Gannet | b57/16/276 Northern Gannet | b57/16/277 Northern Gannet |
b57/16/278 Northern Gannet | b57/16/279 Northern Gannet | b57/16/280 Northern Gannet | v11/9/018 Northern Gannet |
v11/9/019 Northern Gannet | v11/9/020 Northern Gannet | v11/9/021 Northern Gannet | v11/9/022 Northern Gannet |
v11/9/023 Northern Gannet | v11/9/024 Northern Gannet | v11/9/025 Northern Gannet |
Wood Duck Aix sponsa |
j08/1/921 Wood Duck | j08/1/922 Wood Duck |
Hybrid Duck Black x Mallard A. platyrhynchos x A. rubripes |
j08/1/008 Hybrid Duck Black x Mallard | j08/1/009 Hybrid Duck Black x Mallard |
American Black Duck Anas rubripes |
f20/9/008 American Black Duck | j08/1/001 American Black Duck | j08/1/002 American Black Duck | j08/1/003 American Black Duck |
j08/1/004 American Black Duck | j08/1/005 American Black Duck | j08/1/006 American Black Duck | j08/1/007 American Black Duck |
f20/9/007 American Black Duck | b57/18/001 American Black Duck | b57/18/002 American Black Duck | b57/16/001 American Black Duck |
b57/16/002 American Black Duck | b57/16/003 American Black Duck | b57/16/004 American Black Duck | b57/16/005 American Black Duck |
b57/16/006 American Black Duck | b57/16/007 American Black Duck | b57/16/008 American Black Duck |
Northern Pintail Anas acuta |
j08/1/594 Northern Pintail | j08/1/595 Northern Pintail |
Barrow's Goldeneye Bucephala islandica |
b57/16/079 Barrow's Goldeneye |
Rock Ptarmigan Lagopus muta |
b57/18/043 Rock Ptarmigan | b57/16/353 Rock Ptarmigan | b57/16/354 Rock Ptarmigan | b57/16/355 Rock Ptarmigan |
b57/16/356 Rock Ptarmigan | b57/16/357 Rock Ptarmigan | b57/16/358 Rock Ptarmigan | b57/16/359 Rock Ptarmigan |
b57/16/360 Rock Ptarmigan |
Razorbill Alca torda |
b57/16/336 Razorbill | b57/16/334 Razorbill | b57/16/335 Razorbill | b57/16/337 Razorbill |
b57/16/338 Razorbill |
Common Murre Uria aalge |
h21/99/099 Common Murre | h21/99/100 Common Murre | h21/99/102 Common Murre | b57/16/180 Common Murre |
b57/16/181 Common Murre | b57/16/182 Common Murre | b57/16/183 Common Murre | b57/16/184 Common Murre |
b57/16/185 Common Murre | b57/16/186 Common Murre | b57/16/187 Common Murre | f20/9/220 Common Murre |
f20/9/221 Common Murre |