Paste P43151

2022 articles created query.sql
ActivePublic
Actions

Authored by Legoktm on Jan 13 2023, 2:23 AM.

Tags

None

Referenced Files

	F36175389: 2022 articles created query.sql
	Jan 13 2023, 2:23 AM

Subscribers

None

	select
	log_title,
	log_timestamp,
	user_registration
	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 "2022%"
	and (
	page_is_redirect = 0
	or page_is_redirect is null
	);

Event Timeline

Legoktm created this paste.Jan 13 2023, 2:23 AM