PageHelper插件实现一对多查询时的分页问题

  
    ....



  
    
    
  



  
  
  
  
  
  
    
    
  



  
  

  select id pt_id, title pt_title
  from t_activity_template where is_delete=0 and activity_id = #{id}
  order by sort_number desc


  SELECT t.*,t1.real_name creator_name
  FROM t_activity t
  left join user t1 on t1.user_id = t.creator
  
    t.is_delete = 0
    AND (t.activity_name like concat("%",#{criteria},"%"))
  
  ORDER BY t.id desc

  SELECT t.*, t6.id pt_id, t1.title pt_title
  FROM t_activity t
  left join t_activity_template t1 on t.id=t6.activity_id and t1.is_delete=0
  WHERE t.is_delete = 0 AND t.id = #{id}