User:Gmaxwell/lfu

Templates that are tagged but don't begin with Non-free.. and the number of transclusions they have.

 mysql> select concat('*',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;  114 rows in set (5.75 sec)
 * 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

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