Obsolete:Tool:Query service/9

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This page contains historical information. It may be outdated or unreliable.

Temporary Wikipedian userpages

Description	List of en:Category:Temporary Wikipedian userpages
Assignee	Misza13
JIRA bug	DBQ-9
Source	Query service/Temporary Wikipedian userpages#Query
Results	http://tools.wikimedia.de/~misza13/cat_temp.txt
Approximate run time	several minutes
Interval

Query

select
  concat(
    '[[',
    case when page_namespace = 2 then 'User:' else 'User talk:' end,
    page_title,
    ']]') as page_title

from page

join revision
  on rev_id = page_latest

join categorylinks
  on cl_from = page_id

where page_namespace in (2,3)
  and cl_to = 'Temporary_Wikipedian_userpages'
  and datediff(now(),rev_timestamp) > 30

This page was moved from toolserver:en:Query service/9. It's edit history can be viewed at Nova Resource:Tools/Tools/Query service/9/edithistory