select (select count(ll_lang) from langlinks

        where ll_from = page_id) + 1 as "number", (select ll_title from langlinks where ll_from = page_id and ll_lang = "en") as "name"

from page

where page_namespace = 0

and (select count(ll_lang) from langlinks where ll_from = page_id) > 48

and exists (select * from langlinks where ll_from = page_id and ll_lang = "en"

            and not ll_title like "_ BC" and not ll_title like "__ BC" and not ll_title like "___ BC" and not ll_title like ".__"

            and exists (select * from enwiki_p.page as p1 where p1.page_namespace = 0 and p1.page_title = replace(ll_title, " ", "_")

            and p1.page_len > 5119))

and exists (select * from langlinks where ll_from = page_id and ll_lang = "fr")

and exists (select * from langlinks where ll_from = page_id and ll_lang = "de")

and not exists (select * from langlinks where ll_from = page_id and ll_lang = "he")

​