Fork of
Orphaned non-free files (lvwiki)
by Edgars2007
This query is marked as a draft
This query has been published
by Bulgu.
SQL
AخA
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.