|
|
select * from
(select *,count(*) as cnt from
(select brand_id,brand_name_en,brand_sort_no
from goods_desc
where show=1 and not(stock_type=1 and stock=0) and type_id in (1,2,3)
and category_id in () and brand_id='1'
group by brand_id,brand_name_en,brand_sort_no,goods_id,color_id) as t
group by brand_id,brand_name_en,brand_sort_no) as tt
where cnt<>0 order by brand_sort_no
商品情報を選択できませんでした:sm1
|
|