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

SQL

x
 
use arwiki_p;
SELECT p.page_title, CONCAT(pp_value)
FROM page as p, page_props as pp, wikidatawiki_p.page as wdp
#LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P31' or wdpl.pl_title = 'P279') AND wdpl.pl_namespace = 120 
WHERE p.page_namespace = 0
#and  exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P31') AND wdpl.pl_namespace = 120)
and  exists (select * from arwiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'user:Mr._Ibrahem/78') AND wdpl.pl_namespace = 10)
#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 not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P735') AND wdpl.pl_namespace = 120)
#JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'Q11424' AND wdpl2.pl_namespace = 0
#and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'Q794') AND wdpl.pl_namespace = 0)
AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0
    # and (p.page_title like "أحمد_%") and (p.page_title not like "%_أحمد") 
 #   and (p.page_title not like "%أباد%")
  #  and (p.page_title not like "%آباد%")
  #      and (p.page_title not like "%توضيح%")
  #  and (p.page_title like "علي_%") and (p.page_title not like "%_علي")
GROUP BY p.page_title
#order by ll_from
LIMIT 1000;
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...