(),contacts_cstm.last_contact_date_c)为“自上次接触以来的天数”,(从联系人中选择COUNT(reqcl_requiredclientinfo.id),从联系人内部连接= contacts.id左连接reqcl_requiredclientinfo ON reqcl_requiredclientinfo )contacts_reqcl_requiredclientinfo作为联系人的CCS Status继续内部连接contacts_cstm ON contacts_cstm.id_c =