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