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

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

"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";