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' 
WHERE 
  cscart_pages.page_id = 93 
  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', 'B', 'F')

Query time 0.00075

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.35"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_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",
            "facebook_obj_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_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": "3K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link"
          ]
        }
      },
      {
        "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"
          ]
        }
      }
    ]
  }
}

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 facebook_obj_type lang_code page description meta_keywords meta_description page_title link seo_name seo_path
93 0 7 7/93 A B 0 1732579200 0 0 N 0 0 en We are The Helpful Started with a Question: How can I help her through this? <p><span style="color: var(--redactor2-text-color);">That one question has led me to hundreds of conversations, deep research, and invaluable insights into what truly helps when life happens. Whether it’s busyness, overwhelm, excitement, new life, loss, illness, recovery, marriage, divorce, parenting, menopause, career highs and lows - the list goes on.</span></p> <p>My reason? I don’t believe we should navigate these moments alone. But as life gets busier, it often feels like we are. Strangely, even with everything at our fingertips, showing up for the ones we love can feel harder than ever. And it’s not because we don’t care (we do); it’s because we don’t always know how.</p> <p>What if <strong>helpful gifting -&nbsp;</strong>gifting that truly supports and uplifts - was easier?</p> <p>What if we started sharing stories, insights, and real-life experiences to help ourselves and our loved ones through life’s hardest (and even happiest) transitions?</p> <p>What if those insights reshaped how we think about <strong>group gifting</strong>, turning it into something more meaningful - something that allows a community to rally around a friend or family member when they need it most?</p> <p>Three years later, I’m incredibly proud to say that these learnings have led to <strong>We are The Helpful -&nbsp;</strong>a curated gifting marketplace focused on gifting help, not just stuff. And now, the site is live.</p> <p>Every product and service featured is informed by real customer stories - the experiences I’ve gathered from countless conversations about what truly helps. <strong>We are The Helpful</strong> is designed to answer the question: <em>"How can I support them through this?",&nbsp;</em>whether that means a small gesture or a group effort to provide meaningful care.</p> <p>This is just the beginning. The more I learn, the stronger the site becomes. So if you have a story to share, feedback, or insights, I would love to hear from you. <strong>We are The Helpful</strong> is built on your experiences- on what actually made a difference when life happened.</p> <p>So tell me, what helped you most?</p> <p>I’d love to hear your story (and I mean that - you can contact me <a href="mailto:kate@wearethehelpful.com">here</a>).</p> <p>Kate x</p> We are The Helpful, Helpful Gifting, Group gifting, gifts for her, how do I help her, sympathy gifts, gifts for new Mums How I came to build We are The Helpful, and why Helpful Gifting is so important for the ones we love We are The Helpful Started with the Question we-are-the-helpful-started-with-a-question-how-can-i-help-her-through-this 7