Untitled query #26447

SQL

USE dewiki_p;
SELECT DISTINCT p.page_title
FROM page p
INNER JOIN revision_userindex rv ON rv.rev_page = p.page_id
LEFT JOIN (page pd, categorylinks clpd) ON (p.page_title = pd.page_title AND clpd.cl_from = pd.page_id AND pd.page_namespace = 1)
LEFT JOIN categorylinks clp ON clp.cl_from = p.page_id
WHERE rv.rev_user_text = "Ermanno da Baskerville"
AND rv.rev_parent_id = 0
AND p.page_namespace = 0
AND p.page_is_redirect = 0
AND (clp.cl_to REGEXP "Wikipedia\:(Defekte\_Weblinks\/Ungeprüfte\_Botmarkierungen.*|Weblink\_offline)" OR clpd.cl_to = "Wikipedia:Defekte_Weblinks/Bot")
ORDER BY p.page_title
SQL

Checking query status...
