SQL CTE Solution: Identifying Soft Deletes with Consecutive Row Changes

Using Correlated Subquery to Simulate LAG(...) IGNORE NULLS OVER (ORDER BY...) in MariaDB