çift kopya dosyalar

Fork of Wikidata items that link to trwiki and don't have claims by HakanIST

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

SQL

USE trwiki_p;
SELECT concat("* [[:Dosya:",REPLACE(REPLACE(p.page_title, '"', '**DOUBLEQUOTE**'), '_', ' '),"]]") FROM page p
INNER JOIN (image e JOIN commonswiki_p.image c ON c.img_sha1 = e.img_sha1) ON e.img_name = p.page_title
#LEFT JOIN categorylinks c1 ON c1.cl_from = p.page_id AND c1.cl_to = 'All_Wikipedia_files_with_a_different_name_on_Wikimedia_Commons'
#LEFT JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to = 'All_Wikipedia_files_with_the_same_name_on_Wikimedia_Commons'
#LEFT JOIN categorylinks c3 ON c3.cl_from = p.page_id AND c3.cl_to = 'Wikipedia_files_on_Wikimedia_Commons_for_which_a_local_copy_has_been_requested_to_be_kept'
WHERE p.page_namespace = 6
#AND c1.cl_from IS NULL
#AND c2.cl_from IS NULL
#AND c3.cl_from IS NULL

SQL

Checking query status...