Запрос на ротацию записи

mysql> SELECT * FROM test;
+------+------+----------+--------+
| id   | name | text     | active |
+------+------+----------+--------+
|    1 |      | 0        |        |
|    2 |      | txt txt2 |        |
|    3 |      | txt txt2 | yes    |
|    4 |      | 0        |        |
|    5 |      | txt txt2 |        |
|    6 |      | txt txt2 |        |
+------+------+----------+--------+

SELECT  t1.id AS currentActiveId, t2.id AS nextActiveId, t3.id AS firstActiveId FROM test t1
LEFT JOIN test t2
ON (t1.id < t2.id AND t2.text <> '0')
LEFT JOIN test t3
ON (t1.id > t3.id AND t3.text <> '0' )
 
WHERE 
t1.active = 'yes'
ORDER BY t2.id, t3.id LIMIT 1;
 
+-----------------+--------------+---------------+
| currentActiveId | nextActiveId | firstActiveId |
+-----------------+--------------+---------------+
|               3 |            5 |             2 |
+-----------------+--------------+---------------+

WITH update_cte AS (
SELECT  t1.id AS currentActiveId, t2.id AS nextActiveId, t3.id AS firstActiveId FROM test t1
LEFT JOIN test t2
ON (t1.id < t2.id AND t2.text <> '0')
LEFT JOIN test t3
ON (t1.id > t3.id AND t3.text <> '0' )
 
WHERE 
t1.active = 'yes'
ORDER BY t2.id, t3.id LIMIT 1
)
 
UPDATE update_cte 
JOIN test 
ON update_cte.currentActiveId = test.id OR test.id = IFNULL(update_cte.nextActiveId, update_cte.firstActiveId)
SET STATUS = IF(STATUS = 'active', '', 'active');

WHERE t1.active = 'yes'   AND t2.id NOT IN (14,15)