Latest properties

SQL

# For convenience, regex for Wikibase-SortedProperties
# (\d+)\t(.*)
# ->
# * P$1 ($2)

set @lastPropertyId = 8206;
set @language = 'en';

USE wikidatawiki_p;
SELECT
  wbpt_property_id as id,
  wbx_text as text
FROM wbt_property_terms
LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id
LEFT JOIN wbt_type ON wbtl_type_id = wby_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wby_name = 'label'
AND wbxl_language = @language
AND wbpt_property_id > @lastPropertyId
SQL

Checking query status...
