
# Get the site id
select id into @siteId from site limit 1;

INSERT INTO `page` (`site_id`, `image_id`, `title`, `name`, `description`, `cache`, `parent_page_id`, `previous_page_id`, `next_page_id`, `sitemap_priority`, `sitemap_frequency`, `sitemap_lastmod`, `menu_order`, `include_on_menu`)
VALUES
(@siteId, NULL, 'The Betway Kachy Stakes | Lingfield Park', '/racing-highlights/the-betway-kachy-stakes/', 'The Betway Kachy Stakes', '<?xml version=\"1.0\" encoding=\"utf8\"?>\n<!DOCTYPE content [\n<!ELEMENT content (module | modal)*>\n<!ELEMENT module (#PCDATA)>\n<!ELEMENT modal (#PCDATA)>\n<!ATTLIST module key CDATA #REQUIRED>\n<!ATTLIST module type CDATA #REQUIRED>\n<!ATTLIST modal key CDATA #REQUIRED>\n]>\n<content><module key=\"b3a4ad68-85dc-4f66-acb3-aae97fe6669c\" type=\"page-hero\"><![CDATA[{\"template_name\":\"page-hero\",\"data\":{\"items\":[{\"image\":{\"id\":\"217\",\"filename\":\"2901d61d-1a1d-4b1f-9d00-ef9b550f3f0b.jpg\",\"show_placeholder\":true,\"alt\":\"horses racing in snow\",\"tablet_land\":{\"id\":\"218\",\"filename\":\"99bd3435-256d-4f1b-95c3-5a4ed1172d84.jpg\",\"alt\":\"horses racing in snow\"},\"tablet_port\":{\"id\":\"220\",\"filename\":\"e5893eba-84d7-447b-b32a-5d662235a42b.jpg\",\"alt\":\"horses racing in snow\"},\"mobile\":{\"id\":\"219\",\"filename\":\"65771040-bad7-4443-b248-7d9bb7f83bce.jpg\",\"alt\":\"horses racing in snow\"}},\"title\":{\"text\":\"Winter Racing\",\"visible\":true},\"subtitle\":{\"text\":\"A true test of skill.\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA Button\",\"url\":\"\\/\",\"target\":\"_self\",\"visible\":false}}]},\"block_type\":\"page-hero\"}]]></module><module key=\"deb11497-c6cf-4572-a618-fd1bf58bd0d5\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-intro-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"The Winter Derby At Lingfield Races\",\"visible\":\"true\"},\"content\":{\"text\":\"Established in 1998, the Winter Derby is a flat horse race run at Lingfield Park during February - March each year, and is open to horses aged 4 and over.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"This is paragraph text.\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image50land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image75\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"24668286-53d3-44e9-8828-0a8eeba9bc79\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-txt50-img50_1sqr\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"What Is The Winter Derby?\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p>Open to horses aged 4 and over, the race is run over one mile and two furlongs. It also doubles up as a Fast-Track Qualifier for the Coral Middle Distance Category All-Weather Championships, with the winner securing their place on Finals Day.<\\/p>\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":\"221\",\"filename\":\"3d747c51-f7d9-4e3c-834c-eacd77f09bf4.jpg\",\"alt\":\"snowing during horse race\",\"tablet_land\":{\"id\":\"222\",\"filename\":\"49005aa1-26cd-457e-856a-5e91e577403b.jpg\",\"alt\":\"snowing during horse race\"},\"tablet_port\":{\"id\":\"224\",\"filename\":\"64330f25-d876-462e-a82a-12650ac20cce.jpg\",\"alt\":\"snowing during horse race\"},\"mobile\":{\"id\":\"223\",\"filename\":\"ff6e68ac-d8f8-4a9e-9634-2325ffb771a4.jpg\",\"alt\":\"snowing during horse race\"}},\"image50land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image75\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"21ed6a70-767f-48da-815a-43c12a4fc9a4\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-img50_1sqr-txt50\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Who Has Won Before?\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p>Previous winning horses include Convey, Grendisar and Tryster. There have been four jockeys who have won twice (Richard Hughes, Frankie Dettori, Adam Kirby and Andrea Atzeni), and 1 trainer who has won twice (Clive Brittain).<\\/p>\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":\"941\",\"filename\":\"d1b21c35-2305-41b0-bcd4-25e5097c799a.jpg\",\"alt\":\"Jockey riding in Winter Derby at Lingfield Park\",\"tablet_land\":{\"id\":\"944\",\"filename\":\"1b1ca3c3-fd7f-44d0-8097-6da6ff29d144.jpg\",\"alt\":\"Jockey riding in Winter Derby at Lingfield Park\"},\"tablet_port\":{\"id\":\"943\",\"filename\":\"8e765768-d963-4f1c-96ee-8d6226ca3303.jpg\",\"alt\":\"Jockey riding in Winter Derby at Lingfield Park\"},\"mobile\":{\"id\":\"942\",\"filename\":\"0f2c7e23-4d4a-418d-a173-4d220c5ff289.jpg\",\"alt\":\"Jockey riding in Winter Derby at Lingfield Park\"}},\"image50land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image75\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"9b82c6b4-6fb5-47fa-bf2d-458f7efb53fd\" type=\"key-facts\"><![CDATA[{\"template_name\":\"key-facts-center\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Title\",\"visible\":false},\"content\":{\"text\":\"Content\",\"visible\":false},\"items\":[{\"icon\":{\"name\":\"icon-15-racecourses\",\"visible\":false},\"title\":{\"text\":\"Want To Join Us?\",\"visible\":false},\"content\":{\"text\":\"The tickets for the next Winter Derby will be available in late 2019. In the meantime, why not take a look at our other upcom\",\"visible\":false},\"cta\":{\"label\":\"View Calendar\",\"url\":\"\\/whats-on\\/\",\"target\":\"_self\",\"visible\":false}}]},\"block_type\":\"key-facts\"}]]></module><module key=\"27fefb04-9980-4f2b-9c6c-6b5cbe350e5e\" type=\"salesforce-form\">{\"template_name\":\"salesforce-form-pre-newsletter\",\"template_inverse\":true}</module></content>\n', 0, 0, 0, 0.9, 'monthly', NULL, 0, 1);

UPDATE `site_global`
SET `data` = '
{
  "template": {
    "name": "dark",
    "whatson": true
  },
  "evergreenPages": [
    {
      "heading": "Racing Highlights",
      "items": [
        {
          "title": "All-Weather Championships",
          "slug": "/racing-highlights/all-weather-championships/"
        },
        {
          "title": "The Silk Series",
          "slug": "/racing-highlights/silk-series/"
        },
        {
          "title": "The Winter Derby",
          "slug": "/racing-highlights/the-winter-derby/"
        },
        {
          "title": "The Derby Trial",
          "slug": "/racing-highlights/the-derby-trial/"
        },
        {
          "title": "Churchill Stakes",
          "slug": "/racing-highlights/churchill-stakes/"
        },
        {
          "title": "The Betway Kachy Stakes",
          "slug": "/racing-highlights/the-betway-kachy-stakes/"
        }
      ]
    },
    {
      "heading": "Popular Events",
      "items": [
        {
          "title": "Live Music",
          "slug": "/popular-events/live-music/"
        },
        {
          "title": "Ladies Day",
          "slug": "/popular-events/ladies-day/"
        },
        {
          "title": "Family Fun Days",
          "slug": "/popular-events/family-fun-days/"
        },
        {
          "title": "Oktoberfest",
          "slug": "/popular-events/oktoberfest/"
        },
        {
          "title": "Christmas Lunches",
          "slug": "/your-venue/christmas-lunches/"
        }
      ]
    }
  ],
  "menus" : [
    {
      "title": "Raceday <br/>Experience",
      "menu": "raceday-experience",
      "columns": [
        {
          "title":{
            "text": "Raceday Experience",
            "slug": "/raceday-experience/"
          },
          "items": [
            {
              "type": "parent",
              "title": "Dress Code",
              "slug": "/raceday-experience/dress-code/"
            },
            {
              "type": "parent",
              "title": "Food & Drink",
              "slug": "/raceday-experience/food-and-drink/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Get Here",
              "slug": "/raceday-experience/get-here/"
            },
            {
              "type": "parent",
              "title": "Racecourse Map",
              "slug": "/raceday-experience/racecourse-map/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Betting at Lingfield",
              "slug": "/raceday-experience/betting-at-lingfield/"
            },
            {
              "type": "parent",
              "title": "Venue Accessibility",
              "slug": "/raceday-experience/venue-accessibility/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Visiting Safely",
              "slug": "https://www.arenaracingcompany.co.uk/racing/visiting-safely/?site={site}&slug={slug}"
            }
          ]
        }
      ]
    },
    {
      "title": "Restaurants & <br>Hospitality",
      "menu": "restaurants-and-hospitality",
      "url": "/restaurants-and-hospitality/"
    },
    {
      "title": "Hotel",
      "menu": "hotel",
      "columns": [
        {
          "title":{
            "text": "Hotel",
            "slug": "/hotel/"
          },
          "items": [
            {
              "type": "parent",
              "title": "Rooms and Suites",
              "slug": "/hotel/rooms-and-suites/"
            },
            {
              "type": "parent",
              "title": "Business Facilities",
              "slug": "/hotel/business-facilities/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Cyprium Bar and Grill",
              "slug": "/hotel/cyprium-bar-and-grill/"
            }
          ]
        }
      ]
    },
    {
      "title": "Spa",
      "menu": "spa",
      "url": "/spa/"
    },
    {
      "title": "Golf",
      "menu": "golf",
      "columns": [
        {
          "title":{
            "text": "Golf",
            "slug": "/golf/"
          },
          "items": [
            {
              "type": "parent",
              "title": "Golf Fees and Deals",
              "slug": "/golf/golf-fees-and-deals/"
            },
            {
              "type": "parent",
              "title": "Golf Breaks",
              "slug": "/golf/golf-breaks/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Golf Academy",
              "slug": "/golf/golf-academy/"
            },
            {
              "type": "parent",
              "title": "Golf Society Days",
              "slug": "/golf/golf-society-days/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Golf Shop",
              "slug": "/golf/golf-shop/"
            },
            {
              "type": "parent",
              "title": "Golf Membership",
              "slug": "/golf/golf-membership/"
            }
          ]
        }
      ]
    },
    {
      "title": "YourVENUE",
      "menu": "your-venue",
      "columns": [
        {
          "title":{
            "text": "YourVENUE",
            "slug": "/your-venue/"
          },
          "items": [
            {
              "type": "parent",
              "title": "Business Meetings",
              "slug": "/your-venue/business-meetings/"
            },
            {
              "type": "parent",
              "title": "Conferences & Events",
              "slug": "/your-venue/conferences-and-events/"
            },
            {
              "type": "parent",
              "title": "YourVENUE+",
              "slug": "/your-venue/your-venue-plus/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Weddings",
              "slug": "/your-venue/weddings/"
            },
            {
              "type": "parent",
              "title": "Asian Weddings",
              "slug": "/your-venue/asian-weddings/"
            },
            {
              "type": "parent",
              "title": "Parties & Celebrations",
              "slug": "/your-venue/parties-and-celebrations/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Christmas Lunches",
              "slug": "/your-venue/christmas-lunches/"
            }
          ]
        }
      ]
    },
    {
      "title": "Lingfield <br/>Park",
      "menu": "lingfield-park",
      "columns": [
        {
          "title":{
            "text": "Lingfield Park",
            "slug": "/lingfield-park/"
          },
          "items": [
            {
              "type": "parent",
              "title": "History",
              "slug": "/lingfield-park/history/"
            },
            {
              "type": "parent",
              "title": "Meet The Team",
              "slug": "/lingfield-park/meet-the-team/"
            },
            {
              "type": "parent",
              "title": "Careers",
              "slug": "/lingfield-park/careers/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Owners & Trainers",
              "slug": "/lingfield-park/owners-and-trainers/"
            },
            {
              "type": "parent",
              "title": "Gift Vouchers",
              "slug": "/lingfield-park/gift-vouchers/"
            },
            {
              "type": "parent",
              "title": "Membership",
              "slug": "/lingfield-park/membership/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Sponsorship",
              "slug": "/lingfield-park/sponsorship/"
            },
            {
              "type": "parent",
              "title": "Contact Us",
              "slug": "/contact-us/"
            }

          ]
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    }

  ]
}'
WHERE `label` = 'main_menu';


