Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Seb35
.
en: these SVG images are translated in French using the switch method, but unused on the French Wikipedia, hence possibly they could be added in some article. fr: ces images SVG sont traduites en français en utilisant la méthode de switch, mais ne sont pas utilisées sur la Wikipédia en français, il est donc possible de les ajouter sur certains articles.
Toggle Highlighting
SQL
USE commonswiki_p; -- SELECT * -- FROM categorylinks, page, image -- WHERE cl_type = 'file' -- AND cl_to = 'Translation_possible_-_SVG_(switch)' -- AND cl_from = page_id -- AND page_title = img_name -- AND img_metadata LIKE '%s:2:"fr"%' -- LIMIT 10; SELECT DISTINCT page_title FROM categorylinks, page, image, globalimagelinks WHERE cl_type = 'file' AND cl_to = 'Translation_possible_-_SVG_(switch)' AND cl_from = page_id AND page_title = img_name AND img_metadata LIKE '%s:2:"fr"%'; AND page_title = gil_to AND gil_wiki = 'frwiki' AND gil_page_namespace_id = 0;
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
.
Checking query status...