进入CRM正式环境ETL采集服务器(192.168.103.60)数据库执行以下SQL语句:
SELECT (SELECT CPQC FROM TFP_CPDM WHERE ID =C.CPID),C.GLSP,C.USR_ID,C.YYZT,C.CZYYTJ,C.DJYH,C.SHR,C.* FROM TCPYY C WHERE C.KHMC LIKE '陈长春%'
SELECT * FROM TSPXXB WHERE CPYYID IN (26580);
就可以查看TSPXXB(视频双录的ID)然后从顶点(192.168.103.66)的/home/crm/data/app/tSPXXB的目录下获取相应视频。
select t.*,tk.* from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh
select t.id,t.spmc, ( select cpqc from tfp_cpdm where id= (select cpid from tcpyy tp where id=t.cpyyid) ) ,t.khid,tk.khh,tk.khxm from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh
select t.id,t.spmc,
( select cpqc from tfp_cpdm where id= (select cpid from tcpyy tp where id=t.cpyyid) ),
t.khid,tk.khh,tk.khxm from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh and tk.khxm='赵新亮'
select t.id,t.spmc, t.cpyyid ,t.khid,tk.khh,tk.khxm from tspxxb t,tkhxx tk where (t.khid-1000000000000)=tk.khh
select * from tkhxx
select * from tfp_cpdm where id=32719