WSoR datasets/wikiproject pages

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

This table contains a list of WikiProjects and their main page id.

Location[edit]

db1048:shawn.wikiproject_pages

Fields[edit]

	shawn@internproxy:~$ mysql -h db1048 -e "EXPLAIN wikiproject_pages;SELECT * FROM wikiproject_pages LIMIT 3" shawn
	+------------+------------------+------+-----+---------+-------+
	| Field      | Type             | Null | Key | Default | Extra |
	+------------+------------------+------+-----+---------+-------+
	| page_id    | int(11) unsigned | NO   | PRI | NULL    |       |
	| page_title | varbinary(255)   | YES  |     | NULL    |       |
	+------------+------------------+------+-----+---------+-------+
	+---------+------------------+
	| page_id | page_title       |
	+---------+------------------+
	|   33631 | WikiProject      |
	| 2586179 | WikiProject_.NET |
	| 5186090 | WikiProject_24   |
	+---------+------------------+

Each row represents a categorylink and the page_id of the WikiProject it is related to.

  • page_id: id of the WikiProject main page
  • page_title: title of WikiProject

Reproduction[edit]

Create Table:

	CREATE TABLE `wikiproject_pages` (
	  `page_id` int(11) unsigned NOT NULL,
	  `page_title` varbinary(255) DEFAULT NULL,
	  PRIMARY KEY (`page_id`)
	) ENGINE=MyISAM DEFAULT CHARSET=binary;

Insert Statement:

	INSERT INTO wikiproject_pages
	SELECT page_id,
	       page_title
	FROM   enwiki.page
	WHERE  page_namespace = 4
	   AND page_title LIKE 'WikiProject%'
	   AND page_title NOT LIKE '%/%'

Notes[edit]

This table was generated on 2011-07-21 23:25:01.