Featured and good articles, not yet promoted from homepage (skwiki)

SQL

USE tewiki_p;

SELECT
    page_title AS title,
    page_len,
    GROUP_CONCAT(cl_to) AS categories
  FROM
    page,
    categorylinks
  WHERE
    page_namespace = 0 AND
    cl_from = page_id AND
    cl_to IN ('వికీపీడియా:విశేష_వ్యాసాలు', 'వికీపీడియా:ఈ_వారపు_వ్యాసం') AND
    page_title NOT IN (
      SELECT 
          pl_title 
        FROM 
          page, 
          pagelinks 
        WHERE 
          pl_from = page_id AND 
          page_namespace = 4 AND 
          page_title LIKE 'విశేష_వ్యాసాలు%'
    ) AND
    page_title NOT IN (
      SELECT 
          rd_title 
        FROM 
          redirect,
          page page_redirect, 
          pagelinks, 
          page page_wlsrc
        WHERE 
          rd_from = page_redirect.page_id AND 
          page_redirect.page_title = pl_title AND 
          page_redirect.page_namespace = pl_namespace AND 
          pl_from = page_wlsrc.page_id AND 
          page_wlsrc.page_namespace = 4 AND 
          page_wlsrc.page_title LIKE 'విశేష_వ్యాసాలు%'
   )
  GROUP BY
    page_id
  ORDER BY
    categories DESC, page_len DESC
  ;
SQL

Checking query status...
