article creations for a given user

SQL

SELECT article.page_title
FROM page AS article
INNER JOIN revision ON revision.rev_page = article.page_id
JOIN actor ON  revision.rev_actor = actor.actor_id
WHERE actor.actor_name= 'Vexations'
AND revision.rev_parent_id = 0
AND revision.rev_timestamp > 20211201000000
AND article.page_namespace = 0
AND article.page_is_redirect = 0
#AND article.page_title NOT IN (
#  SELECT page_title FROM page  INNER JOIN templatelinks ON page_id = tl_from 
#  INNER JOIN revision_userindex ON rev_page = page_id 
#  WHERE rev_user_text = 'Vexations' 
#  AND rev_parent_id = 0 AND page_namespace = 0 
#  AND tl_namespace = 10 AND page_is_redirect = 0 
#  AND LOWER(tl_title)  IN  ('disambig', 'disambiguation', 'hndis')
#)
LIMIT 10
SQL

Checking query status...
