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 |