Untitled query #38105

SQL

use skwiki_p;

SELECT
    COUNT(*) AS count
  FROM
    page,
    categorylinks
  WHERE
    page_namespace = 0 AND
    cl_from = page_id AND
    cl_to = page_title  -- eponymous cat.
  ;

SELECT
    COUNT(*)
  FROM
    page pa,
    categorylinks,
    page pc
  WHERE
    pa.page_namespace = 0 AND
    cl_from = pa.page_id AND
    cl_to = pa.page_title AND  -- eponymous cat.
    pc.page_namespace = 14 AND
    pc.page_title = cl_to AND
    (SELECT COUNT(*) - 1 FROM categorylinks WHERE cl_from = pa.page_id) < 
    (SELECT COUNT(*) FROM categorylinks WHERE cl_from = pc.page_id)
  ;
  
SELECT
    (SELECT COUNT(*) FROM categorylinks WHERE cl_from = page_id) AS cat_count,
    COUNT(*) AS count
  FROM
    page,
    categorylinks
  WHERE
    page_namespace = 0 AND
    cl_from = page_id AND
    cl_to = page_title  -- eponymous cat.
  GROUP BY
    cat_count
  ORDER BY
    cat_count
  ;
SQL

Checking query status...
