Wikidata disambiguations with properties

SQL

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

Checking query status...
