81,122
社区成员




SELECT
g
FROM
Goods g
WHERE
1 = 1
AND g.category.id = : categoryId
AND g.isOutOfSale = : isOutOfSale
ORDER BY
(
SELECT
IFNULL(SUM(og.number), 0)
FROM
OrderGoods og
WHERE
g.id = og.goods.id
AND og. ORDER .isValid = TRUE
) DESC
SELECT
g
FROM
Goods g
WHERE
1 = 1
AND (
g.goodsName LIKE : keyWord
OR g.goodsShortName LIKE : keyWord
OR g.goodsSn LIKE : keyWord
)
AND g.isOutOfSale = : isOutOfSale
ORDER BY
CAST(
(
SELECT
COALESCE (SUM(og.number), 0) AS sales
FROM
OrderGoods og
WHERE
g.id = og.goods.id
AND og. ORDER .isValid = TRUE
) AS INT
) DESC
我改成这样还是不行啊,是我写错了吗?大神能不能帮我修改一下呢?