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 = 142 
  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.00030

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
142 0 7 7/142 A B 0 1759791600 0 0 N 0 0 en The Powerful Magic of Old Friends <p>There’s something about old friends that hits different, isn’t there? The ones who’ve seen your questionable fringe era. Peplum tops and pencil skirts. Heartbreaks. Celebrations. The messy middle years. The whole evolution of you - unfiltered, uncurated and through decades of hilarious fashion choices. <br></p><p><span style="font-weight: 700;"></span>They’ve been there through the moves, the kids, the 3 a.m. texts, the “I can’t do this” days. And somehow, no matter how much time or distance stretches between you, they’re still a part of your foundation. The one who knows how you take your coffee, when to talk and when to just&hellip; not talk.</p> <p>Old friendships are the rare kind of wealth that can’t be bought, bottled, or replaced. And in this mid-life chaos, they might just be the most important thing we’ve got.</p> <h4>Why Old Friends Are So Different</h4> <p>You know that feeling when someone walks into your house, ignores the pile of washing on the sofa, makes their own cuppa, and starts unloading the dishwasher while asking how you really are? That’s the kind of friendship we’re talking about.</p> <p>They see the real stuff.</p> <p> They’ve held your crying baby, poured your wine, seen your unwashed hair and still think you’re the most wonderful human on the planet.</p> <p>They’re the ones who show up - no performance, no pretence - just presence. They’ll read bedtime stories, play hide-and-seek, and fall asleep on the sofa with you halfway through a movie you’ve both seen ten times.</p> <p>You skip the small talk and go straight for the jugular: the big feelings, the quiet fears, the truth under the surface. Or you sit in silence, together, and that’s enough.</p> <p>It’s not glamorous. But it’s real. And it feeds your soul in a way no “networking connection” or school-gate chat ever will.</p> <h4>The Science Bit (Because Feelings Deserve Data)</h4> <p>Turns out, friendship isn’t just good for your heart - it literally protects it. </p> <p>The Harvard Study of Adult Development (the longest-running study on happiness ever) found that the quality of our close relationships is the number one predictor of long-term health and happiness. Not money. Not status. Not clean eating. Connection.</p> <p>People with strong social ties have lower blood pressure, less inflammation, better immune function and live longer. Basically, friendship is a wellness trend that actually works.</p> <p>And yet, midlife is the friendship danger zone. Between the juggle of work, family, health, and the never-ending WhatsApp groups, even the strongest connections can fade into the background noise.</p> <p>So how do we hold onto them?</p> <h4>How to Keep the Good Ones Close (Even When You’re Busy, Tired and Just Trying to Survive)</h4> <p><strong>1. Drop the perfection:</strong> Your house doesn’t need to be spotless. Your life doesn’t need to be “together.” Real friends want the real you. Invite them into the mess, it’s where the magic is.</p> <p><strong>2. Make it micro: </strong>You don’t need a three-hour catch-up and matching diaries. A two-minute voice note. A shared meme. A “thinking of you” text. It all counts. Connection is cumulative.</p> <p><strong>3. Keep rituals:</strong> A monthly coffee. A Friday night FaceTime. The same incense lit when you chat. Tiny rituals make big roots.</p> <p><strong>4. Be the first to reach out: </strong>Stop waiting for the perfect time - it doesn’t exist. Be brave enough to go first. Say, “Hey, I miss you,” even if it’s been months (or years). The right people never make you feel silly for trying.</p> <p><strong>5. Give meaningfully:</strong> When words fail, gestures speak. A gift that helps - something that says “I see you” - can bridge silence and truly support.</p> <p>That’s why we built We Are The Helpful: for these exact moments. The inner-circle moments. The ones not for the masses, but for the people who’ve seen our real lives - the exhaustion, the heartbreak, the comeback. The ones who’ve earned the front-row seat and are always there to cheer you on.</p> <h4>When Time or Life Gets in the Way</h4> <p>It’s easy to think old friendships should be effortless. But even the best ones need care. Life shifts - jobs, cities, marriages, kids, menopause, grief.</p> <p> Sometimes there’s silence. Sometimes there’s distance. But the real ones? They’re still there. Beneath the noise. Waiting for that text, that cup of tea, that reconnection.</p> <p>And when you do find your way back, it’s like muscle memory - the conversation picks up mid-sentence, the laughter sounds the same, and suddenly it’s all still there.</p> <p>Because it is still there. Always has been.</p> <h4>The Truth About the Inner Circle</h4> <p>We talk a lot about love in romantic terms, but the quiet, consistent love of friendship? That’s the glue that holds us together when life unravels.</p> <p>Old friends are the witnesses - to who we were, who we’ve become, and who we’re still figuring out how to be.</p> <p>They remind us of our strength when we’ve forgotten it. They make us laugh when everything else feels too heavy. They bring light when the room’s gone dark.</p> <p>And that - that’s why we do what we do. </p> <p>Helpful gifting isn’t about “stuff.” It’s about showing up. For her. For yourself. For the circle that holds you both steady when everything else wobbles.</p> <h4>A Little Nudge (From One Friend to Another)</h4> <p>Text her. Call him. Send the thing that says I see you. Don’t wait until life slows down - it won’t. Old friends are the mirrors of who we’ve been and the medicine for who we’re still becoming. </p> <p>They don’t need grand gestures - just reminders that they still matter. And in this messy, mid-life swirl of doing and holding and caring for everyone else, they might just be the thing that helps you breathe again, too.</p> <p><a href="https://wearethehelpful.com/she-needs/">Shop our She Needs gift edit</a> today - a curated collection of gifts that truly help when life happens (we know because hundreds of you have told us).</p> meaningful gifts for friends UK, connection gifts UK, thoughtful friendship gifts UK, gifts for close friends UK, heartfelt gifts for friend UK, midlife friendship, old friendships A love letter to old friends - the ones who’ve seen it all. Explore why long-term friendships are vital to midlife wellbeing, how to keep them close, and how thoughtful gifting helps us show up for our inner circle. The Quiet Magic of Old Friendships | We Are The Helpful the-powerful-magic-of-old-friends 7