Wikimedia:Sandbox: Difference between revisions

Edit links
From Wikimedia Foundation Governance Wiki
Browse history interactively
← Older edit
Content deleted Content added
VisualWikitext
MZMcBride (talk | contribs)
4,081 edits
all right
m Testing T338023
 
(22 intermediate revisions by 4 users not shown)
Line 1: Line 1:
foo
<source lang="sql">
SELECT
il1.il_to,
COUNT(*)
FROM page
JOIN imagelinks AS il1
ON il1.il_from = page_id
JOIN imagelinks AS il2
ON il1.il_to = il2.il_to
WHERE page_namespace = 10
AND page_title = 'Staff_and_contractors'
GROUP BY il1.il_to
ORDER BY COUNT(*) ASC;
</source>
<pre>
+---------------------------------------------------------------------+----------+
| il_to | COUNT(*) |
+---------------------------------------------------------------------+----------+
| Santhosh_Thottingal.jpg | 24 |
| Ava_Miller_March_2013.jpg | 24 |
| Jami_Mathewson_staff_pic-1.jpg | 24 |
| 03_Chris_McMahon_-_Wikimedia_Foundation_04.jpg | 24 |
| Gabriel_Wicke_013_-_Berlin_2012.jpg | 24 |
| Benny_Situ_staff_photo.jpg | 24 |
| Diederik_van_Liere_07_-_Wikimania_2011.jpg | 24 |
| Katy_Love_March_2013.jpg | 24 |
| Matt_Walker.jpg | 24 |
| Brad_Jorsch-3.jpg | 24 |
| Jeff_Green_008_-_Berlin_2012.jpg | 24 |
| 07_Joady_Lohr_-_Wikimedia_Foundation_21.jpg | 24 |
| Doreen_Dunican_March_2013.jpg | 24 |
| Robert_Miller_March_2013.jpg | 24 |
| Anasuya_Sengupta_March_2013.jpg | 24 |
| Matthew_Roth_March_2013.jpg | 24 |
| Pau_Giner.jpg | 24 |
| Rory_Tiger_7.jpg | 24 |
| Andrew_Bogott_staff_photo.jpg | 24 |
| Geoff_Brigham_1.jpg | 24 |
| Matthias_Mullie_001_-_Berlin_2012.jpg | 24 |
| Jon_Robson_006_-_Berlin_2012.jpg | 24 |
| Andrew_Garrett_Wikimedia_Foundation.jpg | 24 |
| Megumi_Yukie_March_2013.jpg | 24 |
| Antoine_Musso-3500.jpg | 24 |
| CT_Woo_staff_photo.jpg | 24 |
| Peter_Youngmeister_012_-_Berlin_2012.jpg | 24 |
| 15_Christine_Bocknek_-_Wikimedia_Foundation_01.jpg | 24 |
| Ian_Poirier_March_2013.jpg | 24 |
| Chad_Horohoe_Wikimedia_Foundation-9063.jpeg | 24 |
| Praveena_Maharaj.jpg | 24 |
| 16_Oliver_Keyes_-_Wikimedia_Foundation_016.jpg | 24 |
| Faidon_Liambotis.jpg | 24 |
| Ion_Vazquez_March_2013.jpg | 24 |
| Quim_Gil_March_2013.jpg | 24 |
| Aaron_Schulz_March_2013.jpg | 24 |
| Faris_El-Gwely.jpg | 24 |
| S_Page_March_2013.jpg | 24 |
| NOLA_Hackathon_31.jpg | 24 |
| Julie_Trias_March_2013.jpg | 24 |
| RDunican_April_2010_wikimedia_03_10_616.jpg | 24 |
| Adam_Wight.jpg | 24 |
| Sage_Ross_self-portrait_in_Creative_Commons_t-shirt,_2012-12-16.jpg | 24 |
| Dan_Foy_WMF.jpg | 24 |
| Juliusz_Gonera.jpg | 24 |
| Alolita_Sharma_004_-_Berlin_2011.jpg | 25 |
| Mark_Holmquist.jpeg | 25 |
| Nischayn22.jpeg | 25 |
| Vibha_Bamba.jpg | 25 |
| Dario_Taraborelli_020_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| Katie_Horn_2.jpg | 25 |
| Renee_Bracey_Sherman_Wikimedia_Foundation_Staff_May_1_2012-1.jpg | 25 |
| Amir_Aharoni.jpg | 25 |
| VictorGrigas.jpg | 25 |
| 06_Heather_Walls_-_Wikimedia_Foundation_04.jpg | 25 |
| Rob_Lanphier_014_-_Berlin_2011.jpg | 25 |
| Amit_Kapoor_007_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| Siko_Bouterse-8.jpg | 25 |
| PPena-16.jpg | 25 |
| Gayle_Karen_Young.jpg | 25 |
| Stephen_LaPorte.jpg | 25 |
| Jessie_Wild_008_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| 08_Roan_Kattouw_-_Wikimedia_Foundation_10.jpg | 25 |
| Peter_Coombe.jpg | 25 |
| Wikimedia_Staff_Portrait_-_Andrew_Otto.jpg | 25 |
| 11_Janice_Tud_-_Wikimedia_Foundation_01.jpg | 25 |
| Erik_Zachte_June_2008.JPG | 25 |
| Leslie_Harms_014_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| Rubina_Kwon.jpg | 25 |
| HFung_April_2010_wikimedia_03_10_841.jpg | 25 |
| Jonathan_Curiel_014_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| 12_Rob_Moen_-_Wikimedia_Foundation_06.jpg | 25 |
| Evan_Rosen.jpg | 25 |
| Ryan_Faulkner_018_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| Haitham_Shamaa.jpg | 25 |
| Jonathan_Morgan_crop.png | 25 |
| Zack_Exley-8858.jpeg | 25 |
| Fabrice_Florin.jpg | 25 |
| Lisa_Seitz-Gruwell_008_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| Michael_Dale_December_2008.jpg | 25 |
| Ryan_Lane_004_-_Berlin_2011.jpg | 25 |
| Michelle_Paulson_009_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| Chip_Deubner_staff_photo.jpg | 25 |
| Joslyn_Lewis_-_Head_Shot.jpg | 25 |
| MaggieDennis.jpg | 25 |
| Daisy_Chen-2.jpg | 25 |
| Asher_Feldman_021_-_Wikimedia_Foundation_Oct11.jpg | 25 |
| James_Forrester.jpg | 25 |
| Niklas_Laxstrom_Wikipedia_Staff_Portrait.jpg | 25 |
| GPaumier_April_2010_wikimedia_03_10_805.jpg | 26 |
| Maryana_Pinchuk_007_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Siebrand_Mazeland.jpg | 26 |
| Jay_Walsh_May_2008.JPG | 26 |
| PBeaudette_april_2010_wikimedia_03_10_238.jpg | 26 |
| Garfield_Byrd_003_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Kul_Wadhwa_May_2008.JPG | 26 |
| Brandon_Harris_023_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Leslie_Carr_009_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Steven_Walling_004_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Brion_Vibber_May_2008.JPG | 26 |
| Sumana_Harihareswara_021_-_Berlin_2011.jpg | 26 |
| Bryony_Jones_009_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Peter_Gehres_008_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Winifred_Olliff_003_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| LiAnna_Davis_001_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Melanie_Brown_004_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Tilman_Bayer_002_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Ryan_Kaldari_Banner_photo.jpg | 26 |
| Ariel_Glenn_005_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Tim_Starling_June08.jpg | 26 |
| Josh_VanDavier_004_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| MHernandez_April_2010_wikimedia_03_10_574.jpg | 26 |
| Arthur_Richards_005_-_Berlin_2011.jpg | 26 |
| Asaf_Bartov_006_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| James_Alexander_005_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Tony_Le_012_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Frank_Schulenburg_June08.JPG | 26 |
| Mark_Bergsma_June08.JPG | 26 |
| Trevor_Parscal_December_2008.jpg | 26 |
| Rachel_Farrand_010_-_Wikimedia_Foundation_Oct11.jpg | 26 |
| Tomasz_Finc_December_2008.jpg | 27 |
| Wikimedia_Foundation_Sue_Gardner_Sept_2010.jpg | 29 |
| Wikimedia_Foundation_office_camera_shy.png | 29 |
| Erik_Moeller_May_2008.JPG | 30 |
+---------------------------------------------------------------------+----------+
124 rows in set (0.00 sec)
</pre>

Latest revision as of 15:08, 3 June 2023

foo

Retrieved from "https://foundation.wikimedia.org/w/index.php?title=Wikimedia:Sandbox&oldid=260310"