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 = 108 
  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.00113

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
108 0 7 7/108 A B 0 1743120000 0 0 N 0 0 en Building We are The Helpful: My Journey as a Solo Founder and the Power of Community <p><span style="color: var(--redactor2-text-color);">Starting and growing We are The Helpful as a solo founder has been an incredible journey so far - one that has challenged me, shaped me, and, most importantly, connected me with some of the most extraordinary and supportive communities.&nbsp;</span></p><p><span style="color: var(--redactor2-text-color);">Moving from Australia to the UK and launching a business on my own was no small feat, but the power of finding like-minded people who truly want to see you succeed has been a game-changer. One of those communities is Buy Women Built, and I’m incredibly proud that We are The Helpful is now part of this movement.</span></p> <p>The statistics around female entrepreneurship in the UK are staggering - and not in a good way. Women are 30% less likely to start a business in the UK compared to the USA, Canada, and the Netherlands. Only 1 in 3 UK entrepreneurs is female, and a shocking 80% of young people aged 11-18 can’t name a single female entrepreneur. That matters because visibility shapes possibility - if young girls don’t see women building businesses, they don’t grow up believing they can do it themselves.</p> <p>This is why Buy Women Built is so important. It’s more than just a directory of female-led businesses; it’s a movement that champions the work of women who are building, innovating, and leading. It shines a light on businesses like mine and so many others, encouraging people to actively support and invest in female founders. Because when women start businesses at the same rate as men, we add an additional £250 billion to the UK economy. That’s not just good for women - it’s good for <em>everyone</em>.</p> <p>For me, We are The Helpful is about more than just gifting. It’s about rethinking how we show up for each other, especially in the moments that truly matter. And in many ways, Buy Women Built embodies that same ethos - championing and celebrating the women who are showing up, doing the work, and changing the landscape of entrepreneurship.</p> <p>So, if you want to make a difference, start by supporting women-led businesses. Seek them out, buy from them, engage with their posts and share their work. Because when we back women, we build a better future for everyone.</p> <p>Check out the <a href="https://buywomenbuilt.com/">Buy Women Built website</a> and explore the incredible businesses that are part of this movement - including We are The Helpful. Because together, we can shift the stats and change the narrative.</p><p>Kate x</p> Buy Women Built, female owned business, gifting for women, gifts for women, gifts when life happens Starting We Are The Helpful as an Australian solo founder in the UK has been a journey filled with challenges, growth, and the most incredible support from communities like Buy Women Built. Now proudly part of this movement, I’m sharing why championing fe Building We are The Helpful: My Journey as a Solo Founder and the Power of Community building-we-are-the-helpful-my-journey-as-a-solo-founder-and-the-power-of-community 7