top WD mergers

SQL

USE wikidatawiki_p;
SELECT epp_entity_id
#CONCAT("# [[Q",epp1.epp_entity_id,"]]") AS item, GROUP_CONCAT(DISTINCT CONCAT("[[",further_links.pl_title,"]]") SEPARATOR ', ') AS links_to
	FROM wb_entity_per_page 
	LEFT JOIN wb_items_per_site
		ON ips_item_id = epp_entity_id
    join revision on rev_page = epp_page_id
WHERE ips_item_id IS NULL and rev_comment like "%wbmergeitems-from%"
and rev_len > 100
GROUP BY epp_page_id


/*
	JOIN revision AS rev2 ON rev2.rev_id = rev1.rev_parent_id
WHERE rev1.rev_len IS NOT NULL AND rev2.rev_len IS NOT NULL
GROUP BY rev1.rev_user_text HAVING COUNT(rev1.rev_id) > 50
*/
SQL

Checking query status...
