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,'price2' AS code FROM shiyan_scenery AS a WHERE a.isok='0' ORDER BY b.discount DESC,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'