SELECT e.id,e.date,e.people FROM
(SELECT id, s.date,
@sdate1 :=
(CASE
WHEN s.people >=100 THEN @sdate1
ELSE @sdate1 + 1
END) AS sdate,s.people FROM stadium as s,(SELECT @sdate1 := 0) as b) as e,
(SELECT c.sdate FROM (SELECT id,s.date,
@sdate :=
(CASE
WHEN s.people >= 100 THEN @sdate
ELSE @sdate + 1 END) AS sdate,
s.people FROM stadium as s,(SELECT @sdate := 0) as b) as c WHERE c.people >= 100
GROUP BY c.sdate HAVING COUNT(c.sdate) >=4) as d
WHERE d.sdate = e.sdate
AND e.people >= 100
