FIS [v2] - Quarry

SQL

SELECT p.page_title, el_to, props
FROM (SELECT * FROM externallinks WHERE (el_index LIKE "http://com.fis-ski.data./dynamic/athlete-biography.html?sector=%"
                                        or el_index LIKE "http://com.fis-ski.www./uk/604/613.html?sector=%")
                                        ) AS el
JOIN page AS p
	ON p.page_id = el_from
join templatelinks tl on tl.tl_from=p.page_id and tl.tl_title="Ann" and tl.tl_namespace=10 and tl.tl_from_namespace=0
LEFT JOIN page_props AS pp
	ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
LEFT JOIN wikidatawiki_p.page AS wdp
	ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN (SELECT pl_from, GROUP_CONCAT( pl_title ) AS props FROM wikidatawiki_p.pagelinks
           WHERE pl_title IN ('P2772','P2773','P2774','P2775','P2776','P2777') AND pl_namespace = 120
           GROUP BY pl_from) AS wdpl
	ON wdpl.pl_from = wdp.page_id
WHERE p.page_namespace = 0;
SQL

Checking query status...
