Untitled query #27338

SQL

USE enwiki_p;
select * from (
SELECT current_timestamp() as date, tp.page_id, tp.page_title,
cl1.cl_timestamp as pending_afc_submissions_time,
t.*
FROM page tp
LEFT JOIN categorylinks cl1
ON tp.page_id = cl1.cl_from
AND cl1.cl_to = 'Pending_AfC_submissions'
LEFT JOIN templatelinks t
ON tp.page_id = t.tl_from
AND (tl_title like '%AFC%' or tl_title like '%AfC%' or tl_title like '%afc%')
WHERE tp.page_is_redirect = 0
AND tp.page_namespace = 118
  order by tp.page_id) a
  where page_title = 'Hope_Services';
SQL

Checking query status...
