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", CONCAT(CASE
    WHEN il_from_namespace=0 THEN '[['
    WHEN il_from_namespace=1 THEN '[[Tartışma:'
    WHEN il_from_namespace=2 THEN '[[Kullanıcı:'
    WHEN il_from_namespace=3 THEN '[[Kullanıcı_mesaj:'
    ELSE '[[Diger:'
                                                            END;),page_title,']]') 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...
