User contribs in archive

SQL

SET @USER_ID = 82697; # 48,559,210 (x); 82,697 (Bri)
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:"}
]';

select UNIQUE ar_title as title, ar_namespace as namespace, user.user_name from archive, user, actor,

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

where archive.ar_actor = actor.actor_id
and actor.actor_user = user.user_id
and user_id=@USER_ID 
and a.id = ar_namespace
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...
