A common table expression that refers to itself in a FROM clause from the fullselect. Recursive common table expressions are used to write recursive queries.