SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  cscart_pages.page_id = 66 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'F')

Query time 0.00059

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "table": {
      "table_name": "cscart_pages",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["page_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_page_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["page_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_ult_objects_sharing",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "159",
      "used_key_parts": [
        "share_object_id",
        "share_company_id",
        "share_object_type"
      ],
      "ref": ["const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "206",
      "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
      "ref": ["const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_seo_names.`type` = 'a' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
    }
  }
}

Result

page_id company_id parent_id id_path status page_type position timestamp usergroup_ids localization new_window use_avail_period avail_from_timestamp avail_till_timestamp extra_css extra_js layout_id commercial_hidden lang_code page description meta_keywords meta_description page_title link seo_name seo_path
66 1 0 66 A T 0 1274068800 0 0 N 0 0 0 0 en Return Policy <p><span>We understand that due to the nature of online ordering and the fluid process of building and remodeling, returns are sometimes necessary. Because we offer a vast quantity of designs and options, and every product is made to order to the customer's specifications, w</span><span>e encourage customers to talk with our sales team about sizes, colors, quantities, and other finish options before ordering to ensure their satisfaction.</span><span> Finish samples can also be requested prior to placing an order. These steps often resolve the need to return a product. </span></p> <p>If, by some chance, we make a mistake on your order, we will get the correct products to you with no additional charges. We will also pay for the incorrect items to be picked up and shipped back to us. It’s our goal to meet your expectations and make sure you are completely satisfied with your purchase.</p> <p> </p> <h2>RETURN POLICY</h2> <ol class="numbered-list"> <li><strong>No restocking fees</strong><span> </span>on standard returns (See<span> </span><strong>Non-Returns</strong><span> </span>below for merchandise not eligible).</li> <li><span>An RGA (Return Goods Authorization) Number must be requested within 30 days of receipt of the merchandise. Items returned without an RGA will be charged a 20% restocking fee. Refusal of shipment will also incur a 20% restocking fee.</span></li> <li>Returns must be received to Barn Light within 15 days of the RGA being issued. Returns outside of this period will not be accepted.</li> <li>Refunds will only be issued in the manner that payment was received, or store credit will be issued.</li> <li>Shipping charges and/or rush manufacturing charges will not be refunded.</li> <li>Items must not have been installed or altered in any way.</li> <li>Items must be in the original box and with original packaging material.</li> <li>Customer is responsible for all return shipping charges.</li> <li>Customer is responsible for insuring returned items.</li> <li>Refunds will be issued upon inspection and after the merchandise is placed back into inventory. Typically this process takes between 5 to 7 business days.</li> <li>Items refused at delivery address will be charged all freight costs and applicable restocking fees.</li> <li>If a package is accepted and it is found to be uninsured with damages, has been installed, or altered in any way, the package and its contents becomes the property of Barn Light and no refunds will be issued.</li> <li>After items are inspected, the customer will be contacted and informed if the return is accepted. Barn Light retains the right to modify this return policy without notification.</li> </ol> <p> </p> <h2>NO REFUNDS OR RETURNS WILL BE ACCEPTED FOR THE FOLLOWING:</h2> <ol class="numbered-list"> <li><strong>No refunds or exchanges accepted on commercial orders.</strong></li> <li><strong>Installed</strong><span> </span>or<span> </span><strong>altered merchandise</strong><span> </span>are not eligible for return and will not be refunded.</li> <li>Barn Light will not refund<span> </span><strong>damaged merchandise</strong>. Customer must file a claim with the return shipper if returned merchandise is damaged.</li> <li><strong>Clearance, Discount and/or Customized Items</strong><span> </span>will not be authorized for return or refunded.</li> <li><strong>International Orders </strong>are not authorized for return.</li> <li><strong>Items returned to other manufacturers without authorization</strong><span> </span>will not be refunded.</li> <li><strong>Special order finishes of Copper, Brass &amp; Commercial HID, PAR, GU24 Bi-Pin CFL, E27 Socket, LED and/or ballast items</strong><span> </span>are non-returnable.</li> <li><strong>Vintage, Antiques, Salvage Items &amp; Light Bulbs</strong><span> </span>are non-returnable.</li> <li><strong>Light poles, clocks, and apartment lights</strong><span> </span>are non-returnable.</li> <li><strong>Furniture</strong><span> </span>is non-returnable as they are custom made-to-order items.</li> <li><strong>Porcelain Enamel Dinnerware Collection</strong><span> </span>is non-returnable.</li> </ol> <p> </p> <h2>CANCELLATIONS</h2> <p style="font-weight: 400;">Due to the custom nature of our hand-made products, Barn Light does not generally accept order cancellations. Cancellations may be subject to penalty, as follows:</p> <p style="font-weight: 400;"><strong>Retail Orders</strong> - retail orders may be cancelled within 24 hours of being placed without penalty.  All orders cancelled beyond 24 hours of placement will be subject to a restocking fee up to 50% of the order value, excluding shipping if applicable.</p> <p style="font-weight: 400;"><strong>Commercial Orders</strong> – commercial orders may be cancelled within 24 hours of being placed without penalty. All orders cancelled beyond 24 hours of placement will be subject to restocking fee commensurate with the level of production, plus any associated administrative costs. Please refer to Section 4 of the Sales Agent Agreement (rev. 7/22) for further details.</p> Lighting & Ceiling Fan Return Policy Barn Light Electric Company Return Policy Return Policy return-policy-en