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