Pagine utente possibilmente categorizzate nelle categorie sbagliate

SQL

SELECT
  CONCAT('Utente:', page_title) AS 'pagina utente',
  IF(page_title LIKE '%/%', 'sì', 'no') AS 'è una sottopagina?',
  GROUP_CONCAT(CONCAT('Categoria:', REPLACE(cl_to, '_', ' ')) SEPARATOR ', ') AS categorie
FROM page
JOIN categorylinks ON page_id = cl_from
WHERE page_namespace = 2
  AND page_title NOT LIKE '%andbox%'
  AND cl_to NOT LIKE 'Errori\_d%'
  AND cl_to NOT LIKE 'Pagine\_che\_%'
  AND cl_to NOT LIKE 'Pagine\_con\_%'
  AND cl_to IN
  (
    SELECT cl_to
    FROM page, category, categorylinks
    WHERE page_id = cl_from
      AND cl_to = cat_title
      AND page_namespace = 0
    GROUP BY cl_to, cat_pages, cat_subcats, cat_files
    HAVING COUNT(cl_to) > cat_pages - cat_subcats - cat_files - COUNT(cl_to)
  )
GROUP BY page_title
ORDER BY 2, 1

SQL

Checking query status...