User:Bawolff/usage stats sexual media

From Wikimedia Commons, the free media repository
Jump to: navigation, search

See also: User:Bawolff/usage_stats

Russavia asked me if I could do some quick stats like in User:Bawolff/usage_stats but for sexually explicit images. There's lots of controversy over such images, and it would be interesting to see how many there are, how often they are used, etc. Here are some very very rough stats on that. Its very difficult to accurately determine if an image is sexually explicit automatically, so this list almost certainly excludes many sexual images, as well as including some images that aren't sexual.

So for some rough stats, what I did is took images in Eroticism, Category:Sex_in_humans, category:Videos_of_human_sexuality, category:Audio_of_human_sexuality (I made a typo here. I meant to include Category:Audio files_about human_sexuality but typed the category name wrong, so ended up having an extra empty category. This does not affect the stats output, it just means entries in Category:Audio_files_about_human_sexuality weren't included), and category:Human_penis. If an image is used more than once, or if its in multiple of these categories, its only counted once. I then tried it again, with the subcats of these categories (and the original categories excluded). If an image is both in Eroticism and its subcat, it will be counted both when doing the original cat, and its subcat.

An image is considered used if it is used on a Wikimedia project other than commons. Hotlinkers, instant commons, and certain usages with Proofread page are not counted.

These stats were roughly done on 21:37, 5 July 2013 (UTC)

Recursion level (See below for exact categories) Total Used Percentage used
0 (5 categories) 271 94 34.67%
1 (75 categories) 2458 925 38%
2 (362 categories) 8268 4266 51.60%


Categories at each level[edit]

0[edit]

'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis'

1[edit]

MariaDB [commonswiki_p]> select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( 'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis' ) and cl_type= 'subcat';
+---------------------------------------------+
| page_title                                  |
+---------------------------------------------+
| Adult_models                                |
| Erotic_art                                  |
| Autoeroticism                               |
| Banknotes_in_crotch_area                    |
| Cameltoes                                   |
| Cleavage_(breasts)                          |
| Crotchless_clothing                         |
| Erogenous_zones                             |
| Erotic_licking                              |
| Erotic_novels                               |
| Homoeroticism                               |
| Human_surface_anatomy                       |
| Intergluteal_cleft                          |
| Kia_Kole_(Sally)                            |
| Naked_News                                  |
| Panty_lines                                 |
| Pasties                                     |
| Penthouse_magazine                          |
| People_in_sexually_appealing_postures       |
| Playboy                                     |
| Shaved_genitalia                            |
| Erotic_shows                                |
| Suggestive_use_of_feathers                  |
| Suggestive_use_of_sticking_out_tongue       |
| SuicideGirls                                |
| Vintage_nude_photographs                    |
| Uncircumcised_human_penis                   |
| Circumcised_human_penis                     |
| Human_penis_in_art                          |
| Clean_intermittent_self-catheterization     |
| Cock_rings                                  |
| Penises_in_condoms                          |
| Human_penis_by_degree_of_rigidity           |
| Erectile_dysfunction                        |
| Human_penis_facing_left                     |
| Human_penis_facing_right                    |
| Fordyce's_spots_on_human_penis              |
| Frenulum_of_the_human_penis                 |
| Human_glans_penis                           |
| Hirsuties_papillaris_penis                  |
| Human_foreskin                              |
| Human_male_urination                        |
| Human_penis_(medical)                       |
| Hypospadias                                 |
| Penis_Lesion                                |
| Male_ejaculation                            |
| Meatus_urethrae,_male                       |
| Modification_of_the_human_male_penis        |
| Penile_art                                  |
| Penis_pumps                                 |
| Sex_practices_involving_the_penis           |
| Human_penis_size                            |
| Smegma                                      |
| Ultrasound_images_of_fetal_penis            |
| Sex_practices                               |
| Females_having_sex                          |
| Males_having_sex                            |
| People_having_sex_in_art                    |
| Videos_of_humans_having_sex                 |
| Aphrodisiacs                                |
| Sex_business                                |
| Demonstrations_and_protests_relating_to_sex |
| Sexually_transmitted_diseases_and_disorders |
| Sex_education                               |
| Sex_festivals                               |
| Humans_mating                               |
| Sex-related_objects                         |
| Puberty                                     |
| Religion_and_sex                            |
| Videos_of_sexuality_by_decade               |
| Videos_of_sexuality_by_format               |
| Black_and_white_videos_of_sexuality         |
| Videos_of_human_genitalia                   |
| Videos_of_masturbation                      |
| Videos_of_humans_having_sex                 |
+---------------------------------------------+

Queries used were:

MariaDB [commonswiki_p]> select count(DISTINCT cl_from) from categorylinks where cl_type= 'file' and cl_to in ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( 'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis' ) and cl_type= 'subcat');
+-------------------------+
| count(DISTINCT cl_from) |
+-------------------------+
|                    2458 |
+-------------------------+
1 row in set (0.05 sec)

MariaDB [commonswiki_p]> select count(DISTINCT cl_from) from image inner join page on page_namespace = 6 and page_title = img_name inner join categorylinks on cl_from = page_id and cl_type = 'file' LEFT OUTER JOIN globalimagelinks on gil_to = img_name where gil_to is null and cl_to in ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( 'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis' ) and cl_type= 'subcat');
+-------------------------+
| count(DISTINCT cl_from) |
+-------------------------+
|                    1533 |
+-------------------------+
1 row in set (0.37 sec)

2[edit]

At this stage, we've already got things like pictures of demonstrations pro/against abortion coming in to the mix, which are probably not sexually explicit.

MariaDB [commonswiki_p]> select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( 'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis' ) and cl_type= 'subcat') and cl_type= 'subcat';
+--------------------------------------------------------------+
| page_title                                                   |
+--------------------------------------------------------------+
| Penthouse_Pets                                               |
| DanniGirls                                                   |
| Playboy_Playmates                                            |
| Playboy_models                                               |
| Adult_models_by_country                                      |
| Zoey_Cash                                                    |
| Fetish_models                                                |
| Male_adult_models                                            |
| Holly_Wood_(model)                                           |
| Ancient_erotic_art                                           |
| Pin-up-art                                                   |
| Erotic_Pre-Columbian_art                                     |
| Nicolas_Chorier                                              |
| Romanesque_erotic_art                                        |
| Love_Land                                                    |
| I_modi                                                       |
| Les_Sonnetts_Luxurieux_(Paul_Avril)                          |
| Abstract_erotic_art                                          |
| Nymphs_and_satyrs                                            |
| Gothic_erotic_art                                            |
| Musée_de_l'érotisme                                          |
| Los_Borbones_en_pelota                                       |
| Erotic_comics                                                |
| Erotic_art_of_Persia                                         |
| Drunken_Lot_and_his_daughters                                |
| Gay_erotic_art                                               |
| Erotic_photography                                           |
| Marquise's_book                                              |
| Erotic_cakes                                                 |
| Erotic_Art_Museum_Hamburg                                    |
| Erotic_artists                                               |
| Erotic_sculptures                                            |
| Erotic_scenes_from_Second_Life                               |
| Erotic_images_of_children                                    |
| Erotic_engravings                                            |
| Erotic_art_of_Japan                                          |
| Couples_in_love_in_art                                       |
| Erotic_graffiti                                              |
| Blasphemy                                                    |
| Go-go_boys                                                   |
| Santa_Claus_by_Paul_McCarthy                                 |
| Monumens_de_la_vie_privee_des_douze_cesars                   |
| Aphrodite_and_Eros                                           |
| Pornography                                                  |
| Eighth_Festival_of_Erotic_Art,_Tlalnepantla                  |
| Women's_erotica                                              |
| Masturbation                                                 |
| Autoeroticism_in_art                                         |
| Male_cameltoes                                               |
| Female_cameltoes                                             |
| Downblouse                                                   |
| Necklaces_in_cleavage                                        |
| Décolleté                                                    |
| Crotchless_lingerie                                          |
| Genitalia                                                    |
| Breasts                                                      |
| Human_navel                                                  |
| Sexual_licking                                               |
| Tongue_kisses                                                |
| Fanny_Hill                                                   |
| Les_Liaisons_Dangereuses                                     |
| Histoire_de_Dom_Bougre,_Portier_des_Chartreux                |
| Josefine_Mutzenbacher                                        |
| Thérèse_philosophe                                           |
| Lesbian_eroticism                                            |
| Male_homoeroticism                                           |
| Female_cameltoes                                             |
| Shaved_genitalia                                             |
| Bald_heads                                                   |
| Pubic_hair                                                   |
| Female_breasts_of_humans                                     |
| Toplessness                                                  |
| Female_long_hair                                             |
| Nude_or_partially_nude_people                                |
| Female_hands                                                 |
| Female_hips                                                  |
| Male_faces                                                   |
| Female_faces                                                 |
| Female_armpits                                               |
| Naked_female_buttocks                                        |
| Human_anus                                                   |
| Dimples_of_Venus                                             |
| Cupid's_bow                                                  |
| Perineum                                                     |
| Male_human_genitalia                                         |
| Female_human_genitalia                                       |
| Lily_Kwan                                                    |
| Ken_Marcus                                                   |
| Suze_Randall                                                 |
| Hesketh_308D                                                 |
| Hesketh_308E                                                 |
| Penthouse_Pets                                               |
| Palmolive_Building                                           |
| Playboy_magazine                                             |
| Playboy_Mansion                                              |
| Playboy_Radio                                                |
| N950PB_(aircraft)                                            |
| Playboy_Jazz_festival                                        |
| Playboy_bunny_logos                                          |
| Playboy-colored_racing_automobiles                           |
| Playboy_people                                               |
| Playboy_Racing                                               |
| Shaved_genitalia_(female)                                    |
| Shaved_genitalia_(male)                                      |
| Striptease                                                   |
| Sex_shows                                                    |
| Wet_T-shirt_contests                                         |
| Mud_wrestling                                                |
| Erotic_pole_dancing                                          |
| Eros_Galicia                                                 |
| Bikini_car_wash                                              |
| Oil_wrestling_(erotic_show)                                  |
| Erotic_licking                                               |
| Anemona                                                      |
| Amina_Munster                                                |
| Files_from_SuicideGirls_Flickr_stream                        |
| Gaudenzio_Marconi                                            |
| Jean_Louis_Marie_Eugène_Durieu                               |
| Max_Koch                                                     |
| Vincenzo_Galdi                                               |
| Wilhelm_von_Plueschow                                        |
| Uwe-Scheid-Collection                                        |
| Jean_Agélou                                                  |
| Auguste_Belloc                                               |
| Félix-Jacques_Moulin                                         |
| Louis-Camille_d'Olivier                                      |
| Julien_Vallou_de_Villeneuve                                  |
| Julian_Mandel                                                |
| Lehnert_&_Landrock                                           |
| Stratz_-_Der_Körper_des_Kindes_und_seine_Pflege_(pictures)   |
| Wilhelm_von_Gloeden                                          |
| Marcel_Chatelain                                             |
| Marcellin_Flandrin                                           |
| Pierre_Louÿs                                                 |
| Jean_Marie_Canellas                                          |
| Jules_Richard_(photographer)                                 |
| Louis_Jean-Baptiste_Igout                                    |
| Charles_Gilhousen                                            |
| F._Viala                                                     |
| Charles_Naudet                                               |
| Levy_&_Fils                                                  |
| P._Cousin_et_Cie                                             |
| Studio_CL                                                    |
| Fhal                                                         |
| Adia_(photography)                                           |
| J._Boussuge                                                  |
| Compagnie_des_Arts_Photomécaniques                           |
| Editions_Photo_Africaines                                    |
| Combier_(CIM)                                                |
| Regence_(photography)                                        |
| Collection_Louys                                             |
| Kricorian                                                    |
| Collection_idéale_PS                                         |
| Société_Industrielle_de_Photographie                         |
| Ephtimios                                                    |
| Behar                                                        |
| Aqua-Photo_L.V.S.                                            |
| Erotische_Fotografie_1845-1890                               |
| Erotische_Fotografie_1890-1920                               |
| P._Madeleine                                                 |
| Photographs_by_Lucien_Walery                                 |
| Rodolphe_Neuer                                               |
| Orientalist_nude_photographs_by_Jean_Geiser                  |
| Pictures_of_the_female_nude_by_Eadweard_Muybridge            |
| Orientalist_nude_photographs_by_J._Garrigues                 |
| Vintage_male_nude_photographs                                |
| Nude_photos_by_Wilhelm_von_Plueschow                         |
| Circumcised_and_uncircumcised_human_penises_in_comparison    |
| Circumcised_and_uncircumcised_human_penises_in_comparison    |
| Partial_circumcision                                         |
| Human_penis_in_art_in_various_degrees_of_rigidity            |
| Semi-erect_human_penis_in_art                                |
| Erect_human_penis_in_art                                     |
| Flaccid_human_penis_in_art                                   |
| Phallic_symbols                                              |
| Human_male_urination_in_art                                  |
| Erect_human_penis                                            |
| Flaccid_human_penis                                          |
| Semi-erect_human_penis                                       |
| Videos_of_penile_erection                                    |
| Viagra                                                       |
| Frenulum_breve                                               |
| Phimosis                                                     |
| Foreskin_restoration                                         |
| Foreskin_piercings                                           |
| Human_foreskin_videos                                        |
| Human_male_urination_in_art                                  |
| Fordyce's_spots_on_human_penis                               |
| Foreskin_restoration                                         |
| Hirsuties_papillaris_genitalis                               |
| Ultrasound_images_of_fetal_penis                             |
| Surgery_of_male_human_genitalia                              |
| Phimosis                                                     |
| Hypospadias                                                  |
| Penis_Lesion                                                 |
| Clean_intermittent_self-catheterization                      |
| Micropenis                                                   |
| Frenulum_breve                                               |
| Ejaculation_(animated)                                       |
| Videos_of_human_ejaculation                                  |
| Male_masturbation_after_ejaculation                          |
| Semen_on_partner's_body                                      |
| Pre-ejaculate                                                |
| Male_genital_piercings                                       |
| Dorsal_slit                                                  |
| Meatotomy                                                    |
| Penile_subincision                                           |
| Circumcision                                                 |
| Penis_pumps                                                  |
| Paintings_by_Pricasso                                        |
| Penile-vaginal_intercourse                                   |
| Penile-anal_intercourse                                      |
| Male_masturbation                                            |
| Fellatio                                                     |
| Frot                                                         |
| Footjob                                                      |
| Handjob                                                      |
| Human_penises,_erect_length_5"_to_under_6"                   |
| Human_penises,_erect_length_8"_to_under_9"                   |
| Human_penises,_erect_length_7"_to_under_8"                   |
| Human_penises,_erect_length_6"_to_under_7"                   |
| Human_penises,_erect_length_3"_to_under_4"                   |
| Human_penises,_erect_length_4"_to_under_5"                   |
| Human_penises,_erect_length_1"_to_under_2"                   |
| Human_penises,_erect_length_2"_to_under_3"                   |
| Micropenis                                                   |
| Group_sex                                                    |
| Oral_sex                                                     |
| Sexual_acts                                                  |
| Sexual_penetrative_use_of_objects                            |
| Phone_sex                                                    |
| Safer_sex                                                    |
| Glory_holes                                                  |
| Masturbation                                                 |
| Voyeurism                                                    |
| Semen_on_partner's_body                                      |
| Sex_toys                                                     |
| Outdoor_sex                                                  |
| Heterosexual_sex                                             |
| LGBT_sex                                                     |
| Anal_sex                                                     |
| Vaginal_sex                                                  |
| Sex_practices_involving_the_penis                            |
| Homosexual_sex                                               |
| Female_orgasms                                               |
| Cunnilingus                                                  |
| Vaginal_sex                                                  |
| Threesomes_involving_women                                   |
| Female_submission                                            |
| Lesbic_sex                                                   |
| Heterosexual_sex                                             |
| Homosexual_sex                                               |
| Females_performing_oral_sex                                  |
| Woman-on-top_positions                                       |
| Females_having_sex_in_art                                    |
| Fellatio                                                     |
| Male_orgasms                                                 |
| Males_performing_cunnilingus                                 |
| Threesomes_involving_men                                     |
| Male_submission                                              |
| Man-on-top_positions                                         |
| Gay_sex                                                      |
| Heterosexual_sex                                             |
| Sex_practices_involving_the_penis                            |
| Homosexual_sex                                               |
| Males_performing_oral_sex                                    |
| Males_having_sex_in_art                                      |
| Zoophilia_in_art                                             |
| Rape_in_art                                                  |
| Paintings_of_couples_having_sex                              |
| Kama_Sutra                                                   |
| Wiki-Sexuality_Images                                        |
| Sex_drawings                                                 |
| Pornography                                                  |
| Sex_museums                                                  |
| Sex_on_coins                                                 |
| Anal_sex_in_art                                              |
| Group_sex_in_art                                             |
| Oral_sex_in_art                                              |
| Couples_having_sex_in_art                                    |
| Homosexual_sex_in_art                                        |
| Autoeroticism_in_art                                         |
| Missionary_positions_in_art                                  |
| Kneeling_sex_positions_in_art                                |
| Females_having_sex_in_art                                    |
| Males_having_sex_in_art                                      |
| Heterosexual_sex_in_art                                      |
| Historic_pornographic_videos                                 |
| Viagra                                                       |
| PDE5_inhibitors                                              |
| Sex_shops                                                    |
| Prostitution                                                 |
| Erotic_bakeries                                              |
| Sex_shows                                                    |
| Love_hotels                                                  |
| Gay_bathhouses                                               |
| Sexuality-related_occupations                                |
| Sex_business_by_country                                      |
| Strip_clubs                                                  |
| Sex_clubs                                                    |
| Demonstrations_and_protests_relating_to_LGBT                 |
| Fuck_for_Forest                                              |
| Demonstrations_and_protests_against_pedophilia               |
| Sex_strike                                                   |
| Demonstrations_and_protests_by_Femen                         |
| Fuckparade                                                   |
| Demonstrations_and_protests_against_sexism                   |
| Demonstrations_and_protests_relating_to_abortion             |
| Demonstrations_and_protests_against_prostitution             |
| Demonstrations_and_protests_in_support_of_prostitutes_rights |
| Posters_of_sexually_transmitted_diseases_and_disorders       |
| Chlamydia                                                    |
| Genital_warts                                                |
| Donovanosis                                                  |
| Gonorrhea                                                    |
| Herpes_genitalis                                             |
| HIV                                                          |
| Molluscum_contagiosum                                        |
| Non-specific_urethritis                                      |
| Pubic_lice                                                   |
| Scabies                                                      |
| Syphilis                                                     |
| Trichomonas_vaginalis                                        |
| Bacterial_vaginosis                                          |
| Sex_educators                                                |
| Sex_education_for_adults                                     |
| Safer_sex                                                    |
| Wiki-Sexuality_Images                                        |
| Venus_Berlin                                                 |
| BDSM_events                                                  |
| Eropolis                                                     |
| Vancouver_International_Burlesque_festival                   |
| Salon-erotik                                                 |
| Courtship_in_humans                                          |
| Penile-vaginal_intercourse                                   |
| Condoms                                                      |
| Personal_lubricants                                          |
| Sex_toys                                                     |
| Adolescence                                                  |
| Tanner_scale                                                 |
| Male_puberty                                                 |
| Acne                                                         |
| Religion_and_LGBT                                            |
| Fertility_deities                                            |
| Love_and_lust_goddesses                                      |
| Steven_Greenberg                                             |
| Videos_of_ejaculation_by_decade                              |
| Videos_of_male_masturbation_by_decade                        |
| Ogv_videos_of_sexuality                                      |
| Ogg_videos_of_sexuality                                      |
| GIF_videos_of_sexuality                                      |
| Videos_of_male_masturbation_by_format                        |
| Videos_of_ejaculation_by_format                              |
| Black_and_white_videos_of_ejaculation                        |
| Historic_pornographic_videos                                 |
| Black_and_white_videos_of_female_masturbation                |
| Black_and_white_videos_of_male_masturbation                  |
| Videos_of_male_genitalia                                     |
| Videos_of_female_genitalia                                   |
| Videos_of_humans_having_sex                                  |
| Videos_of_female_masturbation                                |
| Videos_of_male_masturbation                                  |
+--------------------------------------------------------------+
362 rows in set (0.05 sec)

Actual queries:

MariaDB [commonswiki_p]> select count(DISTINCT cl_from) from image inner join page on page_namespace = 6 and page_title = img_name inner join categorylinks on cl_from = page_id and cl_type = 'file' LEFT OUTER JOIN globalimagelinks on gil_to = img_name where gil_to is null and cl_to in ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( 'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis' ) and cl_type= 'subcat') and cl_type= 'subcat');
+-------------------------+
| count(DISTINCT cl_from) |
+-------------------------+
|                    4002 |
+-------------------------+
1 row in set (1.07 sec)

MariaDB [commonswiki_p]> select count(DISTINCT cl_from) from categorylinks where cl_type= 'file' and cl_to in ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( ( select page_title from categorylinks inner join page on page_id = cl_from where cl_to in ( 'Eroticism', 'Sex_in_humans', 'Videos_of_human_sexuality', 'Audio_of_human_sexuality', 'Human_penis' ) and cl_type= 'subcat'))and cl_type = 'subcat');
+-------------------------+
| count(DISTINCT cl_from) |
+-------------------------+
|                    8268 |
+-------------------------+
1 row in set (0.12 sec)