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 '%United% Arab% Emirate%'
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 '%United% Arab% Emirate%' order by spcode, comname, rating DESC LIMIT 100
|
Little Grebe Tachybaptus ruficollis |
e05/15/028 Little Grebe | e05/15/029 Little Grebe | e05/15/030 Little Grebe |
Socotra Cormorant Phalacrocorax nigrogularis |
a16/10/023 Socotra Cormorant |
Western Reef-Heron Egretta gularis |
e05/17/104 Western Reef-Heron |
Great Egret Ardea alba |
e05/1/016 Great Egret |
Gray Heron Ardea cinerea |
e05/14/119 Gray Heron |
Glossy Ibis Plegadis falcinellus |
e05/14/115 Glossy Ibis | e05/14/116 Glossy Ibis |
Greater Flamingo Phoenicopterus roseus |
e05/1/054 Greater Flamingo | e05/1/056 Greater Flamingo | e05/1/052 Greater Flamingo | e05/1/053 Greater Flamingo |
e05/1/055 Greater Flamingo | e05/17/058 Greater Flamingo | e05/4/110 Greater Flamingo |
Ruddy Shelduck Tadorna ferruginea |
e05/12/048 Ruddy Shelduck |
Verreaux's Eagle Aquila verreauxii |
a16/10/050 Verreaux's Eagle |
Peregrine Falcon Falco peregrinus |
e05/4/217 Peregrine Falcon | e05/1/123 Peregrine Falcon | e05/1/124 Peregrine Falcon | e05/1/125 Peregrine Falcon |
|
Vulturine Guineafowl Acryllium vulturinum |
e05/4/222 Vulturine Guineafowl | e05/4/221 Vulturine Guineafowl |
Chukar Alectoris chukar |
e05/18/025 Chukar |
Gray Francolin Francolinus pondicerianus |
e05/15/024 Gray Francolin | e05/1/127 Gray Francolin | e05/15/092 Gray Francolin | e05/15/093 Gray Francolin |
e05/1/126 Gray Francolin |
Houbara Bustard Chlamydotis undulata |
e05/14/139 Houbara Bustard | e05/14/140 Houbara Bustard | e05/14/141 Houbara Bustard | e05/14/185 Houbara Bustard |
|
Sociable Lapwing Vanellus gregarius |
e05/1/171 Sociable Lapwing | e05/1/172 Sociable Lapwing |
White-tailed Lapwing Vanellus leucurus |
e05/14/328 White-tailed Lapwing |
Greater Sand-Plover Charadrius leschenaultii |
a16/10/024 Greater Sand-Plover |
Crab-Plover Dromas ardeola |
a16/10/013 Crab-Plover | e05/1/141 Crab-Plover |
Black-headed Gull Chroicocephalus ridibundus |
e05/1/277 Black-headed Gull | e05/4/293 Black-headed Gull |
Eurasian Curlew Numenius arquata |
e05/17/037 Eurasian Curlew | e05/15/096 Eurasian Curlew |
Terek Sandpiper Xenus cinereus |
a16/10/048 Terek Sandpiper | a16/10/049 Terek Sandpiper |
Common Sandpiper Actitis hypoleucos |
e05/15/097 Common Sandpiper |
Little Stint Calidris minuta |
y03/10/094 Little Stint | y03/10/095 Little Stint | y03/10/096 Little Stint |
White-cheeked Tern Sterna repressa |
e05/14/314 White-cheeked Tern | e05/14/315 White-cheeked Tern | e05/14/321 White-cheeked Tern |
Sandwich Tern Thalasseus sandvicensis |
e05/1/305 Sandwich Tern |
Eurasian Collared-Dove Streptopelia decaocto |
e05/13/028 Eurasian Collared-Dove |
Rose-ringed Parakeet Psittacula krameri |
e05/1/344 Rose-ringed Parakeet |
Common Hawk-Cuckoo Cuculus varius |
e05/17/024 Common Hawk-Cuckoo | e05/17/025 Common Hawk-Cuckoo | e05/17/026 Common Hawk-Cuckoo |
Common Cuckoo Cuculus canorus |
e05/17/022 Common Cuckoo | e05/17/023 Common Cuckoo |
Northern Eagle-Owl Bubo bubo |
e05/14/215 Northern Eagle-Owl | e05/14/216 Northern Eagle-Owl | e05/14/217 Northern Eagle-Owl |
Barn Owl Tyto alba |
e05/14/027 Barn Owl |
Collared Kingfisher Todirhamphus chloris |
e05/4/412 Collared Kingfisher |
Indian Roller Coracias benghalensis |
e05/14/159 Indian Roller | y03/1/056 Indian Roller | e05/1/382 Indian Roller |
Green Bee-eater Merops orientalis |
e05/1/359 Green Bee-eater |
Eurasian Hoopoe Upupa epops |
e05/3/024 Eurasian Hoopoe | e05/12/028 Eurasian Hoopoe | a16/10/028 Eurasian Hoopoe | e05/1/385 Eurasian Hoopoe |
|
Desert Lark Ammomanes deserti |
e05/14/093 Desert Lark | e05/13/017 Desert Lark | e05/13/018 Desert Lark | e05/13/019 Desert Lark |
|
Crested Lark Galerida cristata |
e05/12/021 Crested Lark |
Gray Hypocolius Hypocolius ampelinus |
e05/1/417 Gray Hypocolius | e05/1/418 Gray Hypocolius | e05/1/419 Gray Hypocolius |
House Crow Corvus splendens |
y03/1/060 House Crow |
Bay-backed Shrike Lanius vittatus |
e05/18/017 Bay-backed Shrike |
Southern Gray Shrike Lanius meridionalis |
e05/1/416 Southern Gray Shrike |
Yellow Wagtail Motacilla flava |
e05/15/099 Yellow Wagtail | e05/15/100 Yellow Wagtail |
Tawny Pipit Anthus campestris |
e05/14/301 Tawny Pipit |
Spotted Flycatcher Muscicapa striata |
e05/14/292 Spotted Flycatcher |
Taiga Flycatcher Ficedula albicilla |
e05/13/105 Taiga Flycatcher | e05/13/106 Taiga Flycatcher | e05/13/101 Taiga Flycatcher | e05/13/102 Taiga Flycatcher |
|
Yellow-throated Sparrow Gymnoris xanthocollis |
e05/18/088 Yellow-throated Sparrow | e05/18/028 Yellow-throated Sparrow |
Yellow-crowned Bishop Euplectes afer |
e05/14/347 Yellow-crowned Bishop | e05/14/348 Yellow-crowned Bishop |
Black-capped Bulbul Pycnonotus xanthopygos |
e05/1/404 Black-capped Bulbul |
White-eared Bulbul Pycnonotus leucotis |
e05/15/019 White-eared Bulbul |