Wikipedia:Bot requests: Difference between revisions - Wikipedia

Line 310:

</source>[[User_talk:Josh Parris|Josh Parris]] 03:44, 8 February 2012 (UTC)

:*I can't read code. Which intervals did you use? <span style="color:green">'''Ten Pound Hammer'''</span> • ^{([[User talk:TenPoundHammer|What did I screw up now?]])} 03:13, 8 February 2012 (UTC)

::I used 4 years. I re-ran the query to give a timestamp of last edit for each result. The results are [http://en.wikipedia.org/w/index.php?title=User:Tim1357/sandbox&oldid=475700310 here] and the updated code is below.[[User:Tim1357|<font color="Blue" face="Arial" >Tim]]</font><font color="Red" face="Optima" >[[Special:Contributions/Tim1357|1357]]</font> ^{<font face="Times new roman" size = 2 >[[User talk:Tim1357|talk]]</font>} 04:04, 8 February 2012 (UTC)

::P.S. I got to the end and figured that out, Josh Paris. Thanks anyways though. {{=)}} [[User:Tim1357|<font color="Blue" face="Arial" >Tim]]</font><font color="Red" face="Optima" >[[Special:Contributions/Tim1357|1357]]</font> ^{<font face="Times new roman" size = 2 >[[User talk:Tim1357|talk]]</font>} 04:05, 8 February 2012 (UTC)

{{collapsetop|New SQL}}

<source lang="SQL">

SELECT Concat(Concat('|[[', REPLACE(page_title, '_', ' ')), ']]||') AS t,

TIMESTAMP((SELECT rev_timestamp

FROM revision

WHERE rev_id = page_latest)) AS ts

FROM page

WHERE page_is_redirect = 0

AND page_namespace = 0

AND page_latest < (SELECT rev_id

FROM revision

WHERE rev_timestamp > Date_format(DATE_SUB(NOW(),

INTERVAL 4 YEAR),

'%Y%m%d%H%i%s')

LIMIT 1)

AND NOT EXISTS (SELECT 1

FROM categorylinks

WHERE cl_to = 'All_article_disambiguation_pages'

AND cl_from = page_id);

</source>

{{collapsebottom}}

== Red link syntax removal ==