marker_to_map

SELECT m.marker_id,

    me.protocol,

    ml.location_id,

    linkage_group.lg_name,

    linkage_group.lg_order,

    ml."position",

    ml.confidence_id,

    ml.subscript,

    ml.map_version_id,

    map.map_id,

    map.parent_1,

    map.parent_2,

    map_version.current_version

   FROM (((((sgn.marker m

     LEFT JOIN sgn.marker_experiment me USING (marker_id))

     LEFT JOIN sgn.marker_location ml USING (location_id))

     LEFT JOIN sgn.map_version USING (map_version_id))

     LEFT JOIN sgn.map USING (map_id))

     LEFT JOIN sgn.linkage_group USING (lg_id))

  WHERE (map_version.current_version = true);