Untitled query #51996

SQL

#USE trwiki_p;
#SELECT COUNT(*) AS "Toplam", COUNT(DISTINCT page_title) AS "Toplam sayfa", COUNT(DISTINCT il_to) AS "Toplam dosya"
#FROM page
#JOIN imagelinks
#ON page_id = il_from 
#WHERE (NOT EXISTS( SELECT 1 FROM image WHERE img_name = il_to))
#AND (NOT EXISTS(SELECT 1 FROM commonswiki_p.page WHERE page_title = il_to AND page_namespace = 6))
#LIMIT 20;
USE trwiki_p;
SELECT CONCAT('# [[Dosya:',il_to,']]') AS "link_to", COUNT (DISTINCT page_title) AS  "Kullanıldığı sayfa sayısı"
FROM page JOIN imagelinks ON page_id = il_from 
WHERE (NOT EXISTS( SELECT 1 FROM image WHERE img_name = il_to))
AND (NOT EXISTS(SELECT 1 FROM commonswiki_p.page WHERE page_title = il_to AND page_namespace = 6))

ORDER BY page_title
LIMIT 100;

USE trwiki_p;
SELECT CONCAT('# [[Dosya:',il_to,']]') AS "link_to", CASE 
                                                            WHEN il_from_namespace=0 THEN CONCAT('[[',page_title,']]')
                                                            WHEN il_from_namespace=1 THEN CONCAT('[[Tartışma:',page_title,']]') 
                                                            WHEN il_from_namespace=2 THEN CONCAT('[[Kullanıcı:',page_title,']]')
                                                            WHEN il_from_namespace=3 THEN CONCAT('[[Kullanıcı_mesaj:',page_title,']]')
                                                            ELSE CONCAT('[[Diger:',page_title,']]')
                                                            END
                                                            AS  "Madde"
FROM page JOIN imagelinks ON page_id = il_from 
WHERE (NOT EXISTS( SELECT 1 FROM image WHERE img_name = il_to))
AND (NOT EXISTS(SELECT 1 FROM commonswiki_p.page WHERE page_title = il_to AND page_namespace = 6))

ORDER BY page_title
LIMIT 100;
SQL

Checking query status...
