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 '%Costa% Rica,% Cartago%'
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 '%Costa% Rica,% Cartago%' order by spcode, comname, rating DESC LIMIT 100
59 Images found.
|
Cattle Egret Bubulcus ibis |
 b57/1/078 Cattle Egret |
Gray-headed Chachalaca Ortalis cinereiceps |
 b57/1/116 Gray-headed Chachalaca |
White-necked Jacobin Florisuga mellivora |
 b57/1/303 White-necked Jacobin |
Brown Violetear Colibri delphinae |
 b57/1/070 Brown Violetear |  m47/5/004 Brown Violetear |
Violet-headed Hummingbird Klais guimeti |
 b57/1/290 Violet-headed Hummingbird |
Black-crested Coquette Lophornis helenae |
 b57/1/051 Black-crested Coquette |
Green Thorntail Discosura conversii |
 b57/1/141 Green Thorntail |  b57/1/142 Green Thorntail |  b57/1/140 Green Thorntail |
Black-bellied Hummingbird Eupherusa nigriventris |
 b13/6/090 Black-bellied Hummingbird |
Snowcap Microchera albocoronata |
 b57/1/257 Snowcap |  b57/1/258 Snowcap |  m47/1/002 Snowcap |  m47/5/005 Snowcap |
|
Purple-crowned Fairy Heliothryx barroti |
 b57/1/203 Purple-crowned Fairy |
Garden Emerald Chlorostilbon assimilis |
 b57/1/108 Garden Emerald |
Violet-crowned Woodnymph Thalurania colombica |
 m47/5/008 Violet-crowned Woodnymph |  m47/5/008 Violet-crowned Woodnymph |  b57/1/288 Violet-crowned Woodnymph |  b57/1/289 Violet-crowned Woodnymph |
 m47/5/009 Violet-crowned Woodnymph |  m47/5/009 Violet-crowned Woodnymph |
Stripe-throated Hermit Phaethornis striigularis |
 b57/1/166 Stripe-throated Hermit |
Acorn Woodpecker Melanerpes formicivorus |
 b53/4/118 Acorn Woodpecker |
Black-cheeked Woodpecker Melanerpes pucherani |
 b57/1/048 Black-cheeked Woodpecker |  b57/1/047 Black-cheeked Woodpecker |
Golden-olive Woodpecker Piculus rubiginosus |
 b57/1/113 Golden-olive Woodpecker |
Brown Jay Cyanocorax morio |
 b57/1/068 Brown Jay |
Wing-barred Seedeater Sporophila americana |
 d01/31/241 Wing-barred Seedeater |  d01/31/243 Wing-barred Seedeater |  d01/31/244 Wing-barred Seedeater |
Yellow-faced Grassquit Tiaris olivaceus |
 d01/31/471 Yellow-faced Grassquit |  b57/1/323 Yellow-faced Grassquit |
Orange-billed Sparrow Arremon aurantiirostris |
 d01/32/030 Orange-billed Sparrow |
Black-headed Saltator Saltator atriceps |
 b57/1/055 Black-headed Saltator |
Buff-throated Saltator Saltator maximus |
 d01/32/308 Buff-throated Saltator |
Streak-breasted Treehunter Thripadectes rufobrunneus |
 d01/21/683 Streak-breasted Treehunter |
Chestnut-headed Oropendola Psarocolius wagleri |
 b57/1/080 Chestnut-headed Oropendola |  b57/1/079 Chestnut-headed Oropendola |
Montezuma Oropendola Psarocolius montezuma |
 b57/1/186 Montezuma Oropendola |  b57/1/187 Montezuma Oropendola |
Bronzed Cowbird Molothrus aeneus |
 b57/1/067 Bronzed Cowbird |
Chestnut-sided Warbler Setophaga pensylvanica |
 d01/27/184 Chestnut-sided Warbler |  d01/27/185 Chestnut-sided Warbler |
Rufous-capped Warbler Basileuterus rufifrons |
 d01/27/407 Rufous-capped Warbler |  d01/27/409 Rufous-capped Warbler |
White-lined Tanager Tachyphonus rufus |
 b57/1/300 White-lined Tanager |  b57/1/301 White-lined Tanager |
Crimson-collared Tanager Ramphocelus sanguinolentus |
 b57/1/098 Crimson-collared Tanager |
Passerini's Tanager Ramphocelus passerinii |
 d01/28/499 Passerini's Tanager |  d01/28/501 Passerini's Tanager |
Orange-billed Nightingale-Thrush Catharus aurantiirostris |
 d01/26/366 Orange-billed Nightingale-Thrush |
Black-headed Nightingale-Thrush Catharus mexicanus |
 m47/3/009 Black-headed Nightingale-Thrush |
White-ringed Flycatcher Conopias albovittatus |
 h02/22/003 White-ringed Flycatcher |
Tawny-chested Flycatcher Aphanotriccus capitalis |
 b57/1/277 Tawny-chested Flycatcher |
Yellow-olive Flycatcher Tolmomyias sulphurescens |
 d01/25/012 Yellow-olive Flycatcher |
Black-crowned Tityra Tityra inquisitor |
 b57/1/053 Black-crowned Tityra |
Yellow-throated Vireo Vireo flavifrons |
 d01/27/047 Yellow-throated Vireo |