在mysql中查询两个日期之间最大的连续登录天数的方法

SELECT *
FROM (SELECT *
  FROM (
    SELECT
    uid,
    max(days)  lianxu_days,
    min(login_day) start_date,
    max(login_day) end_date
    FROM (SELECT
      uid,
      @cont_day :=
      (CASE
      WHEN (@last_uid = uid AND DATEDIFF(created_ts, @last_dt) = 1)
      THEN
       (@cont_day + 1)
      WHEN (@last_uid = uid AND DATEDIFF(created_ts, @last_dt) < 1)
      THEN
       (@cont_day + 0)
      ELSE
      1
      END)            AS days,
      (@cont_ix := (@cont_ix + IF(@cont_day = 1, 1, 0))) AS cont_ix,
      @last_uid := uid,
      @last_dt := created_ts        login_day
     FROM (SELECT
       uid,
       DATE(created_ts) created_ts
       FROM plan_stage
       WHERE uid != 0
       ORDER BY uid, created_ts) AS t,
      (SELECT
      @last_uid := '',
      @last_dt := '',
      @cont_ix := 0,
      @cont_day := 0) AS t1
     ) AS t2
    GROUP BY uid, cont_ix
    HAVING lianxu_days > 10
   ) tmp
  ORDER BY lianxu_days DESC) ntmp
GROUP BY uid;