Untitled query #26305

SQL

USE enwiki_p;
SELECT
tp.page_id as page_id_tp,
tp.page_namespace as page_namespace_tp,
tp.page_title as page_title_tp,
tp.page_restrictions as page_restrictions_tp,
tp.page_is_redirect as page_is_redirect_tp,
tp.page_is_new as page_is_new_tp,
tp.page_random as page_random_tp,
tp.page_touched as page_touched_tp,
tp.page_links_updated as page_links_updated_tp,
tp.page_latest as page_latest_tp,
tp.page_len as page_len_tp,
tp.page_content_model as page_content_model_tp,
categorylinks.*,
ap.page_id as page_id_ap,
ap.page_namespace as page_namespace_ap,
ap.page_title as page_title_ap,
ap.page_restrictions as page_restrictions_ap,
ap.page_is_redirect as page_is_redirect_ap,
ap.page_is_new as page_is_new_ap,
ap.page_random as page_random_ap,
ap.page_touched as page_touched_ap,
ap.page_links_updated as page_links_updated_ap,
ap.page_latest as page_latest_ap,
ap.page_len as page_len_ap,
ap.page_content_model as page_content_model_ap
FROM page tp
JOIN categorylinks cl
ON tp.page_id=cl_from and tp.page_id = 12709898
JOIN page ap
ON (tp.page_title=ap.page_title
    AND ap.page_namespace=0)
WHERE cl_to='Accepted_AfC_submissions'
AND ap.page_is_redirect=0
SQL

Checking query status...
