Wikimedia:Sandbox: Difference between revisions
Content deleted Content added
+ |
all right |
||
Line 1:
<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>
|
Revision as of 05:07, 12 March 2013
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;
+---------------------------------------------------------------------+----------+ | 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)