Articles created during Wikimarathon 2023 w/o Wikimarathon template

SQL

SELECT P1.page_title, A.actor_name
FROM ukwiki_p.revision R
 JOIN ukwiki_p.page P1 ON R.rev_page = P1.page_id
 JOIN ukwiki_p.actor A ON R.rev_actor = A.actor_id
WHERE R.rev_parent_id = 0
 AND P1.page_namespace = 0
 AND P1.page_is_redirect = 0
 AND R.rev_timestamp >= 20230126000000
 AND R.rev_timestamp <  20230206000000
 AND P1.page_title NOT IN 
(SELECT P1.page_title
FROM ukwiki_p.revision R
 JOIN ukwiki_p.page P1 ON R.rev_page = P1.page_id
 JOIN ukwiki_p.page P2 ON P1.page_title = P2.page_title
 JOIN ukwiki_p.categorylinks CL ON P2.page_id = CL.cl_from
WHERE R.rev_parent_id = 0
 AND P1.page_namespace = 0
 AND P2.page_namespace = 1
 AND CL.cl_to = "Статті_Вікімарафону_2023"
 AND R.rev_timestamp >= 20230126000000
 AND R.rev_timestamp <  20230205000000)

SQL

Checking query status...