alswiki displaytitle

SQL

/*
USE cswiki_p;
SELECT page_title, rev_user_text, rev_timestamp
FROM revision
JOIN page ON page_id = rev_page
WHERE page_is_redirect = 0
AND page_namespace = 0
AND rev_parent_id = 0
AND rev_timestamp BETWEEN 20180228230000 AND 20180331230000
ORDER BY rev_timestamp;
*/
USE wikidatawiki_p;
SELECT page_title FROM page
JOIN pagelinks ON page_id = pl_from
LEFT JOIN wb_terms ON term_full_entity_id = page_title AND page_namespace = 0 AND term_language = 'en' AND term_type = 'description'
WHERE pl_title = 'Q34740' AND pl_namespace = 0
LIMIT 100;
SQL

Checking query status...
