[Resolvido] Consulta que retorna valores diferentes

Rafafel Reis - PHP · Fevereiro 28, 2012

tenho um banco onde eu preciso buscar uma coluna e ela não pode vir com valores iguais....

por exempo:

$query = "SELECT 
             col1, col2, col3
         FROM 
             table
         GROUP BY col1";

só que a ´col2´ não pode retornar com valores iguais.... como eu faço?

manolegal · Fevereiro 29, 2012

Detalhe um pouco melhor sua dúvida.

shini · Fevereiro 29, 2012

ja tentou usar distinct? essa consulta ai ta meio estranha....

Rafafel Reis - PHP · Fevereiro 29, 2012

então vou fazer um exemplo aqui...

tenho uma tabela ´fiscal´

nf | cfop | emiss | valor | dataFinal

1 | 123 | 01/01/2012 | 12.34 | 02/02/2012

3 | 123 | 01/01/2012 | 11.35 | 02/02/2012

4 | 124 | 01/01/2012 | 56.31 | 02/02/2012

5 | 124 | 01/01/2012 | 54.76 | 02/02/2012

6 | 125 | 01/01/2012 | 34.98 | 02/02/2012

7 | 125 | 01/01/2012 | 76.22 | 03/02/2012

7 | 125 | 01/01/2012 | 76.22 | 02/02/2012

8 | 123 | 01/01/2012 | 11.45 | 02/02/2012


$query = "
SELECT 
    DISTINCT datafinal,
    GROUP_CONCACT(nf) AS gNf,
    GROUP_CONCACT(cfpo) AS gCfop,
    GROUP_CONCACT(emiss) AS gEmiss,
    GROUP_CONCACT(valor) AS valor,
    GROUP_CONCACT(dataFinal) as gDataFinal
FROM 
    fiscal
GROUP BY 
    nf, cfop, emiss, valor
HAVING 
    COUNT(nf) > 1
"

/*
* NA TEORIA SERIA ISSO, PORÉM ELE NÃO RETORNA SOMENTE AS LINHAS 
* COM ´nf = 7´ 'PORQUE A ´dataFinal´ É DIFERENTE, ELE ADICIONA 
* AO "GROUP_CONCACT()" AS OUTRAS LINHAS.'
* 
* O QUE EU QUERIA É QUE NÃO ADICIONASSE AO "GROUP_CONCACT" AS 
* LINHAS COM ´dataFinal´ IGUAIS, NEM RETORNASSE ELAS, SÓ RETORNAR 
* AS LINHAS COM ´dataFinal´ DIFERENTE
*/

shini · Fevereiro 29, 2012

da o group by na datafinal tbm

Rafafel Reis - PHP · Fevereiro 29, 2012

vou te mandar o banco e a query

/*

SQLyog Ultimate v8.54 
MySQL - 5.5.8 : Database - fiscal

*********************************************************************

*/



/*!40101 SET NAMES utf8 */;



/*!40101 SET SQL_MODE=''*/;



/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`fiscal` /*!40100 DEFAULT CHARACTER SET utf8 */;



USE `fiscal`;



/*Table structure for table `fiscal1` */



DROP TABLE IF EXISTS `fiscal1`;



CREATE TABLE `fiscal1` (
 `cfop` varchar(10) NOT NULL,
 `forn` int(10) NOT NULL,
 `nf` int(5) NOT NULL,
 `emiss` varchar(10) NOT NULL,
 `valor` varchar(20) NOT NULL,
 `nameProccess` varchar(100) NOT NULL,
 `dataFinal` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



/*Data for the table `fiscal1` */



insert  into `fiscal1`(`cfop`,`forn`,`nf`,`emiss`,`valor`,`nameProccess`,`dataFinal`) values ('1.556',3948,1,'08/12/2011','816','SOX-TESTES','12/12/2012'),('1.556',4129,8,'30/11/2011','1.512.00','SOX-TESTES','13/12/2012'),('2.556',6601,8,'02/12/2011','8.518.40','SOX-TESTES','14/12/2012'),('2.949',2235,10,'14/04/2011','168.924.00','SOX-TESTES','15/12/2012'),('2.949',2235,11,'14/04/2011','99.300.00','SOX-TESTES','16/12/2012'),('1.556',4129,11,'15/12/2011','1.662.80','SOX-TESTES','17/12/2012'),('2.556',1403,12,'03/12/2011','6.465.00','SOX-TESTES','18/12/2012'),('1.949.01',6151,12,'22/12/2011','419.61','SOX-TESTES','18/12/2012'),('1.407',6151,12,'22/12/2011','1.799.90','SOX-TESTES','18/12/2012'),('2.556',1403,13,'03/12/2011','420','SOX-TESTES','21/12/2012'),('2.556',1403,15,'05/12/2011','1.879.80','SOX-TESTES','22/12/2012'),('2.949',2235,15,'03/05/2011','168.600.00','SOX-TESTES','23/12/2012'),('2.949',2235,25,'07/06/2011','101.572.00','SOX-TESTES','24/12/2012'),('2.949',2235,27,'10/06/2011','190.789.00','SOX-TESTES','25/12/2012'),('1.556',2472,27,'27/12/2011','30.000.00','SOX-TESTES','26/12/2012'),('1.556',2178,30,'13/12/2011','1.489.20','SOX-TESTES','27/12/2012'),('2.556',2362,32,'12/12/2011','1.146.84','SOX-TESTES','28/12/2012'),('2.949',2235,39,'05/07/2011','103.500.00','SOX-TESTES','29/12/2012'),('1.353',63881,42,'11/11/2011','12.002.80','SOX-TESTES','30/12/2012'),('1.303',3208,42,'06/12/2011','2.097.68','SOX-TESTES','31/12/2012'),('1.556',3535,43,'01/12/2011','3.116.60','SOX-TESTES','01/01/2013'),('2.949.01',3323,44,'06/10/2011','2.240.00','SOX-TESTES','02/01/2013'),('2.949',2235,44,'11/07/2011','93.300.00','SOX-TESTES','03/01/2013'),('1.353',63881,45,'19/11/2011','542.27','SOX-TESTES','04/01/2013'),('2.949',2235,46,'12/07/2011','105.000.00','SOX-TESTES','05/01/2013'),('1.556',3535,46,'19/12/2011','3.286.80','SOX-TESTES','06/01/2013'),('2.556',1635,47,'01/12/2011','3.976.00','SOX-TESTES','07/01/2013'),('1.353',63881,48,'19/11/2011','483.37','SOX-TESTES','08/01/2013'),('2.556',6746,48,'06/12/2011','3.972.50','SOX-TESTES','09/01/2013'),('1.353',63881,49,'19/11/2011','335.14','SOX-TESTES','10/01/2013'),('2.556',5550,49,'16/12/2011','478.55','SOX-TESTES','11/01/2013'),('1.556',6167,50,'30/11/2011','8.751.50','SOX-TESTES','12/01/2013'),('1.353',63881,50,'19/11/2011','425.24','SOX-TESTES','13/01/2013'),('2.407',1911,50,'30/11/2011','826.2','SOX-TESTES','14/01/2013'),('2.556',6746,50,'26/12/2011','4.176.00','SOX-TESTES','15/01/2013'),('2.407',1911,53,'02/12/2011','811.3','SOX-TESTES','16/01/2013'),('1.353',63881,55,'21/11/2011','413.01','SOX-TESTES','17/01/2013'),('1.556',6167,58,'16/12/2011','10.216.50','SOX-TESTES','18/01/2013'),('1.353',63881,58,'21/11/2011','411.16','SOX-TESTES','19/01/2013'),('1.353',63881,60,'22/11/2011','935.63','SOX-TESTES','20/01/2013'),('2.949',2235,60,'29/07/2011','193.600.00','SOX-TESTES','21/01/2013'),('1.556',6167,60,'31/12/2011','10.786.50','SOX-TESTES','22/01/2013'),('1.353',63881,61,'23/11/2011','1.160.16','SOX-TESTES','23/01/2013'),('1.353',63881,62,'23/11/2011','200','SOX-TESTES','24/01/2013'),('2.407',3542,62,'27/12/2011','723.5','SOX-TESTES','25/01/2013'),('1.353',63881,63,'23/11/2011','301.79','SOX-TESTES','26/01/2013'),('1.353',63881,65,'23/11/2011','845','SOX-TESTES','27/01/2013'),('1.353',63881,66,'23/11/2011','1.919.69','SOX-TESTES','28/01/2013'),('1.353',63881,67,'23/11/2011','774.4','SOX-TESTES','29/01/2013'),('1.556',6166,68,'01/12/1931','348','SOX-TESTES','30/01/2013'),('1.353',63881,68,'23/11/2011','518.8','SOX-TESTES','31/01/2013'),('1.353',63881,70,'23/11/2011','265','SOX-TESTES','01/02/2013'),('1.353',63881,71,'23/11/2011','284.21','SOX-TESTES','02/02/2013'),('1.949.01',3949,73,'22/12/2011','58.445.00','SOX-TESTES','03/02/2013'),('2.556',69351,74,'12/12/2011','465','SOX-TESTES','04/02/2013'),('1.353',63881,74,'23/11/2011','693.11','SOX-TESTES','05/02/2013'),('1.353',63881,75,'23/11/2011','473.11','SOX-TESTES','06/02/2013'),('2.407',2140,76,'01/06/2011','159.1','SOX-TESTES','07/02/2013'),('1.556',2276,76,'24/11/2011','720','SOX-TESTES','08/02/2013'),('1.353',63881,76,'23/11/2011','1.911.63','SOX-TESTES','09/02/2013'),('1.353',63881,79,'23/11/2011','1.374.25','SOX-TESTES','10/02/2013'),('1.353',63881,80,'24/11/2011','314.72','SOX-TESTES','11/02/2013'),('1.353',63881,82,'24/11/2011','713.88','SOX-TESTES','12/02/2013'),('1.353',63881,83,'24/11/2011','1.509.92','SOX-TESTES','13/02/2013'),('1.353',63881,84,'24/11/2011','1.522.28','SOX-TESTES','14/02/2013'),('2.407',6329,85,'02/12/2011','261','SOX-TESTES','15/02/2013'),('1.353',63881,85,'24/11/2011','1.526.01','SOX-TESTES','16/02/2013'),('2.949',970839,87,'12/12/2011','190.450.00','SOX-TESTES','17/02/2013'),('1.353',63881,89,'24/11/2011','815','SOX-TESTES','18/02/2013'),('2.407',6329,94,'14/12/2011','671','SOX-TESTES','19/02/2013'),('2.556',1592,97,'19/12/2011','902.5','SOX-TESTES','20/02/2013'),('1.556',3639,106,'29/11/2011','600','SOX-TESTES','21/02/2013'),('1.407',3910,106,'08/12/2011','602','SOX-TESTES','22/02/2013'),('1.908',6169,108,'20/10/2011','3.060.00','SOX-TESTES','23/02/2013'),('1.949.01',3937,108,'21/12/2011','72.6','SOX-TESTES','24/02/2013'),('1.407',3937,108,'21/12/2011','1.695.40','SOX-TESTES','25/02/2013'),('1.908',6169,109,'20/10/2011','2.700.00','SOX-TESTES','26/02/2013'),('1.908',6169,110,'20/10/2011','540','SOX-TESTES','27/02/2013'),('1.556',3328,111,'27/12/2011','7.032.00','SOX-TESTES','28/02/2013'),('1.908',6169,113,'20/10/2011','1.020.00','SOX-TESTES','01/03/2013'),('1.908',6169,114,'20/10/2011','3.960.00','SOX-TESTES','02/03/2013'),('1.556',1471,114,'06/12/2011','2.400.00','SOX-TESTES','03/03/2013'),('1.908',6169,119,'10/11/2011','1.620.00','SOX-TESTES','04/03/2013'),('1.908',6169,120,'10/11/2011','900','SOX-TESTES','05/03/2013'),('1.353',63881,126,'08/12/2011','2.109.27','SOX-TESTES','06/03/2013'),('1.353',63881,127,'08/12/2011','3.814.60','SOX-TESTES','07/03/2013'),('1.353',63881,128,'08/12/2011','5.874.03','SOX-TESTES','08/03/2013'),('2.556',6871,129,'23/11/2011','10.953.00','SOX-TESTES','09/03/2013'),('1.353',63881,129,'08/12/2011','390','SOX-TESTES','10/03/2013'),('1.353',63881,130,'08/12/2011','2.515.00','SOX-TESTES','11/03/2013'),('1.353',63881,131,'08/12/2011','160','SOX-TESTES','12/03/2013'),('1.353',63881,132,'08/12/2011','208.4','SOX-TESTES','13/03/2013'),('2.556',6871,133,'05/12/2011','10.009.50','SOX-TESTES','14/03/2013'),('1.353',63881,135,'09/12/2011','405','SOX-TESTES','15/03/2013'),('1.556',4113,135,'16/11/2011','21.420.00','SOX-TESTES','16/03/2013'),('2.556',979600,136,'12/12/2011','35.722.00','SOX-TESTES','17/03/2013'),('1.353',63881,136,'09/12/2011','543.9','SOX-TESTES','18/03/2013'),('1.353',63881,138,'18/12/2011','165.36','SOX-TESTES','19/03/2013'),('1.353',63881,139,'09/12/2011','690','SOX-TESTES','20/03/2013'),('2.556',6758,140,'22/11/2011','515.76','SOX-TESTES','21/03/2013'),('1.353',63881,141,'09/12/2011','302.3','SOX-TESTES','22/03/2013'),('1.353',63881,142,'09/12/2011','206.75','SOX-TESTES','23/03/2013'),('1.556',1407,143,'07/12/2011','3.792.90','SOX-TESTES','24/03/2013'),('1.353',63881,144,'09/12/2011','590','SOX-TESTES','25/03/2013'),('2.407',6225,146,'21/11/2011','395.2','SOX-TESTES','26/03/2013'),('1.353',63881,146,'09/12/2011','1.404.64','SOX-TESTES','27/03/2013'),('1.353',63881,148,'09/12/2011','651.23','SOX-TESTES','28/03/2013'),('1.353',63881,149,'09/12/2011','669.31','SOX-TESTES','29/03/2013'),('1.556',4113,149,'03/12/2011','20.647.00','SOX-TESTES','30/03/2013'),('2.556',979600,149,'21/12/2011','93.990.79','SOX-TESTES','31/03/2013'),('1.353',63881,150,'09/12/2011','2.006.26','SOX-TESTES','01/04/2013'),('2.407',2005,150,'02/12/2011','328.8','SOX-TESTES','02/04/2013'),('1.353',63881,151,'09/12/2011','2.071.75','SOX-TESTES','03/04/2013'),('2.556',2035,152,'22/11/2011','9.497.05','SOX-TESTES','04/04/2013'),('1.353',63881,154,'09/12/2011','1.601.87','SOX-TESTES','05/04/2013'),('1.353',63881,155,'12/12/2011','160','SOX-TESTES','06/04/2013'),('1.556',4113,156,'16/12/2011','16.313.00','SOX-TESTES','07/04/2013'),('1.353',63881,156,'12/12/2011','364','SOX-TESTES','08/04/2013'),('1.353',63881,157,'12/12/2011','500','SOX-TESTES','09/04/2013'),('2.556',2649,158,'05/12/2011','1.860.20','SOX-TESTES','10/04/2013'),('1.353',63881,159,'12/12/2011','376.65','SOX-TESTES','11/04/2013'),('1.353',63881,160,'12/12/2011','367.69','SOX-TESTES','12/04/2013'),('1.353',63881,161,'12/12/2011','372.45','SOX-TESTES','13/04/2013'),('1.353',63881,162,'12/12/2011','1.188.69','SOX-TESTES','14/04/2013'),('1.949',9053,162,'22/06/2011','14.000.00','SOX-TESTES','15/04/2013'),('1.353',63881,163,'12/12/2011','545','SOX-TESTES','16/04/2013'),('1.353',63881,164,'12/12/2011','1.223.74','SOX-TESTES','17/04/2013'),('2.949.01',8057,165,'08/11/2011','654','SOX-TESTES','18/04/2013'),('1.353',63881,166,'12/12/2011','2.506.00','SOX-TESTES','19/04/2013'),('2.407',1715,167,'29/11/2011','1.259.00','SOX-TESTES','20/04/2013'),('1.353',63881,167,'12/12/2011','1.916.36','SOX-TESTES','21/04/2013'),('2.407',1715,168,'29/11/2011','50.6','SOX-TESTES','22/04/2013'),('1.353',63881,168,'12/12/2011','1.929.54','SOX-TESTES','23/04/2013'),('2.949.01',2018,168,'07/12/2011','2.418.96','SOX-TESTES','24/04/2013'),('2.407',2018,168,'07/12/2011','99.74','SOX-TESTES','25/04/2013'),('1.353',63881,171,'12/12/2011','545.98','SOX-TESTES','26/04/2013'),('2.556',3372,171,'20/11/2011','2.445.00','SOX-TESTES','27/04/2013'),('1.353',63881,172,'12/12/2011','1.115.02','SOX-TESTES','28/04/2013'),('2.556',3372,172,'02/12/2011','1.585.00','SOX-TESTES','29/04/2013'),('1.353',63881,173,'12/12/2011','390.92','SOX-TESTES','30/04/2013'),('1.353',63881,174,'12/12/2011','1.075.67','SOX-TESTES','01/05/2013'),('2.556',2035,175,'08/12/2011','10.554.95','SOX-TESTES','02/05/2013'),('1.353',63881,179,'13/12/2011','658.47','SOX-TESTES','03/05/2013'),('1.353',63881,184,'14/12/2011','611.28','SOX-TESTES','04/05/2013'),('1.353',63881,185,'14/12/2011','1.186.93','SOX-TESTES','05/05/2013'),('1.353',63881,186,'14/12/2011','496.63','SOX-TESTES','06/05/2013'),('1.353',63881,187,'14/12/2011','838.77','SOX-TESTES','07/05/2013'),('2.949.01',2018,188,'16/12/2011','3.871.70','SOX-TESTES','08/05/2013'),('2.949.01',2018,190,'21/12/2011','5.844.00','SOX-TESTES','09/05/2013'),('1.949.01',6187,190,'16/12/2011','855','SOX-TESTES','10/05/2013'),('1.353',63881,190,'14/12/2011','3.134.10','SOX-TESTES','11/05/2013'),('1.353',63881,191,'14/12/2011','558.75','SOX-TESTES','12/05/2013'),('2.949.01',2018,192,'22/12/2011','836','SOX-TESTES','13/05/2013'),('1.353',63881,192,'14/12/2011','669.6','SOX-TESTES','14/05/2013'),('1.353',63881,193,'14/12/2011','545.61','SOX-TESTES','15/05/2013'),('1.933',1731,194,'30/11/2011','900','SOX-TESTES','16/05/2013'),('1.353',63881,194,'14/12/2011','163.43','SOX-TESTES','17/05/2013'),('2.556',2035,195,'27/12/2011','9.553.95','SOX-TESTES','18/05/2013'),('1.353',63881,195,'14/12/2011','290.6','SOX-TESTES','19/05/2013'),('2.556',3329,197,'04/12/2011','468','SOX-TESTES','20/05/2013'),('1.353',63881,197,'16/12/2011','764.14','SOX-TESTES','21/05/2013'),('2.407',2140,198,'01/12/2011','297.7','SOX-TESTES','22/05/2013'),('1.353',63881,198,'16/12/2011','767.42','SOX-TESTES','23/05/2013'),('1.353',63881,199,'16/12/2011','777.27','SOX-TESTES','24/05/2013'),('1.353',63881,200,'16/12/2011','777.7','SOX-TESTES','25/05/2013'),('1.949.01',3584,200,'06/12/2011','725.3','SOX-TESTES','26/05/2013'),('1.407',3584,200,'06/12/2011','420.7','SOX-TESTES','27/05/2013'),('1.556',3584,200,'06/12/2011','70','SOX-TESTES','28/05/2013'),('1.353',63881,201,'16/12/2011','621.19','SOX-TESTES','29/05/2013'),('1.353',63881,207,'19/12/2011','714.58','SOX-TESTES','30/05/2013'),('1.353',63881,208,'19/12/2011','395','SOX-TESTES','31/05/2013'),('1.933',1731,209,'30/12/2011','900','SOX-TESTES','01/06/2013'),('1.353',63881,209,'19/12/2011','3.529.67','SOX-TESTES','02/06/2013'),('1.353',63881,210,'19/12/2011','2.473.33','SOX-TESTES','03/06/2013'),('1.556',2424,211,'17/11/2011','486','SOX-TESTES','04/06/2013'),('1.353',63881,212,'19/12/2011','1.206.04','SOX-TESTES','05/06/2013'),('1.353',63881,213,'19/12/2011','680.77','SOX-TESTES','06/06/2013'),('2.556',6760,214,'21/09/2011','315','SOX-TESTES','07/06/2013'),('1.353',63881,214,'19/12/2011','1.516.00','SOX-TESTES','08/06/2013'),('1.353',63881,215,'19/12/2011','2.602.87','SOX-TESTES','09/06/2013'),('1.353',63881,216,'19/12/2011','324.6','SOX-TESTES','10/06/2013'),('2.556',6559,217,'14/12/2011','485.5','SOX-TESTES','11/06/2013'),('1.353',63881,217,'19/12/2011','221.54','SOX-TESTES','12/06/2013'),('1.353',63881,218,'19/12/2011','1.076.27','SOX-TESTES','13/06/2013'),('2.353',63881,219,'19/12/2011','3.045.96','SOX-TESTES','14/06/2013'),('2.949.01',5811,223,'24/11/2011','1.112.96','SOX-TESTES','15/06/2013'),('2.556',6760,224,'06/10/2011','1.320.00','SOX-TESTES','16/06/2013'),('1.353',63881,226,'28/12/2011','22.122.74','SOX-TESTES','17/06/2013'),('1.949.01',3357,227,'12/12/2011','8.153.00','SOX-TESTES','18/06/2013'),('1.407',3357,227,'12/11/2011','955','SOX-TESTES','19/06/2013'),('1.353',63881,228,'28/12/2011','994.08','SOX-TESTES','20/06/2013'),('1.353',63881,229,'28/12/2011','1.005.00','SOX-TESTES','21/06/2013'),('1.353',63881,230,'28/12/2011','376.2','SOX-TESTES','22/06/2013'),('1.353',63881,231,'28/12/2011','2.083.99','SOX-TESTES','23/06/2013'),('1.353',63881,232,'28/12/2011','721.63','SOX-TESTES','24/06/2013'),('1.353',63881,233,'28/12/2011','760.31','SOX-TESTES','25/06/2013'),('1.353',63881,234,'28/12/2011','757.24','SOX-TESTES','26/06/2013'),('1.556',6629,235,'01/12/2011','1.330.32','SOX-TESTES','27/06/2013'),('1.353',63881,235,'28/12/2011','724.75','SOX-TESTES','28/06/2013'),('1.353',63881,236,'28/12/2011','2.452.28','SOX-TESTES','29/06/2013'),('2.949',2147,237,'03/11/2011','51.700.00','SOX-TESTES','30/06/2013'),('1.353',63881,238,'28/12/2011','866.38','SOX-TESTES','01/07/2013'),('1.353',63881,240,'28/12/2011','945.38','SOX-TESTES','02/07/2013'),('1.353',63881,244,'29/12/2011','3.384.15','SOX-TESTES','03/07/2013'),('1.353',63881,245,'29/12/2011','688.3','SOX-TESTES','04/07/2013'),('1.353',63881,246,'29/12/2011','1.607.98','SOX-TESTES','05/07/2013'),('1.353',63881,247,'29/12/2011','971.67','SOX-TESTES','06/07/2013'),('1.353',63881,248,'29/12/2011','174.04','SOX-TESTES','07/07/2013'),('2.353',63881,249,'29/12/2011','3.036.17','SOX-TESTES','08/07/2013'),('1.353',63881,250,'29/12/2011','2.045.00','SOX-TESTES','09/07/2013'),('1.353',63881,251,'29/12/2011','3.137.45','SOX-TESTES','10/07/2013'),('1.353',63881,252,'29/12/2011','234.5','SOX-TESTES','11/07/2013'),('1.353',63881,253,'29/12/2011','968.8','SOX-TESTES','12/07/2013'),('1.353',63881,254,'29/12/2011','163.61','SOX-TESTES','13/07/2013'),('1.353',63881,255,'29/12/2011','1.882.93','SOX-TESTES','14/07/2013'),('1.353',63881,256,'29/12/2011','1.178.00','SOX-TESTES','15/07/2013'),('1.353',63881,257,'29/12/2011','3.343.51','SOX-TESTES','16/07/2013'),('1.353',63881,258,'29/12/2011','714.58','SOX-TESTES','17/07/2013'),('1.949.01',6629,266,'08/12/2011','465.89','SOX-TESTES','18/07/2013'),('1.556',3536,267,'11/11/2011','136.4','SOX-TESTES','19/07/2013'),('1.949.01',3536,267,'11/11/2011','100','SOX-TESTES','20/07/2013'),('1.556',3536,288,'25/11/2011','210.6','SOX-TESTES','21/07/2013'),('1.556',3536,298,'28/11/2011','57.6','SOX-TESTES','22/07/2013'),('1.949.01',6629,298,'16/12/2011','634.95','SOX-TESTES','23/07/2013'),('1.556',6629,298,'16/12/2011','263.15','SOX-TESTES','24/07/2013'),('1.556',1465,301,'01/12/2011','920','SOX-TESTES','25/07/2013'),('1.556',4121,302,'08/11/2011','828','SOX-TESTES','26/07/2013'),('1.653',2023,305,'02/12/2011','489.32','SOX-TESTES','27/07/2013'),('2.556',3521,308,'02/12/2011','1.308.00','SOX-TESTES','28/07/2013'),('2.556',3521,309,'02/12/2011','5.152.00','SOX-TESTES','29/07/2013'),('2.407',6876,310,'06/10/2011','945.37','SOX-TESTES','30/07/2013'),('2.556',6876,310,'06/10/2011','78.13','SOX-TESTES','31/07/2013'),('2.556',3521,311,'15/12/2011','5.448.00','SOX-TESTES','01/08/2013'),('1.653',2023,311,'20/12/2011','407.52','SOX-TESTES','02/08/2013'),('2.556',3521,312,'15/12/2011','708','SOX-TESTES','03/08/2013'),('1.949.01',1464,314,'18/11/2011','150','SOX-TESTES','04/08/2013'),('2.556',6331,315,'01/12/2011','2.666.00','SOX-TESTES','05/08/2013'),('2.556',3964,317,'16/12/2011','314.1','SOX-TESTES','06/08/2013'),('1.912',6128,319,'01/11/2011','157.000.00','SOX-TESTES','07/08/2013'),('1.556',4121,323,'29/11/2011','902.4','SOX-TESTES','08/08/2013'),('1.556',233566,331,'01/12/2011','3.833.50','SOX-TESTES','09/08/2013'),('2.556',3517,331,'05/12/2011','4.499.00','SOX-TESTES','10/08/2013'),('2.556',6219,332,'30/11/2011','406.9','SOX-TESTES','11/08/2013'),('1.949.01',6168,333,'17/11/2011','9.608.80','SOX-TESTES','12/08/2013'),('1.949.01',6168,334,'17/11/2011','3.264.70','SOX-TESTES','13/08/2013'),('1.556',233566,334,'19/12/2011','6.253.00','SOX-TESTES','14/08/2013'),('1.949.01',6168,335,'17/11/2011','4.387.50','SOX-TESTES','15/08/2013'),('2.556',3517,335,'06/12/2011','2.057.00','SOX-TESTES','16/08/2013'),('1.949.01',6168,336,'17/11/2011','1.697.50','SOX-TESTES','17/08/2013'),('1.949.01',6168,337,'17/11/2011','1.347.20','SOX-TESTES','18/08/2013'),('1.407',6202,337,'03/11/2011','5.710.00','SOX-TESTES','19/08/2013'),('2.556',3517,337,'19/12/2011','5.247.00','SOX-TESTES','20/08/2013'),('2.407',6876,338,'31/10/2011','1.172.31','SOX-TESTES','21/08/2013'),('2.556',6876,338,'31/10/2011','164.24','SOX-TESTES','22/08/2013'),('1.949.01',1732,345,'10/11/2011','8.107.50','SOX-TESTES','23/08/2013'),('1.933',3935,357,'16/12/2011','50.141.30','SOX-TESTES','24/08/2013'),('2.407',2047,374,'20/12/2011','104.4','SOX-TESTES','25/08/2013'),('1.949.01',1464,377,'06/12/2011','1.200.00','SOX-TESTES','26/08/2013'),('2.556',6321,400,'01/12/2011','3.048.00','SOX-TESTES','27/08/2013'),('1.949.01',6151,409,'30/11/2011','174.3','SOX-TESTES','28/08/2013'),('1.556',6151,409,'30/11/2011','116.2','SOX-TESTES','29/08/2013'),('1.556',6151,411,'30/11/2011','999.9','SOX-TESTES','30/08/2013'),('1.949.01',6151,411,'30/11/2011','190','SOX-TESTES','31/08/2013'),('2.407',6876,411,'08/12/2011','2.216.76','SOX-TESTES','01/09/2013'),('2.556',6876,411,'08/12/2011','232.54','SOX-TESTES','02/09/2013'),('1.949',6151,412,'30/11/2011','316.85','SOX-TESTES','03/09/2013'),('1.556',6151,412,'30/11/2011','662.75','SOX-TESTES','04/09/2013'),('1.556',6151,413,'30/11/2011','115.4','SOX-TESTES','05/09/2013'),('1.949.01',6151,413,'30/11/2011','113.52','SOX-TESTES','06/09/2013'),('2.556',2505,419,'01/12/2011','898.35','SOX-TESTES','07/09/2013'),('2.556',6321,421,'16/12/2011','2.656.00','SOX-TESTES','08/09/2013'),('1.949.01',3506,423,'01/12/2011','4.750.00','SOX-TESTES','09/09/2013'),('2.556',6209,428,'25/11/2011','240','SOX-TESTES','10/09/2013'),('1.949.01',2096,436,'14/12/2011','313.5','SOX-TESTES','11/09/2013'),('1.556',6223,461,'01/12/2011','750','SOX-TESTES','12/09/2013'),('2.949',1857,466,'23/09/2011','7.600.00','SOX-TESTES','13/09/2013'),('2.407',2166,480,'02/12/2011','4.960.00','SOX-TESTES','14/09/2013'),('1.556',7153,483,'02/12/2011','7.631.82','SOX-TESTES','15/09/2013'),('2.949',2891,488,'24/10/2011','104.295.51','SOX-TESTES','16/09/2013'),('2.407',2166,493,'12/12/2011','420','SOX-TESTES','17/09/2013'),('2.949.01',3461,494,'19/10/2011','15.624.00','SOX-TESTES','18/09/2013'),('2.949.01',3461,495,'19/10/2011','15.624.00','SOX-TESTES','19/09/2013'),('2.949.01',3461,496,'19/10/2011','15.624.00','SOX-TESTES','20/09/2013'),('1.556',3649,501,'30/11/2011','8.361.44','SOX-TESTES','21/09/2013'),('1.556',7153,506,'21/12/2011','7.596.76','SOX-TESTES','22/09/2013'),('1.949.01',4020,513,'16/12/2011','261.6','SOX-TESTES','23/09/2013'),('1.949.01',4125,525,'01/12/2011','2.850.00','SOX-TESTES','24/09/2013'),('1.556',3649,525,'19/12/2011','8.327.46','SOX-TESTES','25/09/2013'),('1.124',979579,538,'25/10/2011','94.77','SOX-TESTES','26/09/2013'),('1.124',979579,541,'25/10/2011','17.55','SOX-TESTES','27/09/2013'),('1.124',979579,542,'25/10/2011','19.89','SOX-TESTES','28/09/2013'),('1.407',3943,549,'01/12/2011','410','SOX-TESTES','29/09/2013'),('2.949.01',3561,554,'21/11/2011','61.25','SOX-TESTES','30/09/2013'),('1.556',3649,559,'31/12/2011','8.408.41','SOX-TESTES','01/10/2013'),('1.556',61310,583,'05/12/2011','5.082.40','SOX-TESTES','02/10/2013'),('1.556',3933,587,'16/11/2011','8.405.20','SOX-TESTES','03/10/2013'),('2.949.01',3561,599,'05/12/2011','610.3','SOX-TESTES','04/10/2013'),('2.407',3561,599,'05/12/2011','117.4','SOX-TESTES','05/10/2013'),('1.556',3933,609,'06/12/2011','8.074.00','SOX-TESTES','06/10/2013'),('1.556',3933,616,'16/12/2011','5.780.00','SOX-TESTES','07/10/2013'),('2.407',3561,628,'19/12/2011','396.07','SOX-TESTES','08/10/2013'),('2.949.01',3561,628,'19/12/2011','3.954.63','SOX-TESTES','09/10/2013'),('2.407',3561,631,'20/12/2011','130.75','SOX-TESTES','10/10/2013'),('1.556',2049,642,'14/12/2011','3.072.90','SOX-TESTES','11/10/2013'),('2.407',2853,653,'28/12/2011','484.3','SOX-TESTES','12/10/2013'),('1.124',979579,678,'14/11/2011','3.154.50','SOX-TESTES','13/10/2013'),('1.949.01',2421,680,'16/12/2011','3.456.00','SOX-TESTES','14/10/2013'),('2.556',3967,686,'26/12/2011','1.406.20','SOX-TESTES','15/10/2013'),('1.949.01',2085,706,'30/09/2011','1.556.00','SOX-TESTES','16/10/2013'),('1.124',979579,712,'21/11/2011','5.438.01','SOX-TESTES','17/10/2013'),('1.407',2420,714,'09/12/2011','729','SOX-TESTES','18/10/2013'),('1.949.01',2085,716,'30/09/2011','1.569.80','SOX-TESTES','19/10/2013'),('1.556',2507,717,'09/12/2011','1.500.00','SOX-TESTES','20/10/2013'),('1.949.01',2507,719,'23/12/2011','18.878.47','SOX-TESTES','21/10/2013'),('1.949.01',2412,722,'12/12/2011','1.460.00','SOX-TESTES','22/10/2013'),('1.949.01',2085,724,'30/09/2011','6.000.00','SOX-TESTES','23/10/2013'),('1.949.01',3908,724,'24/10/2011','2.100.00','SOX-TESTES','24/10/2013'),('1.407',2412,737,'28/12/2011','29.92','SOX-TESTES','25/10/2013'),('1.949.01',2412,737,'28/12/2011','700.08','SOX-TESTES','26/10/2013'),('1.556',6229,739,'06/12/2011','22.47','SOX-TESTES','27/10/2013'),('1.407',6229,739,'06/12/2011','986.25','SOX-TESTES','28/10/2013'),('2.949.01',6820,743,'29/11/2011','315','SOX-TESTES','29/10/2013'),('2.556',6820,743,'29/11/2011','8','SOX-TESTES','30/10/2013'),('2.949.01',1441,748,'30/11/2011','684.84','SOX-TESTES','31/10/2013'),('1.124',979579,748,'28/11/2011','2.903.12','SOX-TESTES','01/11/2013'),('1.556',6835,749,'28/11/2011','678.26','SOX-TESTES','02/11/2013'),('1.949.01',6835,749,'28/11/2011','1.155.00','SOX-TESTES','03/11/2013'),('1.949.01',6835,765,'01/12/2011','83.07','SOX-TESTES','04/11/2013'),('1.556',6835,765,'01/12/2011','469.89','SOX-TESTES','05/11/2013'),('1.124',979579,771,'29/11/2011','4.015.40','SOX-TESTES','06/11/2013'),('1.949.01',6835,776,'06/12/2011','168.61','SOX-TESTES','07/11/2013'),('1.556',6835,776,'06/12/2011','33.33','SOX-TESTES','08/11/2013'),('1.949.01',6835,778,'07/12/2011','74.24','SOX-TESTES','09/11/2013'),('1.556',6835,778,'08/12/2011','191.56','SOX-TESTES','10/11/2013'),('1.124',979579,780,'01/12/2011','3.176.59','SOX-TESTES','11/11/2013'),('1.124',979579,781,'01/12/2011','1.814.28','SOX-TESTES','12/11/2013'),('2.556',2008,783,'05/12/2011','112.113.40','SOX-TESTES','13/11/2013'),('1.949.01',6325,784,'13/12/2011','700','SOX-TESTES','14/11/2013'),('1.949.01',2085,786,'14/10/2011','3.624.60','SOX-TESTES','15/11/2013'),('1.124',979579,792,'05/12/2011','7.204.35','SOX-TESTES','16/11/2013'),('2.556',8070,793,'12/12/2011','1.316.64','SOX-TESTES','17/11/2013'),('2.949.01',8070,793,'12/12/2011','311.77','SOX-TESTES','18/11/2013'),('2.556',6820,798,'14/12/2011','1.054.00','SOX-TESTES','19/11/2013'),('2.407',6820,798,'14/12/2011','190','SOX-TESTES','20/11/2013'),('1.949.01',6835,805,'17/12/2011','666.7','SOX-TESTES','21/11/2013'),('1.949.01',6835,806,'21/12/2011','633.94','SOX-TESTES','22/11/2013'),('1.949.01',2085,812,'20/10/2011','380','SOX-TESTES','23/11/2013'),('1.124',979579,820,'07/12/2011','1.044.81','SOX-TESTES','24/11/2013'),('2.556',6138,822,'09/12/2011','3.209.01','SOX-TESTES','25/11/2013'),('2.556',6820,824,'22/12/2011','620','SOX-TESTES','26/11/2013'),('1.124',979579,826,'09/12/2011','2.305.68','SOX-TESTES','27/11/2013'),('1.124',979579,829,'12/12/2011','3.292.40','SOX-TESTES','28/11/2013'),('2.556',6820,829,'27/12/2011','953','SOX-TESTES','29/11/2013'),('2.407',6820,829,'27/12/2011','233','SOX-TESTES','30/11/2013'),('1.949.01',2085,831,'25/10/2011','11.001.70','SOX-TESTES','01/12/2013'),('1.353',63361,831,'12/12/2011','330','SOX-TESTES','02/12/2013'),('2.556',6138,836,'13/12/2011','369','SOX-TESTES','03/12/2013'),('2.556',6138,837,'13/12/2011','627','SOX-TESTES','04/12/2013'),('2.407',6805,843,'20/10/2011','422.73','SOX-TESTES','05/12/2013'),('2.949.01',6805,843,'20/10/2011','385.84','SOX-TESTES','06/12/2013'),('1.124',979579,845,'16/12/2011','7.483.81','SOX-TESTES','07/12/2013'),('1.556',65293,852,'13/12/2011','7.845.00','SOX-TESTES','08/12/2013'),('2.949.01',2084,853,'29/12/2011','158.7','SOX-TESTES','09/12/2013'),('2.556',2084,853,'29/12/2011','27.9','SOX-TESTES','10/12/2013'),('2.949.01',3947,884,'26/12/2011','1.960.00','SOX-TESTES','11/12/2013'),('1.124',979579,888,'22/12/2011','2.626.16','SOX-TESTES','12/12/2013'),('1.124',979579,890,'26/12/2011','3.227.12','SOX-TESTES','13/12/2013'),('1.124',979579,891,'26/12/2011','3.283.36','SOX-TESTES','14/12/2013'),('1.124',979579,892,'26/12/2011','3.013.52','SOX-TESTES','15/12/2013'),('1.124',979579,900,'27/12/2011','820.56','SOX-TESTES','16/12/2013'),('1.124',979579,903,'28/12/2011','966','SOX-TESTES','17/12/2013'),('2.949',9040,907,'06/04/2011','258.100.00','SOX-TESTES','18/12/2013'),('1.949.01',2085,909,'07/11/2011','5.219.20','SOX-TESTES','19/12/2013'),('1.124',979579,910,'29/12/2011','427.84','SOX-TESTES','20/12/2013'),('1.949.01',2085,916,'08/11/2011','1.764.00','SOX-TESTES','21/12/2013'),('1.949.01',2153,929,'15/12/2011','1.542.50','SOX-TESTES','22/12/2013'),('1.556',2070,936,'25/11/2011','1.410.00','SOX-TESTES','23/12/2013'),('1.949.01',2085,941,'16/11/2011','2.781.56','SOX-TESTES','24/12/2013'),('1.949.01',6624,943,'24/10/2011','5.261.56','SOX-TESTES','25/12/2013'),('1.949.01',6624,949,'27/10/2011','5.261.56','SOX-TESTES','26/12/2013'),('1.949.01',6624,953,'28/10/2011','5.261.56','SOX-TESTES','27/12/2013'),('2.556',1839,954,'29/11/2011','1.928.00','SOX-TESTES','28/12/2013'),('1.949.01',6624,954,'28/10/2011','5.261.56','SOX-TESTES','29/12/2013'),('2.556',1839,960,'30/11/2011','7.016.41','SOX-TESTES','30/12/2013'),('1.556',2070,961,'05/12/2011','960','SOX-TESTES','31/12/2013'),('1.949.01',2085,987,'23/11/2011','118.5','SOX-TESTES','01/01/2014'),('1.407',2085,987,'23/11/2011','2.232.00','SOX-TESTES','02/01/2014'),('1.556',2070,987,'16/12/2011','960','SOX-TESTES','03/01/2014'),('1.949.01',2085,988,'23/11/2011','3.344.00','SOX-TESTES','04/01/2014'),('1.556',2070,988,'16/12/2011','1.440.00','SOX-TESTES','05/01/2014'),('2.556',6777,995,'15/12/2011','4.347.50','SOX-TESTES','06/01/2014'),('2.556',6777,997,'20/12/2011','400','SOX-TESTES','07/01/2014'),('2.556',65809,1012,'14/12/2011','388.9','SOX-TESTES','08/01/2014'),('2.556',2006,1013,'30/11/2011','577.5','SOX-TESTES','09/01/2014'),('1.556',2825,1023,'28/12/2011','255.01','SOX-TESTES','10/01/2014'),('1.407',2825,1023,'28/12/2011','175.48','SOX-TESTES','11/01/2014'),('1.949.01',2277,1030,'24/11/2011','2.945.00','SOX-TESTES','12/01/2014'),('1.949.01',2277,1033,'25/11/2011','573.7','SOX-TESTES','13/01/2014'),('1.407',2277,1033,'25/11/2011','520','SOX-TESTES','14/01/2014'),('1.949.01',2085,1034,'30/11/2011','3.780.00','SOX-TESTES','15/01/2014'),('1.949.01',2277,1036,'25/11/2011','1.074.00','SOX-TESTES','16/01/2014'),('1.556',4126,1045,'01/12/2011','1.381.50','SOX-TESTES','17/01/2014'),('1.949.01',2277,1045,'01/12/2011','335','SOX-TESTES','18/01/2014'),('1.949',2270,1050,'04/11/2011','30.000.00','SOX-TESTES','19/01/2014'),('1.949.01',2085,1054,'06/12/2011','1.822.08','SOX-TESTES','20/01/2014'),('1.949.01',2085,1057,'07/12/2011','3.847.20','SOX-TESTES','21/01/2014'),('1.949.01',2277,1059,'06/12/2011','412.5','SOX-TESTES','22/01/2014'),('1.949.01',2277,1061,'07/12/2011','496','SOX-TESTES','23/01/2014'),('1.949.01',2277,1066,'08/12/2011','1.378.00','SOX-TESTES','24/01/2014'),('2.407',6805,1068,'08/11/2011','115','SOX-TESTES','25/01/2014'),('1.949.01',2277,1069,'09/12/2011','823','SOX-TESTES','26/01/2014'),('2.949',1480,1071,'24/11/2011','71.204.87','SOX-TESTES','27/01/2014'),('2.949',1480,1073,'24/11/2011','87.886.57','SOX-TESTES','28/01/2014'),('1.949.01',2085,1077,'12/12/2011','737','SOX-TESTES','29/01/2014'),('1.949',1480,1084,'28/11/2011','1.950.00','SOX-TESTES','30/01/2014'),('1.949.01',2085,1095,'15/12/2011','4.376.40','SOX-TESTES','31/01/2014'),('1.949.01',2085,1100,'15/12/2011','9.900.00','SOX-TESTES','01/02/2014'),('1.556',2064,1100,'26/10/2011','1.953.00','SOX-TESTES','02/02/2014'),('1.949.01',2085,1108,'16/12/2011','5.736.00','SOX-TESTES','03/02/2014'),('1.556',2262,1113,'26/12/2011','194.14','SOX-TESTES','04/02/2014'),('1.556',2064,1114,'01/11/2011','1.227.00','SOX-TESTES','05/02/2014'),('1.949.01',2149,1114,'07/12/2011','2.146.36','SOX-TESTES','06/02/2014'),('1.949.01',2085,1116,'19/12/2011','533.39','SOX-TESTES','07/02/2014'),('1.556',2064,1121,'03/11/2011','818','SOX-TESTES','08/02/2014'),('1.556',2064,1122,'03/11/2011','7.041.60','SOX-TESTES','09/02/2014'),('2.949',9036,1123,'25/10/2011','28.250.00','SOX-TESTES','10/02/2014'),('1.556',2064,1125,'03/11/2011','1.636.00','SOX-TESTES','11/02/2014'),('1.949.01',2085,1126,'20/12/2011','2.183.86','SOX-TESTES','12/02/2014'),('1.407',6204,1135,'18/11/2011','576','SOX-TESTES','13/02/2014'),('1.949.01',6204,1135,'18/11/2011','3.852.54','SOX-TESTES','14/02/2014'),('1.949.01',6204,1138,'18/11/2011','13.984.86','SOX-TESTES','15/02/2014'),('1.949.01',6204,1139,'18/11/2011','13.359.72','SOX-TESTES','16/02/2014'),('1.407',6204,1139,'18/11/2011','50','SOX-TESTES','17/02/2014'),('1.949.01',2085,1140,'21/12/2011','2.136.01','SOX-TESTES','18/02/2014'),('1.556',1742,1144,'16/12/2011','15','SOX-TESTES','19/02/2014'),('2.949.01',6805,1178,'17/11/2011','5.935.41','SOX-TESTES','20/02/2014'),('1.556',2064,1178,'18/11/2011','1.840.50','SOX-TESTES','21/02/2014'),('1.949.01',85321,1184,'09/12/2011','725','SOX-TESTES','22/02/2014'),('1.556',2064,1203,'30/11/2011','818','SOX-TESTES','23/02/2014'),('1.556',2064,1204,'30/11/2011','3.419.00','SOX-TESTES','24/02/2014'),('2.407',6805,1209,'18/11/2011','438.75','SOX-TESTES','25/02/2014'),('2.407',3950,1209,'16/12/2011','151.72','SOX-TESTES','26/02/2014'),('2.949.01',3950,1209,'16/12/2011','891','SOX-TESTES','27/02/2014'),('2.949.01',3950,1210,'16/12/2011','89','SOX-TESTES','28/02/2014'),('2.407',3950,1212,'16/12/2011','6','SOX-TESTES','01/03/2014'),('1.556',2064,1219,'05/12/2011','1.877.80','SOX-TESTES','02/03/2014'),('1.949.01',6204,1221,'19/12/2011','3.100.72','SOX-TESTES','03/03/2014'),('1.407',6204,1221,'19/12/2011','41.2','SOX-TESTES','04/03/2014'),('2.949.01',6805,1227,'18/11/2011','299','SOX-TESTES','05/03/2014'),('2.653',2016,1228,'16/12/2011','143.21','SOX-TESTES','06/03/2014'),('1.949.01',6204,1228,'20/12/2011','2.055.25','SOX-TESTES','07/03/2014'),('1.556',2064,1232,'08/12/2011','3.165.50','SOX-TESTES','08/03/2014'),('1.556',3941,1232,'16/12/2011','1.712.47','SOX-TESTES','09/03/2014'),('2.556',9036,1238,'23/11/2011','200','SOX-TESTES','10/03/2014'),('1.949.01',6204,1242,'22/12/2011','3.748.61','SOX-TESTES','11/03/2014'),('1.556',2064,1247,'15/12/2011','19.462.30','SOX-TESTES','12/03/2014'),('1.556',2064,1248,'15/12/2011','137.4','SOX-TESTES','13/03/2014'),('1.556',2064,1249,'15/12/2011','2.863.00','SOX-TESTES','14/03/2014'),('1.556',2064,1260,'20/12/2011','7.656.00','SOX-TESTES','15/03/2014'),('1.556',2064,1261,'20/12/2011','5.317.00','SOX-TESTES','16/03/2014'),('2.407',6805,1264,'22/11/2011','299.56','SOX-TESTES','17/03/2014'),('1.949.01',6204,1265,'29/12/2011','913.32','SOX-TESTES','18/03/2014'),('1.949.01',6204,1267,'29/12/2011','1.842.17','SOX-TESTES','19/03/2014'),('1.407',6204,1267,'29/12/2011','1.345.00','SOX-TESTES','20/03/2014'),('1.556',2083,1270,'13/07/2011','2.971.00','SOX-TESTES','21/03/2014'),('2.949.01',6805,1275,'23/11/2011','660','SOX-TESTES','22/03/2014'),('2.949.01',6805,1276,'23/11/2011','1.185.00','SOX-TESTES','23/03/2014'),('2.556',6805,1277,'23/11/2011','4.778.83','SOX-TESTES','24/03/2014'),('2.407',6805,1277,'23/11/2011','4.913.29','SOX-TESTES','25/03/2014'),('2.407',6805,1281,'23/11/2011','443.31','SOX-TESTES','26/03/2014'),('1.556',2064,1282,'28/12/2011','2.181.30','SOX-TESTES','27/03/2014'),('2.949.01',6805,1293,'24/11/2011','202.63','SOX-TESTES','28/03/2014'),('1.556',2007,1299,'16/11/2011','5.325.50','SOX-TESTES','29/03/2014'),('1.949.01',8056,1324,'17/09/2011','635.6','SOX-TESTES','30/03/2014'),('1.556',8056,1324,'17/09/2011','184.4','SOX-TESTES','31/03/2014'),('2.556',65838,1327,'13/12/2011','1.207.50','SOX-TESTES','01/04/2014'),('1.556',2007,1331,'15/12/2011','7.579.50','SOX-TESTES','02/04/2014'),('2.556',6805,1334,'29/11/2011','47.4','SOX-TESTES','03/04/2014'),('2.407',6805,1334,'29/11/2011','555.9','SOX-TESTES','04/04/2014'),('2.556',6805,1335,'29/11/2011','458.6','SOX-TESTES','05/04/2014'),('2.407',6805,1335,'29/11/2011','116','SOX-TESTES','06/04/2014'),('1.949.01',5611,1349,'13/12/2011','1.403.60','SOX-TESTES','07/04/2014'),('2.949',9036,1352,'12/12/2011','8.050.00','SOX-TESTES','08/04/2014'),('2.949.01',6805,1368,'30/11/2011','49.26','SOX-TESTES','09/04/2014'),('2.407',6805,1368,'30/11/2011','5.25','SOX-TESTES','10/04/2014'),('1.556',2134,1378,'28/10/2011','648','SOX-TESTES','11/04/2014'),('2.303',6861,1379,'14/11/2011','1.594.87','SOX-TESTES','12/04/2014'),('1.556',1433,1390,'22/11/2011','828','SOX-TESTES','13/04/2014'),('1.949.01',2134,1391,'08/11/2011','562.5','SOX-TESTES','14/04/2014'),('1.556',2134,1391,'08/11/2011','2.781.90','SOX-TESTES','15/04/2014'),('2.556',65838,1397,'28/12/2011','4.862.60','SOX-TESTES','16/04/2014'),('1.556',2134,1405,'18/11/2011','3.156.50','SOX-TESTES','17/04/2014'),('1.556',2134,1406,'18/11/2011','459.75','SOX-TESTES','18/04/2014'),('1.556',2134,1407,'18/11/2011','178.6','SOX-TESTES','19/04/2014'),('1.556',2134,1409,'21/11/2011','154','SOX-TESTES','20/04/2014'),('1.556',2134,1410,'21/11/2011','11.877.00','SOX-TESTES','21/04/2014'),('1.556',2134,1411,'25/11/2011','470.32','SOX-TESTES','22/04/2014'),('1.556',2134,1413,'28/11/2011','10','SOX-TESTES','23/04/2014'),('1.556',2134,1414,'29/11/2011','22.836.90','SOX-TESTES','24/04/2014'),('1.556',2134,1415,'02/12/2011','27.065.69','SOX-TESTES','25/04/2014'),('1.949.01',2134,1415,'02/12/2011','228','SOX-TESTES','26/04/2014'),('1.556',2134,1416,'02/12/2011','4.920.00','SOX-TESTES','27/04/2014'),('1.556',2134,1418,'05/12/2011','2.873.05','SOX-TESTES','28/04/2014'),('1.556',2134,1420,'06/12/2011','3.974.00','SOX-TESTES','29/04/2014'),('1.556',2134,1421,'06/12/2011','2.456.38','SOX-TESTES','30/04/2014'),('1.556',2134,1422,'06/12/2011','1.423.20','SOX-TESTES','01/05/2014'),('1.556',2134,1423,'06/12/2011','21.443.51','SOX-TESTES','02/05/2014'),('1.556',2134,1427,'08/12/2011','2.460.00','SOX-TESTES','03/05/2014'),('1.556',2134,1431,'13/12/2011','9.840.00','SOX-TESTES','04/05/2014'),('1.556',2134,1432,'13/12/2011','12.040.00','SOX-TESTES','05/05/2014'),('1.556',2134,1433,'13/12/2011','641','SOX-TESTES','06/05/2014'),('1.556',2134,1434,'13/12/2011','738','SOX-TESTES','07/05/2014'),('1.556',2134,1437,'14/12/2011','894.5','SOX-TESTES','08/05/2014'),('1.556',2134,1438,'14/12/2011','231.5','SOX-TESTES','09/05/2014'),('1.556',2134,1440,'16/12/2011','2.401.00','SOX-TESTES','10/05/2014'),('1.556',2134,1441,'16/12/2011','1.203.00','SOX-TESTES','11/05/2014'),('1.556',2134,1443,'22/12/2011','4.497.00','SOX-TESTES','12/05/2014'),('1.303',5817,1447,'01/12/2011','35.5','SOX-TESTES','13/05/2014'),('2.949.01',6805,1455,'09/12/2011','209.4','SOX-TESTES','14/05/2014'),('2.407',6805,1455,'09/12/2011','286.32','SOX-TESTES','15/05/2014'),('2.556',6805,1455,'09/12/2011','48.3','SOX-TESTES','16/05/2014'),('1.949.01',7049,1462,'28/10/2011','350','SOX-TESTES','17/05/2014'),('1.949.01',3698,1477,'28/11/2011','2.045.96','SOX-TESTES','18/05/2014'),('2.949.01',3945,1501,'28/12/2011','1.946.00','SOX-TESTES','19/05/2014'),('2.949.01',6805,1518,'14/12/2011','740','SOX-TESTES','20/05/2014'),('2.407',6805,1518,'14/12/2011','189','SOX-TESTES','21/05/2014'),('2.949.01',6805,1542,'14/12/2011','229.06','SOX-TESTES','22/05/2014'),('2.407',6805,1542,'14/12/2011','178.25','SOX-TESTES','23/05/2014'),('2.556',6805,1542,'14/12/2011','10.4','SOX-TESTES','24/05/2014'),('1.556',2210,1548,'30/11/2011','397.5','SOX-TESTES','25/05/2014'),('1.949.01',7049,1549,'24/11/2011','1.710.27','SOX-TESTES','26/05/2014'),('1.949.01',7049,1570,'29/11/2011','1.039.72','SOX-TESTES','27/05/2014'),('1.949.01',2074,1571,'15/08/2011','228.85','SOX-TESTES','28/05/2014'),('1.303',6686,1576,'01/12/2011','4.06','SOX-TESTES','29/05/2014'),('1.949.01',7049,1576,'01/12/2011','6.707.10','SOX-TESTES','30/05/2014'),('1.949.01',7049,1585,'02/12/2011','960','SOX-TESTES','31/05/2014'),('2.949.01',2054,1595,'30/11/2011','1.374.18','SOX-TESTES','01/06/2014'),('2.556',2054,1595,'30/11/2011','1.645.59','SOX-TESTES','02/06/2014'),('2.556',2054,1597,'01/12/2011','2.523.26','SOX-TESTES','03/06/2014'),('2.949.01',2054,1597,'01/12/2011','592.07','SOX-TESTES','04/06/2014'),('2.556',2054,1599,'02/12/2011','1.822.13','SOX-TESTES','05/06/2014'),('2.556',2824,1600,'13/12/2011','504','SOX-TESTES','06/06/2014'),('2.949.01',6805,1600,'19/12/2011','67.6','SOX-TESTES','07/06/2014'),('2.407',6805,1600,'19/12/2011','171.93','SOX-TESTES','08/06/2014'),('2.949.01',2054,1603,'05/12/2011','816.11','SOX-TESTES','09/06/2014'),('2.556',2054,1603,'05/12/2011','2.432.69','SOX-TESTES','10/06/2014'),('2.556',2054,1608,'06/12/2011','2.641.34','SOX-TESTES','11/06/2014'),('2.556',2054,1610,'07/12/2011','1.450.76','SOX-TESTES','12/06/2014'),('2.556',2054,1611,'08/12/2011','2.288.29','SOX-TESTES','13/06/2014'),('2.556',2054,1614,'09/12/2011','1.998.81','SOX-TESTES','14/06/2014'),('2.556',2054,1616,'12/12/2011','2.838.30','SOX-TESTES','15/06/2014'),('1.949.01',7049,1619,'15/12/2011','5.782.70','SOX-TESTES','16/06/2014'),('2.556',2054,1620,'13/12/2011','2.040.27','SOX-TESTES','17/06/2014'),('2.556',2054,1623,'14/12/2011','3.010.01','SOX-TESTES','18/06/2014'),('2.556',2054,1624,'15/12/2011','3.195.16','SOX-TESTES','19/06/2014'),('2.556',2054,1630,'16/12/2011','1.827.17','SOX-TESTES','20/06/2014'),('2.556',2054,1632,'19/12/2011','2.713.79','SOX-TESTES','21/06/2014'),('2.556',2054,1635,'20/12/2011','3.068.41','SOX-TESTES','22/06/2014'),('2.556',2054,1638,'21/12/2011','2.491.05','SOX-TESTES','23/06/2014'),('2.556',2054,1639,'22/12/2011','2.928.90','SOX-TESTES','24/06/2014'),('2.556',2054,1643,'23/12/2011','999.32','SOX-TESTES','25/06/2014'),('1.949.01',3942,1646,'21/12/2011','53.777.02','SOX-TESTES','26/06/2014'),('2.556',2054,1647,'26/12/2011','586.42','SOX-TESTES','27/06/2014'),('2.556',2054,1651,'27/12/2011','3.133.98','SOX-TESTES','28/06/2014'),('1.556',2040,1657,'10/11/2011','162.45','SOX-TESTES','29/06/2014'),('1.949.01',2040,1657,'10/11/2011','160.11','SOX-TESTES','30/06/2014'),('2.556',2054,1657,'29/12/2011','762.84','SOX-TESTES','01/07/2014'),('1.949.01',7049,1660,'29/12/2011','1.686.90','SOX-TESTES','02/07/2014'),('2.407',6805,1701,'26/12/2011','252.7','SOX-TESTES','03/07/2014'),('2.949.01',6805,1701,'26/12/2011','148.5','SOX-TESTES','04/07/2014'),('2.556',6805,1701,'26/12/2011','84.1','SOX-TESTES','05/07/2014'),('2.949.01',6805,1713,'28/12/2011','350.46','SOX-TESTES','06/07/2014'),('2.556',6805,1713,'28/12/2011','1.130.96','SOX-TESTES','07/07/2014'),('2.407',6805,1713,'28/12/2011','542.71','SOX-TESTES','08/07/2014'),('2.556',6557,1716,'01/12/2011','474.3','SOX-TESTES','09/07/2014'),('2.949.01',6557,1716,'01/12/2011','3.3','SOX-TESTES','10/07/2014'),('2.407',6557,1717,'01/12/2011','115.7','SOX-TESTES','11/07/2014'),('1.949.01',1437,1756,'01/12/2011','4.992.00','SOX-TESTES','12/07/2014'),('2.556',6191,1764,'01/12/2011','952','SOX-TESTES','13/07/2014'),('1.949.01',8056,1792,'10/12/2011','110','SOX-TESTES','14/07/2014'),('1.556',8056,1792,'10/12/2011','378','SOX-TESTES','15/07/2014'),('2.949.01',6408,1815,'07/12/2011','2.456.57','SOX-TESTES','16/07/2014'),('2.407',6408,1815,'07/12/2011','91.2','SOX-TESTES','17/07/2014'),('2.949.01',6408,1818,'08/12/2011','4.928.20','SOX-TESTES','18/07/2014'),('2.407',1825,1836,'22/11/2011','333.74','SOX-TESTES','19/07/2014'),('1.949.01',3646,1837,'02/12/2011','840','SOX-TESTES','20/07/2014'),('2.949.01',6408,1840,'13/12/2011','1.171.80','SOX-TESTES','21/07/2014'),('2.407',6408,1840,'13/12/2011','53.5','SOX-TESTES','22/07/2014'),('2.949.01',6408,1849,'14/12/2011','638.5','SOX-TESTES','23/07/2014'),('2.949.01',6789,1862,'24/11/2011','2.580.00','SOX-TESTES','24/07/2014'),('1.949.01',3646,1862,'16/12/2011','2.600.00','SOX-TESTES','25/07/2014'),('2.556',65784,1878,'25/05/2011','31.5','SOX-TESTES','26/07/2014'),('2.407',65784,1878,'25/05/2011','302','SOX-TESTES','27/07/2014'),('1.949.01',975452,1878,'18/11/2011','5.399.52','SOX-TESTES','28/07/2014'),('2.949.01',6408,1883,'21/12/2011','528','SOX-TESTES','29/07/2014'),('2.949.01',6408,1894,'21/12/2011','2.763.41','SOX-TESTES','30/07/2014'),('2.556',8089,1929,'06/12/2011','12.112.20','SOX-TESTES','31/07/2014'),('1.556',1408,1933,'28/09/2011','12.720.00','SOX-TESTES','01/08/2014'),('1.949.01',9000,1943,'05/12/2011','828.28','SOX-TESTES','02/08/2014'),('2.556',8089,1950,'15/12/2011','3.801.60','SOX-TESTES','03/08/2014'),('1.949.01',9000,1979,'20/12/2011','117','SOX-TESTES','04/08/2014'),('1.407',1408,1992,'29/09/2011','10.613.00','SOX-TESTES','05/08/2014'),('1.556',1408,1992,'29/09/2011','5.248.00','SOX-TESTES','06/08/2014'),('1.407',1761,2008,'02/12/2011','366.3','SOX-TESTES','07/08/2014'),('1.556',3626,2013,'02/12/2011','463','SOX-TESTES','08/08/2014'),('1.556',2083,2070,'20/09/2011','1.080.00','SOX-TESTES','09/08/2014'),('2.949.01',6850,2082,'24/11/2011','1.882.10','SOX-TESTES','10/08/2014'),('2.407',6850,2082,'24/11/2011','186','SOX-TESTES','11/08/2014'),('1.556',2754,2094,'23/11/2011','8.451.50','SOX-TESTES','12/08/2014'),('1.556',2754,2095,'24/11/2011','3.736.60','SOX-TESTES','13/08/2014'),('1.556',2754,2109,'07/12/2011','8.904.00','SOX-TESTES','14/08/2014'),('1.556',2754,2110,'07/12/2011','5.474.00','SOX-TESTES','15/08/2014'),('2.949.01',8064,2115,'17/11/2011','186.71','SOX-TESTES','16/08/2014'),('2.407',8064,2115,'17/11/2011','261.79','SOX-TESTES','17/08/2014'),('1.949.01',2196,2117,'23/09/2011','557.7','SOX-TESTES','18/08/2014'),('1.551',2196,2117,'23/09/2011','609.7','SOX-TESTES','19/08/2014'),('1.556',2754,2131,'21/12/2011','6.927.00','SOX-TESTES','20/08/2014'),('2.949.01',64282,2136,'25/11/2011','55.6','SOX-TESTES','21/08/2014'),('2.407',64282,2136,'25/11/2011','248','SOX-TESTES','22/08/2014'),('2.949.01',6850,2180,'07/12/2011','452.4','SOX-TESTES','23/08/2014'),('1.556',2083,2183,'29/09/2011','3.000.00','SOX-TESTES','24/08/2014'),('2.556',65749,2185,'01/12/2011','771','SOX-TESTES','25/08/2014'),('1.556',6788,2203,'30/11/2011','11.727.90','SOX-TESTES','26/08/2014'),('2.407',64282,2211,'12/12/2011','252.2','SOX-TESTES','27/08/2014'),('1.556',1761,2215,'22/12/2011','75','SOX-TESTES','28/08/2014'),('1.949.01',1843,2222,'28/11/2011','3.184.00','SOX-TESTES','29/08/2014'),('1.653',2030,2228,'02/12/2011','185','SOX-TESTES','30/08/2014'),('1.949.01',1843,2241,'30/11/2011','3.958.00','SOX-TESTES','31/08/2014'),('1.949',2083,2254,'06/10/2011','3.000.00','SOX-TESTES','01/09/2014'),('1.556',3916,2262,'13/12/2011','360','SOX-TESTES','02/09/2014'),('1.949.01',1843,2277,'09/12/2011','8.790.00','SOX-TESTES','03/09/2014'),('1.908',4114,2281,'05/10/2011','7.000.00','SOX-TESTES','04/09/2014'),('1.556',2083,2285,'07/10/2011','2.321.00','SOX-TESTES','05/09/2014'),('2.556',6799,2301,'05/11/2011','496','SOX-TESTES','06/09/2014'),('1.556',6137,2319,'24/11/2011','1.328.50','SOX-TESTES','07/09/2014'),('1.556',6147,2323,'05/12/2011','627.55','SOX-TESTES','08/09/2014'),('1.407',6147,2323,'05/12/2011','239.05','SOX-TESTES','09/09/2014'),('2.949.01',6850,2343,'28/12/2011','1.262.00','SOX-TESTES','10/09/2014'),('1.556',6125,2369,'06/12/2011','1.188.00','SOX-TESTES','11/09/2014'),('2.949.01',2152,2414,'07/12/2011','710','SOX-TESTES','12/09/2014'),('2.949.01',2152,2424,'08/12/2011','710','SOX-TESTES','13/09/2014'),('2.556',2078,2451,'13/12/2011','135.8','SOX-TESTES','14/09/2014'),('2.949.01',2078,2452,'13/12/2011','267.9','SOX-TESTES','15/09/2014'),('2.556',3543,2464,'21/10/2011','300','SOX-TESTES','16/09/2014'),('1.556',2083,2465,'25/10/2011','900','SOX-TESTES','17/09/2014'),('1.556',4114,2485,'04/11/2011','12.290.00','SOX-TESTES','18/09/2014'),('1.949.01',4104,2489,'26/11/2011','4.400.00','SOX-TESTES','19/09/2014'),('2.556',2078,2491,'27/12/2011','125.12','SOX-TESTES','20/09/2014'),('2.949.01',2078,2491,'27/12/2011','278.58','SOX-TESTES','21/09/2014'),('1.949.01',4104,2538,'08/12/2011','785','SOX-TESTES','22/09/2014'),('1.949.01',4104,2545,'09/12/2011','628','SOX-TESTES','23/09/2014'),('2.949.01',6203,2556,'03/11/2011','521.1','SOX-TESTES','24/09/2014'),('2.556',6203,2556,'03/11/2011','99.5','SOX-TESTES','25/09/2014'),('2.556',6203,2557,'03/11/2011','296','SOX-TESTES','26/09/2014'),('2.949.01',6203,2557,'03/11/2011','110','SOX-TESTES','27/09/2014'),('2.949.01',6203,2578,'02/12/2011','1.287.50','SOX-TESTES','28/09/2014'),('2.556',6203,2578,'02/12/2011','118.5','SOX-TESTES','29/09/2014'),('2.949.01',6203,2579,'02/12/2011','418.2','SOX-TESTES','30/09/2014'),('2.556',6203,2579,'02/12/2011','381.9','SOX-TESTES','01/10/2014'),('2.556',6203,2580,'02/12/2011','232.6','SOX-TESTES','02/10/2014'),('2.949.01',6203,2580,'02/12/2011','60.8','SOX-TESTES','03/10/2014'),('2.949',9033,2606,'27/06/2011','118.697.27','SOX-TESTES','04/10/2014'),('1.556',2083,2616,'09/11/2011','6.480.00','SOX-TESTES','05/10/2014'),('1.949.01',1442,2632,'08/11/2011','6.751.80','SOX-TESTES','06/10/2014'),('2.556',3543,2650,'18/11/2011','6.656.50','SOX-TESTES','07/10/2014'),('2.949.01',3543,2650,'18/11/2011','6.240.00','SOX-TESTES','08/10/2014'),('2.556',6828,2685,'28/12/2011','596.1','SOX-TESTES','09/10/2014'),('2.949.01',6828,2685,'28/12/2011','11','SOX-TESTES','10/10/2014'),('1.556',2083,2699,'17/11/2011','2.700.00','SOX-TESTES','11/10/2014'),('1.556',2083,2700,'17/11/2011','2.700.00','SOX-TESTES','12/10/2014'),('1.556',2083,2725,'21/11/2011','9.600.00','SOX-TESTES','13/10/2014'),('1.949.01',2241,2738,'21/11/2011','10.872.40','SOX-TESTES','14/10/2014'),('1.949.01',2083,2755,'22/11/2011','360','SOX-TESTES','15/10/2014'),('2.556',3543,2755,'29/11/2011','551.66','SOX-TESTES','16/10/2014'),('1.556',4114,2760,'17/12/2011','462','SOX-TESTES','17/10/2014'),('1.556',2083,2769,'23/11/2011','2.125.00','SOX-TESTES','18/10/2014'),('1.949.01',2241,2774,'24/11/2011','1.029.25','SOX-TESTES','19/10/2014'),('1.556',2083,2778,'24/11/2011','1.440.00','SOX-TESTES','20/10/2014'),('2.556',3543,2789,'05/12/2011','120','SOX-TESTES','21/10/2014'),('1.556',2083,2791,'24/11/2011','475','SOX-TESTES','22/10/2014'),('1.556',2083,2813,'28/11/2011','1.132.00','SOX-TESTES','23/10/2014'),('1.556',2083,2816,'28/11/2011','360','SOX-TESTES','24/10/2014'),('1.949.01',2241,2834,'01/12/2011','6.306.91','SOX-TESTES','25/10/2014'),('1.556',2083,2838,'29/11/2011','900','SOX-TESTES','26/10/2014'),('1.949.01',63319,2845,'01/12/2011','13.078.06','SOX-TESTES','27/10/2014'),('1.949.01',2241,2849,'07/12/2011','1.044.33','SOX-TESTES','28/10/2014'),('1.949.01',2241,2850,'07/12/2011','4.570.50','SOX-TESTES','29/10/2014'),('1.303',5818,2857,'02/12/2011','293.91','SOX-TESTES','30/10/2014'),('1.556',2083,2857,'30/11/2011','360','SOX-TESTES','31/10/2014'),('1.949',2022,2857,'03/03/2011','1.800.00','SOX-TESTES','01/11/2014'),('1.949.01',2241,2858,'07/12/2011','7.484.60','SOX-TESTES','02/11/2014'),('1.556',2241,2858,'07/12/2011','598.5','SOX-TESTES','03/11/2014'),('1.556',2083,2865,'30/11/2011','1.250.00','SOX-TESTES','04/11/2014'),('1.949.01',2241,2869,'09/12/2011','2.681.49','SOX-TESTES','05/11/2014'),('1.556',2083,2875,'01/12/2011','2.665.00','SOX-TESTES','06/11/2014'),('1.949.01',2241,2888,'13/12/2011','484','SOX-TESTES','07/11/2014'),('1.556',2241,2888,'13/12/2011','35.2','SOX-TESTES','08/11/2014'),('1.949.01',2241,2890,'14/12/2011','464.94','SOX-TESTES','09/11/2014'),('1.949.01',2241,2892,'14/12/2011','6.819.00','SOX-TESTES','10/11/2014'),('1.556',2083,2896,'05/12/2011','2.700.00','SOX-TESTES','11/11/2014'),('1.949.01',2241,2899,'14/12/2011','2.431.35','SOX-TESTES','12/11/2014'),('2.949',1975,2900,'28/11/2011','227.708.00','SOX-TESTES','13/11/2014'),('1.949.01',6860,2931,'30/11/2011','360','SOX-TESTES','14/11/2014'),('1.949.01',6860,2935,'02/12/2011','10.000.00','SOX-TESTES','15/11/2014'),('1.556',2083,2938,'07/12/2011','1.800.00','SOX-TESTES','16/11/2014'),('1.556',2083,2954,'08/12/2011','2.665.00','SOX-TESTES','17/11/2014'),('1.949.01',2241,2959,'22/12/2011','5.476.90','SOX-TESTES','18/11/2014'),('1.949.01',2241,2962,'22/12/2011','330.04','SOX-TESTES','19/11/2014'),('1.949.01',6860,2972,'12/12/2011','714','SOX-TESTES','20/11/2014'),('2.949',1975,2977,'25/11/2011','215.322.25','SOX-TESTES','21/11/2014'),('1.556',2083,2985,'09/12/2011','1.080.00','SOX-TESTES','22/11/2014'),('1.949.01',6794,3031,'05/11/2011','4.179.25','SOX-TESTES','23/11/2014'),('1.556',6794,3031,'05/11/2011','832.75','SOX-TESTES','24/11/2014'),('1.556',2083,3053,'16/12/2011','1.135.00','SOX-TESTES','25/11/2014'),('1.556',2083,3056,'16/12/2011','6.000.00','SOX-TESTES','26/11/2014'),('1.556',2083,3067,'16/12/2011','686','SOX-TESTES','27/11/2014'),('2.303',6887,3071,'14/11/2011','7.49','SOX-TESTES','28/11/2014'),('1.556',2083,3091,'19/12/2011','900','SOX-TESTES','29/11/2014'),('1.556',2083,3096,'19/12/2011','1.800.00','SOX-TESTES','30/11/2014'),('2.949.01',2697,3129,'13/12/2011','873.6','SOX-TESTES','01/12/2014'),('1.556',2083,3143,'29/12/2011','2.710.00','SOX-TESTES','02/12/2014'),('2.556',2497,3152,'09/12/2011','450','SOX-TESTES','03/12/2014'),('2.556',2497,3161,'12/12/2011','1.050.00','SOX-TESTES','04/12/2014'),('2.353',2748,3182,'23/11/2011','1.200.00','SOX-TESTES','05/12/2014'),('2.353',2748,3183,'23/11/2011','1.200.00','SOX-TESTES','06/12/2014'),('2.353',2748,3205,'29/11/2011','1.200.00','SOX-TESTES','07/12/2014'),('1.556',3514,3213,'01/12/2011','3.430.20','SOX-TESTES','08/12/2014'),('1.908',2022,3246,'14/04/2011','2.500.00','SOX-TESTES','09/12/2014'),('1.556',3514,3259,'16/12/2011','1.451.65','SOX-TESTES','10/12/2014'),('2.949.01',2497,3285,'27/12/2011','12.759.00','SOX-TESTES','11/12/2014'),('2.949.01',2497,3290,'28/12/2011','7.715.00','SOX-TESTES','12/12/2014'),('1.949.01',5803,3351,'15/12/2011','152.75','SOX-TESTES','13/12/2014'),('2.556',6170,3371,'11/11/2011','411','SOX-TESTES','14/12/2014'),('1.303',6686,3395,'01/12/2011','1.19','SOX-TESTES','15/12/2014'),('1.908',2022,3428,'29/04/2011','30.576.00','SOX-TESTES','16/12/2014'),('1.949.01',6127,3432,'02/12/2011','229.88','SOX-TESTES','17/12/2014'),('1.407',2112,3439,'16/11/2011','13.710.75','SOX-TESTES','18/12/2014'),('1.556',2112,3439,'16/11/2011','10.100.95','SOX-TESTES','19/12/2014'),('1.556',2112,3444,'16/11/2011','3.521.10','SOX-TESTES','20/12/2014'),('1.949.01',2112,3459,'17/11/2011','125','SOX-TESTES','21/12/2014'),('1.407',2112,3459,'17/11/2011','13.340.10','SOX-TESTES','22/12/2014'),('2.653',2027,3459,'05/12/2011','1.140.21','SOX-TESTES','23/12/2014'),('1.407',2112,3472,'21/11/2011','17.810.60','SOX-TESTES','24/12/2014'),('1.556',2112,3472,'21/11/2011','8.530.00','SOX-TESTES','25/12/2014'),('1.407',2112,3477,'21/11/2011','5.088.00','SOX-TESTES','26/12/2014'),('1.407',2112,3482,'21/11/2011','7.961.30','SOX-TESTES','27/12/2014'),('1.556',2112,3482,'21/11/2011','1.150.00','SOX-TESTES','28/12/2014'),('1.949.01',2112,3482,'21/11/2011','674','SOX-TESTES','29/12/2014'),('1.556',2112,3483,'21/11/2011','1.274.76','SOX-TESTES','30/12/2014'),('1.407',2112,3483,'21/11/2011','1.738.00','SOX-TESTES','31/12/2014'),('1.949.01',2112,3487,'21/11/2011','619','SOX-TESTES','01/01/2015'),('1.407',2112,3487,'21/11/2011','8.340.17','SOX-TESTES','02/01/2015'),('1.556',2112,3487,'21/11/2011','4.866.42','SOX-TESTES','03/01/2015'),('1.407',2112,3489,'21/11/2011','1.920.00','SOX-TESTES','04/01/2015'),('1.949.01',2093,3490,'12/11/2011','212.5','SOX-TESTES','05/01/2015'),('1.556',2093,3490,'12/11/2011','22.8','SOX-TESTES','06/01/2015'),('1.407',2093,3490,'12/11/2011','15','SOX-TESTES','07/01/2015'),('2.653',2027,3503,'16/12/2011','1.094.36','SOX-TESTES','08/01/2015'),('1.556',2112,3504,'22/11/2011','5.140.00','SOX-TESTES','09/01/2015'),('1.407',2112,3510,'23/11/2011','4.150.90','SOX-TESTES','10/01/2015'),('1.556',2112,3510,'23/11/2011','86.3','SOX-TESTES','11/01/2015'),('1.949.01',2112,3510,'23/11/2011','496.8','SOX-TESTES','12/01/2015'),('1.407',2112,3515,'24/11/2011','9.399.00','SOX-TESTES','13/01/2015'),('1.407',2112,3516,'24/11/2011','11.469.00','SOX-TESTES','14/01/2015'),('1.556',2112,3536,'28/11/2011','416','SOX-TESTES','15/01/2015'),('1.407',2112,3536,'28/11/2011','719.74','SOX-TESTES','16/01/2015'),('1.949.01',3357,3543,'24/11/2011','1.359.00','SOX-TESTES','17/01/2015'),('1.556',3357,3543,'24/11/2011','560','SOX-TESTES','18/01/2015'),('1.407',3357,3543,'24/11/2011','945','SOX-TESTES','19/01/2015'),('1.949.01',3357,3557,'30/11/2011','4.686.00','SOX-TESTES','20/01/2015'),('1.407',3357,3557,'30/11/2011','1.032.00','SOX-TESTES','21/01/2015'),('1.949.01',3357,3558,'30/11/2011','2.900.00','SOX-TESTES','22/01/2015'),('1.407',3357,3558,'30/11/2011','610','SOX-TESTES','23/01/2015'),('2.556',65809,3559,'09/12/2011','67.08','SOX-TESTES','24/01/2015'),('1.949.01',6127,3559,'19/12/2011','324.33','SOX-TESTES','25/01/2015'),('1.407',2112,3566,'30/11/2011','9.050.00','SOX-TESTES','26/01/2015'),('1.949.01',2112,3572,'02/12/2011','686.25','SOX-TESTES','27/01/2015'),('1.407',2093,3587,'21/11/2011','120','SOX-TESTES','28/01/2015'),('1.556',3357,3587,'20/12/2011','1.400.00','SOX-TESTES','29/01/2015'),('1.407',2112,3587,'05/12/2011','4.095.00','SOX-TESTES','30/01/2015'),('1.407',2112,3590,'06/12/2011','3.480.00','SOX-TESTES','31/01/2015'),('1.407',2112,3596,'06/12/2011','971.5','SOX-TESTES','01/02/2015'),('1.556',2112,3598,'07/12/2011','265.5','SOX-TESTES','02/02/2015'),('1.407',2112,3598,'07/12/2011','3.840.00','SOX-TESTES','03/02/2015'),('1.949.01',6127,3607,'23/12/2011','962.81','SOX-TESTES','04/02/2015'),('1.407',6127,3607,'23/12/2011','72','SOX-TESTES','05/02/2015'),('1.949.01',3357,3608,'28/12/2011','345','SOX-TESTES','06/02/2015'),('1.407',2112,3609,'08/12/2011','1.569.40','SOX-TESTES','07/02/2015'),('1.556',2112,3609,'08/12/2011','1.279.20','SOX-TESTES','08/02/2015'),('1.407',2112,3610,'08/12/2011','1.972.26','SOX-TESTES','09/02/2015'),('1.556',2112,3610,'08/12/2011','200.44','SOX-TESTES','10/02/2015'),('1.949.01',2112,3610,'08/12/2011','61.9','SOX-TESTES','11/02/2015'),('1.407',2112,3612,'08/12/2011','4.646.00','SOX-TESTES','12/02/2015'),('1.556',2112,3612,'08/12/2011','735','SOX-TESTES','13/02/2015'),('2.949.01',3980,3628,'29/12/2011','8.606.00','SOX-TESTES','14/02/2015'),('1.949.01',6127,3630,'27/12/2011','889.98','SOX-TESTES','15/02/2015'),('1.407',2112,3633,'12/12/2011','534.4','SOX-TESTES','16/02/2015'),('1.556',2112,3633,'12/12/2011','5.168.10','SOX-TESTES','17/02/2015'),('1.949.01',2093,3639,'24/11/2011','433','SOX-TESTES','18/02/2015'),('1.556',2112,3642,'13/12/2011','90','SOX-TESTES','19/02/2015'),('1.407',2112,3642,'13/12/2011','235','SOX-TESTES','20/02/2015'),('1.407',2112,3643,'13/12/2011','606.97','SOX-TESTES','21/02/2015'),('1.556',2112,3643,'13/12/2011','58','SOX-TESTES','22/02/2015'),('1.407',2112,3644,'13/12/2011','2.855.00','SOX-TESTES','23/02/2015'),('1.556',2112,3644,'13/12/2011','2.142.00','SOX-TESTES','24/02/2015'),('1.407',2112,3645,'13/12/2011','192.74','SOX-TESTES','25/02/2015'),('1.556',2112,3645,'13/12/2011','301','SOX-TESTES','26/02/2015'),('2.556',6328,3647,'02/12/2011','3.580.00','SOX-TESTES','27/02/2015'),('2.949.01',6328,3647,'02/12/2011','304','SOX-TESTES','28/02/2015'),('1.556',2112,3653,'13/12/2011','825','SOX-TESTES','01/03/2015'),('1.407',2112,3660,'14/12/2011','1.160.00','SOX-TESTES','02/03/2015'),('1.908',2022,3662,'23/05/2011','48.300.00','SOX-TESTES','03/03/2015'),('1.407',2112,3665,'14/12/2011','2.484.00','SOX-TESTES','04/03/2015'),('1.949.01',2112,3668,'15/12/2011','76','SOX-TESTES','05/03/2015'),('1.407',2112,3668,'15/12/2011','1.567.60','SOX-TESTES','06/03/2015'),('1.407',2112,3669,'15/12/2011','2.447.90','SOX-TESTES','07/03/2015'),('1.556',2112,3669,'15/12/2011','1.313.40','SOX-TESTES','08/03/2015'),('1.407',2112,3671,'15/12/2011','1.216.49','SOX-TESTES','09/03/2015'),('1.407',2112,3684,'16/12/2011','1.190.00','SOX-TESTES','10/03/2015'),('1.949.01',2112,3688,'16/12/2011','438','SOX-TESTES','11/03/2015'),('1.556',2112,3688,'16/12/2011','495.2','SOX-TESTES','12/03/2015'),('1.407',2112,3688,'16/12/2011','399.7','SOX-TESTES','13/03/2015'),('1.407',2112,3697,'19/12/2011','147.03','SOX-TESTES','14/03/2015'),('1.407',2112,3698,'19/12/2011','1.887.20','SOX-TESTES','15/03/2015'),('1.407',2112,3699,'19/12/2011','67.65','SOX-TESTES','16/03/2015'),('1.556',2112,3699,'19/12/2011','636','SOX-TESTES','17/03/2015'),('1.949.01',2112,3713,'20/12/2011','75','SOX-TESTES','18/03/2015'),('1.407',2112,3713,'20/12/2011','6.374.10','SOX-TESTES','19/03/2015'),('1.949.01',2112,3714,'20/12/2011','419.4','SOX-TESTES','20/03/2015'),('1.407',2112,3715,'20/12/2011','22.035.20','SOX-TESTES','21/03/2015'),('1.556',2112,3715,'20/12/2011','10.274.90','SOX-TESTES','22/03/2015'),('1.407',2112,3716,'20/12/2011','2.993.10','SOX-TESTES','23/03/2015'),('1.556',2112,3716,'20/12/2011','47.8','SOX-TESTES','24/03/2015'),('1.407',2112,3718,'21/12/2011','180','SOX-TESTES','25/03/2015'),('1.407',6154,3719,'01/12/2011','395','SOX-TESTES','26/03/2015'),('1.407',2112,3722,'21/12/2011','3.950.00','SOX-TESTES','27/03/2015'),('1.407',2112,3723,'21/12/2011','532.9','SOX-TESTES','28/03/2015'),('1.556',2112,3723,'21/12/2011','65','SOX-TESTES','29/03/2015'),('1.949.01',2112,3723,'21/12/2011','61','SOX-TESTES','30/03/2015'),('1.407',2112,3727,'21/12/2011','9.437.30','SOX-TESTES','31/03/2015'),('1.556',2112,3727,'21/12/2011','291.2','SOX-TESTES','01/04/2015'),('1.407',2112,3739,'22/12/2011','1.982.00','SOX-TESTES','02/04/2015'),('1.556',2112,3739,'22/12/2011','465','SOX-TESTES','03/04/2015'),('1.407',2112,3741,'23/12/2011','2.263.50','SOX-TESTES','04/04/2015'),('1.556',2112,3741,'23/12/2011','26.76','SOX-TESTES','05/04/2015'),('1.949.01',2112,3742,'23/12/2011','159','SOX-TESTES','06/04/2015'),('1.949.01',1467,3745,'30/11/2011','231.69','SOX-TESTES','07/04/2015'),('2.949.01',4112,3781,'08/12/2011','130.14','SOX-TESTES','08/04/2015'),('1.949.01',1467,3813,'02/12/2011','745.5','SOX-TESTES','09/04/2015'),('1.949.01',3615,3830,'19/12/2011','138.6','SOX-TESTES','10/04/2015'),('1.949.01',1467,3834,'15/12/2011','325','SOX-TESTES','11/04/2015'),('1.556',1467,3834,'15/12/2011','339','SOX-TESTES','12/04/2015'),('2.949.01',4112,3855,'12/12/2011','150.93','SOX-TESTES','13/04/2015'),('1.949.01',2093,3856,'09/12/2011','97','SOX-TESTES','14/04/2015'),('1.556',2093,3856,'09/12/2011','37.2','SOX-TESTES','15/04/2015'),('1.908',2022,3893,'09/06/2011','31.539.00','SOX-TESTES','16/04/2015'),('2.949',6400,3907,'01/12/2011','4.000.00','SOX-TESTES','17/04/2015'),('2.949',65554,3919,'02/12/2011','2.561.50','SOX-TESTES','18/04/2015'),('1.949.01',2115,3922,'16/09/2011','3.260.00','SOX-TESTES','19/04/2015'),('1.949',6890,3937,'05/12/2011','397.097.30','SOX-TESTES','20/04/2015'),('1.949',6894,3941,'06/12/2011','6.154.40','SOX-TESTES','21/04/2015'),('1.949',6890,3977,'09/12/2011','4.354.24','SOX-TESTES','22/04/2015'),('2.949',6400,3988,'13/12/2011','96.615.00','SOX-TESTES','23/04/2015'),('1.949',6906,3993,'14/12/2011','2.778.00','SOX-TESTES','24/04/2015'),('1.949.01',2079,3999,'07/12/2011','647.7','SOX-TESTES','25/04/2015'),('1.407',2079,3999,'07/12/2011','33','SOX-TESTES','26/04/2015'),('1.949',2146,4003,'14/12/2011','15.000.00','SOX-TESTES','27/04/2015'),('2.949',6888,4009,'15/12/2011','20.150.00','SOX-TESTES','28/04/2015'),('1.949',6619,4012,'15/12/2011','7.102.00','SOX-TESTES','29/04/2015'),('2.949',2045,4027,'16/12/2011','37.681.00','SOX-TESTES','30/04/2015'),('2.949',5800,4030,'19/12/2011','55.178.13','SOX-TESTES','01/05/2015'),('1.949.01',2079,4039,'13/12/2011','511.5','SOX-TESTES','02/05/2015'),('1.949',2148,4048,'21/12/2011','8.557.00','SOX-TESTES','03/05/2015'),('1.949',2043,4067,'22/12/2011','19.615.00','SOX-TESTES','04/05/2015'),('1.949',6619,4068,'22/12/2011','17.730.00','SOX-TESTES','05/05/2015'),('1.949',2449,4078,'28/12/2011','95.250.00','SOX-TESTES','06/05/2015'),('1.949',2148,4082,'28/12/2011','14.169.43','SOX-TESTES','07/05/2015'),('1.949',2449,4083,'28/12/2011','4.680.00','SOX-TESTES','08/05/2015'),('1.949.01',2079,4086,'20/12/2011','1.266.50','SOX-TESTES','09/05/2015'),('1.407',2079,4086,'20/12/2011','190.3','SOX-TESTES','10/05/2015'),('1.949.01',6330,4090,'28/11/2011','1.919.93','SOX-TESTES','11/05/2015'),('1.949',63414,4093,'29/12/2011','97.317.33','SOX-TESTES','12/05/2015'),('1.949',63414,4094,'29/12/2011','12.001.05','SOX-TESTES','13/05/2015'),('1.949.01',2079,4107,'21/12/2011','227.58','SOX-TESTES','14/05/2015'),('1.407',2079,4107,'21/12/2011','69.4','SOX-TESTES','15/05/2015'),('1.908',2022,4137,'04/07/2011','5.200.80','SOX-TESTES','16/05/2015'),('1.908',2022,4194,'08/07/2011','147.000.00','SOX-TESTES','17/05/2015'),('1.949.01',1754,4319,'06/12/2011','2.250.00','SOX-TESTES','18/05/2015'),('1.556',1754,4319,'06/12/2011','77.5','SOX-TESTES','19/05/2015'),('1.556',1754,4320,'06/12/2011','256','SOX-TESTES','20/05/2015'),('1.556',1754,4355,'12/12/2011','245','SOX-TESTES','21/05/2015'),('2.949.01',6409,4387,'03/11/2011','1.750.00','SOX-TESTES','22/05/2015'),('1.556',6146,4486,'17/11/2011','178.56','SOX-TESTES','23/05/2015'),('1.407',6146,4486,'17/11/2011','76.04','SOX-TESTES','24/05/2015'),('1.949.01',2427,4565,'12/12/2011','1.680.39','SOX-TESTES','25/05/2015'),('1.949.01',2065,4606,'02/12/2011','556.1','SOX-TESTES','26/05/2015'),('1.407',2065,4606,'02/12/2011','840','SOX-TESTES','27/05/2015'),('1.949.01',2065,4639,'06/12/2011','281.5','SOX-TESTES','28/05/2015'),('1.407',2065,4639,'06/12/2011','189','SOX-TESTES','29/05/2015'),('1.949.01',2427,4662,'16/12/2011','1.233.00','SOX-TESTES','30/05/2015'),('1.949.01',1401,4666,'19/12/2011','384','SOX-TESTES','31/05/2015'),('2.908',955372,4715,'18/01/2011','2.784.00','SOX-TESTES','01/06/2015'),('1.949.01',2115,4739,'09/11/2011','2.805.00','SOX-TESTES','02/06/2015'),('1.949.01',2427,4765,'22/12/2011','6.115.00','SOX-TESTES','03/06/2015'),('1.949.01',2065,4786,'16/12/2011','29.497.39','SOX-TESTES','04/06/2015'),('1.407',2065,4786,'16/12/2011','758.06','SOX-TESTES','05/06/2015'),('1.949.01',2115,4819,'16/11/2011','1.111.01','SOX-TESTES','06/06/2015'),('1.949.01',2065,4832,'21/12/2011','410','SOX-TESTES','07/06/2015'),('1.949.01',2115,4841,'17/11/2011','1.362.10','SOX-TESTES','08/06/2015'),('1.908',2022,4858,'08/09/2011','41.400.00','SOX-TESTES','09/06/2015'),('1.949.01',2115,4864,'18/11/2011','1.177.32','SOX-TESTES','10/06/2015'),('1.949.01',6858,4891,'22/11/2011','559','SOX-TESTES','11/06/2015'),('1.949.01',6858,4904,'24/11/2011','3.520.00','SOX-TESTES','12/06/2015'),('1.949.01',6858,4911,'25/11/2011','24.600.00','SOX-TESTES','13/06/2015'),('1.949.01',6858,4937,'29/11/2011','1.624.00','SOX-TESTES','14/06/2015'),('1.949.01',6858,4940,'30/11/2011','465','SOX-TESTES','15/06/2015'),('2.949.01',2405,4957,'03/11/2011','898','SOX-TESTES','16/06/2015'),('2.556',2405,4957,'03/11/2011','20.35','SOX-TESTES','17/06/2015'),('1.949.01',6858,4966,'05/12/2011','6.490.00','SOX-TESTES','18/06/2015'),('1.949.01',2015,4999,'01/12/2011','129.56','SOX-TESTES','19/06/2015'),('1.556',2015,4999,'01/12/2011','229.1','SOX-TESTES','20/06/2015'),('1.556',2414,5002,'30/11/2011','389.98','SOX-TESTES','21/06/2015'),('1.949.01',2414,5002,'30/11/2011','31.67','SOX-TESTES','22/06/2015'),('1.949.01',2115,5007,'28/11/2011','340','SOX-TESTES','23/06/2015'),('1.556',6133,5034,'15/12/2011','165','SOX-TESTES','24/06/2015'),('1.124',63265,5040,'30/11/2011','3.431.00','SOX-TESTES','25/06/2015'),('1.902',63265,5040,'30/11/2011','5.177.31','SOX-TESTES','26/06/2015'),('1.908',2022,5107,'28/09/2011','57.440.00','SOX-TESTES','27/06/2015'),('1.949',5648,5133,'16/11/2011','8.780.40','SOX-TESTES','28/06/2015'),('1.303',2486,5154,'01/12/2011','1.17','SOX-TESTES','29/06/2015'),('2.303',2486,5174,'01/12/2011','1.17','SOX-TESTES','30/06/2015'),('1.949.01',6798,5178,'16/12/2011','4.530.00','SOX-TESTES','01/07/2015'),('1.908',2022,5210,'10/10/2011','93.380.00','SOX-TESTES','02/07/2015'),('1.908',2022,5211,'10/10/2011','135.903.60','SOX-TESTES','03/07/2015'),('1.949.01',3139,5222,'03/10/2011','3.412.50','SOX-TESTES','04/07/2015'),('1.949.01',2115,5313,'15/12/2011','3.214.30','SOX-TESTES','05/07/2015'),('1.949.01',2115,5314,'15/12/2011','1.229.66','SOX-TESTES','06/07/2015'),('1.949.01',2115,5396,'20/12/2011','6.138.72','SOX-TESTES','07/07/2015'),('2.949.01',3378,5505,'09/11/2011','867.09','SOX-TESTES','08/07/2015'),('1.556',2022,5515,'09/11/2011','1.600.00','SOX-TESTES','09/07/2015'),('1.407',2022,5553,'14/11/2011','429','SOX-TESTES','10/07/2015'),('1.556',2022,5563,'09/12/2011','5.430.90','SOX-TESTES','11/07/2015'),('1.407',2022,5563,'16/11/2011','12.687.55','SOX-TESTES','12/07/2015'),('1.407',2022,5567,'16/11/2011','217','SOX-TESTES','13/07/2015'),('1.407',2022,5569,'16/11/2011','1.600.00','SOX-TESTES','14/07/2015'),('1.407',2022,5574,'16/11/2011','23','SOX-TESTES','15/07/2015'),('1.556',2022,5574,'16/11/2011','23','SOX-TESTES','16/07/2015'),('1.949.01',2022,5574,'16/11/2011','159','SOX-TESTES','17/07/2015'),('1.407',2022,5578,'16/11/2011','12.3','SOX-TESTES','18/07/2015'),('1.407',2022,5624,'21/11/2011','69.6','SOX-TESTES','19/07/2015'),('1.556',2022,5624,'21/11/2011','75.2','SOX-TESTES','20/07/2015'),('2.556',6730,5654,'21/12/2011','300','SOX-TESTES','21/07/2015'),('1.407',2022,5670,'24/11/2011','11.495.45','SOX-TESTES','22/07/2015'),('1.556',2022,5670,'24/11/2011','1.078.90','SOX-TESTES','23/07/2015'),('1.949.01',3494,5671,'25/10/2011','642.16','SOX-TESTES','24/07/2015'),('1.407',2022,5675,'25/11/2011','272','SOX-TESTES','25/07/2015'),('1.407',2022,5678,'25/11/2011','4.644.17','SOX-TESTES','26/07/2015'),('1.556',2022,5678,'25/11/2011','680.58','SOX-TESTES','27/07/2015'),('1.949.01',2022,5678,'25/11/2011','288','SOX-TESTES','28/07/2015'),('1.407',2022,5686,'28/11/2011','26','SOX-TESTES','29/07/2015'),('2.949.01',6222,5696,'29/12/2011','218.86','SOX-TESTES','30/07/2015'),('1.949.01',2022,5715,'30/11/2011','800','SOX-TESTES','31/07/2015'),('1.407',2022,5715,'30/11/2011','410.5','SOX-TESTES','01/08/2015'),('1.556',2022,5715,'30/11/2011','649.9','SOX-TESTES','02/08/2015'),('1.407',2022,5729,'30/11/2011','279.3','SOX-TESTES','03/08/2015'),('1.407',2022,5731,'30/11/2011','457.2','SOX-TESTES','04/08/2015'),('1.407',2022,5731,'30/11/2011','457.2','SOX-TESTES','05/08/2015'),('1.407',2022,5732,'30/11/2011','372','SOX-TESTES','06/08/2015'),('1.949.01',2432,5737,'21/12/2011','11.598.52','SOX-TESTES','07/08/2015'),('1.556',2022,5769,'02/12/2011','293','SOX-TESTES','08/08/2015'),('1.407',2022,5769,'02/12/2011','114.44','SOX-TESTES','09/08/2015'),('1.407',2022,5770,'02/12/2011','543.4','SOX-TESTES','10/08/2015'),('1.556',2022,5784,'05/12/2011','40.48','SOX-TESTES','11/08/2015'),('1.407',2022,5784,'05/12/2011','26','SOX-TESTES','12/08/2015'),('1.407',2022,5785,'05/12/2011','341.5','SOX-TESTES','13/08/2015'),('1.949.01',2022,5786,'05/12/2011','92','SOX-TESTES','14/08/2015'),('1.556',2022,5786,'05/12/2011','760.5','SOX-TESTES','15/08/2015'),('2.949.01',6222,5793,'02/12/2011','231.44','SOX-TESTES','16/08/2015'),('2.949.01',3378,5794,'13/12/2011','37.829.08','SOX-TESTES','17/08/2015'),('2.949.01',3378,5810,'14/12/2011','3.065.88','SOX-TESTES','18/08/2015'),('1.556',2022,5811,'08/12/2011','3.568.00','SOX-TESTES','19/08/2015'),('1.407',2022,5811,'08/12/2011','5.770.40','SOX-TESTES','20/08/2015'),('1.407',2022,5812,'08/12/2011','867.34','SOX-TESTES','21/08/2015'),('1.556',2022,5816,'09/12/2011','234.46','SOX-TESTES','22/08/2015'),('1.407',2022,5816,'09/12/2011','1.011.35','SOX-TESTES','23/08/2015'),('1.407',2022,5819,'09/12/2011','511.04','SOX-TESTES','24/08/2015'),('1.407',2022,5820,'09/12/2011','1.013.00','SOX-TESTES','25/08/2015'),('1.556',2022,5820,'09/12/2011','2.800.00','SOX-TESTES','26/08/2015'),('1.407',2022,5821,'09/12/2011','246.55','SOX-TESTES','27/08/2015'),('1.556',2022,5821,'09/12/2011','113.28','SOX-TESTES','28/08/2015'),('1.407',2022,5834,'09/12/2011','2.664.00','SOX-TESTES','29/08/2015'),('1.556',2022,5850,'10/12/2011','280','SOX-TESTES','30/08/2015'),('1.556',2022,5855,'10/12/2011','1.418.00','SOX-TESTES','31/08/2015'),('1.407',2022,5855,'10/12/2011','41.22','SOX-TESTES','01/09/2015'),('1.407',2022,5875,'12/12/2011','790.18','SOX-TESTES','02/09/2015'),('1.556',2022,5875,'12/12/2011','47.81','SOX-TESTES','03/09/2015'),('1.949.01',2022,5875,'12/12/2011','48.57','SOX-TESTES','04/09/2015'),('1.556',2022,5895,'13/12/2011','543.2','SOX-TESTES','05/09/2015'),('1.407',2022,5895,'13/12/2011','1.013.00','SOX-TESTES','06/09/2015'),('1.407',2022,5896,'13/12/2011','20.052.00','SOX-TESTES','07/09/2015'),('1.949.01',2022,5902,'14/12/2011','190.8','SOX-TESTES','08/09/2015'),('1.407',2022,5902,'14/12/2011','1.200.99','SOX-TESTES','09/09/2015'),('1.556',2022,5902,'14/12/2011','47.78','SOX-TESTES','10/09/2015'),('1.556',2022,5909,'14/12/2011','617.5','SOX-TESTES','11/09/2015'),('1.407',2022,5909,'14/12/2011','5.580.00','SOX-TESTES','12/09/2015'),('1.407',2022,5912,'14/12/2011','296.4','SOX-TESTES','13/09/2015'),('1.556',2022,5915,'14/12/2011','219','SOX-TESTES','14/09/2015'),('1.407',2022,5933,'15/12/2011','1.574.80','SOX-TESTES','15/09/2015'),('1.556',2022,5933,'15/12/2011','239.6','SOX-TESTES','16/09/2015'),('1.407',2022,5936,'15/12/2011','505.43','SOX-TESTES','17/09/2015'),('1.303',5973,5937,'14/11/2011','1.72','SOX-TESTES','18/09/2015'),('1.407',2022,5944,'16/12/2011','1.585.20','SOX-TESTES','19/09/2015'),('1.556',2022,5944,'16/12/2011','9.707.40','SOX-TESTES','20/09/2015'),('1.949.01',2022,5944,'16/12/2011','3.285.60','SOX-TESTES','21/09/2015'),('2.949.01',3378,5945,'27/12/2011','1.536.00','SOX-TESTES','22/09/2015'),('2.949.01',3378,5956,'27/12/2011','40.258.48','SOX-TESTES','23/09/2015'),('1.949.01',2022,5968,'20/12/2011','246.57','SOX-TESTES','24/09/2015'),('1.556',2022,5968,'20/12/2011','247.39','SOX-TESTES','25/09/2015'),('1.407',2022,5968,'20/12/2011','1.949.81','SOX-TESTES','26/09/2015'),('1.949.01',2022,5969,'20/12/2011','296.99','SOX-TESTES','27/09/2015'),('1.407',2022,5969,'20/12/2011','89.25','SOX-TESTES','28/09/2015'),('1.556',2022,5973,'20/12/2011','5.400.00','SOX-TESTES','29/09/2015'),('1.407',2022,5973,'20/12/2011','9.080.00','SOX-TESTES','30/09/2015'),('1.556',2022,5974,'20/12/2011','5.373.84','SOX-TESTES','01/10/2015'),('1.407',2022,5974,'20/12/2011','3.010.96','SOX-TESTES','02/10/2015'),('1.949.01',2022,5974,'20/12/2011','1.799.50','SOX-TESTES','03/10/2015'),('1.556',2022,5975,'21/12/2011','7.218.00','SOX-TESTES','04/10/2015'),('1.407',2022,5975,'21/12/2011','4.290.00','SOX-TESTES','05/10/2015'),('1.407',2022,5976,'21/12/2011','6.400.00','SOX-TESTES','06/10/2015'),('1.556',2022,5976,'21/12/2011','9.760.00','SOX-TESTES','07/10/2015'),('1.949.01',2022,5976,'21/12/2011','500','SOX-TESTES','08/10/2015'),('1.949.01',3494,5987,'04/11/2011','927.56','SOX-TESTES','09/10/2015'),('1.407',2022,5988,'21/12/2011','241','SOX-TESTES','10/10/2015'),('1.949.01',2022,6012,'26/12/2011','117.37','SOX-TESTES','11/10/2015'),('1.556',2022,6012,'26/12/2011','429.6','SOX-TESTES','12/10/2015'),('1.556',2022,6018,'27/12/2011','70','SOX-TESTES','13/10/2015'),('2.949.01',6222,6026,'13/12/2011','360','SOX-TESTES','14/10/2015'),('1.556',2022,6026,'28/12/2011','7.564.20','SOX-TESTES','15/10/2015'),('1.407',2022,6026,'28/12/2011','5.172.60','SOX-TESTES','16/10/2015'),('1.949.01',2022,6026,'28/12/2011','560','SOX-TESTES','17/10/2015'),('1.407',2022,6028,'28/12/2011','8.633.52','SOX-TESTES','18/10/2015'),('1.556',2022,6028,'28/12/2011','2.579.70','SOX-TESTES','19/10/2015'),('1.407',2022,6036,'29/12/2011','1.954.70','SOX-TESTES','20/10/2015'),('1.407',2022,6038,'29/12/2011','3.344.30','SOX-TESTES','21/10/2015'),('1.949.01',2022,6038,'29/12/2011','45.8','SOX-TESTES','22/10/2015'),('1.949.01',3494,6260,'14/11/2011','122.4','SOX-TESTES','23/10/2015'),('1.949.01',3494,6261,'14/11/2011','926.95','SOX-TESTES','24/10/2015'),('2.949.01',2012,6298,'01/12/2011','47.6','SOX-TESTES','25/10/2015'),('2.556',2012,6298,'01/12/2011','1.211.00','SOX-TESTES','26/10/2015'),('2.949.01',3965,6323,'09/12/2011','9.000.00','SOX-TESTES','27/10/2015'),('2.556',1463,6329,'04/12/2011','3.276.80','SOX-TESTES','28/10/2015'),('1.556',1744,6338,'11/08/2011','98','SOX-TESTES','29/10/2015'),('1.407',1744,6338,'11/08/2011','365','SOX-TESTES','30/10/2015'),('1.407',2411,6397,'30/11/2011','491.42','SOX-TESTES','31/10/2015'),('1.949.01',3944,6534,'13/12/2011','2.025.00','SOX-TESTES','01/11/2015'),('2.949.01',2125,6615,'23/12/2011','3.288.00','SOX-TESTES','02/11/2015'),('2.949.01',2125,6615,'23/12/2011','3.288.00','SOX-TESTES','03/11/2015'),('2.908',955372,6626,'26/05/2011','3.712.00','SOX-TESTES','04/11/2015'),('1.949.01',1440,6857,'28/11/2011','992','SOX-TESTES','05/11/2015'),('2.949.01',2159,6879,'17/10/2011','495.8','SOX-TESTES','06/11/2015'),('2.556',2159,6879,'17/10/2011','948','SOX-TESTES','07/11/2015'),('2.303',5974,7093,'14/11/2011','12.91','SOX-TESTES','08/11/2015'),('2.949.01',7154,7126,'30/11/2011','658.35','SOX-TESTES','09/11/2015'),('1.916',2141,7174,'28/09/2010','300','SOX-TESTES','10/11/2015'),('2.303',6863,7243,'14/11/2011','24.03','SOX-TESTES','11/11/2015'),('1.556',6123,7262,'18/11/2011','720','SOX-TESTES','12/11/2015'),('1.407',6123,7387,'07/12/2011','720','SOX-TESTES','13/11/2015'),('1.407',3638,7642,'16/12/2011','768.3','SOX-TESTES','14/11/2015'),('1.556',3638,7642,'16/12/2011','94.5','SOX-TESTES','15/11/2015'),('1.556',1750,7683,'18/11/2011','8.181.45','SOX-TESTES','16/11/2015'),('1.949.01',6795,7715,'16/11/2011','48','SOX-TESTES','17/11/2015'),('1.556',6795,7715,'16/11/2011','468.42','SOX-TESTES','18/11/2015'),('1.407',6795,7715,'16/11/2011','1.071.05','SOX-TESTES','19/11/2015'),('1.556',1750,7725,'01/12/2011','7.615.50','SOX-TESTES','20/11/2015'),('1.949.01',2417,7751,'12/12/2011','860','SOX-TESTES','21/11/2015'),('1.556',2417,7751,'12/12/2011','422','SOX-TESTES','22/11/2015'),('1.556',3638,7753,'28/12/2011','200','SOX-TESTES','23/11/2015'),('1.407',3638,7753,'28/12/2011','531.34','SOX-TESTES','24/11/2015'),('1.556',1750,7765,'16/12/2011','7.726.00','SOX-TESTES','25/11/2015'),('1.556',1750,7797,'30/12/2011','6.588.40','SOX-TESTES','26/11/2015'),('2.556',6218,7845,'30/11/2011','1.655.00','SOX-TESTES','27/11/2015'),('1.556',4115,7858,'09/12/2011','20.217.50','SOX-TESTES','28/11/2015'),('1.556',4115,7954,'16/12/2011','20.610.00','SOX-TESTES','29/11/2015'),('1.949.01',2419,8005,'12/12/2011','14.033.58','SOX-TESTES','30/11/2015'),('2.949.01',6732,8029,'14/10/2011','3.967.00','SOX-TESTES','01/12/2015'),('1.949.01',8092,8088,'29/11/2011','168','SOX-TESTES','02/12/2015'),('2.556',6732,8136,'21/11/2011','661.1','SOX-TESTES','03/12/2015'),('1.407',6795,8145,'30/11/2011','137.53','SOX-TESTES','04/12/2015'),('1.407',6795,8146,'30/11/2011','113.07','SOX-TESTES','05/12/2015'),('2.949.01',6732,8147,'02/12/2011','42.6','SOX-TESTES','06/12/2015'),('2.556',6732,8147,'02/12/2011','825.96','SOX-TESTES','07/12/2015'),('2.949.01',6732,8148,'06/12/2011','925','SOX-TESTES','08/12/2015'),('2.556',6732,8148,'06/12/2011','787.67','SOX-TESTES','09/12/2015'),('2.949.01',2058,8417,'07/12/2011','1.814.40','SOX-TESTES','10/12/2015'),('1.303',6686,8431,'14/11/2011','14','SOX-TESTES','11/12/2015'),('1.303',6686,8432,'14/11/2011','1.05','SOX-TESTES','12/12/2015'),('1.949.01',1744,8688,'08/12/2011','17.012.60','SOX-TESTES','13/12/2015'),('1.407',6795,8710,'21/12/2011','371.6','SOX-TESTES','14/12/2015'),('2.949.01',2118,8750,'17/08/2011','270','SOX-TESTES','15/12/2015'),('1.556',1804,8802,'09/12/2011','80','SOX-TESTES','16/12/2015'),('1.556',6795,8873,'30/12/2011','616.52','SOX-TESTES','17/12/2015'),('1.949.01',6795,8873,'30/12/2011','29.28','SOX-TESTES','18/12/2015'),('2.556',5619,8914,'25/11/2011','783.26','SOX-TESTES','19/12/2015'),('1.949.01',2132,8927,'25/11/2011','622','SOX-TESTES','20/12/2015'),('1.949.01',2132,9019,'30/11/2011','16.586.75','SOX-TESTES','21/12/2015'),('1.407',2132,9019,'30/11/2011','12.316.00','SOX-TESTES','22/12/2015'),('1.949.01',3619,9116,'06/12/2011','1.538.73','SOX-TESTES','23/12/2015'),('1.556',3619,9116,'06/12/2011','13.2','SOX-TESTES','24/12/2015'),('1.407',3619,9116,'06/12/2011','32.88','SOX-TESTES','25/12/2015'),('1.949.01',8042,9230,'09/12/2011','2.927.72','SOX-TESTES','26/12/2015'),('1.949.01',3619,9273,'14/12/2011','3.065.66','SOX-TESTES','27/12/2015'),('1.407',3619,9273,'14/12/2011','11.43','SOX-TESTES','28/12/2015'),('1.556',3619,9273,'14/12/2011','52','SOX-TESTES','29/12/2015'),('1.949.01',2132,9357,'19/12/2011','125.4','SOX-TESTES','30/12/2015'),('1.556',1927,9395,'22/12/2011','513.76','SOX-TESTES','31/12/2015'),('1.949.01',3619,9420,'21/12/2011','35','SOX-TESTES','01/01/2016'),('1.407',3619,9420,'21/12/2011','201.16','SOX-TESTES','02/01/2016'),('1.949.01',2900,9444,'17/11/2011','300.81','SOX-TESTES','03/01/2016'),('1.556',1444,9447,'28/11/2011','824.25','SOX-TESTES','04/01/2016'),('1.407',1444,9447,'28/11/2011','2.790.00','SOX-TESTES','05/01/2016'),('1.949.01',2132,9474,'26/12/2011','6.925.00','SOX-TESTES','06/01/2016'),('1.949.01',2132,9504,'28/12/2011','3.761.20','SOX-TESTES','07/01/2016'),('1.949.01',2132,9518,'29/12/2011','98','SOX-TESTES','08/01/2016'),('1.949.01',3619,9564,'29/12/2011','192.72','SOX-TESTES','09/01/2016'),('2.949.01',6563,9632,'17/10/2011','196.2','SOX-TESTES','10/01/2016'),('2.407',6563,9632,'17/10/2011','36.4','SOX-TESTES','11/01/2016'),('1.407',2832,9788,'29/11/2011','410.75','SOX-TESTES','12/01/2016'),('1.556',2832,9788,'29/11/2011','100.21','SOX-TESTES','13/01/2016'),('2.949.01',2071,9820,'12/12/2011','726','SOX-TESTES','14/01/2016'),('1.556',2088,10047,'27/12/2011','1.785.00','SOX-TESTES','15/01/2016'),('2.949.01',2071,10191,'26/12/2011','1.940.00','SOX-TESTES','16/01/2016'),('1.949.01',7116,10266,'07/11/2011','1.622.18','SOX-TESTES','17/01/2016'),('2.949.01',2071,10297,'29/12/2011','8.335.00','SOX-TESTES','18/01/2016'),('1.949.01',7116,10497,'21/11/2011','5.904.00','SOX-TESTES','19/01/2016'),('2.949.01',2118,10553,'01/12/2011','4.424.91','SOX-TESTES','20/01/2016'),('2.556',2118,10553,'01/12/2011','148.9','SOX-TESTES','21/01/2016'),('2.949.01',2118,10556,'01/12/2011','906.05','SOX-TESTES','22/01/2016'),('1.556',6332,10571,'08/12/2011','132.81','SOX-TESTES','23/01/2016'),('1.949.01',7116,10599,'25/11/2011','1.302.00','SOX-TESTES','24/01/2016'),('2.949.01',2118,10621,'06/12/2011','33.791.20','SOX-TESTES','25/01/2016'),('2.949.01',2118,10682,'08/12/2011','2.060.00','SOX-TESTES','26/01/2016'),('1.949.01',8033,10713,'18/11/2011','3.774.26','SOX-TESTES','27/01/2016'),('1.949.01',7116,10728,'01/02/2011','1.802.49','SOX-TESTES','28/01/2016'),('1.949.01',2272,10743,'20/12/2011','1.944.00','SOX-TESTES','29/01/2016'),('1.949.01',8033,10775,'21/11/2011','510.8','SOX-TESTES','30/01/2016'),('1.949.01',7116,10836,'07/12/2011','1.006.45','SOX-TESTES','31/01/2016'),('2.303',5816,10997,'14/11/2011','3.131.39','SOX-TESTES','01/02/2016'),('1.949.01',7116,11042,'20/12/2011','145.12','SOX-TESTES','02/02/2016'),('1.949.01',7116,11151,'27/12/2011','915.2','SOX-TESTES','03/02/2016'),('1.556',1466,11171,'22/11/2011','553.93','SOX-TESTES','04/02/2016'),('1.949.01',7116,11199,'29/12/2011','6.930.00','SOX-TESTES','05/02/2016'),('2.949.01',2090,11255,'22/11/2011','2.244.60','SOX-TESTES','06/02/2016'),('1.949.01',65791,11492,'05/10/2011','4.107.60','SOX-TESTES','07/02/2016'),('2.949.01',2090,11529,'05/12/2011','603.34','SOX-TESTES','08/02/2016'),('1.949.01',1807,11720,'25/11/2011','277.05','SOX-TESTES','09/02/2016'),('1.556',3632,12004,'07/12/2011','4.191.00','SOX-TESTES','10/02/2016'),('1.949.01',1807,12020,'30/11/2011','148','SOX-TESTES','11/02/2016'),('1.949.01',2072,12047,'09/12/2011','1.254.81','SOX-TESTES','12/02/2016'),('1.949.01',65791,12076,'25/11/2011','122.978.46','SOX-TESTES','13/02/2016'),('1.949.01',65791,12095,'28/11/2011','6.972.90','SOX-TESTES','14/02/2016'),('1.949.01',1807,12109,'01/12/2011','170','SOX-TESTES','15/02/2016'),('1.949.01',1807,12117,'02/12/2011','1.476.00','SOX-TESTES','16/02/2016'),('1.556',3632,12175,'12/12/2011','6.985.00','SOX-TESTES','17/02/2016'),('1.407',2265,12238,'14/10/2011','441.7','SOX-TESTES','18/02/2016'),('1.949.01',2265,12238,'14/10/2011','600.58','SOX-TESTES','19/02/2016'),('1.949.01',65791,12292,'08/12/2011','1.098.00','SOX-TESTES','20/02/2016'),('1.949.01',3551,12324,'08/12/2011','648','SOX-TESTES','21/02/2016'),('1.949.01',1807,12367,'10/12/2011','4.352.00','SOX-TESTES','22/02/2016'),('1.949.01',1807,12443,'13/12/2011','3.799.00','SOX-TESTES','23/02/2016'),('1.556',1833,12448,'23/11/2011','1.537.20','SOX-TESTES','24/02/2016'),('1.556',1833,12530,'30/11/2011','512.4','SOX-TESTES','25/02/2016'),('1.407',2430,12643,'13/12/2011','731.82','SOX-TESTES','26/02/2016'),('1.949.01',1807,12668,'19/12/2011','1.048.00','SOX-TESTES','27/02/2016'),('2.949.01',6857,12876,'19/12/2011','181.2','SOX-TESTES','28/02/2016'),('1.949.01',2089,12903,'03/08/2011','2.695.94','SOX-TESTES','29/02/2016'),('1.407',2089,12903,'03/08/2011','64.72','SOX-TESTES','01/03/2016'),('1.556',2089,12903,'03/08/2011','31.84','SOX-TESTES','02/03/2016'),('1.949.01',1807,13094,'29/12/2011','150.5','SOX-TESTES','03/03/2016'),('1.303',6686,13189,'01/12/2011','0.62','SOX-TESTES','04/03/2016'),('1.949',2894,13543,'08/11/2011','390.288.64','SOX-TESTES','05/03/2016'),('1.407',4117,13571,'07/10/2011','88','SOX-TESTES','06/03/2016'),('1.407',2089,13586,'16/08/2011','565','SOX-TESTES','07/03/2016'),('1.949.01',8040,13608,'28/11/2011','4.860.00','SOX-TESTES','08/03/2016'),('1.949.01',8040,13619,'28/11/2011','474.02','SOX-TESTES','09/03/2016'),('1.949.01',2075,14044,'02/12/2011','893.64','SOX-TESTES','10/03/2016'),('1.407',2075,14044,'02/12/2011','147.6','SOX-TESTES','11/03/2016'),('2.949.01',2110,14118,'12/12/2011','1.694.00','SOX-TESTES','12/03/2016'),('2.949.01',2110,14152,'15/12/2011','1.360.00','SOX-TESTES','13/03/2016'),('2.949.01',2110,14259,'29/12/2011','9.976.00','SOX-TESTES','14/03/2016'),('2.949.01',2110,14260,'29/12/2011','2.064.00','SOX-TESTES','15/03/2016'),('2.949.01',2110,14265,'29/12/2011','4.288.00','SOX-TESTES','16/03/2016'),('2.407',2110,14266,'29/12/2011','400','SOX-TESTES','17/03/2016'),('1.556',6821,14418,'02/12/2011','163.2','SOX-TESTES','18/03/2016'),('1.407',6821,14418,'02/12/2011','196.8','SOX-TESTES','19/03/2016'),('1.933',6821,14418,'02/12/2011','140','SOX-TESTES','20/03/2016'),('2.407',2181,14618,'09/12/2011','336.64','SOX-TESTES','21/03/2016'),('2.556',2181,14618,'09/12/2011','115','SOX-TESTES','22/03/2016'),('1.407',4117,14868,'21/11/2011','890','SOX-TESTES','23/03/2016'),('1.556',4117,14880,'22/11/2011','1.050.00','SOX-TESTES','24/03/2016'),('1.407',4117,15196,'30/11/2011','356','SOX-TESTES','25/03/2016'),('1.556',4117,15207,'30/11/2011','500','SOX-TESTES','26/03/2016'),('1.556',4117,15277,'01/12/2011','1.700.00','SOX-TESTES','27/03/2016'),('1.407',4117,15277,'01/12/2011','187.75','SOX-TESTES','28/03/2016'),('1.407',4117,15323,'02/12/2011','890','SOX-TESTES','29/03/2016'),('1.556',4117,15323,'02/12/2011','120','SOX-TESTES','30/03/2016'),('1.407',4117,15402,'06/12/2011','916.5','SOX-TESTES','31/03/2016'),('1.556',4117,15404,'06/12/2011','1.700.00','SOX-TESTES','01/04/2016'),('1.556',4117,15437,'07/12/2011','6.040.00','SOX-TESTES','02/04/2016'),('1.949.01',6807,15587,'08/12/2011','1.799.85','SOX-TESTES','03/04/2016'),('1.949.01',7110,15595,'05/11/2011','277.9','SOX-TESTES','04/04/2016'),('1.407',7110,15595,'05/11/2011','14.7','SOX-TESTES','05/04/2016'),('1.407',4124,15687,'21/11/2011','249.27','SOX-TESTES','06/04/2016'),('1.556',4124,15687,'21/11/2011','17.04','SOX-TESTES','07/04/2016'),('1.407',4117,15706,'15/12/2011','1.240.00','SOX-TESTES','08/04/2016'),('1.949.01',7110,15778,'15/11/2011','88.9','SOX-TESTES','09/04/2016'),('1.407',7110,15778,'15/11/2011','50.2','SOX-TESTES','10/04/2016'),('1.556',4117,15789,'19/12/2011','1.320.00','SOX-TESTES','11/04/2016'),('1.407',4117,15789,'19/12/2011','50','SOX-TESTES','12/04/2016'),('1.949.01',6807,15807,'22/12/2011','5.792.07','SOX-TESTES','13/04/2016'),('1.556',6807,15807,'22/12/2011','219.03','SOX-TESTES','14/04/2016'),('1.407',4117,16052,'29/12/2011','350','SOX-TESTES','15/04/2016'),('1.556',3560,16081,'23/11/2011','269.55','SOX-TESTES','16/04/2016'),('2.303',6104,16118,'14/11/2011','3.16','SOX-TESTES','17/04/2016'),('1.556',7102,16137,'13/12/2011','365.68','SOX-TESTES','18/04/2016'),('2.949.01',6213,16226,'30/11/2011','596.7','SOX-TESTES','19/04/2016'),('1.949.01',6201,16352,'07/10/2011','4.844.59','SOX-TESTES','20/04/2016'),('1.407',4124,16362,'05/12/2011','129.8','SOX-TESTES','21/04/2016'),('1.556',4124,16362,'05/12/2011','20','SOX-TESTES','22/04/2016'),('1.556',3560,16493,'07/12/2011','339.5','SOX-TESTES','23/04/2016'),('1.556',3560,16494,'08/12/2011','744.25','SOX-TESTES','24/04/2016'),('2.303',5972,16613,'14/11/2011','0.92','SOX-TESTES','25/04/2016'),('1.556',4124,16692,'09/12/2011','202.82','SOX-TESTES','26/04/2016'),('1.407',4124,16692,'09/12/2011','262.67','SOX-TESTES','27/04/2016'),('1.949.01',2042,16710,'12/12/2011','1.813.34','SOX-TESTES','28/04/2016'),('1.949.01',2089,17018,'11/10/2011','159.23','SOX-TESTES','29/04/2016'),('1.949.01',2080,17041,'24/11/2011','275.26','SOX-TESTES','30/04/2016'),('1.949.01',2171,17059,'22/10/2011','2.772.04','SOX-TESTES','01/05/2016'),('2.949.01',6213,17100,'15/12/2011','1.016.00','SOX-TESTES','02/05/2016'),('2.949.01',6213,17138,'16/12/2011','1.012.00','SOX-TESTES','03/05/2016'),('1.949.01',2080,17147,'29/11/2011','2.020.13','SOX-TESTES','04/05/2016'),('1.556',4124,17151,'20/12/2011','58.58','SOX-TESTES','05/05/2016'),('1.407',4124,17151,'20/12/2011','222.56','SOX-TESTES','06/05/2016'),('1.949.01',2171,17279,'29/10/2011','671.15','SOX-TESTES','07/05/2016'),('1.407',2171,17279,'29/10/2011','186.3','SOX-TESTES','08/05/2016'),('2.407',3533,17286,'30/11/2011','437','SOX-TESTES','09/05/2016'),('1.949.01',2080,17578,'19/12/2011','219.12','SOX-TESTES','10/05/2016'),('1.949.01',2080,17625,'20/12/2011','926.74','SOX-TESTES','11/05/2016'),('1.949.01',2080,17709,'23/12/2011','1.403.95','SOX-TESTES','12/05/2016'),('2.949.01',2255,17769,'29/11/2011','2.735.64','SOX-TESTES','13/05/2016'),('1.556',2080,17770,'28/12/2011','805','SOX-TESTES','14/05/2016'),('1.949.01',2080,17805,'29/12/2011','835.87','SOX-TESTES','15/05/2016'),('1.556',6332,18121,'21/11/2011','935.37','SOX-TESTES','16/05/2016'),('1.556',6332,18147,'24/11/2011','3.158.53','SOX-TESTES','17/05/2016'),('1.556',6332,18168,'28/11/2011','265.6','SOX-TESTES','18/05/2016'),('1.556',6332,18170,'28/11/2011','3.024.38','SOX-TESTES','19/05/2016'),('1.556',6332,18198,'01/12/2011','5.217.05','SOX-TESTES','20/05/2016'),('1.556',6332,18226,'05/12/2011','1.922.07','SOX-TESTES','21/05/2016'),('1.556',6332,18253,'08/12/2011','2.974.76','SOX-TESTES','22/05/2016'),('1.556',6332,18269,'12/12/2011','1.512.69','SOX-TESTES','23/05/2016'),('1.556',6332,18291,'14/12/2011','397.45','SOX-TESTES','24/05/2016'),('1.556',6332,18298,'15/12/2011','1.411.71','SOX-TESTES','25/05/2016'),('1.556',6332,18299,'15/12/2011','375.36','SOX-TESTES','26/05/2016'),('2.949.01',8099,18447,'20/12/2011','6.573.60','SOX-TESTES','27/05/2016'),('1.556',2089,18660,'09/11/2011','760','SOX-TESTES','28/05/2016'),('1.949.01',2089,18907,'16/11/2011','252.32','SOX-TESTES','29/05/2016'),('1.949.01',2279,18913,'24/11/2011','26.100.48','SOX-TESTES','30/05/2016'),('2.949.01',1834,18945,'01/12/2011','1.035.00','SOX-TESTES','31/05/2016'),('1.949.01',2089,18999,'17/11/2011','608','SOX-TESTES','01/06/2016'),('1.949.01',2089,19032,'18/11/2011','963.2','SOX-TESTES','02/06/2016'),('2.949.01',1834,19080,'05/12/2011','517.5','SOX-TESTES','03/06/2016'),('1.407',2089,19132,'21/11/2011','809','SOX-TESTES','04/06/2016'),('1.949.01',2089,19190,'21/11/2011','10.284.08','SOX-TESTES','05/06/2016'),('1.556',2089,19313,'23/11/2011','388','SOX-TESTES','06/06/2016'),('2.949.01',1834,19701,'14/12/2011','470','SOX-TESTES','07/06/2016'),('1.949.01',2089,19784,'30/11/2011','1.321.51','SOX-TESTES','08/06/2016'),('2.949.01',2274,19796,'16/12/2011','363','SOX-TESTES','09/06/2016'),('2.556',2274,19796,'16/12/2011','1.524.50','SOX-TESTES','10/06/2016'),('2.949.01',1834,19837,'16/12/2011','4.491.60','SOX-TESTES','11/06/2016'),('1.949.01',2089,19929,'02/12/2011','163.44','SOX-TESTES','12/06/2016'),('1.949.01',2089,19973,'02/12/2011','1.975.07','SOX-TESTES','13/06/2016'),('1.949.01',2089,20016,'05/12/2011','2.013.74','SOX-TESTES','14/06/2016'),('1.407',2089,20016,'05/12/2011','213','SOX-TESTES','15/06/2016'),('1.949.01',3541,20017,'28/11/2011','115.5','SOX-TESTES','16/06/2016'),('1.303',2486,20026,'02/12/2011','2.95','SOX-TESTES','17/06/2016'),('1.949.01',3541,20032,'28/11/2011','1.698.51','SOX-TESTES','18/06/2016'),('1.949.01',2089,20038,'05/12/2011','807.97','SOX-TESTES','19/06/2016'),('1.556',2089,20038,'05/12/2011','240','SOX-TESTES','20/06/2016'),('1.949.01',2089,20050,'06/12/2011','3.720.00','SOX-TESTES','21/06/2016'),('1.407',2089,20050,'06/12/2011','1.618.00','SOX-TESTES','22/06/2016'),('1.949.01',3541,20075,'29/11/2011','282.15','SOX-TESTES','23/06/2016'),('1.949.01',3541,20138,'30/11/2011','15.696.98','SOX-TESTES','24/06/2016'),('1.949.01',3541,20173,'30/11/2011','2.014.10','SOX-TESTES','25/06/2016'),('1.949.01',2089,20240,'08/12/2011','3.868.88','SOX-TESTES','26/06/2016'),('1.949.01',3541,20254,'02/12/2011','372.46','SOX-TESTES','27/06/2016'),('1.949.01',2089,20350,'09/12/2011','423','SOX-TESTES','28/06/2016'),('1.949.01',3541,20361,'06/12/2011','412.5','SOX-TESTES','29/06/2016'),('1.949.01',2089,20557,'19/12/2011','450.92','SOX-TESTES','30/06/2016'),('1.949.01',2089,20573,'19/12/2011','112.5','SOX-TESTES','01/07/2016'),('1.556',2089,20573,'19/12/2011','420','SOX-TESTES','02/07/2016'),('1.949.01',2089,20794,'21/12/2011','1.726.05','SOX-TESTES','03/07/2016'),('1.407',2089,20794,'21/12/2011','123.79','SOX-TESTES','04/07/2016'),('1.949.01',2089,20833,'21/12/2011','10.482.11','SOX-TESTES','05/07/2016'),('2.303',6670,20971,'14/11/2011','11.87','SOX-TESTES','06/07/2016'),('1.949.01',64193,21688,'18/10/2011','1.440.00','SOX-TESTES','07/07/2016'),('1.949.01',1940,21796,'10/08/2011','34.365.05','SOX-TESTES','08/07/2016'),('2.407',6200,21815,'12/11/2011','600','SOX-TESTES','09/07/2016'),('1.949.01',64193,22138,'26/10/2011','478.26','SOX-TESTES','10/07/2016'),('1.949.01',1940,22162,'26/08/2011','5.177.31','SOX-TESTES','11/07/2016'),('1.407',64193,22343,'31/10/2011','136.4','SOX-TESTES','12/07/2016'),('1.949.01',64193,22343,'31/10/2011','3.527.17','SOX-TESTES','13/07/2016'),('1.949.01',64193,22508,'03/11/2011','575.81','SOX-TESTES','14/07/2016'),('1.949.01',2061,22680,'31/08/2011','146.4','SOX-TESTES','15/07/2016'),('1.949.01',64193,23054,'17/11/2011','1.593.10','SOX-TESTES','16/07/2016'),('1.949.01',64193,23055,'17/11/2011','416.07','SOX-TESTES','17/07/2016'),('1.949.01',64193,23110,'18/11/2011','166.1','SOX-TESTES','18/07/2016'),('1.949.01',64193,23243,'22/11/2011','112.45','SOX-TESTES','19/07/2016'),('1.949.01',64193,23598,'29/11/2011','603.2','SOX-TESTES','20/07/2016'),('1.949.01',2061,23607,'09/09/2011','3.705.80','SOX-TESTES','21/07/2016'),('1.949.01',64193,23634,'30/11/2011','903.11','SOX-TESTES','22/07/2016'),('1.407',64193,23634,'30/11/2011','492.48','SOX-TESTES','23/07/2016'),('1.949.01',64193,23691,'01/12/2011','2.423.78','SOX-TESTES','24/07/2016'),('1.949.01',3939,23695,'12/12/2011','4.636.43','SOX-TESTES','25/07/2016'),('1.949.01',64193,23724,'01/12/2011','2.966.29','SOX-TESTES','26/07/2016'),('1.407',64193,23724,'01/12/2011','101.52','SOX-TESTES','27/07/2016'),('1.949.01',64193,23783,'02/12/2011','387.24','SOX-TESTES','28/07/2016'),('1.949.01',2061,23817,'13/09/2011','472.32','SOX-TESTES','29/07/2016'),('1.949.01',64193,23885,'05/12/2011','545.86','SOX-TESTES','30/07/2016'),('1.949.01',64193,23889,'06/12/2011','14.772.66','SOX-TESTES','31/07/2016'),('1.949.01',64193,23904,'06/12/2011','129.94','SOX-TESTES','01/08/2016'),('1.949.01',64193,23905,'06/12/2011','131.78','SOX-TESTES','02/08/2016'),('1.407',64193,23913,'06/12/2011','124.95','SOX-TESTES','03/08/2016'),('1.949.01',64193,24023,'08/12/2011','961.05','SOX-TESTES','04/08/2016'),('1.949.01',64193,24073,'09/12/2011','200','SOX-TESTES','05/08/2016'),('1.949.01',1929,24216,'24/11/2011','23.050.00','SOX-TESTES','06/08/2016'),('1.949.01',64193,24232,'13/12/2011','713','SOX-TESTES','07/08/2016'),('1.949.01',1929,24540,'07/12/2011','13.640.00','SOX-TESTES','08/08/2016'),('1.949.01',64193,24564,'20/10/2011','1.509.08','SOX-TESTES','09/08/2016'),('2.303',2261,24690,'14/11/2011','1.722.31','SOX-TESTES','10/08/2016'),('1.949.01',2061,24778,'22/09/2011','741.64','SOX-TESTES','11/08/2016'),('1.949.01',1929,24795,'19/12/2011','853.5','SOX-TESTES','12/08/2016'),('2.949.01',1404,25856,'06/12/2011','2.232.70','SOX-TESTES','13/08/2016'),('2.949.01',2056,26585,'29/11/2011','1.833.00','SOX-TESTES','14/08/2016'),('2.949.01',2056,26661,'30/11/2011','90','SOX-TESTES','15/08/2016'),('2.556',2056,26661,'30/11/2011','60','SOX-TESTES','16/08/2016'),('2.949.01',2056,26663,'30/11/2011','2.956.00','SOX-TESTES','17/08/2016'),('2.949.01',2056,26672,'01/12/2011','979.5','SOX-TESTES','18/08/2016'),('2.949.01',2056,26673,'01/12/2011','1.517.00','SOX-TESTES','19/08/2016'),('2.556',2066,27078,'01/12/2011','1.007.20','SOX-TESTES','20/08/2016'),('2.949.01',2056,27123,'13/12/2011','515','SOX-TESTES','21/08/2016'),('2.556',2056,27329,'20/12/2011','348','SOX-TESTES','22/08/2016'),('2.949.01',2056,27329,'20/12/2011','482','SOX-TESTES','23/08/2016'),('1.556',4116,27381,'22/11/2011','926.21','SOX-TESTES','24/08/2016'),('1.556',4116,27400,'25/11/2011','584.63','SOX-TESTES','25/08/2016'),('1.556',4116,27407,'28/11/2011','1.171.09','SOX-TESTES','26/08/2016'),('1.556',4116,27422,'30/11/2011','993.29','SOX-TESTES','27/08/2016'),('1.556',4116,27437,'02/12/2011','661.59','SOX-TESTES','28/08/2016'),('1.556',4116,27444,'05/12/2011','1.984.75','SOX-TESTES','29/08/2016'),('1.556',4116,27460,'07/12/2011','1.455.48','SOX-TESTES','30/08/2016'),('1.556',4116,27470,'09/12/2011','1.455.48','SOX-TESTES','31/08/2016'),('1.556',4116,27476,'12/12/2011','661.59','SOX-TESTES','01/09/2016'),('1.556',4116,27487,'13/12/2011','1.323.17','SOX-TESTES','02/09/2016'),('1.556',4116,27490,'14/12/2011','1.587.80','SOX-TESTES','03/09/2016'),('1.556',4116,27505,'19/12/2011','793.91','SOX-TESTES','04/09/2016'),('1.556',4116,27513,'20/12/2011','1.058.53','SOX-TESTES','05/09/2016'),('1.556',4116,27521,'21/12/2011','1.323.17','SOX-TESTES','06/09/2016'),('1.556',4116,27528,'22/12/2011','1.577.93','SOX-TESTES','07/09/2016'),('1.556',4116,27540,'26/12/2011','1.058.53','SOX-TESTES','08/09/2016'),('2.556',2056,27549,'27/12/2011','816','SOX-TESTES','09/09/2016'),('1.556',4116,27555,'28/12/2011','1.058.53','SOX-TESTES','10/09/2016'),('1.556',4116,27563,'29/12/2011','1.190.85','SOX-TESTES','11/09/2016'),('2.556',2056,27609,'28/12/2011','664','SOX-TESTES','12/09/2016'),('2.949.01',2056,27618,'28/12/2011','36','SOX-TESTES','13/09/2016'),('2.556',2056,27618,'28/12/2011','281','SOX-TESTES','14/09/2016'),('2.407',2052,27825,'28/12/2011','184.5','SOX-TESTES','15/09/2016'),('2.556',2052,27825,'28/12/2011','276','SOX-TESTES','16/09/2016'),('2.303',1832,27901,'06/12/2011','13.26','SOX-TESTES','17/09/2016'),('1.949.01',3981,27963,'18/11/2011','4.151.35','SOX-TESTES','18/09/2016'),('2.949.01',1743,29005,'01/12/2011','838.44','SOX-TESTES','19/09/2016'),('2.949.01',1743,29090,'03/12/2011','1.656.00','SOX-TESTES','20/09/2016'),('2.949.01',1743,29091,'03/12/2011','628.96','SOX-TESTES','21/09/2016'),('1.949.01',2061,29620,'17/11/2011','2.597.88','SOX-TESTES','22/09/2016'),('1.949.01',2061,30938,'01/12/2011','9.386.45','SOX-TESTES','23/09/2016'),('1.949.01',2061,30938,'01/12/2011','9.386.45','SOX-TESTES','24/09/2016'),('1.949.01',6224,31325,'07/12/2011','855.79','SOX-TESTES','25/09/2016'),('1.407',1948,32211,'09/12/2011','686.25','SOX-TESTES','26/09/2016'),('1.949.01',2061,32387,'15/12/2011','677.16','SOX-TESTES','27/09/2016'),('1.949.01',1867,32463,'13/12/2011','1.463.65','SOX-TESTES','28/09/2016'),('1.407',2086,32583,'07/11/2011','2.340.00','SOX-TESTES','29/09/2016'),('1.949.01',2133,32658,'30/11/2011','580','SOX-TESTES','30/09/2016'),('1.949.01',2136,32827,'06/12/2011','846','SOX-TESTES','01/10/2016'),('1.949.01',2086,32864,'17/11/2011','12.082.00','SOX-TESTES','02/10/2016'),('1.949.01',2086,32925,'18/11/2011','6.257.40','SOX-TESTES','03/10/2016'),('1.949.01',2133,33015,'08/12/2011','2.592.40','SOX-TESTES','04/10/2016'),('1.407',2086,33067,'23/11/2011','777','SOX-TESTES','05/10/2016'),('1.949.01',2086,33067,'23/11/2011','648.5','SOX-TESTES','06/10/2016'),('1.949.01',2086,33073,'24/11/2011','311','SOX-TESTES','07/10/2016'),('1.949.01',2086,33074,'24/11/2011','2.298.24','SOX-TESTES','08/10/2016'),('1.949.01',2086,33082,'24/11/2011','56.230.00','SOX-TESTES','09/10/2016'),('1.949.01',2086,33089,'24/11/2011','8.460.00','SOX-TESTES','10/10/2016'),('1.407',2086,33097,'25/11/2011','854.82','SOX-TESTES','11/10/2016'),('1.949.01',2086,33123,'25/11/2011','17.600.00','SOX-TESTES','12/10/2016'),('1.949.01',2086,33147,'28/11/2011','10.212.75','SOX-TESTES','13/10/2016'),('1.949.01',2086,33173,'29/11/2011','5.331.50','SOX-TESTES','14/10/2016'),('1.407',2141,33229,'04/08/2011','1.160.00','SOX-TESTES','15/10/2016'),('1.949.01',2061,33243,'27/12/2011','255.97','SOX-TESTES','16/10/2016'),('1.407',1948,33328,'20/12/2011','312.85','SOX-TESTES','17/10/2016'),('1.949.01',2061,33333,'28/12/2011','582','SOX-TESTES','18/10/2016'),('1.949.01',2086,33388,'06/12/2011','4.482.80','SOX-TESTES','19/10/2016'),('1.949.01',2133,33392,'19/12/2011','1.472.00','SOX-TESTES','20/10/2016'),('1.949.01',2086,33435,'07/12/2011','3.211.85','SOX-TESTES','21/10/2016'),('1.949.01',2086,33508,'09/12/2011','5.016.12','SOX-TESTES','22/10/2016'),('1.407',2293,33868,'06/12/2011','153','SOX-TESTES','23/10/2016'),('1.407',2293,34746,'15/12/2011','38.76','SOX-TESTES','24/10/2016'),('1.556',2293,34746,'15/12/2011','274.83','SOX-TESTES','25/10/2016'),('1.407',2141,35864,'01/09/2011','1.496.00','SOX-TESTES','26/10/2016'),('1.407',2141,36697,'12/09/2011','178','SOX-TESTES','27/10/2016'),('2.303',6103,37451,'14/11/2011','1.406.56','SOX-TESTES','28/10/2016'),('2.303',6103,37452,'14/11/2011','637.38','SOX-TESTES','29/10/2016'),('1.303',2486,38405,'03/12/2011','263.57','SOX-TESTES','30/10/2016'),('1.949.01',2122,38835,'16/12/2011','548.92','SOX-TESTES','31/10/2016'),('1.949.01',7140,39775,'24/11/2011','2.499.23','SOX-TESTES','01/11/2016'),('1.407',7140,39775,'24/11/2011','125.8','SOX-TESTES','02/11/2016'),('1.949.01',7140,39776,'24/11/2011','49.32','SOX-TESTES','03/11/2016'),('1.303',3204,39828,'20/12/2011','167.93','SOX-TESTES','04/11/2016'),('1.949.01',7140,39837,'24/11/2011','684.6','SOX-TESTES','05/11/2016'),('1.556',6332,39892,'21/11/2011','3.780.48','SOX-TESTES','06/11/2016'),('1.949.01',7140,39899,'25/11/2011','3.338.89','SOX-TESTES','07/11/2016'),('1.949.01',7140,39923,'25/11/2011','257.3','SOX-TESTES','08/11/2016'),('1.949.01',7140,39993,'25/11/2011','1.336.65','SOX-TESTES','09/11/2016'),('1.949.01',7140,40055,'28/11/2011','5.214.79','SOX-TESTES','10/11/2016'),('1.949.01',7140,40068,'28/11/2011','476.25','SOX-TESTES','11/11/2016'),('1.949.01',6825,41239,'27/10/2011','237.82','SOX-TESTES','12/11/2016'),('1.949.01',7140,41274,'09/12/2011','526.2','SOX-TESTES','13/11/2016'),('1.407',7140,41274,'09/12/2011','107.92','SOX-TESTES','14/11/2016'),('1.407',7140,41410,'12/12/2011','50','SOX-TESTES','15/11/2016'),('1.949.01',7140,41410,'12/12/2011','376','SOX-TESTES','16/11/2016'),('1.949.01',7140,41440,'12/12/2011','30','SOX-TESTES','17/11/2016'),('1.949.01',7140,41678,'14/12/2011','544','SOX-TESTES','18/11/2016'),('1.556',6332,41859,'14/12/2011','3.459.14','SOX-TESTES','19/11/2016'),('1.949.01',7140,42694,'28/12/2011','543.08','SOX-TESTES','20/11/2016'),('2.949.01',1741,43455,'13/12/2011','5.447.00','SOX-TESTES','21/11/2016'),('2.556',8072,43579,'12/11/2011','547.95','SOX-TESTES','22/11/2016'),('1.949',2141,43612,'01/12/2011','154.65','SOX-TESTES','23/11/2016'),('1.407',2141,43612,'01/12/2011','40.5','SOX-TESTES','24/11/2016'),('2.556',8072,43942,'05/12/2011','238.1','SOX-TESTES','25/11/2016'),('2.949.01',8072,43942,'05/12/2011','19.4','SOX-TESTES','26/11/2016'),('1.949.01',2141,45284,'21/12/2011','253','SOX-TESTES','27/11/2016'),('1.949.01',2694,47212,'28/12/2011','227.82','SOX-TESTES','28/11/2016'),('1.949.01',2174,47728,'30/12/2011','1.183.56','SOX-TESTES','29/11/2016'),('1.303',2264,48035,'01/12/2011','404.72','SOX-TESTES','30/11/2016'),('1.949.01',2117,48187,'21/12/2011','717.26','SOX-TESTES','01/12/2016'),('2.949.01',6220,48324,'23/11/2011','537.5','SOX-TESTES','02/12/2016'),('2.556',6220,48324,'23/11/2011','85.1','SOX-TESTES','03/12/2016'),('1.949.01',2062,49281,'17/10/2011','1.960.02','SOX-TESTES','04/12/2016'),('1.949.01',1951,49406,'28/11/2011','1.370.00','SOX-TESTES','05/12/2016'),('1.949.01',1951,49574,'02/12/2011','1.320.00','SOX-TESTES','06/12/2016'),('1.949.01',1951,49961,'19/12/2011','123.9','SOX-TESTES','07/12/2016'),('1.949.01',2062,50118,'28/10/2011','3.015.01','SOX-TESTES','08/12/2016'),('1.949.01',2243,50982,'13/09/2011','874.23','SOX-TESTES','09/12/2016'),('1.949.01',2062,51369,'18/11/2011','2.593.00','SOX-TESTES','10/12/2016'),('1.949.01',2062,51695,'24/11/2011','2.195.99','SOX-TESTES','11/12/2016'),('1.303',2496,51923,'05/12/2011','459.7','SOX-TESTES','12/12/2016'),('1.303',2496,51926,'05/12/2011','519.6','SOX-TESTES','13/12/2016'),('1.949.01',2062,51939,'28/11/2011','1.969.80','SOX-TESTES','14/12/2016'),('1.949.01',2062,51940,'28/11/2011','1.725.01','SOX-TESTES','15/12/2016'),('1.949.01',2139,52159,'30/11/2011','805','SOX-TESTES','16/12/2016'),('1.949.01',2062,52168,'01/12/2011','21.343.51','SOX-TESTES','17/12/2016'),('1.949.01',2062,52169,'01/12/2011','5.208.01','SOX-TESTES','18/12/2016'),('1.556',2062,52170,'01/12/2011','2.604.00','SOX-TESTES','19/12/2016'),('1.949.01',2139,52223,'06/12/2011','1.997.00','SOX-TESTES','20/12/2016'),('1.407',2139,52258,'08/12/2011','619','SOX-TESTES','21/12/2016'),('1.556',2139,52258,'08/12/2011','75','SOX-TESTES','22/12/2016'),('1.949.01',2139,52273,'09/12/2011','230','SOX-TESTES','23/12/2016'),('1.556',2139,52273,'09/12/2011','162.5','SOX-TESTES','24/12/2016'),('1.556',2139,52276,'09/12/2011','152','SOX-TESTES','25/12/2016'),('1.407',2139,52276,'09/12/2011','220.5','SOX-TESTES','26/12/2016'),('1.407',2139,52295,'12/12/2011','276','SOX-TESTES','27/12/2016'),('1.949.01',2062,52305,'02/12/2011','6.912.00','SOX-TESTES','28/12/2016'),('1.303',2264,52874,'01/12/2011','240.14','SOX-TESTES','29/12/2016'),('1.949.01',2062,53013,'13/12/2011','2.898.00','SOX-TESTES','30/12/2016'),('2.949.01',1439,53047,'29/11/2011','247.2','SOX-TESTES','31/12/2016'),('2.556',1439,53047,'29/11/2011','68.97','SOX-TESTES','01/01/2017'),('2.303',2264,53134,'01/12/2011','234.01','SOX-TESTES','02/01/2017'),('1.949.01',2062,53242,'15/12/2011','11.249.99','SOX-TESTES','03/01/2017'),('1.949.01',2062,53485,'20/12/2011','1.660.80','SOX-TESTES','04/01/2017'),('1.949.01',2059,55365,'27/12/2011','4.438.09','SOX-TESTES','05/01/2017'),('2.407',3936,55754,'01/12/2011','900','SOX-TESTES','06/01/2017'),('1.556',2423,55841,'02/09/2011','3.198.65','SOX-TESTES','07/01/2017'),('1.303',2264,56648,'14/11/2011','565.42','SOX-TESTES','08/01/2017'),('1.303',2264,56649,'14/11/2011','482.3','SOX-TESTES','09/01/2017'),('1.303',2264,56650,'14/11/2011','1.29','SOX-TESTES','10/01/2017'),('1.949.01',3556,56677,'28/11/2011','1.704.00','SOX-TESTES','11/01/2017'),('2.949.01',6124,58339,'19/12/2011','4.439.99','SOX-TESTES','12/01/2017'),('1.303',5973,59034,'14/11/2011','1.42','SOX-TESTES','13/01/2017'),('1.303',5973,59035,'14/11/2011','53.16','SOX-TESTES','14/01/2017'),('1.303',5973,59036,'14/11/2011','41.57','SOX-TESTES','15/01/2017'),('1.949.01',2699,59134,'27/12/2011','35.989.27','SOX-TESTES','16/01/2017'),('1.949.01',2699,59135,'27/12/2011','5.953.78','SOX-TESTES','17/01/2017'),('1.949.01',2699,59232,'28/12/2011','9.045.41','SOX-TESTES','18/01/2017'),('1.949.01',2699,59307,'29/12/2011','3.998.81','SOX-TESTES','19/01/2017'),('1.407',3620,60108,'08/12/2011','2.496.90','SOX-TESTES','20/01/2017'),('1.949.01',3620,60108,'08/12/2011','1.186.20','SOX-TESTES','21/01/2017'),('2.556',5558,60395,'20/12/2011','8.099.70','SOX-TESTES','22/01/2017'),('1.407',1438,60440,'20/10/2011','195.55','SOX-TESTES','23/01/2017'),('1.407',1438,60519,'20/10/2011','801.5','SOX-TESTES','24/01/2017'),('1.949.01',3620,60519,'12/12/2011','16.643.20','SOX-TESTES','25/01/2017'),('1.407',1406,61060,'07/12/2011','97.5','SOX-TESTES','26/01/2017'),('1.303',2486,62726,'06/12/2011','3.644.21','SOX-TESTES','27/01/2017'),('2.949.01',2418,63418,'02/12/2011','938','SOX-TESTES','28/01/2017'),('2.556',2418,63418,'02/12/2011','608.6','SOX-TESTES','29/01/2017'),('2.556',2418,63446,'07/12/2011','120','SOX-TESTES','30/01/2017'),('2.949.01',2418,63446,'07/12/2011','140','SOX-TESTES','31/01/2017'),('2.556',2418,63646,'15/12/2011','3.527.80','SOX-TESTES','01/02/2017'),('2.556',2418,63861,'22/12/2011','443','SOX-TESTES','02/02/2017'),('2.556',2418,63925,'28/12/2011','134.5','SOX-TESTES','03/02/2017'),('2.556',2418,63944,'29/12/2011','360','SOX-TESTES','04/02/2017'),('1.653',1402,64509,'24/11/2011','490','SOX-TESTES','05/02/2017'),('1.653',1402,65532,'13/12/2011','490','SOX-TESTES','06/02/2017'),('1.653',1402,65998,'21/12/2011','490','SOX-TESTES','07/02/2017'),('2.949.01',2055,66625,'09/12/2011','820','SOX-TESTES','08/02/2017'),('2.949.01',2055,67635,'19/12/2011','4.032.20','SOX-TESTES','09/02/2017'),('2.949.01',2055,67933,'21/12/2011','3.162.50','SOX-TESTES','10/02/2017'),('1.303',2486,68008,'08/12/2011','1.556.34','SOX-TESTES','11/02/2017'),('1.407',2102,69540,'05/12/2011','359.5','SOX-TESTES','12/02/2017'),('1.556',2102,69540,'05/12/2011','387.5','SOX-TESTES','13/02/2017'),('1.407',2102,69673,'06/12/2011','2.580.00','SOX-TESTES','14/02/2017'),('1.407',2102,69768,'06/12/2011','1.250.35','SOX-TESTES','15/02/2017'),('1.556',2102,69768,'06/12/2011','469.75','SOX-TESTES','16/02/2017'),('1.407',2102,69825,'06/12/2011','755.4','SOX-TESTES','17/02/2017'),('1.556',2102,69825,'06/12/2011','255.3','SOX-TESTES','18/02/2017'),('1.949.01',1438,70546,'26/12/2011','510','SOX-TESTES','19/02/2017'),('1.407',1438,70546,'26/12/2011','715','SOX-TESTES','20/02/2017'),('1.949.01',1438,70561,'26/12/2011','510','SOX-TESTES','21/02/2017'),('1.407',1438,70561,'26/12/2011','801','SOX-TESTES','22/02/2017'),('1.407',2102,70788,'09/12/2011','455','SOX-TESTES','23/02/2017'),('1.556',2102,70788,'09/12/2011','38.25','SOX-TESTES','24/02/2017'),('1.949.01',3966,71364,'25/11/2011','21.794.29','SOX-TESTES','25/02/2017'),('1.407',2102,72099,'16/12/2011','62.5','SOX-TESTES','26/02/2017'),('1.556',2102,72192,'16/12/2011','140.7','SOX-TESTES','27/02/2017'),('2.556',2048,77590,'09/11/2011','3.742.56','SOX-TESTES','28/02/2017'),('1.949.01',4008,77839,'25/11/2011','835.59','SOX-TESTES','01/03/2017'),('2.556',2078,78095,'03/12/2011','1.148.14','SOX-TESTES','02/03/2017'),('2.556',2078,78360,'01/12/2011','67.8','SOX-TESTES','03/03/2017'),('2.556',2048,78604,'28/11/2011','593.1','SOX-TESTES','04/03/2017'),('2.407',2048,78604,'28/11/2011','164','SOX-TESTES','05/03/2017'),('2.556',2078,78823,'08/12/2011','188.51','SOX-TESTES','06/03/2017'),('2.949.01',2078,78823,'08/12/2011','550.25','SOX-TESTES','07/03/2017'),('2.556',2078,78976,'09/12/2011','803.7','SOX-TESTES','08/03/2017'),('2.556',2078,78984,'14/12/2011','1.071.60','SOX-TESTES','09/03/2017'),('2.556',2048,79024,'05/12/2011','635.52','SOX-TESTES','10/03/2017'),('2.556',2048,79026,'05/12/2011','164.94','SOX-TESTES','11/03/2017'),('2.407',2048,79026,'05/12/2011','541','SOX-TESTES','12/03/2017'),('1.949.01',4008,79027,'06/12/2011','271.95','SOX-TESTES','13/03/2017'),('2.407',2048,79112,'05/12/2011','728','SOX-TESTES','14/03/2017'),('2.556',2048,79137,'06/12/2011','254.75','SOX-TESTES','15/03/2017'),('2.407',2048,79387,'09/12/2011','2.320.00','SOX-TESTES','16/03/2017'),('2.556',2048,79387,'09/12/2011','160.8','SOX-TESTES','17/03/2017'),('2.556',2078,79527,'19/12/2011','803.7','SOX-TESTES','18/03/2017'),('2.407',2048,79571,'13/12/2011','90.54','SOX-TESTES','19/03/2017'),('2.556',2048,79571,'13/12/2011','802.6','SOX-TESTES','20/03/2017'),('2.556',2048,79642,'14/12/2011','72.6','SOX-TESTES','21/03/2017'),('2.556',2048,79731,'15/12/2011','1.557.15','SOX-TESTES','22/03/2017'),('2.407',2048,79731,'15/12/2011','2.829.80','SOX-TESTES','23/03/2017'),('2.407',2048,79841,'16/12/2011','127.44','SOX-TESTES','24/03/2017'),('1.949.01',1844,85128,'08/12/2011','1.949.85','SOX-TESTES','25/03/2017'),('1.556',8063,86847,'01/12/2011','117.4','SOX-TESTES','26/03/2017'),('1.407',8063,86847,'01/12/2011','33.6','SOX-TESTES','27/03/2017'),('1.933',8063,86847,'01/12/2011','325','SOX-TESTES','28/03/2017'),('2.949.01',6615,89737,'15/12/2011','2.110.58','SOX-TESTES','29/03/2017'),('1.949.01',2495,90465,'21/11/2011','152','SOX-TESTES','30/03/2017'),('1.949.01',2495,90850,'07/12/2011','233.06','SOX-TESTES','31/03/2017'),('2.303',1831,91826,'14/11/2011','400.25','SOX-TESTES','01/04/2017'),('1.556',6738,93565,'22/12/2011','1.191.60','SOX-TESTES','02/04/2017'),('1.556',4116,96271,'24/11/2011','1.323.17','SOX-TESTES','03/04/2017'),('1.556',4116,98819,'03/12/2011','661.59','SOX-TESTES','04/04/2017'),('1.556',4116,102019,'17/12/2011','1.852.44','SOX-TESTES','05/04/2017'),('1.303',5817,103424,'14/11/2011','146.98','SOX-TESTES','06/04/2017'),('1.303',5817,103425,'14/11/2011','10.306.03','SOX-TESTES','07/04/2017'),('1.303',5817,103426,'14/11/2011','3.672.57','SOX-TESTES','08/04/2017'),('1.303',5817,103427,'14/11/2011','1.161.70','SOX-TESTES','09/04/2017'),('1.303',5817,103428,'14/11/2011','1.008.61','SOX-TESTES','10/04/2017'),('1.949.01',8038,104961,'09/12/2011','606.63','SOX-TESTES','11/04/2017'),('1.556',8038,104961,'09/12/2011','54.37','SOX-TESTES','12/04/2017'),('1.303',2264,105299,'01/12/2011','196.83','SOX-TESTES','13/04/2017'),('1.949.01',6723,108223,'05/12/2011','10.236.53','SOX-TESTES','14/04/2017'),('1.949.01',2415,111805,'06/12/2011','240','SOX-TESTES','15/04/2017'),('2.949.01',6183,116375,'18/11/2011','784.6','SOX-TESTES','16/04/2017'),('1.407',2578,131453,'27/12/2011','146.5','SOX-TESTES','17/04/2017'),('1.407',2578,131454,'27/12/2011','13.5','SOX-TESTES','18/04/2017'),('1.949.01',6153,137842,'20/12/2011','194.35','SOX-TESTES','19/04/2017'),('1.303',2264,139296,'01/12/2011','0.85','SOX-TESTES','20/04/2017'),('1.556',41217,145761,'17/11/2011','3.425.40','SOX-TESTES','21/04/2017'),('2.303',1850,147503,'06/12/2011','619.4','SOX-TESTES','22/04/2017'),('1.556',41217,149095,'06/12/2011','195.72','SOX-TESTES','23/04/2017'),('1.556',41217,149097,'06/12/2011','195.74','SOX-TESTES','24/04/2017'),('1.949.01',41217,152001,'27/12/2011','4.338.16','SOX-TESTES','25/04/2017'),('2.556',2827,152591,'14/12/2011','306.46','SOX-TESTES','26/04/2017'),('2.407',2827,152591,'14/12/2011','198.72','SOX-TESTES','27/04/2017'),('1.949.01',8044,153393,'22/12/2011','16.044.05','SOX-TESTES','28/04/2017'),('1.949.01',2067,153537,'29/11/2011','1.188.54','SOX-TESTES','29/04/2017'),('1.949.01',6182,158602,'20/12/2011','770.59','SOX-TESTES','30/04/2017'),('1.653',1434,159289,'24/11/2011','480','SOX-TESTES','01/05/2017'),('1.949.01',7045,160014,'19/11/2011','827.97','SOX-TESTES','02/05/2017'),('1.949.01',7045,160015,'19/11/2011','249.56','SOX-TESTES','03/05/2017'),('1.949.01',7045,160016,'19/11/2011','154.32','SOX-TESTES','04/05/2017'),('1.949.01',7045,160097,'21/11/2011','2.3','SOX-TESTES','05/05/2017'),('1.949.01',7045,160098,'21/11/2011','2.207.10','SOX-TESTES','06/05/2017'),('1.949.01',7045,160610,'02/12/2011','2.947.20','SOX-TESTES','07/05/2017'),('2.303',2261,186120,'14/11/2011','83.54','SOX-TESTES','08/05/2017'),('2.556',65809,215646,'13/10/2011','433','SOX-TESTES','09/05/2017'),('2.556',65809,218781,'11/11/2011','321.81','SOX-TESTES','10/05/2017'),('2.556',65809,218841,'16/11/2011','254.75','SOX-TESTES','11/05/2017'),('2.556',65809,220126,'25/11/2011','254.75','SOX-TESTES','12/05/2017'),('1.556',6332,226156,'21/11/2011','521.34','SOX-TESTES','13/05/2017'),('1.556',6332,226159,'24/11/2011','1.323.17','SOX-TESTES','14/05/2017'),('1.556',2034,248246,'05/12/2011','998.85','SOX-TESTES','15/05/2017'),('2.303',3381,272355,'14/11/2011','92.31','SOX-TESTES','16/05/2017'),('1.556',1824,278968,'04/10/2011','592.48','SOX-TESTES','17/05/2017'),('1.407',1824,278968,'04/10/2011','511.42','SOX-TESTES','18/05/2017'),('1.303',2264,305057,'03/12/2011','166.19','SOX-TESTES','19/05/2017'),('1.407',1824,305189,'04/11/2011','1.931.04','SOX-TESTES','20/05/2017'),('1.556',1824,305189,'04/11/2011','2.037.96','SOX-TESTES','21/05/2017'),('1.407',1824,305191,'04/11/2011','143.04','SOX-TESTES','22/05/2017'),('1.556',1824,305191,'04/11/2011','150.96','SOX-TESTES','23/05/2017'),('1.556',1824,305315,'05/11/2011','607.35','SOX-TESTES','24/05/2017'),('1.407',1824,305315,'05/11/2011','544.65','SOX-TESTES','25/05/2017'),('1.407',1824,310071,'11/11/2011','72.4','SOX-TESTES','26/05/2017'),('1.556',1824,310071,'11/11/2011','81.2','SOX-TESTES','27/05/2017'),('1.407',8011,315415,'06/12/2011','344.24','SOX-TESTES','28/05/2017'),('1.556',1824,335801,'01/12/2011','1.660.50','SOX-TESTES','29/05/2017'),('1.407',1824,335801,'01/12/2011','1.447.30','SOX-TESTES','30/05/2017'),('1.556',1824,335802,'01/12/2011','486','SOX-TESTES','31/05/2017'),('1.407',1824,335802,'01/12/2011','423.6','SOX-TESTES','01/06/2017'),('2.303',5972,336803,'19/11/2011','3.74','SOX-TESTES','02/06/2017'),('1.303',2496,350329,'05/12/2011','219.8','SOX-TESTES','03/06/2017'),('1.303',2496,350330,'05/12/2011','608.76','SOX-TESTES','04/06/2017'),('1.303',2496,350331,'05/12/2011','809.1','SOX-TESTES','05/06/2017'),('1.303',2496,350332,'05/12/2011','359.6','SOX-TESTES','06/06/2017'),('1.303',2496,350333,'05/12/2011','564.65','SOX-TESTES','07/06/2017'),('1.303',2496,350334,'05/12/2011','359.6','SOX-TESTES','08/06/2017'),('1.303',2496,350335,'05/12/2011','269.7','SOX-TESTES','09/06/2017'),('1.303',2496,350336,'05/12/2011','109.9','SOX-TESTES','10/06/2017'),('1.303',2496,350337,'05/12/2011','223','SOX-TESTES','11/06/2017'),('1.303',2496,350338,'05/12/2011','539.4','SOX-TESTES','12/06/2017'),('1.303',2496,350340,'05/12/2011','359.6','SOX-TESTES','13/06/2017'),('1.949.01',2060,351631,'14/12/2011','172','SOX-TESTES','14/06/2017'),('1.407',2060,351631,'14/12/2011','144','SOX-TESTES','15/06/2017'),('1.949.01',6756,386589,'27/12/2011','1.423.50','SOX-TESTES','16/06/2017'),('2.556',3375,389613,'01/12/2011','806.62','SOX-TESTES','17/06/2017'),('2.949.01',3375,393950,'09/12/2011','968.05','SOX-TESTES','18/06/2017'),('2.556',3375,393950,'09/12/2011','1.231.63','SOX-TESTES','19/06/2017'),('2.556',3375,396731,'14/12/2011','32','SOX-TESTES','20/06/2017'),('2.303',5972,398804,'16/12/2011','0.74','SOX-TESTES','21/06/2017'),('2.556',3375,399594,'20/12/2011','3.080.00','SOX-TESTES','22/06/2017'),('1.556',6228,419839,'03/12/2011','2.024.00','SOX-TESTES','23/06/2017'),('1.407',6228,419839,'03/12/2011','1.973.50','SOX-TESTES','24/06/2017'),('1.556',6228,419841,'03/12/2011','360.4','SOX-TESTES','25/06/2017'),('1.407',6228,419841,'03/12/2011','1.366.20','SOX-TESTES','26/06/2017'),('1.407',6228,419843,'03/12/2011','12.012.75','SOX-TESTES','27/06/2017'),('1.556',6228,419843,'03/12/2011','12.329.10','SOX-TESTES','28/06/2017'),('1.407',6228,419845,'03/12/2011','1.577.94','SOX-TESTES','29/06/2017'),('1.556',6228,419845,'03/12/2011','1.618.11','SOX-TESTES','30/06/2017'),('1.556',6228,419847,'03/12/2011','3.940.41','SOX-TESTES','01/07/2017'),('1.407',6228,419847,'03/12/2011','3.843.69','SOX-TESTES','02/07/2017'),('1.556',6228,419849,'03/12/2011','290.43','SOX-TESTES','03/07/2017'),('1.407',6228,419849,'03/12/2011','283.22','SOX-TESTES','04/07/2017'),('1.407',6228,419852,'03/12/2011','5.265.00','SOX-TESTES','05/07/2017'),('1.556',6228,419852,'03/12/2011','5.400.20','SOX-TESTES','06/07/2017'),('1.556',6228,419854,'03/12/2011','6.470.10','SOX-TESTES','07/07/2017'),('1.407',6228,419854,'03/12/2011','9.597.90','SOX-TESTES','08/07/2017'),('1.407',6228,419856,'03/12/2011','2.210.32','SOX-TESTES','09/07/2017'),('1.556',6228,419856,'03/12/2011','2.266.88','SOX-TESTES','10/07/2017'),('1.407',6228,419858,'03/12/2011','1.026.22','SOX-TESTES','11/07/2017'),('1.556',6228,419858,'03/12/2011','1.052.48','SOX-TESTES','12/07/2017'),('1.407',6228,419860,'03/12/2011','1.791.24','SOX-TESTES','13/07/2017'),('1.556',6228,419860,'03/12/2011','1.836.56','SOX-TESTES','14/07/2017'),('1.407',6228,419863,'03/12/2011','838.6','SOX-TESTES','15/07/2017'),('1.556',6228,419863,'03/12/2011','860.4','SOX-TESTES','16/07/2017'),('1.407',6228,419897,'03/12/2011','366.12','SOX-TESTES','17/07/2017'),('1.556',6228,419897,'03/12/2011','375.48','SOX-TESTES','18/07/2017'),('1.556',6228,419904,'03/12/2011','931.04','SOX-TESTES','19/07/2017'),('1.407',6228,419904,'03/12/2011','907.81','SOX-TESTES','20/07/2017'),('1.407',6228,419909,'03/12/2011','3.497.62','SOX-TESTES','21/07/2017'),('1.556',6228,419909,'03/12/2011','3.587.26','SOX-TESTES','22/07/2017'),('1.407',6228,419911,'03/12/2011','3.479.56','SOX-TESTES','23/07/2017'),('1.556',6228,419911,'03/12/2011','3.568.14','SOX-TESTES','24/07/2017'),('1.556',6228,419915,'03/12/2011','4.655.20','SOX-TESTES','25/07/2017'),('1.407',6228,419915,'03/12/2011','4.539.05','SOX-TESTES','26/07/2017'),('1.407',6228,420559,'06/12/2011','789.4','SOX-TESTES','27/07/2017'),('1.556',6228,420559,'06/12/2011','809.6','SOX-TESTES','28/07/2017'),('1.407',6228,420872,'07/12/2011','2.605.02','SOX-TESTES','29/07/2017'),('1.556',6228,420872,'07/12/2011','2.671.68','SOX-TESTES','30/07/2017'),('1.556',6228,420874,'07/12/2011','890.56','SOX-TESTES','31/07/2017'),('1.407',6228,420874,'07/12/2011','868.34','SOX-TESTES','01/08/2017'),('1.556',6228,420904,'07/12/2011','1.173.92','SOX-TESTES','02/08/2017'),('1.407',6228,420904,'07/12/2011','1.144.63','SOX-TESTES','03/08/2017'),('1.556',6228,420905,'07/12/2011','2.318.55','SOX-TESTES','04/08/2017'),('1.556',6228,420962,'07/12/2011','19.430.40','SOX-TESTES','05/08/2017'),('1.407',6228,420962,'07/12/2011','18.945.60','SOX-TESTES','06/08/2017'),('1.407',6228,421904,'08/12/2011','315.76','SOX-TESTES','07/08/2017'),('1.556',6228,421904,'08/12/2011','323.84','SOX-TESTES','08/08/2017'),('1.407',6228,421907,'08/12/2011','473.64','SOX-TESTES','09/08/2017'),('1.556',6228,421907,'08/12/2011','485.76','SOX-TESTES','10/08/2017'),('1.407',6228,421911,'08/12/2011','289.24','SOX-TESTES','11/08/2017'),('1.556',6228,421911,'08/12/2011','296.45','SOX-TESTES','12/08/2017'),('1.407',6228,422385,'09/12/2011','3.670.71','SOX-TESTES','13/08/2017'),('1.556',6228,422385,'09/12/2011','3.764.64','SOX-TESTES','14/08/2017'),('1.556',6228,423475,'14/12/2011','4.048.00','SOX-TESTES','15/08/2017'),('1.407',6228,423475,'14/12/2011','3.947.00','SOX-TESTES','16/08/2017'),('1.949.01',3627,424977,'21/12/2011','8.288.80','SOX-TESTES','17/08/2017'),('1.303',6100,485220,'23/11/2011','20.185.01','SOX-TESTES','18/08/2017'),('1.303',6100,485722,'23/11/2011','6.234.76','SOX-TESTES','19/08/2017'),('1.556',65873,507287,'03/10/2011','1.312.00','SOX-TESTES','20/08/2017'),('1.556',65873,529014,'05/10/2011','332','SOX-TESTES','21/08/2017'),('1.303',2496,537231,'19/12/2011','217.8','SOX-TESTES','22/08/2017'),('1.407',1400,685812,'24/09/2011','3.285.00','SOX-TESTES','23/08/2017'),('1.556',1400,685812,'24/09/2011','4.023.00','SOX-TESTES','24/08/2017'),('1.303',5817,751746,'14/11/2011','45.95','SOX-TESTES','25/08/2017'),('1.303',5817,751747,'14/11/2011','558.49','SOX-TESTES','26/08/2017'),('1.303',5817,751748,'14/11/2011','481.52','SOX-TESTES','27/08/2017'),('1.303',5817,751749,'14/11/2011','620.21','SOX-TESTES','28/08/2017'),('1.949.01',2247,787458,'10/12/2011','14.913.64','SOX-TESTES','29/08/2017'),('1.949.01',2247,795440,'30/12/2011','5.990.00','SOX-TESTES','30/08/2017'),('1.407',2247,795440,'30/12/2011','354','SOX-TESTES','31/08/2017'),('2.303',8054,866817,'22/11/2011','97.13','SOX-TESTES','01/09/2017'),('1.303',2496,997177,'12/12/2011','399.7','SOX-TESTES','02/09/2017'),('1.303',2496,997179,'12/12/2011','597.6','SOX-TESTES','03/09/2017'),('2.303',5971,1925594,'19/11/2011','546.77','SOX-TESTES','04/09/2017'),('2.303',5971,1945016,'16/12/2011','298.33','SOX-TESTES','05/09/2017'),('2.303',5971,1971795,'17/09/2011','390.57','SOX-TESTES','06/09/2017'),('2.303',5971,1996627,'19/11/2011','224.85','SOX-TESTES','07/09/2017'),('2.303',5971,2017751,'16/12/2011','352.57','SOX-TESTES','08/09/2017'),('1.303',2496,2854072,'28/12/2011','215.24','SOX-TESTES','09/09/2017'),('2.303',5971,2859085,'16/12/2011','280.22','SOX-TESTES','10/09/2017');



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

a query que eu to executando é essa....

SELECT 
DISTINCT dataFinal,
cfop, GROUP_CONCAT(cfop) AS gCfop, 
forn, GROUP_CONCAT(forn) AS gForn, 
nf, GROUP_CONCAT(nf) AS gNf, 
emiss, GROUP_CONCAT(emiss) AS gEmiss, 
valor, GROUP_CONCAT(valor) AS gValor, 
GROUP_CONCAT(dataFinal) AS gDataFinal 
FROM 
fiscal1 
WHERE 
nameProccess = 'SOX-TESTES' 
GROUP BY 
nf, forn, emiss/*, dataFinal*/
HAVING 
COUNT(gForn) > 1

oque você falou nao da certo pq eu quero justamente ao contrário, que não retorne datas iguais

Rafafel Reis - PHP · Março 1, 2012

Pessoal, consegui... Da uma olhada na query


$query = "
SELECT 
/*COUNT(DISTINCT dataFinal) AS cDataFinal,*/
cfop, GROUP_CONCAT(cfop) AS gCfop, 
forn, GROUP_CONCAT(forn) AS gForn, 
nf, GROUP_CONCAT(nf) AS gNf, 
emiss, GROUP_CONCAT(emiss) AS gEmiss, 
valor, GROUP_CONCAT(valor) AS gValor, 
GROUP_CONCAT(dataFinal) AS gDataFinal 
FROM 
fiscal1 
WHERE 
nameProccess = 'SOX-TESTES' 
GROUP BY 
nf, forn, emiss
HAVING 
COUNT(gForn) > 1 AND COUNT(DISTINCT dataFinal) > 1 ;
";

/* 
* Ou seja, se a contagem da dataFinal, sendo ela distinta 
* (valores diferentes), for maior que 1 retorna, se não, 
* não retorna
*/

Entrar

Arquivado

[Resolvido] Consulta que retorna valores diferentes

Recommended Posts

Rafafel Reis - PHP 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

manolegal 12

Compartilhar este post

Link para o post

Compartilhar em outros sites

shini 318

Compartilhar este post

Link para o post

Compartilhar em outros sites

Rafafel Reis - PHP 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

shini 318

Compartilhar este post

Link para o post

Compartilhar em outros sites

Rafafel Reis - PHP 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Rafafel Reis - PHP 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Girls From Your Town - Anonymous Casual Dating - No Selfie

Alteracao Tema Wordpress Profolio

Alteracao Tema Wordpress Profolio

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante