Obsolete:Tool:Query service/9

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