SELECT
	                SUM(COALESCE(TM.VOLUMEREAL, 0)) AS VOLUMEFATURADOCX,
	                SUM(COALESCE(HIST.QTDEVENDA, 0)) AS VOLUMEVENDIDO,
	                SUM(COALESCE(TM.TONELADAREAL, 0)) AS VOLUMEFATURADOKG,
	                SUM(COALESCE(HIST.TOTALPESO, 0)) AS VOLUMEVENDIDOKG,
	                SUM(TM.VLRPRAZOPAGTO) AS FATURAMENTORS,
	                CASE WHEN SUM(TM.VLRPRAZOPAGTO) = 0 OR SUM(TM.VOLUMEREAL) = 0 THEN 0 ELSE SUM(TM.VLRPRAZOPAGTO)/SUM(TM.VOLUMEREAL) END AS PRECOMEDIOFATURADORSCX,
	                CASE WHEN SUM(TM.VLRPRAZOPAGTO) = 0 OR SUM(TM.TONELADAREAL) = 0 THEN 0 ELSE SUM(TM.VLRPRAZOPAGTO)/SUM(TM.TONELADAREAL) END AS PRECOMEDIOFATURADORSKG,
	                SUM(FATCOMMODITIES.VLRPRAZOPAGTO) AS FATURAMENTOCOMMODITIES,
	                '' AS FATURAMENTOMIXIDEAL,
	                SUM(QTDECATEGORIAS.CATEGORIASQTDE) AS QTDECATEGORIAS,
	                COUNT(HIST.CODIGOPRODUTO) AS NROITENSPORCLIENTE,
	                COUNT(COALESCE(NOTA.CODIGOCLIENTE, 0)) AS CLIENTESPOSITIVADOSQTDE,
	                COUNT(COALESCE(NOTAPED.NUMNOTAFISCAL, '')) AS PEDIDOSQTDE
                FROM TESP_META TM
                LEFT JOIN (
		                SELECT THI.QTDEVENDA, THI.CODIGOPRODUTO, THI.TOTALPESO
			                FROM TE_HISTPEDIDOITEM THI
			                INNER JOIN TE_HISTPEDIDO TH ON (TH.CODIGOVENDEDORESP = '01738'  AND TH.NUMPEDIDOEMP = THI.NUMPEDIDOEMP)
			                WHERE TH.DATAPEDIDO BETWEEN CONVERT(DATETIME, '01/01/2017', 103) AND
			                CONVERT(DATETIME, '31/01/2017', 103)
                ) HIST ON (HIST.CODIGOPRODUTO = TM.CODIGOPRODUTO)
                LEFT JOIN (
	                SELECT TN.CODIGOCLIENTE
		                FROM TE_NOTAFISCAL TN
		                INNER JOIN TR_CLIENTEVENDEDOR TRC ON (TRC.CODIGOVENDEDORESP = '01738')
		                WHERE TN.CODIGOCLIENTE = TRC.CODIGOCLIENTE AND
		                TN.DATAEMISSAO BETWEEN CONVERT(DATETIME, '01/01/2017', 103) AND
			                CONVERT(DATETIME, '31/01/2017', 103)
	                GROUP BY TN.CODIGOCLIENTE
                ) NOTA ON (1 = 1)
                LEFT JOIN (
	                SELECT TN.NUMNOTAFISCAL
		                FROM TE_NOTAFISCAL TN
		                INNER JOIN TR_CLIENTEVENDEDOR TRC ON (TRC.CODIGOVENDEDORESP = '01738')
		                WHERE TN.CODIGOCLIENTE = TRC.CODIGOCLIENTE AND
		                TN.DATAEMISSAO BETWEEN CONVERT(DATETIME, '01/01/2017', 103) AND
			                CONVERT(DATETIME, '31/01/2017', 103)
		                GROUP BY TN.NUMNOTAFISCAL
                ) NOTAPED ON (1 = 1)
                LEFT JOIN (
	                SELECT COUNT(TP.CODIGO) AS CATEGORIASQTDE FROM TESP_META TSM
	                INNER JOIN TE_PRODUTO TP ON (TP.CODIGO = TSM.CODIGOPRODUTO)
	                INNER JOIN T_CATEGORIA TC ON (TC.CODIGO = TP.CODIGOCATEGORIA)
	                WHERE
	                TSM.CODIGOVENDEDORESP = '01738' AND
	                TSM.ANO = '2017' AND
	                TSM.MES = '01' AND
	                TSM.VOLUMEREAL > 0
                ) QTDECATEGORIAS ON (1 = 1)
                LEFT JOIN (
                SELECT TSM.VLRPRAZOPAGTO AS VLRPRAZOPAGTO
                FROM TESP_META TSM
                LEFT JOIN TESP_CATEGFOCOPROD CATFOCOPROD ON (CATFOCOPROD.CODIGOPRODUTO = TSM.CODIGOPRODUTO)
                LEFT JOIN TESP_CATEGORIASFOCO CATFOCO ON (CATFOCO.CODIGO = CATFOCOPROD.CODIGOCATEGFOCO)
                WHERE
	                TSM.CODIGOVENDEDORESP = '01738' AND
	                TSM.ANO = '2017' AND
	                TSM.MES = '01' AND
	                TSM.VOLUMEREAL > 0 AND
	                CATFOCO.DESCRICAO = 'Commodities'
                ) FATCOMMODITIES ON (1 = 1)
                WHERE
	                CODIGOVENDEDORESP = '01738' AND
	                ANO = '2017' AND
	                MES = '01'