Untitled query #79587

SQL

set
  max_statement_time = 300;
#select * from category where cat_title = replace('Fatah attacks', ' ', '_');
select 
cl_from, 
cl_type, 
page_title, 
#cat_id, 
cl_to
from page
join categorylinks on cl_from = page_id
#join category on cl_to = cat_title
where cl_to = 'Fatah_attacks' 
and cl_type = 'subcat'
and page_namespace = 0

# 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...
