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 '%Greece%'
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 '%Greece%' order by spcode, comname, rating DESC LIMIT 100
|
Great White Pelican Pelecanus onocrotalus |
t08/9/002 Great White Pelican | t08/9/003 Great White Pelican |
Little Bittern Ixobrychus minutus |
c31/5/083 Little Bittern | n06/1/023 Little Bittern |
Little Egret Egretta garzetta |
n06/1/034 Little Egret |
Black Stork Ciconia nigra |
c31/5/081 Black Stork | t08/11/012 Black Stork | t08/11/014 Black Stork |
Glossy Ibis Plegadis falcinellus |
c31/5/082 Glossy Ibis |
Ferruginous Pochard Aythya nyroca |
n06/1/062 Ferruginous Pochard |
Griffon Vulture Gyps fulvus |
y03/2/007 Griffon Vulture |
Chukar Alectoris chukar |
w27/22/011 Chukar |
Water Rail Rallus aquaticus |
n06/1/113 Water Rail |
Baillon's Crake Porzana pusilla |
t08/13/755 Baillon's Crake |
Yellow-legged Gull Larus michahellis |
t08/13/159 Yellow-legged Gull |
Laughing Gull Leucophaeus atricilla |
t08/13/163 Laughing Gull |
Mediterranean Gull Larus melanocephalus |
t08/13/160 Mediterranean Gull | t08/13/161 Mediterranean Gull |
Wood Sandpiper Tringa glareola |
n06/1/142 Wood Sandpiper | t08/9/005 Wood Sandpiper | t08/9/006 Wood Sandpiper | t08/9/007 Wood Sandpiper |
t08/9/008 Wood Sandpiper |
Little Stint Calidris minuta |
n06/1/150 Little Stint |
Curlew Sandpiper Calidris ferruginea |
n06/1/152 Curlew Sandpiper |
Ruff Philomachus pugnax |
n06/1/154 Ruff |
Little Owl Athene noctua |
n06/1/202 Little Owl | c31/5/080 Little Owl |
Eurasian Roller Coracias garrulus |
n06/1/240 Eurasian Roller |
Crested Lark Galerida cristata |
t08/13/162 Crested Lark | n06/1/257 Crested Lark |
Wood Lark Lullula arborea |
y03/2/037 Wood Lark |
Cretzchmar's Bunting Emberiza caesia |
n06/1/274 Cretzchmar's Bunting |
Black-headed Bunting Emberiza melanocephala |
n06/1/275 Black-headed Bunting | y03/2/036 Black-headed Bunting |
Hawfinch Coccothraustes coccothraustes |
p25/3/097 Hawfinch | p25/3/098 Hawfinch |
Barn Swallow Hirundo rustica |
y03/2/042 Barn Swallow |
Red-rumped Swallow Hirundo daurica |
n06/1/341 Red-rumped Swallow | y03/2/043 Red-rumped Swallow | y03/2/044 Red-rumped Swallow |
Red-backed Shrike Lanius collurio |
b50/1/024 Red-backed Shrike |
Northern Shrike Lanius excubitor |
t08/13/149 Northern Shrike | p25/3/312 Northern Shrike | p25/3/313 Northern Shrike |
Woodchat Shrike Lanius senator |
n06/1/368 Woodchat Shrike |
Citrine Wagtail Motacilla citreola |
t08/13/730 Citrine Wagtail |
Red-throated Pipit Anthus cervinus |
t08/13/570 Red-throated Pipit | t08/13/571 Red-throated Pipit | n06/1/382 Red-throated Pipit |
Water Pipit Anthus spinoletta |
t08/13/150 Water Pipit |
Sombre Tit Parus lugubris |
t08/6/039 Sombre Tit | t08/6/040 Sombre Tit |
House Sparrow Passer domesticus |
n06/1/405 House Sparrow | n06/1/406 House Sparrow |
Penduline Tit Remiz pendulinus |
y03/2/048 Penduline Tit | y03/2/049 Penduline Tit |
Rock Nuthatch Sitta neumayer |
c44/4/071 Rock Nuthatch | o05/6/002 Rock Nuthatch |
Zitting Cisticola Cisticola juncidis |
t08/9/023 Zitting Cisticola |
Black-eared Wheatear Oenanthe hispanica |
n06/1/436 Black-eared Wheatear |