mysql 衍生表必须有别名_MySQL“每个派生表必须有自己的别名”

我对这种奇怪的

MySQL行为感到有些困惑.我收到了可怕的每个派生表必须有自己的别名错误.

通常,我可以通过向主SELECT语句添加AS子句来避免这种情况,但是它看不到使用以下示例：

SELECT SUM (`a`.`total`) AS `total` FROM (

SELECT COUNT(DISTINCT(`item_sales`.`id`)) AS `total`,

(SELECT COUNT(DISTINCT(`sale_item`)) AS `offers` FROM `item_sales_bids` WHERE `user_id` = 2) AS `offers`

FROM `item_sales`

INNER JOIN `item_sales_bids` ON `item_sales`.`id` = `item_sales_bids`.`sale_item`

WHERE `item_sales`.`buyer` != 2

AND `item_sales`.`sold` = 1

GROUP BY `item_sales`.`id`

HAVING `offers` > 0

) UNION (

SELECT COUNT(*) AS `total`,

`item_sales`.`reserve`,

(SELECT COUNT(*) FROM `item_sales_bids` WHERE `user_id` = 2) AS `bids`,

(SELECT MAX(`max_bid`) AS `max` FROM `item_sales_bids` WHERE `user_id` = 2) AS `maxBid`,

SUM((`item_sales`.`list_date` + (`item_sales`.duration * 86400)) - UNIX_TIMESTAMP()) AS `endTime`

FROM `item_sales`

INNER JOIN `item_sales_bids` ON `item_sales_bids`.`sale_item` = `item_sales`.`id`

GROUP BY `item_sales`.`id`

HAVING `endTime` < 0

AND `maxBid` < `item_sales`.`reserve`

)

) `a`

任何人都可以指出我错过了什么？请注意,为连接添加别名会导致相同的错误.