Untitled query #23950

SQL

use arwiki_p;
SELECT  mp.page_title AS t, 
       TIMESTAMP((SELECT rev_timestamp 
                  FROM   revision 
                  WHERE  rev_id = mp.page_latest))                     AS ts, (SELECT COUNT(*) from revision where rev_page=mp.page_id) as ec,
(SELECT count(*) from templatelinks join page as tp on tp.page_title=tl_title and tp.page_namespace=10
join categorylinks as s on s.cl_to='Article_message_boxes' and s.cl_from=tp.page_id
where tl_namespace=10
and tl_from=mp.page_id) as tc
FROM   page as mp
LEFT OUTER JOIN  categorylinks as m
   ON  m.cl_to in ('صفحات_توضيح' )
   AND m.cl_from = mp.page_id
WHERE  mp.page_is_redirect = 0 
       AND mp.page_namespace = 0
       AND mp.page_latest < (SELECT rev_id 
                          FROM   revision 
                          WHERE  rev_timestamp > Date_format(DATE_SUB(NOW(), 
                                                             INTERVAL 3 YEAR), 
                                                 '%Y%m%d%H%i%s') 
                          LIMIT  1) 
       AND m.cl_to IS NULL order by ts asc LIMIT 5;
SQL

Checking query status...
