select s.id as idsp, ss.nome as estado, l.data as loaddata, s.nrencomenda as nrencomenda, s.nrpedido as nrpedido
from sp s
join loads l on s.idloads = l.id
join spstatus ss on ss.id = s.estado
where !exists
(select idsp from pagamentos where idsp = s.id);