Untitled query #9484

SQL

USE enwiki_p;
SELECT
  tp.page_title, class, article.page_len
FROM (
  SELECT cl_from, "Stub" AS class 
  FROM categorylinks qual 
  WHERE qual.cl_to LIKE "Stub-Class_%" LIMIT 10
) AS foo
INNER JOIN page tp ON cl_from = page_id
INNER JOIN page article ON article.page_namespace = 0 AND article.page_title = tp.page_title
GROUP BY tp.page_title
UNION ALL
SELECT
  tp.page_title, class, article.page_len
FROM (
  SELECT cl_from, "Start" AS class 
  FROM categorylinks qual 
  WHERE qual.cl_to LIKE "Start-Class_%" LIMIT 10
) AS foo
INNER JOIN page tp ON cl_from = page_id
INNER JOIN page article ON article.page_namespace = 0 AND article.page_title = tp.page_title
GROUP BY tp.page_title
UNION ALL
SELECT
  tp.page_title, class, article.page_len
FROM (
  SELECT cl_from, "C" AS class 
  FROM categorylinks qual 
  WHERE qual.cl_to LIKE "C-Class_%" LIMIT 10
) AS foo
INNER JOIN page tp ON cl_from = page_id
INNER JOIN page article ON article.page_namespace = 0 AND article.page_title = tp.page_title
GROUP BY tp.page_title
UNION ALL
SELECT
  tp.page_title, class, article.page_len
FROM (
  SELECT cl_from, "B" AS class 
  FROM categorylinks qual 
  WHERE qual.cl_to LIKE "B-Class_%" LIMIT 10
) AS foo
INNER JOIN page tp ON cl_from = page_id
INNER JOIN page article ON article.page_namespace = 0 AND article.page_title = tp.page_title
GROUP BY tp.page_title
UNION ALL
SELECT
  tp.page_title, class, article.page_len
FROM (
  SELECT cl_from, "GA" AS class 
  FROM categorylinks qual 
  WHERE qual.cl_to LIKE "GA-Class_%" LIMIT 10
) AS foo
INNER JOIN page tp ON cl_from = page_id
INNER JOIN page article ON article.page_namespace = 0 AND article.page_title = tp.page_title
GROUP BY tp.page_title
UNION ALL
SELECT
  tp.page_title, class, article.page_len
FROM (
  SELECT cl_from, "FA" AS class 
  FROM categorylinks qual 
  WHERE qual.cl_to LIKE "FA-Class_%" LIMIT 10
) AS foo
INNER JOIN page tp ON cl_from = page_id
INNER JOIN page article ON article.page_namespace = 0 AND article.page_title = tp.page_title
GROUP BY tp.page_title;
SQL

Checking query status...
