elwiki kategorisiz maddeler

SQL

SELECT CONCAT(page_title) AS page_title_formatted 
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (
  SELECT p.page_id FROM page p
  INNER JOIN categorylinks cl ON cl.cl_from = p.page_id
  INNER JOIN page p2 ON cl.cl_to = p2.page_title AND p2.page_namespace = 14 -- 14 = Category
  LEFT JOIN page_props pp ON pp.pp_page = p2.page_id AND pp.pp_propname = 'hiddencat'
  WHERE pp.pp_page IS NULL
)
AND page_id NOT IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = "Σελίδες_που_δεν_ανήκουν_σε_κατηγορία"
)
AND page_id NOT IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = "Ακατηγοριοποίητο"
  AND cl_type = "page"
)
ORDER BY page_len ASC;
SQL

Checking query status...
