[online]

evo jos jedna varijanta - sada za slucaj da nema verzije koja se ponavlja na vise datuma, dok jos nisam poceo da radim:

SELECT p.*, v.*
  FROM (
        SELECT v.ver_prod_id, MAX(v.ver_date) version_dt
          FROM Versions v
         INNER JOIN Products p ON v.ver_prod_id = p.prod_id
         WHERE p.prod_cat    = 1
           AND p.prod_active = 1
           AND v.ver_active  = 1
         GROUP BY v.ver_prod_id
        ) m
INNER JOIN Versions v ON v.ver_date = m.version_dt
INNER JOIN Products p ON p.prod_id  = v.ver_prod_id