Fork of تخصيص بذرة by FShbib
This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

AخA
 
use arwiki_p;
select p.page_title
#select CONCAT('[[',p.page_title,']]')
#select CONCAT('[[تصنيف:',p.page_title,']]')
FROM page as p, page_props as pp#, wikidatawiki_p.page as wdp
WHERE p.page_namespace = 0
/*and  exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND
            (wdpl.pl_title = 'P21') AND wdpl.pl_namespace = 120)
#and exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id
#AND (wdpl.pl_title = 'Q6581072') AND wdpl.pl_namespace = 0)  #أنثى
and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND 
            (wdpl.pl_title = 'Q6581097') AND wdpl.pl_namespace = 0)  # ذكر
and exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id 
                AND (wdpl.pl_title = 'P214' or wdpl.pl_title = 'P1309')  )*/
and p.page_id in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="بذرة")
and p.page_id in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="صندوق_معلومات_شخص")
and p.page_is_redirect = 0 
#AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0
GROUP BY p.page_title
#order by ll_from
LIMIT 20;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...