insert into `comyuedang`.`ecs_category` (ruleCategory,cat_name,parent_id) select cat_id,cat_name,parent_id from `comyuedang`.`ecs_supplier_category` as a where supplier_id='368' and (select count(1) as num from `comyuedang`.`ecs_category` where ruleCategory = a.cat_id) = 0 and is_show=1 order by cat_id
update `comyuedang`.`ecs_category` a,`comyuedang`.`ecs_category` b set a.parent_id = b.cat_id where a.ruleCategory>0 and b.ruleCategory = a.parent_id and a.parent_id>0
update `comyuedang`.`ecs_goods` a, `comyuedang`.`ecs_category` b, `comyuedang`.`ecs_supplier_goods_cat` c set a.cat_id = b.cat_id where c.goods_id=a.goods_id and c.cat_id=b.ruleCategory and b.ruleCategory>0 and c.supplier_id='368' and a.cat_id='332' and c.id in (select id from `comyuedang`.`ecs_supplier_goods_cat` where supplier_id='368' group by goods_id)
insert into `comyuedang`.`ecs_goods_cat` (goods_id,cat_id) select c.goods_id,b.cat_id from `comyuedang`.`ecs_goods` a, `comyuedang`.`ecs_category` b, `comyuedang`.`ecs_supplier_goods_cat` c where c.goods_id=a.goods_id and c.cat_id=b.ruleCategory and b.ruleCategory>0 and c.supplier_id='368' and (select count(1) as num from `comyuedang`.`ecs_goods_cat` where goods_id=c.goods_id and cat_id=b.cat_id ) = 0 and c.id not in (select id from `comyuedang`.`ecs_supplier_goods_cat` where supplier_id='368' group by goods_id)婴儿礼盒_童装_母婴用品_悦当YUEDANG.COM-悦!我喜欢
温馨提示

确定取消
温馨提示

关闭
您尚未登录

用户登陆

忘记密码?
商品
历史查询删除记录
您还没有搜过任何内容哦~!
真遗憾,没有搜到匹配的结果哦~!

为你推荐

根据你购买浏览记录专门推荐

为你推荐

根据你购买浏览记录专门推荐

婴儿礼盒
亲,真的没有更多内容了,只能帮你到这啦~!
悦当商城官方微信

现在扫描二维码,更多精彩活动等着你哦!

服务时间:09:00 - 21:00

客服热线:

客服QQ:

本站文字、图片、程序等版权均属于悦当商城所有,未经同意不得用于商业用途。
ICP备案证书号:粤ICP备19126544号 © 2005-2020 悦当网络 版权所有,并保留所有权利。