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 = 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', 'B', 'F')

Query time 0.00095

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
66 0 7 7/66 A B 0 1715295600 0 0 N 0 0 activity en Letter from our Founder <p>Hi, I’m Kate, and I have a question for you.<br></p> <p>How many times have you witnessed someone you love experience something tough (even when the reason is good) and found yourself saying, “I wish I knew how to help?”&nbsp;</p> <p>For me, it’s too many. And every time it happens, I feel a little more deflated, and a little less of a “good” friend.&nbsp;</p> <p>It began when a close friend of mine was living in a different city and experiencing total exhaustion and overwhelm.&nbsp; If I’d lived closer, I ‘d have scheduled playdates with her kids so she could have an hour or two to herself.&nbsp; I would have cooked, cleaned or made sure she could prioritise some self care - anything to take a few things off her to-do list and bring her back to feeling more like herself.&nbsp;&nbsp;</p> <p>But I didn’t, and I couldn't find anything online that would actually HELP her through this period.&nbsp;Nothing that would have shown her that I saw her,&nbsp; or provide the help I knew she so badly needed.&nbsp;</p> <p>The gifting industry (the obvious go-to) caters to every milestone under the sun. But what about the moments in between, when life <i>really</i> happens, when flowers or the typical “stuff” just adds to the mental load? We live in a time when we can access anything, but not, it seems, the things we truly need.&nbsp;</p> <p>So where do you go when what you need to gift is support, not stuff?</p> <p>What does ‘help’ or “support” even look like?</p> <p>And, perhaps more pressingly, why is it so hard to ask for it or even talk about it?</p> <p>This is what I intend to uncover as I journey in pursuit of what I’m coining “The Art of Showing Up”, or to put it differently, how to ensure that our inner circles, aka the people we love the most, are NEVER doing it alone.&nbsp;</p> <p>I’ll be exploring when the ‘village’ became bad for business. Why the gifting industry is booming yet overwhelm, loneliness and isolation is at an all-time high and boldly asking where it all went so wrong.&nbsp;&nbsp;</p> <p>My findings, shaped through four key pillars; How to Show Up, When to Show Up, What to Show up with, and how to Ask For Help, powered by lived experiences (not those dictated by the industry - you won’t find a Christmas gift guide here&hellip;) will shape what I hope to be the solution to that first question; where do you go when what you need to gift is support.</p> <p>The answer? I’m building it.&nbsp;</p> <p>We Are The Helpful, is a gifting marketplace offering help, not just stuff. It’s gifting, reimagined.&nbsp; It's for the inner circle, not the masses. And it’s curated by your experiences, of what actually helped you and made you feel less alone and more supported, so we can more easily gift it to others.</p> <p>As for the rest? I’m well on my way. I’ve already spoken to hundreds of women, just like you, who’ve generously shared their experiences of what helped, or would have, when life happened.&nbsp;</p> <p>If you have a story to tell (don’t we all?) then I’d love to hear from you. Drop me a note at the link below and let’s shape what the future of showing up for the ones we love looks like, together.</p> <p>Love,&nbsp;</p> <p>Kate&nbsp;</p> <p>x</p> letter-from-the-founder 7