"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";
+ "where FActivityStatus='2' order by case when m.FStoreId=? then 0 when s.FCity=? then 1 else 2 end ,FCreateTime DESC";