| SQL | SELECT DISTINCT g.goods_id,g.* FROM `shop`.`ecs_goods` AS g, `shop`.`ecs_supplier_goods_cat` AS gc, `shop`.`ecs_supplier_cat_recommend` AS cr
WHERE cr.recommend_type =1 AND cr.supplier_id =1 AND cr.cat_id = gc.cat_id AND gc.goods_id = g.goods_id
AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0
ORDER BY g.sort_order, g.last_update DESC LIMIT 4 |