Redirects from move not tagged with {{R from move}}

SQL

SELECT log_title AS old_title, Pa.page_title AS new_title
/* REGEXP_REPLACE(log_params, ".*::target\";s:\\d=+:\"([^\"]+)\";s:.*", "$1") */
FROM logging
JOIN page Pa ON Pa.page_id=log_page
JOIN page Pr ON Pr.page_title=log_title AND Pr.page_namespace=0
JOIN redirect ON rd_from=Pr.page_id AND rd_namespace=0 AND rd_title=Pa.page_title
LEFT JOIN templatelinks ON tl_from=Pr.page_id AND tl_target_id=(SELECT lt_id FROM linktarget WHERE lt_namespace=10 AND lt_title="R_from_move")
WHERE log_type="move" AND log_action="move" AND log_timestamp BETWEEN "20240101" AND "20250101" AND log_namespace=0
AND tl_from IS NULL

SQL

Checking query status...