The "popular items" query for Wikidata's main page

SQL

SHOW TABLES IN wikidatawiki_p;
SELECT * FROM wikidatawiki_p.wbs_propertypairs LIMIT 10;

/* use wikidatawiki_p;
SELECT
	rc_title,
    COUNT(*) AS cnt
FROM recentchanges
LEFT JOIN tag_summary
	ON rc_id = ts_rc_id
WHERE ts_tags IS NULL
	AND rc_type=0
    AND rc_bot=0
    AND rc_namespace=0
    AND rc_patrolled=1
    AND rc_timestamp<20180424000000
    AND rc_timestamp>20180422000000
    AND rc_old_len<rc_new_len
    AND rc_title NOT IN
    	(SELECT pl_title
         FROM pagelinks
         WHERE pl_from = 26001882
         	AND pl_namespace = 0)
GROUP BY rc_title HAVING COUNT(DISTINCT rc_user_text) >= 3
ORDER BY cnt DESC # */

SQL

Checking query status...