User:Fæ/Wikinews DRs

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

Table of images with Deletion Requests used on Wikinews. See Commons fair use upload bot for images that are due to be deleted and may be transferred for local use on Wikinews or other projects.

# File Cat/DR Wikinews link
01
Burqini.jpg
September 2016
DR
wikinews:en:French court suspends burkini ban
02
[[:|Conseil constitutionnel.jpg]]
September 2016
DR
wikinews:fr:France
wikinews:fr:Législatives 2007 en France
wikinews:fr:France
wikinews:fr:France
wikinews:fr:France
03
Notepad++ screenshot2.png
September 2016
DR
wikinews:en:User:Turtlestack/contact
wikinews:ru:Сайт Notepad++ подвергся взлому после выпуска «Je suis Charlie»-версии программы

Report completed: Tue, 06 Sep 2016 04:19 (8m 45.1s runtime).

SQL query to generate this table.
SELECT
 page_title,
 cl_to,
 GROUP_CONCAT(CONCAT(gil_wiki,':', gil_page_namespace,':', gil_page_title) SEPARATOR ' :: ') AS links
FROM page
JOIN globalimagelinks ON page_title=gil_to AND gil_wiki IN (
 "arwikinews", "bgwikinews", "bswikinews", "cawikinews", "cswikinews",
 "dewikinews", "elwikinews", "enwikinews", "eowikinews", "eswikinews",
 "fawikinews", "fiwikinews", "frwikinews", "hewikinews", "huwikinews",
 "itwikinews", "jawikinews", "kowikinews", "nowikinews", "plwikinews",
 "ptwikinews", "rowikinews", "ruwikinews", "sdwikinews", "sqwikinews",
 "srwikinews", "svwikinews", "tawikinews", "thwikinews", "trwikinews",
 "ukwikinews", "zhwikinews")
JOIN categorylinks ON page_id=cl_from AND cl_to LIKE "%Deletion_requests%"
WHERE	page_namespace=6
GROUP BY page_title;