Wikimedia:Sandbox: Difference between revisions
Content deleted Content added
+ |
all right |
||
Line 1: | Line 1: | ||
<source lang="sql"> |
|||
{{sandbox heading}}<!-- |
|||
SELECT |
|||
* Welcome to the sandbox! * |
|||
il1.il_to, |
|||
* Please leave this part alone * |
|||
COUNT(*) |
|||
* Feel free to try your editing skills below * --> |
|||
FROM page |
|||
JOIN imagelinks AS il1 |
|||
[[wikipedia:This link should go to Wikipedia]] |
|||
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)