SQLsummary/普通查询/期业绩.sql

SELECT
	P.PERIOD_NUM AS 期数,
	U.USER_NAME AS 会员编号,
	U.REAL_NAME AS 会员姓名,
	P.PV_PCS AS 个人业绩,
	P.PV_PCS_ZC AS 报单业绩,
	P.PV_PCS_FX AS 复消业绩,
	P.PV_1L AS 一市场新增业绩,
	P.PV_1L_ZC AS 一市场报单新增业绩,
	P.PV_1L_FX AS 一市场复消新增业绩,
	P.PV_2L AS 二市场新增业绩,
	P.PV_2L_ZC AS 二市场报单新增业绩,
	P.PV_2L_FX AS 二市场复消新增业绩,
	P.PV_3L AS 三市场新增业绩,
	P.PV_3L_ZC AS 三市场报单新增业绩,
	P.PV_3L_FX AS 三市场复消新增业绩,
	P.SURPLUS_1L AS 一市场结余业绩,
	P.SURPLUS_2L AS 二市场结余业绩,
	P.SURPLUS_3L AS 三市场结余业绩,
	P.SURPLUS_1L_ZC AS 一市场报单结余业绩,
	P.SURPLUS_2L_ZC AS 二市场报单结余业绩,
	P.SURPLUS_3L_ZC AS 三市场报单结余业绩,
	P.SURPLUS_1L_FX AS 一市场复消结余业绩,
	P.SURPLUS_2L_FX AS 二市场复消结余业绩,
	P.SURPLUS_3L_FX AS 三市场复消结余业绩,
	P.PV_PSS AS 团队业绩,
	DATE_FORMAT(FROM_UNIXTIME(P.CREATED_AT),'%Y-%m-%d %H:%i:%s') AS 创建时间
FROM
	AR_PERF_PERIOD P
	LEFT JOIN AR_USER U ON U.ID = P.USER_ID 
WHERE
	p.PERIOD_NUM = 156