Untitled query #84640

SQL

WITH RECURSIVE get_name_dabs (page_title, page_id, page_namespace, inc, parent_title, parent_namespace) AS (
  (
    SELECT page_title, page_id, page_namespace, 1, page_title, page_namespace
    FROM page
    WHERE page_title IN ("Israel–Hamas_war")
      AND page_namespace = 14
  )
  UNION
  (
    SELECT child.page_title, child.page_id, child.page_namespace, inc + 1, parent.page_title, parent.page_namespace
    FROM page AS child
    JOIN categorylinks as childLinks ON child.page_id = childLinks.cl_from
    JOIN get_name_dabs 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 inc < 8
  )
),

pages AS (
  SELECT talk.page_title, talk.page_id
  FROM get_name_dabs AS article 
  JOIN page AS talk ON talk.page_title = article.page_title WHERE talk.page_namespace = 1
  WHERE article.page_namespace = 0
  UNION
  SELECT page_title, page_id
  FROM get_name_dabs
)

SELECT actor_name, page_title, LEFT(rev_timestamp, 8) as date, LEFT(rev_timestamp, 10) as hour
FROM pages
JOIN revision on rev_page = page_id
JOIN actor on rev_actor = actor_id
WHERE page_namespace = 0
GROUP BY hour, date, page_title, actor_name
SQL

Checking query status...
