use ruwiki_p;

select (select count(ll_lang) from langlinks

        where ll_from = page_id) + 1 as "number", page_title,

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

from page

where page_namespace = 0

and page_is_redirect = 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 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")

​