SELECT 
  shop_policies.*, 
  return_policy_descriptions.policy AS return_policy, 
  company_descriptions.*, 
  companies.*, 
  cscart_vendor_plan_descriptions.plan, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  AVG(
    cscart_discussion_rating.rating_value
  ) AS average_rating, 
  CONCAT(
    companies.company_id, 
    '_', 
    IF (
      cscart_discussion_rating.thread_id, 
      cscart_discussion_rating.thread_id, 
      '0'
    )
  ) AS company_thread_ids 
FROM 
  cscart_companies AS companies 
  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id 
  AND company_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id 
  AND cscart_vendor_plan_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 381 
  AND cscart_seo_names.type = 'm' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = companies.company_id 
  AND cscart_discussion.object_type = 'M' 
  LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id 
  AND cscart_discussion_posts.status = 'A' 
  LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id 
  AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id 
  LEFT JOIN cscart_return_policies AS return_policies ON return_policies.object_id = companies.company_id 
  AND return_policies.object_type = 'company' 
  LEFT JOIN cscart_return_policy_descriptions AS return_policy_descriptions ON return_policy_descriptions.policy_id = return_policies.policy_id 
  AND return_policy_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_shop_policies AS shop_policies ON shop_policies.company_id = companies.company_id 
  AND shop_policies.lang_code = 'en' 
WHERE 
  companies.company_id = 381

Query time 0.00117

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_discussion_posts",
          "access_type": "system",
          "possible_keys": [
            "thread_id",
            "thread_id_2"
          ],
          "rows_examined_per_scan": 0,
          "rows_produced_per_join": 1,
          "filtered": "0.00",
          "const_row_not_found": true,
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "448"
          },
          "used_columns": [
            "post_id",
            "thread_id",
            "status"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_discussion_rating",
          "access_type": "system",
          "possible_keys": [
            "PRIMARY",
            "thread_id"
          ],
          "rows_examined_per_scan": 0,
          "rows_produced_per_join": 1,
          "filtered": "0.00",
          "const_row_not_found": true,
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "16"
          },
          "used_columns": [
            "rating_value",
            "post_id",
            "thread_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "companies",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "company_id"
          ],
          "key_length": "4",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "15K"
          },
          "used_columns": [
            "company_id",
            "status",
            "company",
            "lang_code",
            "address",
            "city",
            "state",
            "country",
            "zipcode",
            "email",
            "phone",
            "url",
            "storefront",
            "secure_storefront",
            "entry_page",
            "redirect_customer",
            "countries_list",
            "timestamp",
            "shippings",
            "logos",
            "request_user_id",
            "request_account_name",
            "request_account_data",
            "tax_number",
            "registered_from_storefront_id",
            "plan_id",
            "pre_moderation",
            "pre_moderation_edit",
            "pre_moderation_edit_vendors",
            "suspend_date",
            "grace_period_start",
            "last_time_suspended",
            "last_debt_notification_time",
            "paypal_commerce_platform_account_id",
            "discreet_shipping",
            "shipstation_enabled",
            "shipstation_fulfillment",
            "shipstation_api_key",
            "shipstation_api_secret",
            "shipstation_api_connected",
            "shipstation_webhook_id",
            "shipstation_store_id",
            "shipstation_warehouse_name",
            "shipstation_warehouse_street1",
            "shipstation_warehouse_street2",
            "shipstation_warehouse_street3",
            "shipstation_warehouse_country",
            "shipstation_warehouse_state",
            "shipstation_warehouse_city",
            "shipstation_warehouse_postal_code",
            "shipstation_warehouse_phone",
            "shipstation_warehouse_residential",
            "shipstation_warehouse_id",
            "shipengine_enabled",
            "shipengine_api_key",
            "shipengine_api_connected",
            "shipengine_webhook_id",
            "shipengine_account_id",
            "shipengine_external_account_id",
            "shipengine_api_key_id",
            "discreet_shipping_shop_name",
            "vacation_mode",
            "vacation_start_date",
            "vacation_end_date",
            "tagline",
            "shopify_token",
            "shopify_link_app",
            "shopify_api_key",
            "shopify_api_secret",
            "stripe_connect_account_id",
            "stripe_connect_account_type",
            "chitchats_enabled",
            "chitchats_client_id",
            "chitchats_api_key",
            "royal_mail_enabled",
            "royal_mail_api_key"
          ]
        }
      },
      {
        "table": {
          "table_name": "company_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "company_id",
            "lang_code"
          ],
          "key_length": "10",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "company_id",
            "lang_code",
            "company_description",
            "terms",
            "i18n_company",
            "i18n_address",
            "i18n_city"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_vendor_plan_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "plan_id",
            "lang_code"
          ],
          "key_length": "10",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "792"
          },
          "used_columns": [
            "plan_id",
            "lang_code",
            "plan"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "dispatch"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "object_id",
            "type",
            "dispatch",
            "lang_code"
          ],
          "key_length": "206",
          "ref": [
            "const",
            "const",
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.35",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_discussion",
          "access_type": "const",
          "possible_keys": [
            "object_id"
          ],
          "key": "object_id",
          "used_key_parts": [
            "object_id",
            "object_type"
          ],
          "key_length": "6",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.45",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "thread_id",
            "object_id",
            "object_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "return_policies",
          "access_type": "ref",
          "possible_keys": [
            "object_type"
          ],
          "key": "object_type",
          "used_key_parts": [
            "object_type",
            "object_id"
          ],
          "key_length": "95",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.80",
            "data_read_per_join": "112"
          },
          "used_columns": [
            "policy_id",
            "object_type",
            "object_id"
          ]
        }
      },
      {
        "table": {
          "table_name": "return_policy_descriptions",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "policy_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "cscartdb.return_policies.policy_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.90",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "policy_id",
            "policy",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "shop_policies",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "company_id",
            "lang_code"
          ],
          "key_length": "10",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "1.00",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "company_id",
            "lang_code",
            "shop_policies"
          ]
        }
      }
    ]
  }
}

Result

company_id lang_code shop_policies return_policy company_description terms i18n_company i18n_address i18n_city status company address city state country zipcode email phone url storefront secure_storefront entry_page redirect_customer countries_list timestamp shippings logos request_user_id request_account_name request_account_data tax_number registered_from_storefront_id plan_id pre_moderation pre_moderation_edit pre_moderation_edit_vendors suspend_date grace_period_start last_time_suspended last_debt_notification_time paypal_commerce_platform_account_id discreet_shipping shipstation_enabled shipstation_fulfillment shipstation_api_key shipstation_api_secret shipstation_api_connected shipstation_webhook_id shipstation_store_id shipstation_warehouse_name shipstation_warehouse_street1 shipstation_warehouse_street2 shipstation_warehouse_street3 shipstation_warehouse_country shipstation_warehouse_state shipstation_warehouse_city shipstation_warehouse_postal_code shipstation_warehouse_phone shipstation_warehouse_residential shipstation_warehouse_id shipengine_enabled shipengine_api_key shipengine_api_connected shipengine_webhook_id shipengine_account_id shipengine_external_account_id shipengine_api_key_id discreet_shipping_shop_name vacation_mode vacation_start_date vacation_end_date tagline shopify_token shopify_link_app shopify_api_key shopify_api_secret stripe_connect_account_id stripe_connect_account_type chitchats_enabled chitchats_client_id chitchats_api_key royal_mail_enabled royal_mail_api_key plan seo_name seo_path average_rating company_thread_ids
381 en SHIPPING & HANDLING: All orders are processed, printed and SHIPPED within 1-3 business days. All posters are shipped in a reinforced shipping tube. If you need something fast or have a question please send us a message. DESIGN SERVICES We offer a wide variety of services including custom image searching, design consultation and the sale of high-end photographs and posters. We also do special orders and custom sizes. The copies that you are buying have been retouched and restored to as close to original as possible. Please note that different sizes have different aspect ratios which means your photo may be cropped a little differently depending on the size. Thanks for looking. We hope you enjoy them! Delivery Estimates & Delays Please note that we are not responsible for slow transit due to bad weather or packages lost by the USPS. We have no control over the Post Office and how they handle the mail or their deliveries. Lost Items If the Post Office indicates that your item[s] were delivered we have no responsibility to replace the items[s] or issue a refund of any kind. If a package is lost in transit and it can be verified that it was not delivered through the records we will gladly replace the item, refund your purchase price or give you a store credit at your request. If you have a problem with your order please contact us before leaving negative feedback. We will always try to work with you to resolve these kinds of situations if at all possible. Custom and Personalized Orders Every item that is shipped by the Post Office has $100.00 in basic insurance coverage through the Postal Service. If the Post Office says that your item was delivered and you did not receive it is your responsibility to make a claim through the Post Office for the amount that was lost. We do not have the ability to make that claim for you or assist in any way. If you wish to purchase additional Insurance on your package[s] please let us know and we will adjust the price of shipping or send a special listing to you for the amount of the insurance you wish to purchase. Correct Mailing Address It is your responsibility to make sure that the address that you give us for mailing is correct. If your address is not verified by the Post Office and the items are lost or not delivered we are not responsible. Please make sure that you use a verified postal address when you are placing your order. We ship to the address that you provide and do not have the ability to modify, change or correct it if there is an issue. Return Policy All of our prints come with a money back guarantee. We are happy to work with you and want you to enjoy your purchase. If you aren't satisfied with your purchase you may return it to us within 7 business days. Please contact us before you send it back so we can give you a return number. We are not responsible for return shipping charges. If we require that the item be sent back then you must pay the costs associated with the return. In most cases we will be happy to either refund your money, reprint and reship the item or give you a store credit for the amount of the purchase. Payment Methods You can pay via directly via PayPal - you do not need a PayPal Account to pay for your items through PayPal. You can choose the PayPal Option during checkout. After you submit your order click the "Pay Now" button. Scroll down and you will see the option to pay with a Credit or Debit Card WITHOUT having to sign up for a PayPal Account. If you have any questions please contact us. All of our prints come with a money back guarantee. We are happy to work with you and want you to enjoy your purchase. If you aren't satisfied with your purchase you may return it to us within 14 calendar days. We are not responsible for return shipping charges. If we require that the item be sent back then you must pay the costs associated with the return and the item must be in saleable condition upon receipt. In most cases we will be happy to either refund your money or reprint and reship the item. Welcome to Vintageous Classic! We are long time collectors of classic images and have several online shops. Everything we do is in-house. We take great pride in the quality of the images we sell and appreciate your interest in our store. We moved here from another platform where we have over 5,000 verified five star reviews ... our sister shop Vintageous Gallery is now open !! Vintageous Classic 525 Tribble Gap Rd #1948 Cumming A Vintageous Classic 525 Tribble Gap Rd #1948 Cumming GA US 30040 Vintageous.classic@gmail.com 8509058126 none Y 1723036110 1065 a:4:{s:14:"company_fields";a:8:{i:37;s:5:"Susan";i:38;s:6:"Berlon";i:52;s:21:"vintageousclassic.com";i:58;s:0:"";i:54;s:0:"";i:55;s:0:"";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:5:"Susan";s:14:"admin_lastname";s:6:"Berlon";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:0:"";i:62;s:0:"";i:63;s:0:"";i:64;s:0:"";}} def502001c95ea57166f355f702b9e6c5931d85ffb400158c3e6183e6db36c03e8a70a816766c75a20457b72965e3420727a0987ef7d9b5d7916cf06879d1bd26257e5df8f5f7c927347f90628e0beae8667e92af06aabac6992ac2eddfd 1 1 N N N 0 0 0 0 FAC4SAG4NVZ6J Y N Y N 0 N 0 Y F8CynpLpiFF9quHPueRZiFF5zLzsBGj3Tti3fNw7VoE Y 0 6732596 317d8807-9bf6-46cc-9737-b3ce1e34e49e 5480293 VintageousClassic 0 0 0 Sexy, sultry, glamourous & erotic prints from the past... N N Beta Plan vintageousclassic 381_0