79323261

Date: 2025-01-02 09:20:02
Score: 0.5
Natty:
Report link

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
;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Zhiqiang Guo