trwiki:Pages created by new users in last thirty days

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_SUB(NOW(),INTERVAL 30 DAY)
group by page_title
order by rev_timestamp desc;

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 < 150 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_SUB(NOW(),INTERVAL 30 DAY)
group by page_title
order by rev_timestamp desc;
SQL

Checking query status...
