Re: how to optimize this query

[Minski Browar]

Please try this statement instead and let us know the change

SELECT f.id, f.species_name, f.date
FROM lister_importedsighting as f
WHERE user_id=%s
and NOT EXISTS ( SELECT x.id
FROM lister_importedsighting as x
WHERE f.user_id = x.user_id
and f.species_name = x.species_name
and f.date > x.date
)