SELECT 
  company_descriptions.*, 
  companies.*, 
  vendor_plan_descriptions.plan, 
  seo_names.name as seo_name, 
  seo_names.path as seo_path, 
  vendor_ga_tracking_code, 
  vendor_fb_tracking_code, 
  AVG(discussion_rating.rating_value) AS average_rating, 
  CONCAT(
    companies.company_id, 
    '_', 
    IF (
      discussion_rating.thread_id, discussion_rating.thread_id, 
      '0'
    )
  ) AS company_thread_ids 
FROM 
  companies AS companies 
  LEFT JOIN company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id 
  AND company_descriptions.lang_code = 'en' 
  LEFT JOIN vendor_plan_descriptions ON companies.plan_id = vendor_plan_descriptions.plan_id 
  AND vendor_plan_descriptions.lang_code = 'en' 
  LEFT JOIN seo_names ON seo_names.object_id = 5415 
  AND seo_names.type = 'm' 
  AND seo_names.dispatch = '' 
  AND seo_names.lang_code = 'en' 
  LEFT JOIN discussion as discussionA ON discussionA.object_id = companies.company_id 
  AND discussionA.object_type = 'M' 
  LEFT JOIN discussion_posts ON discussion_posts.thread_id = discussionA.thread_id 
  AND discussion_posts.status = 'A' 
  LEFT JOIN discussion_rating ON discussionA.thread_id = discussion_rating.thread_id 
  AND discussion_rating.post_id = discussion_posts.post_id 
WHERE 
  companies.company_id = 5415

Query time 0.00189

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.93"
    },
    "nested_loop": [
      {
        "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": "14K"
          },
          "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",
            "plan_id",
            "stripe_connect_account_id",
            "identifier_facebook_pixel",
            "featured_products",
            "sd_ga_tracking_code",
            "paypal_commerce_platform_account_id",
            "tagline",
            "url_facebook",
            "url_instagram",
            "url_twitter",
            "url_pinterest",
            "announcement",
            "shippo_api_token",
            "shippo_carrier",
            "shippo_service_type",
            "vendor_ga_tracking_code",
            "vendor_fb_tracking_code",
            "custom_domain",
            "custom_domain_status",
            "taxjar_key",
            "taxjar_export_statuses",
            "taxjar_export_csv_data",
            "ag_hide_city",
            "updated_timestamp",
            "suspend_date",
            "grace_period_start",
            "last_time_suspended",
            "last_debt_notification_time",
            "tax_number",
            "stripe_connect_account_type",
            "registered_from_storefront_id"
          ]
        }
      },
      {
        "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",
            "subdomain_colors",
            "i18n_company",
            "i18n_address",
            "i18n_city"
          ]
        }
      },
      {
        "table": {
          "table_name": "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": "1K"
          },
          "used_columns": [
            "plan_id",
            "lang_code",
            "plan"
          ]
        }
      },
      {
        "table": {
          "table_name": "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.90",
            "eval_cost": "0.10",
            "prefix_cost": "1.00",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "discussionA",
          "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",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.79",
            "eval_cost": "0.10",
            "prefix_cost": "1.89",
            "data_read_per_join": "24"
          },
          "used_columns": [
            "thread_id",
            "object_id",
            "object_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "discussion_posts",
          "access_type": "ref",
          "possible_keys": [
            "thread_id",
            "thread_id_2"
          ],
          "key": "thread_id_2",
          "used_key_parts": [
            "thread_id",
            "status"
          ],
          "key_length": "6",
          "ref": [
            "goimagine.discussionA.thread_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.18",
            "prefix_cost": "2.32",
            "data_read_per_join": "787"
          },
          "used_columns": [
            "post_id",
            "thread_id",
            "status"
          ]
        }
      },
      {
        "table": {
          "table_name": "discussion_rating",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY",
            "thread_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "post_id"
          ],
          "key_length": "3",
          "ref": [
            "goimagine.discussion_posts.post_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.44",
            "eval_cost": "0.18",
            "prefix_cost": "2.93",
            "data_read_per_join": "28"
          },
          "used_columns": [
            "rating_value",
            "post_id",
            "thread_id"
          ],
          "attached_condition": "<if>(is_not_null_compl(discussion_rating), (`goimagine`.`discussion_rating`.`thread_id` = `goimagine`.`discussionA`.`thread_id`), true)"
        }
      }
    ]
  }
}

Result

company_id lang_code company_description terms subdomain_colors 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 plan_id stripe_connect_account_id identifier_facebook_pixel featured_products sd_ga_tracking_code paypal_commerce_platform_account_id tagline url_facebook url_instagram url_twitter url_pinterest announcement shippo_api_token shippo_carrier shippo_service_type vendor_ga_tracking_code vendor_fb_tracking_code custom_domain custom_domain_status taxjar_key taxjar_export_statuses taxjar_export_csv_data ag_hide_city updated_timestamp suspend_date grace_period_start last_time_suspended last_debt_notification_time tax_number stripe_connect_account_type registered_from_storefront_id plan seo_name seo_path average_rating company_thread_ids
5415 en <p><span style="color: rgb(0, 0, 0);"></span></p> <p>Hello there and welcome to my Goimagine Store!</p> <p>I'm Nancy, and I'm thrilled to introduce you to my small business, YKnot Handmade. Crafting has been a passion of mine for decades, starting with sewing my own clothes, crocheting, macramé, woodworking, jewelry making, and exploring any creative outlet I could find. There's something so fulfilling about taking raw materials and transforming them into something both beautiful and practical!</p> <p>Today, I work exclusively with top-quality cotton cords and recycled materials from reputable manufacturers in Europe, South America, and the USA. While these materials may be pricier, I believe they're worth the investment, as they're OEKO-TEX certified and safe for even the most sensitive individuals, including babies and those with respiratory issues.</p> <p>I'm always on the lookout for unique and high-quality beads, chains, buttons, and other embellishments that will make my work stand out. In today's world, where more and more people are turning to crafting, I take pride in creating pieces that are truly one-of-a-kind.</p> <p>If you have any questions or are interested in a custom order, please don't hesitate to let me know. I love working with my customers to create something special just for them. And when it comes to wearable items, you can rest easy knowing that I hand wash each piece before shipping it out, and include care instructions with your order.</p> <p>All of my products are crafted by hand in my smoke-free home in Tennessee, and I'm proud to support the Arts, Makers, and Made in the USA.</p> <p>Thank you for taking the time to get to know me and my work. Wishing you all the best!</p> <p>Warmly,&nbsp;</p> <p>Nancy</p> <p><span style="color: rgb(0, 0, 0);"></span></p> <h6></h6> <p><span style="color: rgb(79, 129, 189);"><strong><em><span style="color: rgb(49, 133, 155);">I gladly accept returns and cancellations.</span></em></strong></span></p> <ul><li>Contact me within <strong>3 days of delivery</strong></li><li>Ship items back within <strong>7 days of delivery</strong></li><li>Request a cancellation within <strong>2 hours of purchase</strong></li></ul> <hr> <p><em style="color: rgb(49, 133, 155);"><strong>Shipping and Handling</strong>:</em><br></p> <ul><li>We ship to the United States only, usually within 1 to 3 business days if the item is in stock. Most lightweight items will ship USPS First Class, larger items USPS Priority, and heavier or oddly shaped items will be UPS.&nbsp; We do not charge a "handling fee".</li><li>All packages are sent with tracking, and is sent with $100 of included insurance. If you would like to purchase additional insurance or other services including signature confirmation, please contact me before purchasing.</li></ul> <hr> <p><em style="font-weight: 700;"><span style="color: rgb(49, 133, 155);">The following items cannot be returned:</span></em><br></p> <ul><li>Because of the nature of these items, unless they arrive damaged or defective, I can't accept returns for "Custom or Made to Order" items.</li></ul> <hr> <p><span style="color: rgb(79, 129, 189);"><strong><em><span style="color: rgb(49, 133, 155);">Conditions of return:</span></em></strong></span><br></p> <ul><li>Buyers are responsible for return shipping costs. If the item is not returned in its original condition, the buyer is responsible for any loss in value.</li></ul> <hr> <p><strong><em><strong><span style="color: rgb(49, 133, 155);">Questions about your order:</span></strong></em></strong><br></p> <ul><li>Please contact me anytime.</li></ul> <hr> <p><strong style="color: rgb(79, 129, 189);"><em><span style="color: rgb(49, 133, 155);">Do you make custom orders?</span></em></strong><br></p> <ul><li>Yes, if you would like a different color or size, just contact me and I'll be happy to help.</li></ul> <hr> <p><em><strong><span style="color: rgb(49, 133, 155);">Care Instructions:</span></strong></em><br></p> <ul><li>The care instructions will be included with your order. Basically with macramé, it's a vacuum and shake of large items and a spot clean and lay flat to dry for small items.</li></ul> <hr> <p><em><strong><span style="color: rgb(49, 133, 155);">Are all items in a certain style identical?</span></strong></em><br></p> <ul><li>No, there will always be small variations in anything that is handmade. Sometimes macramé cord and yarn that is the same size can be slightly tighter wound than another color might be. No two items will be identical but pretty close.</li></ul> <hr> <p><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"> <h4></h4> </b><p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p><p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b><br></p> <p><b class="btn btn-link" data-action="open-convo" style="border-radius: 3px; border-width: initial; border-style: none; border-color: initial; font-family: inherit; font-size: inherit; font-weight: inherit; height: inherit; line-height: inherit; padding: 0px; text-decoration-line: underline; user-select: none; white-space: nowrap; -webkit-tap-highlight-color: transparent; appearance: none; background-color: transparent; color: rgb(34, 34, 34);"></b></p> {"tmenu_style":"H","default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"","vbp_2_url":"https:\/\/yknothandmade.com\/index.php?dispatch=companies.view&company_id=5415","vbp_3_url":"https:\/\/yknothandmade.com\/search\/?search_performed=Y","vba_1_url":"https:\/\/yknothandmade.com\/search\/?search_performed=Y","vba_2_url":"https:\/\/www.oeko-tex.com\/en\/our-standards\/oeko-tex-standard-100","vba_3_url":"https:\/\/goimagine.com\/caring-economy\/"} YKnot Handmade Nashville A YKnot Handmade Nashville TN US 37122 yknothandmade@outlook.com +18036271318 none Y 1644876562 0 3 acct_1KTDTQKhzdPhXXjN 285158,179477,179478,196198,309493,179479,179476 Macramé Fiber Art, Unique Gifts, & Décor for your home https://www.facebook.com/profile.php?id=100068105449656 https://www.instagram.com/yknothandmade/ https://www.pinterest.com/yknothandmade4170/_created/ <p><em><span style="background-color: rgb(255, 255, 255);"><span style="color: rgb(49, 133, 155); background-color: rgb(219, 238, 243);">Welcome! All of my products are sustainably sourced and crafted in beautiful Tennessee. Shipping is $6 or less-no item limit. Free shipping for orders over $75.</span></span><span style="background-color: rgb(49, 133, 155);"></span></em></p> oauth.EQtsFHE_KRL4j5j47vauAjJrSgfbXdN2NdvhRJ26._bHpiTNzokVgP6sbk8X5zXjyPNiwa6dXh43qPwmgFk8 UA-221455790-1 3280765728910290 yknothandmade.com A {"items_per_file":"2500","time_from":"","time_to":""} N 0 0 0 0 0 S Professional Plan yknothandmade 5.0000 5415_1242508