[Labs-l] Separating "content" categorizes from organizational categories

[Maarten Dammers]

Hi,

Op 15-3-2016 om 8:41 schreef Guilherme Gonçalves:
> I think most categories you'd call organizational (or maintenance) 
> categories will be subcategories of [[Category:Hidden categories]], so 
> you can query for that. There might be a more precise way to do it, 
> but that's how I've been distinguishing the two.

On quite a few wiki's (at least Commons) all non-topic (what you call 
organizational) categories should be hidden categories. I hope you're 
not doing recursive queries. You can see if a category is hidden in the 
page_props table. For example:

MariaDB [enwiki_p]> SELECT * FROM page JOIN page_props ON 
page_id=pp_page AND 
page_title='All_articles_covered_by_WikiProject_Wikify' AND 
page_namespace=14 AND page_is_redirect=0 LIMIT 1;
+----------+----------------+--------------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+----------+-------------+----------+------------+
| page_id  | page_namespace | page_title                                 
| page_restrictions | page_counter | page_is_redirect | page_is_new | 
page_random    | page_touched   | page_links_updated | page_latest | 
page_len | page_content_model | pp_page  | pp_propname | pp_value | 
pp_sortkey |
+----------+----------------+--------------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+----------+-------------+----------+------------+
| 36624356 |             14 | All_articles_covered_by_WikiProject_Wikify 
| |            0 |                0 |           0 | 0.204521342345 | 
20160315234552 | 20160123181102     |   546385235 |      261 | 
wikitext           | 36624356 | hiddencat   |          |       NULL |
+----------+----------------+--------------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+----------+-------------+----------+------------+
1 row in set (0.52 sec)

Maarten