Bug #3396 A SUB-QUERY IN MYSQL 4.1.1.max.log MAKE SERVER DOWN :_(

Submitted:	5 Apr 2004 16:57	Modified:	29 Mar 2011 18:22
Reporter:	Roberto Spadim (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.1	OS:	Linux (LINUX)
Assigned to:		CPU Architecture:	Any

Description:
SUB-QUERY MAKE SERVER TO HALT OR BROKE
SLOW LOG:
# Time: 040405 20:20:53
# User@Host: rspadim[rspadim] @  [200.206.160.28]
# Query_time: 17  Lock_time: 0  Rows_sent: 0  Rows_examined: 1101
SELECT data_operacao,data_vencimento,sacado_tipo,sacado_id,documento,valor,valor_residual 
FROM movimento_baixas 
WHERE 
(sacador_tipo='j' AND sacador_id=1) AND 
(operacao,documento,data_operacao) IN 
	(
		SELECT operacao,documento,if((sacador_tipo='j' AND sacador_id=1),MAX(data_operacao),'0000-00-00 00:00:00')
		FROM 
		movimento_baixas 
		WHERE 
		((sacado_tipo='j' AND sacado_id=1) OR (sacador_tipo='j' AND sacador_id=1)) 
		AND 
		(data_operacao<='0000-00-06 05:05:46') 
		AND operacao=102 
		GROUP BY operacao,documento
	);

How to repeat:
-- MySQL dump 8.22
--
-- Host: 172.16.0.1    Database: spd_fluxocaixa
---------------------------------------------------------
-- Server version	4.1.1-alpha-max-log

--
-- Table structure for table 'movimento_baixas'
--

CREATE TABLE movimento_baixas (
  documento_id varchar(75) NOT NULL default '',
  documento_show varchar(75) NOT NULL default '',
  digitador_tipo enum('f','j') NOT NULL default 'f',
  digitador_id double NOT NULL default '0',
  operacao tinyint(3) unsigned NOT NULL default '0',
  operacao_show tinyint(3) unsigned NOT NULL default '0',
  documento varchar(50) NOT NULL default '',
  sit_titulo_movimento enum('cv','ie','ma','tr','mp','r','?') NOT NULL default '?',
  titulo_unidade double NOT NULL default '0',
  titulo_bordero double NOT NULL default '0',
  titulo_partida enum('c','p') NOT NULL default 'c',
  valor double NOT NULL default '0',
  valor_liquido double NOT NULL default '0',
  liquidez tinyint(3) unsigned NOT NULL default '0',
  custo_operacao double NOT NULL default '0',
  dias_compensacao smallint(6) unsigned NOT NULL default '0',
  data_compensacao date NOT NULL default '0000-00-00',
  data_vencimento date NOT NULL default '0000-00-00',
  data_operacao datetime NOT NULL default '0000-00-00 00:00:00',
  sacado_tipo enum('f','j') NOT NULL default 'f',
  sacado_id double NOT NULL default '0',
  conta_sacado double NOT NULL default '0',
  sacador_tipo enum('f','j') NOT NULL default 'f',
  sacador_id double NOT NULL default '0',
  conta_sacador double NOT NULL default '0',
  valor_residual double NOT NULL default '0',
  conta_contabil_sacado double NOT NULL default '0',
  conta_contabil_sacador double NOT NULL default '0',
  PRIMARY KEY  (documento_id),
  UNIQUE KEY documento (operacao,documento,data_operacao),
  KEY sacado_operacao (sacado_tipo,sacado_id,conta_sacado,data_operacao,liquidez,operacao_show),
  KEY sacador_operacao (sacador_tipo,sacador_id,conta_sacador,data_operacao,liquidez,operacao_show),
  KEY sacado_vencimento (sacado_tipo,sacado_id,conta_sacado,data_vencimento,liquidez,operacao_show),
  KEY sacador_vencimento (sacador_tipo,sacador_id,conta_sacador,data_vencimento,liquidez,operacao_show),
  KEY sacado_compensacao (sacado_tipo,sacado_id,conta_sacado,data_compensacao,liquidez,operacao_show),
  KEY sacador_compensacao (sacador_tipo,sacador_id,conta_sacador,data_compensacao,liquidez,operacao_show)
) TYPE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table 'movimento_baixas'
--

INSERT INTO movimento_baixas VALUES ('102.18.356.1299.90029760.11147.16-03-2004 00:00:00','102.18.356.1299.90029760.11147.16-03-2004 00:00:00','j',3569,102,102,'18.356.1299.90029760.11147','',1,7,'c',290.7,290.7,0,0,3,'0000-00-00','2004-05-09','2004-03-16 00:00:00','f',11170,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.559.1036959.783702.16-03-2004 00:00:00','102.18.33.559.1036959.783702.16-03-2004 00:00:00','j',3569,102,102,'18.33.559.1036959.783702','',1,7,'c',53,53,0,0,3,'0000-00-00','2004-05-15','2004-03-16 00:00:00','f',11169,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.5023261.975486.16-03-2004 00:00:00','102.18.33.3.5023261.975486.16-03-2004 00:00:00','j',3569,102,102,'18.33.3.5023261.975486','',1,7,'c',165,165,0,0,3,'0000-00-00','2004-05-13','2004-03-16 00:00:00','f',11168,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.1089582.921936.16-03-2004 00:00:00','102.18.33.3.1089582.921936.16-03-2004 00:00:00','j',3569,102,102,'18.33.3.1089582.921936','',1,7,'c',110,110,0,0,3,'0000-00-00','2004-05-12','2004-03-16 00:00:00','f',11167,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.756.4295.1038.459538.16-03-2004 00:00:00','102.18.756.4295.1038.459538.16-03-2004 00:00:00','j',3569,102,102,'18.756.4295.1038.459538','',1,7,'c',250,250,0,0,3,'0000-00-00','2004-05-12','2004-03-16 00:00:00','f',11166,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.756.4295.1038.459537.16-03-2004 00:00:00','102.18.756.4295.1038.459537.16-03-2004 00:00:00','j',3569,102,102,'18.756.4295.1038.459537','',1,7,'c',250,250,0,0,3,'0000-00-00','2004-04-12','2004-03-16 00:00:00','f',11166,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.258.77133198.12063.16-03-2004 00:00:00','102.18.356.258.77133198.12063.16-03-2004 00:00:00','j',3569,102,102,'18.356.258.77133198.12063','',1,7,'c',214,214,0,0,3,'0000-00-00','2004-05-20','2004-03-16 00:00:00','f',11145,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.93.956943.21845.16-03-2004 00:00:00','102.18.356.93.956943.21845.16-03-2004 00:00:00','j',3569,102,102,'18.356.93.956943.21845','',1,7,'c',150,150,0,0,3,'0000-00-00','2004-04-20','2004-03-16 00:00:00','j',11145,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.5487.1005215.3281.16-03-2004 00:00:00','102.18.151.5487.1005215.3281.16-03-2004 00:00:00','j',3569,102,102,'18.151.5487.1005215.3281','',1,7,'c',600,600,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11150,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.103233.291309.16-03-2004 00:00:00','102.18.1.50.103233.291309.16-03-2004 00:00:00','j',3569,102,102,'18.1.50.103233.291309','',1,7,'c',255,255,0,0,3,'0000-00-00','2004-05-05','2004-03-16 00:00:00','j',11144,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.146.91949.17.16-03-2004 00:00:00','102.18.237.146.91949.17.16-03-2004 00:00:00','j',3569,102,102,'18.237.146.91949.17','',1,7,'c',185,185,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11149,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.680.1001675.999592.16-03-2004 00:00:00','102.18.33.680.1001675.999592.16-03-2004 00:00:00','j',3569,102,102,'18.33.680.1001675.999592','',1,7,'c',309,309,0,0,3,'0000-00-00','2004-05-09','2004-03-16 00:00:00','f',11152,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.46.5051467.967778.16-03-2004 00:00:00','102.18.33.46.5051467.967778.16-03-2004 00:00:00','j',3569,102,102,'18.33.46.5051467.967778','',1,7,'c',162,162,0,0,3,'0000-00-00','2004-05-20','2004-03-16 00:00:00','f',11157,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.237.72.20223.8268.16-03-2004 00:00:00','102.9.237.72.20223.8268.16-03-2004 00:00:00','j',3569,102,102,'9.237.72.20223.8268','',1,7,'c',35,35,0,0,3,'0000-00-00','2004-05-30','2004-03-16 00:00:00','f',11161,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.101104.915900.16-03-2004 00:00:00','102.18.33.3.101104.915900.16-03-2004 00:00:00','j',3569,102,102,'18.33.3.101104.915900','',1,7,'c',117,117,0,0,3,'0000-00-00','2004-05-25','2004-03-16 00:00:00','f',11163,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.172.1004733.1263.16-03-2004 00:00:00','102.18.151.172.1004733.1263.16-03-2004 00:00:00','j',3569,102,102,'18.151.172.1004733.1263','',1,7,'c',290,290,0,0,3,'0000-00-00','2004-05-15','2004-03-16 00:00:00','f',11147,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.2698.52663.850177.16-03-2004 00:00:00','102.18.1.2698.52663.850177.16-03-2004 00:00:00','j',3569,102,102,'18.1.2698.52663.850177','',1,7,'c',250,250,0,0,3,'0000-00-00','2004-04-20','2004-03-16 00:00:00','f',11148,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.103233.291308.16-03-2004 00:00:00','102.18.1.50.103233.291308.16-03-2004 00:00:00','j',3569,102,102,'18.1.50.103233.291308','',1,7,'c',255,255,0,0,3,'0000-00-00','2004-04-05','2004-03-16 00:00:00','j',11144,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.291.119.2464087.923.16-03-2004 00:00:00','102.18.291.119.2464087.923.16-03-2004 00:00:00','j',3569,102,102,'18.291.119.2464087.923','',1,7,'c',125,125,0,0,3,'0000-00-00','2004-05-25','2004-03-16 00:00:00','f',11146,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.291.119.2464087.922.16-03-2004 00:00:00','102.18.291.119.2464087.922.16-03-2004 00:00:00','j',3569,102,102,'18.291.119.2464087.922','',1,7,'c',125,125,0,0,3,'0000-00-00','2004-04-25','2004-03-16 00:00:00','f',11146,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.23.139020.447.16-03-2004 00:00:00','102.18.237.23.139020.447.16-03-2004 00:00:00','j',3569,102,102,'18.237.23.139020.447','',1,7,'c',500,500,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','j',11143,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.258.77133198.12062.16-03-2004 00:00:00','102.18.356.258.77133198.12062.16-03-2004 00:00:00','j',3569,102,102,'18.356.258.77133198.12062','',1,7,'c',214,214,0,0,3,'0000-00-00','2004-04-22','2004-03-16 00:00:00','f',11145,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.2698.52663.850178.16-03-2004 00:00:00','102.18.1.2698.52663.850178.16-03-2004 00:00:00','j',3569,102,102,'18.1.2698.52663.850178','',1,7,'c',250,250,0,0,3,'0000-00-00','2004-05-20','2004-03-16 00:00:00','f',11148,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.93.9569430.21846.16-03-2004 00:00:00','102.18.356.93.9569430.21846.16-03-2004 00:00:00','j',3569,102,102,'18.356.93.9569430.21846','',1,7,'c',150,150,0,0,3,'0000-00-00','2004-05-20','2004-03-16 00:00:00','j',11145,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.145122.200518.16-03-2004 00:00:00','102.18.1.50.145122.200518.16-03-2004 00:00:00','j',3569,102,102,'18.1.50.145122.200518','',1,7,'c',270,270,0,0,3,'0000-00-00','2004-05-11','2004-03-16 00:00:00','j',11146,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.13019397.926775.16-03-2004 00:00:00','102.18.33.3.13019397.926775.16-03-2004 00:00:00','j',3569,102,102,'18.33.3.13019397.926775','',1,7,'c',270,270,0,0,3,'0000-00-00','2004-04-11','2004-03-16 00:00:00','j',11146,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.146.91949.18.16-03-2004 00:00:00','102.18.237.146.91949.18.16-03-2004 00:00:00','j',3569,102,102,'18.237.146.91949.18','',1,7,'c',185,185,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11149,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.420212.850798.16-03-2004 00:00:00','102.18.1.50.420212.850798.16-03-2004 00:00:00','j',3569,102,102,'18.1.50.420212.850798','',1,7,'c',275,275,0,0,3,'0000-00-00','2004-04-15','2004-03-16 00:00:00','f',10720,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.5487.1005215.3280.16-03-2004 00:00:00','102.18.151.5487.1005215.3280.16-03-2004 00:00:00','j',3569,102,102,'18.151.5487.1005215.3280','',1,7,'c',600,600,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11150,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.470.151939.850132.16-03-2004 00:00:00','102.18.1.470.151939.850132.16-03-2004 00:00:00','j',3569,102,102,'18.1.470.151939.850132','',1,7,'c',313,313,0,0,3,'0000-00-00','2004-04-15','2004-03-16 00:00:00','f',11151,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.470.151939.850133.16-03-2004 00:00:00','102.18.1.470.151939.850133.16-03-2004 00:00:00','j',3569,102,102,'18.1.470.151939.850133','',1,7,'c',313,313,0,0,3,'0000-00-00','2004-05-15','2004-03-16 00:00:00','f',11151,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.680.1001675.999591.16-03-2004 00:00:00','102.18.33.680.1001675.999591.16-03-2004 00:00:00','j',3569,102,102,'18.33.680.1001675.999591','',1,7,'c',309,309,0,0,3,'0000-00-00','2004-04-09','2004-03-16 00:00:00','f',11152,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.107.1017774.101.16-03-2004 00:00:00','102.18.151.107.1017774.101.16-03-2004 00:00:00','j',3569,102,102,'18.151.107.1017774.101','',1,7,'c',100,100,0,0,3,'0000-00-00','2004-04-03','2004-03-16 00:00:00','f',11153,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.75.412007.5.16-03-2004 00:00:00','102.18.341.75.412007.5.16-03-2004 00:00:00','j',3569,102,102,'18.341.75.412007.5','',1,7,'c',185,185,0,0,3,'0000-00-00','2004-05-07','2004-03-16 00:00:00','f',11154,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.201.55024.736.16-03-2004 00:00:00','102.18.237.201.55024.736.16-03-2004 00:00:00','j',3569,102,102,'18.237.201.55024.736','',1,7,'c',127,127,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11155,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.201.55024.737.16-03-2004 00:00:00','102.18.237.201.55024.737.16-03-2004 00:00:00','j',3569,102,102,'18.237.201.55024.737','',1,7,'c',127,127,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11155,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.143.4000433.2512.16-03-2004 00:00:00','102.18.151.143.4000433.2512.16-03-2004 00:00:00','j',3569,102,102,'18.151.143.4000433.2512','',1,7,'c',118,118,100,0,3,'0000-00-00','2004-03-25','2004-03-16 00:00:00','j',11147,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.143.4000433.2513.16-03-2004 00:00:00','102.18.151.143.4000433.2513.16-03-2004 00:00:00','j',3569,102,102,'18.151.143.4000433.2513','',1,7,'c',118,118,0,0,3,'0000-00-00','2004-04-25','2004-03-16 00:00:00','j',11147,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.143.4000433.2514.16-03-2004 00:00:00','102.18.151.143.4000433.2514.16-03-2004 00:00:00','j',3569,102,102,'18.151.143.4000433.2514','',1,7,'c',117,117,0,0,3,'0000-00-00','2004-05-25','2004-03-16 00:00:00','j',11147,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.46.5051467.967777.16-03-2004 00:00:00','102.18.33.46.5051467.967777.16-03-2004 00:00:00','j',3569,102,102,'18.33.46.5051467.967777','',1,7,'c',162,162,0,0,3,'0000-00-00','2004-04-20','2004-03-16 00:00:00','f',11157,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.1981.6576.148.16-03-2004 00:00:00','102.18.237.1981.6576.148.16-03-2004 00:00:00','j',3569,102,102,'18.237.1981.6576.148','',1,7,'c',117,117,0,0,3,'0000-00-00','2004-04-12','2004-03-16 00:00:00','f',11158,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.1981.6576.149.16-03-2004 00:00:00','102.18.237.1981.6576.149.16-03-2004 00:00:00','j',3569,102,102,'18.237.1981.6576.149','',1,7,'c',117,117,0,0,3,'0000-00-00','2004-05-12','2004-03-16 00:00:00','f',11158,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.78.12630.5188.16-03-2004 00:00:00','102.18.237.78.12630.5188.16-03-2004 00:00:00','j',3569,102,102,'18.237.78.12630.5188','',1,7,'c',400,400,100,0,3,'0000-00-00','2004-04-01','2004-03-16 00:00:00','f',11159,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.78.12630.5189.16-03-2004 00:00:00','102.18.237.78.12630.5189.16-03-2004 00:00:00','j',3569,102,102,'18.237.78.12630.5189','',1,7,'c',400,400,0,0,3,'0000-00-00','2004-04-30','2004-03-16 00:00:00','f',11159,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.78.12630.5190.16-03-2004 00:00:00','102.18.237.78.12630.5190.16-03-2004 00:00:00','j',3569,102,102,'18.237.78.12630.5190','',1,7,'c',400,400,0,0,3,'0000-00-00','2004-05-30','2004-03-16 00:00:00','f',11159,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.1.47.51876.850279.16-03-2004 00:00:00','102.9.1.47.51876.850279.16-03-2004 00:00:00','j',3569,102,102,'9.1.47.51876.850279','',1,7,'c',130,130,0,0,3,'0000-00-00','2004-04-12','2004-03-16 00:00:00','f',11160,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.1.47.51876.850280.16-03-2004 00:00:00','102.9.1.47.51876.850280.16-03-2004 00:00:00','j',3569,102,102,'9.1.47.51876.850280','',1,7,'c',130,130,0,0,3,'0000-00-00','2004-05-12','2004-03-16 00:00:00','f',11160,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.237.72.20223.8267.16-03-2004 00:00:00','102.9.237.72.20223.8267.16-03-2004 00:00:00','j',3569,102,102,'9.237.72.20223.8267','',1,7,'c',35,35,0,0,3,'0000-00-00','2004-04-30','2004-03-16 00:00:00','f',11161,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.15.92020287.792521.16-03-2004 00:00:00','102.18.33.15.92020287.792521.16-03-2004 00:00:00','j',3569,102,102,'18.33.15.92020287.792521','',1,7,'c',82,82,0,0,3,'0000-00-00','2004-04-18','2004-03-16 00:00:00','f',11162,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.15.92020287.792522.16-03-2004 00:00:00','102.18.33.15.92020287.792522.16-03-2004 00:00:00','j',3569,102,102,'18.33.15.92020287.792522','',1,7,'c',82,82,0,0,3,'0000-00-00','2004-05-18','2004-03-16 00:00:00','f',11162,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.273.9160.850293.16-03-2004 00:00:00','102.18.1.273.9160.850293.16-03-2004 00:00:00','j',3569,102,102,'18.1.273.9160.850293','',1,7,'c',349,349,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11164,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.119.1460038.468.16-03-2004 00:00:00','102.18.151.119.1460038.468.16-03-2004 00:00:00','j',3569,102,102,'18.151.119.1460038.468','',1,7,'c',221.6,221.6,100,0,3,'0000-00-00','2004-04-01','2004-03-16 00:00:00','f',11165,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.273.9160.850294.16-03-2004 00:00:00','102.18.1.273.9160.850294.16-03-2004 00:00:00','j',3569,102,102,'18.1.273.9160.850294','',1,7,'c',349,349,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11164,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.2825.714.841.15-03-2004 00:00:00','102.18.237.2825.714.841.15-03-2004 00:00:00','f',9109,102,102,'18.237.2825.714.841','',1,2,'c',375,375,100,0,3,'0000-00-00','2004-04-12','2004-03-15 00:00:00','f',9116,0,'j',1,2,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.2825.842.0.15-03-2004 00:00:00','102.18.237.2825.842.0.15-03-2004 00:00:00','f',9109,102,102,'18.237.2825.842.0','',1,2,'c',375,375,100,0,3,'0000-00-00','2004-05-13','2004-03-15 00:00:00','f',9116,0,'j',1,2,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.172.1004733.1262.16-03-2004 00:00:00','102.18.151.172.1004733.1262.16-03-2004 00:00:00','j',3569,102,102,'18.151.172.1004733.1262','',1,7,'c',290,290,0,0,3,'0000-00-00','2004-04-15','2004-03-16 00:00:00','f',11147,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.389.604.1500251.726.16-03-2004 00:00:00','102.18.389.604.1500251.726.16-03-2004 00:00:00','j',3569,102,102,'18.389.604.1500251.726','',1,7,'c',298,298,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11156,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.420212.850799.16-03-2004 00:00:00','102.18.1.50.420212.850799.16-03-2004 00:00:00','j',3569,102,102,'18.1.50.420212.850799','',1,7,'c',275,275,0,0,3,'0000-00-00','2004-05-15','2004-03-16 00:00:00','f',11149,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.107.1017774.102.16-03-2004 00:00:00','102.18.151.107.1017774.102.16-03-2004 00:00:00','j',3569,102,102,'18.151.107.1017774.102','',1,7,'c',100,100,0,0,3,'0000-00-00','2004-05-03','2004-03-16 00:00:00','f',11153,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.389.604.1500251.725.16-03-2004 00:00:00','102.18.389.604.1500251.725.16-03-2004 00:00:00','j',3569,102,102,'18.389.604.1500251.725','',1,7,'c',298,298,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11156,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.101104.915899.16-03-2004 00:00:00','102.18.33.3.101104.915899.16-03-2004 00:00:00','j',3569,102,102,'18.33.3.101104.915899','',1,7,'c',117,117,0,0,3,'0000-00-00','2004-04-25','2004-03-16 00:00:00','f',11163,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.119.1460038.469.16-03-2004 00:00:00','102.18.151.119.1460038.469.16-03-2004 00:00:00','j',3569,102,102,'18.151.119.1460038.469','',1,7,'c',221.6,221.6,0,0,3,'0000-00-00','2004-05-01','2004-03-16 00:00:00','f',11165,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.46.1075508.921111.16-03-2004 00:00:00','102.18.33.46.1075508.921111.16-03-2004 00:00:00','f',3115,102,102,'18.33.46.1075508.921111','',1,10,'c',460,460,100,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',4864,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.275.337.703217.11331.16-03-2004 00:00:00','102.48.275.337.703217.11331.16-03-2004 00:00:00','j',2554,102,102,'48.275.337.703217.11331','',1,13,'c',500,500,0,0,3,'0000-00-00','2004-04-05','2004-03-16 00:00:00','f',11183,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.563.1008999.2527.16-03-2004 00:00:00','102.48.104.563.1008999.2527.16-03-2004 00:00:00','j',2554,102,102,'48.104.563.1008999.2527','',1,13,'c',300,300,0,0,3,'0000-00-00','2004-05-20','2004-03-16 00:00:00','f',11182,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.563.1008999.2526.16-03-2004 00:00:00','102.48.104.563.1008999.2526.16-03-2004 00:00:00','j',2554,102,102,'48.104.563.1008999.2526','',1,13,'c',300,300,0,0,3,'0000-00-00','2004-06-20','2004-03-16 00:00:00','f',11182,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.3397.66915.850048.16-03-2004 00:00:00','102.18.1.3397.66915.850048.16-03-2004 00:00:00','j',2554,102,102,'18.1.3397.66915.850048','',1,13,'c',100,100,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11185,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.3397.66915.850045.16-03-2004 00:00:00','102.18.1.3397.66915.850045.16-03-2004 00:00:00','j',2554,102,102,'18.1.3397.66915.850045','',1,13,'c',100,100,0,0,3,'0000-00-00','2004-06-10','2004-03-16 00:00:00','f',11185,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.3397.66915.850044.16-03-2004 00:00:00','102.18.1.3397.66915.850044.16-03-2004 00:00:00','j',2554,102,102,'18.1.3397.66915.850044','',1,13,'c',100,100,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11185,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.275.337.703217.11332.16-03-2004 00:00:00','102.48.275.337.703217.11332.16-03-2004 00:00:00','j',2554,102,102,'48.275.337.703217.11332','',1,13,'c',500,500,0,0,3,'0000-00-00','2004-05-05','2004-03-16 00:00:00','f',11183,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2096.290300.850238.16-03-2004 00:00:00','102.33.1.2096.290300.850238.16-03-2004 00:00:00','j',2554,102,102,'33.1.2096.290300.850238','',1,13,'c',117,117,0,0,3,'0000-00-00','2004-04-12','2004-03-16 00:00:00','f',11184,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2096.290300.850239.16-03-2004 00:00:00','102.33.1.2096.290300.850239.16-03-2004 00:00:00','j',2554,102,102,'33.1.2096.290300.850239','',1,13,'c',117,117,0,0,3,'0000-00-00','2004-05-12','2004-03-16 00:00:00','f',11184,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2096.290300.850240.16-03-2004 00:00:00','102.33.1.2096.290300.850240.16-03-2004 00:00:00','j',2554,102,102,'33.1.2096.290300.850240','',1,13,'c',117,117,0,0,3,'0000-00-00','2004-06-12','2004-03-16 00:00:00','f',11184,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.341.861.362192.202742.16-03-2004 00:00:00','102.33.341.861.362192.202742.16-03-2004 00:00:00','j',2554,102,102,'33.341.861.362192.202742','',1,13,'c',90,90,0,0,3,'0000-00-00','2004-04-16','2004-03-16 00:00:00','f',11186,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2353.7968.850005.16-03-2004 00:00:00','102.33.1.2353.7968.850005.16-03-2004 00:00:00','j',2554,102,102,'33.1.2353.7968.850005','',1,13,'c',100,100,0,0,3,'0000-00-00','2004-05-10','2004-03-16 00:00:00','f',11187,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2353.79685.850004.16-03-2004 00:00:00','102.33.1.2353.79685.850004.16-03-2004 00:00:00','j',2554,102,102,'33.1.2353.79685.850004','',1,13,'c',100,100,0,0,3,'0000-00-00','2004-04-10','2004-03-16 00:00:00','f',11187,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1273.10398.724907.16-03-2004 00:00:00','102.18.399.1273.10398.724907.16-03-2004 00:00:00','j',2554,102,102,'18.399.1273.10398.724907','',1,13,'c',150,150,0,0,3,'0000-00-00','2004-06-27','2004-03-16 00:00:00','f',11188,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.356.824.824.37063901.14443.16-03-2004 00:00:00','102.356.824.824.37063901.14443.16-03-2004 00:00:00','j',2554,102,102,'356.824.824.37063901.14443','',1,13,'c',380,380,0,0,3,'0000-00-00','2004-04-06','2004-03-16 00:00:00','f',11192,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.152.59803.850115.16-03-2004 00:00:00','102.33.1.152.59803.850115.16-03-2004 00:00:00','j',2554,102,102,'33.1.152.59803.850115','',1,13,'c',313.4,313.4,0,0,3,'0000-00-00','2004-04-20','2004-03-16 00:00:00','f',11190,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.237.1902.2572.4388.16-03-2004 00:00:00','102.48.237.1902.2572.4388.16-03-2004 00:00:00','j',2554,102,102,'48.237.1902.2572.4388','',1,13,'c',393,393,0,0,3,'0000-00-00','2004-04-13','2004-03-16 00:00:00','f',11189,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.3305.544.101638.905887.16-03-2004 00:00:00','102.18.3305.544.101638.905887.16-03-2004 00:00:00','j',2554,102,102,'18.3305.544.101638.905887','',1,13,'c',150,150,0,0,3,'0000-00-00','2004-09-15','2004-03-16 00:00:00','f',11181,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.563.1008999.2525.16-03-2004 00:00:00','102.48.104.563.1008999.2525.16-03-2004 00:00:00','j',2554,102,102,'48.104.563.1008999.2525','',1,13,'c',300,300,0,0,3,'0000-00-00','2004-04-20','2004-03-16 00:00:00','f',11182,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1273.103986.724908.16-03-2004 00:00:00','102.18.399.1273.103986.724908.16-03-2004 00:00:00','j',2554,102,102,'18.399.1273.103986.724908','',1,13,'c',150,150,0,0,3,'0000-00-00','2004-07-27','2004-03-16 00:00:00','f',11188,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.341.861.362192.202741.16-03-2004 00:00:00','102.33.341.861.362192.202741.16-03-2004 00:00:00','j',2554,102,102,'33.341.861.362192.202741','',1,13,'c',90,90,0,0,3,'0000-00-00','2004-05-16','2004-03-16 00:00:00','f',11186,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.347.316.241420.2725.16-03-2004 00:00:00','102.18.347.316.241420.2725.16-03-2004 00:00:00','j',2554,102,102,'18.347.316.241420.2725','',1,13,'c',300,300,0,0,3,'0000-00-00','2004-04-13','2004-03-16 00:00:00','f',11191,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.44.74653.352.16-03-2004 00:00:00','102.18.237.44.74653.352.16-03-2004 00:00:00','j',2554,102,102,'18.237.44.74653.352','',1,13,'c',168,168,0,0,3,'0000-00-00','2004-07-15','2004-03-16 00:00:00','f',11180,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.44.74653.351.16-03-2004 00:00:00','102.18.237.44.74653.351.16-03-2004 00:00:00','j',2554,102,102,'18.237.44.74653.351','',1,13,'c',168,168,0,0,3,'0000-00-00','2004-06-15','2004-03-16 00:00:00','f',11180,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.44.74653.350.16-03-2004 00:00:00','102.18.237.44.74653.350.16-03-2004 00:00:00','j',2554,102,102,'18.237.44.74653.350','',1,13,'c',168,168,0,0,3,'0000-00-00','2004-05-15','2004-03-16 00:00:00','f',11180,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.44.74653.349.16-03-2004 00:00:00','102.18.237.44.74653.349.16-03-2004 00:00:00','j',2554,102,102,'18.237.44.74653.349','',1,13,'c',168,168,0,0,3,'0000-00-00','2004-04-15','2004-03-16 00:00:00','f',11180,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2372.311561.850414.16-03-2004 00:00:00','102.33.1.2372.311561.850414.16-03-2004 00:00:00','j',2554,102,102,'33.1.2372.311561.850414','',1,13,'c',120,120,0,0,3,'0000-00-00','2004-06-09','2004-03-16 00:00:00','f',11179,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.104.383.3000458.437.16-03-2004 00:00:00','102.9.104.383.3000458.437.16-03-2004 00:00:00','j',2554,102,102,'9.104.383.3000458.437','',1,13,'c',315,315,0,0,3,'0000-00-00','2004-07-15','2004-03-16 00:00:00','j',11153,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.341.341.3711.51312.830706.16-03-2004 00:00:00','102.341.341.3711.51312.830706.16-03-2004 00:00:00','j',2554,102,102,'341.341.3711.51312.830706','',1,13,'c',246,246,0,0,3,'0000-00-00','2004-05-15','2004-03-16 00:00:00','f',11178,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.182.237.41.11691.45.16-03-2004 00:00:00','102.182.237.41.11691.45.16-03-2004 00:00:00','j',2554,102,102,'182.237.41.11691.45','',1,13,'c',270,270,0,0,3,'0000-00-00','2004-09-15','2004-03-16 00:00:00','f',10245,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.41.11691.49.16-03-2004 00:00:00','102.18.237.41.11691.49.16-03-2004 00:00:00','j',2554,102,102,'18.237.41.11691.49','',1,13,'c',120,120,0,0,3,'0000-00-00','2005-01-15','2004-03-16 00:00:00','f',10245,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.41.11691.48.16-03-2004 00:00:00','102.18.237.41.11691.48.16-03-2004 00:00:00','j',2554,102,102,'18.237.41.11691.48','',1,13,'c',270,270,0,0,3,'0000-00-00','2004-12-15','2004-03-16 00:00:00','f',10245,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.41.11691.47.16-03-2004 00:00:00','102.18.237.41.11691.47.16-03-2004 00:00:00','j',2554,102,102,'18.237.41.11691.47','',1,13,'c',270,270,0,0,3,'0000-00-00','2004-11-15','2004-03-16 00:00:00','f',10245,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.41.11691.46.16-03-2004 00:00:00','102.18.237.41.11691.46.16-03-2004 00:00:00','j',2554,102,102,'18.237.41.11691.46','',1,13,'c',270,270,0,0,3,'0000-00-00','2004-10-15','2004-03-16 00:00:00','f',10245,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.1.100.81272.850096.16-03-2004 00:00:00','102.9.1.100.81272.850096.16-03-2004 00:00:00','j',2554,102,102,'9.1.100.81272.850096','',1,13,'c',246,246,0,0,3,'0000-00-00','2004-09-15','2004-03-16 00:00:00','f',11177,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.330.1.2353.251518.850383.16-03-2004 00:00:00','102.330.1.2353.251518.850383.16-03-2004 00:00:00','j',2554,102,102,'330.1.2353.251518.850383','',1,13,'c',200,200,0,0,3,'0000-00-00','2004-11-13','2004-03-16 00:00:00','f',11176,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2353.251518.850384.16-03-2004 00:00:00','102.33.1.2353.251518.850384.16-03-2004 00:00:00','j',2554,102,102,'33.1.2353.251518.850384','',1,13,'c',100,100,0,0,3,'0000-00-00','2004-12-13','2004-03-16 00:00:00','f',11176,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.2353.251518.850382.16-03-2004 00:00:00','102.33.1.2353.251518.850382.16-03-2004 00:00:00','j',2554,102,102,'33.1.2353.251518.850382','',1,13,'c',200,200,0,0,3,'0000-00-00','2004-09-13','2004-03-16 00:00:00','f',11176,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.3806.3806.94978.850091.16-03-2004 00:00:00','102.33.3806.3806.94978.850091.16-03-2004 00:00:00','j',2554,102,102,'33.3806.3806.94978.850091','',1,13,'c',79,79,0,0,3,'0000-00-00','2004-12-20','2004-03-16 00:00:00','f',11175,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.3806.94978.850090.16-03-2004 00:00:00','102.33.1.3806.94978.850090.16-03-2004 00:00:00','j',2554,102,102,'33.1.3806.94978.850090','',1,13,'c',79,79,0,0,3,'0000-00-00','2004-11-20','2004-03-16 00:00:00','f',11175,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.3806.94978.850089.16-03-2004 00:00:00','102.33.1.3806.94978.850089.16-03-2004 00:00:00','j',2554,102,102,'33.1.3806.94978.850089','',1,13,'c',79,79,0,0,3,'0000-00-00','2004-10-20','2004-03-16 00:00:00','f',11175,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.1.3806.94978.850088.16-03-2004 00:00:00','102.33.1.3806.94978.850088.16-03-2004 00:00:00','j',2554,102,102,'33.1.3806.94978.850088','',1,13,'c',79,79,0,0,3,'0000-00-00','2004-09-20','2004-03-16 00:00:00','f',11175,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.409.264.200990.600451.16-03-2004 00:00:00','102.18.409.264.200990.600451.16-03-2004 00:00:00','j',2554,102,102,'18.409.264.200990.600451','',1,13,'c',230,230,0,0,3,'0000-00-00','2004-11-13','2004-03-16 00:00:00','f',11174,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.409.264.200990.600450.16-03-2004 00:00:00','102.18.409.264.200990.600450.16-03-2004 00:00:00','j',2554,102,102,'18.409.264.200990.600450','',1,13,'c',230,230,0,0,3,'0000-00-00','2004-09-13','2004-03-16 00:00:00','f',11174,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.238.174136.613947.16-03-2004 00:00:00','102.48.399.238.174136.613947.16-03-2004 00:00:00','j',2554,102,102,'48.399.238.174136.613947','',1,13,'c',180,180,0,0,3,'0000-00-00','2004-11-12','2004-03-16 00:00:00','f',11173,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.238.174136.613946.16-03-2004 00:00:00','102.48.399.238.174136.613946.16-03-2004 00:00:00','j',2554,102,102,'48.399.238.174136.613946','',1,13,'c',180,180,0,0,3,'0000-00-00','2004-10-12','2004-03-16 00:00:00','f',11173,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.238.17413.613948.16-03-2004 00:00:00','102.48.399.238.17413.613948.16-03-2004 00:00:00','j',2554,102,102,'48.399.238.17413.613948','',1,13,'c',180,180,0,0,3,'0000-00-00','2004-12-12','2004-03-16 00:00:00','f',11173,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.136.136.109891.24.16-03-2004 00:00:00','102.33.136.136.109891.24.16-03-2004 00:00:00','j',2554,102,102,'33.136.136.109891.24','',1,13,'c',122,122,0,0,3,'0000-00-00','2004-07-14','2004-03-16 00:00:00','f',11172,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.180.33.136.109891.22.16-03-2004 00:00:00','102.180.33.136.109891.22.16-03-2004 00:00:00','j',2554,102,102,'180.33.136.109891.22','',1,13,'c',122,122,0,0,3,'0000-00-00','2004-05-14','2004-03-16 00:00:00','f',11172,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.136.1098914.25.16-03-2004 00:00:00','102.18.33.136.1098914.25.16-03-2004 00:00:00','j',2554,102,102,'18.33.136.1098914.25','',1,13,'c',122,122,0,0,3,'0000-00-00','2004-08-14','2004-03-16 00:00:00','f',11172,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.1.48.62487.850315.16-03-2004 00:00:00','102.48.1.48.62487.850315.16-03-2004 00:00:00','j',2554,102,102,'48.1.48.62487.850315','',1,13,'c',146,146,0,0,3,'0000-00-00','2004-12-12','2004-03-16 00:00:00','f',11171,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.136.1098914.23.16-03-2004 00:00:00','102.18.33.136.1098914.23.16-03-2004 00:00:00','j',2554,102,102,'18.33.136.1098914.23','',1,13,'c',122,122,0,0,3,'0000-00-00','2004-06-14','2004-03-16 00:00:00','f',11172,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.1981.65765.150.17-03-2004 00:00:00','102.18.237.1981.65765.150.17-03-2004 00:00:00','j',3569,102,102,'18.237.1981.65765.150','',1,21,'c',116,116,0,0,3,'0000-00-00','2004-06-12','2004-03-17 00:00:00','f',11158,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.15.20287.792523.17-03-2004 00:00:00','102.18.33.15.20287.792523.17-03-2004 00:00:00','j',3569,102,102,'18.33.15.20287.792523','',1,21,'c',82,82,0,0,3,'0000-00-00','2004-06-18','2004-03-17 00:00:00','f',11162,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.273.9160.850295.17-03-2004 00:00:00','102.18.1.273.9160.850295.17-03-2004 00:00:00','j',3569,102,102,'18.1.273.9160.850295','',1,21,'c',349,349,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11164,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.1198.1460038.470.17-03-2004 00:00:00','102.18.151.1198.1460038.470.17-03-2004 00:00:00','j',3569,102,102,'18.151.1198.1460038.470','',1,21,'c',221.6,221.6,0,0,3,'0000-00-00','2004-06-01','2004-03-17 00:00:00','f',11165,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.756.4295.103870.459539.17-03-2004 00:00:00','102.18.756.4295.103870.459539.17-03-2004 00:00:00','j',3569,102,102,'18.756.4295.103870.459539','',1,21,'c',250,250,0,0,3,'0000-00-00','2004-06-12','2004-03-17 00:00:00','f',11166,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.389.604.1500251.727.17-03-2004 00:00:00','102.18.389.604.1500251.727.17-03-2004 00:00:00','j',3569,102,102,'18.389.604.1500251.727','',1,21,'c',298,298,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11156,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.201.55024.738.17-03-2004 00:00:00','102.18.237.201.55024.738.17-03-2004 00:00:00','j',3569,102,102,'18.237.201.55024.738','',1,21,'c',127,127,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11155,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.75.412007.6.17-03-2004 00:00:00','102.18.341.75.412007.6.17-03-2004 00:00:00','j',3569,102,102,'18.341.75.412007.6','',1,21,'c',185,185,0,0,3,'0000-00-00','2004-06-07','2004-03-17 00:00:00','f',11154,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.1074.1017774.103.17-03-2004 00:00:00','102.18.151.1074.1017774.103.17-03-2004 00:00:00','j',3569,102,102,'18.151.1074.1017774.103','',1,21,'c',100,100,0,0,3,'0000-00-00','2004-06-03','2004-03-17 00:00:00','f',11153,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.680.1001675.999593.17-03-2004 00:00:00','102.18.33.680.1001675.999593.17-03-2004 00:00:00','j',3569,102,102,'18.33.680.1001675.999593','',1,21,'c',309,309,0,0,3,'0000-00-00','2004-06-09','2004-03-17 00:00:00','f',11152,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.23.139020.448.17-03-2004 00:00:00','102.18.237.23.139020.448.17-03-2004 00:00:00','j',3569,102,102,'18.237.23.139020.448','',1,21,'c',500,500,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','j',11143,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.103233.291310.17-03-2004 00:00:00','102.18.1.50.103233.291310.17-03-2004 00:00:00','j',3569,102,102,'18.1.50.103233.291310','',1,21,'c',255,255,0,0,3,'0000-00-00','2004-06-05','2004-03-17 00:00:00','j',11144,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.172.1004733.1264.17-03-2004 00:00:00','102.18.151.172.1004733.1264.17-03-2004 00:00:00','j',3569,102,102,'18.151.172.1004733.1264','',1,21,'c',290,290,0,0,3,'0000-00-00','2004-06-15','2004-03-17 00:00:00','f',11147,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.261.394290.811875.17-03-2004 00:00:00','102.18.341.261.394290.811875.17-03-2004 00:00:00','j',3569,102,102,'18.341.261.394290.811875','',1,21,'c',270,270,0,0,3,'0000-00-00','2004-06-11','2004-03-17 00:00:00','j',11146,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.146.91949.19.17-03-2004 00:00:00','102.18.237.146.91949.19.17-03-2004 00:00:00','j',3569,102,102,'18.237.146.91949.19','',1,21,'c',185,185,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11149,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.50.420212.850800.17-03-2004 00:00:00','102.18.1.50.420212.850800.17-03-2004 00:00:00','j',3569,102,102,'18.1.50.420212.850800','',1,21,'c',275,275,0,0,3,'0000-00-00','2004-06-15','2004-03-17 00:00:00','f',10720,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.5487.1005215.3282.17-03-2004 00:00:00','102.18.151.5487.1005215.3282.17-03-2004 00:00:00','j',3569,102,102,'18.151.5487.1005215.3282','',1,21,'c',600,600,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11150,0,'j',1,100,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.1089582.921937.17-03-2004 00:00:00','102.18.33.3.1089582.921937.17-03-2004 00:00:00','j',3569,102,102,'18.33.3.1089582.921937','',1,21,'c',110,110,0,0,3,'0000-00-00','2004-06-12','2004-03-17 00:00:00','f',11167,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.3.5053261.975487.17-03-2004 00:00:00','102.18.33.3.5053261.975487.17-03-2004 00:00:00','j',3569,102,102,'18.33.3.5053261.975487','',1,21,'c',165,165,0,0,3,'0000-00-00','2004-06-13','2004-03-17 00:00:00','f',11168,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.559.1036959.783703.17-03-2004 00:00:00','102.18.33.559.1036959.783703.17-03-2004 00:00:00','j',3569,102,102,'18.33.559.1036959.783703','',1,21,'c',55,55,0,0,3,'0000-00-00','2004-06-15','2004-03-17 00:00:00','f',11169,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.1299.90029760.11146.17-03-2004 00:00:00','102.18.356.1299.90029760.11146.17-03-2004 00:00:00','j',3569,102,102,'18.356.1299.90029760.11146','',1,21,'c',290.7,290.7,0,0,3,'0000-00-00','2004-04-09','2004-03-17 00:00:00','f',11170,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.1299.90029760.11148.17-03-2004 00:00:00','102.18.356.1299.90029760.11148.17-03-2004 00:00:00','j',3569,102,102,'18.356.1299.90029760.11148','',1,21,'c',290.7,290.7,0,0,3,'0000-00-00','2004-06-09','2004-03-17 00:00:00','f',11170,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1007.10070946.653001.17-03-2004 00:00:00','102.18.399.1007.10070946.653001.17-03-2004 00:00:00','j',3569,102,102,'18.399.1007.10070946.653001','',1,21,'c',104,104,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11194,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.278.15736.918347.17-03-2004 00:00:00','102.18.33.278.15736.918347.17-03-2004 00:00:00','f',4154,102,102,'18.33.278.15736.918347','',1,24,'c',98,98,100,0,3,'0000-00-00','2004-04-12','2004-03-17 00:00:00','f',11204,0,'j',1,2,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.278.15736.918348.17-03-2004 00:00:00','102.18.33.278.15736.918348.17-03-2004 00:00:00','f',4154,102,102,'18.33.278.15736.918348','',1,24,'c',98,98,100,0,3,'0000-00-00','2004-05-12','2004-03-17 00:00:00','f',11204,0,'j',1,2,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.278.15736.918349.17-03-2004 00:00:00','102.18.33.278.15736.918349.17-03-2004 00:00:00','f',4154,102,102,'18.33.278.15736.918349','',1,24,'c',98,98,100,0,3,'0000-00-00','2004-06-12','2004-03-17 00:00:00','f',11204,0,'j',1,2,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.278.15736.918350.17-03-2004 00:00:00','102.18.33.278.15736.918350.17-03-2004 00:00:00','f',4154,102,102,'18.33.278.15736.918350','',1,24,'c',98,98,100,0,3,'0000-00-00','2004-07-12','2004-03-17 00:00:00','f',11204,0,'j',1,2,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.1310.1001798.900088.17-03-2004 00:00:00','102.48.104.1310.1001798.900088.17-03-2004 00:00:00','j',2554,102,102,'48.104.1310.1001798.900088','',1,23,'c',274,274,0,0,3,'0000-00-00','2004-04-10','2004-03-17 00:00:00','f',11201,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.1310.1001798.900089.17-03-2004 00:00:00','102.48.104.1310.1001798.900089.17-03-2004 00:00:00','j',2554,102,102,'48.104.1310.1001798.900089','',1,23,'c',274,274,0,0,3,'0000-00-00','2004-05-10','2004-03-17 00:00:00','f',11201,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.1310.1001798.900090.17-03-2004 00:00:00','102.48.104.1310.1001798.900090.17-03-2004 00:00:00','j',2554,102,102,'48.104.1310.1001798.900090','',1,23,'c',274,274,0,0,3,'0000-00-00','2004-06-10','2004-03-17 00:00:00','f',11201,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.1310.1001798.900091.17-03-2004 00:00:00','102.48.104.1310.1001798.900091.17-03-2004 00:00:00','j',2554,102,102,'48.104.1310.1001798.900091','',1,23,'c',274,274,0,0,3,'0000-00-00','2004-07-10','2004-03-17 00:00:00','f',11201,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.1.3321.155039.851099.17-03-2004 00:00:00','102.48.1.3321.155039.851099.17-03-2004 00:00:00','j',2554,102,102,'48.1.3321.155039.851099','',1,23,'c',514,514,0,0,3,'0000-00-00','2004-04-15','2004-03-17 00:00:00','f',11202,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.1.3321.155039.851100.17-03-2004 00:00:00','102.48.1.3321.155039.851100.17-03-2004 00:00:00','j',2554,102,102,'48.1.3321.155039.851100','',1,23,'c',514,514,0,0,3,'0000-00-00','2004-05-15','2004-03-17 00:00:00','f',11202,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10015.17-03-2004 00:00:00','102.48.356.85.6026074.10015.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10015','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-05-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10017.17-03-2004 00:00:00','102.48.356.85.6026074.10017.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10017','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-07-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10018.17-03-2004 00:00:00','102.48.356.85.6026074.10018.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10018','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-08-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10019.17-03-2004 00:00:00','102.48.356.85.6026074.10019.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10019','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-09-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10020.17-03-2004 00:00:00','102.48.356.85.6026074.10020.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10020','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-10-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10021.17-03-2004 00:00:00','102.48.356.85.6026074.10021.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10021','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-11-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.6026074.10022.17-03-2004 00:00:00','102.48.356.85.6026074.10022.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.6026074.10022','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-12-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.60260745.10016.17-03-2004 00:00:00','102.48.356.85.60260745.10016.17-03-2004 00:00:00','j',2554,102,102,'48.356.85.60260745.10016','',1,23,'c',146,146,0,0,3,'0000-00-00','2004-06-15','2004-03-17 00:00:00','f',11203,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.1.1.1352.18-03-2004 00:00:00','102.18.237.1.1.1352.18-03-2004 00:00:00','f',4154,102,102,'18.237.1.1.1352','',1,27,'c',650,650,100,0,3,'0000-00-00','2004-05-03','2004-03-18 00:00:00','f',4773,0,'j',1,100,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.1.1.1353.18-03-2004 00:00:00','102.18.237.1.1.1353.18-03-2004 00:00:00','f',4154,102,102,'18.237.1.1.1353','',1,27,'c',650,650,100,0,3,'0000-00-00','2004-06-01','2004-03-18 00:00:00','f',4773,0,'j',1,100,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.1.1.1354.18-03-2004 00:00:00','102.18.237.1.1.1354.18-03-2004 00:00:00','f',4154,102,102,'18.237.1.1.1354','',1,27,'c',650,650,100,0,3,'0000-00-00','2004-07-01','2004-03-18 00:00:00','f',4773,0,'j',1,100,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.22.1500024.962520.18-03-2004 00:00:00','102.18.33.22.1500024.962520.18-03-2004 00:00:00','f',3115,102,102,'18.33.22.1500024.962520','',1,29,'c',493,493,100,0,3,'0000-00-00','2004-04-16','2004-03-18 00:00:00','f',11206,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.22.1500024.112581.18-03-2004 00:00:00','102.18.33.22.1500024.112581.18-03-2004 00:00:00','f',3115,102,102,'18.33.22.1500024.112581','',1,29,'c',493,493,100,0,3,'0000-00-00','2004-05-16','2004-03-18 00:00:00','f',11206,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.22.1500024.112582.18-03-2004 00:00:00','102.18.33.22.1500024.112582.18-03-2004 00:00:00','f',3115,102,102,'18.33.22.1500024.112582','',1,29,'c',493,493,100,0,3,'0000-00-00','2004-06-16','2004-03-18 00:00:00','f',11206,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.1.891.254088.850097.18-03-2004 00:00:00','102.9.1.891.254088.850097.18-03-2004 00:00:00','j',2554,102,102,'9.1.891.254088.850097','',1,34,'c',78,78,0,0,3,'0000-00-00','2004-07-12','2004-03-18 00:00:00','f',9215,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.1.891.254088.850096.18-03-2004 00:00:00','102.9.1.891.254088.850096.18-03-2004 00:00:00','j',2554,102,102,'9.1.891.254088.850096','',1,34,'c',78,78,0,0,3,'0000-00-00','2004-06-12','2004-03-18 00:00:00','f',9215,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.292.9201422.963426.18-03-2004 00:00:00','102.18.33.292.9201422.963426.18-03-2004 00:00:00','j',2554,102,102,'18.33.292.9201422.963426','',1,33,'c',100,100,0,0,3,'0000-00-00','2004-06-10','2004-03-18 00:00:00','f',9986,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.842.101311.575840.18-03-2004 00:00:00','102.48.399.842.101311.575840.18-03-2004 00:00:00','j',2554,102,102,'48.399.842.101311.575840','',1,33,'c',149,149,0,0,3,'0000-00-00','2004-08-10','2004-03-18 00:00:00','f',10986,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.148.1.48.159204.850478.18-03-2004 00:00:00','102.148.1.48.159204.850478.18-03-2004 00:00:00','j',2554,102,102,'148.1.48.159204.850478','',1,33,'c',540,540,0,0,3,'0000-00-00','2004-08-20','2004-03-18 00:00:00','f',11233,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.9.1.2221.74578.850032.18-03-2004 00:00:00','102.9.1.2221.74578.850032.18-03-2004 00:00:00','j',2554,102,102,'9.1.2221.74578.850032','',1,33,'c',190,190,0,0,3,'0000-00-00','2004-06-12','2004-03-18 00:00:00','f',9224,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.292.9201422.963424.18-03-2004 00:00:00','102.18.33.292.9201422.963424.18-03-2004 00:00:00','j',2554,102,102,'18.33.292.9201422.963424','',1,33,'c',100,100,0,0,3,'0000-00-00','2004-08-10','2004-03-18 00:00:00','f',9986,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.292.9201422.963423.18-03-2004 00:00:00','102.18.33.292.9201422.963423.18-03-2004 00:00:00','j',2554,102,102,'18.33.292.9201422.963423','',1,33,'c',100,100,0,0,3,'0000-00-00','2004-07-10','2004-03-18 00:00:00','f',9986,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.2228.1006007.900104.18-03-2004 00:00:00','102.48.104.2228.1006007.900104.18-03-2004 00:00:00','j',2554,102,102,'48.104.2228.1006007.900104','',1,33,'c',151,151,0,0,3,'0000-00-00','2004-08-12','2004-03-18 00:00:00','f',11232,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.17.1039860.900018.18-03-2004 00:00:00','102.48.104.17.1039860.900018.18-03-2004 00:00:00','j',2554,102,102,'48.104.17.1039860.900018','',1,33,'c',148,148,0,0,3,'0000-00-00','2004-08-26','2004-03-18 00:00:00','f',11231,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.104.17.1039860.900017.18-03-2004 00:00:00','102.48.104.17.1039860.900017.18-03-2004 00:00:00','j',2554,102,102,'48.104.17.1039860.900017','',1,33,'c',148,148,0,0,3,'0000-00-00','2004-07-26','2004-03-18 00:00:00','f',11231,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.842.144188.546304.18-03-2004 00:00:00','102.48.399.842.144188.546304.18-03-2004 00:00:00','j',2554,102,102,'48.399.842.144188.546304','',1,33,'c',104,104,0,0,3,'0000-00-00','2004-09-27','2004-03-18 00:00:00','f',10770,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.842.144188.546302.18-03-2004 00:00:00','102.48.399.842.144188.546302.18-03-2004 00:00:00','j',2554,102,102,'48.399.842.144188.546302','',1,33,'c',104,104,0,0,3,'0000-00-00','2004-08-27','2004-03-18 00:00:00','f',10770,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.399.842.144188.546301.18-03-2004 00:00:00','102.48.399.842.144188.546301.18-03-2004 00:00:00','j',2554,102,102,'48.399.842.144188.546301','',1,33,'c',104,104,0,0,3,'0000-00-00','2004-07-27','2004-03-18 00:00:00','f',10770,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.30266663.10112.18-03-2004 00:00:00','102.48.356.85.30266663.10112.18-03-2004 00:00:00','j',2554,102,102,'48.356.85.30266663.10112','',1,33,'c',202,202,0,0,3,'0000-00-00','2004-08-26','2004-03-18 00:00:00','f',11230,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.30266663.10111.18-03-2004 00:00:00','102.48.356.85.30266663.10111.18-03-2004 00:00:00','j',2554,102,102,'48.356.85.30266663.10111','',1,33,'c',202,202,0,0,3,'0000-00-00','2004-10-26','2004-03-18 00:00:00','f',11230,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.30266663.10110.18-03-2004 00:00:00','102.48.356.85.30266663.10110.18-03-2004 00:00:00','j',2554,102,102,'48.356.85.30266663.10110','',1,33,'c',202,202,0,0,3,'0000-00-00','2004-07-26','2004-03-18 00:00:00','f',11230,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.48.356.85.30266663.10109.18-03-2004 00:00:00','102.48.356.85.30266663.10109.18-03-2004 00:00:00','j',2554,102,102,'48.356.85.30266663.10109','',1,33,'c',202,202,0,0,3,'0000-00-00','2004-09-26','2004-03-18 00:00:00','f',11230,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1121.15529.135546.18-03-2004 00:00:00','102.18.399.1121.15529.135546.18-03-2004 00:00:00','j',2554,102,102,'18.399.1121.15529.135546','',1,33,'c',500,500,0,0,3,'0000-00-00','2004-08-15','2004-03-18 00:00:00','f',11229,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1121.15529.135545.18-03-2004 00:00:00','102.18.399.1121.15529.135545.18-03-2004 00:00:00','j',2554,102,102,'18.399.1121.15529.135545','',1,33,'c',500,500,0,0,3,'0000-00-00','2004-07-15','2004-03-18 00:00:00','f',11229,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.766.72761.850035.18-03-2004 00:00:00','102.18.1.766.72761.850035.18-03-2004 00:00:00','j',2554,102,102,'18.1.766.72761.850035','',1,33,'c',60,60,0,0,3,'0000-00-00','2004-06-13','2004-03-18 00:00:00','f',11228,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.766.16500.850519.18-03-2004 00:00:00','102.18.1.766.16500.850519.18-03-2004 00:00:00','j',2554,102,102,'18.1.766.16500.850519','',1,33,'c',40,40,0,0,3,'0000-00-00','2004-06-12','2004-03-18 00:00:00','f',11227,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.99.1007029.68.18-03-2004 00:00:00','102.18.151.99.1007029.68.18-03-2004 00:00:00','j',2554,102,102,'18.151.99.1007029.68','',1,33,'c',36,36,0,0,3,'0000-00-00','2004-06-10','2004-03-18 00:00:00','f',11226,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.531.23873.786.18-03-2004 00:00:00','102.18.237.531.23873.786.18-03-2004 00:00:00','j',2554,102,102,'18.237.531.23873.786','',1,33,'c',28,28,0,0,3,'0000-00-00','2004-06-10','2004-03-18 00:00:00','f',11225,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.531.28893.2509.18-03-2004 00:00:00','102.18.237.531.28893.2509.18-03-2004 00:00:00','j',2554,102,102,'18.237.531.28893.2509','',1,33,'c',42,42,0,0,3,'0000-00-00','2004-06-09','2004-03-18 00:00:00','f',11224,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.161.3083826.843513.18-03-2004 00:00:00','102.18.33.161.3083826.843513.18-03-2004 00:00:00','j',2554,102,102,'18.33.161.3083826.843513','',1,33,'c',60,60,0,0,3,'0000-00-00','2004-06-25','2004-03-18 00:00:00','f',11223,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.161.0.843512.18-03-2004 00:00:00','102.18.33.161.0.843512.18-03-2004 00:00:00','j',2554,102,102,'18.33.161.0.843512','',1,33,'c',50,50,0,0,3,'0000-00-00','2004-05-25','2004-03-18 00:00:00','f',11223,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.241.287697.171310.18-03-2004 00:00:00','102.18.341.241.287697.171310.18-03-2004 00:00:00','j',2554,102,102,'18.341.241.287697.171310','',1,33,'c',52,52,0,0,3,'0000-00-00','2004-06-20','2004-03-18 00:00:00','f',11222,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.241.287697.171309.18-03-2004 00:00:00','102.18.341.241.287697.171309.18-03-2004 00:00:00','j',2554,102,102,'18.341.241.287697.171309','',1,33,'c',52,52,0,0,3,'0000-00-00','2004-05-20','2004-03-18 00:00:00','f',11222,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.583.7707911.10054.18-03-2004 00:00:00','102.18.356.583.7707911.10054.18-03-2004 00:00:00','j',2554,102,102,'18.356.583.7707911.10054','',1,33,'c',30,30,0,0,3,'0000-00-00','2004-05-20','2004-03-18 00:00:00','f',11221,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.161.5014260.943430.18-03-2004 00:00:00','102.18.33.161.5014260.943430.18-03-2004 00:00:00','j',2554,102,102,'18.33.161.5014260.943430','',1,33,'c',48,48,0,0,3,'0000-00-00','2004-04-10','2004-03-18 00:00:00','f',11220,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.531.11735.4890.18-03-2004 00:00:00','102.18.237.531.11735.4890.18-03-2004 00:00:00','j',2554,102,102,'18.237.531.11735.4890','',1,33,'c',50,50,0,0,3,'0000-00-00','2004-04-07','2004-03-18 00:00:00','f',11219,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.3292.3880.888846.18-03-2004 00:00:00','102.18.341.3292.3880.888846.18-03-2004 00:00:00','j',2554,102,102,'18.341.3292.3880.888846','',1,33,'c',27,27,0,0,3,'0000-00-00','2004-04-08','2004-03-18 00:00:00','f',11218,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.163.563544.850565.18-03-2004 00:00:00','102.18.1.163.563544.850565.18-03-2004 00:00:00','j',2554,102,102,'18.1.163.563544.850565','',1,33,'c',42,42,0,0,3,'0000-00-00','2004-04-04','2004-03-18 00:00:00','f',11217,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.583.8706684.10521.18-03-2004 00:00:00','102.18.356.583.8706684.10521.18-03-2004 00:00:00','j',2554,102,102,'18.356.583.8706684.10521','',1,33,'c',40,40,100,0,3,'0000-00-00','2004-04-01','2004-03-18 00:00:00','f',11216,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.356.11.87077715.10651.18-03-2004 00:00:00','102.33.356.11.87077715.10651.18-03-2004 00:00:00','j',2554,102,102,'33.356.11.87077715.10651','',1,33,'c',200,200,0,0,3,'0000-00-00','2004-11-25','2004-03-18 00:00:00','f',11212,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.33.356.255.17108850.10164.18-03-2004 00:00:00','102.33.356.255.17108850.10164.18-03-2004 00:00:00','j',2554,102,102,'33.356.255.17108850.10164','',1,33,'c',190,190,0,0,3,'0000-00-00','2004-11-18','2004-03-18 00:00:00','f',8070,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.766.158682.850307.18-03-2004 00:00:00','102.18.1.766.158682.850307.18-03-2004 00:00:00','j',2554,102,102,'18.1.766.158682.850307','',1,33,'c',54,54,100,0,3,'0000-00-00','2004-03-26','2004-03-18 00:00:00','f',11213,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.161.100374.340409.18-03-2004 00:00:00','102.18.33.161.100374.340409.18-03-2004 00:00:00','j',2554,102,102,'18.33.161.100374.340409','',1,33,'c',100,100,100,0,3,'0000-00-00','2004-04-01','2004-03-18 00:00:00','f',11214,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.25.52895.371520.18-03-2004 00:00:00','102.18.341.25.52895.371520.18-03-2004 00:00:00','j',2554,102,102,'18.341.25.52895.371520','',1,33,'c',50,50,100,0,3,'0000-00-00','2004-04-01','2004-03-18 00:00:00','f',11215,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.2923.13435.8500093.18-03-2004 00:00:00','102.18.1.2923.13435.8500093.18-03-2004 00:00:00','j',2950,102,102,'18.1.2923.13435.8500093','',1,30,'c',308,308,0,0,3,'0000-00-00','2004-04-15','2004-03-18 00:00:00','f',8436,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.2923.13435.850094.18-03-2004 00:00:00','102.18.1.2923.13435.850094.18-03-2004 00:00:00','j',2950,102,102,'18.1.2923.13435.850094','',1,30,'c',308,308,0,0,3,'0000-00-00','2004-04-24','2004-03-18 00:00:00','f',8436,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.2923.13435.850095.18-03-2004 00:00:00','102.18.1.2923.13435.850095.18-03-2004 00:00:00','j',2950,102,102,'18.1.2923.13435.850095','',1,30,'c',308,308,0,0,3,'0000-00-00','2004-04-30','2004-03-18 00:00:00','f',8436,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.1700.80370.850901.18-03-2004 00:00:00','102.18.1.1700.80370.850901.18-03-2004 00:00:00','j',2950,102,102,'18.1.1700.80370.850901','',1,30,'c',1098,1098,0,0,3,'0000-00-00','2004-04-16','2004-03-18 00:00:00','j',1448,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.2155.7797.850368.18-03-2004 00:00:00','102.18.1.2155.7797.850368.18-03-2004 00:00:00','j',2950,102,102,'18.1.2155.7797.850368','',1,30,'c',450,450,0,0,3,'0000-00-00','2004-04-17','2004-03-18 00:00:00','f',7976,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.46.1117228.953512.18-03-2004 00:00:00','102.18.33.46.1117228.953512.18-03-2004 00:00:00','f',3445,102,102,'18.33.46.1117228.953512','',1,35,'c',32.8,32.8,100,0,3,'0000-00-00','2004-04-08','2004-03-18 00:00:00','f',5536,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.218.432037.1.18-03-2004 00:00:00','102.18.341.218.432037.1.18-03-2004 00:00:00','f',3445,102,102,'18.341.218.432037.1','',1,35,'c',54.8,54.8,100,0,3,'0000-00-00','2004-04-09','2004-03-18 00:00:00','f',11234,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.151.1091.10141101.176.18-03-2004 00:00:00','102.18.151.1091.10141101.176.18-03-2004 00:00:00','f',3445,102,102,'18.151.1091.10141101.176','',1,35,'c',39.2,39.2,100,0,3,'0000-00-00','2004-04-07','2004-03-18 00:00:00','f',4856,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1012.1012026807.611956.18-03-2004 00:00:00','102.18.399.1012.1012026807.611956.18-03-2004 00:00:00','f',3445,102,102,'18.399.1012.1012026807.611956','',1,35,'c',33,33,100,0,3,'0000-00-00','2004-03-27','2004-03-18 00:00:00','f',6575,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.237.7.64807.129.18-03-2004 00:00:00','102.18.237.7.64807.129.18-03-2004 00:00:00','f',3445,102,102,'18.237.7.64807.129','',1,35,'c',31,31,100,0,3,'0000-00-00','2004-03-23','2004-03-18 00:00:00','f',5656,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.58.433179.850177.18-03-2004 00:00:00','102.18.1.58.433179.850177.18-03-2004 00:00:00','f',4154,102,102,'18.1.58.433179.850177','',1,35,'c',88.6,88.6,100,0,3,'0000-00-00','2004-03-30','2004-03-18 00:00:00','f',6579,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.218.520229.78299.18-03-2004 00:00:00','102.18.341.218.520229.78299.18-03-2004 00:00:00','f',4154,102,102,'18.341.218.520229.78299','',1,35,'c',56,56,100,0,3,'0000-00-00','2004-03-20','2004-03-18 00:00:00','f',11239,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.1.58.294489.850177.18-03-2004 00:00:00','102.18.1.58.294489.850177.18-03-2004 00:00:00','f',4154,102,102,'18.1.58.294489.850177','',1,35,'c',123,123,100,0,3,'0000-00-00','2004-03-28','2004-03-18 00:00:00','f',11240,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.356.595.37100218.10050.18-03-2004 00:00:00','102.18.356.595.37100218.10050.18-03-2004 00:00:00','f',4154,102,102,'18.356.595.37100218.10050','',1,35,'c',98.5,98.5,100,0,3,'0000-00-00','2004-04-25','2004-03-18 00:00:00','f',9482,0,'j',1,101,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1032.103203600.673255.18-03-2004 00:00:00','102.18.399.1032.103203600.673255.18-03-2004 00:00:00','f',1523,102,102,'18.399.1032.103203600.673255','',1,39,'c',3775.46,3775.46,100,0,3,'0000-00-00','2004-04-15','2004-03-18 00:00:00','f',5041,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.399.1032.103203600.673256.18-03-2004 00:00:00','102.18.399.1032.103203600.673256.18-03-2004 00:00:00','f',1523,102,102,'18.399.1032.103203600.673256','',1,40,'c',3208.88,3208.88,100,0,3,'0000-00-00','2004-05-15','2004-03-18 00:00:00','f',5041,0,'j',1,1,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.180.33.39.127373.196433.18-03-2004 00:00:00','102.180.33.39.127373.196433.18-03-2004 00:00:00','j',2554,102,102,'180.33.39.127373.196433','',1,36,'c',79,79,0,0,3,'0000-00-00','2004-07-25','2004-03-18 00:00:00','f',11238,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.127373.1273737.1964.18-03-2004 00:00:00','102.18.33.127373.1273737.1964.18-03-2004 00:00:00','j',2554,102,102,'18.33.127373.1273737.1964','',1,36,'c',79,79,0,0,3,'0000-00-00','2004-06-25','2004-03-18 00:00:00','f',11238,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.39.5097036.939755.18-03-2004 00:00:00','102.18.33.39.5097036.939755.18-03-2004 00:00:00','j',2554,102,102,'18.33.39.5097036.939755','',1,36,'c',147,147,0,0,3,'0000-00-00','2004-06-10','2004-03-18 00:00:00','f',11237,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.39.1273737.196431.18-03-2004 00:00:00','102.18.33.39.1273737.196431.18-03-2004 00:00:00','j',2554,102,102,'18.33.39.1273737.196431','',1,36,'c',79,79,0,0,3,'0000-00-00','2004-05-25','2004-03-18 00:00:00','f',11238,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.39.5097036.939754.18-03-2004 00:00:00','102.18.33.39.5097036.939754.18-03-2004 00:00:00','j',2554,102,102,'18.33.39.5097036.939754','',1,36,'c',147,147,0,0,3,'0000-00-00','2004-05-10','2004-03-18 00:00:00','f',11237,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.33.39.5097036.939753.18-03-2004 00:00:00','102.18.33.39.5097036.939753.18-03-2004 00:00:00','j',2554,102,102,'18.33.39.5097036.939753','',1,36,'c',147,147,0,0,3,'0000-00-00','2004-04-10','2004-03-18 00:00:00','f',11237,0,'j',1,0,0,0,0);
INSERT INTO movimento_baixas VALUES ('102.18.341.223.248972.643745.18-03-2004 00:00:00','102.18.341.223.248972.643745.18-03-2004 00:00:00','j',25

Suggested fix:
CREATE TABLE tmp
SELECT operacao,documento,if((sacador_tipo='j' AND sacador_id=1),MAX(data_operacao),'0000-00-00 00:00:00') AS data_operacao
		FROM 
		movimento_baixas 
		WHERE 
		((sacado_tipo='j' AND sacado_id=1) OR (sacador_tipo='j' AND sacador_id=1)) 
		AND 
		(data_operacao<='0000-00-06 05:05:46') 
		AND operacao=102 
		GROUP BY operacao,documento;

SELECT data_operacao,data_vencimento,sacado_tipo,sacado_id,documento,valor,valor_residual 
FROM movimento_baixas 
WHERE 
(sacador_tipo='j' AND sacador_id=1) AND 
(operacao,documento,data_operacao) IN 
	(
		SELECT operacao,documento,MAX(data_operacao)
		FROM tmp
		GROUP BY operacao,documento
	);
DROP TABLE tmp;

STATUS FROM SERVER BEFORE BREAK

Attachment: server-variables.txt (text/plain), 10.70 KiB.

the zipped sql

Attachment: tables.zip (application/zip, text), 27.54 KiB.

see the sql file in files!!!

Thank you so much for writting to us.

Sorry, but your test case does not work with latest 4.1.2.

With both tables.zip (albeit tables.sql) and a script in the bugs db I get:

ERROR 1062 at line 55: Duplicate entry '102-18.356.1299.90029760.11147-2004-03-16 00:00:00' for key 2

I could fix data, but then may be problem would not surface.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

closed, problem done with newer mysql versions

Page generated in 0.077 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.