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