WUs7oQpAMFAAAAG5QqEAAABN query
No One
Actions

Authored By

	bd808
	Jun 22 2017, 4:12 AM

Size

447 B

Referenced Files

None

Subscribers

None

WUs7oQpAMFAAAAG5QqEAAABN query
View Options

	```
	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
	```