Fork of Untitled query #9443 by Sfan00 IMG
This query is marked as a draft This query has been published by ShakespeareFan00.

SQL

AخA
 
SELECT page_id, CONCAT('File:',page_title) as page_title,
                   (    SELECT COUNT(*)
                        FROM imagelinks
                        WHERE il_to = page_title
                   ) AS imagelinks         
                   FROM page
                   WHERE page_namespace = 6
                   AND page_is_redirect = 1
                   HAVING imagelinks > 1
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...