papwiki Use of Babel user templates

SQL

SELECT page_title, rev_timestamp AS created, actor_name AS creator
FROM page, revision, actor
WHERE
	page_namespace=10 AND
    page_title NOT REGEXP '^User_(blank|info)' AND
    page_title REGEXP '^User_[a-z]' 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_[a-z]' AND tl_from=page_id
GROUP BY page_namespace, page_title
SQL

Checking query status...
