Links to redirecting image in frwiki

This query is marked as a draft This query has been published by Wurgl.

SQL

SELECT Redir.page_title AS "Redirect Image", Image.page_title as "Image", gil_page_namespace as "Namespace", gil_page_title as "Article"
  FROM page as Redir, redirect, page as Image, globalimagelinks
 WHERE Redir.page_is_redirect = 1
   AND Redir.page_namespace = 6
   AND rd_from = Redir.page_id
   AND Image.page_title = rd_title
   AND Image.page_namespace = rd_namespace
   AND gil_to = Redir.page_title
   AND gil_wiki = 'frwiki'
   AND gil_page_namespace_id = 0 /* Just article-namespace in frwiki */
LIMIT 10;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...