56,866
社区成员




SELECT fittingsequipinfo.fittingID, fittingName, price, GROUP_CONCAT( DISTINCT `fittingCategory`
ORDER BY `fittingCategory`
SEPARATOR "," ) AS re,GROUP_CONCAT( `Equipmentamount`
ORDER BY `fittingCategory`
SEPARATOR "," ) AS re2
FROM `fittingsequipinfo`
LEFT JOIN fittingsinfo ON fittingsequipinfo.fittingID = fittingsinfo.fittingID
GROUP BY fittingID