Issues with datebase returning multiples of the same record

Another day and another project.
Issues I am having is the database is returning multiples of the same product.
I have selected ‘DISTINCT’ but for some reason this is just not working.
I’ve tried multiple things but it just is still happening .

Any guru help would be appreciated.

This is the page