
# URL and title change in the page table
update `page`
set `name` = '/our-racecourse/lansdown-live/', `description` = 'Lansdown Live'
where `name` = '/our-racecourse/live-on-the-lawn/';

# URL change in the mega menu
update `site_global`
set `data` = '
{
  "template": {
    "name": "light"
  },
  "menus": [
    {
      "title": "Plan Your Visit",
      "menu": "plan-your-visit",
      "slug": "/plan-your-visit/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Plan Your Visit",
              "slug": "/plan-your-visit/"
            },
            {
              "type": "parent",
              "title": "New Racegoers Guide",
              "slug": "/plan-your-visit/new-racegoers-guide/"
            },
            {
              "type": "parent",
              "title": "Get Here",
              "slug": "/plan-your-visit/get-here/"
            },
            {
              "type": "parent",
              "title": "Tickets & Packages",
              "slug": "/plan-your-visit/tickets-and-packages/"
            },
            {
              "type": "parent",
              "title": "Rewards4Racing",
              "slug": "/plan-your-visit/rewards4racing/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Food & Drink",
              "slug": "/plan-your-visit/food-and-drink/"
            },
            {
              "type": "parent",
              "title": "Venue Etiquette",
              "slug": "/plan-your-visit/venue-etiquette/"
            },
            {
              "type": "parent",
              "title": "Venue Accessibility ",
              "slug": "/plan-your-visit/venue-accessibility/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Racecourse Map",
              "slug": "/plan-your-visit/racecourse-map/"
            },
            {
              "type": "parent",
              "title": "Where To Stay",
              "slug": "/plan-your-visit/where-to-stay/"
            },
     	    {
              "type": "parent",
              "title": "Around Bath",
              "slug": "/plan-your-visit/around-bath/"
            }


          ]
        }
      ]
    },
    {
      "title": "Restaurants </br>& Hospitality",
      "menu": "hospitality",
      "slug": "/restaurants-and-hospitality/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Restaurants & Hospitality",
              "slug": "/restaurants-and-hospitality/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Raceday Hospitality",
              "slug": "/restaurants-and-hospitality/raceday-hospitality/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Executive Suites",
              "slug": "/restaurants-and-hospitality/executive-suites/"
            }

          ]
        }
      ]
    },
    {
      "title": "Hire Our Venue",
      "menu": "hire-our-venue",
      "slug": "/hire-our-venue/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Hire Our Venue",
              "slug": "/hire-our-venue/"
            },
            {
              "type": "parent",
              "title": "Hire For Business",
              "slug": "/hire-our-venue/hire-for-business/"
            },
            {
              "type": "child",
              "title": "Conferences & Meetings",
              "slug": "/hire-our-venue/hire-for-business/conferences-and-meetings/"
            },
            {
              "type": "child",
              "title": "Exhibitions & Fairs",
              "slug": "/hire-our-venue/hire-for-business/exhibitions-and-fairs/"
            },
            {
              "type": "child",
              "title": "Seminars & Training Sessions",
              "slug": "/hire-our-venue/hire-for-business/seminars-and-training-sessions/"
            },
            {
              "type": "child",
              "title": "Banquets & Awards",
              "slug": "/hire-our-venue/hire-for-business/banquets-and-awards/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Hire For Celebration",
              "slug": "/hire-our-venue/hire-for-celebration/"
            },
            {
              "type": "child",
              "title": "Weddings",
              "slug": "/hire-our-venue/hire-for-celebration/weddings/"
            },
            {
              "type": "child",
              "title": "Wedding Packages & Prices",
              "slug": "/hire-our-venue/hire-for-celebration/wedding-packages-and-prices/"
            },
            {
              "type": "child",
              "title": "Christmas Parties",
              "slug": "/hire-our-venue/hire-for-celebration/christmas-parties/"
            },
            {
              "type": "child",
              "title": "Parties & Dinners",
              "slug": "/hire-our-venue/hire-for-celebration/parties-and-dinners/"
            },
            {
              "type": "child",
              "title": "Celebration of Life",
              "slug": "/hire-our-venue/hire-for-celebration/celebration-of-life/"
            }

          ]
        },
        {
          "items": [
        {
              "type": "parent",
              "title": "Outdoor Events",
              "slug": "/hire-our-venue/outdoor-events/"
            }

          ]
        }

      ]
    },
    {
      "title": "Our Racecourse",
      "menu": "our-racecourse",
      "slug": "/our-racecourse/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Our Racecourse",
              "slug": "/our-racecourse/"
            },
            {
              "type": "parent",
              "title": "About Us",
              "slug": "/our-racecourse/about-us/"
            },
             {
              "type": "parent",
              "title": "Annual Membership",
              "slug": "/our-racecourse/annual-membership/"
            },
             {
              "type": "parent",
              "title": "Lansdown Live",
              "slug": "/our-racecourse/lansdown-live/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Competitions",
              "slug": "/our-racecourse/competitions/"
            },
	   {
              "type": "parent",
              "title": "Sponsorship & Advertising",
              "slug": "/our-racecourse/sponsorship-and-advertising/"
            },
            {
              "type": "parent",
              "title": "Official Partners",
              "slug": "/our-racecourse/official-partners/"
            },
            {
              "type": "parent",
              "title": "Join Our Team",
              "slug": "/our-racecourse/join-our-team/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Owners & Trainers",
              "slug": "/our-racecourse/owners-and-trainers/"
            },
            {
              "type": "parent",
              "title": "Equine Welfare",
              "slug": "/our-racecourse/equine-welfare/"
            }
          ]
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    },
    {
      "title": "Contact Us",
      "menu": "contact-us",
      "url": "/contact-us/"
    }
  ]
}'
where `label` = 'main_menu';

