USE fawiki_p;

SELECT /*SLOW OK*/ concat('*[[',page_title,']]')

FROM page

WHERE page_id IN (

        SELECT tl_from

        FROM templatelinks

        WHERE tl_title = "بدون_منبع"

            AND tl_namespace = 10)

and page_id IN (

        SELECT tl_from

        FROM templatelinks

        WHERE tl_title = "سرشناسی"

            AND tl_namespace = 10)

            AND page_id NOT IN (

                SELECT ll_from

                FROM langlinks

                WHERE ll_lang = "en"

                );