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

SQL

USE skwiki_p;

SELECT
    REPLACE(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 ('Wikipédia:Dobré_články', 'Wikipédia:Najlepšie_články') AND
    page_title NOT IN (
      SELECT 
          lt_title 
        FROM 
          page, 
          pagelinks,
          linktarget
        WHERE 
          pl_from = page_id AND 
          page_namespace = 4 AND 
          lt_id = pl_target_id AND
          page_title LIKE 'Odporúčané_články%'
    ) AND
    page_title NOT IN (
      SELECT 
          rd_title 
        FROM 
          redirect,
          page page_redirect, 
          pagelinks, 
          linktarget,
          page page_wlsrc
        WHERE 
          rd_from = page_redirect.page_id AND 
          lt_id = pl_target_id AND
          page_redirect.page_title = lt_title AND 
          page_redirect.page_namespace = lt_namespace AND 
          pl_from = page_wlsrc.page_id AND 
          page_wlsrc.page_namespace = 4 AND 
          page_wlsrc.page_title LIKE 'Odporúčané_články%'
   )
  GROUP BY
    page_id
  ORDER BY
    categories DESC, page_len DESC
  ;
SQL

Checking query status...
