Sandbox

SELECT 
  vi_banners.banner_id, 
  vi_banners.status, 
  vi_banner_descriptions.banner, 
  vi_banners.type, 
  vi_banners.target, 
  vi_banners.localization, 
  vi_banners.timestamp, 
  vi_banner_descriptions.description, 
  vi_banner_descriptions.url, 
  vi_banner_images.banner_image_id, 
  vi_banners.company_id as company_id, 
  vi_banners.group_id, 
  vi_abt__ut2_banner_images.abt__ut2_banner_image_id, 
  vi_banners.abt__ut2_usergroup_ids, 
  vi_banners.abt__ut2_use_avail_period, 
  vi_banners.abt__ut2_avail_from, 
  vi_banners.abt__ut2_avail_till, 
  vi_banners.abt__ut2_button_use, 
  vi_banners.abt__ut2_button_style, 
  vi_banners.abt__ut2_button_text_color, 
  vi_banners.abt__ut2_button_text_color_use, 
  vi_banners.abt__ut2_button_color, 
  vi_banners.abt__ut2_button_color_use, 
  vi_banners.abt__ut2_title_color, 
  vi_banners.abt__ut2_title_color_use, 
  vi_banners.abt__ut2_title_font_size, 
  vi_banners.abt__ut2_title_font_weight, 
  vi_banners.abt__ut2_title_tag, 
  vi_banners.abt__ut2_background_image_size, 
  vi_banners.abt__ut2_image_v_position, 
  vi_banners.abt__ut2_image_h_position, 
  vi_banners.abt__ut2_background_v_position, 
  vi_banners.abt__ut2_background_h_position, 
  vi_banners.abt__ut2_title_shadow, 
  vi_banners.abt__ut2_description_font_size, 
  vi_banners.abt__ut2_description_color, 
  vi_banners.abt__ut2_description_color_use, 
  vi_banners.abt__ut2_description_bg_color, 
  vi_banners.abt__ut2_description_bg_color_use, 
  vi_banners.abt__ut2_object, 
  vi_banners.abt__ut2_background_color, 
  vi_banners.abt__ut2_background_color_use, 
  vi_banners.abt__ut2_class, 
  vi_banners.abt__ut2_color_scheme, 
  vi_banners.abt__ut2_content_valign, 
  vi_banners.abt__ut2_content_align, 
  vi_banners.abt__ut2_content_full_width, 
  vi_banners.abt__ut2_content_bg, 
  vi_banners.abt__ut2_content_bg_position, 
  vi_banners.abt__ut2_content_bg_align, 
  vi_banners.abt__ut2_content_bg_opacity, 
  vi_banners.abt__ut2_content_bg_color, 
  vi_banners.abt__ut2_content_bg_color_use, 
  vi_banners.abt__ut2_padding, 
  vi_banners.abt__ut2_how_to_open, 
  vi_banners.abt__ut2_data_type, 
  vi_banners.abt__ut2_youtube_use, 
  vi_banners.abt__ut2_youtube_autoplay, 
  vi_banners.abt__ut2_youtube_hide_controls, 
  vi_banners.abt__ut2_background_type, 
  vi_banner_descriptions.abt__ut2_background_mp4_video, 
  vi_banner_descriptions.abt__ut2_button_text, 
  vi_banner_descriptions.abt__ut2_title, 
  vi_banner_descriptions.abt__ut2_url, 
  vi_banner_descriptions.abt__ut2_description, 
  vi_banner_descriptions.abt__ut2_youtube_id, 
  vi_banners.abt__ut2_products_template, 
  vi_banners.abt__ut2_products_links_thumb_columns, 
  vi_banners.abt__ut2_products_links_thumb_rows, 
  vi_banners.abt__ut2_products_small_items_columns, 
  vi_banners.abt__ut2_products_small_items_rows, 
  vi_banners.abt__ut2_products_grid_columns, 
  vi_banners.abt__ut2_products_list, 
  vi_banners.abt__ut2_tablet_use, 
  vi_banners.abt__ut2_tablet_content_valign, 
  vi_banners.abt__ut2_tablet_content_valign_use_own, 
  vi_banners.abt__ut2_tablet_content_align, 
  vi_banners.abt__ut2_tablet_content_align_use_own, 
  vi_banners.abt__ut2_tablet_padding, 
  vi_banners.abt__ut2_tablet_padding_use_own, 
  vi_banners.abt__ut2_tablet_content_full_width, 
  vi_banners.abt__ut2_tablet_content_full_width_use_own, 
  vi_banner_descriptions.abt__ut2_tablet_title, 
  vi_banner_descriptions.abt__ut2_tablet_title_use_own, 
  vi_banners.abt__ut2_tablet_title_font_size, 
  vi_banners.abt__ut2_tablet_title_font_size_use_own, 
  vi_banners.abt__ut2_tablet_title_shadow, 
  vi_banners.abt__ut2_tablet_title_shadow_use_own, 
  vi_banner_descriptions.abt__ut2_tablet_description, 
  vi_banner_descriptions.abt__ut2_tablet_description_use_own, 
  vi_banners.abt__ut2_tablet_description_font_size, 
  vi_banners.abt__ut2_tablet_description_font_size_use_own, 
  vi_banners.abt__ut2_tablet_main_image_use_own, 
  vi_banners.abt__ut2_tablet_background_type, 
  vi_banners.abt__ut2_tablet_background_type_use_own, 
  vi_banner_descriptions.abt__ut2_tablet_background_mp4_video, 
  vi_banner_descriptions.abt__ut2_tablet_background_mp4_video_use_own, 
  vi_banners.abt__ut2_tablet_background_image_use_own, 
  vi_banners.abt__ut2_tablet_background_image_size, 
  vi_banners.abt__ut2_tablet_background_image_size_use_own, 
  vi_banners.abt__ut2_tablet_image_v_position, 
  vi_banners.abt__ut2_tablet_image_v_position_use_own, 
  vi_banners.abt__ut2_tablet_image_h_position, 
  vi_banners.abt__ut2_tablet_image_h_position_use_own, 
  vi_banners.abt__ut2_tablet_background_v_position, 
  vi_banners.abt__ut2_tablet_background_v_position_use_own, 
  vi_banners.abt__ut2_tablet_background_h_position, 
  vi_banners.abt__ut2_tablet_background_h_position_use_own, 
  vi_banners.abt__ut2_tablet_button_use, 
  vi_banners.abt__ut2_tablet_button_use_use_own, 
  vi_banner_descriptions.abt__ut2_tablet_button_text, 
  vi_banner_descriptions.abt__ut2_tablet_button_text_use_own, 
  vi_banners.abt__ut2_tablet_content_bg, 
  vi_banners.abt__ut2_tablet_content_bg_use_own, 
  vi_banners.abt__ut2_tablet_content_bg_position, 
  vi_banners.abt__ut2_tablet_content_bg_position_use_own, 
  vi_banners.abt__ut2_tablet_content_bg_align, 
  vi_banners.abt__ut2_tablet_content_bg_align_use_own, 
  vi_banners.abt__ut2_tablet_content_bg_opacity, 
  vi_banners.abt__ut2_tablet_content_bg_opacity_use_own, 
  vi_banners.abt__ut2_tablet_content_bg_color, 
  vi_banners.abt__ut2_tablet_content_bg_color_use_own, 
  vi_banners.abt__ut2_tablet_content_bg_color_use, 
  vi_banners.abt__ut2_tablet_content_bg_color_use_use_own, 
  vi_banners.abt__ut2_tablet_button_text_color, 
  vi_banners.abt__ut2_tablet_button_text_color_use_own, 
  vi_banners.abt__ut2_tablet_button_text_color_use, 
  vi_banners.abt__ut2_tablet_button_text_color_use_use_own, 
  vi_banners.abt__ut2_tablet_button_color, 
  vi_banners.abt__ut2_tablet_button_color_use_own, 
  vi_banners.abt__ut2_tablet_button_color_use, 
  vi_banners.abt__ut2_tablet_button_color_use_use_own, 
  vi_banners.abt__ut2_tablet_button_style, 
  vi_banners.abt__ut2_tablet_button_style_use_own, 
  vi_banners.abt__ut2_tablet_title_color, 
  vi_banners.abt__ut2_tablet_title_color_use_own, 
  vi_banners.abt__ut2_tablet_title_color_use, 
  vi_banners.abt__ut2_tablet_title_color_use_use_own, 
  vi_banners.abt__ut2_tablet_title_font_weight, 
  vi_banners.abt__ut2_tablet_title_font_weight_use_own, 
  vi_banners.abt__ut2_tablet_title_tag, 
  vi_banners.abt__ut2_tablet_title_tag_use_own, 
  vi_banners.abt__ut2_tablet_description_color, 
  vi_banners.abt__ut2_tablet_description_color_use_own, 
  vi_banners.abt__ut2_tablet_description_color_use, 
  vi_banners.abt__ut2_tablet_description_color_use_use_own, 
  vi_banners.abt__ut2_tablet_description_bg_color, 
  vi_banners.abt__ut2_tablet_description_bg_color_use_own, 
  vi_banners.abt__ut2_tablet_description_bg_color_use, 
  vi_banners.abt__ut2_tablet_description_bg_color_use_use_own, 
  vi_banners.abt__ut2_tablet_object, 
  vi_banners.abt__ut2_tablet_object_use_own, 
  vi_banners.abt__ut2_tablet_background_color, 
  vi_banners.abt__ut2_tablet_background_color_use_own, 
  vi_banners.abt__ut2_tablet_background_color_use, 
  vi_banners.abt__ut2_tablet_background_color_use_use_own, 
  vi_banners.abt__ut2_tablet_class, 
  vi_banners.abt__ut2_tablet_class_use_own, 
  vi_banners.abt__ut2_tablet_color_scheme, 
  vi_banners.abt__ut2_tablet_color_scheme_use_own, 
  vi_banners.abt__ut2_tablet_how_to_open, 
  vi_banners.abt__ut2_tablet_how_to_open_use_own, 
  vi_banners.abt__ut2_tablet_data_type, 
  vi_banners.abt__ut2_tablet_data_type_use_own, 
  vi_banners.abt__ut2_tablet_youtube_use, 
  vi_banners.abt__ut2_tablet_youtube_use_use_own, 
  vi_banners.abt__ut2_tablet_youtube_autoplay, 
  vi_banners.abt__ut2_tablet_youtube_autoplay_use_own, 
  vi_banners.abt__ut2_tablet_youtube_hide_controls, 
  vi_banners.abt__ut2_tablet_youtube_hide_controls_use_own, 
  vi_banner_descriptions.abt__ut2_tablet_youtube_id, 
  vi_banner_descriptions.abt__ut2_tablet_youtube_id_use_own, 
  vi_banners.abt__ut2_tablet_products_template, 
  vi_banners.abt__ut2_tablet_products_template_use_own, 
  vi_banners.abt__ut2_tablet_products_links_thumb_columns, 
  vi_banners.abt__ut2_tablet_products_links_thumb_columns_use_own, 
  vi_banners.abt__ut2_tablet_products_links_thumb_rows, 
  vi_banners.abt__ut2_tablet_products_links_thumb_rows_use_own, 
  vi_banners.abt__ut2_tablet_products_small_items_columns, 
  vi_banners.abt__ut2_tablet_products_small_items_columns_use_own, 
  vi_banners.abt__ut2_tablet_products_small_items_rows, 
  vi_banners.abt__ut2_tablet_products_small_items_rows_use_own, 
  vi_banners.abt__ut2_tablet_products_grid_columns, 
  vi_banners.abt__ut2_tablet_products_grid_columns_use_own, 
  vi_banners.abt__ut2_tablet_products_list, 
  vi_banners.abt__ut2_tablet_products_list_use_own, 
  vi_banners.abt__ut2_mobile_use, 
  vi_banners.abt__ut2_mobile_color_scheme, 
  vi_banners.abt__ut2_mobile_color_scheme_use_own, 
  vi_banners.abt__ut2_mobile_content_valign, 
  vi_banners.abt__ut2_mobile_content_valign_use_own, 
  vi_banners.abt__ut2_mobile_content_align, 
  vi_banners.abt__ut2_mobile_content_align_use_own, 
  vi_banners.abt__ut2_mobile_padding, 
  vi_banners.abt__ut2_mobile_padding_use_own, 
  vi_banners.abt__ut2_mobile_content_full_width, 
  vi_banners.abt__ut2_mobile_content_full_width_use_own, 
  vi_banner_descriptions.abt__ut2_mobile_title, 
  vi_banner_descriptions.abt__ut2_mobile_title_use_own, 
  vi_banners.abt__ut2_mobile_title_font_size, 
  vi_banners.abt__ut2_mobile_title_font_size_use_own, 
  vi_banners.abt__ut2_mobile_title_color_use, 
  vi_banners.abt__ut2_mobile_title_color_use_use_own, 
  vi_banners.abt__ut2_mobile_title_color, 
  vi_banners.abt__ut2_mobile_title_color_use_own, 
  vi_banners.abt__ut2_mobile_title_font_weight, 
  vi_banners.abt__ut2_mobile_title_font_weight_use_own, 
  vi_banners.abt__ut2_mobile_title_tag, 
  vi_banners.abt__ut2_mobile_title_tag_use_own, 
  vi_banners.abt__ut2_mobile_title_shadow, 
  vi_banners.abt__ut2_mobile_title_shadow_use_own, 
  vi_banner_descriptions.abt__ut2_mobile_description, 
  vi_banner_descriptions.abt__ut2_mobile_description_use_own, 
  vi_banners.abt__ut2_mobile_description_font_size, 
  vi_banners.abt__ut2_mobile_description_font_size_use_own, 
  vi_banners.abt__ut2_mobile_description_color_use, 
  vi_banners.abt__ut2_mobile_description_color_use_use_own, 
  vi_banners.abt__ut2_mobile_description_color, 
  vi_banners.abt__ut2_mobile_description_color_use_own, 
  vi_banners.abt__ut2_mobile_description_bg_color_use, 
  vi_banners.abt__ut2_mobile_description_bg_color_use_use_own, 
  vi_banners.abt__ut2_mobile_description_bg_color, 
  vi_banners.abt__ut2_mobile_description_bg_color_use_own, 
  vi_banners.abt__ut2_mobile_object, 
  vi_banners.abt__ut2_mobile_object_use_own, 
  vi_banners.abt__ut2_mobile_data_type, 
  vi_banners.abt__ut2_mobile_data_type_use_own, 
  vi_banners.abt__ut2_mobile_youtube_use, 
  vi_banners.abt__ut2_mobile_youtube_use_use_own, 
  vi_banners.abt__ut2_mobile_youtube_autoplay, 
  vi_banners.abt__ut2_mobile_youtube_autoplay_use_own, 
  vi_banners.abt__ut2_mobile_youtube_hide_controls, 
  vi_banners.abt__ut2_mobile_youtube_hide_controls_use_own, 
  vi_banner_descriptions.abt__ut2_mobile_youtube_id, 
  vi_banner_descriptions.abt__ut2_mobile_youtube_id_use_own, 
  vi_banners.abt__ut2_mobile_products_template, 
  vi_banners.abt__ut2_mobile_products_template_use_own, 
  vi_banners.abt__ut2_mobile_products_links_thumb_columns, 
  vi_banners.abt__ut2_mobile_products_links_thumb_columns_use_own, 
  vi_banners.abt__ut2_mobile_products_links_thumb_rows, 
  vi_banners.abt__ut2_mobile_products_links_thumb_rows_use_own, 
  vi_banners.abt__ut2_mobile_products_small_items_columns, 
  vi_banners.abt__ut2_mobile_products_small_items_columns_use_own, 
  vi_banners.abt__ut2_mobile_products_small_items_rows, 
  vi_banners.abt__ut2_mobile_products_small_items_rows_use_own, 
  vi_banners.abt__ut2_mobile_products_grid_columns, 
  vi_banners.abt__ut2_mobile_products_grid_columns_use_own, 
  vi_banners.abt__ut2_mobile_products_list, 
  vi_banners.abt__ut2_mobile_products_list_use_own, 
  vi_banners.abt__ut2_mobile_main_image_use_own, 
  vi_banners.abt__ut2_mobile_image_v_position, 
  vi_banners.abt__ut2_mobile_image_v_position_use_own, 
  vi_banners.abt__ut2_mobile_image_h_position, 
  vi_banners.abt__ut2_mobile_image_h_position_use_own, 
  vi_banners.abt__ut2_mobile_background_type, 
  vi_banners.abt__ut2_mobile_background_type_use_own, 
  vi_banners.abt__ut2_mobile_background_image_use_own, 
  vi_banner_descriptions.abt__ut2_mobile_background_mp4_video, 
  vi_banner_descriptions.abt__ut2_mobile_background_mp4_video_use_own, 
  vi_banners.abt__ut2_mobile_background_image_size, 
  vi_banners.abt__ut2_mobile_background_image_size_use_own, 
  vi_banners.abt__ut2_mobile_background_color_use, 
  vi_banners.abt__ut2_mobile_background_color_use_use_own, 
  vi_banners.abt__ut2_mobile_background_color, 
  vi_banners.abt__ut2_mobile_background_color_use_own, 
  vi_banners.abt__ut2_mobile_background_v_position, 
  vi_banners.abt__ut2_mobile_background_v_position_use_own, 
  vi_banners.abt__ut2_mobile_background_h_position, 
  vi_banners.abt__ut2_mobile_background_h_position_use_own, 
  vi_banners.abt__ut2_mobile_content_bg, 
  vi_banners.abt__ut2_mobile_content_bg_use_own, 
  vi_banners.abt__ut2_mobile_content_bg_position, 
  vi_banners.abt__ut2_mobile_content_bg_position_use_own, 
  vi_banners.abt__ut2_mobile_content_bg_align, 
  vi_banners.abt__ut2_mobile_content_bg_align_use_own, 
  vi_banners.abt__ut2_mobile_content_bg_opacity, 
  vi_banners.abt__ut2_mobile_content_bg_opacity_use_own, 
  vi_banners.abt__ut2_mobile_content_bg_color_use, 
  vi_banners.abt__ut2_mobile_content_bg_color_use_use_own, 
  vi_banners.abt__ut2_mobile_content_bg_color, 
  vi_banners.abt__ut2_mobile_content_bg_color_use_own, 
  vi_banners.abt__ut2_mobile_button_use, 
  vi_banners.abt__ut2_mobile_button_use_use_own, 
  vi_banner_descriptions.abt__ut2_mobile_button_text, 
  vi_banner_descriptions.abt__ut2_mobile_button_text_use_own, 
  vi_banners.abt__ut2_mobile_button_style, 
  vi_banners.abt__ut2_mobile_button_style_use_own, 
  vi_banners.abt__ut2_mobile_button_text_color_use, 
  vi_banners.abt__ut2_mobile_button_text_color_use_use_own, 
  vi_banners.abt__ut2_mobile_button_text_color, 
  vi_banners.abt__ut2_mobile_button_text_color_use_own, 
  vi_banners.abt__ut2_mobile_button_color, 
  vi_banners.abt__ut2_mobile_button_color_use_own, 
  vi_banners.abt__ut2_mobile_button_color_use, 
  vi_banners.abt__ut2_mobile_button_color_use_use_own, 
  vi_banners.abt__ut2_mobile_class, 
  vi_banners.abt__ut2_mobile_class_use_own, 
  vi_banners.abt__ut2_mobile_how_to_open, 
  vi_banners.abt__ut2_mobile_how_to_open_use_own 
FROM 
  vi_banners 
  LEFT JOIN vi_banner_descriptions ON vi_banner_descriptions.banner_id = vi_banners.banner_id 
  AND vi_banner_descriptions.lang_code = 'es' 
  LEFT JOIN vi_banner_images ON vi_banner_images.banner_id = vi_banners.banner_id 
  AND vi_banner_images.lang_code = 'es' 
  LEFT JOIN vi_abt__ut2_banner_images ON vi_abt__ut2_banner_images.banner_id = vi_banners.banner_id 
  AND vi_abt__ut2_banner_images.lang_code = 'es' 
WHERE 
  vi_banners.banner_id = 42 
  AND vi_banners.status IN ('A', 'H')

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "vi_banners",
          "access_type": "const",
          "possible_keys": ["PRIMARY", "status"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["banner_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "vi_banner_descriptions",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["banner_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "vi_banner_images",
          "access_type": "const",
          "possible_keys": ["banner"],
          "key": "banner",
          "key_length": "9",
          "used_key_parts": ["banner_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 0,
          "filtered": 0,
          "unique_row_not_found": true
        }
      },
      {
        "table": {
          "table_name": "vi_abt__ut2_banner_images",
          "access_type": "const",
          "possible_keys": ["banner_lang_code"],
          "key": "banner_lang_code",
          "key_length": "9",
          "used_key_parts": ["banner_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

banner_id	status	banner	type	target	localization	timestamp	description	url	banner_image_id	company_id	group_id	abt__ut2_banner_image_id	abt__ut2_usergroup_ids	abt__ut2_use_avail_period	abt__ut2_avail_from	abt__ut2_avail_till	abt__ut2_button_use	abt__ut2_button_style	abt__ut2_button_text_color	abt__ut2_button_text_color_use	abt__ut2_button_color	abt__ut2_button_color_use	abt__ut2_title_color	abt__ut2_title_color_use	abt__ut2_title_font_size	abt__ut2_title_font_weight	abt__ut2_title_tag	abt__ut2_background_image_size	abt__ut2_image_v_position	abt__ut2_image_h_position	abt__ut2_background_v_position	abt__ut2_background_h_position	abt__ut2_title_shadow	abt__ut2_description_font_size	abt__ut2_description_color	abt__ut2_description_color_use	abt__ut2_description_bg_color	abt__ut2_description_bg_color_use	abt__ut2_object	abt__ut2_background_color	abt__ut2_background_color_use	abt__ut2_class	abt__ut2_color_scheme	abt__ut2_content_valign	abt__ut2_content_align	abt__ut2_content_full_width	abt__ut2_content_bg	abt__ut2_content_bg_position	abt__ut2_content_bg_align	abt__ut2_content_bg_opacity	abt__ut2_content_bg_color	abt__ut2_content_bg_color_use	abt__ut2_padding	abt__ut2_how_to_open	abt__ut2_data_type	abt__ut2_youtube_use	abt__ut2_youtube_autoplay	abt__ut2_youtube_hide_controls	abt__ut2_background_type	abt__ut2_background_mp4_video	abt__ut2_button_text	abt__ut2_title	abt__ut2_url	abt__ut2_description	abt__ut2_youtube_id	abt__ut2_products_template	abt__ut2_products_links_thumb_columns	abt__ut2_products_links_thumb_rows	abt__ut2_products_small_items_columns	abt__ut2_products_small_items_rows	abt__ut2_products_grid_columns	abt__ut2_products_list	abt__ut2_tablet_use	abt__ut2_tablet_content_valign	abt__ut2_tablet_content_valign_use_own	abt__ut2_tablet_content_align	abt__ut2_tablet_content_align_use_own	abt__ut2_tablet_padding	abt__ut2_tablet_padding_use_own	abt__ut2_tablet_content_full_width	abt__ut2_tablet_content_full_width_use_own	abt__ut2_tablet_title	abt__ut2_tablet_title_use_own	abt__ut2_tablet_title_font_size	abt__ut2_tablet_title_font_size_use_own	abt__ut2_tablet_title_shadow	abt__ut2_tablet_title_shadow_use_own	abt__ut2_tablet_description	abt__ut2_tablet_description_use_own	abt__ut2_tablet_description_font_size	abt__ut2_tablet_description_font_size_use_own	abt__ut2_tablet_main_image_use_own	abt__ut2_tablet_background_type	abt__ut2_tablet_background_type_use_own	abt__ut2_tablet_background_mp4_video	abt__ut2_tablet_background_mp4_video_use_own	abt__ut2_tablet_background_image_use_own	abt__ut2_tablet_background_image_size	abt__ut2_tablet_background_image_size_use_own	abt__ut2_tablet_image_v_position	abt__ut2_tablet_image_v_position_use_own	abt__ut2_tablet_image_h_position	abt__ut2_tablet_image_h_position_use_own	abt__ut2_tablet_background_v_position	abt__ut2_tablet_background_v_position_use_own	abt__ut2_tablet_background_h_position	abt__ut2_tablet_background_h_position_use_own	abt__ut2_tablet_button_use	abt__ut2_tablet_button_use_use_own	abt__ut2_tablet_button_text	abt__ut2_tablet_button_text_use_own	abt__ut2_tablet_content_bg	abt__ut2_tablet_content_bg_use_own	abt__ut2_tablet_content_bg_position	abt__ut2_tablet_content_bg_position_use_own	abt__ut2_tablet_content_bg_align	abt__ut2_tablet_content_bg_align_use_own	abt__ut2_tablet_content_bg_opacity	abt__ut2_tablet_content_bg_opacity_use_own	abt__ut2_tablet_content_bg_color	abt__ut2_tablet_content_bg_color_use_own	abt__ut2_tablet_content_bg_color_use	abt__ut2_tablet_content_bg_color_use_use_own	abt__ut2_tablet_button_text_color	abt__ut2_tablet_button_text_color_use_own	abt__ut2_tablet_button_text_color_use	abt__ut2_tablet_button_text_color_use_use_own	abt__ut2_tablet_button_color	abt__ut2_tablet_button_color_use_own	abt__ut2_tablet_button_color_use	abt__ut2_tablet_button_color_use_use_own	abt__ut2_tablet_button_style	abt__ut2_tablet_button_style_use_own	abt__ut2_tablet_title_color	abt__ut2_tablet_title_color_use_own	abt__ut2_tablet_title_color_use	abt__ut2_tablet_title_color_use_use_own	abt__ut2_tablet_title_font_weight	abt__ut2_tablet_title_font_weight_use_own	abt__ut2_tablet_title_tag	abt__ut2_tablet_title_tag_use_own	abt__ut2_tablet_description_color	abt__ut2_tablet_description_color_use_own	abt__ut2_tablet_description_color_use	abt__ut2_tablet_description_color_use_use_own	abt__ut2_tablet_description_bg_color	abt__ut2_tablet_description_bg_color_use_own	abt__ut2_tablet_description_bg_color_use	abt__ut2_tablet_description_bg_color_use_use_own	abt__ut2_tablet_object	abt__ut2_tablet_object_use_own	abt__ut2_tablet_background_color	abt__ut2_tablet_background_color_use_own	abt__ut2_tablet_background_color_use	abt__ut2_tablet_background_color_use_use_own	abt__ut2_tablet_class	abt__ut2_tablet_class_use_own	abt__ut2_tablet_color_scheme	abt__ut2_tablet_color_scheme_use_own	abt__ut2_tablet_how_to_open	abt__ut2_tablet_how_to_open_use_own	abt__ut2_tablet_data_type	abt__ut2_tablet_data_type_use_own	abt__ut2_tablet_youtube_use	abt__ut2_tablet_youtube_use_use_own	abt__ut2_tablet_youtube_autoplay	abt__ut2_tablet_youtube_autoplay_use_own	abt__ut2_tablet_youtube_hide_controls	abt__ut2_tablet_youtube_hide_controls_use_own	abt__ut2_tablet_youtube_id	abt__ut2_tablet_youtube_id_use_own	abt__ut2_tablet_products_template	abt__ut2_tablet_products_template_use_own	abt__ut2_tablet_products_links_thumb_columns	abt__ut2_tablet_products_links_thumb_columns_use_own	abt__ut2_tablet_products_links_thumb_rows	abt__ut2_tablet_products_links_thumb_rows_use_own	abt__ut2_tablet_products_small_items_columns	abt__ut2_tablet_products_small_items_columns_use_own	abt__ut2_tablet_products_small_items_rows	abt__ut2_tablet_products_small_items_rows_use_own	abt__ut2_tablet_products_grid_columns	abt__ut2_tablet_products_grid_columns_use_own	abt__ut2_tablet_products_list	abt__ut2_tablet_products_list_use_own	abt__ut2_mobile_use	abt__ut2_mobile_color_scheme	abt__ut2_mobile_color_scheme_use_own	abt__ut2_mobile_content_valign	abt__ut2_mobile_content_valign_use_own	abt__ut2_mobile_content_align	abt__ut2_mobile_content_align_use_own	abt__ut2_mobile_padding	abt__ut2_mobile_padding_use_own	abt__ut2_mobile_content_full_width	abt__ut2_mobile_content_full_width_use_own	abt__ut2_mobile_title	abt__ut2_mobile_title_use_own	abt__ut2_mobile_title_font_size	abt__ut2_mobile_title_font_size_use_own	abt__ut2_mobile_title_color_use	abt__ut2_mobile_title_color_use_use_own	abt__ut2_mobile_title_color	abt__ut2_mobile_title_color_use_own	abt__ut2_mobile_title_font_weight	abt__ut2_mobile_title_font_weight_use_own	abt__ut2_mobile_title_tag	abt__ut2_mobile_title_tag_use_own	abt__ut2_mobile_title_shadow	abt__ut2_mobile_title_shadow_use_own	abt__ut2_mobile_description	abt__ut2_mobile_description_use_own	abt__ut2_mobile_description_font_size	abt__ut2_mobile_description_font_size_use_own	abt__ut2_mobile_description_color_use	abt__ut2_mobile_description_color_use_use_own	abt__ut2_mobile_description_color	abt__ut2_mobile_description_color_use_own	abt__ut2_mobile_description_bg_color_use	abt__ut2_mobile_description_bg_color_use_use_own	abt__ut2_mobile_description_bg_color	abt__ut2_mobile_description_bg_color_use_own	abt__ut2_mobile_object	abt__ut2_mobile_object_use_own	abt__ut2_mobile_data_type	abt__ut2_mobile_data_type_use_own	abt__ut2_mobile_youtube_use	abt__ut2_mobile_youtube_use_use_own	abt__ut2_mobile_youtube_autoplay	abt__ut2_mobile_youtube_autoplay_use_own	abt__ut2_mobile_youtube_hide_controls	abt__ut2_mobile_youtube_hide_controls_use_own	abt__ut2_mobile_youtube_id	abt__ut2_mobile_youtube_id_use_own	abt__ut2_mobile_products_template	abt__ut2_mobile_products_template_use_own	abt__ut2_mobile_products_links_thumb_columns	abt__ut2_mobile_products_links_thumb_columns_use_own	abt__ut2_mobile_products_links_thumb_rows	abt__ut2_mobile_products_links_thumb_rows_use_own	abt__ut2_mobile_products_small_items_columns	abt__ut2_mobile_products_small_items_columns_use_own	abt__ut2_mobile_products_small_items_rows	abt__ut2_mobile_products_small_items_rows_use_own	abt__ut2_mobile_products_grid_columns	abt__ut2_mobile_products_grid_columns_use_own	abt__ut2_mobile_products_list	abt__ut2_mobile_products_list_use_own	abt__ut2_mobile_main_image_use_own	abt__ut2_mobile_image_v_position	abt__ut2_mobile_image_v_position_use_own	abt__ut2_mobile_image_h_position	abt__ut2_mobile_image_h_position_use_own	abt__ut2_mobile_background_type	abt__ut2_mobile_background_type_use_own	abt__ut2_mobile_background_image_use_own	abt__ut2_mobile_background_mp4_video	abt__ut2_mobile_background_mp4_video_use_own	abt__ut2_mobile_background_image_size	abt__ut2_mobile_background_image_size_use_own	abt__ut2_mobile_background_color_use	abt__ut2_mobile_background_color_use_use_own	abt__ut2_mobile_background_color	abt__ut2_mobile_background_color_use_own	abt__ut2_mobile_background_v_position	abt__ut2_mobile_background_v_position_use_own	abt__ut2_mobile_background_h_position	abt__ut2_mobile_background_h_position_use_own	abt__ut2_mobile_content_bg	abt__ut2_mobile_content_bg_use_own	abt__ut2_mobile_content_bg_position	abt__ut2_mobile_content_bg_position_use_own	abt__ut2_mobile_content_bg_align	abt__ut2_mobile_content_bg_align_use_own	abt__ut2_mobile_content_bg_opacity	abt__ut2_mobile_content_bg_opacity_use_own	abt__ut2_mobile_content_bg_color_use	abt__ut2_mobile_content_bg_color_use_use_own	abt__ut2_mobile_content_bg_color	abt__ut2_mobile_content_bg_color_use_own	abt__ut2_mobile_button_use	abt__ut2_mobile_button_use_use_own	abt__ut2_mobile_button_text	abt__ut2_mobile_button_text_use_own	abt__ut2_mobile_button_style	abt__ut2_mobile_button_style_use_own	abt__ut2_mobile_button_text_color_use	abt__ut2_mobile_button_text_color_use_use_own	abt__ut2_mobile_button_text_color	abt__ut2_mobile_button_text_color_use_own	abt__ut2_mobile_button_color	abt__ut2_mobile_button_color_use_own	abt__ut2_mobile_button_color_use	abt__ut2_mobile_button_color_use_use_own	abt__ut2_mobile_class	abt__ut2_mobile_class_use_own	abt__ut2_mobile_how_to_open	abt__ut2_mobile_how_to_open_use_own
42	A	Main banner 3 (XBOX)	abt__ut2	B		0				1	0	115	0	N	0	0	Y	text	#01c241	Y		N	#ffffff	Y	60px	900	div	cover	bottom	center	center	center	Y	18px	#bababa	Y		N	image	#000000	Y	b--column-reverse	dark	center	right	N	transparent	whole_banner	auto	60		N	5%	in_this_window	url	N	Y	N	mp4_video	ut2_banner_videos/47-abt__ut2_background_mp4_video-banner.mp4	Let's Play	<small>Xbox Series X</small>LOOKS BETTER,<br>SOUNDS BETTER,<br><span style="color: #01c241">PLAYS BETTER</span>	categories.view&category_id=255	Embark on new adventures the way they’re meant to be experienced on Xbox Series X.			0	0	0	0	0		N	center	N	center	N	20px 20px 20px 20px	N	N	N		N	18px	N	Y	N		N	14px	N	N	image	N		N	N	cover	N	center	N	center	N	center	N	center	N	N	N		N	none	N	only_under_content	N	auto	N	50	N		N	N	N		N	N	N		N	N	N	normal	N		N	N	N	300	N	div	N		N	N	N		N	N	N	image	N		N	N	N		N	light	N	in_this_window	N	url	N	N	N	N	N	N	N		N		N	0	N	0	N	0	N	0	N	0	N		N	Y	light	N	bottom	Y	center	Y	30px 10px 0	Y	Y	Y		N	32px	Y	N	N		N	300	N	div	N	Y	N		N	18px	Y	N	N		N	N	N		N	image	N	url	N	N	N	N	N	N	N		N		N	0	N	0	N	0	N	0	N	0	N		N	Y	center	N	center	N	image	N	N		N	cover	N	N	N		N	center	N	center	N	none	N	only_under_content	N	auto	N	50	N	N	N		N	N	N		N	normal	N	N	N		N		N	N	N		N	in_this_window	N