Excerpts from OgiSer Tamade's message of mié jul 14 17:25:53 -0400 2010: > SELECT S.phoneid, S.sequenceid > FROM d_campaigns C, d_phonestatus S > WHERE C.campaignid IN (17,16,15,14,13) AND C.campaignid=S.campaignid AND > S.sequenceid=( > > SELECT MAX(S2.sequenceid) FROM d_phonestatus S2 WHERE > S2.phoneid=S.phoneid ) > > AND (S.assignedto IS NULL OR (S.assignedto<>'A436MA' AND > (S.status='rejected' OR > S.status='error'))) > AND (S.callbackdate <= NOW() OR S.callbackdate IS > NULL) > ORDER BY S.callbackdate, C.priority DESC, S.phoneid LIMIT 1
Esta no es la misma consulta de la que mostraste el EXPLAIN. - Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda@postgresql.org) Para cambiar tu suscripci�n: http://www.postgresql.org/mailpref/pgsql-es-ayuda
