重庆公司、青岛公司、太原公司、海南公司、济南公司、唐山公司、武汉公司

1.项目

1 014D3916-4DF4-479E-9F16-13E65A4529D1    唐山
2 5EB4BB1E-1560-4B3E-8D39-6FA078BF85F1    海南
3 67AC69CC-84BD-4CD4-A3B1-8913FD27A972    济南
4 9269A850-F4E8-4CA7-B2EC-E0D8D06C142B    青岛
5 CAA9288C-6EAF-4768-88AB-FCA80DFD8BD8    太原
6 7FDFB371-4A99-4D91-A237-FDEE72B51025    重庆
7 7E88F26A-4126-4DCC-9F71-672E054BB4DE    武汉

2.推荐

SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_141 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_142 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_143 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_144 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_145 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_146 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_147 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_148 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_149 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_150 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;
SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_151 a where ProjCode in (SELECT ProjCode from 0221zhenzhoi ) ;

View Code

3.客户

individCst_data_

SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_141 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_141  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_142 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_142  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_143 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_143  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_144 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_144  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_145 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_145  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_146 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_146  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_147 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_147  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_148 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_148  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_149 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_149  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_150 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_150  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));
 
SELECT CstName, Gender, BirthDate,  Language,   CstType,    CardType,   CardID, MobileTel,
OfficeTel,  HomeTel,    Fax,    Email,  PostCode,   Address,    Nationality,    NativePlace,  
SrcType,    LastModifyTime, OriGUID,    CreditEvaluate, CstCode,    Company,    Position,   Incoming, 
CompanyTel, Race,   Religion,   Political,  IsMerried,  LastTouchTime,  RecentTouch,    LastAssignTime,
RecentAssign,   LastAppointTime,    RecentAppoint,
cogniChannel,   Status, MemGUID,    StaffGUID,  OwnerGUID,  level,  CstGUID
from cst_Customer_151 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_151  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

View Code

4.跟进

followRecord_data_

SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_141 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);




SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_142 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_143 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_144 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_145 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_146 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_147 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_148 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_149 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_150 
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);



SELECT DISTINCT followGUID, followType, Description,   
ReceiveDate,    CstGUID,    SrcType ,cstType    ,OriCstGUID,    ProjCode,OppGUID
from cst_FollowRecord_151
where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi);

View Code

posted @ 2016-06-14 20:48 侠之大者kamil 阅读(76) 评论(0) 收藏举报

刷新页面返回顶部

侠之大者

重庆公司、青岛公司、太原公司、海南公司、济南公司、唐山公司、武汉公司

1.项目

2.推荐

3.客户

individCst_data_

4.跟进

followRecord_data_

公告