test - Quarry

Fork of #/articles in CAT:LP, and #/those that are footballers by Cryptic

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

#use enwiki_p;
select ll_title, en_temp.tl_title 
from page as en_p, langlinks , templatelinks as en_temp, linktarget
#where en_temp.tl_title like "US-%-stub" 
where  en_temp.tl_from = en_p.page_id
and lt_title like "%-cycling-bio-stub"
and en_p.page_id = ll_from
and en_p.page_namespace = 0
and en_p.page_is_redirect = 0
and en_temp.tl_target_id = lt_id and lt_namespace = 10
and ll_lang = 'ar'
and EXISTS ( select ar_p.page_title
    from arwiki_p.page ar_p, arwiki_p.categorylinks as cc
        where cc.cl_from = ar_p.page_id
        #and cc.cl_to = "بذرة_أعلام_الولايات_المتحدة_الأمريكية"
        and cc.cl_to like "بذرة_%"
        and ar_p.page_title = REPLACE(ll_title, ' ', '_')
        and en_p.page_namespace = ar_p.page_namespace
        )

SQL

Checking query status...