MySQL Query : SELECT a.id,a.title,a.style,a.thumb,a.start,a.price,a.discount,a.address,a.inputtime,a.isok,a.ishot,a.istop,a.ischeap,a.isfirst,a.isfast,a.hits,'price1' AS code FROM shiyan_scenery AS a WHERE a.isok='0' AND a.`town_id`=420301 ORDER BY b.discount ASC,a.id DESC LIMIT 0,10
MySQL Error : Unknown column 'b.discount' in 'order clause'
MySQL Errno : 1054
Message : Unknown column 'b.discount' in 'order clause'