Error

Se produjo un error al acceder a la base de datos Incorrect syntax near the keyword 'and'. SELECT NFDN, NADN, metabanco, desembolsado, TuberiaMes, prospectos, avanceporc, supervisor from (SELECT TOP (100) PERCENT fkSupervisor, supervisor, fkAgencia, Agencia, SUM(NFDN) as NFDN, metaTotal * 3.25 as metaTotal, metaDolaresTotal * 3.25 as metaDolaresTotal, metabanco * 3.25 as metabanco, SUM(desem)* 3.25 AS desembolsado, SUM(tuberiames)* 3.25 as TuberiaMes,SUM(prospectos)* 3.25 AS prospectos, SUM(NADNActivos) AS NADN, (SELECT varAvanceOptimo FROM coreComercial.avanceOptimoProduccion WHERE idMes= and (idDia = (case when MONTH(getdate())= then (DAY(getdate()) -1) else (select MAX(b.idDia) from coreComercial.avanceOptimoProduccion b where b.idMes=) end))) AS avanceporc, (SELECT varMejorPorcAvancMes FROM coreComercial.avanceOptimoProduccion WHERE idMes= and (idDia = (case when MONTH(getdate())= then (DAY(getdate()) - 1) else (select MAX(b.idDia) from coreComercial.avanceOptimoProduccion b where b.idMes=) end))) AS AvanceMejorMes FROM (SELECT fkAgencia, (SELECT varAgencia FROM coreComercial.agencias AS f WHERE (a.fkAgencia = idAgencia)) AS Agencia, fkZonal, (select COUNT(fkFuncionario) from coreComercial.mesas h, coreComercial.funcionarios x where h.bitEstado=1 and h.fkAgencia=a.fkAgencia and h.fkFuncionario=x.idFuncionario and x.chaSegmento<>3) as NFDN, (SELECT varNombre FROM coreRecursosHumanos.personal AS z WHERE (idPersonal = a.fkZonal)) AS Zonal, fkSupervisor, (SELECT varNombre FROM coreRecursosHumanos.personal AS z WHERE (idPersonal = a.fkSupervisor)) AS supervisor, (SELECT SUM(decMetaT) AS Expr1 FROM coreComercial.metas AS b WHERE (a.fkAgencia = fkAgencia) AND (bitEstado = 1) AND (varGrupo IN (1))) AS metaTotal, (SELECT SUM(decMetaP) AS Expr1 FROM coreComercial.metas AS b WHERE (a.fkAgencia = fkAgencia) AND (bitEstado = 1) AND (varGrupo IN (1))) AS metaDolaresTotal, (select SUM(decMetaBanco) from coreComercial.agencias where (a.fkAgencia = idAgencia)) as metabanco, (SELECT SUM(decImporteDolares) AS Expr1 FROM micro.expedientes AS c WHERE (fkAgencia = a.fkAgencia) AND (u_fkTrackingE = 7) and fkProducto not in (310,105) AND (MONTH(u_datFechaE) = AND (YEAR(u_datFechaE) = ))) AS desem, (SELECT SUM(decImporteDolares) AS Expr1 FROM micro.expedientes AS c WHERE (fkAgencia = a.fkAgencia) AND (bitVisita = 0) AND (fkproducto not in (105,310,033,498,044,045,152,155,159,160)) AND (u_fkTrackingE not in (7,8,9,26,28,31,30,33,35,42,50,54)) AND ((YEAR(u_datFechaE) = ))) AS prospectos, (SELECT SUM(decImporteDolares) AS Expr1 FROM micro.expedientes AS c WHERE (fkAgencia = a.fkAgencia) AND (bitVisita = 0) AND (fkproducto not in (105,310,033,498,044,045,152,155,159,160)) AND (u_fkTrackingE not in (7,8,9,26,28,31,30,33,35,42,50,54)) AND (MONTH(u_datFechaE) = ) AND ((YEAR(u_datFechaE) = ))) AS tuberiames, (SELECT COUNT(fkAsesor) AS Expr1 FROM coreComercial.organizaciondetalle AS w WHERE (fkAgencia = a.fkAgencia) AND (bitEstado = 1) AND (bitOrganizacion = 1) AND (fkOrganizacion = (SELECT MAX(idOrganizacion) AS Expr1 FROM coreComercial.organizacion where month(datFecha)= and YEAR(datFecha)=))) AS NADNActivos FROM coreComercial.orgsupervisores AS a WHERE (fkAgencia <> 0) GROUP BY fkZonal, fkSupervisor, fkAgencia) AS t1 where fkSupervisor = GROUP BY fkZonal, Zonal, fkSupervisor, supervisor, fkAgencia, Agencia, metaTotal, metaDolaresTotal,metabanco ) nm_sel_esp order by supervisor asc