This issue was converted from https://jira.toolserver.org/browse/DBQ-34.
Summary: IP discussion pages on it.wiki
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)
From: Incola <diegmonti@gmail.com>
Date: Thu, 31 Jul 2008 10:07:25
On it.wiki we need a list of the IP discussion pages, for insert a template with a bot, but there isn't a dump available.
That is the query:
SELECT CONCAT( "# [[Discussioni_utente:", page_title, "]]" )
FROM page
LEFT JOIN revision ON page_latest = rev_id
WHERE page_namespace = 3
AND page_title REGEXP '^[[:digit:]]{1,3}([.][[:digit:]]{1,3}){3}$'
AND rev_timestamp < '20080701000000'
AND page_id NOT IN (
SELECT cl_from
FROM categorylinks
WHERE cl_to = 'IP_NOTI'
OR cl_to = 'Vandali_recidivi'
OR cl_to = 'Open_proxy'
OR cl_to = 'TOR_exit_node')
AND page_id NOT IN (
SELECT tl_from
FROM templatelinks
WHERE tl_title = 'BenvenutoIP')
ORDER BY rev_timestamp;Thank you.
Version: unspecified
Severity: major