use enwiki_p;

​

select

    el_from,

        page_title,

    el_to_domain_index

    from

    externallinks,

    page

where

    el_to_domain_index like '%com.nytimes.www%' and

    el_from = page_id and

    page_namespace = 0

    limit 1000000;