Jump to content

Talk:Wikibase/Schema/wb items per site

Add topic
From mediawiki.org
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)Reply