Untitled query #64887

SQL

SELECT page_title, MIN(rev_timestamp),
       Count(ll_lang) 
FROM   page 
       JOIN category 
         ON page_title = cat_title 
       LEFT JOIN categorylinks 
              ON page_title = cl_to 
       LEFT JOIN templatelinks 
              ON tl_from = page_id 
                 AND tl_title IN ( 'تصنيف_فارغ' , 'تحويل_تصنيف' ) 
       LEFT JOIN langlinks 
              ON page_id = ll_from 
       LEFT JOIN revision
             ON page_id = rev_id
WHERE  page_namespace = 14 
       AND page_is_redirect = 0 
       AND cl_to IS NULL 
       AND tl_title IS NULL
       AND page_title NOT LIKE "%مقال%"
AND rev_timestamp < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)
GROUP  BY page_title 
ORDER  BY 2, 
          1;
          #query from Reza1615
SQL

Checking query status...
