Page MenuHomePhabricator
Paste P5614

WUs7oQpAMFAAAAG5QqEAAABN query
ActivePublic

Authored by bd808 on Jun 22 2017, 4:12 AM.
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

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpage_assessments_projectsindexPRIMARYpap_project_title258NULL2915Using index
1SIMPLEpage_assessmentsrefPRIMARY,pa_projectpa_project4enwiki.page_assessments_projects.pap_project_id559
1SIMPLEpageeq_refPRIMARY,name_titlePRIMARY4enwiki.page_assessments.pa_page_id1Using where
1SIMPLErevisioneq_refPRIMARY,page_timestamp,page_user_timestamp,rev_page_idPRIMARY4enwiki.page_assessments.pa_page_revision1Using where