イタリア自動車雑貨店 | イタリア車のパーツとグッズの公式オンラインショップ

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) and category_id in () and brand_id='4' 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