Fork of Untitled query #30597 by SQL
This query is marked as a draft This query has been published by SQL.

SQL

AخA
 
SELECT rd_title          AS new, 
       rev_timestamp as timestamp, 
       source.page_title AS source
FROM   redirect 
       JOIN page AS target 
         ON page_title = rd_title 
            AND page_namespace = rd_namespace 
       JOIN page AS source 
         ON source.page_id = rd_from 
       JOIN revision 
         ON rev_id = target.page_latest 
WHERE  rd_title LIKE "%/%.js" 
       AND rd_namespace = 2 
order by timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...