Hi Rudo,
You can use a advance query to get only first and last record ..see below .
This is just an example you need to tweak as per your requirement.
(SELECT <some columns>
FROM mytable
<maybe some joins here>
WHERE <various conditions>
ORDER BY date DESC
LIMIT 1)
UNION ALL
(SELECT <some columns>
FROM mytable
<maybe some joins here>
WHERE <various conditions>
ORDER BY date ASC
LIMIT 1)
Please try something like this and let me know if it helps.
Regards,
-PJ-