SELECT
    DISTINCT vmsd.obs_type_name,
    vmsd.uom_type_disp AS units,
    st.description AS sensor_descr,
    s.s_order,
    mo.m_type_id,
    s.row_id AS sensor_id,
    gc.coll_id
FROM multi_obs mo,
    geo_cast gc,
    sensor s,
    sensor_type st,
    m_type mt,
    v_m_scalar_dd vmsd
WHERE mo.collection_id = gc.coll_id
        AND mo.sensor_id = s.row_id
        AND s.type_id = st.row_id
        AND s.m_type_id = mt.row_id
        AND mt.m_scalar_type_id = vmsd.row_id
ORDER BY vmsd.obs_type_name,
    st.description,
    s.s_order,
    vmsd.uom_type_disp,
    mo.m_type_id,
    s.row_id,
    gc.coll_id