Mysql 8 recursive query with two mandatory parents
I am working with a hierarchy problem where the nodes have two parents and need get only the nodes where both parents are in the result. In the happy world, this query would be perfect WITH RECURSIVE granters (id, parents)…