select firstname, lastname from users where email = '' 

COUNT:select count(*) from species_list as sp left join webflatfile on webflatfile.spcode = sp.spcode  where  (sp.COMNAME LIKE "Harlequin Duck" or sp.COMNAME LIKE "%Harlequin Duck%") AND webflatfile.VCODE LIKE "w02%"

select webflatfileid, webflatfile.comname, webflatfile.sciname, webflatfile.vcode, rating, Day, height, width, webflatfile.spcode, photodata, country_state, locality, age, sex, month, dname, comments from species_list as sp left join webflatfile on webflatfile.spcode = sp.spcode left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND  (sp.COMNAME LIKE "Harlequin Duck" or sp.COMNAME LIKE "%Harlequin Duck%") AND webflatfile.VCODE LIKE "w02%"

select webflatfileid, webflatfile.comname, webflatfile.sciname, webflatfile.vcode, rating, Day, height, width, webflatfile.spcode, photodata, country_state, locality, age, sex, month, dname, comments from species_list as sp left join webflatfile on webflatfile.spcode = sp.spcode left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND  (sp.COMNAME LIKE "Harlequin Duck" or sp.COMNAME LIKE "%Harlequin Duck%") AND webflatfile.VCODE LIKE "w02%"order by spcode, comname, rating DESC LIMIT 100