Container categories with pages not in subcategories on huwiki

This query is marked as a draft This query has been published by FoBe.

SQL

SELECT concat( '[[:Kategória:', cat_title, ']]' ) as cat_title, cat_pages - cat_subcats
FROM huwiki_p.categorylinks
INNER JOIN huwiki_p.page ON cl_from = page_id
INNER JOIN huwiki_p.category on cat_title = page_title
WHERE cl_to = 'Gyűjtőkategóriák'
AND  cl_type = 'subcat'
AND  cat_pages > cat_subcats
ORDER BY (cat_pages - cat_subcats) DESC, cat_title ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...