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: SVG images in Commons category "Translation possible - SVG (switch)" translated in French used on French Wikipedia - possibly there are images translated into French on the French Wikipedia used without the parameter lang=fr when the image is used and then this parameter could be added. fr: Images SVG dans la catégorie Commons "Translation possible - SVG (switch)" traduites en français utilisées sur la Wikipédia en français - il est possible qu’il y ait des images traduites en français qui sont soient utilisées sur la Wikipédia en français sans le paramètre lang=fr lors de l’utilisation de l’image et ce paramètre pourrait être ajouté.
Toggle Highlighting
SQL
USE commonswiki_p; SELECT DISTINCT page_title, gil_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_id NOT IN ( 2818907,66104037,4608036,2343786,16014755,34324124,2334342,65202522,38543331,36237771,64481505,40215907,1763926,34506446,34534313,38442373,10514170,3114883,1072961,34642130,35219648,65243110,59624145,67635660,865714,4597965,68359128,12009211,60314249,18556148,17627298,1472235,42003439,37980484,43939580,68323103,34702390,68158203,48182340,34877594,60160367,51671295,39931747,26895328,22542942,2527541,10874222,73462787,46233629,6388056,34722971,13284004,41136454,42163361,42408916,42163360,42163359,42924402,45695793,43263274,43281909,37911088,37264722,37461090,2614970,24696016,44069661,44309401,41956737,68824974,63995775,35907128,42402715,42284035,32222280,37292688,37285306,37321419,45155851,72021662,37075793,37268736,8991964,10868614,24363898,30159916,33290913,2258763,37225471,51671296,33551412,38549630,38547498,68430438,34834176,34834173,37089758,37962078,33898705,58416321,36728275,38535781,65198542,2345768,60447073,27876962,60398043,38255428,37239478,30437540,11459233,34615524,40589663,27837560,34936025,33653810,37883927,32031787,36633703,65350751,39917431,63501649,46411509,38306669,14939155,36737065,10242751,46542131,31103602,36262518,52813193,29233362,42469954,18619977,3941719,63454374,37957611,49027736,34552039,39183625,12851594,60073247,10287551,48544618,68418372,18587930,40387656,60251819,69873468,52035509,15500578,36832781,4809738,65261516,34826656,37088511,35868722,34167653,1514245,24951796,36688109,7408455,26758112,37193359,47791861,865422,36618195,37075345,27853839,60288837 ); -- SELECT DISTINCT page_id -- 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...