查询活动 依照绑定门店,城市,其他随机排序
查询活动 按照绑定门店,城市,其他随机排序
"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";
"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";