Михаил Ушенин

SELECT r.id
FROM countersRecords r
WHERE r.id = (
    SELECT MAX(id)
    FROM countersRecords latest
    WHERE latest.counter_id = r.counter_id
) t

SELECT
    product.*,
    category.name
FROM product p
JOIN category c
    ON c.id = p.category_id