The SQL standard defines multiple ways of phrasing subqueries. One of them is called “table expression” (aka “inline view”).
The case you are talking about is a simple table expressions in the form:
SELECT * FROM (<subquery>) <alias> WHERE <condition>
In your case const
is the alias.
solved Where in the MySQL doc could I find an explanation of const