Monthly streak for NPP reviewers (2023)

SQL

SELECT	distinct article.page_title
FROM	page AS article
join	page as talk on talk.page_namespace=1 and talk.page_title=article.page_title
join	categorylinks as articleC on articleC.cl_from=article.page_id
-- join	categorylinks as talkC on talkC.cl_from=talk.page_id
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=0
        and (articleC.cl_to="Constituencies_of_the_Lok_Sabha" OR
             articleC.cl_to like "Assembly_constituencies_of_%" OR
             articleC.cl_to like "Lok_Sabha_constituencies_in_%") and
             talk.page_id not in (select distinct cl_from from categorylinks where
        			cl_to in ("WikiProject_Indian_politics_articles")
                                 )

AخA
 
SELECT  distinct article.page_titleFROM    page AS articlejoin    page as talk on talk.page_namespace=1 and talk.page_title=article.page_titlejoin    categorylinks as articleC on articleC.cl_from=article.page_id-- join categorylinks as talkC on talkC.cl_from=talk.page_idWHERE   article.page_is_redirect=0        AND article.page_namespace=0        and (articleC.cl_to="Constituencies_of_the_Lok_Sabha" OR             articleC.cl_to like "Assembly_constituencies_of_%" OR             articleC.cl_to like "Lok_Sabha_constituencies_in_%") and             talk.page_id not in (select distinct cl_from from categorylinks where                    cl_to in ("WikiProject_Indian_politics_articles")                                 )

SQL

Checking query status...