ANN - Quarry

SELECT group_concat(wdpl.pl_title)
FROM page as p
JOIN page_props as pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
JOIN wikidatawiki_p.page as wdp ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title in ('P345')
			AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0


select page_title, el_to, (SELECT group_concat(wdpl.pl_title)
FROM page as p
JOIN page_props as pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
JOIN wikidatawiki_p.page as wdp ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title in ('P345')
			AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0) as "Props"
        
        
        
from externallinks
join page on page_id=el_from and page_namespace=0
where el_index like "https://com.animenewsnetwork.www./encyclopedia/%"
limit 15

SQL

SELECT p.page_title, group_concat(wdpl.pl_title)
FROM page as p
JOIN page_props as pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
JOIN wikidatawiki_p.page as wdp ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title in ('P1982','P1983','P1984','P1985')
			AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0

SQL

Checking query status...