title: Query on the result of another query giving errors
body: <p>I'm trying to run a query on the result set of another query but getting errors which I cannot understand. I'm sure it's something small but I'm somehow missing it. This is the query:</p>
  
  <pre><code>SELECT
    RLID,
    NAME,
    GROUP_CONCAT(SUBQUERY.Items SEPARATOR ', ') AS Items
  FROM
    (
    SELECT
      `rel_menu_item`.`ID` AS `RLID`,
      `menu`.`Name` AS `Menu_Name`,
      `item`.`Name` AS `Items`
    FROM
      `rel_menu_item`
    JOIN
      `menu` ON `menu`.`ID` = `rel_menu_item`.`Menu_ID`
    JOIN
      `item` ON `item`.`ID` = `rel_menu_item`.`Item_ID`
  ) AS SUBQUERY
  GROUP BY
    SUBQUERY.Name
  </code></pre>
  
  <p><strong>Errors:</strong></p>
  
  <blockquote>
    <p>3 errors were found during analysis.</p>
    
    <ol>
    <li>An expression was expected. (near "(" at position 90)</li>
    <li>Unexpected token. (near "(" at position 90)</li>
    <li>This type of clause was previously parsed. (near "SELECT" at position 95)</li>
    </ol>
  </blockquote>