| SQL | SELECT distinct g.goods_id, g.collect_base,g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb ,g.goods_img FROM `comyuedang`.`ecs_goods` AS g LEFT JOIN `comyuedang`.`ecs_member_price` AS mp ON mp.goods_id=g.goods_id AND mp.user_rank='0' WHERE g.is_on_sale=1 AND g.is_alone_sale=1 AND g.is_delete=0 and g.goods_img!="" order by rand() LIMIT 12 |