SELECT  article.page_title, article.page_len as bytes

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"

        and articleC.cl_to like "Assembly_constituencies_of_%"

--        and articleC.cl_to like "Lok_Sabha_constituencies_in_%"

        and talkC.cl_to="Stub-Class_Indian_politics_articles"

        and article.page_len > 5000

order by article.page_len desc;