https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/subqueries/subqueries-in-a-from-clause-derived-tables
Subqueries in a FROM Clause (Derived Tables) | Server | MariaDB Documentation
Use a subquery as a temporary table. Derived tables allow you to select from the result set of another query within the FROM clause.
tables server mariadbclause
https://jira.mariadb.org/browse/MDEV-31466
[MDEV-31466] Add optional correlation column list for derived tables - Jira
derived tablesmdevaddoptional