Interwiki links to be fixed on arwiki pointing to cat pages on Commons

Fork of Bad links from wikis to Commons: redirects by Achim55

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

(SELECT dep.page_namespace, dep.page_title, deiwl.iwl_title FROM arwiki_p.iwlinks deiwl
INNER JOIN arwiki_p.page dep ON dep.page_id = deiwl.iwl_from
WHERE deiwl.iwl_prefix ='commons'
AND deiwl.iwl_title = 'Category:')
UNION
(SELECT dep.page_namespace, dep.page_title, deiwl.iwl_title FROM arwiki_p.iwlinks deiwl
INNER JOIN arwiki_p.page dep ON dep.page_id = deiwl.iwl_from
INNER JOIN commonswiki_p.page cop ON CONCAT('Category:',cop.page_title) = deiwl.iwl_title
WHERE deiwl.iwl_prefix ='commons'
AND deiwl.iwl_title LIKE 'Category:%'
AND cop.page_namespace = 14
AND cop.page_is_redirect = 1)
ORDER BY page_namespace, page_title;

SQL

Checking query status...