SQL
x
SET @uname = 'Cabayi' ;
SELECT CONCAT('[[', IF (pt.pt_namespace=6,':',IF (pt.pt_namespace=14,':','')), '{{ns:', CAST(pt.pt_namespace AS CHAR), '}}:', pt.pt_title, ']]') page,
pt.pt_create_perm 'protection level'
FROM protected_titles pt, user u
WHERE pt.pt_user = u.user_id
AND u.user_name = @uname
ORDER BY 2, 1
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.