SELECT hh.lcourt_doc_running, ht.send_doc_running
FROM hcase_historical hh
INNER JOIN hjudgement hj ON hh.run_id=hj.run_id
INNER JOIN hjudgement_times ht ON hj.red_running=ht.red_running
WHERE 1 AND hh.event_type=4


UPDATE hcase_historical hh
INNER JOIN hdocument hd ON hh.lcourt_doc_running = hd.doc_running
INNER JOIN hjudgement hj ON hh.run_id = hj.run_id
INNER JOIN hjudgement_times ht ON hj.red_running = ht.red_running
SET ht.send_doc_running=hd.doc_running, ht.send_read_date=hd.send_rcv_date
WHERE 1 
AND hh.event_type =4

SELECT hd.doc_running
FROM hcase_historical hh
INNER JOIN hcase hc ON hh.lrun_id=AES_DECRYPT(hc.lrun_id, '9d4c2f6')
INNER JOIN hdocument hd ON hh.lcourt_doc_running = hd.doc_running
INNER JOIN hjudgement hj ON hc.run_id = hj.run_id
INNER JOIN hjudgement_times ht ON hj.red_running = ht.red_running
WHERE 1 
AND hh.event_type =4

SELECT hd.doc_running
UPDATE hcase_historical hh
INNER JOIN hcase hc ON AES_ENCRYPT( hh.lrun_id,  '9d4c2f6' ) = hc.lrun_id
INNER JOIN hdocument hd ON hh.lcourt_doc_running = hd.doc_running
INNER JOIN hjudgement hj ON hc.run_id = hj.run_id
INNER JOIN hjudgement_times ht ON hj.red_running = ht.red_running
SET ht.send_doc_running=hd.doc_running, ht.send_read_date=hd.send_rcv_date
WHERE 1 
AND hh.event_type =4
AND ht.send_doc_running IS NULL 


UPDATE hjudgement_times ht 
INNER JOIN hdocument hd ON ht.send_doc_running= hd.doc_running
SET ht.send_read_date=hd.send_rcv_date
WHERE 1