Flickr images should generally be moved to Commons where there is a process in place for validating the license. Otherwise, when a Flickr user closes their account, we cannot be certain that the license was ever correct and have to delete the image.
https://quarry.wmflabs.org/query/29759
USE enwiki_p;
SELECT DISTINCT CONCAT('File:', p.page_title) FROM page p
INNER JOIN externallinks ON el_from = p.page_id
/*LEFT JOIN imagelinks i ON p.page_title = i.il_to -- AND (i.il_from_namespace = 0) */
LEFT JOIN categorylinks c1 ON p.page_id = c1.cl_from AND c1.cl_to = "All_non-free_media"
LEFT JOIN redirect on rd_from = p.page_id
WHERE /*i.il_from IS NULL
AND*/ p.page_namespace = 6
AND c1.cl_to IS NULL -- Exclude fair use - other processes will handle those
AND rd_title IS NULL -- Exclude redirects
AND el_to LIKE '%flickr%'
ORDER BY page_id DESC
LIMIT 20000
-
File:Boy Playing Games.jpg
-
File:MestenoAtOU.jpeg
-
File:Girl Next To A Water Fountain Wikipedia.jpg
-
File:Smiley Dude.JPG
-
File:What if s1 digital keyart vert v3 lg (1).jpg
-
File:Indigenous Language Map.jpeg
-
File:2010 Guangzhou Auto Show * MG3 Girl.jpeg
-
File:Tau Cadre Fireblade Colasanti.jpg
-
File:Kitten typing on black keyboard (496607907).jpg
-
File:Disney Animal Kingdom (27589660700).jpg
-
File:ISS004-E-7723.jpeg
-
File:Olszewski Inauguration.jpg
-
File:The Octagon.jpeg
-
File:Eric Jacobson puppeteer, July 2015.jpg
-
File:Thomas Hampson Baritone (3).jpg
-
File:Petroliana along NH 116.jpg
-
File:New Hampshire marker for Fort at No. 4.jpg
-
File:Great North Woods sign (Coos County, New Hampshire).jpg
-
File:Terry Glynn, Wycombe Wanderers FC footballer, August 1981.jpg
-
File:Samyang Instant Noodles.jpg
-
File:KamalPatelResearcher.jpg
-
File:SolOrwellEntrepreneur.jpg
-
File:Thomas Bach in Bangkok-17 April 2018.jpg
-
File:Prawit Wongsuwan in PyeongChang-18 February 2018.jpg
-
File:Jan-Willem Breure NVIFF.jpg
-
File:Guerin Austin July 2019.jpg
-
File:Michael Chavis July 2019.jpg
-
File:Trump and Kim in North Korea June 2019 (cropped).jpg
-
File:Bretton Woods Monetary Conference historical marker (2007).jpg
-
File:Image of Abhodi Lahib (Kapre).jpg
-
File:Chloe Chaidez performing with Kitten at The Roxy in 2017.jpg
-
File:Green Apple Hi-Chew.jpg
-
File:Actress Aderonke Adeniyi on an interview set.jpg
-
File:Aderonke Adeniyi in 'Twisted', a movie produced by her.jpg
-
File:Aderonke Adeniyi and Actor Funsho Adeolu on set of Our Wife.jpg
-
File:Aderonke Adeniyi's Movie 'Our Wife.jpeg
-
File:Aderonke Adeniyi.jpeg
-
File:Nigel Osborne.jpg
-
File:CliffCompton2012Cropped.png
-
File:Northwest Territories Licence Plate 1979 bear design.jpg
-
File:Northwest Territories Licence Plate 1977 bear design.jpg
-
File:Northwest Territories Licence Plate 1975 bear design.jpg
-
File:Wooden Pig.jpg
-
File:Northwest Territories Licence Plate 1974 bear design.jpg
-
File:Sewanee1906.png
-
File:Juliette Adam c. 1895.jpg
-
File:Stephanie Kugelman.jpeg
-
File:Kirkland Lake Gold Mine Rescue Team 2016.jpg
-
File:Montgomery Fitch logo monogram.jpg
-
File:Stagecoach Gold bus in Wantage.jpg
-
File:Tale Ognenovski with his Quartet and with Dimitar Dimovski in May, 2001.jpg
-
File:Tale Ognenovski was clarinetist of Macedonian National Police Wind Orchestra in 1955.jpg
-
File:Tale Ognenovski, clarinetist and composer with his wife Nevena in Bitola, Republic of Macedonia in 1947.jpg
-
File:Tale Ognenovski, clarinetist and composer with his Quartet in Vodno Mountain, Skopje, Republic of Macedonia in 2000.jpg
-
File:Tale Ognenovski, with his zurna (“zurla”) in Vodno Mountain, Skopje, Republic of Macedonia in 2006.jpg
-
File:Tale Ognenovski, with his son Stevan Ognenovski, Mag. Scient. photographed in front of the Faculty of Electrical Engineering, University of Zagreb, Croatia in May, 1974.jpg
-
File:Tale Ognenovski, clarinetist and composer with his drum and his son Stevan Ognenovski, in Vodno Mountain, Skopje, Republic of Macedonia in 2000.jpg
-
File:Tale Ognenovski, clarinetist and composer with his reed pipe in Vodno Mountain, Skopje, Republic of Macedonia in 2006.jpg
-
File:Tale Ognenovski, clarinetist and composer with his Buffet Crampon and Dushko Dimitrovski, ethnomusicologist in 1999.jpg
-
File:Tale Ognenovski, clarinetist and composer with his tin whistle in front of his house in village Brusnik, Bitola, Republic of Macedonia in 2000.jpg
-
File:Tale Ognenovski with his son Stevan Ognenovski, his daughter in law Margarita Ognenovska, and his grandsons Nikola and Kliment in 2002, Skopje, Republic of Macedonia.jpg
-
File:Pelister National Park, Baba Mountain, Bitola, Republic of Macedonia in 1998.jpg
-
File:Tale Ognenovski with his Rampone clarinet performing for his uncle Petar Hristov from North City, Illinois, USA in February 1956.jpg
-
File:Tale Ognenovski, clarinetist and composer performs live with his son Stevan Ognenovski on drum in Ohrid, Republic of Macedonia on July 9, 2001.jpg
-
File:Tale Ognenovski, clarinetist and composer speak in Ohrid, Republic of Macedonia on July 9, 2001.jpg
-
File:Tale Ognenovski, with his family in 1926, village Brusnik, Bitola, Republic of Macedonia.jpg
-
File:Tale Ognenovski, in front of Macedonian Radio-Television in Skopje, Republic of Macedonia in 2000.jpg
-
File:Tale Ognenovski with his Quartet and with his daughter in law Margarita Ognenovska in May 2001 in the “Promuzika TRA-LA-LA Studio”, Skopje, Republic of Macedonia.jpg
-
File:Lineup kimaera.jpg
-
File:Raymond Transportation logo.png
-
File:Dianthus-plumarius-plant.jpg
-
File:Bobby Ross, Brentford FC footballer, 1968.jpg
-
File:Roc city ballet futurpointe.jpeg
-
File:Jeroen Paul Thesseling with Warwick Thumb NT7 fretless.jpg
-
File:Brentford v Grazer Sportklub programme, 1955.jpg
-
File:St. John the Evangelist Church in Pittston City.jpg
-
File:City Hall of Pittston.jpg
-
File:Dweck mermaid mural.jpg
-
File:MetcalfSouthComingSoon.jpg
-
File:"File:Mohammed ""Saint"" Sillah at Le Fest ,002.jpeg"
-
File:Rural Transit Bus.jpg
-
File:Deatil from the Creation window in S.Chad, Far Headingley, Leeds, Yorkshire.jpg
-
File:Downtown Phoenix Dusk 2006.jpg
-
File:Delta Upsilon pinning.jpg
-
File:Sabrina Erdely.jpg
-
File:Ki-Hong Lee.jpg
-
File:R.Farooq.jpg
-
File:The very know Rwandan basket decoration used in Wedding ceremonies.jpg
-
File:Kumari Sheila Arangetram with Padma Bhushan Dhanvanthi Rama Rau.jpg
-
File:Sheila with Rukmini Devi Arundale.jpg
-
File:Pearse Doherty speaking at Bodenstown 2013.jpg
-
File:Dr Muhammad Ali-drali1954.jpg
-
File:Alberto Santos-Dumont 1910 circa.jpg
-
File:Vblock 300 FX.jpg
-
File:Toyo Tsutsuli 120725.jpg
-
File:Cleopatra and Julia Child.jpg
-
File:"File:DWC ""New Orleans"".jpg"
-
File:Egyptian Vulture in Pokhara.jpg
-
File:Pokhara Montage 2.jpg
-
File:Pokhara Montage.jpg
-
File:Lillisfromquad.jpg
-
File:Telehealth - Blood Pressure Monitor.jpg
-
File:CIGI Composition.jpg
-
File:BSIA Logo.jpg
-
File:CIGI-Campus-Creative-Commons.jpg
-
File:CIGI-Atrium-Creative-Commons.jpg
-
File:NeeKauNis Sunset.jpg
-
File:JEREMY CORBELL.jpg
-
File:ShriGuruRavidasJikijai.JPG
-
File:Barbara Morgenstern.jpg
-
File:Coral Nebula Aelita Andre.jpg
-
File:Stevenmiles.jpg
-
File:Smithfieldhorse.jpg
-
File:4413086138 29390ab733.jpg
-
File:Andrew gronholdt photography by david l clark slight retouch.jpg
-
File:BloodhoundGangBandFlic.jpg
-
File:Louisiana Senate.png
-
File:Palmettocheese.jpg
-
File:Mediatrixlipa.jpg
-
File:UnmaadOct2009 Floor Painting.jpg
-
File:Zupan's Markets logo.jpg
-
File:City seal bartow.jpg
-
File:Aron Nels Steinke.jpg
-
File:Tim Finin.jpg
-
File:Chuck Klein WOF.jpg
-
File:Jason Flom 2010.jpg
-
File:UST in Intramuros.jpg
-
File:NewHolland Telehandler LM5000.jpg
-
File:Bocelli and Blige on Oprah.jpg
-
File:Shinran statue nyc.jpg
-
File:Budapest Opera interior.jpg
-
File:Curt Simmons plaque.jpg
-
File:CharlieBendate.jpg
-
File:Draught Mythos.jpg
-
File:Rickdees.jpg
-
File:IHWC - Gold.jpg
-
File:IHWC - Pajamas.jpg
-
File:AlfredoKeil Bust.jpg
-
File:Bargate Lion.jpg
-
File:Boyd Orr Building Glasgow.jpg
-
File:Evolutionposter.jpg
-
File:Beasties3.png
-
File:Lindsayczarniakbowiebaysoxgame.jpg
-
File:Kund Malir 3.jpg
-
File:Kund Malir 2.jpg
-
File:Kund Malir sign.jpg
-
File:Falak palace.jpg
-
File:ATXPortal.jpg
-
File:GeckoTAT.jpg
-
File:Kuwait water towers.jpg
-
File:River exe low.jpg
-
File:Tozeur Local in the Medina.jpg
-
File:Dr Jerry Pournelle at BayCon 2006.
-
File:Agordat2.jpg
-
File:Battambangmonksquarters.jpg
-
File:Battambangmarket.jpg
-
File:Battambangtemple.jpg
-
File:Battambangwomen.jpg
-
File:Chdl 1.jpg
-
File:Correction gabu-chan croppe(1).gif
-
File:Nansen Ski Jump.jpg
-
File:Arnhem trolleybus2.jpg
-
File:Rc firehouse 1934.jpg
-
File:Barrett-baseballcubs.jpg
-
File:AndrewCoulterEnright.jpg
-
File:Beer-Schlenkerla-Rauchbier-Urbock.jpg
-
File:Bip!.jpg
-
File:SaintJohnHarbo.jpg
-
File:Silver pagoda cambodia.jpg
-
File:Cubs-barrett2.jpg
-
File:BetTzedekHousingConditions.gif
-
File:BetTzedekKinshipCare.jpg
-
File:ClimbHighTemple.jpg
-
File:ShrineofBab.jpg
-
File:Attappadi Tribal Chief.jpg
-
File:André Derain - Arlequin et Pierrot.jpg
-
File:Sue wideangle full.jpg
-
File:Musée du Louvre - from Jardin des Tuileres, Paris, France (26 April 2006).JPG
-
File:Château de Breze - from vineyard (1 May 2006).jpg
-
File:Château de Chenonceau - east facade over Cher (4 May 2006).JPG
-
File:Bd lady.jpg
-
File:Mosaicofmyfamily.jpg
-
File:Stegosaurus hall of dinos.jpg
-
File:Shawn murray trees.jpg
-
File:Bolasspider.jpg
-
File:YB lighthouse.jpg
-
File:OrbTransit.jpg
-
File:BananaSlugOnFern.jpg
-
File:UnidentifiedBrownSpider.jpg
You must be logged in to post a comment.