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 '%Yemen%'
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 '%Yemen%' order by spcode, comname, rating DESC LIMIT 100
|
Brown Booby Sula leucogaster |
e05/14/072 Brown Booby |
Black Kite Milvus migrans |
e05/14/042 Black Kite | e05/14/043 Black Kite | e05/12/005 Black Kite | e05/12/004 Black Kite |
|
Griffon Vulture Gyps fulvus |
e05/12/027 Griffon Vulture |
Dark Chanting Goshawk Melierax metabates |
|
Philby's Rock-Partridge Alectoris philbyi |
e05/14/218 Philby's Rock-Partridge |
White-eyed Gull Larus leucophthalmus |
e05/14/324 White-eyed Gull | e05/14/325 White-eyed Gull | e05/14/326 White-eyed Gull | e05/14/327 White-eyed Gull |
|
Slender-billed Gull Larus genei |
e05/14/269 Slender-billed Gull | e05/14/270 Slender-billed Gull | e05/14/271 Slender-billed Gull |
Black-winged Stilt Himantopus himantopus |
e05/14/062 Black-winged Stilt |
Caspian Tern Hydroprogne caspia |
e05/14/076 Caspian Tern |
Lesser Crested Tern Sterna bengalensis |
e05/14/171 Lesser Crested Tern |
African Olive Pigeon Columba arquatrix |
|
Dusky Turtle-Dove Streptopelia lugens |
e05/13/020 Dusky Turtle-Dove | e05/12/022 Dusky Turtle-Dove |
African Collared-Dove Streptopelia roseogrisea |
e05/13/001 African Collared-Dove |
Red-eyed Dove Streptopelia semitorquata |
e05/13/064 Red-eyed Dove | e05/13/065 Red-eyed Dove |
Namaqua Dove Oena capensis |
e05/13/057 Namaqua Dove |
Little Owl Athene noctua |
e05/15/101 Little Owl | e05/15/102 Little Owl |
African Gray Hornbill Tockus nasutus |
e05/12/001 African Gray Hornbill | e05/12/002 African Gray Hornbill |
Abyssinian Roller Coracias abyssinica |
e05/14/001 Abyssinian Roller | e05/14/002 Abyssinian Roller |
Arabian Woodpecker Dendrocopos dorae |
e05/13/003 Arabian Woodpecker | e05/13/004 Arabian Woodpecker |
Red-capped Lark Calandrella cinerea |
e05/12/047 Red-capped Lark | e05/12/046 Red-capped Lark |
House Crow Corvus splendens |
e05/14/142 House Crow |
Fan-tailed Raven Corvus rhipidurus |
e05/14/112 Fan-tailed Raven | e05/12/031 Fan-tailed Raven | e05/12/032 Fan-tailed Raven |
Arabian Waxbill Estrilda rufibarba |
e05/14/005 Arabian Waxbill | e05/14/006 Arabian Waxbill |
Yemen Serin Serinus menachensis |
e05/12/069 Yemen Serin |
Yemen Linnet Acanthis yemenensis |
e05/12/068 Yemen Linnet | e05/12/067 Yemen Linnet |
Olive-rumped Serin Serinus rothschildsi |
e05/12/042 Olive-rumped Serin | e05/12/044 Olive-rumped Serin | e05/12/043 Olive-rumped Serin |
Northern Shrike Lanius excubitor |
d22/1/049 Northern Shrike |
Southern Gray Shrike Lanius meridionalis |
e05/13/094 Southern Gray Shrike | e05/13/095 Southern Gray Shrike |
Bush Petronia Gymnoris dentata |
e05/14/074 Bush Petronia |
Ruppell's Weaver Ploceus galbula |
e05/14/260 Ruppell's Weaver | e05/14/261 Ruppell's Weaver | e05/14/262 Ruppell's Weaver | e05/14/263 Ruppell's Weaver |
|
Yemen Accentor Prunella fagani |
e05/12/066 Yemen Accentor |
Somali Starling Onychognathus blythii |
e05/14/272 Somali Starling |
Arabian Warbler Sylvia leucomelaena |
e05/12/003 Arabian Warbler |
Menetries Warbler Sylvia mystacea |
e05/12/039 Menetries Warbler |
Brown Woodland-Warbler Phylloscopus umbrovirens |
e05/13/010 Brown Woodland-Warbler | e05/12/015 Brown Woodland-Warbler |
Streaked Scrub-Warbler Scotocerca inquieta |
e05/12/052 Streaked Scrub-Warbler | e05/12/051 Streaked Scrub-Warbler | e05/13/099 Streaked Scrub-Warbler | e05/12/050 Streaked Scrub-Warbler |
|
Socotra Warbler Incana incana |
e05/12/056 Socotra Warbler | e05/12/057 Socotra Warbler | e05/12/058 Socotra Warbler |
Yemen Warbler Parisoma buryi |
e05/12/071 Yemen Warbler |
Arabian Babbler Turdoides squamiceps |
e05/15/103 Arabian Babbler |
Black Scrub-Robin Cercotrichas podobe |
e05/14/049 Black Scrub-Robin | e05/14/050 Black Scrub-Robin | e05/13/009 Black Scrub-Robin |
Stonechat Saxicola torquatus |
e05/15/098 Stonechat |
Red-breasted Wheatear Oenanthe bottae |
e05/12/045 Red-breasted Wheatear |
Little Rock-Thrush Monticola rufocinereus |
e05/12/037 Little Rock-Thrush | e05/12/038 Little Rock-Thrush | e05/13/048 Little Rock-Thrush |
Yemen Thrush Turdus menachensis |
e05/12/070 Yemen Thrush |
Arabian Wheatear Oenanthe lugentoides |
e05/12/060 Arabian Wheatear | e05/13/002 Arabian Wheatear | e05/12/059 Arabian Wheatear |