Wikidata disambiguations with properties

SQL

USE wikidatawiki_p;
SELECT epp_entity_id, epp_entity_type, rev_parent_id, rev_timestamp
FROM wb_entity_per_page
JOIN revision ON rev_parent_id = 0 AND rev_page = epp_page_id
WHERE epp_entity_id > 9999999
AND CONCAT(
  IF(epp_entity_id % 10000 < 1000, 0, ""), IF(epp_entity_id % 10000 < 100, 0, ""), IF(epp_entity_id % 10000 < 10, 0, ""),
  epp_entity_id % 10000,
  IF(((epp_entity_id - (epp_entity_id % 10000)) / 10000) % 100 < 10, 0, ""),
  ROUND(((epp_entity_id - (epp_entity_id % 10000)) / 10000) % 100),
  ROUND((epp_entity_id - (epp_entity_id % 1000000)) / 1000000),
  "%"
)
LIMIT 1;

SQL

Checking query status...