ensure_my_table() Limited to One Relationship Per Table

Views generates a bad SQL/JOINS in the following case:
1. Have 2 nodes types "Node_Type_A" and "Node_Type_B"
2. "B" contains an imagefield + title
3. Have 2 nodes of NodeType_B (nidB1 and nidB2)
4. Have 1 node of Node_Type_A (nidA3)
5. Have nodA3 contains 2 references to NodeType_B (to nodes nidB1 and nidB2)
6. In the view, you add 2 imagefields from NodeType_B (from the two related nodes nidB1 and nidB2)

Result:
The displayed result returns twice the information from nidB2 also for nidB3

Exported view:

$view = new view;
$view->name = 'view_couples';
$view->description = 'Listing of couples';
$view->tag = 'couples';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Default Gallery View', 'default');
$handler->override_option('relationships', array(
  'field_partner_m_nid' => array(
    'label' => 'Partner',
    'required' => 1,
    'delta' => -1,
    'id' => 'field_partner_m_nid',
    'table' => 'node_data_field_partner_m',
    'field' => 'field_partner_m_nid',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'field_partner_f_nid' => array(
    'label' => 'Partner(lady)',
    'required' => 1,
    'delta' => -1,
    'id' => 'field_partner_f_nid',
    'table' => 'node_data_field_partner_f',
    'field' => 'field_partner_f_nid',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('fields', array(
  'field_teaser_img_fid' => array(
    'label' => '',
    'link_to_node' => 0,
    'label_type' => 'none',
    'format' => 'Portrait_linked',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_teaser_img_fid',
    'table' => 'node_data_field_teaser_img',
    'field' => 'field_teaser_img_fid',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'field_partner_m_nid',
  ),
  'field_teaser_img_fid_1' => array(
    'label' => '',
    'link_to_node' => 0,
    'label_type' => 'none',
    'format' => 'Portrait_linked',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_teaser_img_fid_1',
    'table' => 'node_data_field_teaser_img',
    'field' => 'field_teaser_img_fid',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'field_partner_f_nid',
  ),
  'title' => array(
    'label' => 'Title',
    'link_to_node' => 1,
    'exclude' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'field_date_start_value2' => array(
    'label' => '',
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'short',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_date_start_value2',
    'table' => 'node_data_field_date_start',
    'field' => 'field_date_start_value2',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'field_category_stt_value' => array(
    'label' => 'STT',
    'link_to_node' => 0,
    'label_type' => 'custom',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_category_stt_value',
    'table' => 'node_data_field_category_stt',
    'field' => 'field_category_stt_value',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'field_category_lat_value' => array(
    'label' => 'LAT',
    'link_to_node' => 0,
    'label_type' => 'custom',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_category_lat_value',
    'table' => 'node_data_field_category_lat',
    'field' => 'field_category_lat_value',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'field_date_start_value' => array(
    'order' => 'ASC',
    'id' => 'field_date_start_value',
    'table' => 'node_data_field_date_start',
    'field' => 'field_date_start_value',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('filters', array(
  'status' => array(
    'operator' => '=',
    'value' => 1,
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'status',
    'table' => 'node',
    'field' => 'status',
    'relationship' => 'none',
  ),
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'cck_couple' => 'cck_couple',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('title', 'Galéria párov');
$handler->override_option('header_format', '1');
$handler->override_option('header_empty', 0);
$handler->override_option('empty', 'No items have been found matching your criteria');
$handler->override_option('empty_format', '1');
$handler->override_option('use_ajax', TRUE);
$handler->override_option('items_per_page', 16);
$handler->override_option('use_pager', 'mini');
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 1,
  'sticky' => 0,
  'order' => 'asc',
  'columns' => array(
    'field_teaser_img_fid' => 'field_teaser_img_fid',
    'field_teaser_img_fid_1' => 'field_teaser_img_fid_1',
    'title' => 'title',
    'field_date_start_value2' => 'title',
    'field_category_stt_value' => 'field_category_stt_value',
    'field_category_lat_value' => 'field_category_lat_value',
  ),
  'info' => array(
    'field_teaser_img_fid' => array(
      'separator' => '',
    ),
    'field_teaser_img_fid_1' => array(
      'separator' => '',
    ),
    'title' => array(
      'sortable' => 0,
      'separator' => '<br/>',
    ),
    'field_date_start_value2' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_category_stt_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'field_category_lat_value' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => '-1',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'gallery');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'weight' => 0,
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'weight' => 0,
));

SQL Select generated by Views:

SELECT node.nid AS nid,
   node_data_field_teaser_img.field_teaser_img_fid AS node_data_field_teaser_img_field_teaser_img_fid,
   node_data_field_teaser_img.field_teaser_img_list AS node_data_field_teaser_img_field_teaser_img_list,
   node_data_field_teaser_img.field_teaser_img_data AS node_data_field_teaser_img_field_teaser_img_data,
   node_data_field_teaser_img.nid AS node_data_field_teaser_img_nid,
   node_node_data_field_partner_m.type AS node_node_data_field_partner_m_type,
   node_node_data_field_partner_f.type AS node_node_data_field_partner_f_type,
   node.title AS node_title,
   node_data_field_date_start.field_date_start_value AS node_data_field_date_start_field_date_start_value,
   node_data_field_date_start.field_date_start_value2 AS node_data_field_date_start_field_date_start_value2,
   node_data_field_date_start.nid AS node_data_field_date_start_nid,
   node.type AS node_type,
   node_data_field_category_stt.field_category_stt_value AS node_data_field_category_stt_field_category_stt_value,
   node_data_field_category_stt.field_category_stt_format AS node_data_field_category_stt_field_category_stt_format,
   node_data_field_category_stt.nid AS node_data_field_category_stt_nid,
   node_data_field_category_stt.field_category_lat_value AS node_data_field_category_stt_field_category_lat_value,
   node_data_field_category_stt.field_category_lat_format AS node_data_field_category_stt_field_category_lat_format
 FROM drupal6_node node 
 LEFT JOIN drupal6_content_type_cck_couple node_data_field_partner_m ON node.vid = node_data_field_partner_m.vid
 INNER JOIN drupal6_node node_node_data_field_partner_m ON node_data_field_partner_m.field_partner_m_nid = node_node_data_field_partner_m.nid
 LEFT JOIN drupal6_content_type_cck_couple node_data_field_partner_f ON node.vid = node_data_field_partner_f.vid
 INNER JOIN drupal6_node node_node_data_field_partner_f ON node_data_field_partner_f.field_partner_f_nid = node_node_data_field_partner_f.nid
 LEFT JOIN drupal6_content_type_cck_std_node node_data_field_teaser_img ON node_node_data_field_partner_f.vid = node_data_field_teaser_img.vid
 LEFT JOIN drupal6_content_field_date_start node_data_field_date_start ON node.vid = node_data_field_date_start.vid
 LEFT JOIN drupal6_content_type_cck_couple node_data_field_category_stt ON node.vid = node_data_field_category_stt.vid
 WHERE (node.status <> 0) AND (node.type in ('cck_couple'))
   ORDER BY node_data_field_date_start_field_date_start_value ASC