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;
select page_title from page where page_id in ('343155423');
## 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_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 cat_id as id from category where cat_title = @cat
  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';
SQL

Checking query status...
