查询活动 按照绑定门店，城市，其他随机排序

"select m.*,s.FCity from TuMemberActivity as m INNER join TuStore as s on m.FStoreId=s.FId "
+ "where FActivityStatus='2' order by case when m.FStoreId=? then 0 when s.FCity=? then 1 else 2 end ,FCreateTime DESC";