Certain SELECT statements are so complicated that they are separated into several internal SELECT steps.
For SELECT statements of this type, the EXPLAIN statement outputs several search strategies. In this output, INTERNAL TEMPORARY RESULT is given as the table name. Searches through internal temporary results of this type can only ever be performed sequentially.