cswiki analytics

SQL

USE cswiki_p;
SELECT *
FROM (SELECT * FROM externallinks WHERE el_to LIKE "%drusop.nature.cz%") AS el
JOIN page AS cs ON cs.page_id = el_from
JOIN (SELECT * FROM page_props WHERE pp_propname = "wikibase_item") AS props ON pp_page = cs.page_id
JOIN (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS wd ON wd.page_title = pp_value
LEFT JOIN (SELECT * FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 120 AND pl_title = "P677") AS links
	ON pl_from = wd.page_id AND pl_from_namespace = wd.page_namespace
WHERE pl_title IS NULL
LIMIT 10;
SQL

Checking query status...
