select firstname, lastname from users where email = '' 

COUNT:select count(*) from webflatfile  where  country_state LIKE '%Canada% New% Brunswick%' 

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 '%Canada% New% Brunswick%' 

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 '%Canada% New% Brunswick%' order by spcode, comname, rating DESC LIMIT 100