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 |