[SQL Error: 1054] Unknown column 'sp_xianjia' in 'order clause'

SELECT * from ib_sp where (1) and sp_lo='seungwoo-tour' and sp_shangjia='판매' and mid(sp_fl_code,1,(2*1))='02' order by cast(sp_xianjia as unsigned) desc, sp_fl_code asc, sp_id desc limit 0, 15