MySQL Error Message
In recursive query block of Recursive Common Table
Expression ‘%s’, the recursive table must neither be in the right
argument of a LEFT JOIN, nor be forced to be non-first with join
order hints
Reason for the Error
ER_CTE_RECURSIVE_FORBIDDEN_JOIN_ORDER
was added in 8.0.1.