SVG images translated in French used on frwiki

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é.

SQL

USE commonswiki_p;
SELECT DISTINCT COUNT(*) -- 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_title = gil_to
    AND gil_wiki = 'frwiki'
    AND gil_page_namespace_id = 0;
--    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.

SQL

Checking query status...