Wikisource E book creation requirement

Fork of Wikisource priority chapterisation list by Arjunaraoc

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

SQL

use tewikisource_p;
SELECT  
	pl_title,
    	page_title
FROM page 
LEFT JOIN  categorylinks ON categorylinks.cl_from = page_id
LEFT JOIN pagelinks ON pl_from=page_id
WHERE(categorylinks.cl_to= 'సూచిక_ఆమోదించబడినది' AND pl_namespace=0 AND pl_title NOT REGEXP '.+/.+'  AND pl_title NOT IN (SELECT page_title
	FROM page
        LEFT JOIN categorylinks ON categorylinks.cl_from = page_id
	WHERE (categorylinks.cl_to = 'దింపుకొనదగిన_పుస్తకాలు' AND page_namespace=0)) )
ORDER BY pl_title;

SQL

Checking query status...