SELECT
C.color_id,
C.color_name,
C.color_sort,
V.count
FROM
T_ITEM_COLOR as C
left join (
SELECT
t_item_color.color_id,
count(V_ITEM.*) as count
FROM
T_ITEM_COLOR
LEFT JOIN
V_ITEM
ON
V_ITEM.color_category = t_item_color.color_id
WHERE
V_ITEM.register_type = 1
and V_ITEM.category_id =
GROUP BY
t_item_color.color_id
) as V
ON
V.color_id = C.color_id
WHERE
V.count is not NULL and
C.is_color_category = 1
ORDER BY
C.color_sort
;
ERROR: syntax error at or near "GROUP" at character 415 PRODUCT - デザインＴシャツストア グラニフ - Design Tshirts Store graniph
