when searching for records to view with mysql

backend, search failed because the column aliases aren't working in the WHERE clause (possibly a DBD::mysql issue).

worked around by not using column aliases in WHERE clause