mysql - 来自两个表的 GROUP_CONCAT

Question

我有这么大的选择，问题是来自不同表的 2 个 GROUP_CONCAT。如果我从选择的颜色中删除描述正常显示，如果我保持这种颜色显示 x3 次。

SELECT
DISTINCT m.model as model
        ,m.price as price
        ,m.size as size
        ,m.colorsetIDMainBag as mainColor
    ,GROUP_CONCAT(colorset.name) AS color
    ,leather.name AS leather
        ,leather.nameUA AS leatherUA
        ,leather.nameRU AS leatherRU
    ,GROUP_CONCAT(description.descriptionUA) AS descriptionUA
    ,GROUP_CONCAT(description.descriptionRU) AS descriptionRU
    ,GROUP_CONCAT(description.descriptionEN) AS descriptionEN
FROM
        bags as m
        LEFT OUTER JOIN colorpack
        on m.bagsID=colorpack.colorpack
        LEFT OUTER JOIN color
        on colorpack.colorID=color.colorID
        LEFT OUTER JOIN colorset
        on color.colorsetID=colorset.colorsetID
        LEFT OUTER JOIN leather
        on color.leatherID=leather.leatherID

        LEFT OUTER JOIN descriptionpack
        on m.bagsID=descriptionpack.descriptionpack
        LEFT OUTER JOIN description
        on descriptionpack.descriptionID=description.descriptionID

WHERE
        colorpack.colorpack='62'
GROUP BY model

Answer 1

尝试

GROUP_CONCAT(DISTINCT colorset.name) AS color

我假设您知道您正在对 GROUP BY 使用非标准的 MySQL 扩展，这通常会产生不可预测和奇怪的结果。如果您不知道，请阅读此内容。

http://dev.mysql.com/doc/refman/5.1/en/group-by-extensions.html