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

SET SQL_MODE=ORACLE

SELECT decode (pt.pt_namespace,
-2, "Media",
-1, "Special",
0, "mainspace",
1, "Talk",
2, "User",
3, "User talk",
4, "Wikipedia",
5, "Wikipedia talk",
6, "File",
7, "File talk",
8, "MediaWiki",
9, "MediaWiki talk",
10, "Template",
11, "Template talk",
12, "Help",
13, "Help talk",
14, "Category",
15, "Category talk",
100, "Portal",
101, "Portal talk",
108, "Book",
109, "Book talk",
118, "Draft",
119, "Draft talk",
446, "Education Program",
447, "Education Program talk",
710, "Timed Text",
711, "Timed Text talk",
828, "Module",
829, "Module talk",
2300, "Gadget",
2301, "Gadget talk",
2302, "Gadget definition",
2303, "Gadget definition talk",
"???")
from   protected_titles pt, user u
where  pt.pt_user = u.user_id
and    u.user_name = 'Cabayi'

SQL

Checking query status...