USE enwiki_p;

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

FROM page

WHERE page_id IN (

        SELECT tl_from

        FROM templatelinks

        WHERE tl_title = "Infobox_sportsperson"

            AND tl_namespace = 10

            AND tl_from IN (

                SELECT ll_from

                FROM langlinks

                WHERE ll_from

                GROUP BY ll_from

                HAVING COUNT(*) > 17

                )

  and page_id not IN (

        SELECT tl_from

        FROM templatelinks

        WHERE tl_title in ("Infobox_biathlete",

                           "Infobox_speed_skater",

                           "Infobox_athlete",

                           "Infobox_boxer_(amateur)"

                          ) AND tl_namespace = 10)

    AND tl_from NOT IN (

                SELECT ll_from

                FROM langlinks

                WHERE ll_lang = "fa"

                )

        );