Obsolete:Tool:Query service/9

From Wikitech
Jump to navigation Jump to search

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