select firstname, lastname from users where email = ''
COUNT:select count(*) from webflatfile where country_state LIKE '%Bismark% Archipelago,% New% Britain% Is%'
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 '%Bismark% Archipelago,% New% Britain% Is%'
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 '%Bismark% Archipelago,% New% Britain% Is%' order by spcode, comname, rating DESC LIMIT 100
Login to view larger versions of VIREO images or to place an order. |
Red-knobbed Imperial Pigeon Ducula rubricera | |||
b59/3/001 Red-knobbed Imperial Pigeon | |||
Forest Kingfisher Todirhamphus macleayii | |||
b59/3/002 Forest Kingfisher |