SELECT
    cg.collection_id,
    ccr.platform_id,
    ccr.short_name AS cruise_name,
    cg.spat_coll_id AS cruise_id,
    ccr.fixed_date AS cruise_date,
    cst.short_name AS station_sname,
    cst.long_name AS station_name,
    cg.time_coll_id AS station_id,
    cst.fixed_lon AS station_lon,
    cst.fixed_lat AS station_lat,
    cst.type_id AS station_col_typ
FROM collection_group cg
    JOIN collection ccr ON cg.spat_coll_id = ccr.row_id
    JOIN collection cst ON cg.time_coll_id = cst.row_id
ORDER BY cg.collection_id