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  "Sayı"
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))
GROUP BY il_from_namespace
ORDER BY COUNT(page_title) DESC
LIMIT 20;
SQL

Checking query status...
