USE fawiki_p;

SELECT /*SLOW OK*/ page_title

FROM page

WHERE page_namespace = 0 and page_is_redirect = 0 and page_id not IN (

        SELECT tl_from

        FROM templatelinks

        WHERE tl_title = "Infobox" AND tl_namespace = 10)

    AND page_id IN (

                SELECT ll_from

                FROM langlinks

                WHERE ll_from

                and ll_lang = "en"

                )

    AND page_id NOT IN (

        SELECT cl_from

        FROM categorylinks

        WHERE cl_to = "همه_صفحه•های_ابهام•زدایی"

        )

    AND page_id NOT IN (

        SELECT cl_from

        FROM categorylinks

        WHERE cl_to = "مقالات_دارای_جعبه_اطلاعات"

        );