You are browsing a read-only backup copy of Wikitech. The primary site can be found at

Obsolete:Tool:Query service/9

From Wikitech-static
< Obsolete:Tool:Query service
Revision as of 19:10, 4 September 2021 by imported>Quiddity (fixes)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Approximate run time several minutes


    case when page_namespace = 2 then 'User:' else 'User talk:' end,
    ']]') 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