SELECT 
  pages.*, 
  page_descriptions.*, 
  seo_names.name as seo_name, 
  seo_names.path as seo_path 
FROM 
  pages 
  INNER JOIN page_descriptions ON pages.page_id = page_descriptions.page_id 
  LEFT JOIN seo_names ON seo_names.object_id = pages.page_id 
  AND seo_names.type = 'a' 
  AND seo_names.dispatch = '' 
  AND seo_names.lang_code = 'en' 
WHERE 
  pages.page_id = 43 
  AND page_descriptions.lang_code = 'en' 
  AND (
    pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, pages.usergroup_ids) 
    OR FIND_IN_SET(1, pages.usergroup_ids)
  ) 
  AND pages.page_type IN ('T', 'L', 'F')

Query time 0.00787

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.96"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "pages",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "page_id"
          ],
          "key_length": "3",
          "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": "2K"
          },
          "used_columns": [
            "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"
          ]
        }
      },
      {
        "table": {
          "table_name": "page_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "page_id",
            "lang_code"
          ],
          "key_length": "9",
          "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": "4K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link",
            "custom_header"
          ]
        }
      },
      {
        "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.86",
            "eval_cost": "0.10",
            "prefix_cost": "0.96",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      }
    ]
  }
}

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 lang_code page description meta_keywords meta_description page_title link custom_header seo_name seo_path
43 0 0 43 A T 0 1593144000 0 0 N 0 0 en Buyer & Returns Policy <h3><span style="color: rgb(49, 133, 155);">Buyer Policy</span></h3> <p>goimagine is a venue where you can purchase handmade goods directly from sellers around the United States. Please read on to find out more about your rights, as well as what is expected of you, as a buyer.</p> <p>This policy is a part of our <a href="https://goimagine.com/terms-conditions/">Terms &&nbsp;Conditions</a>.&nbsp;By shopping on Goimagine, you’re agreeing to this policy and our Terms of Use. </p> <h4><span style="color: rgb(49, 133, 155);">1. Understanding Goimagine’s Limitations as a Venue</span> </h4> <p>Goimagine provides a venue for buyers to discover and purchase from sellers around the United States. It is important to note that Goimagine is not a part of that transaction. By shopping on Goimagine, you understand that: </p> <ul><li>You are not buying directly from Goimagine, but from one of the many talented sellers on Goimagine; </li><li>Goimagine does not pre-screen sellers and therefore does not guarantee or endorse any items sold on Goimagine or any content posted by sellers (such as photographs or language used in listings or shop policies); </li><li>Each seller on Goimagine has their own processing times, shipping methods, and shop policies; and </li><li>You assume responsibility if you provide your own materials for a custom order. </li></ul> <p>As a member of the community, you have the opportunity to flag an item or a shop that violates any of Goimagine’s policies.&nbsp;If you have a complaint or find a seller violating goimagine policies please email us at&nbsp;<a href="mailto:info@goimagine.com">info@goimagine.com</a>&nbsp;&nbsp;</p> <h4><span style="color: rgb(49, 133, 155);">2. Communicating with Goimagine Makers</span></h4> <p>You can use Goimagine’s&nbsp;Message Center tool to communicate directly with Goimagine makers. Messages are a great way to ask makers any questions you have about an item or an order. You can initiate conversation with a maker by either clicking "Ask a Question"&nbsp;a product or from an order you placed in your buyer profile.&nbsp;</p> <p>Messages may not be used for the following activities: </p> <ul><li>Sending unsolicited advertising or promotions, requests for donations, or spam; </li><li>Harassing or abusing another buyer or seller </li><li>Contacting someone after they have explicitly asked you not to; or </li><li>Interfering with a transaction or the business of another maker. Interference occurs when a maker intentionally interferes with another maker’s shop in order to drive away their business. Interference is strictly prohibited on Goimagine.&nbsp;</li></ul> <p>Examples of interference include:</p> <ul><li>Contacting another maker via Goimagine Messages to warn them away from a particular buyer, shop, or item; </li><li>Posting in public areas to demonstrate or discuss a dispute with another maker; </li><li>Purchasing from a maker for the sole purpose of leaving a negative review;</li></ul> <p>Any use of Goimagine Messages to harass other members is strictly prohibited. If you receive a message that violates this policy, please email us at <a href="mailto:info@goimagine.com">info@goimagine.com</a>&nbsp;&nbsp;</p> <h4><span style="color: rgb(49, 133, 155);">3. Purchasing an Item on Goimagine</span> </h4> <p>When you buy from a shop on Goimagine, you’re directly supporting an independent business, each with its handmade listings, policies, processing times, and payment systems. By making a purchase from a seller on Goimagine, you agree that you have: </p> <ul><li>Read the item description thoroughly </li><li>Read and agree to the sellers Terms & Conditions at checkout </li><li>Submitted appropriate payment for item(s) purchased; and </li><li>Provided accurate shipping information to the seller. </li></ul> <h4><span style="color: rgb(49, 133, 155);">4. Leaving a Review of an Item</span> </h4> <p>Reviews are a great way to learn about a maker’s items, help good sellers build a strong reputation, or help warn other buyers about a poor experience. You can leave review, including a one to five star rating of your purchase. </p> <h4><span style="color: rgb(49, 133, 155);">5. Goimagine’s Return Policy</span></h4> <p>Although Goimagine is not directly involved in a transaction between a buyer and a seller, we provide a case system in the unlikely event that your order does not go as expected. By using Goimagine’s case system, you understand that Goimagine may use your personal information for the purpose of resolving disputes with sellers. You can use Goimagine’s case system to come to a resolution with the seller in the event of a non-delivery or if an item you receive is not as described in the listing.</p> <p><strong>Refunds</strong></p> <p>If you choose a refund as your preferred resolution, keep in mind that Goimagine only allows on-platform refunds for a period of 90 days post-transaction. After this 90 window has elapsed, Goimagine cannot support on-platform refunds for your order. However, you may still communicate directly with the seller to come to an off-platform resolution. Refunds issued by Goimagine will be in your original form of payment, and if such payment is not available, a Goimagine credit will be issued.</p> <p><b>Returning an Item</b> </p> <p>Each seller has his or her own return policies, which should be outlined in their Shop Policies. Not all sellers accept returns. We encourage you to read the sellers Terms & Conditions on each product or at checkout before making a purchase. </p> <p>&nbsp; </p> buyer-policy