WITH RECURSIVE entries (page_title, page_id, page_namespace, inc, parent_title, parent_namespace, page_len) AS (

  (

    SELECT page_title, page_id, page_namespace, 1, page_title, page_namespace, page_len

    FROM page

    WHERE page_title IN ("Populated_places_in_Azerbaijan_by_district")

      AND page_namespace = 14

  )

  UNION

  (

    SELECT child.page_title, child.page_id, child.page_namespace, inc + 1, parent.page_title, parent.page_namespace, child.page_len

    FROM page AS child

    JOIN categorylinks as childLinks ON child.page_id = childLinks.cl_from

    JOIN entries AS parent ON childLinks.cl_to = parent.page_title

    LEFT JOIN page_props ON childLinks.cl_from = pp_page AND pp_propname = "hiddencat"

    WHERE (child.page_namespace = 14

      OR child.page_namespace = 0)

      AND parent.page_namespace = 14

      AND pp_propname IS NULL

      AND page_is_redirect = 0

      #AND inc < 4

  )

),

articles AS (

  SELECT *

  FROM entries

  JOIN revision_userindex on page_id = rev_page

  WHERE rev_parent_id = 0

    AND rev_actor = 10795

    AND page_namespace = 0

)

​

SELECT DISTINCT(page_title), page_len, rev_len, (CAST(page_len AS SIGNED) - CAST(rev_len AS SIGNED)) as Growth, rev_timestamp

FROM articles

ORDER BY page_title ASC