https://de.wikipedia.org/w/index.php?title=Kategorie:Crurotarsi has one subcat, but in it's parent category, https://de.wikipedia.org/wiki/Kategorie:Sauropsida, none is shown, just as inn category table. However, categorylinks has the entry that should match.
Any tips?
wikiadmin@10.64.0.163(dewiki)> select * from category where cat_title="Crurotarsi"; +--------+------------+-----------+-------------+-----------+ | cat_id | cat_title | cat_pages | cat_subcats | cat_files | +--------+------------+-----------+-------------+-----------+ | 984830 | Crurotarsi | 21 | 0 | 0 | +--------+------------+-----------+-------------+-----------+ 1 row in set (0.00 sec) wikiadmin@10.64.0.163(dewiki)> select * from categorylinks where cl_from=6568210 and cl_type="subcat"; +---------+------------+------------+---------------------+-------------------+--------------+---------+ | cl_from | cl_to | cl_sortkey | cl_timestamp | cl_sortkey_prefix | cl_collation | cl_type | +---------+------------+------------+---------------------+-------------------+--------------+---------+ | 6568210 | Sauropsida | CRUROTARSI | 2014-10-15 07:21:41 | | uppercase | subcat | +---------+------------+------------+---------------------+-------------------+--------------+---------+ 1 row in set (0.00 sec)