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 '%Cambodia%'
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 '%Cambodia%' order by spcode, comname, rating DESC LIMIT 100
|
Spot-billed Pelican Pelecanus philippensis |
h42/6/110 Spot-billed Pelican | h42/6/111 Spot-billed Pelican | h42/6/112 Spot-billed Pelican |
Indian Cormorant Phalacrocorax fuscicollis |
h42/6/053 Indian Cormorant |
Painted Stork Mycteria leucocephala |
h42/6/072 Painted Stork | h42/6/073 Painted Stork |
Woolly-necked Stork Ciconia episcopus |
s83/1/042 Woolly-necked Stork |
Lesser Adjutant Stork Leptoptilos javanicus |
h42/6/060 Lesser Adjutant Stork |
White-shouldered Ibis Pseudibis davisoni |
s83/1/006 White-shouldered Ibis |
Giant Ibis Pseudibis gigantea |
h42/6/037 Giant Ibis | h42/6/038 Giant Ibis | h42/6/039 Giant Ibis | h42/6/040 Giant Ibis |
h42/6/041 Giant Ibis | h42/6/042 Giant Ibis | h42/6/043 Giant Ibis | h42/6/044 Giant Ibis |
h42/6/045 Giant Ibis |
Comb Duck Sarkidiornis melanotos |
h42/6/025 Comb Duck | h42/6/026 Comb Duck | h42/6/027 Comb Duck | h42/6/028 Comb Duck |
|
Cotton Pygmy-Goose Nettapus coromandelianus |
h42/6/029 Cotton Pygmy-Goose |
Black Baza Aviceda leuphotes |
s83/1/033 Black Baza | s83/1/032 Black Baza |
Gray-headed Fish-Eagle Ichthyophaga ichthyaetus |
s83/1/020 Gray-headed Fish-Eagle | s83/1/026 Gray-headed Fish-Eagle |
White-rumped Vulture Gyps bengalensis |
h42/6/121 White-rumped Vulture | h42/6/122 White-rumped Vulture |
Red-headed Vulture Sarcogyps calvus |
s83/1/039 Red-headed Vulture | s83/1/040 Red-headed Vulture | h42/6/091 Red-headed Vulture | h42/6/092 Red-headed Vulture |
s83/1/031 Red-headed Vulture |
Rufous-winged Buzzard Butastur liventer |
s83/1/007 Rufous-winged Buzzard |
White-rumped Falcon Polihierax insignis |
h42/6/125 White-rumped Falcon | h42/6/126 White-rumped Falcon |
Green Peafowl Pavo muticus |
s83/1/034 Green Peafowl |
Sarus Crane Grus antigone |
h42/6/101 Sarus Crane |
Bengal Florican Houbaropsis bengalensis |
h42/6/002 Bengal Florican | h42/6/003 Bengal Florican | h42/6/004 Bengal Florican | h42/6/005 Bengal Florican |
|
River Lapwing Vanellus duvaucelii |
s83/1/003 River Lapwing |
Little Pratincole Glareola lactea |
s83/1/021 Little Pratincole | s83/1/023 Little Pratincole |
Slender-billed Gull Larus genei |
s83/1/029 Slender-billed Gull |
River Tern Sterna aurantia |
s83/1/019 River Tern | s83/1/022 River Tern |
Orange-breasted Green-Pigeon Treron bicincta |
s83/1/038 Orange-breasted Green-Pigeon |
Brown Fish-Owl Ketupa zeylonensis |
s83/1/027 Brown Fish-Owl |
Spotted Wood-Owl Strix seloputo |
s83/1/041 Spotted Wood-Owl |
Oriental Scops-Owl Otus sunia |
h42/6/071 Oriental Scops-Owl |
Oriental Pied Hornbill Anthracoceros albirostris |
s83/1/030 Oriental Pied Hornbill |
Blue-tailed Bee-eater Merops philippinus |
s83/1/001 Blue-tailed Bee-eater |
Chestnut-headed Bee-eater Merops leschenaulti |
s83/1/005 Chestnut-headed Bee-eater |
Black-headed Woodpecker Picus erythropygius |
s83/1/025 Black-headed Woodpecker |
Greater Flameback Chrysocolaptes lucidus |
s83/1/002 Greater Flameback |
Mekong Wagtail Motacilla samveasnae |
s83/1/024 Mekong Wagtail | s83/1/028 Mekong Wagtail | s83/1/036 Mekong Wagtail |
Plain-backed Sparrow Passer flaveolus |
h42/6/084 Plain-backed Sparrow | h42/6/085 Plain-backed Sparrow |
Asian Golden Weaver Ploceus hypoxanthus |
s83/1/043 Asian Golden Weaver |
Chestnut-tailed Starling Sturnus malabaricus |
s83/1/035 Chestnut-tailed Starling |