Wikisource priority chapterisation list

Fork of Wikisource priority chapterisation list by Arjunaraoc

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

Gives a listing of pages from the category:'గూగుల్_అనువాద_వ్యాసాలు'  on tewiki_p

SQL

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

SQL

Checking query status...