SELECT STRAIGHT_JOIN A.nfce, A.caixa, A.empresa, IF(E.REGIME=1,C.COD_CONT_SN, IF(E.REGIME=3,C.COD_CONT_LR, C.COD_CONT_LP)) as COD_CONT,    
       A.ALIQUOTACOFINS AS ALIQ_COFINS, SUM(A.QTDXUNIT) AS VL_REC_BRT,    
      SUM(if(A.CST_COFINS='05', 0,(A.QTDXUNIT-A.DESCONTO+A.ACRESCIMO-A.DESCONTO_ITEM))) AS VL_BC_CONT,    
      ROUND(SUM(if (A.CST_COFINS='05',0,((A.QTDXUNIT-A.DESCONTO+A.ACRESCIMO-A.DESCONTO_ITEM) *    
        (A.ALIQUOTACOFINS/100)))),2) AS VL_CONT_APUR ,
		  A.CST_COFINS, A.ID_PRODUTO
      FROM MOVDIARIO A    
      INNER JOIN PDVS PDV ON A.CAIXA = PDV.NUMERO AND A.EMPRESA = PDV.ID_EMPRESA    
      INNER JOIN PRODUTO B ON A.ID_PRODUTO = B.CODITEM    
      LEFT JOIN tributacaopiscofins C ON B.COD_TRIBPISCOFINSVENDAS = C.ID    
      LEFT JOIN empresas E ON E.CODIGO_N = A.EMPRESA             
      WHERE A.EMISSAO BETWEEN(:datainicial) AND (:datafinal)    
      AND A.EMPRESA in (1,2)    
      AND (A.situacao is null or A.situacao='' or A.situacao=' ')    
      AND IF(E.REGIME=1,C.COD_CONT_SN, IF(E.REGIME=3,C.COD_CONT_LR, C.COD_CONT_LP))    
      IN ('01', '02', '03','04', '32', '71','31','51','52','53','54','72')    
      AND A.CST_COFINS IN ('01', '02', '03', '04', '05', '49')    
      AND A.TIPO='V' and A.ALIQUOTACOFINS>0    
      AND A.NFCE > 0    
      AND PDV.MODELODOC = 65
		AND A.cst_cofins = '02'    
      GROUP BY 
		A.empresa, A.caixa, A.nfce, 
		A.ALIQUOTACOFINS, COD_CONT, A.ID_PRODUTO
		ORDER BY 10;*/