User:Gmaxwell/lfu
Templates that are tagged but don't begin with Non-free.. and the number of transclusions they have.
mysql> select concat('*{{tl|',tp.page_title,'}}'),count(distinct ip.page_title) as cc from templatelinks as nfm join page as tp on tp.page_id=nfm.tl_from join templatelinks as bt on bt.tl_title=tp.page_title and bt.tl_namespace=10 join page as ip on bt.tl_from=ip.page_id where nfm.tl_namespace=10 and nfm.tl_title='Non-free_media' and tp.page_namespace=10 and tp.page_title not like 'Non-free%' and ip.page_namespace=6 group by tp.page_title order by cc desc;
- {{Di-no_fair_use_rationale}} - 5576
- {{Restricted_use}} - 3110
- {{Seal}} - 1878
- {{No_copyright_holder}} - 1487
- {{Scoutlogo}} - 1131
- {{No_license_needing_editor_assistance}} - 728
- {{Tv-program-logo}} - 695
- {{Politicalposter}} - 660
- {{Withpermission}} - 596
- {{Somewebsite}} - 586
- {{Album_cover_fur}} - 390
- {{PhilippinesGov_with_fair_use}} - 383
- {{Boardgamecover}} - 343
- {{Filmrationale}} - 309
- {{Mugshot}} - 300
- {{Linux-software-screenshot}} - 261
- {{MEP_image_(EP)}} - 237
- {{FairusewithNC}} - 234
- {{Cardimage}} - 232
- {{Hqfl_logo}} - 219
- {{CartoonNetworkImageTag}} - 215
- {{Restaurant}} - 213
- {{Otto_Perry_image}} - 189
- {{Information_TV_series_screenshot}} - 177
- {{Olympics-logo}} - 166
- {{Reviewedfairuse}} - 157
- {{WWE-photo}} - 152
- {{NZCrownCopyright}} - 149
- {{Wrong-license}} - 144
- {{Sports_uniform}} - 139
- {{Orphaned_fairuse_replaced}} - 138
- {{Flagimage}} - 130
- {{Canada-politician-photo}} - 121
- {{USPSstamp}} - 115
- {{K12-logo}} - 114
- {{Money-EU_coin_national}} - 88
- {{Rationale}} - 78
- {{Fairuseair}} - 74
- {{Fair_use_audio_rationale}} - 69
- {{BC-traffic-sign}} - 66
- {{WP_Trains_fair_use}} - 57
- {{Sheet_music}} - 57
- {{Commercial_logo}} - 56
- {{Orphaned_fairuse_not_replaced}} - 55
- {{Fairusereview}} - 52
- {{Old-50}} - 50
- {{EUAVS}} - 49
- {{Filmbiorationale}} - 48
- {{IEEPA_sanctions}} - 44
- {{TNA-photo}} - 42
- {{Web-software-screenshot}} - 42
- {{Softwarecover}} - 40
- {{Machinima-screenshot}} - 39
- {{No_license}} - 38
- {{No_source}} - 35
- {{Denver_Public_Library_images}} - 35
- {{Cereal_box_cover}} - 33
- {{PD-CCTV}} - 32
- {{Tvlogo}} - 31
- {{Wayfinding}} - 28
- {{Product-cover}} - 28
- {{EU_image}} - 26
- {{Logo_fur}} - 23
- {{ESA_media}} - 23
- {{Replaceable_fair_use}} - 22
- {{Computer_hardware_logo}} - 22
- {{NZ-Currency}} - 20
- {{BCRP}} - 19
- {{Biorationale}} - 18
- {{Vodcast-screenshot}} - 17
- {{Maccabiah-logo}} - 17
- {{FOTWpic}} - 16
- {{HKCrownCopyright}} - 15
- {{Video_disc_cover}} - 15
- {{Db-unfree}} - 13
- {{Money-EU_coin_common}} - 12
- {{India-politician-photo}} - 11
- {{Danishdefence}} - 10
- {{RPG-artwork}} - 10
- {{FirefoxWiki}} - 9
- {{Sri-Lanka-politician-photo}} - 9
- {{Parody}} - 8
- {{Logo_rationale}} - 8
- {{Quebec-politician-photo}} - 8
- {{Speech}} - 7
- {{Official_document}} - 7
- {{Image-license-fairuse}} - 7
- {{Gymnast_ru_image}} - 6
- {{MEP_image_(EP_-_1st_term)}} - 6
- {{Iraqcopyright}} - 6
- {{Video_sample}} - 6
- {{Robert_Richardson_image}} - 5
- {{Dutch-politician-photo}} - 5
- {{Arcade-game-cover}} - 4
- {{TV_Rationale}} - 4
- {{Possibly-unfree-mural}} - 4
- {{Saskatchewan-politician-photo}} - 4
- {{FinnishDefenceForces}} - 4
- {{No_source_no_license}} - 3
- {{PolishPresidentCopyright}} - 3
- {{Old-70}} - 3
- {{MEP_image_(EP_-_2nd_term)}} - 3
- {{New_Brunswick-politician-photo}} - 3
- {{Money-EU}} - 3
- {{GFDL-invariants}} - 2
- {{Film_logo}} - 2
- {{Parliament_of_Australia}} - 2
- {{Alberta-politician-photo}} - 1
- {{Money-EU_banknote}} - 1
- {{Album_cover_fur/old}} - 1
- {{Political_party_trademark}} - 1
- {{CopyrightedCharacter}} - 1
- {{MEP_image_(EP_-_3rd_term)}} - 1
- {{Recordingmedium}} - 1
114 rows in set (5.75 sec)
Also, with Non-free:
- {{Non-free_album_cover}} - 71780
- {{Non-free_logo}} - 68352
- {{Non-free_promotional}} - 21931
- {{Non-free_media_rationale}} - 19894
- {{Non-free_book_cover}} - 16614
- {{Non-free_fair_use_in}} - 15556
- {{Non-free_film_screenshot}} - 14934
- {{Non-free_poster}} - 14618
- {{Non-free_game_screenshot}} - 13982
- {{Non-free_comic}} - 13346
- {{Non-free_DVD_cover}} - 8227
- {{Non-free_game_cover}} - 6228
- {{Non-free_character}} - 4430
- {{Non-free_software_screenshot}} - 3653
- {{Non-free_magazine_cover}} - 3227
- {{Non-free_audio_sample}} - 2746
- {{Non-free_music_video_screenshot}} - 2302
- {{Non-free_2D_art}} - 2040
- {{Non-free_currency}} - 1835
- {{Non-free_newspaper_image}} - 1567
- {{Non-free_symbol}} - 1546
- {{Non-free_web_screenshot}} - 1304
- {{Non-free_video_cover}} - 1190
- {{Non-free_historic_image}} - 1134
- {{Non-free_computer_icon}} - 656
- {{Non-free_unsure}} - 646
- {{Non-free_stamp}} - 334
- {{Non-free_3D_art}} - 218
- {{Non-free_video_screenshot}} - 125
- {{Non-free_Crown_copyright}} - 35
- {{Non-free_Mozilla_logo}} - 22
- {{Non-free_standard_test_image}} - 15