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 = 118 
  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.00106

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
118 0 7 7/118 A B 0 1747004400 0 0 N 0 0 en Introducing La Fève: The Art of Chocolate Gifting, Reimagined <p><span style="color: var(--redactor2-text-color); font-size: 16px;"></span></p> <p><span style="color: var(--redactor2-text-color);">We talk to a lot of you (hundreds in fact) about what you actually need when life takes an unexpected turn; the good, the hard and the in-between.&nbsp;</span></p> <p>Again and again, food comes up. And not just the comforting, practical kind (though we love that too), but something else entirely.</p> <p><strong><em>Introducing Indulgent Treats:</em></strong> <strong>Delicious little luxuries made to delight, surprise and spoil - just because.&nbsp;</strong></p> <p>We’ve introduced the Indulgent Treats category because we know, without a doubt, that food is the Mother of Helpful Gifting.&nbsp; Pre-made, nourishing, comforting and designed to ease the mental load. But through so many conversations, we’ve also learnt that help doesn’t always have to be practical. Sometimes, it looks like a perfectly wrapped box of something rich, beautiful, and joyfully indulgent.&nbsp;</p> <p>A sweet distraction.&nbsp;</p> <p>A delicious celebration.&nbsp;</p> <p>A quiet little luxury that says, “I see you - you deserve this”.&nbsp;</p> <p>These are the treats that don’t solve everything, but they do soften the edges. And honestly? They’re always welcome on the doorstep.</p> <p>So we created a new category, Indulgent Treats, to celebrate the kind of gifting that speaks joy in its own quiet language. And the first brand to take its well-earned place here is La Fève.</p> <p><strong>So, who are La Fève?</strong></p> <p>La Fève is a small, passionate team led by the brilliant chocolatier, Pavel, in Bulgaria. Each piece is handcrafted with flair, curiosity, and a touch of mischief. You’ll find bold flavour combinations, design-led aesthetics and a thoughtful philosophy that chocolate can be more than a treat. It can be a moment of meaning.</p> <p>Whether you’re sending something sweet to a friend going through it, celebrating a tiny win, or gifting a little “just because”, La Fève belongs in your toolkit for thoughtful, deliciously magical gifting.</p> <p>We sat down with Jae and Kalin, Co-CEO's of La Fève UK to get to know them and this stunning brand a little better.</p> <p><strong><em>What begins as chocolate becomes something more - a memory, a mood, a moment. </em></strong>- Jae & Kalin</p> <p><strong>Your name and role with La Fève?&nbsp;</strong></p> <p>Hi! We’re Jae and Kalin, the duo bringing La Fève chocolates to the UK. We believe these unique, artisan treats deserve to be tasted and treasured here, in one of the world’s most chocolate-loving countries. More chocolate = more joy, right?</p> <p><strong>Why did you bring La Fève to the UK?</strong></p> <p>It all started with a single chocolate bonbon. We were chatting about the unique flavours of our home countries - South Korea and Bulgaria - when Kalin mentioned a yuzu chocolate he couldn’t stop thinking about. “The best I’ve ever had,” he said, eyes wide. Bold claim...&nbsp;</p> <p>As a lifelong chocolate lover, Jae was intrigued&hellip;and a little sceptical. The next day, Kalin handed her a box of La Fève. She thought she’d tried it all, but this was different. Every detail - the aesthetic, the textures, the delicate flavours - created an experience that felt truly special.</p> <p>Right then and there, we knew: more people needed to taste this joy.</p> <p><strong>Tell us more about La Fève:&nbsp;</strong></p> <p>La Fève is a small, passionate team led by the brilliant chocolatier Pavel in Bulgaria. His team brings curiosity, joy, and a touch of mischief into every creation. La Fève is all about bold flavours, creative expression, and making meaningful moments through chocolate.</p> <p><strong>What has been the most impactful and helpful gift you've received from a loved one and why?&nbsp;</strong></p> <p>Jae:&nbsp; A care box filled with meals and my favourite snacks during a time I barely had the time or energy to cook. It wasn’t just helpful, it was emotionally nourishing. Thoughtfulness like that stays with you.</p> <p>Kalin: I have to say that the most impactful gift I have received was a journal notebook. What made it special was the message and the words of wisdom that the notebook came with, which for the first time in my life made me sit down and reflect my thoughts onto paper. Since then, I look at the humble notebook in a whole new way.</p> <p><strong>Tell us 3 - 4 words that best describe your Inner Circle (you know, the ones who look after you while you're busy looking after everyone else):</strong></p> <p>Supportive, caring, understanding, unconditional. That’s the kind of love we try to pass on with every La Fève box.&nbsp;</p> <p><strong>Closing words?&nbsp;</strong></p> <p><em>Because in the end... what begins as chocolate becomes something more - a memory, a mood, a moment. We can’t wait to delight people with just the right chocolate, at just the right time.</em></p> <p>You can <a href="https://wearethehelpful.com/feed-nourish/indulgent-treats/">shop La Fève</a> on We are The Helpful today.</p> <p>Enjoy x</p> artisan chocolate UK, luxury chocolate gifts, indulgent treats for gifting, La Fève chocolate, thoughtful gift ideas, chocolate delivery UK, beautiful chocolate gifts, feel-good gifting, non-traditional gifts, best chocolate gifts UK, gifts for wife, gift Discover La Fève: bold, beautiful artisan chocolates that bring joy, colour, and indulgence to life’s most meaningful (and messy) moments. Introducing La Fève: The Art of Chocolate Gifting, Reimagined introducing-la-feve-the-art-of-chocolate-gifting-reimagined 7