Paste P5614

WUs7oQpAMFAAAAG5QqEAAABN query
ActivePublic
Actions

Authored by bd808 on Jun 22 2017, 4:12 AM.

Tags

None

Referenced Files

	F8504432: WUs7oQpAMFAAAAG5QqEAAABN query
	Jun 22 2017, 4:13 AM

	F8504430: WUs7oQpAMFAAAAG5QqEAAABN query
	Jun 22 2017, 4:12 AM

Subscribers

None

	SELECT pap_project_title AS `project`,
	pa_class AS `class`,
	pa_importance AS `importance`,
	rev_timestamp AS `timestamp`,
	page_title,pa_page_revision AS `page_revision`,
	page_namespace
	FROM `page_assessments`
	JOIN `page_assessments_projects` ON ((pa_project_id = pap_project_id))
	JOIN `page` ON ((pa_page_id = page_id))
	JOIN `revision` ON ((page_id = rev_page AND pa_page_revision = rev_id))
	WHERE page_namespace = '2' LIMIT 101

Event Timeline

bd808 created this paste.Jun 22 2017, 4:12 AM

bd808 updated the paste's language from autodetect to sql.

bd808 edited the content of this paste. (Show Details)

EXPLAIN result

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page_assessments_projects	index	PRIMARY	pap_project_title	258	NULL	2915	Using index
1	SIMPLE	page_assessments	ref	PRIMARY,pa_project	pa_project	4	enwiki.page_assessments_projects.pap_project_id	559
1	SIMPLE	page	eq_ref	PRIMARY,name_title	PRIMARY	4	enwiki.page_assessments.pa_page_id	1	Using where
1	SIMPLE	revision	eq_ref	PRIMARY,page_timestamp,page_user_timestamp,rev_page_id	PRIMARY	4	enwiki.page_assessments.pa_page_revision	1	Using where

• MZMcBride mentioned this in T168599: Make the WikiProject or Page title field required for Page Assessments.Jun 22 2017, 4:19 AM