Untitled query #79587

SQL

# get the category hierarchy
with recursive CategoryHierarchy as (
select cl_from, cl_to, cl_type, page_id, page_title, 0 as level
from categorylinks join page on cl_from = page_id
where cl_to = "Palestine Liberation Organization" #"Fatah_attacks" #replace("Palestine Liberation Organization", " ", "_")
and cl_type = 'subcat'
union
select c.cl_from, c.cl_to, c.cl_type, p.page_id, p.page_title, ch.level + 1 
from categorylinks c join page p on c.cl_from = p.page_id
join CategoryHierarchy ch on c.cl_to = ch.page_title -- Recursive
where c.cl_type = 'subcat'
and ch.level <= 2
)
select cl_from, cl_to, cl_type, page_id, page_title, level
from CategoryHierarchy
#where level <= 2


# cat_id = 249081020 for Fatah_attacks
#select page_id from page where page_title = 'Fatah_attacks' and page_namespace = 0;
# 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...
