LOCK TABLES site WRITE, page WRITE;

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, 'Lingfield Hero 2022', '/competitions/lingfield-hero-2022', 'Lingfield Hero 2022', '<?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=\"dd28826f-e1b6-4a65-94af-f432346a6936\" type=\"page-hero\"><![CDATA[{\"template_name\":\"page-hero\",\"data\":{\"items\":[{\"image\":{\"id\":0,\"filename\":\"\",\"show_placeholder\":true,\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"title\":{\"text\":\"Do you know a local hero?\",\"visible\":\"true\"},\"subtitle\":{\"text\":\"Slide 1 subtitle\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA Button\",\"url\":\"/\",\"target\":\"_self\",\"visible\":\"true\"}}]}}]]></module><module key=\"b60197cc-1783-4cbf-9b5a-b74c9c45a0b6\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-intro-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Promo Block Header\",\"visible\":false},\"content\":{\"text\":\"<p>Do you know a local hero? Doncaster Racecourse has launched the search to find the \\u2018Doncaster Hero 2021\\u2019, as we celebrate all that\\u2019s great about \\u2018Donny\\u2019 as part of the famous <a href=\\\"https:\\/\\/www.doncaster-racecourse.co.uk\\/racing-highlights\\/st-leger-festival\\/\\\" target=\\\"_self\\\"><u>Cazoo St Leger Festival<\\/u><\\/a>, taking place 8th \\u2013 11th September 2021.<\\/p><p>All nominees will be entered into a draw to win a pair of 50 available County Tickets to attend the famous <a href=\\\"https:\\/\\/www.doncaster-racecourse.co.uk\\/whats-on\\/doncaster-cup-day\\\" target=\\\"_self\\\"><u>Doncaster Cup Day on Friday 10 September<\\/u><\\/a>. The overall Doncaster Legend 2021 will be invited to celebrate the accolade with hospitality at the event along with nine others, as well as receive \\u00a3500 to be donated to the charity of their choice.<\\/p><p>These are the people who always volunteer, the ones who always say yes, the ones who put the needs of others before their own. &nbsp;<\\/p><p><strong>Submit your Doncaster Hero 2021 nomination by midnight on Wednesday 25 August 2021 below.<\\/strong><\\/p>\",\"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\":\"\"}},\"items\":[]},\"block_type\":\"standard-content\"}]]></module><module key=\"89431b88-b5fc-47b6-9284-7fa78cb0a677\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Promo Block Header\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p>Please tell us why the person you\\u2019re nominating should be the Lingfield Hero 2021 (Limited to 500 characters). Please include their achievements and demonstrate how they have gone above and beyond to help their community.<\\/p>\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":\"true\"},\"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\":\"\"}},\"items\":[]},\"block_type\":\"standard-content\"}]]></module><module key=\"5ef9ba23-9681-4848-b05b-72b2b87c05d7\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Promo Block Header\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p><strong>Terms and conditions:<\\/strong><\\/p><ol><li>All entries must be submitted by midnight on Wednesday 25 August 2021 via the online form.<\\/li><li>Entrants must be a resident in the UK aged 18 or over. If nominating an under 18, you must have the permission of their parent or guardian.<\\/li><li>The competition is free and no purchase is necessary. Only one entry per household.<\\/li><li>Prize. All nominations will be entered into a prize draw to win a pair of 50 County Tickets to attend the Doncaster Cup Day on Friday 10th September 2021. The winners of these tickets will be selected at random and notified via email within seven days of the competition closing. The overall winner awards Doncaster Hero 2021 will receive a table for 10 in The Garden Suite restaurant on Friday 10th September to enjoy a glass of Prosecco on arrival followed by three-course lunch plus afternoon tea alongside a donation to their chosen charity.<\\/li><li>Each Winner will be responsible for all other costs prior to and after fulfilment of the prize, and not otherwise provided herein.<\\/li><li>The Winners of the prize draw will be the first Racecourse Prize Draw entries that are randomly selected by an adjudicator from all the entry submissions received by the Closing Date in respect to the Promotion. The adjudicators decision is final, and no correspondence will be entered into. The Winner\\/s will be notified via email.<\\/li><li>No cash or other alternatives to any Prize is available; and not transferable and cannot be exchanged for cash. Each Prize must be claimed by the person named on the official winning Racecourse Prize Draw submission within 24 hours of notification from the Promoter<\\/li><li>The Racecourse reserves the right to use the name of the entrants for the purpose of publicity without charge, and all entrants hereby consent to the same.<\\/li><li>Events may occur that render the event itself or awarding the Prize impossible due to reasons beyond the control of the Promoter and the entrant agrees that no liability shall be attached to the Promoter as a result thereof. The Promoter reserves the right to offer an alternative Prize of equal value should this prove necessary.<\\/li><li>By entering the Racecourse Prize Draw promotions, all entrants confirm they have read, accepted and agreed to be bound to these Terms and Conditions<\\/li><li>Employees (and their families) of Racecourse, its associated companies, its retailers and agencies are not eligible for entry.<\\/li><\\/ol>\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":\"true\"},\"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\":\"\"}},\"items\":[]},\"block_type\":\"standard-content\"}]]></module></content>\n', 0, 0, 0, 0.9, 'monthly', NULL, 0, 1);

UNLOCK TABLES;
