SELECT  distinct 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_%" OR

             articleC.cl_to like "Lok_Sabha_constituencies_in_%")

        and articleC.cl_to != "Assembly_constituencies_of_Coorg"

        and talkC.cl_to="Stub-Class_Indian_politics_articles"

order by article.page_len

limit 50