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 '%Switzerland%'
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 '%Switzerland%' order by spcode, comname, rating DESC LIMIT 100
77 Images found.
|
Little Grebe Tachybaptus ruficollis |
n06/1/002 Little Grebe |
Great Crested Grebe Podiceps cristatus |
n06/1/001 Great Crested Grebe |
White Stork Ciconia ciconia |
n06/1/043 White Stork |
Whooper Swan Cygnus cygnus |
n06/1/047 Whooper Swan |
Ruddy Shelduck Tadorna ferruginea |
e05/10/003 Ruddy Shelduck |
Green-winged Teal Anas crecca |
n06/1/054 Green-winged Teal |
Red-crested Pochard Netta rufina |
e05/10/004 Red-crested Pochard |
Tufted Duck Aythya fuligula |
e05/10/005 Tufted Duck |
Common Goldeneye Bucephala clangula |
e05/10/006 Common Goldeneye |
Common Buzzard Buteo buteo |
n06/1/079 Common Buzzard | n06/1/080 Common Buzzard |
Rock Ptarmigan Lagopus muta |
e05/13/072 Rock Ptarmigan | e05/13/073 Rock Ptarmigan |
Black Grouse Tetrao tetrix |
n06/1/093 Black Grouse |
Capercaillie Tetrao urogallus |
n06/1/094 Capercaillie |
Eurasian Coot Fulica atra |
n06/2/153 Eurasian Coot | n06/1/118 Eurasian Coot | e05/10/016 Eurasian Coot |
Common Cuckoo Cuculus canorus |
n06/1/183 Common Cuckoo |
Northern Eagle-Owl Bubo bubo |
n06/1/196 Northern Eagle-Owl |
Tawny Owl Strix aluco |
n06/1/204 Tawny Owl |
Alpine Swift Apus melba |
c21/5/007 Alpine Swift | c21/5/008 Alpine Swift | c21/5/009 Alpine Swift |
Common Kingfisher Alcedo atthis |
n06/1/234 Common Kingfisher |
Eurasian Wryneck Jynx torquilla |
n06/1/246 Eurasian Wryneck |
Lesser Spotted Woodpecker Picoides minor |
n06/1/251 Lesser Spotted Woodpecker |
Green Woodpecker Picus viridis |
n06/1/255 Green Woodpecker |
White-throated Dipper Cinclus cinclus |
n06/1/258 White-throated Dipper | n06/1/259 White-throated Dipper |
Eurasian Nutcracker Nucifraga caryocatactes |
n06/1/267 Eurasian Nutcracker |
Yellow-billed Chough Pyrrhocorax graculus |
e05/13/104 Yellow-billed Chough | c31/6/017 Yellow-billed Chough | n06/1/268 Yellow-billed Chough | e05/10/024 Yellow-billed Chough |
|
Snow Bunting Plectrophenax nivalis |
n06/1/278 Snow Bunting |
Brambling Fringilla montifringilla |
n06/1/327 Brambling | n06/1/328 Brambling |
European Greenfinch Carduelis chloris |
n06/2/154 European Greenfinch | n06/2/155 European Greenfinch |
European Goldfinch Carduelis carduelis |
n06/1/331 European Goldfinch |
Red Crossbill Loxia curvirostra |
n06/1/336 Red Crossbill |
Eurasian Bullfinch Pyrrhula pyrrhula |
n06/2/151 Eurasian Bullfinch | n06/2/152 Eurasian Bullfinch |
Barn Swallow Hirundo rustica |
n06/1/339 Barn Swallow |
Common House-Martin Delichon urbicum |
n06/1/337 Common House-Martin |
Red-backed Shrike Lanius collurio |
n06/1/366 Red-backed Shrike |
Northern Shrike Lanius excubitor |
n06/1/367 Northern Shrike |
Meadow Pipit Anthus pratensis |
n06/1/381 Meadow Pipit |
Willow Tit Parus montanus |
n06/1/385 Willow Tit |
Coal Tit Parus ater |
n06/2/131 Coal Tit | n06/2/132 Coal Tit | n06/1/386 Coal Tit |
Crested Tit Parus cristatus |
n06/2/133 Crested Tit | n06/2/134 Crested Tit | n06/2/135 Crested Tit |
Great Tit Parus major |
n06/2/182 Great Tit | n06/2/183 Great Tit | n06/2/184 Great Tit |
Blue Tit Parus caeruleus |
n06/2/074 Blue Tit | n06/2/075 Blue Tit | n06/2/076 Blue Tit | n06/1/387 Blue Tit |
|
Eurasian Snow Finch Montifringilla nivalis |
c31/6/018 Eurasian Snow Finch |
Garden Warbler Sylvia borin |
n06/1/413 Garden Warbler |
Eurasian Blackcap Sylvia atricapilla |
|
Willow Warbler Phylloscopus trochilus |
n06/1/417 Willow Warbler |
Eurasian Wren Troglodytes troglodytes |
n06/1/425 Eurasian Wren |
European Robin Erithacus rubecula |
n06/2/156 European Robin |
Bluethroat Luscinia svecica |
n06/1/428 Bluethroat |
Common Redstart Phoenicurus phoenicurus |
n06/1/430 Common Redstart |
European Whinchat Saxicola rubetra |
n06/1/434 European Whinchat |
Stonechat Saxicola torquatus |
n06/1/435 Stonechat |
Eurasian Blackbird Turdus merula |
n06/1/437 Eurasian Blackbird |
Fieldfare Turdus pilaris |
n06/1/438 Fieldfare |
Common Song Thrush Turdus philomelos |
n06/1/439 Common Song Thrush |