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 '%Mexico% Nayarit%'
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 '%Mexico% Nayarit%' order by spcode, comname, rating DESC LIMIT 100
184 Images found.
|
Black-vented Shearwater Puffinus opisthomelas |
 a21/4/011 Black-vented Shearwater |  a21/4/012 Black-vented Shearwater |
Audubon's Shearwater Puffinus lherminieri |
 a21/4/004 Audubon's Shearwater |
Anhinga Anhinga anhinga |
 a21/4/002 Anhinga |  b13/46/001 Anhinga |
Magnificent Frigatebird Fregata magnificens |
 f20/14/086 Magnificent Frigatebird |  f20/14/087 Magnificent Frigatebird |  w13/15/001 Magnificent Frigatebird |  a01/1/023 Magnificent Frigatebird |
|
Brown Pelican Pelecanus occidentalis |
 w13/15/002 Brown Pelican |  f20/14/084 Brown Pelican |  b13/46/044 Brown Pelican |
Blue-footed Booby Sula nebouxii |
 f20/17/012 Blue-footed Booby |  f20/17/013 Blue-footed Booby |  f20/17/011 Blue-footed Booby |  f20/17/014 Blue-footed Booby |
 f20/14/072 Blue-footed Booby |  f20/14/076 Blue-footed Booby |  f20/14/083 Blue-footed Booby |
Brown Booby Sula leucogaster |
 f20/14/071 Brown Booby |  f20/14/073 Brown Booby |  f20/14/074 Brown Booby |  f20/14/075 Brown Booby |
 f20/14/077 Brown Booby |  f20/14/080 Brown Booby |  f20/14/081 Brown Booby |  f20/14/082 Brown Booby |
 j10/1/033 Brown Booby |  f20/14/002 Brown Booby |  a21/4/015 Brown Booby |
Bare-throated Tiger-Heron Tigrisoma mexicanum |
 f20/17/001 Bare-throated Tiger-Heron |  f20/17/002 Bare-throated Tiger-Heron |  a21/4/007 Bare-throated Tiger-Heron |  a21/4/008 Bare-throated Tiger-Heron |
 d27/1/001 Bare-throated Tiger-Heron |
Yellow-crowned Night-Heron Nyctanassa violacea |
 f20/17/192 Yellow-crowned Night-Heron |  f20/17/193 Yellow-crowned Night-Heron |  b13/46/176 Yellow-crowned Night-Heron |  f20/14/099 Yellow-crowned Night-Heron |
|
Boat-billed Heron Cochlearius cochlearius |
 f20/17/015 Boat-billed Heron |  f20/17/017 Boat-billed Heron |  f20/17/018 Boat-billed Heron |  f20/17/019 Boat-billed Heron |
 f20/17/020 Boat-billed Heron |  f20/17/021 Boat-billed Heron |  f20/17/022 Boat-billed Heron |  f20/17/016 Boat-billed Heron |
 f20/14/094 Boat-billed Heron |  g25/2/012 Boat-billed Heron |
Green Heron Butorides virescens |
 f20/17/077 Green Heron |  f20/17/078 Green Heron |  f20/17/079 Green Heron |  f20/17/080 Green Heron |
|
Little Blue Heron Egretta caerulea |
 f20/17/101 Little Blue Heron |
Tricolored Heron Egretta tricolor |
 f20/14/102 Tricolored Heron |
Great Egret Ardea alba |
 f20/17/075 Great Egret |  f20/14/092 Great Egret |
Great Blue Heron Ardea herodias |
 f20/14/079 Great Blue Heron |
Wood Stork Mycteria americana |
 f20/17/188 Wood Stork |  f20/17/189 Wood Stork |  f20/17/190 Wood Stork |  f20/17/191 Wood Stork |
 b13/46/173 Wood Stork |  b13/46/174 Wood Stork |  f20/14/089 Wood Stork |  f20/14/093 Wood Stork |
|
White Ibis Eudocimus albus |
 b13/46/162 White Ibis |  b13/46/163 White Ibis |  f20/14/101 White Ibis |
Roseate Spoonbill Platalea ajaja |
 f20/14/088 Roseate Spoonbill |  f20/14/090 Roseate Spoonbill |  f20/14/091 Roseate Spoonbill |
Black-bellied Whistling-Duck Dendrocygna autumnalis |
 f20/17/003 Black-bellied Whistling-Duck |  f20/14/097 Black-bellied Whistling-Duck |  b13/46/005 Black-bellied Whistling-Duck |  b13/46/006 Black-bellied Whistling-Duck |
 b13/46/007 Black-bellied Whistling-Duck |
Snail Kite Rostrhamus sociabilis |
 f20/17/147 Snail Kite |  f20/17/148 Snail Kite |  b13/46/150 Snail Kite |  b13/46/151 Snail Kite |
 b13/46/152 Snail Kite |  b13/46/153 Snail Kite |
Crane Hawk Geranospiza caerulescens |
 w13/15/021 Crane Hawk |
Common Black-Hawk Buteogallus anthracinus |
 f20/17/040 Common Black-Hawk |  w13/15/029 Common Black-Hawk |  w13/15/030 Common Black-Hawk |  b13/46/059 Common Black-Hawk |
 b13/46/060 Common Black-Hawk |  w13/17/075 Common Black-Hawk |  w13/17/076 Common Black-Hawk |  w13/17/077 Common Black-Hawk |
 w13/17/079 Common Black-Hawk |  w13/15/028 Common Black-Hawk |  w13/15/031 Common Black-Hawk |  w13/15/032 Common Black-Hawk |
 w13/15/033 Common Black-Hawk |  b13/46/061 Common Black-Hawk |
Great Black-Hawk Buteogallus urubitinga |
 w13/15/034 Great Black-Hawk |  w13/15/035 Great Black-Hawk |