Number of original index pages for all downloadble books

Fork of Number of original index pages for all downloadble books by Arjunaraoc

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

SQL

use tewikisource_p;
SELECT 
	page_title,
    COUNT(*) as num_pages
FROM pagelinks
JOIN page on pl_from=page_id
WHERE  (pl_from_namespace=106 AND pl_namespace=104 AND pl_title REGEXP '.+/.+' AND page_title IN
(SELECT 
	page_title
FROM pagelinks
JOIN page on pl_from=page_id
WHERE  (pl_from_namespace=106 AND pl_namespace=0 AND pl_title NOT REGEXP '.+/.+' AND pl_title IN
        (SELECT page_title
		FROM page
        LEFT JOIN categorylinks ON categorylinks.cl_from = page_id
		WHERE (categorylinks.cl_to = 'దింపుకొనదగిన_పుస్తకాలు' AND page_namespace=0)) )))
GROUP BY page_title LIMIT 300;

SQL

Checking query status...