trwiki:Pages created by new users in last day

Fork of trwiki:Pages created by new users by Evolutionoftheuniverse

This query is marked as a draft This query has been published by Evolutionoftheuniverse.

SQL

USE trwiki_p;
SELECT page.page_namespace,page.page_title, rev_timestamp,rev_user_text,user_editcount
FROM page
LEFT JOIN revision
ON rev_page = page.page_id
LEFT JOIN user
ON rev_user_text=user_name
WHERE page.page_id IN (
    SELECT revision_userindex.rev_page 
  FROM revision_userindex 
  WHERE revision_userindex.rev_user_text IN (SELECT user_name
	FROM user
	WHERE #user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 DAY),'20000101000000')
	#AND 
    user_editcount = 1
	AND user_id NOT IN (SELECT ug_user FROM trwiki_p.user_groups WHERE ug_group = 'bot')
	order by user_editcount desc)
  AND revision_userindex.rev_parent_id=0
)
AND rev_parent_id = 0
AND rev_timestamp = DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 DAY)
group by page_title
order by rev_timestamp desc;

SQL

Checking query status...