Orphaned non-free files (trwiki)

Fork of Orphaned non-free files (lvwiki) by Edgars2007

This query is marked as a draft This query has been published by Bulgu.

SQL

USE trwiki_p;
SELECT CONCAT('Dosya:',p.page_title) as dosyalar, rev_user_text as kullanici, min(rev_timestamp) as olusturma, CONCAT("tr.wikipedia.org/wiki/Dosya:",p.page_title) as link, page_is_new as yeni_mi
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to
left join revision rv ON p.page_id = rv.rev_page
WHERE c.cl_to IN ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri")
AND i.il_from IS NULL
AND p.page_namespace = 6
#AND rev_user = 0
#AND page_is_new = 0
GROUP by dosyalar
Order by kullanici

SQL

Checking query status...