Untitled query #66999

SQL

SELECT DISTINCT p.page_id,p.page_title,p.page_namespace,
(SELECT rev_timestamp FROM revision WHERE rev_id=p.page_latest LIMIT 1) AS page_touched,p.page_len,0 AS link_count FROM (
  SELECT * FROM categorylinks WHERE cl_to IN ("User_en")) cl0 INNER JOIN (page p) ON p.page_id=cl0.cl_from AND p.page_namespace=2
  AND p.page_id IN (
    SELECT DISTINCT tl_from FROM templatelinks,linktarget WHERE ((NVL(tl_namespace,0)=10 AND tl_title="User admin") OR (tl_target_id=lt_id
                    AND lt_namespace=10 AND lt_title="User_admin")) AND tl_from_namespace=2)
SQL

Checking query status...
