SELECT hakone_spot.id,detail,name,description,tab,area,genre,title,charge,tag,sub_thumbnail FROM hakone_spot INNER JOIN hakone_ranking ON hakone_spot.id = hakone_ranking.id WHERE publish = 1 AND tag LIKE "%,箱根,%" AND tag LIKE "%,芦ノ湖,%" AND tag LIKE "%,グルメ,%" AND tag LIKE "%,レイクビュー,%" ORDER BY レイクビュー+レイクビュー DESC, hakone_spot.id ASC LIMIT 0,10 [nativecode=1054 ** Unknown column 'レイクビュー' in 'order clause']