“KP工作台数据漏斗”的版本间的差异
来自qingwei personal wiki
Qingwei727(讨论 | 贡献) (创建页面,内容为“== 描述 == [https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone] category: 阿里 category: 数…”) |
Qingwei727(讨论 | 贡献) |
||
第1行: | 第1行: | ||
== 描述 == | == 描述 == | ||
[https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone] | [https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone] | ||
− | + | == oneService == | |
+ | <source lang="shell"> | ||
+ | SELECT | ||
+ | admin_mbr_seq | ||
+ | FROM | ||
+ | dwp_en_dm_comp_term_catelv2_eff_d | ||
+ | where | ||
+ | stat_date="2018-10-8" | ||
+ | and statistic_type="day" | ||
+ | and terminal_type="PC" | ||
+ | and admin_mbr_seq="14" | ||
+ | and is_main_cate="Y" | ||
+ | and cate_lv2_id=123 | ||
+ | </source> | ||
[[category: 阿里]] | [[category: 阿里]] | ||
[[category: 数据管家]] | [[category: 数据管家]] |
2018年11月9日 (五) 06:07的版本
描述
oneService
SELECT
admin_mbr_seq
FROM
dwp_en_dm_comp_term_catelv2_eff_d
where
stat_date="2018-10-8"
and statistic_type="day"
and terminal_type="PC"
and admin_mbr_seq="14"
and is_main_cate="Y"
and cate_lv2_id=123