SELECT
    vcge.cruise_name,
    vmsd.obs_type_name,
    vmsd.uom_type_disp AS units,
    mo.m_type_id,
    mo.sensor_id,
    tr.short_name AS transect_name,
    tr.transect_sta_order,
    tr.transect_dist,
    vcge.station_id,
    vcge.station_name,
    vcge.collection_id,
    co.fixed_date,
    co.qualifier,
    mo.m_z,
    mo.qc_level,
    mo.m_value
FROM multi_obs mo,
    m_type mt,
    v_m_scalar_dd vmsd,
    v_collgroup_expand vcge,
    collection co,
    transect tr
WHERE mo.m_type_id = mt.row_id
        AND mt.m_scalar_type_id = vmsd.row_id
        AND mo.collection_id = vcge.collection_id
        AND vcge.collection_id = co.row_id
        AND vcge.station_id = tr.station_id
        AND vcge.platform_id = 5
        AND vcge.station_id <> 54
ORDER BY vmsd.obs_type_name,
    tr.transect_sta_order,
    co.fixed_date,
    mo.m_z DESC