SELECT aa.goods_id,aa.ops,aa.guarantee_type_id,bb.ops2 FROM
(SELECT ecm_goods_attr.goods_id, CONCAT( ',', GROUP_CONCAT( DISTINCT (
CASE WHEN (
ecm_goods_attr.attr_name != '估值'
)
THEN (
ecm_goods_attr.attr_value
)
END )
ORDER BY ecm_goods_attr.attr_id ASC
SEPARATOR ',' ) , ','
) AS ops, ecm_goods_ext.guarantee_type_id AS guarantee_type_id
FROM ecm_goods_attr, ecm_goods_ext
WHERE ecm_goods_attr.goods_id = ecm_goods_ext.goods_id
GROUP BY ecm_goods_attr.goods_id
ORDER BY ecm_goods_ext.goods_id) AS aa
JOIN
(SELECT ecm_goods_attr.goods_id, CONCAT( ',', GROUP_CONCAT( DISTINCT (
CASE WHEN (
ecm_goods_attr.attr_name = '估值'
)
THEN (
ecm_goods_attr.attr_value
)
END )
ORDER BY ecm_goods_attr.attr_id ASC
SEPARATOR ',' ) , ','
) AS ops2
FROM ecm_goods_attr, ecm_goods_ext
WHERE ecm_goods_attr.goods_id = ecm_goods_ext.goods_id
GROUP BY ecm_goods_attr.goods_id
ORDER BY ecm_goods_ext.goods_id) AS bb
ON aa.goods_id=bb.goods_id