Invalid query: Unknown column 'see_prod' in 'order clause' Whole query: select * from c_loan_view WHERE active='1' order by see_prod desc, date_update desc limit 10 offset 0