User contribs in archive

SQL

SET @json_document = '[
    { "id": 0, "namespace": ":"},
    { "id": 1, "namespace": "Talk:"},
    { "id": 2, "namespace": "User:"},
    { "id": 3, "namespace": "User talk:"},
    { "id": 4, "namespace": "Wikipedia:"},
    { "id": 5, "namespace": "Wikipedia Talk:"},
    { "id": 6, "namespace": "File:"},
    { "id": 7, "namespace": "File talk:"},
    { "id": 8, "namespace": "MediaWiki:"}, 
    { "id": 9, "namespace": "MediaWiki talk:"}, 
    { "id": 10, "namespace": "Template:"},
    { "id": 11, "namespace": "Template talk:"},
    { "id": 12, "namespace": "Help:"},
    { "id": 13, "namespace": "Help talk:"},
    { "id": 14, "namespace": "Category:"},
    { "id": 15, "namespace": "Category talk:"}
]';

SET @USER_ID = 82697; # 48,559,210 (x); 82,697 (Bri)

select UNIQUE ar_title as title, ar_namespace as namespace, user.user_name from archive,
select namespace from (SELECT id,namespace FROM JSON_TABLE(@json_document, '$[*]'
    COLUMNS (
    id INT PATH '$.id', 
    namespace VARCHAR(50) PATH '$.namespace'
    )
 )) as a
join actor on actor.actor_id = archive.ar_actor
join user on user.user_id = actor.actor_user
where 
user_id=@USER_ID 
limit 50



# SELECT * FROM JSON_TABLE(@json_document, '$[*]'
#    COLUMNS (
#    id INT PATH '$.id', 
#    namespace VARCHAR(50) PATH '$.namespace'
#    )
# ) AS json_table;
SQL

Checking query status...
