Find missing category for ids

SQL

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

#select * from category where cat_title = @cat limit 100;
## all subcats as page_ids
#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 from category where cat_title = @cat
  '50922774'
  union all
  select cl_from 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...
