>>Cadê a consulta? SELECT prospects.nome AS nomeProspect, prospects.codigo AS codigoProspect, prospects.dataCadastro AS dataCadastro, prospects.telefoneResidencial AS telRes, prospects.telefoneComercial AS telComer, prospects.celular AS cel, prospects.telefoneRecado AS telRec, prospects.emailPrincipal AS email, interacaoworkflow.datainicio AS dataContato, interacaoworkflow.observacao AS observacao, situacaoprospectpipeline.controle AS controleSituacaoProspectPipeline, turma.identificadorturma AS turma, curso.nome AS nomeCurso, curso.codigo AS codigoCurso, consultorPadrao.nome AS nomeConsultorPadrao, pessoaResponsavel.nome AS nomeResponsavel, matricula.matricula, c3.nome AS cursoMatriculado, ( SELECT count ( matricula.matricula ) FROM matricula WHERE aluno = pessoaProspect.codigo AND matricula.situacao = 'AT' ) > 0 AS possuiMatricula FROM prospects LEFT JOIN pessoa AS pessoaProspect ON pessoaProspect.codigo = prospects.pessoa LEFT JOIN interacaoworkflow ON interacaoworkflow.codigo = ( SELECT iwf.codigo FROM interacaoworkflow iwf WHERE prospects.codigo = iwf.prospect ORDER BY datainicio DESC LIMIT 1 ) LEFT JOIN etapaWorkflow ON interacaoworkflow.etapaWorkflow = etapaWorkflow.codigo LEFT JOIN usuario ON interacaoworkflow.responsavel = usuario.codigo LEFT JOIN pessoa AS pessoaResponsavel ON usuario.pessoa = pessoaResponsavel.codigo LEFT JOIN funcionario ON prospects.consultorPadrao = funcionario.codigo LEFT JOIN pessoa AS consultorPadrao ON consultorPadrao.codigo = funcionario.pessoa LEFT JOIN cursointeresse ON cursointeresse.prospects = prospects.codigo AND cursointeresse.codigo = ( SELECT ci.codigo FROM cursointeresse ci WHERE ci.prospects = prospects.codigo ORDER BY ci.codigo DESC LIMIT 1 ) LEFT JOIN curso ON ( curso.codigo = cursointeresse.curso ) LEFT JOIN curso c2 ON ( c2.codigo = interacaoworkflow.curso )
LEFT JOIN matricula ON matricula.aluno = pessoaProspect.codigo AND matricula.matricula = ( SELECT m.matricula FROM matricula m WHERE m.aluno = pessoaProspect.codigo AND m.situacao = 'AT' ORDER BY DATA DESC LIMIT 1 ) LEFT JOIN matriculaperiodo ON matriculaperiodo.matricula = matricula.matricula AND matriculaperiodo.codigo = ( SELECT codigo FROM matriculaperiodo mp WHERE mp.matricula = matricula.matricula ORDER BY codigo DESC LIMIT 1 ) LEFT JOIN curso c3 ON ( c3.codigo = matricula.curso ) LEFT JOIN turma ON turma.codigo = matriculaperiodo.turma LEFT JOIN situacaoprospectworkflow ON etapaWorkflow.situacaodefinirprospectfinal = situacaoprospectworkflow.codigo LEFT JOIN situacaoprospectpipeline ON situacaoprospectpipeline.codigo = situacaoprospectworkflow.situacaoprospectpipeline WHERE ( prospects.inativo != TRUE ) AND prospects.nome ILIKE '%' AND prospects.unidadeensino IN ( SELECT DISTINCT unidadeEnsino.codigo FROM unidadeEnsino INNER JOIN usuarioperfilacesso ON usuarioperfilacesso.unidadeensino = unidadeensino.codigo WHERE usuarioperfilacesso.usuario = 73164 ) AND ( ( pessoaResponsavel.codigo = 124331 ) OR ( pessoaResponsavel.codigo IS NULL ) ) ORDER BY interacaoworkflow.datainicio DESC, prospects.nome, pessoaResponsavel.nome LIMIT 60 offset 0 >>Cadê o outro plano sem o LIMIT? http://explain.depesz.com/s/hPu Atenciosamente, Alessandro Lima email [email protected]
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
