Query Dando erro com subquery

Já tentei de tudo e continua dando esse bendito erro. essas aspas simples é o php que esta colocando e com isso esta dando esse erro.

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.CPFCNPJMATRIZ) as TOTAL_GERAL from operacao op INNER JOIN agente ag ON ag.`' at line 1

SELECT cadsup.NOME as NOME_SUPER, cadmat.CPFCNPJ as CPF_MATRIZ, cadmat.NOME as NOME_MATRIZ, cadmat.DTHRINSERT as DATA_CADASTRO, SUM(op.TOT_FAC) as VALOR_TOTAL, COUNT() as TOTAL_MES, Year(op.DATAACEITE), (SELECT COUNT() FROM operacao op_in2 WHERE Year(op_in2.DATAACEITE) = 2016 AND op_in2.CODSTATUS IN (5, 7) AND op_in2.CPFCNPJMATRIZ = op.CPFCNPJMATRIZ GROUP BY op_in2.CPFCNPJMATRIZ) as TOTAL_GERAL from operacao op INNER JOIN agente ag ON ag.CPFCNPJ = op.CPFCNPJAGENTE INNER JOIN rup cadsup ON cadsup.CPFCNPJ = ag.CPFCNPJSUPERVISOR INNER JOIN rup cadmat ON cadmat.CPFCNPJ = ag.CPFCNPJMATRIZ WHERE op.DATAACEITE BETWEEN 2016-11-01 AND 2016-12-19 AND op.CODSTATUS IN (5,7) AND op.CODPRODUTO in (1,2) GROUP BY ag.CPFCNPJMATRIZ ORDER BY TOTAL_GERAL DESC

SQL NA INTEGRA:

$this->db->select('cadsup.NOME as NOME_SUPER

 ,cadmat.CPFCNPJ as CPF_MATRIZ

 ,cadmat.NOME as NOME_MATRIZ

 ,cadmat.DTHRINSERT as DATA_CADASTRO

 ,SUM(op.TOT_FAC) as VALOR_TOTAL

 ,COUNT(*) as TOTAL_MES

 ,Year(op.DATAACEITE)

 ,(SELECT COUNT(*) FROM operacao op_in2 WHERE Year(op_in2.DATAACEITE) = 2016 AND op_in2.CODSTATUS IN (5,7) AND op_in2.CPFCNPJMATRIZ = op.CPFCNPJMATRIZ

 GROUP BY op_in2.CPFCNPJMATRIZ) as TOTAL_GERAL

 from operacao op

 INNER JOIN agente ag ON ag.CPFCNPJ = op.CPFCNPJAGENTE

 INNER JOIN rup cadsup ON cadsup.CPFCNPJ = ag.CPFCNPJSUPERVISOR

 INNER JOIN rup cadmat ON cadmat.CPFCNPJ = ag.CPFCNPJMATRIZ');