[{"id":"15","data":"[2018-06-14 18:21:11] - 1:UPDATE vantec.part SET last_updated_by=ZZZ WHERE part_number LIKE(%PARTA%)<\/li>"},{"id":"16","data":"[2018-06-14 18:21:14] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND last_updated < 2017-09-01 AND EXISTS(SELECT id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"17","data":"[2018-06-14 18:37:43] - 1:UPDATE vantec.part SET last_updated_by=ZZZ WHERE part_number LIKE(%PARTA%)<\/li>"},{"id":"18","data":"[2018-06-14 18:38:14] - 1:DELETE FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"19","data":"[2018-06-14 21:11:22] - 1:DELETE FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"20","data":"[2018-06-14 21:11:25] - 1:DELETE FROM vantec.document_body WHERE document_bodyl.id>0 AND document_bodyl.last_updated < 2017-09-01 AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"21","data":"[2018-06-14 21:11:28] - 1:DELETE FROM vantec.document_header WHERE document_header.id>0 AND document_header.last_updated < 2017-09-01 AND document_header.document_reference LIKE(PCK%)<\/li>"},{"id":"22","data":"[2018-06-14 21:19:02] - 1:DELETE FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"23","data":"[2018-06-14 21:19:05] - 1:DELETE FROM vantec.document_body WHERE document_bodyl.id>0 AND document_bodyl.last_updated < 2017-09-01 AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%))<\/li>"},{"id":"24","data":"[2018-06-14 21:19:08] - 1:DELETE FROM vantec.document_header WHERE document_header.id>0 AND document_header.last_updated < 2017-09-01 AND document_header.document_reference LIKE(PCK%)<\/li>"},{"id":"25","data":"[2018-06-14 21:22:46] - 1:DELETE FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"26","data":"[2018-06-15 08:39:27] - 1:DELETE FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"27","data":"[2018-06-15 09:23:08] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%))) WITH DATA<\/li>"},{"id":"28","data":"[2018-06-15 09:25:22] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))) WITH DATA<\/li>"},{"id":"29","data":"[2018-06-15 09:30:26] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))) WITH DATA<\/li>"},{"id":"30","data":"[2018-06-15 09:33:03] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%))))<\/li>"},{"id":"31","data":"[2018-06-15 09:38:08] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%))))<\/li>"},{"id":"32","data":"[2018-06-15 09:43:12] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%))))<\/li>"},{"id":"33","data":"[2018-06-15 09:48:17] - 1:CREATE TABLE vantec.temp AS(SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%))))<\/li>"},{"id":"34","data":"[2018-06-15 09:58:02] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id AND document_header.document_reference_code LIKE(PCK%)))<\/li>"},{"id":"35","data":"[2018-06-15 11:33:23] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id))<\/li>"},{"id":"36","data":"[2018-06-15 11:40:31] - 1:DELETE FROM vantec.document_detail WHERE EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"37","data":"[2018-06-15 11:44:16] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"38","data":"[2018-06-15 11:48:51] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"39","data":"[2018-06-15 11:54:38] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"40","data":"[2018-06-15 12:00:41] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"41","data":"[2018-06-15 12:03:01] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"42","data":"[2018-06-15 12:07:01] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"43","data":"[2018-06-15 12:07:40] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.requirement_detail_id IS null AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id))<\/li>"},{"id":"44","data":"[2018-06-15 12:13:58] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"45","data":"[2018-06-15 12:19:11] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND requirement_detail_id IS null AND EXISTS(SELECT temp_id FROM vantec.temp WHERE id=temp_id)<\/li>"},{"id":"46","data":"[2018-06-15 12:24:20] - 1:DELETE FROM vantec.document_detail a WHERE a.id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE a.id=temp_id) AND NOT EXISTS(SELECT id FROM vantec.document_detail b WHERE a.requirement_detail_id=b.id)<\/li>"},{"id":"47","data":"[2018-06-15 12:27:35] - 1:DELETE FROM vantec.document_detail a WHERE a.id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE a.id=temp_id) AND NOT EXISTS(SELECT DUMMY FROM vantec.document_detail b WHERE a.requirement_detail_id=b.id)<\/li>"},{"id":"48","data":"[2018-06-15 12:29:22] - 1:DELETE FROM vantec.document_detail a WHERE a.id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE a.id=temp_id) AND NOT EXISTS(SELECT DUMMY FROM vantec.document_detail b WHERE a.requirement_detail_id=b.id)<\/li>"},{"id":"49","data":"[2018-06-15 12:33:06] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id) AND NOT EXISTS(SELECT DUMMY FROM vantec.document_detail b WHERE document_detail.requirement_detail_id=b.id)<\/li>"},{"id":"50","data":"[2018-06-15 12:33:54] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id) AND NOT EXISTS(SELECT DUMMY FROM vantec.document_detail b WHERE document_detail.requirement_detail_id=b.id)<\/li>"},{"id":"51","data":"[2018-06-15 12:40:33] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"52","data":"[2018-06-15 12:40:36] - 1:TRUNCATE vantec.temp<\/li>"},{"id":"53","data":"[2018-06-15 12:40:38] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.requirement_detail_id IS NULL AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id))<\/li>"},{"id":"54","data":"[2018-06-15 12:42:19] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"55","data":"[2018-06-15 12:42:24] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"56","data":"[2018-06-15 12:43:09] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.requirement_detail_id IS NULL AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id))<\/li>"},{"id":"57","data":"[2018-06-15 12:47:29] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"58","data":"[2018-06-15 12:57:03] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"59","data":"[2018-06-15 12:57:03] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"60","data":"[2018-06-15 12:57:44] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.requirement_detail_id IS NULL AND document_detail.last_updated < 2017-09-01 AND EXISTS(SELECT document_body.id FROM vantec.document_body WHERE document_detail.document_body_id=document_body.id AND EXISTS(SELECT document_header.id FROM vantec.document_header WHERE document_body.document_header_id=document_header.id))<\/li>"},{"id":"61","data":"[2018-06-15 12:57:47] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"62","data":"[2018-06-15 13:00:38] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"63","data":"[2018-06-15 13:10:00] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"64","data":"[2018-06-15 13:10:05] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"65","data":"[2018-06-15 13:10:06] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01<\/li>"},{"id":"66","data":"[2018-06-15 13:10:07] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"67","data":"[2018-06-15 13:10:09] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"68","data":"[2018-06-15 13:14:40] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"69","data":"[2018-06-15 13:15:15] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01<\/li>"},{"id":"70","data":"[2018-06-15 13:15:17] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"71","data":"[2018-06-15 13:20:37] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"72","data":"[2018-06-15 13:20:53] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"73","data":"[2018-06-15 13:20:55] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01<\/li>"},{"id":"74","data":"[2018-06-15 13:20:56] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"75","data":"[2018-06-15 13:20:57] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"76","data":"[2018-06-15 13:20:58] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"77","data":"[2018-06-15 13:21:34] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01<\/li>"},{"id":"78","data":"[2018-06-15 13:21:57] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"79","data":"[2018-06-15 14:09:45] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"80","data":"[2018-06-15 14:16:00] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"81","data":"[2018-06-15 14:27:23] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"82","data":"[2018-06-15 14:27:42] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"83","data":"[2018-06-15 14:27:50] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01<\/li>"},{"id":"84","data":"[2018-06-15 14:28:57] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"85","data":"[2018-06-15 14:28:57] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"86","data":"[2018-06-15 14:29:00] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"87","data":"[2018-06-15 14:29:01] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"88","data":"[2018-06-15 14:29:04] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"89","data":"[2018-06-15 14:29:04] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"90","data":"[2018-06-15 14:29:58] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"91","data":"[2018-06-15 14:29:58] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"92","data":"[2018-06-15 14:30:52] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"93","data":"[2018-06-15 14:32:55] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"94","data":"[2018-06-15 14:32:55] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"95","data":"[2018-06-15 14:32:58] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"96","data":"[2018-06-15 14:32:58] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"97","data":"[2018-06-15 14:33:02] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"98","data":"[2018-06-15 14:33:02] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"99","data":"[2018-06-15 14:33:56] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"100","data":"[2018-06-15 14:33:56] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"101","data":"[2018-06-15 14:34:49] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"102","data":"[2018-06-15 14:40:01] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"103","data":"[2018-06-15 14:40:01] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"104","data":"[2018-06-15 14:40:03] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"105","data":"[2018-06-15 14:40:03] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"106","data":"[2018-06-15 14:40:05] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"107","data":"[2018-06-15 14:40:05] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"108","data":"[2018-06-15 14:40:05] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"109","data":"[2018-06-15 14:40:05] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"110","data":"[2018-06-15 14:40:36] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"111","data":"[2018-06-15 14:42:22] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"112","data":"[2018-06-15 14:42:22] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"113","data":"[2018-06-15 14:42:24] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"114","data":"[2018-06-15 14:42:24] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"115","data":"[2018-06-15 14:42:26] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"116","data":"[2018-06-15 14:42:26] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"117","data":"[2018-06-15 14:42:27] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01 LIMIT 10000<\/li>"},{"id":"118","data":"[2018-06-15 14:42:27] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"119","data":"[2018-06-15 14:42:57] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"120","data":"[2018-06-15 14:45:48] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"121","data":"[2018-06-15 14:45:48] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"122","data":"[2018-06-15 14:45:50] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 LIMIT 50000<\/li>"},{"id":"123","data":"[2018-06-15 14:45:50] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"124","data":"[2018-06-15 14:45:52] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"125","data":"[2018-06-15 14:45:52] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"126","data":"[2018-06-15 14:45:53] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01 LIMIT 50000<\/li>"},{"id":"127","data":"[2018-06-15 14:45:54] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"128","data":"[2018-06-15 14:46:38] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"},{"id":"129","data":"[2018-06-15 14:47:25] - 1:UPDATE vantec.document_detail SET requirement_detail_id=null WHERE last_updated < 2017-09-01 AND requirement_detail_id IS NOT null<\/li>"},{"id":"130","data":"[2018-06-15 14:47:25] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"131","data":"[2018-06-15 14:47:33] - 1:INSERT INTO vantec.temp SELECT document_detail.id AS temp_id FROM vantec.document_detail WHERE document_detail.id>0 AND document_detail.last_updated < 2017-09-01 LIMIT 50000<\/li>"},{"id":"132","data":"[2018-06-15 14:47:33] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_detail WHERE temp_id=requirement_detail_id)<\/li>"},{"id":"133","data":"[2018-06-15 14:47:42] - 1:DELETE FROM vantec.document_detail WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_detail.id=temp_id)<\/li>"},{"id":"134","data":"[2018-06-15 14:47:42] - 1:DELETE FROM vantec.temp WHERE temp_id > 0<\/li>"},{"id":"135","data":"[2018-06-15 14:47:44] - 1:INSERT INTO vantec.temp SELECT document_body.id AS temp_id FROM vantec.document_body WHERE document_body.id>0 AND document_body.last_updated < 2017-09-01 LIMIT 50000<\/li>"},{"id":"136","data":"[2018-06-15 14:47:45] - 1:DELETE FROM vantec.temp WHERE temp_id > 0 AND EXISTS(SELECT id FROM vantec.document_body WHERE temp_id=requirement_body_id)<\/li>"},{"id":"137","data":"[2018-06-15 14:48:49] - 1:DELETE FROM vantec.document_body WHERE id>0 AND EXISTS(SELECT temp_id FROM vantec.temp WHERE document_body.id=temp_id)<\/li>"}]