self-categorized categories - Commons

SQL

SELECT
  REPLACE(page_title, '_', ' ') as category_name,
  cat_pages as cat_size,
  IF (cat_pages = 1,
      "-",
      IF (cat_pages = cat_subcats,
      	  "S",
      	  IF(cat_pages = cat_files -1, "F", "S+F"))
  ) AS cat_content,
  page_len AS text_size,
  actor_name AS last_user,
  LEFT(rev_timestamp, 12) AS last_edit,
  DATEDIFF(NOW(), rev_timestamp) AS age,
  length(page_title) AS len_name,
  page_is_new AS is_new,
  page_id
FROM
  revision_userindex
  JOIN (
    SELECT
      page_id,
      page_title,
      page_len,
      page_is_new
    FROM
      page
      JOIN categorylinks ON cl_to = page_title
    WHERE
      page_id = cl_from
      AND page_namespace = 14
      AND page_id <> 3617544
  ) AS pagetmp ON rev_page = pagetmp.page_id
  JOIN actor_revision ON rev_actor = actor_id
  JOIN category ON cat_title = pagetmp.page_title AND rev_timestamp = (
    SELECT
      MAX(rev_timestamp)
    FROM
      revision AS last
    WHERE
      last.rev_page = pagetmp.page_id
  )
ORDER BY
  page_id DESC
SQL

Checking query status...
