SELECT 
  cscart_products.*, 
  cscart_product_descriptions.*, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    CASE WHEN (
      cscart_products_categories.link_type = 'M'
    ) THEN CONCAT(
      cscart_products_categories.category_id, 
      'M'
    ) ELSE cscart_products_categories.category_id END 
    ORDER BY 
      cscart_categories.storefront_id IN (0, 1) DESC, 
      (
        cscart_products_categories.link_type = 'M'
      ) DESC, 
      cscart_products_categories.category_position ASC, 
      cscart_products_categories.category_id ASC
  ) as category_ids, 
  popularity.total as popularity, 
  company_descr.i18n_company as company_name, 
  cscart_product_sales.amount as sales_amount, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_discussion.type as discussion_type, 
  cscart_product_review_prepared_data.average_rating average_rating, 
  cscart_product_review_prepared_data.reviews_count product_reviews_count 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  AND cscart_product_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_company_descriptions as company_descr ON company_descr.company_id = cscart_products.company_id 
  AND company_descr.lang_code = 'en' 
  LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id 
  INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_products.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_products.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_products.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_products.status IN ('A', 'H') 
  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id 
  AND cscart_product_sales.category_id = 265 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 929 
  AND cscart_seo_names.type = 'p' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id 
  AND cscart_discussion.object_type = 'P' 
  LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id 
  AND cscart_product_review_prepared_data.storefront_id = 0 
WHERE 
  cscart_products.product_id = 929 
  AND (
    companies.status IN ('A') 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00157

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "6.38"
    },
    "grouping_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_products",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "status"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_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": "4K"
            },
            "used_columns": [
              "product_id",
              "product_code",
              "product_type",
              "status",
              "company_id",
              "list_price",
              "amount",
              "weight",
              "length",
              "width",
              "height",
              "shipping_freight",
              "low_avail_limit",
              "timestamp",
              "updated_timestamp",
              "usergroup_ids",
              "is_edp",
              "edp_shipping",
              "unlimited_download",
              "tracking",
              "free_shipping",
              "zero_price_action",
              "is_pbp",
              "is_op",
              "is_oper",
              "is_returnable",
              "return_period",
              "avail_since",
              "out_of_stock_actions",
              "localization",
              "min_qty",
              "max_qty",
              "qty_step",
              "list_qty_count",
              "tax_ids",
              "age_verification",
              "age_limit",
              "options_type",
              "exceptions_type",
              "details_layout",
              "shipping_params",
              "facebook_obj_type",
              "parent_product_id",
              "buy_now_url",
              "units_in_product",
              "show_price_per_x_units",
              "allow_notes",
              "delivery_time",
              "shopify_product_id",
              "shopify_account_id",
              "shopify_is_parent"
            ]
          }
        },
        {
          "table": {
            "table_name": "popularity",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "total"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_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": "32"
            },
            "used_columns": [
              "product_id",
              "total"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_product_sales",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "pa"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "product_id"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 0,
            "rows_produced_per_join": 1,
            "filtered": "0.00",
            "unique_row_not_found": true,
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "16"
            },
            "used_columns": [
              "category_id",
              "product_id",
              "amount"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_product_prices",
            "access_type": "ref",
            "possible_keys": [
              "usergroup",
              "product_id",
              "lower_limit",
              "usergroup_id"
            ],
            "key": "product_id",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "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": "24"
            },
            "used_columns": [
              "product_id",
              "price",
              "percentage_discount",
              "lower_limit",
              "usergroup_id"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`wearethehelpful_scalesta_net`.`cscart_product_prices`.`lower_limit` = 1) and (`wearethehelpful_scalesta_net`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
          }
        },
        {
          "table": {
            "table_name": "cscart_product_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "product_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_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.45",
              "data_read_per_join": "4K"
            },
            "used_columns": [
              "product_id",
              "lang_code",
              "product",
              "shortname",
              "short_description",
              "full_description",
              "meta_keywords",
              "meta_description",
              "search_words",
              "page_title",
              "age_warning_message",
              "promo_text",
              "unit_name"
            ]
          }
        },
        {
          "table": {
            "table_name": "company_descr",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "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.55",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "i18n_company"
            ]
          }
        },
        {
          "table": {
            "table_name": "companies",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "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.65",
              "data_read_per_join": "6K"
            },
            "used_columns": [
              "company_id",
              "status"
            ],
            "attached_condition": "<if>(found_match(companies), ((`wearethehelpful_scalesta_net`.`companies`.`status` = 'A') or false), true)"
          }
        },
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "pt"
            ],
            "key": "pt",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 12,
            "rows_produced_per_join": 12,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "3.00",
              "eval_cost": "1.20",
              "prefix_cost": "4.85",
              "data_read_per_join": "192"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type",
              "category_position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "wearethehelpful_scalesta_net.cscart_products_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.06",
              "prefix_cost": "6.05",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "category_id",
              "storefront_id",
              "usergroup_ids",
              "status"
            ],
            "attached_condition": "((`wearethehelpful_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`wearethehelpful_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
          }
        },
        {
          "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": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.15",
              "eval_cost": "0.06",
              "prefix_cost": "6.26",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "name",
              "object_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_discussion",
            "access_type": "const",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.06",
              "prefix_cost": "6.32",
              "data_read_per_join": "14"
            },
            "used_columns": [
              "object_id",
              "object_type",
              "type"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_product_review_prepared_data",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id",
              "storefront_id"
            ],
            "key_length": "7",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.06",
              "prefix_cost": "6.38",
              "data_read_per_join": "9"
            },
            "used_columns": [
              "product_id",
              "storefront_id",
              "average_rating",
              "reviews_count"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params facebook_obj_type parent_product_id buy_now_url units_in_product show_price_per_x_units allow_notes delivery_time shopify_product_id shopify_account_id shopify_is_parent lang_code product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message promo_text unit_name price category_ids popularity company_name sales_amount seo_name seo_path discussion_type average_rating product_reviews_count
929 P A 16 0.00 5 0.000 0 0 0 0.00 0 1737066198 1769213363 0 N N N Y N N N N 10 0 N 6 N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 0.000 0.000 N 0 0 0 Y en Food Doula 7 Day Postpartum Food Support <p>Nourishing, ready-made meals, snacks, and herbal support designed to support recovery in the early days after birth - when cooking feels impossible and nourishment matters most.</p> <h2>Food Doula 7 Day Postpartum Food Support&nbsp;</h2> <p><em>Nourishing, ready-made food designed to support recovery, energy, and replenishment when cooking feels impossible in the early days after birth.</em></p> <h5></h5> <h3></h3> <h3>What this support is for</h3> <p>The first days after birth are physically demanding and emotionally full, and eating well often falls to the bottom of the list. This 7-day postpartum food support package provides nourishing, ready-made meals, snacks, and herbal support designed to support recovery, energy, and replenishment when cooking feels impossible. It’s practical, comforting support that removes decisions and genuinely lightens the load.</p> <p><br></p> <p><br></p> <hr> <h5></h5> <h3>When this gift helps</h3> <ul><li>In the first days or weeks after birth </li><li>Following any type of birth including a caesarean or difficult delivery </li><li>When exhaustion, recovery, and feeding leave little capacity to cook </li><li>As a thoughtful alternative to flowers or baby clothes </li><li>When you want to offer real, practical care to a new mother</li></ul> <h5></h5> <hr> <h5></h5> <h3>Why this support is helpful</h3> <p>After birth, the body needs warmth, nourishment, and consistency - not complicated plans or extra effort. This 7-day food support is designed by a Food Doula with postpartum recovery in mind, using nourishing ingredients to support healing, energy, and replenishment during a physically and emotionally demanding time.</p> <p>By providing ready-made meals, snacks, and herbal support for a full week, this support:</p> <ul><li>Removes the daily question of “what should I eat?” </li><li>Supports sustained energy and recovery when sleep is limited </li><li>Helps regulate digestion, warmth, and appetite </li><li>Reduces decision-making at a time when capacity is low </li></ul> <p>This is practical nourishment designed to meet real postpartum needs without pressure, planning, or expectation.</p> <h5></h5> <hr> <h5></h5> <h3>What’s included</h3> <p>This 7-day postpartum food support package provides nourishing meals, snacks, and herbal support designed to support recovery, energy, and replenishment in the early weeks after birth.&nbsp; Your 7-day menu includes:</p> <h5><strong><br></strong></h5> <p><strong>Morning ritual</strong></p> <ul><li>Postpartum Herbal Tonic Tea Blend A nutritive loose-leaf herbal blend to begin each day, supporting digestion, healing, and calm. Designed to gently ground the body and mind during postpartum recovery. </li></ul> <p><strong><br></strong></p> <p><strong>Daily snack</strong></p> <ul><li>Bliss ball goodness A nourishing daily snack designed to support energy levels and gently support hormonal balance. </li></ul> <p><strong><br></strong></p> <p><strong>Main meals (available for 1 or 2 people):</strong></p><ul><li>2 x Golden Turmeric & Ginger Kitchari w/ A Warming Ghee Tarka</li><li>2 x Black Sesame Congee w/ Shitake, Greens & Kombu Lemon</li><li>2 x Lemon Tarka Dahl w/ Star Anise, Curry Leaf & Fennel</li><li>2 x Slow Braised Beef, Tomato & Almond Ragu w/ Soft Herbs</li><li>2 x Coconut Almond Masala w/ Green Lentils & Greens</li><li>2 x Green Laska Broth w/ Tofu, Miso & Pumpkin Seeds</li><li>2 x Ancho Chicken & Black Bean Birria w/ Nettle & Lime</li></ul> <p><br></p><p>When ordering for two people, you’ll receive double the menu above.&nbsp; All meals are thoughtfully balanced and designed to be easy to heat and eat when energy is low and nourishment matters most.</p> <p><br></p> <p><strong>Resources and Personal Support</strong></p> <p>You will also receive a Postpartum Focus Foods Fridge Chart, a reference for you and loved ones to weave the most nourishing postpartum foods into your meals, drinks & snacks when your food doula support has finished and for the inbetweens. A Nourishment check in with The Food Doula. We will message you within 6 weeks of your bundle arriving to see how you are navigating nourishing yourself, offering recipes, tips, practical advice & signposting, for adding in more of what will make you feel good.</p> <p><br></p> <hr> <h5></h5> <h3>Who this is ideal for</h3> <ul><li>New mothers in the early postpartum period </li><li>Women recovering from birth who need nourishment without effort </li><li>Partners, friends, or family wanting to offer meaningful support </li><li>Anyone wanting to help, support and offer care in a real way </li></ul> <h5></h5> <hr> <h5></h5> <h3>Practical details</h3> <p><strong>Delivery timing:</strong> We recommend scheduling delivery 3–4 weeks before your due date, allowing meals to be stored in the freezer and ready to nourish you as soon as baby arrives.&nbsp; For example: if you’re due in August, a July delivery is ideal.</p> <p><strong>Storage:</strong> Meals are suitable for refrigeration or freezing. Storage guidance is provided on delivery.</p> <p><strong>Dietary information:</strong> Please check individual meal listings for allergen and dietary details.</p> <p><strong>Gifting:</strong> This support can be sent directly to the recipient, with the option to include a gift note at checkout.</p> <h5></h5> <hr> <h5></h5> <h3>Companion notes: why this support matters</h3> <p>In the days after birth, support is often offered but not always in ways that truly help. This food support tends to land as relief. It says: you’re looked after, you don’t need to think, and you don’t need to manage anyone else right now.</p> <p>It’s especially meaningful because it doesn’t arrive with advice, expectations, or the need for conversation. Instead, it offers quiet, steady care; the kind that’s felt long after the meals are finished.</p> <p>For many women, this support becomes a daily anchor during an intense and vulnerable transition.</p> <p><em><br></em></p> <p><em>Your thought here is a lovely one; choosing practical support during a tender moment is often the most thoughtful thing you can do.&nbsp;&nbsp;</em></p> <h5></h5> <hr> <h5></h5> <h5><em>Please note</em></h5> <p><em>Please remember that this support is designed to complement postpartum care, not replace medical or professional advice. If there are specific dietary needs, allergies, or medical considerations, please check suitability before ordering.</em></p> <h5></h5> Gift, Self care gift, UK, gifts for new Mum, gifts for pregnant women, baby shower gifts, not flowers, The Food Doula, Get Well gifts, recovery gifts, wellbeing gifts, healthy gift, nourish, Nourishing food UK, healthy food delivery UK Food Doula 7 Day Postpartum Food Support <p><span style="font-size: 16px;"></span></p><p>Nourishing, ready-made food designed to support recovery, energy, and replenishment when cooking feels impossible in the early days after birth.</p><p><span style="font-size: 16px;"></span></p> <p><span style="color: var(--redactor2-text-color);"><em></em></span></p> 280.00000000 265M,268,269,276,288,294,297,298,300,301,267,271,314 3119 The Food Doula food-doula-7-day-postpartum-food-support 265 D