WSoR datasets/wikiprojects member pages

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

This table contains a list of WikiProjects member pages.

Location[edit]

db1048:shawn.wikiprojects_member_pagess

Fields[edit]

	shawn@internproxy:~$ mysql -h db1048 -e "EXPLAIN wikiprojects_member_pages;SELECT * FROM wikiprojects_member_pages LIMIT 3" shawn
	+------------------+----------------+------+-----+---------+-------+
	| Field            | Type           | Null | Key | Default | Extra |
	+------------------+----------------+------+-----+---------+-------+
	| page_id          | int(11)        | YES  |     | NULL    |       |
	| page_title       | varbinary(255) | YES  |     | NULL    |       |
	| page_is_redirect | int(11)        | YES  |     | NULL    |       |
	| page_latest      | int(11)        | YES  |     | NULL    |       |
	| wp_id            | int(11)        | YES  |     | NULL    |       |
	+------------------+----------------+------+-----+---------+-------+
	+----------+---------------------------------+------------------+-------------+---------+
	| page_id  | page_title                      | page_is_redirect | page_latest | wp_id   |
	+----------+---------------------------------+------------------+-------------+---------+
	| 25711742 | WikiProject_Abkhazia/Members    |                0 |   336354196 | 9234505 |
	|  6210271 | WikiProject_Adelaide/Members    |                0 |   151097173 | 1046137 |
	| 20786334 | WikiProject_Afghanistan/Members |                0 |   437847545 | 9235245 |
	+----------+---------------------------------+------------------+-------------+---------+

Each row represents a a member page of a WikiProject.

  • page_id: id of the member page
  • page_title: page title
  • page_is_redirect: 0 if page is not a redirect (taken from page table)
  • page_latest:
  • wp_id: id of the WikiProject main page

Reproduction[edit]

Create Table:

	CREATE TABLE `wikiprojects_member_pages` (
	  `page_id` int(11) DEFAULT NULL,
	  `page_title` varbinary(255) DEFAULT NULL,
	  `page_is_redirect` int(11) DEFAULT NULL,
	  `page_latest` int(11) DEFAULT NULL,
	  `wp_id` int(11) DEFAULT NULL
	)

Notes[edit]

This table was generated on 2011-07-19 23:06:06.