SELECT
                          count(*) as Qtde ,VF.Nota
                        FROM Imoveis_Vandelay I INNER JOIN Cidades C ON I.CodigoCidade=C.CodigoCidade
                            INNER JOIN Estados E ON C.CodigoEstado=E.CodigoEstado
                            INNER JOIN Imoveis_Tipos_Rede T ON I.CodigoTipoImovel=T.CodigoTipoImovel
                            INNER JOIN Usuarios_Vandelay U ON I.CodigoUsuario=U.CodigoUsuario
                            LEFT JOIN Imoveis_Categorias CAT ON I.CodigoCategoriaImovel=CAT.CodigoCategoriaImovel
                            LEFT JOIN Usuarios_Vandelay UA ON I.CodigoUsuario_Angariacao=UA.CodigoUsuario
                            LEFT JOIN Usuarios_Vandelay UOP ON I.CodigoUsuario_Operador=UOP.CodigoUsuario
                              INNER JOIN visitantes_favoritos VF on VF.CodigoImovel = I.CodigoImovel 
                        WHERE I.Lancamento=0 AND I.Finalizado=0 AND (I.CodigoPrivacidadeImovel=1 OR I.CodigoUsuario=2) AND I.CodigoTipoNegocio=2 AND 0=0 AND 0=0 AND 0=0 AND NOT EXISTS(SELECT 1 FROM negociacoes N WHERE N.CodigoImovel=I.CodigoImovel AND N.CodigoStatusNegociacao IN (4,5,6,7)) AND VF.CodigoVisitante =  AND U.Ativo=1 ORDER BY VF.Nota DESC  = 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 'AND U.Ativo=1 ORDER BY VF.Nota DESC' at line 11