vanke推荐客户查询推荐时间

推荐客户查询推荐时间

SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_150 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_141 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_142 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_143 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_144 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_145 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_146 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_147 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_148 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_149 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID
union ALL
SELECT a.CstGUID,a.AgentGUID,a.ProjCode,a.createTime as '创建时间戳',
FROM_UNIXTIME(a.createTime) as '创建时间',
a.modifyTime as '更新时间',
FROM_UNIXTIME(a.modifyTime) as '更新时间戳'
 from prm_Agent_Cst_Recommed_151 a
JOIN `1111111111111111` b 
on b.agentGUID=a.AgentGUID 
and a.ProjCode = b.projCode
and a.CstGUID = b.cstGUID