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

[5 Apr 2004 16:57] Roberto Spadim
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;
[5 Apr 2004 16:59] Roberto Spadim
STATUS FROM SERVER BEFORE BREAK

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

[5 Apr 2004 17:06] Roberto Spadim
the zipped sql

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

[5 Apr 2004 17:06] Roberto Spadim
see the sql file in files!!!
[6 Apr 2004 7:48] Sinisa Milivojevic
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.
[14 Feb 2005 22:54] Bugs System
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".
[29 Mar 2011 18:22] Roberto Spadim
closed, problem done with newer mysql versions