SELECT kyoto_spot.id,detail,name,description,tab,area,genre,title,charge,tag,sub_thumbnail FROM kyoto_spot INNER JOIN kyoto_ranking ON kyoto_spot.id = kyoto_ranking.id WHERE publish = 1 AND tag LIKE "%,京都,%" AND tag LIKE "%,四条河原町,%" AND tag LIKE "%,京都市役所前,%" AND tag LIKE "%,グルメ,%" AND tag LIKE "%,スイーツ,%" AND tag LIKE "%,ドーナツ,%" ORDER BY ドーナツ+ドーナツ DESC, kyoto_spot.id ASC LIMIT 0,10 [nativecode=1054 ** Unknown column 'ドーナツ' in 'order clause']