Jump to content

User:B/Fair use images used outside of mainspace

From Wikipedia, the free encyclopedia

Generated from http://quarry.wmflabs.org/query/2900

USE enwiki_p;
SELECT DISTINCT CONCAT('{{subst:User:B/Fair use images used outside of mainspace/Table row|[[:{{ns:', i.il_from_namespace, '}}:',  p.page_title, ']]|[[:File:', i_p.page_title, ']]|', r.rev_timestamp, '}}') 
FROM page p
INNER JOIN imagelinks i ON i.il_from = p.page_id 
						AND i.il_from_namespace <> 0
INNER JOIN page i_p ON i.il_to = i_p.page_title AND 1 <> p.page_is_redirect
INNER JOIN categorylinks c2 ON i_p.page_id = c2.cl_from AND c2.cl_to = "All_non-free_media"
INNER JOIN revision r ON p.page_latest = r.rev_id
LIMIT 5000

The list

[edit]
Page Image Last edited
User:Cote_d'Azur/sandbox File:Cairo_Coat_of_Arms.svg 20180824144037
User:HannahEvans69 File:Celebrity_Big_Brother_22_(UK)_Eye.png 20180824020308
User:Saurabh_Nadar/sandbox File:Dynamo_Magician_Impossible.jpg 20180824072755
Portal:Calculus File:LeonhardEulerByDrsDotChRadio.ogg 20180815213317
Template:Syrian_Civil_War_infobox File:National_Defence_Force_Syria_Logo.jpg 20180824124013
Template:Syrian_Civil_War_infobox/testcases File:National_Defence_Force_Syria_Logo.jpg 20141023192333
User:B/No_Rights_Reserved_Images File:Robert_Wentorf_Jr._portrait.jpg 20180823202642
User:Cherrylimerickey/sandbox File:Roberta_flack_(album_cover).jpg 20180824020323
File:SR-Olympics.png File:Sports_Reference_Logo.svg 20180722222215
Template:Periodic_table_(group_7) File:Technetium.jpg 20180823204358
User talk:EEng File:Trump_Baby_Balloon_at_protest_in_Parliament_Square.jpg 20180824161134
File:Unibersidad_ng_Pilipinas.png File:University_of_The_Philippines_seal.svg 20180109184409