SELECT 
  cscart_banners.banner_id, 
  cscart_banners.status, 
  cscart_banner_descriptions.banner, 
  cscart_banners.type, 
  cscart_banners.target, 
  cscart_banners.localization, 
  cscart_banners.timestamp, 
  cscart_banner_descriptions.description, 
  cscart_banner_descriptions.url, 
  cscart_banner_images.banner_image_id, 
  cscart_banners.company_id as company_id, 
  cscart_abt__yt_banner_images.abt__yt_banner_image_id, 
  cscart_banners.abt__yt_use_avail_period, 
  cscart_banners.abt__yt_avail_from, 
  cscart_banners.abt__yt_avail_till, 
  cscart_banners.abt__yt_button_use, 
  cscart_banners.abt__yt_button_text_color, 
  cscart_banners.abt__yt_button_text_color_use, 
  cscart_banners.abt__yt_button_color, 
  cscart_banners.abt__yt_button_color_use, 
  cscart_banners.abt__yt_title_color, 
  cscart_banners.abt__yt_title_color_use, 
  cscart_banners.abt__yt_title_font_size, 
  cscart_banners.abt__yt_title_font_weight, 
  cscart_banners.abt__yt_title_tag, 
  cscart_banners.abt__yt_title_shadow, 
  cscart_banners.abt__yt_description_font_size, 
  cscart_banners.abt__yt_description_color, 
  cscart_banners.abt__yt_description_color_use, 
  cscart_banners.abt__yt_description_bg_color, 
  cscart_banners.abt__yt_description_bg_color_use, 
  cscart_banners.abt__yt_object, 
  cscart_banners.abt__yt_background_color, 
  cscart_banners.abt__yt_background_color_use, 
  cscart_banners.abt__yt_class, 
  cscart_banners.abt__yt_color_scheme, 
  cscart_banners.abt__yt_content_valign, 
  cscart_banners.abt__yt_content_align, 
  cscart_banners.abt__yt_content_full_width, 
  cscart_banners.abt__yt_content_bg, 
  cscart_banners.abt__yt_content_bg_color_use, 
  cscart_banners.abt__yt_content_bg_color, 
  cscart_banners.abt__yt_padding, 
  cscart_banners.abt__yt_how_to_open, 
  cscart_banners.abt__yt_data_type, 
  cscart_banners.abt__yt_page_id, 
  cscart_banners.abt__yt_youtube_use, 
  cscart_banners.abt__yt_youtube_autoplay, 
  cscart_banners.abt__yt_youtube_loop, 
  cscart_banners.abt__yt_youtube_hide_controls, 
  cscart_banners.abt__yt_product_list_use, 
  cscart_banners.abt__yt_product_list, 
  cscart_banners.abt__yt_promotion_id, 
  cscart_banners.abt__yt_countdown_use, 
  cscart_banner_descriptions.abt__yt_button_text, 
  cscart_banner_descriptions.abt__yt_title, 
  cscart_banner_descriptions.abt__yt_url, 
  cscart_banner_descriptions.abt__yt_description, 
  cscart_banner_descriptions.abt__yt_youtube_id, 
  cscart_banner_descriptions.abt__yt_youtube_playlist, 
  cscart_banner_descriptions.abt__yt_youtube_thumb_key, 
  cscart_banner_descriptions.abt__yt_product_list_title 
FROM 
  cscart_banners 
  LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id 
  AND cscart_banner_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id 
  AND cscart_banner_images.lang_code = 'en' 
  LEFT JOIN cscart_abt__yt_banner_images ON cscart_abt__yt_banner_images.banner_id = cscart_banners.banner_id 
  AND cscart_abt__yt_banner_images.lang_code = 'en' 
WHERE 
  cscart_banners.banner_id = 31 
  AND cscart_banners.status IN ('A', 'H')

Query time 0.00109

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_banner_images",
          "access_type": "system",
          "possible_keys": ["banner"],
          "rows": 0,
          "filtered": 0,
          "const_row_not_found": true
        }
      },
      {
        "table": {
          "table_name": "cscart_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": "cscart_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": "cscart_abt__yt_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,
          "using_index": true
        }
      }
    ]
  }
}

Result

banner_id status banner type target localization timestamp description url banner_image_id company_id abt__yt_banner_image_id abt__yt_use_avail_period abt__yt_avail_from abt__yt_avail_till abt__yt_button_use abt__yt_button_text_color abt__yt_button_text_color_use abt__yt_button_color abt__yt_button_color_use abt__yt_title_color abt__yt_title_color_use abt__yt_title_font_size abt__yt_title_font_weight abt__yt_title_tag abt__yt_title_shadow abt__yt_description_font_size abt__yt_description_color abt__yt_description_color_use abt__yt_description_bg_color abt__yt_description_bg_color_use abt__yt_object abt__yt_background_color abt__yt_background_color_use abt__yt_class abt__yt_color_scheme abt__yt_content_valign abt__yt_content_align abt__yt_content_full_width abt__yt_content_bg abt__yt_content_bg_color_use abt__yt_content_bg_color abt__yt_padding abt__yt_how_to_open abt__yt_data_type abt__yt_page_id abt__yt_youtube_use abt__yt_youtube_autoplay abt__yt_youtube_loop abt__yt_youtube_hide_controls abt__yt_product_list_use abt__yt_product_list abt__yt_promotion_id abt__yt_countdown_use abt__yt_button_text abt__yt_title abt__yt_url abt__yt_description abt__yt_youtube_id abt__yt_youtube_playlist abt__yt_youtube_thumb_key abt__yt_product_list_title
31 A abt-abt-gbanner-blog abyt T 1782505749 / 1 6 N 0 0 Y #ffffff Y #2176d6 Y N 18px 700 div N 13px N transparent N image #ffffff Y light bottom center Y N N 15px 15px 15px 15px in_popup blog 47 Y Y N N Y 82,83,84,85,87 14 N Buy now WII We brought new games for Nintendo Wii! categories.view&category_id=166 The long-awaited games for Nintendo. New games will be to your liking, in them you will plunge into a fascinating world with fallen in love heroes. TVmW_qM1mmg Products from review