链接mysql 504_phpMyAdmin错误代码：504 MySQL查询

我对SQL一般还是比较新的 . 我在phpMyAdmin中尝试以下查询 .

SELECT i.`ITEM_NO` as SKU,

i.`DESCR` as Description,

(SELECT SUM(`QTY_SOLD`)

FROM `ps_tkt_hist_lin`

WHERE `ITEM_NO` = i.`ITEM_NO`

AND `BUS_DAT` >= MAKEDATE(YEAR(CURDATE()),1)

) as 'QTY Sold YTD',

(SELECT SUM(`QTY_SOLD`)

FROM `ps_tkt_hist_lin`

WHERE `ITEM_NO` = i.`ITEM_NO`

AND `BUS_DAT` >= DATE_SUB(DATE_SUB(CURDATE(),INTERVAL (DAY(CURDATE())-1) DAY), INTERVAL 1 MONTH)

) as 'QTY Sold Last Month',

(SELECT SUM(`QTY_ON_HND`)

FROM `IM_INV`

WHERE `ITEM_NO` = i.`ITEM_NO`

AND `LOC_ID` IN ('SL','S','LO','AF')

) as 'QTY on Hand'

FROM `ps_tkt_hist_lin` as i

WHERE i.`ITEM_VEND_NO` = 'MD'

GROUP BY i.`ITEM_NO`, i.`DESCR`

ORDER BY i.`ITEM_NO`

运行时出现以下错误 .

Error in processing request

Error code: 504

Error text: Gateway Time-out (rejected)

It seems that the connection to server has been lost. Please check your network connectivity and server status.

如果有帮助，这是服务器信息：

服务器：通过UNIX套接字的Localhost服务器类型：MariaDB服务器版本：10.1.31-MariaDB - MariaDB服务器cpsrvd 11.68.0.29数据库客户端版本：libmysql - 5.1.73 PHP版本：5.6.30

Thanks in advance for patiently helping a dude just getting started with SQL and MySQL.