SELECT * FROM `shop_product` a INNER JOIN shop_multi_category b ON a.goods_idx = b.product_id where 1 and b.category_id in ( SELECT mc FROM shop_category where lft >= '' AND rgt <= '' ORDER BY `lft` ASC ) AND goods_view=0 AND (goods_type = '' OR goods_type = 'SHOP' ) GROUP BY product_id order by goods_sub_idx desc limit 0,