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 |
![Great White Pelican
(Pelecanus onocrotalus)
adult Sex Unknown
Greece
Lesbos Date: May](get_image.php?target=t08-9-002&ticket=260b8c64ed563bed8e7ac50842cbcf59) t08/9/002 Great White Pelican | ![Great White Pelican
(Pelecanus onocrotalus)
adult Sex Unknown
Greece
Lesbos Date: May](get_image.php?target=t08-9-003&ticket=03d82b87cf6bfe726806cb5d7db5e78b) t08/9/003 Great White Pelican |
Little Bittern Ixobrychus minutus |
![Little Bittern
(Ixobrychus minutus)
adult male
Greece
Lesbos Lesvos Date: April](get_image.php?target=c31-5-083&ticket=e13244e18f38b1eea967805dc8678168) c31/5/083 Little Bittern | ![Little Bittern
(Ixobrychus minutus)
adult male
Greece
Samos No date](get_image.php?target=n06-1-023&ticket=391c35b46199fe37d8fad3fa64ef41c1) n06/1/023 Little Bittern |
Little Egret Egretta garzetta |
![Little Egret
(Egretta garzetta)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-034&ticket=80e0fb69fe7d0c7b3732a5b9180f9a87) n06/1/034 Little Egret |
Black Stork Ciconia nigra |
![Black Stork
(Ciconia nigra)
adult Sex Unknown
Greece
Lesbos Lesvos Date: April](get_image.php?target=c31-5-081&ticket=1b844881ddd370029401737f2ebf02f4) c31/5/081 Black Stork | ![Black Stork
(Ciconia nigra)
adult Sex Unknown
Greece
Lesbos Date: May](get_image.php?target=t08-11-012&ticket=11d9439c89abbca2726730996f2d9b4e) t08/11/012 Black Stork | ![Black Stork
(Ciconia nigra)
adult Sex Unknown
Greece
Lesbos Date: May](get_image.php?target=t08-11-014&ticket=a907889e013c9d444e333750be02bd43) t08/11/014 Black Stork |
Glossy Ibis Plegadis falcinellus |
![Glossy Ibis
(Plegadis falcinellus)
adult Sex Unknown
Greece
Lesbos Lesvos Date: April](get_image.php?target=c31-5-082&ticket=a65d477004ce12d85eebd5af1cb08df3) c31/5/082 Glossy Ibis |
Ferruginous Pochard Aythya nyroca |
![Ferruginous Pochard
(Aythya nyroca)
adult male
Greece
Samos No date](get_image.php?target=n06-1-062&ticket=cbab2dd0ea5b5bdb252e480d24ff0242) n06/1/062 Ferruginous Pochard |
Griffon Vulture Gyps fulvus |
![Griffon Vulture
(Gyps fulvus)
adult Sex Unknown
Greece
Dadia Date: June](get_image.php?target=y03-2-007&ticket=12868220f4e423ea63470404d876dc1b) y03/2/007 Griffon Vulture |
Chukar Alectoris chukar |
![Chukar
(Alectoris chukar)
adult Sex Unknown
Greece
Date: April](get_image.php?target=w27-22-011&ticket=11735c449cf1232dbae8d226446edddd) w27/22/011 Chukar |
Water Rail Rallus aquaticus |
![Water Rail
(Rallus aquaticus)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-113&ticket=169e13a6d0a0073c85b38586f20d54c1) n06/1/113 Water Rail |
Baillon's Crake Porzana pusilla |
![Baillon's Crake
(Porzana pusilla)
adult Sex Unknown
Greece
No date](get_image.php?target=t08-13-755&ticket=b636624a109a949bfa785077a5a627a1) t08/13/755 Baillon's Crake |
Yellow-legged Gull Larus michahellis |
![Yellow-legged Gull
(Larus michahellis)
adult Sex Unknown
Greece
Lake Kerkini Date: January](get_image.php?target=t08-13-159&ticket=9f879202f31bd7ff4700e7f75cee223b) t08/13/159 Yellow-legged Gull |
Laughing Gull Leucophaeus atricilla |
![Laughing Gull
(Leucophaeus atricilla)
adult Sex Unknown
Greece
Angelochori Salt Pans Date: January](get_image.php?target=t08-13-163&ticket=88c0cddafa5feaa904431e6e92e64041) t08/13/163 Laughing Gull |
Mediterranean Gull Larus melanocephalus |
![Mediterranean Gull
(Larus melanocephalus)
adult Sex Unknown
Greece
Date: January](get_image.php?target=t08-13-160&ticket=e11f3d5d515b087aa5d00ac305cb5cf9) t08/13/160 Mediterranean Gull | ![Mediterranean Gull
(Larus melanocephalus)
adult Sex Unknown
Greece
Date: January](get_image.php?target=t08-13-161&ticket=a662524346129bf92d8be08c1781cddb) t08/13/161 Mediterranean Gull |
Wood Sandpiper Tringa glareola |
![Wood Sandpiper
(Tringa glareola)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-142&ticket=f13c298bf7d3ce4881cf3e375dddb9d1) n06/1/142 Wood Sandpiper | ![Wood Sandpiper
(Tringa glareola)
adult Sex Unknown
Greece
Lesbos Date: April](get_image.php?target=t08-9-005&ticket=beeedc65e885a92381a6940ada64b68a) t08/9/005 Wood Sandpiper | ![Wood Sandpiper
(Tringa glareola)
adult Sex Unknown
Greece
Lesbos Date: April](get_image.php?target=t08-9-006&ticket=a94c539791e8b09d247f28fe5c9153c5) t08/9/006 Wood Sandpiper | ![Wood Sandpiper
(Tringa glareola)
adult Sex Unknown
Greece
Lesbos Date: April](get_image.php?target=t08-9-007&ticket=35e34aaaa558164daee9a20219e6a975) t08/9/007 Wood Sandpiper |
![Wood Sandpiper
(Tringa glareola)
adult Sex Unknown
Greece
Lesbos Date: April](get_image.php?target=t08-9-008&ticket=7611fb3dacb1e089ab77f5c02b191b66) t08/9/008 Wood Sandpiper |
Little Stint Calidris minuta |
![Little Stint
(Calidris minuta)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-150&ticket=29ad3ced1ee9835c2dcc09d7f81a0c91) n06/1/150 Little Stint |
Curlew Sandpiper Calidris ferruginea |
![Curlew Sandpiper
(Calidris ferruginea)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-152&ticket=ad8e070ce84110bb7ec567c0e9a9df54) n06/1/152 Curlew Sandpiper |
Ruff Philomachus pugnax |
![Ruff
(Philomachus pugnax)
adult female
Greece
Samos No date](get_image.php?target=n06-1-154&ticket=b8f9d5a119758844a5e74102f6bef2d2) n06/1/154 Ruff |
Little Owl Athene noctua |
![Little Owl
(Athene noctua)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-202&ticket=bc7e9bc13865b5298ceb6e232f09bc4a) n06/1/202 Little Owl | ![Little Owl
(Athene noctua)
adult Sex Unknown
Greece
Lesbos Lesvos Date: April](get_image.php?target=c31-5-080&ticket=7592d2d06165aa184bf18209c8f053ff) c31/5/080 Little Owl |
Eurasian Roller Coracias garrulus |
![Eurasian Roller
(Coracias garrulus)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-240&ticket=3aaf8be2f6269474e4b05eaba2f80f0a) n06/1/240 Eurasian Roller |
Crested Lark Galerida cristata |
![Crested Lark
(Galerida cristata)
adult Sex Unknown
Greece
Date: January](get_image.php?target=t08-13-162&ticket=2bb21f2c4c4486218ac5009dd2839c41) t08/13/162 Crested Lark | ![Crested Lark
(Galerida cristata)
adult male
Greece
Samos No date](get_image.php?target=n06-1-257&ticket=90880e220742e9d03aebc6b1149f50df) n06/1/257 Crested Lark |
Wood Lark Lullula arborea |
![Wood Lark
(Lullula arborea)
adult Sex Unknown
Greece
Dadia Date: April](get_image.php?target=y03-2-037&ticket=d4e6097c285585ade67947a5a5715539) y03/2/037 Wood Lark |
Cretzchmar's Bunting Emberiza caesia |
![Cretzchmar's Bunting
(Emberiza caesia)
adult male
Greece
Samos No date](get_image.php?target=n06-1-274&ticket=578a7742e6ed9612d14101d9a79f68fe) n06/1/274 Cretzchmar's Bunting |
Black-headed Bunting Emberiza melanocephala |
![Black-headed Bunting
(Emberiza melanocephala)
adult male
Greece
Samos No date](get_image.php?target=n06-1-275&ticket=631e2955cd8121cd063e732d0d7e6d65) n06/1/275 Black-headed Bunting | ![Black-headed Bunting
(Emberiza melanocephala)
adult male
Greece
Date: June](get_image.php?target=y03-2-036&ticket=08c5522a47d326bd8d20a3a7089459a4) y03/2/036 Black-headed Bunting |
Hawfinch Coccothraustes coccothraustes |
![Hawfinch
(Coccothraustes coccothraustes)
adult Sex Unknown
Greece
Oulu Date: January](get_image.php?target=p25-3-097&ticket=2b05be0d57d9e581ac6ba3d758862d8b) p25/3/097 Hawfinch | ![Hawfinch
(Coccothraustes coccothraustes)
adult Sex Unknown
Greece
Oulu Date: January](get_image.php?target=p25-3-098&ticket=e62572decc181744dc13adc7d0ec289a) p25/3/098 Hawfinch |
Barn Swallow Hirundo rustica |
![Barn Swallow
(Hirundo rustica)
adult Sex Unknown
Greece
Date: May](get_image.php?target=y03-2-042&ticket=312971e73288697d48fbe08fa7ece625) y03/2/042 Barn Swallow |
Red-rumped Swallow Hirundo daurica |
![Red-rumped Swallow
(Hirundo daurica)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-341&ticket=c61789bed295a2d8dc339c6994bca823) n06/1/341 Red-rumped Swallow | ![Red-rumped Swallow
(Hirundo daurica)
adult Sex Unknown
Greece
Date: April](get_image.php?target=y03-2-043&ticket=d9854373b0f776ff5d2bf6bad42c7db8) y03/2/043 Red-rumped Swallow | ![Red-rumped Swallow
(Hirundo daurica)
adult Sex Unknown
Greece
Date: May](get_image.php?target=y03-2-044&ticket=f96ee913ceaa630894c6b1dac934908f) y03/2/044 Red-rumped Swallow |
Red-backed Shrike Lanius collurio |
![Red-backed Shrike
(Lanius collurio)
juvenile Sex Unknown
Greece
Litohoro Date: September](get_image.php?target=b50-1-024&ticket=5d7affb8c66e7e13916b7530ef843d29) b50/1/024 Red-backed Shrike |
Northern Shrike Lanius excubitor |
![Northern Shrike
(Lanius excubitor)
adult Sex Unknown
Greece
Date: January](get_image.php?target=t08-13-149&ticket=3e7136f1bcda43b76c9dd6db8aa80e77) t08/13/149 Northern Shrike | ![Northern Shrike
(Lanius excubitor)
adult Sex Unknown
Greece
Macedonia Date: January](get_image.php?target=p25-3-312&ticket=0d585b63792d27cc8c4eb4058cd6d32b) p25/3/312 Northern Shrike | ![Northern Shrike
(Lanius excubitor)
adult Sex Unknown
Greece
Macedonia Date: January](get_image.php?target=p25-3-313&ticket=bdee3fdb99cea9591da06ae8ee0aeee2) p25/3/313 Northern Shrike |
Woodchat Shrike Lanius senator |
![Woodchat Shrike
(Lanius senator)
adult female
Greece
Samos No date](get_image.php?target=n06-1-368&ticket=cac90df966fe56157c6d01496f428962) n06/1/368 Woodchat Shrike |
Citrine Wagtail Motacilla citreola |
![Citrine Wagtail
(Motacilla citreola)
adult male
Greece
Lesbos Date: June](get_image.php?target=t08-13-730&ticket=9dd761c2f4a161aed2f12dd4b6607537) t08/13/730 Citrine Wagtail |
Red-throated Pipit Anthus cervinus |
![Red-throated Pipit
(Anthus cervinus)
adult Sex Unknown
Greece
Lesbos Date: September](get_image.php?target=t08-13-570&ticket=25f662618da3ec83f0f180d5cef5dfd5) t08/13/570 Red-throated Pipit | ![Red-throated Pipit
(Anthus cervinus)
adult Sex Unknown
Greece
Lesbos Date: September](get_image.php?target=t08-13-571&ticket=687ef2e8a3960bbf47aa077fb291a983) t08/13/571 Red-throated Pipit | ![Red-throated Pipit
(Anthus cervinus)
adult Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-382&ticket=dc521b023f54fd7be68ab0f220c60d9c) n06/1/382 Red-throated Pipit |
Water Pipit Anthus spinoletta |
![Water Pipit
(Anthus spinoletta)
Age unknown Sex Unknown
Greece
Northern Greece Date: January](get_image.php?target=t08-13-150&ticket=3643c007491202758a7349e62317adeb) t08/13/150 Water Pipit |
Sombre Tit Parus lugubris |
![Sombre Tit
(Parus lugubris)
adult Sex Unknown
Greece
Lesbos Date: April](get_image.php?target=t08-6-039&ticket=cee29ea92c59cca9113778d227f0723f) t08/6/039 Sombre Tit | ![Sombre Tit
(Parus lugubris)
adult Sex Unknown
Greece
Lesbos Date: April](get_image.php?target=t08-6-040&ticket=bb47616748e38d0194c2bed70c80036c) t08/6/040 Sombre Tit |
House Sparrow Passer domesticus |
![House Sparrow
(Passer domesticus)
juvenile Sex Unknown
Greece
Samos No date](get_image.php?target=n06-1-405&ticket=d90923e68f7f1888124c672145e16fd2) n06/1/405 House Sparrow | ![House Sparrow
(Passer domesticus)
adult male
Greece
Samos No date](get_image.php?target=n06-1-406&ticket=3ac6148ffc8855a1d685ad321c82b550) n06/1/406 House Sparrow |
Penduline Tit Remiz pendulinus |
![Penduline Tit
(Remiz pendulinus)
adult Sex Unknown
Greece
Kerkini Date: April](get_image.php?target=y03-2-048&ticket=94abc3f09c0d29ccaa92fae5609b2472) y03/2/048 Penduline Tit | ![Penduline Tit
(Remiz pendulinus)
adult at nest Sex Unknown
Greece
Kerkini Date: May](get_image.php?target=y03-2-049&ticket=bfffa89791d74585cfb8c0a4a423cdbd) y03/2/049 Penduline Tit |
Rock Nuthatch Sitta neumayer |
![Rock Nuthatch
(Sitta neumayer)
adult Sex Unknown
Greece
Delphi Date: October](get_image.php?target=c44-4-071&ticket=3e781366541173d145c59695d460b266) c44/4/071 Rock Nuthatch | ![Rock Nuthatch
(Sitta neumayer)
adult Sex Unknown
Greece
Delphi Date: May](get_image.php?target=o05-6-002&ticket=901fa333c0f5f5103b7e26a86cf6a22e) o05/6/002 Rock Nuthatch |
Zitting Cisticola Cisticola juncidis |
![Zitting Cisticola
(Cisticola juncidis)
adult Sex Unknown
Greece
Date: April](get_image.php?target=t08-9-023&ticket=b8b65169d0af0206dcf72dc3be7c2432) t08/9/023 Zitting Cisticola |
Black-eared Wheatear Oenanthe hispanica |
![Black-eared Wheatear
(Oenanthe hispanica)
adult male
Greece
Samos No date](get_image.php?target=n06-1-436&ticket=28110308723659c2c2bbdadee1600996) n06/1/436 Black-eared Wheatear |