Query Dando erro com subquery

[avelar.avelar 0]

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');