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.