Untitled query #79587

SQL

set
  max_statement_time = 300;

SELECT
    cl_from,
    p.page_id,
    p.page_title,
    cl_to,
    cl_type,
    0 AS level
from
    page as p
join categorylinks cl on cl.cl_from = p.page_id
WHERE
    cl_to = replace('Fatah attacks', ' ', '_') -- Anchor member (root of the hierarchy)
AND
    cl_type = 'subcat'

# categorylinks.pl_from = page.page_id of child
# categorylinks.pl_to = page.page_title of parent
#select * from actor_revision limit 50
#select * from revision_userindex limit 50
#select * from revision limit 50
#select * from comment_revision limit 10
# user_id = actor_user = 45113768
# rev_actor = actor_id = 222965530
# actor_name = user_name = 'General Blorp'
# rev_comment_id = 19459854
SQL

Checking query status...
