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 Ptr.page_title=log_title AND Ptr.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=(SELECT lt_id FROM linktarget WHERE lt_namespace=10 AND tl_title="R_from_move")
WHERE log_type="move" AND log_action="move" AND log_timestamp BETWEEN "20240101" AND "20240102" AND log_namespace=0
LIMIT 10;

SQL

Checking query status...