papwiki Use of Babel user templates

SQL

SELECT page_namespace AS ns, page_title, actor_name
FROM page, revision, actor
WHERE
	page_namespace=10 AND
    page_title NOT REGEXP '^User_blank' AND
    page_title REGEXP '^User_' AND
    page_id=rev_page AND
    rev_parent_id=0 AND
	rev_actor=actor_id
;
SELECT page_namespace AS ns, page_title, GROUP_CONCAT(lt_title SEPARATOR ', ') AS templates
FROM templatelinks, linktarget, page
WHERE tl_target_id=lt_id AND lt_namespace=10 AND lt_title NOT REGEXP '^User_blank' AND lt_title REGEXP '^User_' AND tl_from=page_id
GROUP BY page_namespace, page_title

SQL

Checking query status...