Pages salted by a named user

Omits namespace for articles, adds leading colon for categories.
Dresses the namespace & title as a usable link
Export the result as a wiki table & it's good-to-go

SQL

SELECT CONCAT('[[', pt.pt_title, ']]'), pt.pt_create_perm
FROM   protected_titles pt, user u
WHERE  pt.pt_user = u.user_id
AND    u.user_name = 'Cabayi'
AND    pt_namespace = 0
UNION
SELECT CONCAT('[[:{{ns:', CAST(pt.pt_namespace AS CHAR), '}}:', pt.pt_title, ']]'), pt.pt_create_perm
FROM   protected_titles pt, user u
WHERE  pt.pt_user = u.user_id
AND    u.user_name = 'Cabayi'
AND    pt_namespace = 14
UNION
SELECT CONCAT('[[{{ns:', CAST(pt.pt_namespace AS CHAR), '}}:', pt.pt_title, ']]'), pt.pt_create_perm
FROM   protected_titles pt, user u
WHERE  pt.pt_user = u.user_id
AND    u.user_name = 'Cabayi'
AND    pt_namespace != 0
AND    pt_namespace != 14
order by 2

SQL

Checking query status...