omni-create-view

CREATE VIEW v_satellitecurrentlocation AS (
  SELECT
    *
  FROM
    satellitelocations t1
    INNER JOIN (
      SELECT
        MAX(postimestamp) as postimestamp,
        satid
      FROM
        satellitelocations
      GROUP BY
        2
    ) t2 ON t1.postimestamp = t2.postimestamp
    AND t1.satid = t2.satid
);