Find missing category for ids

SQL

use commonswiki_p;
describe category;
set @cat := 'Tag_des_Denkmals_2016';
describe page;
#describe image;
#describe user;

#select * from category where cat_title = @cat limit 100;
## all subcats as page_ids
#select page_title from page where page_id in (select cat_id from category where cat_title = @cat);
#select page_id from page where page_title = @cat;
#select page_title from page where page_id in (select cl_from from categorylinks where cl_type = 'subcat' and cl_to = @cat);

#select page_title from page
#where page_id in (
  #select page_id, page_title from page where page_title = @cat and page_namespace=14
  #union all
  #select cl_from as id from categorylinks where cl_type = 'subcat' and cl_to = @cat
#  );

#gt_lat, gt_lon, gt_page_id, gt_name, (select page_title from page where page_id = gt_page_id),gt_country,gt_region from geo_tags
#where gt_lat='0' AND gt_lon='0';
#  select page_id, page_title from page inner join categorylinks on page.page_id = categorylinks.cl_from where page_title = @cat and page_namespace=14

SELECT (page_title as super, page_id as id) FROM page, (cl_to as sub) FROM categorylinks
   INNER JOIN categorylinks ON page_id = cl_from
   #INNER JOIN category ON cl_to = cat_title
   WHERE page_title = @cat and page_namespace=14 AND (page_is_redirect=0)
   LIMIT 50;
SQL

Checking query status...
