Ok. i have forum there i need to know how much topics i have in partition. The main problem what i have partitions and subpartitions in one table. It seems like this:
partitionid - subpartitionid
1 - 0
2 - 0
3 - 1 // it's mean that this partition is sub partition of 1 one
4 - 3 // 4 is subpartition for 3 and so on....

I don't know how much is the level of subpartitions. This means that i can have tree there i can have subpartition level 10 or more
I need to calculate how much topics for the root of the tree (of the 1 partition)
Can somebody tells me how i can do this?
Thanks in advance!