šahisti - Quarry

SQL

use lvwiki_p;
SELECT
  p.page_title AS Title,
  el_to,
  props,
  pp.pp_value
FROM (SELECT * FROM externallinks WHERE (el_to LIKE "http://ratings.fide.com/%"
                                         or el_to LIKE "http://www.chessgames.com/%"
                                         or el_to LIKE "http://www.365chess.com/%"
                                         or el_to LIKE "http://chesstempo.com/gamedb/%"
                                         or el_to LIKE "https://www.iccf.com/player%")) AS el
JOIN page AS p
	ON p.page_id = el_from
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 ('P1440','P1665','P3314','P3315','P3316') 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...
