image distribution sampling 2

This query is marked as a draft This query has been published by Swagoel.
SQL

/*use itwiki_p;

select il_from, il_to
from imagelinks
where il_to in ('Double-headed_eagle_of_the_Greek_Orthodox_Church.svg', 'GClef.svg', 'Flag_of_Hungary.svg', 'Provincia_di_Sassari-Stemma.svg', 'Eisenhower_with_Mamie.jpg', 'Nuvola_apps_ksig-vector.svg', 'Crystal_Clear_action_lock9.png', 'Orange-bg_rounded_cropped.svg', 'Flag_of_Brazil_(1889–1960).svg', 'Shared_IP.svg', 'Blue_pencil.svg', 'Firma_e_data.png', 'Translation_arrow.svg', 'Monitoraggio_non_fatto.svg', 'Flag_of_the_United_Kingdom.svg', 'Green_check.svg', 'Draig.svg', 'French_combat_ration_dsc06927.jpg', 'Mplayer.svg', 'Accessories-text-editor.svg', 'Mincio_a_Peschiera.jpg', 'Crystal_Clear_app_ksirtet.svg', 'Crystal_Clear_app_ktip.svg', 'Crystal_Clear_app_ksirtet.png', 'Stop_hand_nuvola.svg', 'Calendar_with_red_X.png', 'Wikipedia_ridotto.ogv', 'Commons-logo.svg', 'Elana_James_(2007).jpg', 'Symbol_stub_class.svg', 'Rosso_Bianco_e_Blu_(Strisce).svg', 'Puzzle_stub.svg', 'Copyright-problem.svg', 'Flag_of_Slovakia.svg', 'Shuttle.svg', 'Museum_icon.svg', 'Crystal_Clear_action_lock1.png', 'Foodlogo2.svg', 'Nuvola_apps_ksig.png', 'Help-browser.svg', 'Crystal_Clear_app_ktip.png', 'Red_pog.svg', 'Symbol_dot_dot_dot_violet.svg', 'TV-icon-2.svg', 'Kit_socks.svg', 'Nuvola_apps_bookcase.svg', 'Cavaliere_di_Gran_Croce_OCI_Kingdom_BAR.svg', 'Flag_of_Slovenia.svg', 'Question_book-4.svg', 'Cappella_Pelloux.jpg', 'Flag_of_Italy.svg', 'Flag_of_Switzerland.svg', 'Monet_-_Impression,_Sunrise.jpg', 'Norway_flagmap.svg', 'VisualEditor_-_Icon_-_Search-big.svg', '600px_pentasection_HEX-E42B2E_White.svg', 'Flag_map_of_Moldova.svg', 'Flag_of_Yugoslavia_(1946-1992).svg', 'Map_of_Arkansas_highlighting_Chicot_County.svg', 'Flag_of_East_Germany.svg', 'Flag_of_Japan.svg', 'Edit-delete-not_encyclopedic.svg', "Flag_of_the_People's_Republic_of_China.svg", 'Nuvola_filesystems_folder_orange.png', 'George_Spencer_Watson_(1869-1934)_-_Portrait_of_Miss_Beaton.jpg', 'Tennis_icon_nobkg.png', 'Gnome-insert-image.svg', 'Kit_shorts_parma9395a.png', '600px_bisection_vertical_HEX-FF0000_White.svg', 'Quill-Nuvola.svg', 'Flag_of_Germany.svg', 'Nuvola_apps_package_graphics.svg', 'Blu_Bianco_e_Giallo_(Diagonale).png', '600px_Blu_e_Rosso_incrociati_listati_di_Bianco.PNG', 'Flag-map_of_Slovenia.svg', '600px_Blu_e_Bianco2.svg', 'Flag_of_Georgia.svg', 'User-trash-full-4.svg', 'Basketball_the_Soviet_Union.png', 'Missing_Rodentia.png', 'Noia_64_apps_email.png', 'Flag_of_the_United_States.svg', 'Crystal_Clear_app_Login_Manager.svg', 'Silver_medal.svg', 'Flag_of_Libya_(1977-2011).svg', 'Flag_of_Brazil.svg', 'Chaetomium_globosum.jpg', '600px_solid_HEX-8E3145.svg', 'Outline_of_Ukraine.svg', 'Poland_map_flag.svg', 'ReligionSymbol.svg', 'Rosso_e_blu_(strisce)_2.svg', 'Kit_shorts.svg', 'Rugby_penalty.svg', '600px_vertical_Blue_HEX-120059_Red_HEX-F4001C.svg', 'Villa_dei_Sette_Bassi,_veduta.jpg', 'Messier_object_061.jpg', 'Flag_of_France.svg', 'Flag_of_Tuva.svg', 'Wappen_Zürich_matt.svg', 'Nuvola_apps_ktip.png', 'Emblem-important-yellow.svg', 'Abraham_Lincoln_O-55,_1861.png', 'Françoise_Abraham.jpg', 'Kit_body_vitersporthc.png', 'Flag_of_South_Africa.svg', 'Westerner_on_a_camel.jpg', 'Yellow_card.svg', 'Olympic_rings.svg', 'Bundesarchiv_Bild_183-1988-0720-036,_Berlin,_Junioren-Sportfest,_Katrin_Krabbe.jpg', 'Flag_of_Serbia.svg');*/

use itwiki_p;

select count(il_to), il_to
from imagelinks
where il_from_namespace in (0) and il_to in ('Double-headed_eagle_of_the_Greek_Orthodox_Church.svg', 'GClef.svg', 'Flag_of_Hungary.svg', 'Provincia_di_Sassari-Stemma.svg', 'Eisenhower_with_Mamie.jpg', 'Nuvola_apps_ksig-vector.svg', 'Crystal_Clear_action_lock9.png', 'Orange-bg_rounded_cropped.svg', 'Flag_of_Brazil_(1889–1960).svg', 'Shared_IP.svg', 'Blue_pencil.svg', 'Firma_e_data.png', 'Translation_arrow.svg', 'Monitoraggio_non_fatto.svg', 'Flag_of_the_United_Kingdom.svg', 'Green_check.svg', 'Draig.svg', 'French_combat_ration_dsc06927.jpg', 'Mplayer.svg', 'Accessories-text-editor.svg', 'Mincio_a_Peschiera.jpg', 'Crystal_Clear_app_ksirtet.svg', 'Crystal_Clear_app_ktip.svg', 'Crystal_Clear_app_ksirtet.png', 'Stop_hand_nuvola.svg', 'Calendar_with_red_X.png', 'Wikipedia_ridotto.ogv', 'Commons-logo.svg', 'Elana_James_(2007).jpg', 'Symbol_stub_class.svg', 'Rosso_Bianco_e_Blu_(Strisce).svg', 'Puzzle_stub.svg', 'Copyright-problem.svg', 'Flag_of_Slovakia.svg', 'Shuttle.svg', 'Museum_icon.svg', 'Crystal_Clear_action_lock1.png', 'Foodlogo2.svg', 'Nuvola_apps_ksig.png', 'Help-browser.svg', 'Crystal_Clear_app_ktip.png', 'Red_pog.svg', 'Symbol_dot_dot_dot_violet.svg', 'TV-icon-2.svg', 'Kit_socks.svg', 'Nuvola_apps_bookcase.svg', 'Cavaliere_di_Gran_Croce_OCI_Kingdom_BAR.svg', 'Flag_of_Slovenia.svg', 'Question_book-4.svg', 'Cappella_Pelloux.jpg', 'Flag_of_Italy.svg', 'Flag_of_Switzerland.svg', 'Monet_-_Impression,_Sunrise.jpg', 'Norway_flagmap.svg', 'VisualEditor_-_Icon_-_Search-big.svg', '600px_pentasection_HEX-E42B2E_White.svg', 'Flag_map_of_Moldova.svg', 'Flag_of_Yugoslavia_(1946-1992).svg', 'Map_of_Arkansas_highlighting_Chicot_County.svg', 'Flag_of_East_Germany.svg', 'Flag_of_Japan.svg', 'Edit-delete-not_encyclopedic.svg', "Flag_of_the_People's_Republic_of_China.svg", 'Nuvola_filesystems_folder_orange.png', 'George_Spencer_Watson_(1869-1934)_-_Portrait_of_Miss_Beaton.jpg', 'Tennis_icon_nobkg.png', 'Gnome-insert-image.svg', 'Kit_shorts_parma9395a.png', '600px_bisection_vertical_HEX-FF0000_White.svg', 'Quill-Nuvola.svg', 'Flag_of_Germany.svg', 'Nuvola_apps_package_graphics.svg', 'Blu_Bianco_e_Giallo_(Diagonale).png', '600px_Blu_e_Rosso_incrociati_listati_di_Bianco.PNG', 'Flag-map_of_Slovenia.svg', '600px_Blu_e_Bianco2.svg', 'Flag_of_Georgia.svg', 'User-trash-full-4.svg', 'Basketball_the_Soviet_Union.png', 'Missing_Rodentia.png', 'Noia_64_apps_email.png', 'Flag_of_the_United_States.svg', 'Crystal_Clear_app_Login_Manager.svg', 'Silver_medal.svg', 'Flag_of_Libya_(1977-2011).svg', 'Flag_of_Brazil.svg', 'Chaetomium_globosum.jpg', '600px_solid_HEX-8E3145.svg', 'Outline_of_Ukraine.svg', 'Poland_map_flag.svg', 'ReligionSymbol.svg', 'Rosso_e_blu_(strisce)_2.svg', 'Kit_shorts.svg', 'Rugby_penalty.svg', '600px_vertical_Blue_HEX-120059_Red_HEX-F4001C.svg', 'Villa_dei_Sette_Bassi,_veduta.jpg', 'Messier_object_061.jpg', 'Flag_of_France.svg', 'Flag_of_Tuva.svg', 'Wappen_Zürich_matt.svg', 'Nuvola_apps_ktip.png', 'Emblem-important-yellow.svg', 'Abraham_Lincoln_O-55,_1861.png', 'Françoise_Abraham.jpg', 'Kit_body_vitersporthc.png', 'Flag_of_South_Africa.svg', 'Westerner_on_a_camel.jpg', 'Yellow_card.svg', 'Olympic_rings.svg', 'Bundesarchiv_Bild_183-1988-0720-036,_Berlin,_Junioren-Sportfest,_Katrin_Krabbe.jpg', 'Flag_of_Serbia.svg')
group by il_to;
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...
