Bug #313 repared index is not used
Submitted: 22 Apr 2003 10:30 Modified: 22 May 2003 2:38
Reporter: Bruno Faust Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:3.23.56 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[22 Apr 2003 10:30] Bruno Faust 
Description:
i create a table with 3 index and 1 primary.

when i run:
desc SELECT a.cob_id, a.cob_dad_id, a.cob_nparcela, a.cob_dtenvio, a.cob_dtretorno, a.cob_valor, a.cob_status, a.cob_dtatualizacao, a.cob_pai_id, SUM(IF(b.cob_status = 'OK', 1, 0)) as certo, SUM(IF((b.cob_status IN ('NE', 'NR', 'C', 'E', 'EP')), 1, 0)) as b_no_recobra, COUNT(b.cob_id) as envios, TO_DAYS(MAX(b.cob_dtenvio)) - TO_DAYS(a.cob_dtenvio) as dias_no_recobra FROM produto.cobranca a LEFT JOIN produto.cobranca b ON a.cob_id = b.cob_pai_id WHERE a.cob_status = 'ERRO' AND (a.cob_dtretorno = '2003-04-21' OR b.cob_dtretorno = '2003-04-21') GROUP BY a.cob_id HAVING certo = 0 AND envios < 6 AND a.cob_pai_id = 0 AND (dias_no_recobra < 10 OR dias_no_recobra IS NULL) AND b_no_recobra = 0

the result is: 2 index is used

after myisamchk -a table, when i run again, the result is: 1 index is used

why?

How to repeat:
1) DUMP
------------------------------------------------------------
DROP TABLE IF EXISTS cobranca;
CREATE TABLE cobranca (
  cob_id smallint(5) unsigned NOT NULL auto_increment,
  cob_dad_id smallint(5) unsigned NOT NULL default '0',
  cob_nparcela tinyint(3) unsigned NOT NULL default '0',
  cob_dtenvio date NOT NULL default '0000-00-00',
  cob_dtretorno date NOT NULL default '0000-00-00',
  cob_valor float(10,2) unsigned NOT NULL default '0.00',
  cob_status enum('NE','NR','OK','ERRO','C','E','EP') NOT NULL default 'NE',
  cob_dtatualizacao timestamp(14) NOT NULL,
  cob_pai_id smallint(5) unsigned default '0',
  PRIMARY KEY  (cob_id),
  KEY cob_IDX (cob_dad_id,cob_dtenvio),
  KEY IDX_COBRANCA__PAI_ID_RET_STAT (cob_pai_id,cob_dtretorno,cob_status),
  KEY IDX_COBRANCA__STAT_RETORNO (cob_status,cob_dtretorno)
) TYPE=MyISAM;

INSERT INTO cobranca (cob_id, cob_dad_id, cob_nparcela, cob_dtenvio, cob_dtretorno, cob_valor, cob_status, cob_dtatualizacao, cob_pai_id) VALUES
(310, 187, 2, '2003-01-23', '0000-00-00', '33.33', 'NE', 20030205153716, 0),
(311, 187, 3, '2003-02-23', '0000-00-00', '33.33', 'NE', 20030205153716, 0),
(312, 186, 2, '2003-01-22', '0000-00-00', '50.00', 'NE', 20030205153716, 0),
(313, 186, 3, '2003-02-22', '0000-00-00', '50.00', 'NE', 20030205153716, 0),
(307, 187, 1, '2002-12-23', '2003-01-02', '33.33', 'OK', 20030205153716, 0),
(304, 186, 1, '2002-12-22', '2002-12-30', '50.00', 'OK', 20030205153716, 0),
(314, 188, 1, '2002-12-25', '2003-01-02', '100.00', 'ERRO', 20030205153716, 0),
(315, 189, 1, '2003-01-04', '2003-01-13', '33.33', 'OK', 20030205153716, 0),
(316, 189, 2, '2003-02-04', '2003-02-12', '33.33', 'OK', 20030212174216, 0),
(317, 189, 3, '2003-03-04', '2003-03-14', '33.33', 'ERRO', 20030314175323, 0),
(318, 190, 1, '2003-01-07', '2003-01-08', '150.00', 'E', 20030205153716, 0),
(377, 193, 1, '2003-01-10', '2003-01-20', '40.00', 'ERRO', 20030205153715, 0),
(392, 193, 3, '2003-03-10', '2003-03-18', '120.00', 'ERRO', 20030318154927, 0),
(379, 193, 3, '2003-03-10', '2003-03-18', '40.00', 'ERRO', 20030318154925, 0),
(378, 193, 2, '2003-02-10', '2003-02-18', '40.00', 'ERRO', 20030218172804, 0),
(382, 193, 3, '2003-03-10', '2003-03-18', '40.00', 'ERRO', 20030318154926, 0),
(381, 193, 2, '2003-02-10', '2003-02-18', '40.00', 'ERRO', 20030218172805, 0),
(380, 193, 1, '2003-01-10', '2003-01-20', '40.00', 'ERRO', 20030205153715, 0),
(385, 193, 3, '2003-03-10', '2003-03-18', '120.00', 'ERRO', 20030318154926, 0),
(384, 193, 2, '2003-02-10', '2003-02-18', '120.00', 'ERRO', 20030218172805, 0),
(383, 193, 1, '2003-01-10', '2003-01-20', '120.00', 'ERRO', 20030205153715, 0),
(387, 193, 2, '2003-02-10', '2003-02-18', '120.00', 'ERRO', 20030218172806, 0),
(386, 193, 1, '2003-01-10', '2003-01-20', '120.00', 'ERRO', 20030205153715, 0),
(388, 193, 3, '2003-03-10', '2003-03-18', '120.00', 'ERRO', 20030318154927, 0),
(407, 193, 3, '2003-03-10', '2003-03-18', '120.00', 'ERRO', 20030318154929, 0),
(406, 193, 2, '2003-02-10', '2003-02-18', '120.00', 'ERRO', 20030218172808, 0),
(405, 193, 1, '2003-01-10', '2003-01-20', '120.00', 'ERRO', 20030205153715, 0),
(396, 193, 1, '2003-01-10', '2003-01-20', '120.00', 'ERRO', 20030205153715, 0),
(397, 193, 2, '2003-02-10', '2003-02-18', '120.00', 'ERRO', 20030218172807, 0),
(398, 193, 3, '2003-03-10', '2003-03-18', '120.00', 'ERRO', 20030318154928, 0),
(399, 193, 1, '2003-01-10', '2003-01-20', '120.00', 'ERRO', 20030205153715, 0),
(400, 193, 2, '2003-02-10', '2003-02-18', '120.00', 'ERRO', 20030218172808, 0),
(401, 193, 3, '2003-03-10', '2003-03-18', '120.00', 'ERRO', 20030318154929, 0),
(402, 193, 1, '2003-01-10', '0000-00-00', '120.00', 'NE', 20030205153715, 0),
(403, 193, 2, '2003-02-10', '0000-00-00', '120.00', 'NE', 20030205153715, 0),
(404, 193, 3, '2003-03-10', '0000-00-00', '120.00', 'NE', 20030205153715, 0),
(408, 193, 1, '2003-01-10', '2003-01-20', '30.00', 'ERRO', 20030205153714, 0),
(409, 193, 2, '2003-02-10', '2003-02-18', '30.00', 'ERRO', 20030218172808, 0),
(410, 193, 3, '2003-03-10', '2003-03-18', '30.00', 'ERRO', 20030318154930, 0),
(411, 193, 1, '2003-01-10', '2003-01-20', '30.00', 'ERRO', 20030205153714, 0),
(412, 193, 2, '2003-02-10', '2003-02-18', '30.00', 'ERRO', 20030218172809, 0),
(413, 193, 3, '2003-03-10', '2003-03-18', '30.00', 'ERRO', 20030318154930, 0),
(414, 197, 1, '2003-01-11', '2003-01-20', '33.33', 'OK', 20030205153714, 0),
(415, 197, 2, '2003-02-11', '2003-02-20', '33.33', 'OK', 20030220175448, 0),
(416, 197, 3, '2003-03-11', '2003-03-19', '33.33', 'OK', 20030319163135, 0),
(417, 198, 1, '2003-01-13', '2003-01-14', '30.00', 'OK', 20030205153714, 0),
(418, 199, 1, '2003-01-13', '2003-01-21', '90.00', 'OK', 20030205153714, 0),
(419, 193, 1, '2003-01-13', '2003-01-21', '20.00', 'ERRO', 20030205153714, 0),
(420, 193, 2, '2003-02-13', '2003-02-24', '20.00', 'ERRO', 20030224163821, 0),
(421, 193, 3, '2003-03-13', '2003-03-25', '20.00', 'ERRO', 20030325173023, 0),
(422, 193, 1, '2003-01-13', '2003-01-21', '20.00', 'ERRO', 20030205153714, 0),
(423, 193, 2, '2003-02-13', '2003-02-24', '20.00', 'ERRO', 20030224163822, 0),
(424, 193, 3, '2003-03-13', '2003-03-25', '20.00', 'ERRO', 20030325173024, 0),
(425, 200, 1, '2003-01-13', '2003-01-15', '90.00', 'OK', 20030205153714, 0),
(426, 201, 1, '2003-01-14', '2003-01-22', '60.00', 'OK', 20030205153714, 0),
(427, 202, 1, '2003-01-14', '2003-01-15', '30.00', 'OK', 20030205153714, 0),
(428, 203, 1, '2003-01-14', '2003-01-16', '30.00', 'OK', 20030205153714, 0),
(429, 204, 1, '2003-01-15', '0000-00-00', '150.00', 'NE', 20030205153714, 0),
(430, 205, 1, '2003-01-15', '2003-01-23', '50.00', 'OK', 20030205153714, 0),
(431, 205, 2, '2003-02-15', '2003-02-24', '50.00', 'ERRO', 20030224163156, 0),
(432, 205, 3, '2003-03-15', '2003-03-25', '50.00', 'OK', 20030325161556, 0),
(433, 206, 1, '2003-01-16', '2003-01-17', '30.00', 'OK', 20030205153713, 0),
(434, 207, 1, '2003-01-16', '2003-01-23', '50.00', 'OK', 20030205153713, 0),
(435, 207, 2, '2003-02-16', '2003-02-21', '50.00', 'OK', 20030221164730, 0),
(436, 207, 3, '2003-03-16', '2003-03-25', '50.00', 'OK', 20030325191126, 0),
(437, 208, 1, '2003-01-16', '2003-01-17', '60.00', 'ERRO', 20030205153713, 0),
(438, 209, 1, '2003-01-16', '2003-01-27', '10.00', 'OK', 20030205153713, 0),
(391, 193, 2, '2003-02-10', '2003-02-18', '120.00', 'ERRO', 20030218172806, 0),
(390, 193, 1, '2003-01-10', '2003-01-20', '120.00', 'ERRO', 20030205153715, 0),
(439, 209, 2, '2003-02-16', '2003-02-24', '10.00', 'OK', 20030224163157, 0),
(440, 209, 3, '2003-03-16', '2003-03-25', '10.00', 'OK', 20030325161556, 0),
(441, 210, 1, '2003-01-17', '2003-01-24', '30.00', 'OK', 20030205153713, 0),
(442, 211, 1, '2003-01-17', '0000-00-00', '150.00', 'NE', 20030205153713, 0),
(443, 211, 1, '2003-01-17', '0000-00-00', '150.00', 'NE', 20030205153713, 0),
(444, 212, 1, '2003-01-17', '2003-01-24', '30.00', 'OK', 20030205153713, 0),
(445, 213, 1, '2003-01-17', '0000-00-00', '150.00', 'NE', 20030205153713, 0),
(446, 211, 1, '2003-01-17', '2003-01-17', '150.00', 'NE', 20030205153713, 0),
(447, 211, 1, '2003-01-17', '2003-01-17', '150.00', 'NE', 20030205153713, 0),
(448, 214, 1, '2003-01-17', '2003-01-27', '150.00', 'ERRO', 20030205153713, 0),
(449, 211, 1, '2003-01-17', '0000-00-00', '150.00', 'NE', 20030205153713, 0),
(450, 211, 1, '2003-01-17', '2003-04-02', '150.00', 'OK', 20030402104306, 0),
(451, 215, 1, '2003-01-19', '2003-01-20', '150.00', 'E', 20030205153713, 0),
(452, 216, 1, '2003-01-20', '2003-01-28', '30.00', 'ERRO', 20030205153713, 0),
(453, 216, 1, '2003-01-20', '2003-01-28', '30.00', 'ERRO', 20030205153713, 0),
(454, 217, 1, '2003-01-20', '2003-01-22', '30.00', 'ERRO', 20030205153713, 0),
(455, 216, 1, '2003-01-20', '2003-01-28', '30.00', 'ERRO', 20030205153713, 0),
(456, 218, 1, '2003-01-20', '2003-01-28', '30.00', 'ERRO', 20030205153713, 0),
(457, 218, 1, '2003-01-20', '2003-01-28', '30.00', 'ERRO', 20030205153713, 0),
(458, 216, 1, '2003-01-20', '2003-01-28', '150.00', 'ERRO', 20030205153713, 0),
(459, 210, 1, '2003-01-20', '2003-01-27', '30.00', 'OK', 20030205153713, 0),
(460, 219, 1, '2003-01-20', '2003-01-27', '30.00', 'OK', 20030205153713, 0),
(461, 219, 2, '2003-02-20', '2003-02-27', '30.00', 'OK', 20030227180552, 0),
(462, 219, 3, '2003-03-20', '2003-03-27', '30.00', 'OK', 20030327174030, 0),
(463, 220, 1, '2003-01-20', '2003-01-22', '30.00', 'OK', 20030205153713, 0),
(464, 210, 1, '2003-01-20', '2003-01-27', '30.00', 'OK', 20030205153713, 0),
(465, 221, 1, '2003-01-20', '2003-01-27', '30.00', 'ERRO', 20030205153712, 0),
(466, 221, 2, '2003-02-20', '2003-02-27', '30.00', 'ERRO', 20030227180758, 0),
(467, 221, 3, '2003-03-20', '2003-03-27', '30.00', 'ERRO', 20030327174604, 0),
(468, 222, 1, '2003-01-21', '2003-01-29', '150.00', 'ERRO', 20030205153712, 0),
(469, 222, 2, '2003-02-21', '2003-03-05', '150.00', 'ERRO', 20030305170325, 0),
(470, 222, 3, '2003-03-21', '2003-04-01', '150.00', 'ERRO', 20030401110622, 0),
(471, 223, 1, '2003-01-21', '2003-01-28', '30.00', 'OK', 20030205153712, 0),
(472, 224, 1, '2003-01-21', '2003-01-28', '30.00', 'OK', 20030205153712, 0),
(473, 224, 2, '2003-02-21', '2003-03-05', '30.00', 'OK', 20030305120706, 0),
(474, 224, 3, '2003-03-21', '2003-03-31', '30.00', 'OK', 20030331161533, 0),
(475, 225, 1, '2003-01-21', '2003-01-30', '10.00', 'OK', 20030205153712, 0),
(476, 225, 2, '2003-02-21', '2003-03-05', '10.00', 'OK', 20030305165952, 0),
(477, 225, 3, '2003-03-21', '2003-04-01', '10.00', 'OK', 20030401182841, 0),
(478, 226, 1, '2003-01-21', '2003-01-30', '20.00', 'OK', 20030205153712, 0),
(479, 226, 2, '2003-02-21', '2003-03-05', '20.00', 'OK', 20030305165952, 0),
(480, 226, 3, '2003-03-21', '2003-04-01', '20.00', 'OK', 20030401182842, 0),
(481, 227, 1, '2003-01-22', '2003-01-31', '60.00', 'ERRO', 20030205153712, 0),
(482, 228, 1, '2003-01-22', '2003-01-29', '30.00', 'OK', 20030205153712, 0),
(483, 229, 1, '2003-01-22', '2003-01-29', '10.00', 'OK', 20030205153712, 0),
(484, 229, 2, '2003-02-22', '2003-03-05', '10.00', 'OK', 20030305120707, 0),
(485, 229, 3, '2003-03-22', '2003-03-31', '10.00', 'OK', 20030331161534, 0),
(486, 230, 1, '2003-01-22', '2003-01-23', '90.00', 'OK', 20030205153712, 0),
(487, 231, 1, '2003-01-22', '2003-01-24', '30.00', 'OK', 20030205153712, 0),
(488, 232, 1, '2003-01-23', '2003-01-27', '30.00', 'OK', 20030205153712, 0),
(489, 233, 1, '2003-01-23', '2003-01-27', '90.00', 'OK', 20030205153712, 0),
(490, 234, 1, '2003-01-23', '2003-01-30', '30.00', 'OK', 20030205153712, 0),
(491, 235, 1, '2003-01-23', '2003-01-30', '20.00', 'OK', 20030205153712, 0),
(492, 235, 2, '2003-02-23', '2003-03-05', '20.00', 'OK', 20030305120308, 0),
(493, 235, 3, '2003-03-23', '2003-03-31', '20.00', 'OK', 20030331161204, 0),
(494, 236, 1, '2003-01-24', '2003-01-27', '30.00', 'OK', 20030205153711, 0),
(495, 237, 1, '2003-01-24', '2003-01-27', '150.00', 'OK', 20030205153711, 0),
(496, 238, 1, '2003-01-24', '2003-02-03', '60.00', 'OK', 20030205153711, 0),
(497, 239, 1, '2003-01-24', '2003-02-03', '50.00', 'ERRO', 20030205153711, 0),
(498, 239, 2, '2003-02-24', '2003-03-06', '50.00', 'OK', 20030306175548, 0),
(499, 239, 3, '2003-03-24', '2003-04-01', '50.00', 'OK', 20030401180346, 0),
(500, 240, 1, '2003-01-24', '2003-01-28', '30.00', 'OK', 20030205153711, 0),
(501, 241, 1, '2003-01-25', '2003-01-27', '30.00', 'ERRO', 20030205153711, 0),
(502, 242, 1, '2003-01-26', '2003-01-27', '100.00', 'OK', 20030205153711, 0),
(503, 243, 1, '2003-01-26', '2003-02-03', '10.00', 'OK', 20030205153711, 0),
(504, 243, 2, '2003-02-26', '2003-03-10', '10.00', 'OK', 20030310173911, 0),
(505, 243, 3, '2003-03-26', '2003-04-03', '10.00', 'OK', 20030403163806, 0),
(506, 244, 1, '2003-01-26', '2003-01-28', '30.00', 'OK', 20030205153711, 0),
(507, 245, 1, '2003-01-26', '2003-01-27', '30.00', 'OK', 20030205153711, 0),
(508, 246, 1, '2003-01-27', '2003-02-03', '20.00', 'OK', 20030205153711, 0),
(509, 246, 2, '2003-02-27', '2003-03-10', '20.00', 'OK', 20030310183226, 0),
(510, 246, 3, '2003-03-27', '2003-04-07', '20.00', 'OK', 20030407110332, 0),
(511, 247, 1, '2003-01-27', '2003-01-28', '100.00', 'OK', 20030205153711, 0),
(512, 246, 1, '2003-01-27', '2003-02-03', '20.00', 'OK', 20030205153710, 0),
(513, 246, 2, '2003-02-27', '2003-03-10', '20.00', 'OK', 20030310183226, 0),
(514, 246, 3, '2003-03-27', '2003-04-07', '20.00', 'OK', 20030407110333, 0),
(515, 250, 1, '2003-01-27', '2003-02-04', '30.00', 'OK', 20030205153710, 0),
(516, 252, 1, '2003-01-27', '2003-01-29', '30.00', 'OK', 20030205153710, 0),
(517, 216, 1, '2003-01-27', '2003-02-04', '340.00', 'ERRO', 20030205153710, 0),
(518, 253, 1, '2003-01-27', '2003-02-04', '340.00', 'ERRO', 20030205153710, 0),
(519, 254, 1, '2003-01-27', '2003-02-04', '340.00', 'ERRO', 20030205153710, 0),
(520, 254, 1, '2003-01-27', '2003-02-04', '340.00', 'ERRO', 20030205153710, 0),
(521, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(522, 216, 1, '2003-01-27', '2003-02-04', '340.00', 'ERRO', 20030205153710, 0),
(523, 216, 1, '2003-01-27', '2003-02-04', '340.00', 'ERRO', 20030205153710, 0),
(524, 256, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(525, 216, 1, '2003-01-27', '2003-02-04', '150.00', 'ERRO', 20030205153710, 0),
(526, 216, 1, '2003-01-27', '2003-02-04', '150.00', 'ERRO', 20030205153710, 0),
(527, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(528, 216, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(529, 216, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(530, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(531, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(532, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(533, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(534, 255, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(535, 257, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(536, 257, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(537, 257, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(538, 257, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(539, 216, 1, '2003-01-27', '2003-02-04', '60.00', 'ERRO', 20030205153710, 0),
(540, 258, 1, '2003-01-27', '2003-02-04', '30.00', 'OK', 20030205153710, 0),
(541, 259, 1, '2003-01-27', '2003-02-03', '30.00', 'OK', 20030205153709, 0),
(542, 260, 1, '2003-01-27', '2003-02-04', '60.00', 'OK', 20030205153709, 0),
(543, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164118, 0),
(544, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164118, 0),
(545, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164118, 0),
(546, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164119, 0),
(547, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164120, 0),
(548, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164120, 0),
(549, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164121, 0),
(550, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164122, 0),
(551, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164123, 0),
(552, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164123, 0),
(553, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164124, 0),
(554, 257, 1, '2003-01-28', '2003-02-05', '60.00', 'ERRO', 20030205164124, 0),
(555, 257, 1, '2003-01-28', '2003-02-05', '640.00', 'ERRO', 20030205164124, 0),
(556, 261, 1, '2003-01-28', '2003-01-30', '60.00', 'OK', 20030205153709, 0),
(557, 262, 1, '2003-02-12', '2003-02-14', '30.00', 'OK', 20030214151339, 0),
(558, 263, 1, '2003-01-29', '2003-02-07', '50.00', 'ERRO', 20030207151404, 0),
(559, 263, 2, '2003-02-28', '2003-03-13', '50.00', 'ERRO', 20030313174435, 0),
(560, 263, 3, '2003-03-29', '2003-04-10', '50.00', 'ERRO', 20030410145444, 0),
(561, 216, 1, '2003-01-29', '2003-02-07', '150.00', 'ERRO', 20030207151428, 0),
(562, 257, 1, '2003-01-29', '2003-02-07', '60.00', 'ERRO', 20030207151437, 0),
(563, 263, 1, '2003-01-29', '2003-02-07', '50.00', 'ERRO', 20030207151440, 0),
(564, 263, 2, '2003-02-28', '2003-03-13', '50.00', 'ERRO', 20030313174437, 0),
(565, 263, 3, '2003-03-29', '2003-04-10', '50.00', 'ERRO', 20030410145444, 0),
(566, 263, 1, '2003-01-29', '2003-02-07', '50.00', 'ERRO', 20030207151443, 0),
(567, 263, 2, '2003-02-28', '2003-03-13', '50.00', 'ERRO', 20030313174437, 0),
(568, 263, 3, '2003-03-29', '2003-04-10', '50.00', 'ERRO', 20030410145445, 0),
(569, 263, 1, '2003-01-29', '2003-02-07', '50.00', 'ERRO', 20030207151443, 0),
(570, 263, 2, '2003-02-28', '2003-03-13', '50.00', 'ERRO', 20030313174437, 0),
(571, 263, 3, '2003-03-29', '2003-04-10', '50.00', 'ERRO', 20030410145445, 0),
(572, 264, 1, '2003-01-29', '2003-02-07', '0.00', 'ERRO', 20030207151448, 0),
(573, 264, 2, '2003-02-28', '2003-03-13', '0.00', 'ERRO', 20030313174438, 0),
(574, 264, 3, '2003-03-29', '2003-04-10', '0.00', 'ERRO', 20030410145445, 0),
(575, 266, 1, '2003-01-29', '2003-02-07', '60.00', 'ERRO', 20030207151450, 0),
(576, 267, 1, '2003-01-29', '2003-02-07', '150.00', 'ERRO', 20030207151452, 0),
(577, 266, 1, '2003-01-29', '2003-02-07', '60.00', 'ERRO', 20030207151457, 0),
(578, 268, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129103939, 0),
(579, 268, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129104019, 0),
(580, 268, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129104321, 0),
(581, 269, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030129105313, 0),
(582, 269, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030129105546, 0),
(583, 269, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030129105704, 0),
(584, 269, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030129105725, 0),
(585, 270, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129110006, 0),
(586, 270, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129110334, 0),
(587, 270, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129110532, 0),
(588, 270, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129110804, 0),
(589, 270, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030129111109, 0),
(590, 271, 1, '0000-00-00', '0000-00-00', '20.00', 'NE', 20030129111714, 0),
(591, 272, 1, '0000-00-00', '0000-00-00', '640.00', 'NE', 20030129111817, 0),
(592, 272, 1, '0000-00-00', '0000-00-00', '640.00', 'NE', 20030129112039, 0),
(593, 272, 1, '0000-00-00', '0000-00-00', '640.00', 'NE', 20030129112257, 0),
(594, 272, 1, '2003-01-31', '0000-00-00', '640.00', 'NE', 20030205153708, 0),
(595, 272, 1, '2003-01-31', '2003-02-10', '640.00', 'ERRO', 20030210170415, 0),
(596, 272, 1, '2003-01-31', '2003-02-10', '640.00', 'ERRO', 20030210170415, 0),
(597, 272, 1, '2003-01-31', '2003-02-10', '640.00', 'ERRO', 20030210170416, 0),
(598, 271, 1, '0000-00-00', '0000-00-00', '50.00', 'NE', 20030129113208, 0),
(599, 273, 1, '2003-01-29', '2003-02-07', '50.00', 'ERRO', 20030207151458, 0),
(600, 273, 2, '2003-02-28', '2003-03-13', '50.00', 'ERRO', 20030313174438, 0),
(601, 273, 3, '2003-03-29', '2003-04-10', '50.00', 'ERRO', 20030410145447, 0),
(602, 266, 1, '2003-01-29', '2003-02-07', '150.00', 'ERRO', 20030207151459, 0),
(603, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(604, 213, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(605, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(606, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(607, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(608, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(609, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(610, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(611, 216, 1, '2003-01-29', '2003-02-07', '150.00', 'ERRO', 20030207151459, 0),
(612, 211, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(613, 274, 1, '2003-01-29', '2003-02-07', '340.00', 'ERRO', 20030207151503, 0),
(614, 257, 1, '2003-01-29', '2003-02-07', '60.00', 'ERRO', 20030207151505, 0),
(615, 257, 1, '2003-01-29', '2003-02-07', '60.00', 'ERRO', 20030207151507, 0),
(616, 276, 1, '0000-00-00', '0000-00-00', '640.00', 'C', 20030221162231, 0),
(617, 216, 1, '2003-01-20', '0000-00-00', '640.00', 'NE', 20030205153707, 0),
(618, 276, 1, '2003-01-29', '2003-01-31', '640.00', 'ERRO', 20030205153707, 0),
(619, 277, 1, '2003-01-20', '0000-00-00', '340.00', 'NE', 20030205153707, 0),
(620, 257, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163323, 0),
(621, 257, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163324, 0),
(622, 278, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030130122353, 0),
(623, 279, 1, '2000-01-01', '2003-02-11', '60.00', 'E', 20030220114950, 0),
(624, 280, 1, '2003-02-03', '2003-02-05', '60.00', 'ERRO', 20030205153707, 0),
(625, 281, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163324, 0),
(626, 281, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163324, 0),
(627, 281, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163324, 0),
(628, 281, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163324, 0),
(629, 257, 1, '2003-02-03', '2003-02-11', '60.00', 'ERRO', 20030211163325, 0),
(630, 282, 1, '2003-02-03', '2003-02-10', '60.00', 'E', 20030210165406, 0),
(631, 283, 1, '2003-02-03', '2003-02-11', '60.00', 'OK', 20030211163242, 0),
(632, 284, 1, '2003-01-29', '2003-02-07', '150.00', 'ERRO', 20030207151509, 0),
(633, 285, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(634, 286, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(635, 287, 1, '2003-01-29', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(636, 288, 1, '2003-02-04', '2003-02-12', '60.00', 'OK', 20030212174409, 0),
(637, 289, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030130120304, 0),
(638, 290, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203082901, 0),
(639, 291, 1, '2003-01-30', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(640, 292, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(641, 293, 1, '2003-01-30', '2003-01-31', '100.00', 'OK', 20030205153707, 0),
(642, 294, 1, '2003-01-30', '0000-00-00', '150.00', 'NE', 20030205153707, 0),
(643, 295, 1, '0000-00-00', '0000-00-00', '640.00', 'NE', 20030212174426, 0),
(644, 296, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(645, 297, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(646, 298, 1, '0000-00-00', '0000-00-00', '640.00', 'NE', 20030212174426, 0),
(647, 299, 1, '2003-01-30', '0000-00-00', '150.00', 'NE', 20030205153706, 0),
(648, 300, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(649, 301, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(650, 302, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(651, 303, 1, '2003-02-04', '2003-02-12', '60.00', 'ERRO', 20030212174253, 0),
(652, 304, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030212174426, 0),
(653, 305, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(654, 306, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(655, 307, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(656, 308, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(657, 309, 1, '2003-01-30', '0000-00-00', '150.00', 'NE', 20030205153706, 0),
(658, 310, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203112148, 0),
(659, 311, 1, '2003-01-30', '0000-00-00', '100.00', 'NE', 20030205153706, 0),
(660, 312, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(661, 313, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(662, 314, 1, '2003-02-04', '2003-02-06', '60.00', 'OK', 20030206142158, 0),
(663, 315, 1, '2003-01-30', '0000-00-00', '150.00', 'NE', 20030205153706, 0),
(664, 316, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(665, 317, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(666, 318, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(667, 319, 1, '2003-01-30', '0000-00-00', '150.00', 'NE', 20030205153706, 0),
(668, 320, 1, '2003-01-30', '2003-02-07', '30.00', 'OK', 20030207175251, 0),
(669, 321, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203132838, 0),
(670, 322, 1, '2003-01-30', '2003-02-07', '20.00', 'OK', 20030207175127, 0),
(671, 322, 2, '2003-02-28', '2003-03-13', '20.00', 'OK', 20030313174326, 0),
(672, 322, 3, '2003-03-30', '2003-04-07', '20.00', 'OK', 20030407171852, 0),
(673, 323, 1, '2003-01-30', '2003-01-31', '30.00', 'OK', 20030205153706, 0),
(674, 324, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030201194904, 0),
(675, 325, 1, '2003-02-04', '2003-02-12', '60.00', 'ERRO', 20030212174216, 0),
(676, 326, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153706, 0),
(677, 327, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030130201550, 0),
(678, 328, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030202015520, 0),
(679, 329, 1, '2003-01-31', '2003-02-10', '30.00', 'OK', 20030210170336, 0),
(680, 330, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030204094303, 0),
(681, 331, 1, '2003-01-31', '2003-02-04', '60.00', 'C', 20030205153705, 0),
(682, 332, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203105549, 0),
(683, 333, 1, '2003-01-31', '2003-02-04', '60.00', 'OK', 20030205153705, 0),
(684, 334, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205220739, 0),
(685, 335, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030131141934, 0),
(686, 336, 1, '2003-02-02', '2003-02-04', '60.00', 'OK', 20030205153705, 0),
(687, 337, 1, '2003-02-02', '2003-02-04', '60.00', 'OK', 20030205153705, 0),
(688, 338, 1, '2003-02-28', '2003-02-05', '60.00', 'ERRO', 20030225120459, 0),
(689, 339, 1, '2003-01-25', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(690, 340, 1, '2003-01-31', '0000-00-00', '30.00', 'NE', 20030205153705, 0),
(691, 341, 1, '2003-01-31', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(692, 342, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(693, 343, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(694, 344, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030131105546, 0),
(695, 345, 1, '2003-02-05', '2003-02-12', '60.00', 'OK', 20030212174710, 0),
(696, 346, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030131133701, 0),
(697, 347, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(698, 348, 1, '2003-01-31', '0000-00-00', '150.00', 'NE', 20030205153705, 0),
(699, 349, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212174426, 0),
(700, 350, 1, '2003-02-05', '2003-02-14', '60.00', 'ERRO', 20030214174135, 0),
(701, 351, 1, '2003-02-05', '2003-02-04', '60.00', 'OK', 20030205153705, 0),
(702, 352, 1, '2003-01-31', '0000-00-00', '150.00', 'NE', 20030205153705, 0),
(703, 353, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(704, 354, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(705, 355, 1, '2003-01-31', '2003-02-03', '60.00', 'OK', 20030205153705, 0),
(706, 356, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203092956, 0),
(707, 357, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(708, 358, 1, '2003-02-12', '2003-02-19', '60.00', 'ERRO', 20030219173526, 0),
(709, 359, 1, '2003-02-02', '2003-02-05', '60.00', 'ERRO', 20030205161235, 0),
(710, 360, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203105841, 0),
(711, 361, 1, '2003-02-03', '2003-02-11', '60.00', 'C', 20030211163325, 0),
(712, 362, 1, '2003-02-03', '2003-02-11', '60.00', 'C', 20030211163242, 0),
(713, 363, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030203091628, 0),
(714, 364, 1, '0000-00-00', '0000-00-00', '60.00', 'C', 20030325101041, 0),
(715, 365, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030131172203, 0),
(716, 366, 1, '2003-01-31', '2003-02-07', '30.00', 'OK', 20030207173249, 0),
(717, 367, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153705, 0),
(718, 368, 1, '2003-02-01', '2003-02-10', '20.00', 'OK', 20030210165407, 0),
(719, 368, 2, '2003-03-01', '2003-03-14', '20.00', 'OK', 20030314180418, 0),
(720, 368, 3, '2003-04-01', '2003-04-08', '20.00', 'OK', 20030408114528, 0),
(721, 369, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030201200542, 0),
(722, 370, 1, '0000-00-00', '0000-00-00', '100.00', 'NE', 20030205153704, 0),
(723, 371, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153704, 0),
(724, 372, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153704, 0),
(725, 373, 1, '2003-02-02', '2003-02-11', '10.00', 'OK', 20030211163325, 0),
(726, 373, 2, '2003-03-02', '2003-03-13', '10.00', 'OK', 20030313174505, 0),
(727, 373, 3, '2003-04-02', '2003-04-11', '10.00', 'OK', 20030411181859, 0),
(728, 374, 1, '2003-02-02', '2003-02-04', '30.00', 'OK', 20030205153704, 0),
(729, 375, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030202234455, 0),
(730, 376, 1, '2003-02-03', '2003-02-10', '10.00', 'OK', 20030210165407, 0),
(731, 376, 2, '2003-03-03', '2003-03-14', '10.00', 'OK', 20030314180419, 0),
(732, 376, 3, '2003-04-03', '2003-04-11', '10.00', 'OK', 20030411185326, 0),
(733, 377, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030207135521, 0),
(734, 378, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030207164234, 0),
(735, 379, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153704, 0),
(736, 380, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153704, 0),
(737, 381, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030207162851, 0),
(738, 382, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153703, 0),
(739, 383, 1, '2003-02-03', '2003-02-11', '10.00', 'OK', 20030211163242, 0),
(740, 383, 2, '2003-03-03', '2003-03-14', '10.00', 'OK', 20030314175319, 0),
(741, 383, 3, '2003-04-03', '2003-04-15', '10.00', 'OK', 20030415110433, 0),
(742, 384, 1, '2003-02-03', '2003-02-04', '30.00', 'OK', 20030205153703, 0),
(743, 385, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153703, 0),
(744, 386, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153703, 0),
(745, 387, 1, '2003-02-10', '2003-02-11', '60.00', 'OK', 20030211082659, 0),
(746, 388, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153702, 0),
(747, 389, 1, '2003-02-04', '0000-00-00', '30.00', 'NE', 20030205153702, 0),
(748, 390, 1, '0000-00-00', '2003-03-25', '60.00', 'OK', 20030325161558, 0),
(749, 391, 1, '2003-02-04', '0000-00-00', '90.00', 'NE', 20030205153702, 0),
(750, 392, 1, '2003-02-04', '0000-00-00', '60.00', 'NE', 20030205153702, 0),
(751, 393, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030207133742, 0),
(752, 394, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205153702, 0),
(753, 395, 1, '2003-02-04', '2003-03-26', '20.00', 'OK', 20030326121155, 0),
(754, 395, 2, '2003-03-04', '2003-03-12', '20.00', 'OK', 20030312175611, 0),
(755, 395, 3, '2003-04-04', '2003-03-27', '20.00', 'OK', 20030327173601, 0),
(756, 396, 1, '0000-00-00', '2003-03-26', '60.00', 'ERRO', 20030326180742, 0),
(757, 397, 1, '0000-00-00', '2003-03-26', '60.00', 'ERRO', 20030326180743, 0),
(758, 398, 1, '2003-02-09', '2003-03-27', '60.00', 'OK', 20030327173632, 0),
(759, 399, 1, '0000-00-00', '2003-03-27', '60.00', 'ERRO', 20030327173948, 0),
(760, 400, 1, '0000-00-00', '0000-00-00', '150.00', 'NE', 20030205153658, 0),
(761, 401, 1, '2003-02-11', '2003-02-11', '60.00', 'OK', 20030211082701, 0),
(762, 402, 1, '2003-02-05', '2003-03-31', '100.00', 'OK', 20030331155022, 0),
(763, 403, 1, '2003-02-05', '2003-02-14', '10.00', 'OK', 20030214174048, 0),
(764, 403, 2, '2003-03-05', '2003-03-24', '10.00', 'OK', 20030324110240, 0),
(765, 403, 3, '2003-04-05', '2003-03-21', '10.00', 'OK', 20030321175848, 0),
(766, 404, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205135929, 0),
(767, 405, 1, '0000-00-00', '2003-03-25', '60.00', 'OK', 20030325194044, 0),
(768, 406, 1, '2003-02-18', '2003-03-31', '60.00', 'OK', 20030331161535, 0),
(769, 407, 1, '0000-00-00', '2003-04-01', '60.00', 'ERRO', 20030401182843, 0),
(770, 408, 1, '2003-02-05', '2003-02-14', '30.00', 'OK', 20030214174049, 0),
(771, 409, 1, '2003-02-05', '2003-02-12', '10.00', 'OK', 20030212174713, 0),
(772, 409, 2, '2003-03-05', '2003-03-14', '10.00', 'OK', 20030314180420, 0),
(773, 409, 3, '2003-04-05', '2003-04-11', '10.00', 'OK', 20030411185923, 0),
(774, 410, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030205163027, 0),
(775, 411, 1, '2003-02-05', '2003-02-12', '30.00', 'ERRO', 20030212174235, 0),
(776, 412, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030206081117, 0),
(777, 413, 1, '0000-00-00', '0000-00-00', '30.00', 'NE', 20030206094956, 0),
(778, 414, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030206101107, 0),
(779, 415, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030206110322, 0),
(780, 416, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030211094407, 0),
(781, 417, 1, '0000-00-00', '0000-00-00', '30.00', 'NE', 20030206175107, 0),
(782, 418, 1, '2003-02-06', '2003-02-14', '60.00', 'OK', 20030214174548, 0),
(783, 419, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030211010303, 0),
(784, 420, 1, '0000-00-00', '0000-00-00', '30.00', 'NE', 20030206192735, 0),
(785, 421, 1, '2003-02-07', '2003-02-08', '30.00', 'OK', 20030208083034, 0),
(786, 422, 1, '2003-02-07', '2003-02-14', '33.33', 'OK', 20030214174647, 0),
(787, 422, 2, '2003-03-26', '0000-00-00', '33.33', 'NR', 20030326101825, 0),
(788, 422, 3, '2003-04-07', '2003-04-15', '33.33', 'OK', 20030415144307, 0),
(789, 423, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030207153216, 0),
(790, 424, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162540, 0),
(791, 425, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162541, 0),
(792, 426, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162541, 0),
(793, 427, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162541, 0),
(794, 428, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162541, 0),
(795, 429, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162542, 0),
(796, 430, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162542, 0),
(797, 431, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162542, 0),
(798, 432, 1, '2003-02-12', '2003-02-21', '60.00', 'ERRO', 20030221162542, 0),
(799, 433, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030207161655, 0),
(800, 434, 1, '2003-02-22', '0000-00-00', '60.00', 'C', 20030224000027, 0),
(801, 435, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030214085737, 0),
(802, 436, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030214085738, 0),
(803, 437, 1, '2003-02-07', '2003-02-18', '60.00', 'ERRO', 20030218172741, 0),
(804, 437, 2, '2003-03-26', '0000-00-00', '60.00', 'NR', 20030326102242, 0),
(805, 437, 3, '2003-04-07', '2003-04-16', '60.00', 'OK', 20030416175404, 0),
(806, 438, 1, '2003-02-07', '2003-02-14', '30.00', 'OK', 20030214174647, 0),
(807, 438, 2, '2003-03-26', '0000-00-00', '30.00', 'NR', 20030326102204, 0),
(808, 438, 3, '2003-04-07', '2003-04-15', '30.00', 'OK', 20030415144308, 0),
(809, 439, 1, '2003-02-08', '2003-02-14', '30.00', 'OK', 20030214174648, 0),
(810, 440, 1, '0000-00-00', '0000-00-00', '30.00', 'NE', 20030208121016, 0),
(811, 441, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030213214409, 0),
(812, 442, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030209122449, 0),
(813, 443, 1, '2003-02-09', '2003-02-17', '10.00', 'OK', 20030217182511, 0),
(814, 443, 2, '2003-03-09', '2003-03-17', '10.00', 'OK', 20030317153831, 0),
(815, 443, 3, '2003-04-09', '2003-04-17', '10.00', 'OK', 20030417151907, 0),
(816, 444, 1, '2003-02-09', '2003-02-17', '90.00', 'OK', 20030217182517, 0),
(817, 445, 1, '2003-02-09', '2003-02-17', '30.00', 'OK', 20030217182522, 0),
(818, 446, 1, '2003-02-10', '2003-02-12', '30.00', 'OK', 20030212150257, 0),
(819, 447, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217065943, 0),
(820, 448, 1, '2003-02-10', '2003-02-18', '100.00', 'C', 20030218172810, 0),
(821, 449, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217065943, 0),
(822, 450, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030211225948, 0),
(823, 451, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030214002056, 0),
(824, 452, 1, '2003-02-11', '2003-02-19', '10.00', 'ERRO', 20030219173357, 0),
(825, 452, 2, '2003-03-11', '2003-03-19', '10.00', 'ERRO', 20030319170834, 0),
(826, 452, 3, '2003-04-11', '0000-00-00', '10.00', 'NR', 20030414095309, 0),
(827, 453, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030213002737, 0),
(828, 454, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065942, 0),
(829, 455, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065942, 0),
(830, 456, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065942, 0),
(831, 457, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065942, 0),
(832, 458, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065942, 0),
(833, 459, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030213085114, 0),
(834, 460, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065943, 0),
(835, 461, 1, '2003-02-11', '2003-02-12', '120.00', 'OK', 20030212174223, 0),
(836, 462, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217120311, 0),
(837, 463, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065943, 0),
(838, 464, 1, '2003-02-11', '2003-02-18', '30.00', 'OK', 20030218172848, 0),
(839, 465, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065943, 0),
(840, 466, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030218065943, 0),
(841, 467, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065943, 0),
(842, 468, 1, '2003-02-11', '2003-02-13', '120.00', 'OK', 20030213150751, 0),
(843, 469, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218065943, 0),
(844, 470, 1, '0000-00-00', '0000-00-00', '340.00', 'NE', 20030220065938, 0),
(845, 471, 1, '0000-00-00', '0000-00-00', '640.00', 'NE', 20030213151635, 0),
(846, 472, 1, '0000-00-00', '0000-00-00', '50.00', 'NE', 20030211154223, 0),
(847, 472, 2, '0000-00-00', '0000-00-00', '50.00', 'NE', 20030211154223, 0),
(848, 472, 3, '0000-00-00', '0000-00-00', '50.00', 'NE', 20030211154223, 0),
(849, 473, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030220065939, 0),
(850, 474, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217183257, 0),
(851, 475, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030211170638, 0),
(852, 476, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030220065939, 0),
(853, 477, 1, '2003-02-11', '2003-02-18', '20.00', 'OK', 20030218173201, 0),
(854, 477, 2, '2003-03-11', '2003-03-18', '20.00', 'OK', 20030318155525, 0),
(855, 477, 3, '2003-04-11', '0000-00-00', '20.00', 'NR', 20030414095309, 0),
(856, 478, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030211200407, 0),
(857, 479, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217130841, 0),
(858, 480, 1, '2003-02-12', '2003-02-13', '30.00', 'ERRO', 20030213153301, 0),
(859, 481, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221065936, 0),
(860, 482, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219110004, 0),
(861, 483, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217132626, 0),
(862, 484, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219191620, 0),
(863, 485, 1, '2003-02-12', '2003-02-14', '30.00', 'OK', 20030214151342, 0),
(864, 486, 1, '2003-02-12', '2003-02-13', '30.00', 'ERRO', 20030213120945, 0),
(865, 487, 1, '2003-02-12', '2003-02-14', '30.00', 'OK', 20030214151343, 0),
(866, 488, 1, '2003-02-12', '2003-02-19', '33.33', 'OK', 20030219174406, 0),
(867, 488, 2, '2003-03-12', '2003-03-19', '33.33', 'OK', 20030319174244, 0),
(868, 488, 3, '2003-04-12', '0000-00-00', '33.33', 'NR', 20030414095309, 0),
(869, 489, 1, '2003-02-12', '2003-02-14', '150.00', 'OK', 20030214151343, 0),
(870, 490, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221065937, 0),
(871, 491, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221065937, 0),
(872, 492, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212143129, 0),
(873, 493, 1, '2003-02-12', '2003-02-19', '90.00', 'OK', 20030219174728, 0),
(874, 494, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218111925, 0),
(875, 495, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030214085738, 0),
(876, 496, 1, '0000-00-00', '0000-00-00', '120.00', 'NE', 20030214085738, 0),
(877, 497, 1, '2003-02-12', '2003-02-13', '90.00', 'OK', 20030213083014, 0),
(878, 498, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221065937, 0),
(879, 499, 1, '2003-02-19', '2003-02-27', '60.00', 'ERRO', 20030227180122, 0),
(880, 500, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160941, 0),
(881, 501, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160913, 0),
(882, 502, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160859, 0),
(883, 503, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160955, 0),
(884, 504, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212161004, 0),
(885, 505, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160925, 0),
(886, 506, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160907, 0),
(887, 507, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160932, 0),
(888, 508, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030212160949, 0),
(889, 509, 1, '2003-02-12', '2003-02-19', '20.00', 'OK', 20030219174448, 0),
(890, 509, 2, '2003-03-12', '2003-03-19', '20.00', 'ERRO', 20030319174113, 0),
(891, 509, 3, '2003-04-12', '0000-00-00', '20.00', 'NR', 20030414095309, 0),
(892, 510, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221065937, 0),
(893, 511, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221065937, 0),
(894, 512, 1, '2003-02-20', '0000-00-00', '60.00', 'C', 20030222065935, 0),
(895, 513, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030213110700, 0),
(896, 514, 1, '2003-02-13', '2003-02-17', '60.00', 'OK', 20030217171321, 0),
(897, 515, 1, '2000-01-01', '0000-00-00', '60.00', 'C', 20030214094303, 0),
(898, 516, 1, '2003-02-20', '0000-00-00', '60.00', 'C', 20030222065935, 0),
(899, 517, 1, '2003-02-13', '2003-02-20', '10.00', 'OK', 20030220175913, 0),
(900, 517, 2, '2003-03-13', '2003-03-20', '10.00', 'OK', 20030320171302, 0),
(901, 517, 3, '2003-04-13', '0000-00-00', '10.00', 'NR', 20030414095309, 0),
(902, 518, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219105103, 0),
(903, 519, 1, '2003-02-14', '2003-02-18', '30.00', 'OK', 20030218111153, 0),
(904, 520, 1, '2003-02-21', '0000-00-00', '60.00', 'C', 20030223000029, 0),
(905, 521, 1, '2003-02-14', '2003-02-24', '30.00', 'ERRO', 20030224163305, 0),
(906, 521, 2, '2003-03-14', '2003-03-25', '30.00', 'ERRO', 20030325183216, 0),
(907, 521, 3, '2003-04-14', '0000-00-00', '30.00', 'NR', 20030415095648, 0),
(908, 522, 1, '2000-01-01', '0000-00-00', '60.00', 'C', 20030214112045, 0),
(909, 523, 1, '2003-02-28', '2003-03-01', '90.00', 'OK', 20030301081916, 0),
(910, 524, 1, '2003-02-21', '0000-00-00', '60.00', 'C', 20030223000029, 0),
(911, 525, 1, '2003-02-14', '2003-02-24', '20.00', 'OK', 20030224163158, 0),
(912, 525, 2, '2003-03-14', '2003-03-25', '20.00', 'OK', 20030325161557, 0),
(913, 525, 3, '2003-04-14', '0000-00-00', '20.00', 'NR', 20030415095648, 0),
(914, 526, 1, '0000-00-00', '0000-00-00', '270.00', 'NE', 20030216065945, 0),
(915, 529, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030214161622, 0),
(916, 530, 1, '2003-02-14', '2003-02-24', '30.00', 'OK', 20030224163158, 0),
(917, 531, 1, '2003-02-21', '0000-00-00', '60.00', 'C', 20030223000029, 0),
(918, 532, 1, '2003-02-14', '2003-02-21', '10.00', 'OK', 20030221165415, 0),
(919, 532, 2, '2003-03-14', '2003-03-21', '10.00', 'OK', 20030321175710, 0),
(920, 532, 3, '2003-04-14', '0000-00-00', '10.00', 'NR', 20030415095648, 0),
(921, 533, 1, '2003-02-21', '0000-00-00', '60.00', 'C', 20030223000030, 0),
(922, 534, 1, '2003-02-14', '2003-02-18', '30.00', 'OK', 20030218111153, 0),
(923, 535, 1, '2003-02-22', '0000-00-00', '60.00', 'C', 20030224000027, 0),
(924, 536, 1, '0000-00-00', '0000-00-00', '100.00', 'NE', 20030217065944, 0),
(925, 537, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219223403, 0),
(926, 538, 1, '2003-02-15', '2003-02-21', '10.00', 'OK', 20030221162517, 0),
(927, 538, 2, '2003-03-15', '2003-03-21', '10.00', 'OK', 20030321173635, 0),
(928, 538, 3, '2003-04-15', '0000-00-00', '10.00', 'NR', 20030416144451, 0),
(929, 539, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030215235512, 0),
(930, 540, 1, '2003-02-23', '0000-00-00', '60.00', 'C', 20030222231252, 0),
(931, 541, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221114910, 0),
(932, 542, 1, '2003-02-23', '0000-00-00', '60.00', 'C', 20030223110818, 0),
(933, 543, 1, '2003-02-24', '0000-00-00', '60.00', 'C', 20030226070001, 0),
(934, 544, 1, '2003-02-17', '2003-02-24', '30.00', 'OK', 20030224164220, 0),
(935, 545, 1, '2003-02-24', '0000-00-00', '60.00', 'C', 20030226070001, 0),
(936, 546, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217122856, 0),
(937, 547, 1, '2003-02-24', '0000-00-00', '60.00', 'C', 20030226070001, 0),
(938, 548, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030220182559, 0),
(939, 549, 1, '2003-02-17', '2003-02-26', '30.00', 'OK', 20030226170218, 0),
(940, 550, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030217163217, 0),
(941, 551, 1, '2003-02-17', '2003-02-19', '60.00', 'OK', 20030219153559, 0),
(942, 552, 1, '2003-02-17', '2003-02-25', '20.00', 'ERRO', 20030225165658, 0),
(943, 552, 2, '2003-03-17', '2003-03-26', '20.00', 'OK', 20030326180652, 0),
(944, 552, 3, '2003-04-17', '0000-00-00', '20.00', 'NE', 20030217175748, 0),
(945, 553, 1, '2003-02-24', '0000-00-00', '60.00', 'C', 20030226070001, 0),
(946, 554, 1, '2003-02-24', '2003-02-25', '60.00', 'ERRO', 20030225165406, 0),
(947, 555, 1, '2003-02-19', '2003-02-19', '30.00', 'OK', 20030219081943, 0),
(948, 556, 1, '2003-02-18', '2003-02-20', '60.00', 'OK', 20030220110711, 0),
(949, 557, 1, '2003-02-25', '2003-03-11', '60.00', 'ERRO', 20030311181019, 0),
(950, 558, 1, '2000-01-01', '0000-00-00', '60.00', 'C', 20030220092023, 0),
(951, 559, 1, '2003-02-18', '2003-02-25', '30.00', 'OK', 20030225170745, 0),
(952, 560, 1, '2003-02-18', '2003-02-25', '30.00', 'OK', 20030225165632, 0),
(953, 561, 1, '2003-02-18', '2003-02-26', '30.00', 'OK', 20030226170238, 0),
(954, 561, 2, '2003-03-18', '2003-03-27', '30.00', 'OK', 20030327173601, 0),
(955, 561, 3, '2003-04-18', '0000-00-00', '30.00', 'NE', 20030218154816, 0),
(956, 562, 1, '2003-02-18', '2003-02-27', '360.00', 'ERRO', 20030227180053, 0),
(957, 563, 1, '2003-02-18', '2003-02-27', '360.00', 'ERRO', 20030227180054, 0),
(958, 564, 1, '2003-02-18', '2003-02-27', '360.00', 'ERRO', 20030227180054, 0),
(959, 565, 1, '2003-02-18', '2003-02-27', '480.00', 'ERRO', 20030227180055, 0),
(960, 566, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030220153111, 0),
(961, 567, 1, '2003-02-25', '2003-03-10', '60.00', 'OK', 20030310184158, 0),
(962, 568, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030218200838, 0),
(963, 569, 1, '2003-02-26', '0000-00-00', '60.00', 'C', 20030228070001, 0),
(964, 570, 1, '2003-02-19', '2003-02-21', '60.00', 'OK', 20030221104859, 0),
(965, 571, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219112827, 0),
(966, 572, 1, '2003-02-26', '0000-00-00', '60.00', 'C', 20030228070001, 0),
(967, 573, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219160114, 0),
(968, 574, 1, '2003-02-19', '2003-02-27', '150.00', 'ERRO', 20030227180006, 0),
(969, 575, 1, '2003-02-19', '2003-02-26', '20.00', 'OK', 20030226171019, 0),
(970, 575, 2, '2003-03-19', '2003-03-27', '20.00', 'OK', 20030327173949, 0),
(971, 575, 3, '2003-04-19', '0000-00-00', '20.00', 'NE', 20030219170927, 0),
(972, 576, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030219174250, 0),
(973, 577, 1, '2003-02-19', '2003-02-20', '30.00', 'OK', 20030220160821, 0),
(974, 578, 1, '2003-02-19', '2003-02-27', '10.00', 'OK', 20030227180126, 0),
(975, 578, 2, '2003-03-19', '2003-03-27', '10.00', 'OK', 20030327173751, 0),
(976, 578, 3, '2003-04-19', '0000-00-00', '10.00', 'NE', 20030219230740, 0),
(977, 579, 1, '2003-02-20', '2003-03-05', '33.33', 'ERRO', 20030305115302, 0),
(978, 579, 2, '2003-03-20', '2003-03-31', '33.33', 'ERRO', 20030331153846, 0),
(979, 579, 3, '2003-04-20', '0000-00-00', '33.33', 'NE', 20030220003855, 0),
(980, 580, 1, '2003-02-27', '2003-03-13', '60.00', 'ERRO', 20030313174314, 0),
(981, 581, 1, '2003-02-20', '2003-02-27', '30.00', 'OK', 20030227180552, 0),
(982, 581, 2, '2003-03-20', '2003-03-27', '30.00', 'OK', 20030327174031, 0),
(983, 581, 3, '2003-04-20', '0000-00-00', '30.00', 'NE', 20030220131040, 0),
(984, 582, 1, '2003-02-27', '2003-03-11', '60.00', 'ERRO', 20030311180553, 0),
(985, 583, 1, '2003-02-27', '2003-03-05', '340.00', 'ERRO', 20030305112342, 0),
(986, 584, 1, '2003-02-27', '2003-03-11', '640.00', 'ERRO', 20030311180556, 0),
(987, 585, 1, '2003-02-27', '2003-03-11', '640.00', 'ERRO', 20030311180556, 0),
(988, 586, 1, '2003-02-20', '2003-03-05', '30.00', 'ERRO', 20030305115346, 0),
(989, 587, 1, '2003-02-20', '2003-03-05', '30.00', 'ERRO', 20030305115301, 0),
(990, 587, 2, '2003-03-20', '2003-03-31', '30.00', 'ERRO', 20030331153846, 0),
(991, 587, 3, '2003-04-20', '0000-00-00', '30.00', 'NE', 20030220150704, 0),
(992, 588, 1, '2003-02-20', '2003-02-27', '30.00', 'OK', 20030227180553, 0),
(993, 588, 2, '2003-03-20', '2003-03-27', '30.00', 'OK', 20030327174033, 0),
(994, 588, 3, '2003-04-20', '0000-00-00', '30.00', 'NE', 20030220163840, 0),
(995, 589, 1, '2003-02-27', '2003-03-11', '60.00', 'C', 20030325101041, 0),
(996, 590, 1, '2003-02-28', '2003-03-06', '60.00', 'OK', 20030306153502, 0),
(997, 591, 1, '2003-02-21', '2003-03-05', '20.00', 'ERRO', 20030305165953, 0),
(998, 591, 2, '2003-03-21', '2003-04-01', '20.00', 'ERRO', 20030401182843, 0),
(999, 591, 3, '2003-04-21', '0000-00-00', '20.00', 'NE', 20030221091644, 0),
(1000, 592, 1, '2003-02-21', '0000-00-00', '30.00', 'NE', 20030221102921, 0),
(1001, 593, 1, '0000-00-00', '0000-00-00', '60.00', 'NE', 20030221132537, 0),
(1002, 594, 1, '2003-02-21', '2003-03-05', '50.00', 'ERRO', 20030305165954, 0),
(1003, 594, 2, '2003-03-21', '2003-04-01', '50.00', 'ERRO', 20030401182844, 0),
(1004, 594, 3, '2003-04-21', '0000-00-00', '50.00', 'NE', 20030221105506, 0),
(1005, 595, 1, '2003-02-25', '0000-00-00', '30.00', 'NE', 20030221110055, 0),
(1006, 595, 2, '2003-03-25', '0000-00-00', '30.00', 'NE', 20030221110055, 0),
(1007, 595, 3, '2003-04-25', '0000-00-00', '30.00', 'NE', 20030221110055, 0),
(1008, 596, 1, '2003-02-25', '0000-00-00', '30.00', 'NE', 20030221112715, 0),
(1009, 596, 2, '2003-03-25', '0000-00-00', '30.00', 'NE', 20030221112715, 0),
(1010, 596, 3, '2003-04-25', '0000-00-00', '30.00', 'NE', 20030221112715, 0),
(1011, 597, 1, '2003-02-25', '2003-03-10', '30.00', 'C', 20030325103250, 0),
(1012, 597, 2, '2003-03-25', '2003-04-02', '30.00', 'ERRO', 20030402173715, 0),
(1013, 597, 3, '2003-04-25', '0000-00-00', '30.00', 'NE', 20030221115002, 0),
(1014, 598, 1, '2003-02-25', '0000-00-00', '30.00', 'C', 20030227070001, 0),
(1015, 598, 2, '2003-03-25', '0000-00-00', '30.00', 'C', 20030327070001, 0),
(1016, 598, 3, '2003-04-25', '0000-00-00', '30.00', 'NE', 20030221115838, 0),
(1017, 599, 1, '2003-02-25', '0000-00-00', '30.00', 'C', 20030227070001, 0),
(1018, 600, 1, '2003-02-25', '0000-00-00', '30.00', 'C', 20030227070001, 0),
(1019, 601, 1, '2003-02-25', '0000-00-00', '30.00', 'C', 20030227070001, 0),
(1020, 602, 1, '2003-02-25', '0000-00-00', '30.00', 'C', 20030227070001, 0),
(1021, 603, 1, '2003-02-25', '0000-00-00', '30.00', 'C', 20030227070001, 0),
(1022, 604, 1, '2003-02-28', '0000-00-00', '60.00', 'C', 20030223022032, 0),
(1023, 605, 1, '2003-02-28', '2003-03-06', '60.00', 'C', 20030306180113, 0),
(1024, 606, 1, '2003-02-21', '0000-00-00', '240.00', 'C', 20030223000030, 0),
(1025, 607, 1, '2003-03-01', '0000-00-00', '60.00', 'C', 20030303070001, 0),
(1026, 608, 1, '2003-03-01', '0000-00-00', '60.00', 'C', 20030303070001, 0),
(1027, 609, 1, '2003-03-01', '0000-00-00', '60.00', 'C', 20030303070001, 0),
(1028, 610, 1, '2003-02-22', '2003-03-05', '20.00', 'OK', 20030305120709, 0),
(1029, 610, 2, '2003-03-22', '2003-03-31', '20.00', 'OK', 20030331161536, 0),
(1030, 610, 3, '2003-04-22', '0000-00-00', '20.00', 'NE', 20030222182339, 0),
(1031, 611, 1, '2003-02-27', '2003-03-11', '60.00', 'ERRO', 20030311180557, 0),
(1032, 612, 1, '2003-02-27', '2003-03-11', '60.00', 'ERRO', 20030311180559, 0),
(1033, 613, 1, '2003-02-27', '2003-03-11', '60.00', 'ERRO', 20030311180604, 0),
(1034, 614, 1, '2003-02-27', '2003-03-11', '60.00', 'ERRO', 20030311180606, 0),
(1035, 615, 1, '2003-03-02', '0000-00-00', '60.00', 'C', 20030226053413, 0),
(1036, 616, 1, '2003-02-23', '2003-03-06', '33.33', 'ERRO', 20030306175528, 0),
(1037, 616, 2, '2003-03-23', '2003-04-01', '33.33', 'ERRO', 20030401174438, 0),
(1038, 616, 3, '2003-04-23', '0000-00-00', '33.33', 'NE', 20030223132633, 0),
(1039, 617, 1, '2003-02-23', '0000-00-00', '60.00', 'C', 20030225070002, 0),
(1040, 618, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174438, 0),
(1041, 619, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174438, 0),
(1042, 620, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174438, 0),
(1043, 621, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174439, 0),
(1044, 622, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174439, 0),
(1045, 623, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174439, 0),
(1046, 624, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174440, 0),
(1047, 625, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174440, 0),
(1048, 626, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174440, 0),
(1049, 627, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174440, 0),
(1050, 628, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174440, 0),
(1051, 629, 1, '2003-02-28', '2003-03-13', '60.00', 'ERRO', 20030313174441, 0),
(1052, 630, 1, '2003-02-28', '2003-03-13', '640.00', 'ERRO', 20030313174441, 0),
(1053, 631, 1, '2003-02-24', '2003-03-05', '10.00', 'OK', 20030305170559, 0),
(1054, 631, 2, '2003-03-24', '2003-04-01', '10.00', 'OK', 20030401115901, 0),
(1055, 631, 3, '2003-04-24', '0000-00-00', '10.00', 'NE', 20030224112318, 0),
(1056, 632, 1, '2003-03-03', '0000-00-00', '60.00', 'C', 20030224153802, 0),
(1057, 633, 1, '2003-02-24', '2003-03-06', '10.00', 'OK', 20030306175807, 0),
(1058, 633, 2, '2003-03-24', '2003-04-01', '10.00', 'OK', 20030401184858, 0),
(1059, 633, 3, '2003-04-24', '0000-00-00', '10.00', 'NE', 20030224141117, 0),
(1060, 634, 1, '2003-03-03', '0000-00-00', '60.00', 'C', 20030226160405, 0),
(1061, 635, 1, '2003-02-24', '2003-02-25', '30.00', 'ERRO', 20030225165421, 0),
(1062, 636, 1, '2003-02-24', '2003-02-26', '30.00', 'OK', 20030226103952, 0),
(1063, 637, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174505, 0),
(1064, 638, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174505, 0),
(1065, 639, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174505, 0),
(1066, 640, 1, '2003-03-01', '2003-03-07', '640.00', 'ERRO', 20030307115841, 0),
(1067, 641, 1, '2003-03-01', '2003-03-07', '340.00', 'ERRO', 20030307115842, 0),
(1068, 642, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174505, 0),
(1069, 643, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174506, 0),
(1070, 644, 1, '2003-03-01', '0000-00-00', '60.00', 'C', 20030225030003, 0),
(1071, 645, 1, '2003-03-01', '0000-00-00', '60.00', 'C', 20030225030003, 0),
(1072, 646, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174506, 0),
(1073, 647, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174506, 0),
(1074, 648, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174506, 0),
(1075, 649, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174507, 0),
(1076, 650, 1, '2003-03-01', '2003-03-13', '60.00', 'ERRO', 20030313174508, 0),
(1077, 651, 1, '2003-03-01', '0000-00-00', '60.00', 'C', 20030225030003, 0),
(1078, 652, 1, '2003-03-01', '2003-03-14', '60.00', 'OK', 20030314175326, 0),
(1079, 653, 1, '2003-03-04', '0000-00-00', '60.00', 'C', 20030306070001, 0),
(1080, 654, 1, '2003-03-04', '0000-00-00', '60.00', 'C', 20030306070001, 0),
(1081, 655, 1, '2003-03-04', '0000-00-00', '60.00', 'C', 20030306070001, 0),
(1082, 656, 1, '2003-03-04', '0000-00-00', '60.00', 'C', 20030306070001, 0),
(1083, 657, 1, '2003-03-04', '0000-00-00', '640.00', 'C', 20030306070002, 0),
(1084, 658, 1, '2003-03-04', '0000-00-00', '60.00', 'C', 20030306070002, 0),
(1085, 659, 1, '2003-02-25', '2003-02-26', '100.00', 'OK', 20030226170356, 0),
(1086, 660, 1, '2003-03-02', '2003-03-13', '60.00', 'OK', 20030313175142, 0),
(1087, 661, 1, '2003-03-02', '2003-03-07', '60.00', 'OK', 20030307115842, 0),
(1088, 662, 1, '2003-03-02', '0000-00-00', '60.00', 'C', 20030226030002, 0),
(1089, 663, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030227150733, 0),
(1090, 664, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070001, 0),
(1091, 665, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070001, 0),
(1092, 666, 1, '2003-03-20', '0000-00-00', '60.00', 'C', 20030307070001, 0),
(1093, 667, 1, '2003-02-26', '2003-02-27', '30.00', 'OK', 20030227175945, 0),
(1094, 668, 1, '2003-02-26', '2003-03-05', '10.00', 'ERRO', 20030305122549, 0),
(1095, 668, 2, '2003-03-26', '2003-04-04', '10.00', 'ERRO', 20030404100937, 0),
(1096, 668, 3, '2003-04-26', '0000-00-00', '10.00', 'NE', 20030226100210, 0),
(1097, 669, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030227173539, 0),
(1098, 670, 1, '2003-03-05', '2003-03-13', '60.00', 'ERRO', 20030313174508, 0),
(1099, 671, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070002, 0),
(1100, 672, 1, '2003-02-26', '2003-02-28', '100.00', 'OK', 20030228122111, 0),
(1101, 673, 1, '2003-02-26', '2003-03-10', '30.00', 'OK', 20030310184221, 0),
(1102, 673, 2, '2003-03-26', '2003-04-03', '30.00', 'ERRO', 20030403165227, 0),
(1103, 673, 3, '2003-04-26', '0000-00-00', '30.00', 'NE', 20030226111345, 0),
(1104, 674, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030226153937, 0),
(1105, 675, 1, '2003-02-26', '2003-03-10', '113.05', 'C', 20030310184221, 0),
(1106, 676, 1, '2003-02-26', '2003-03-10', '113.05', 'C', 20030310184221, 0),
(1107, 677, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030226161009, 0),
(1108, 678, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030302202238, 0),
(1109, 679, 1, '2003-02-26', '2003-03-10', '59.80', 'C', 20030310184222, 0),
(1110, 680, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030226171709, 0),
(1111, 681, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070002, 0),
(1112, 682, 1, '2003-02-26', '2003-03-10', '61.25', 'C', 20030310184222, 0),
(1113, 683, 1, '2003-02-26', '0000-00-00', '145.15', 'C', 20030227110204, 0),
(1114, 684, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070002, 0),
(1115, 685, 1, '2003-02-26', '2003-03-10', '33.33', 'OK', 20030310184222, 0),
(1116, 685, 2, '2003-03-26', '2003-04-03', '33.33', 'OK', 20030403165228, 0),
(1117, 685, 3, '2003-04-26', '0000-00-00', '33.33', 'NE', 20030226204048, 0),
(1118, 686, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070003, 0),
(1119, 687, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030227142044, 0),
(1120, 688, 1, '2003-03-05', '0000-00-00', '60.00', 'C', 20030307070003, 0),
(1121, 689, 1, '2003-03-03', '2003-03-07', '60.00', 'C', 20030307115842, 0),
(1122, 690, 1, '2003-03-03', '2003-03-07', '60.00', 'OK', 20030307115412, 0),
(1123, 691, 1, '2003-03-03', '2003-03-07', '60.00', 'ERRO', 20030307115108, 0),
(1124, 692, 1, '2003-03-28', '0000-00-00', '60.00', 'C', 20030227171914, 0),
(1125, 693, 1, '2003-03-03', '2003-03-13', '60.00', 'OK', 20030313175107, 0),
(1126, 694, 1, '2003-03-03', '0000-00-00', '60.00', 'C', 20030305070001, 0),
(1127, 695, 1, '2003-03-03', '0000-00-00', '60.00', 'C', 20030227030002, 0),
(1128, 696, 1, '2003-03-03', '0000-00-00', '60.00', 'C', 20030227030002, 0),
(1129, 697, 1, '2003-03-03', '2003-03-13', '60.00', 'C', 20030325101041, 0),
(1130, 698, 1, '2003-03-03', '0000-00-00', '60.00', 'C', 20030227030002, 0),
(1131, 699, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030227081932, 0),
(1132, 700, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030227101703, 0),
(1133, 701, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030303132353, 0),
(1134, 702, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030227103037, 0),
(1135, 703, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030308070001, 0),
(1136, 704, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030305173329, 0),
(1137, 705, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030308070002, 0),
(1138, 706, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030228165719, 0),
(1139, 707, 1, '2003-02-27', '2003-03-10', '10.00', 'OK', 20030310174852, 0),
(1140, 707, 2, '2003-03-27', '2003-04-03', '10.00', 'OK', 20030403164814, 0),
(1141, 707, 3, '2003-04-27', '0000-00-00', '10.00', 'NE', 20030227145934, 0),
(1142, 708, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030308070002, 0),
(1143, 709, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030308070002, 0),
(1144, 710, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030306225949, 0),
(1145, 711, 1, '2003-02-27', '2003-03-10', '10.00', 'OK', 20030310181024, 0),
(1146, 711, 2, '2003-03-27', '2003-04-03', '10.00', 'OK', 20030403173714, 0),
(1147, 711, 3, '2003-04-27', '0000-00-00', '10.00', 'NE', 20030227184738, 0),
(1148, 712, 1, '2003-03-06', '0000-00-00', '60.00', 'C', 20030303095923, 0),
(1149, 713, 1, '2003-03-06', '2003-03-07', '60.00', 'OK', 20030307172218, 0),
(1150, 714, 1, '2003-03-07', '0000-00-00', '60.00', 'C', 20030309070001, 0),
(1151, 715, 1, '2003-03-07', '0000-00-00', '60.00', 'C', 20030309070001, 0),
(1152, 716, 1, '2003-03-04', '2003-03-07', '60.00', 'OK', 20030307082129, 0),
(1153, 717, 1, '2003-03-04', '2003-03-07', '60.00', 'ERRO', 20030307115413, 0),
(1154, 718, 1, '2003-03-07', '0000-00-00', '60.00', 'C', 20030228151954, 0),
(1155, 719, 1, '2003-03-07', '0000-00-00', '60.00', 'C', 20030306144643, 0),
(1156, 720, 1, '2003-02-28', '2003-03-13', '30.00', 'OK', 20030313174442, 0),
(1157, 721, 1, '2003-02-28', '2003-03-05', '30.00', 'OK', 20030305165834, 0),
(1158, 722, 1, '2003-03-19', '0000-00-00', '60.00', 'C', 20030313070117, 0),
(1159, 723, 1, '2003-03-08', '0000-00-00', '60.00', 'C', 20030310070001, 0),
(1160, 724, 1, '2003-03-01', '2003-03-07', '150.00', 'OK', 20030307115414, 0),
(1161, 725, 1, '2003-03-01', '2003-03-14', '30.00', 'ERRO', 20030314183707, 0),
(1162, 726, 1, '2003-03-08', '0000-00-00', '60.00', 'C', 20030301193217, 0),
(1163, 727, 1, '2003-03-08', '0000-00-00', '60.00', 'C', 20030310070001, 0),
(1164, 728, 1, '2003-03-08', '0000-00-00', '60.00', 'C', 20030310070001, 0),
(1165, 729, 1, '2003-03-08', '0000-00-00', '60.00', 'C', 20030302003320, 0),
(1166, 730, 1, '2003-03-09', '0000-00-00', '60.00', 'C', 20030302080922, 0),
(1167, 731, 1, '2003-03-09', '0000-00-00', '60.00', 'C', 20030311070001, 0),
(1168, 732, 1, '2003-03-09', '0000-00-00', '60.00', 'C', 20030302220804, 0),
(1169, 733, 1, '2003-03-02', '2003-03-02', '30.00', 'OK', 20030302201158, 0),
(1170, 734, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1171, 735, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1172, 736, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1173, 737, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1174, 738, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1175, 739, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1176, 740, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1177, 741, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1178, 742, 1, '2003-03-07', '0000-00-00', '60.00', 'NR', 20030310145354, 0),
(1179, 743, 1, '2003-03-03', '2003-03-14', '10.00', 'OK', 20030314175324, 0),
(1180, 743, 2, '2003-04-03', '2003-04-15', '10.00', 'OK', 20030415110434, 0),
(1181, 743, 3, '2003-05-03', '0000-00-00', '10.00', 'NE', 20030303091332, 0),
(1182, 744, 1, '2003-03-10', '0000-00-00', '60.00', 'C', 20030303120226, 0),
(1183, 745, 1, '2003-03-11', '0000-00-00', '60.00', 'C', 20030313070119, 0),
(1184, 746, 1, '2003-03-04', '2003-03-07', '30.00', 'OK', 20030307115420, 0),
(1185, 747, 1, '2003-03-04', '2003-03-13', '60.00', 'OK', 20030313174509, 0),
(1186, 748, 1, '2003-03-04', '2003-03-14', '10.00', 'OK', 20030314180422, 0),
(1187, 748, 2, '2003-04-04', '2003-04-11', '10.00', 'OK', 20030411185923, 0),
(1188, 748, 3, '2003-05-04', '0000-00-00', '10.00', 'NE', 200303041756

Suggested fix:
force to use a index in select
[22 Apr 2003 10:35] Bruno Faust 
"how-to repeat" is incomplete... continue:

3) CHECK
------------------------------------------------------------
myisamchk -a cobranca

4) RUN
------------------------------------------------------------

desc SELECT a.cob_id, a.cob_dad_id, a.cob_nparcela, a.cob_dtenvio,
a.cob_dtretorno, a.cob_valor, a.cob_status, a.cob_dtatualizacao,
a.cob_pai_id, SUM(IF(b.cob_status = 'OK', 1, 0)) as certo,
SUM(IF((b.cob_status IN ('NE', 'NR', 'C', 'E', 'EP')), 1, 0)) as
b_no_recobra, COUNT(b.cob_id) as envios, TO_DAYS(MAX(b.cob_dtenvio)) -
TO_DAYS(a.cob_dtenvio) as dias_no_recobra FROM produto.cobranca a LEFT
JOIN produto.cobranca b ON a.cob_id = b.cob_pai_id WHERE a.cob_status =
'ERRO' AND (a.cob_dtretorno = '2003-04-21' OR b.cob_dtretorno =
'2003-04-21') GROUP BY a.cob_id HAVING certo = 0 AND envios < 6 AND
a.cob_pai_id = 0 AND (dias_no_recobra < 10 OR dias_no_recobra IS NULL) AND
b_no_recobra = 0

5) COMPARE RESULTS
------------------------------------------------------------
before: 2 index used
after: 1 index used
[22 Apr 2003 11:24] Indrek Siitan 
The query doesn't actually use indexes even before running myisamchk:

+-------+------+-------------------------------+------
+---------+------+------
+----------------------------------------------+
| table | type | possible_keys                 | key  | key_len | ref  | rows | 
Extra                                        |
+-------+------+-------------------------------+------
+---------+------+------
+----------------------------------------------+
| a     | ALL  | IDX_COBRANCA__STAT_RETORNO    | NULL |    NULL | NULL 
|  818 | Using where; Using temporary; Using filesort |
| b     | ALL  | IDX_COBRANCA__PAI_ID_RET_STAT | NULL |    NULL | NULL 
|  818 | Using where                                  |
+-------+------+-------------------------------+------
+---------+------+------
+----------------------------------------------+
2 rows in set (0.35 sec)

And the situation didn't change after running it (both with mysql being 
shut down like it should, and it running like it shouldn't).
[22 Apr 2003 11:33] Bruno Faust 
if the myisamchk didn't change, execute:

REPAIR TABLE cobranca;

repair table change then.
[22 Apr 2003 11:42] Bruno Faust 
befor REPAIR TABLE:

+-------+------+-------------------------------+-------------------------------+---------+----------+------+-----------------------------+
| table | type | possible_keys                 | key                           | key_len | ref      | rows | Extra                       |
+-------+------+-------------------------------+-------------------------------+---------+----------+------+-----------------------------+
| a     | ref  | IDX_COBRANCA__STAT_RETORNO    | IDX_COBRANCA__STAT_RETORNO    |       1 | const    |  382 | where used; Using temporary |
| b     | ref  | IDX_COBRANCA__PAI_ID_RET_STAT | IDX_COBRANCA__PAI_ID_RET_STAT |       3 | a.cob_id |   15 | where used                  |
+-------+------+-------------------------------+-------------------------------+---------+----------+------+-----------------------------+

after REPAIR TABLE:

+-------+------+-------------------------------+----------------------------+---------+-------+------+-----------------------------+
| table | type | possible_keys                 | key                        | key_len | ref   | rows | Extra                       |
+-------+------+-------------------------------+----------------------------+---------+-------+------+-----------------------------+
| a     | ref  | IDX_COBRANCA__STAT_RETORNO    | IDX_COBRANCA__STAT_RETORNO |       1 | const |  367 | where used; Using temporary |
| b     | ALL  | IDX_COBRANCA__PAI_ID_RET_STAT | NULL                       |    NULL | NULL  | 1580 | where used                  |
+-------+------+-------------------------------+----------------------------+---------+-------+------+-----------------------------+
[22 May 2003 2:38] Michael Widenius 
The reason for this behaviour is the following:

- The cardinality of the index 'KEY IDX_COBRANCA__PAI_ID_RET_STAT' is very low, becasue   almost all entires in cob_paid_id is 0.
- MySQL calculates the cardinalty of the index during REPAIR / OPTIMIZE
- After REPAIR, MySQL notices that the index is not usable for joins (too many matched rows for a lookup) and will ignore it as a table scan should be faster.

Proposed fix:
- Upgrade to 4.0.13 and change all 0 values in cob_pai_id to NULL

This should work as 4.0.13 ignores all NULL's when calculating the cardinality for an index.