Talk:Wikibase/Schema/wb items per site
Add topicAppearance
< Talk:Wikibase | Schema
Latest comment: 8 years ago by Mdupont in topic page_id?
page_id?
[edit]On wikidata,
select * from wb_items_per_site where ips_item_id= 388 and ips_site_id='enwiki'; +------------+-------------+-------------+---------------+ | ips_row_id | ips_item_id | ips_site_id | ips_site_page | +------------+-------------+-------------+---------------+ | 507144060 | 388 | enwiki | Linux | +------------+-------------+-------------+---------------+
and
select page_id, page_title from page where page_id in (591); +---------+------------+ | page_id | page_title | +---------+------------+ | 591 | Q388 | +---------+------------+
So you can see 591 is the page id and 388 is the page title without the Q. Mdupont (talk) 21:01, 31 January 2016 (UTC)