Find the first id
of the 3 consecutive movies then use the result m1.id
as another table and fetch records whose id is between m1.id
and m1.id+2
SELECT
m1.id
FROM
movie m1,
movie m2,
movie m3
WHERE
m1.id = m2.id-1
AND m2.id = m3.id-1
AND m1.status = m2.status
AND m2.status = m3.status
;