https://bugzilla.wikimedia.org/show_bug.cgi?id=59290

       Web browser: ---
            Bug ID: 59290
           Summary: DBQ-34 IP discussion pages on it.wiki
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
          Assignee: wmf.bugconver...@gmail.com
          Reporter: wmf.bugconver...@gmail.com
    Classification: Unclassified
   Mobile Platform: ---

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 <diegmo...@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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to