New articles in nowiki, 2022

SQL

select
	  log_title,
	  log_timestamp,
	  user_registration,
      page_id,
      actor_id
	from
	  logging_userindex
	  join actor_logging on log_actor = actor_id
	  join user on actor_user = user_id
	  left join page on log_page = page_id
	where
	  log_action = "create"
	  and log_type = "create"
	  and log_namespace = 0
	  and log_timestamp like "2023%"
      #and user_registration like "2023%"
      and UNIX_TIMESTAMP(log_timestamp) - UNIX_TIMESTAMP(user_registration) < 60*60*24*90
      #and page_id
	  and (
	    page_is_redirect = 0
	    or page_is_redirect is null
	  );
SQL

Checking query status...
