“我的产品中增加类目筛选”的版本间的差异

[
  "vip/product/getLvl3Cate",
  {
    "adminMemberSeq": "14",
    "statDate": "2018-10-13"
  }
]

[
  "vip/product/getEffectiveProducts",
  {
    "adminMemberSeq": "200042360",
    "statDate": "2018-10-13",
    "statisticsType": "day",
    "level3CateId": "1458"
  }
]

create table `sc_alidata_[0000-0015].dwp_en_dm_vip_compcate_d_[[0000-0216]]` (
  `id` bigint  not null auto_increment comment '主键',
  `stat_date` date comment '统计日期',
  `admin_mbr_seq` bigint comment '会员SEQ',
  `admin_mbr_id` varchar(100) comment '会员ID',
  `comp_id` bigint comment '公司ID',
  `cate_id` bigint comment '产品发布类目ID【关联维表icbucdm.dim_en_pcate_v】【关联键cate_id】',
  `itm_cnt_std_009` bigint comment '历史截至当日商品数',
  `rank_std_001` bigint comment '历史截止当日商品数排序',
  `cate_desc` varchar(200) comment '行业描述',
  primary key (id),
  key `idx_admin_mbr_id` (stat_date,admin_mbr_seq)
) default charset=utf8mb4 comment='每个分区包含公司发布商品的行业指标';

SELECT * FROM `dwp_en_dm_vip_compcate_d_0026` WHERE admin_mbr_id = 'aliqatest01'

-- 查询cate_lv3_id字段
SELECT * FROM `dwp_en_dm_vip_prod_eff_d_0026` WHERE cate_lv3_id IS NOT NULL