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 arwiki_p;
select DISTINCT CONCAT("",p1.page_title)
from page p1, templatelinks cla, linktarget lt
where p1.page_namespace = 0
and p1.page_is_redirect = 0

and lt.lt_namespace = 10 and cla.tl_target_id = lt.lt_id
and lt.lt_title = "مقالات_فريق_عمل_الرياضيين"
and cla.tl_from = p1.page_id

#sr
AND NOT EXISTS ( SELECT * FROM page p2 , categorylinks cc
    WHERE p2.page_title = p1.page_title 
    AND p2.page_namespace = 1
    and cc.cl_to = "الرياضيون"
    and cc.cl_from = p2.page_id
    )

SQL

Checking query status...