--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------


--
-- Table structure for table `quemsplitlin`
--

CREATE TABLE `quemsplitlin` (
  `id_quemsplitlin` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº tabla split',
  `id_quemsplit` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº Split',
  `ord_quemsplitlin` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº orden',
  `sql_table` char(30) NOT NULL DEFAULT '' COMMENT 'Tabla',
  `num_regs_todo` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº regs a split',
  `sql_count` text NOT NULL COMMENT 'SQL count',
  `sql_count_error` text NOT NULL COMMENT 'Error count',
  `num_regs_moved` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº regs moved',
  `num_regs_deleted` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº regs deleted',
  `sw_split` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'To Split',
  `sw_splited` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Split estado',
  `sql_split` text NOT NULL COMMENT 'SQL split',
  `sql_split_error` text NOT NULL COMMENT 'Error split',
  `fecha_split_ini` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha split ini',
  `hora_split_ini` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora split ini',
  `fecha_split_fin` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha split fin',
  `hora_split_fin` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora split fin',
  UNIQUE KEY `key0` (`id_quemsplitlin`),
  KEY `key1` (`id_quemsplit`,`ord_quemsplitlin`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quemsplitlin`
--

INSERT INTO `quemsplitlin` (`id_quemsplitlin`, `id_quemsplit`, `ord_quemsplitlin`, `sql_table`, `num_regs_todo`, `sql_count`, `sql_count_error`, `num_regs_moved`, `num_regs_deleted`, `sw_split`, `sw_splited`, `sql_split`, `sql_split_error`, `fecha_split_ini`, `hora_split_ini`, `fecha_split_fin`, `hora_split_fin`) VALUES (1,1,1,'quemregipag',579177,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20221031)','',579177,579177,1,2,'INSERT SPYquartup1.quemregipag_vol_202210 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20221031) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20221031) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-01-09','23:01:47','2023-01-09','23:03:05'),(2,1,2,'quemregitra',669566,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20221031)','',669566,669566,1,2,'INSERT SPYquartup1.quemregitra_vol_202210 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20221031) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20221031) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-01-09','23:03:05','2023-01-09','23:05:29'),(3,2,1,'quemregipag',543206,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20221130)','',543206,543206,1,2,'INSERT SPYquartup1.quemregipag_vol_202211 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20221130) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20221130) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-01-09','23:05:51','2023-01-09','23:07:00'),(4,2,2,'quemregitra',646230,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20221130)','',646230,646230,1,2,'INSERT SPYquartup1.quemregitra_vol_202211 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20221130) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20221130) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-01-09','23:07:00','2023-01-09','23:08:48'),(5,3,1,'quemregipag',387909,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20221231)','',387909,387909,1,2,'INSERT SPYquartup1.quemregipag_vol_202212 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20221231) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20221231) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-01-09','23:09:22','2023-01-09','23:10:24'),(6,3,2,'quemregitra',455497,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20221231)','',455497,455497,1,2,'INSERT SPYquartup1.quemregitra_vol_202212 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20221231) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20221231) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-01-09','23:10:24','2023-01-09','23:11:31'),(7,4,1,'quemregipag',480663,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230131)','',480663,480663,1,2,'INSERT SPYquartup1.quemregipag_vol_202301 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230131) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230131) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-04-09','00:06:56','2023-04-09','00:08:03'),(8,4,2,'quemregitra',591976,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230131)','',591976,591976,1,2,'INSERT SPYquartup1.quemregitra_vol_202301 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230131) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230131) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-04-09','00:08:03','2023-04-09','00:09:43'),(9,5,1,'quemregipag',624251,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230228)','',624251,624251,1,2,'INSERT SPYquartup1.quemregipag_vol_202302 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230228) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230228) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-04-09','00:10:20','2023-04-09','00:11:50'),(10,5,2,'quemregitra',714280,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230228)','',714280,714280,1,2,'INSERT SPYquartup1.quemregitra_vol_202302 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230228) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230228) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-04-09','00:11:50','2023-04-09','00:14:18'),(11,6,1,'quemregipag',1262177,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230331)','',1262177,1262177,1,2,'INSERT SPYquartup1.quemregipag_vol_202303 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230331) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230331) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-04-09','00:29:53','2023-04-09','00:32:27'),(12,6,2,'quemregitra',1139615,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230331)','',1139615,1139615,1,2,'INSERT SPYquartup1.quemregitra_vol_202303 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230331) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230331) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-04-09','00:32:27','2023-04-09','00:35:40'),(13,7,1,'quemregipag',1407282,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230430)','',1407282,1407282,1,2,'INSERT SPYquartup1.quemregipag_vol_202304 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230430) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230430) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-08-09','23:42:44','2023-08-09','23:45:57'),(14,7,2,'quemregitra',1169586,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230430)','',1169586,1169586,1,2,'INSERT SPYquartup1.quemregitra_vol_202304 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230430) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230430) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-08-09','23:45:57','2023-08-09','23:49:47'),(15,8,1,'quemregipag',1955161,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230531)','',1955161,1955161,1,2,'INSERT SPYquartup1.quemregipag_vol_202305 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230531) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230531) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-08-09','23:50:42','2023-08-09','23:55:04'),(16,8,2,'quemregitra',1679489,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230531)','',1679489,1679489,1,2,'INSERT SPYquartup1.quemregitra_vol_202305 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230531) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230531) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-08-09','23:55:04','2023-08-10','00:00:11'),(17,9,1,'quemregipag',2056611,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230630)','',2056611,2056611,1,2,'INSERT SPYquartup1.quemregipag_vol_202306 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230630) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230630) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-08-10','00:05:03','2023-08-10','00:09:41'),(18,9,2,'quemregitra',1629232,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230630)','',1629232,1629232,1,2,'INSERT SPYquartup1.quemregitra_vol_202306 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230630) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230630) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-08-10','00:09:41','2023-08-10','00:15:07'),(19,10,1,'quemregipag',1545623,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregipag WHERE (fecha <= 20230731)','',1545623,1545623,1,2,'INSERT SPYquartup1.quemregipag_vol_202307 (id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant) SELECT id_quemregipag, cod_usuario, fecha, hora, milisegundo, id_device, id_navigator, url, id_quemregiips, sql_pid, id_quupsema, sys_load_avg, miliseconds, miliseconds_user, miliseconds_sys, miliseconds_sql, milistenant_sql, milis_serre_sql, num_sentences_sql, num_sentenant_sql, num_sen_serre_sql, input_bytes, output_bytes, max_mem_bytes_real, id_tenant FROM SPYquartup1.quemregipag WHERE (fecha <= 20230731) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregipag WHERE (fecha <= 20230731) ORDER BY quemregipag.id_quemregipag ASC , quemregipag.id_tenant ASC  LIMIT 100000','','2023-08-10','00:28:29','2023-08-10','00:31:42'),(20,10,2,'quemregitra',1357584,'SELECT COUNT(*) AS q FROM SPYquartup1.quemregitra WHERE (fecha <= 20230731)','',1357584,1357584,1,2,'INSERT SPYquartup1.quemregitra_vol_202307 (id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant) SELECT id_mous, id_quemregipag, fichero, tipo_trans, fecha, hora, key_reg, reg_php, id_tenant FROM SPYquartup1.quemregitra WHERE (fecha <= 20230731) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000\n\nDELETE FROM SPYquartup1.quemregitra WHERE (fecha <= 20230731) ORDER BY quemregitra.id_mous ASC , quemregitra.id_tenant ASC  LIMIT 100000','','2023-08-10','00:31:42','2023-08-10','00:35:31');


