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 '%China,% Sichuan%' order by spcode, comname, rating DESC LIMIT 100
|
Ruddy Shelduck Tadorna ferruginea |
 a21/3/118 Ruddy Shelduck |
Black Kite Milvus migrans |
 t09/7/002 Black Kite |  a21/3/011 Black Kite |  a21/3/012 Black Kite |  a21/3/013 Black Kite |
|
Lammergeier Gypaetus barbatus |
 a21/3/099 Lammergeier |
Himalayan Vulture Gyps himalayensis |
 a21/3/080 Himalayan Vulture |  a21/3/081 Himalayan Vulture |  a21/3/082 Himalayan Vulture |  a21/3/083 Himalayan Vulture |
 a21/3/084 Himalayan Vulture |
Besra Accipiter virgatus |
 a21/3/006 Besra |
Upland Buzzard Buteo hemilasius |
 a21/3/142 Upland Buzzard |  a21/3/143 Upland Buzzard |  a21/3/144 Upland Buzzard |  a21/3/145 Upland Buzzard |
|
Temminck's Tragopan Tragopan temminckii |
 a21/3/137 Temminck's Tragopan |  a21/3/138 Temminck's Tragopan |  a21/3/139 Temminck's Tragopan |
Chinese Grouse Bonasa sewerzowi |
 a21/3/033 Chinese Grouse |
Black-necked Crane Grus nigricollis |
 a21/3/017 Black-necked Crane |  a21/3/018 Black-necked Crane |
Hill Pigeon Columba rupestris |
 a21/3/079 Hill Pigeon |  a21/3/078 Hill Pigeon |
Common Cuckoo Cuculus canorus |
 a21/3/034 Common Cuckoo |
Oriental Cuckoo Cuculus saturatus |
 a21/3/106 Oriental Cuckoo |
Little Owl Athene noctua |
 a21/3/101 Little Owl |
Darjeeling Woodpecker Picoides darjellensis |
 a21/3/036 Darjeeling Woodpecker |  a21/3/037 Darjeeling Woodpecker |  a21/3/038 Darjeeling Woodpecker |  a21/3/039 Darjeeling Woodpecker |
|
Oriental Sky Lark Alauda gulgula |
 a21/3/108 Oriental Sky Lark |
Horned Lark Eremophila alpestris |
 a21/3/085 Horned Lark |
Azure-winged Magpie Cyanopica cyana |
 a21/3/005 Azure-winged Magpie |
Hume's Ground Jay Pseudopodoces humilis |
 a21/3/087 Hume's Ground Jay |  a21/3/088 Hume's Ground Jay |  a21/3/086 Hume's Ground Jay |  a21/3/089 Hume's Ground Jay |
|
Daurian Jackdaw Corvus dauuricus |
 a21/3/040 Daurian Jackdaw |  a21/3/041 Daurian Jackdaw |
White-browed Rosefinch Carpodacus thura |
 a21/3/157 White-browed Rosefinch |
Red-fronted Rosefinch Carpodacus puniceus |
 a21/3/112 Red-fronted Rosefinch |  a21/3/113 Red-fronted Rosefinch |
Gray-headed Bullfinch Pyrrhula erythaca |
 a21/3/065 Gray-headed Bullfinch |  a21/3/066 Gray-headed Bullfinch |  a21/3/067 Gray-headed Bullfinch |
Asian House Martin Delichon dasypus |
 a21/3/004 Asian House Martin |
Olive-backed Pipit Anthus hodgsoni |
 a21/3/105 Olive-backed Pipit |
Rosy Pipit Anthus roseatus |
 a21/3/116 Rosy Pipit |  a21/3/117 Rosy Pipit |
Rufous-vented Tit Parus rubidiventris |
 a21/3/120 Rufous-vented Tit |
Yellow-bellied Tit Parus venustulus |
 a21/3/163 Yellow-bellied Tit |
Yellow-browed Tit Sylviparus modestus |
 a21/3/164 Yellow-browed Tit |
Tibetan Snow Finch Montifringilla adamsi |
 a21/3/140 Tibetan Snow Finch |
Rufous-breasted Accentor Prunella strophiata |
 a21/3/119 Rufous-breasted Accentor |
Brown Accentor Prunella fulvescens |
 a21/3/024 Brown Accentor |
Black Bulbul Hypsipetes leucocephalus |
 a21/3/007 Black Bulbul |  a21/3/008 Black Bulbul |
Brownish-flanked Bush-Warbler Cettia fortipes |
 a21/3/030 Brownish-flanked Bush-Warbler |
Yellow-bellied Bush-Warbler Cettia acanthizoides |
 a21/3/165 Yellow-bellied Bush-Warbler |  a21/3/166 Yellow-bellied Bush-Warbler |
Spotted Bush-Warbler Bradypterus thoracicus |
 a21/3/127 Spotted Bush-Warbler |  a21/3/128 Spotted Bush-Warbler |  a21/3/129 Spotted Bush-Warbler |  a21/3/130 Spotted Bush-Warbler |
|
Tickell's Leaf-Warbler Phylloscopus affinis |
 a21/3/141 Tickell's Leaf-Warbler |
Plain Laughingthrush Garrulax davidi |
 a21/3/110 Plain Laughingthrush |
Giant Laughingthrush Garrulax maximus |
 h46/8/001 Giant Laughingthrush |  h46/8/002 Giant Laughingthrush |  h46/8/003 Giant Laughingthrush |
Elliot's Laughingthrush Garrulax elliotii |
 a21/3/044 Elliot's Laughingthrush |  a21/3/045 Elliot's Laughingthrush |  a21/3/046 Elliot's Laughingthrush |  a21/3/047 Elliot's Laughingthrush |
|
Black-faced Laughingthrush Garrulax affinis |
 a21/3/014 Black-faced Laughingthrush |  a21/3/015 Black-faced Laughingthrush |
Red-billed Leiothrix Leiothrix lutea |
 a21/3/111 Red-billed Leiothrix |
Golden-breasted Fulvetta Alcippe chrysotis |
 a21/3/056 Golden-breasted Fulvetta |  a21/3/057 Golden-breasted Fulvetta |  a21/3/055 Golden-breasted Fulvetta |  a21/3/058 Golden-breasted Fulvetta |
|
Streak-throated Fulvetta Alcippe cinereiceps |
 a21/3/131 Streak-throated Fulvetta |  a21/3/132 Streak-throated Fulvetta |
Gray-hooded Parrotbill Paradoxornis zappeyi |
 a21/3/071 Gray-hooded Parrotbill |  a21/3/072 Gray-hooded Parrotbill |  a21/3/068 Gray-hooded Parrotbill |  a21/3/069 Gray-hooded Parrotbill |
 a21/3/070 Gray-hooded Parrotbill |  a21/3/073 Gray-hooded Parrotbill |
Fulvous Parrotbill Paradoxornis fulvifrons |
 a21/3/049 Fulvous Parrotbill |  a21/3/050 Fulvous Parrotbill |  a21/3/051 Fulvous Parrotbill |
Eurasian Wren Troglodytes troglodytes |
 a21/3/162 Eurasian Wren |
White-throated Redstart Phoenicurus schisticeps |
 a21/3/160 White-throated Redstart |  a21/3/161 White-throated Redstart |
White-bellied Redstart Hodgsonius phaenicuroides |
 a21/3/156 White-bellied Redstart |  a21/3/154 White-bellied Redstart |  a21/3/155 White-bellied Redstart |