Untitled query #25816

SQL

USE dewiki_p;
SELECT p.page_title
FROM page p
INNER JOIN revision_userindex rv ON rv.rev_page = p.page_id
LEFT JOIN page pd ON p.page_title = pd.page_title
LEFT JOIN categorylinks clp ON clp.cl_from = p.page_id
LEFT JOIN categorylinks clpd ON clpd.cl_from = pd.page_id
WHERE rv.rev_user_text = "ErdbärMitSahne"
AND rv.rev_parent_id = 0
AND p.page_namespace = 0
AND pd.page_namespace = 1
AND p.page_is_redirect = 0
AND (clp.cl_to RLIKE "Wikipedia\:Defekte_Weblinks/.+" OR clpd.cl_to = "Wikipedia:Defekte_Weblinks/Bot")
SQL

Checking query status...
