select * from answers where rank >= 0 order by rank asc select * from answers where rank < 0 order by rank desc select count(answeridfk) as total from #application.settings.tableprefix#results where answeridfk = and itemidfk =