gps current metadata - materialized view

gistfile1.txt

connection.execute <<-SQL
  CREATE MATERIALIZED VIEW last_current_metadata AS
    SELECT id, hour_start, distance, last_time, max_speed, all_data_records, current_data_record, gl.gps_logger_metadata_item_id
      FROM gps_logger_current_data_items gl
        INNER JOIN (
          SELECT gps_logger_metadata_item_id, MAX(hour_start) AS max_hour_start
          FROM gps_logger_current_data_items
          GROUP BY gps_logger_metadata_item_id
      ) ingl ON ingl.gps_logger_metadata_item_id = gl.gps_logger_metadata_item_id AND ingl.max_hour_start = gl.hour_start
  SQL