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, 'Royal Box Competition', '/competitions/royal-box-competition', 'Royal Box Competition', '<?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>\n\n<module key=\"dd28826f-e1b6-4a65-94af-f432346a6936\" type=\"page-hero\"><![CDATA[{\"template_name\":\"page-hero\",\"data\":{\"items\":[{\"image\":{\"id\":\"4285\",\"filename\":\"68e9fb13-0f5c-43c8-9d82-b7d6cf211d59.jpg\",\"show_placeholder\":true,\"alt\":\"Hosp\",\"tablet_land\":{\"id\":\"4286\",\"filename\":\"d1a995b3-efd9-4e61-91d4-0370092aca5b.jpg\",\"alt\":\"Hosp\"},\"tablet_port\":{\"id\":\"4288\",\"filename\":\"9aea9fe4-653a-4d1b-992b-53c31086f9b6.jpg\",\"alt\":\"Hosp\"},\"mobile\":{\"id\":\"4287\",\"filename\":\"6afad111-477a-425d-94f7-7a180e675666.jpg\",\"alt\":\"Hosp\"}},\"title\":{\"text\":\"Sign up to win our Royal Box for the day\",\"visible\":\"true\"},\"subtitle\":{\"text\":\"on Saturday 4th June\\u00a0\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA Button\",\"url\":\"\\/\",\"target\":\"_self\",\"visible\":false}}]},\"block_type\":\"page-hero\"}]]></module>\n\n<module key=\"b60197cc-1783-4cbf-9b5a-b74c9c45a0b6\" 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\":\"<h4><strong>HUGE GIVEAWAY!&nbsp;<\\/strong><\\/h4><p>Be Queen or King for a Day in our Royal Box and we\\u2019ll treat you like Royalty at our Platinum Jubilee Raceday on Saturday 4th June<\\/p><p>Prize includes:<\\/p><ul><li>Exclusive use of the Royal Box for the day for 10 people (additional guests can be paid for)<\\/li><li>Balcony<\\/li><li>3-course plated menu<\\/li><li>Pay as you go private bar<\\/li><li>Racecards<\\/li><li>Tipster<\\/li><\\/ul><p>All you have to do to enter is answer the following question:<\\/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\":\"\"}},\"image100fine\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module>\n\n\n<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\":\"<h4><strong>Terms &amp; Conditions<\\/strong><\\/h4><p>Prize includes:<\\/p><ul><li>Exclusive use of the Royal Box for the day for 10 people (additional guests can be paid for)<\\/li><li>Balcony<\\/li><li>3-course plated menu<\\/li><li>Pay as you go private bar<\\/li><li>Racecards<\\/li><li>Tipster<\\/li><\\/ul><ol><li>The Competition is open to UK and Irish residents only, who are aged 18 years and over.<\\/li><li>Employees\\/personnel of Arena Leisure Racing Ltd and their groups of companies are not eligible to enter the Competition.<\\/li><li>Entries will close at midnight GMT on Wednesday 18th May.<\\/li><li>By entering this competition you are agreeing to receive email marketing from Arena Racing Company. &nbsp;<\\/li><li>One entry is permitted per person and no more than four entries per household. In the event of a household submitting more than four entries, ALL entries from that household will be void. The winner will be selected by random from all valid entries submitted on the website before the closing date and time.<\\/li><li>The prize is for 10 people and includes hospitality in our royal box on Saturday 4th June - Prize valid for these dates only and cannot be transferred to any other day.<\\/li><li>Incomplete entries will be void.<\\/li><li>The winner will be notified by email by Wednesday 18th May 2022 and given details of how to claim his\\/her prize. If a winner does not respond to the Promoters within 24 hours of being notified, then the winner\\u2019s prize will be forfeited. The winner, whose prize has been forfeited, is not entitled to payment or compensation of any kind.<\\/li><li>The prize is non-exchangeable, non-transferable, non-endorsable and is not redeemable for cash or other prizes. Arena Racing Company retains the right to substitute the prize with another prize of similar value in the event the original prize offered is not available.<\\/li><li>Arena Racing Company shall not be responsible for lost or misdirected messages, unavailable network connections, failed incomplete, garbled or delayed computer transmissions, online failures, hardware, software or other communications failures or circumstances affecting receipt or entrants ability to participate in the Competition or if any racing or any other event applicable to the Competition is cancelled for any reason or any circumstances affecting a winner\\u2019s ability to access or use their prize or for any reasons of Force Majeure.<ol><li>\\\"Event of Force Majeure\\\" means: a fire, flood, lightning, storm, earthquake or other similar geological or metrological event or condition or Act of God, national emergency, diseases, epidemic, pandemic, war, act of terrorism, riot or criminal act or damage, strike, lockout or other industrial action not involving the employees of the affected Party (to the extent such failure is beyond the reasonable control of the affected Party) or any other event beyond the control of a Party. The Parties acknowledge and agree that any disruption caused by the outbreak of coronavirus (COVID-19) or similar diseases (such as the temporary or permanent closure of the venues) shall constitute an Event of Force Majeure.<\\/li><\\/ol><\\/li><li>The entrant consents to the use of their name, voice, photographs and\\/or other likenesses for advertising or publicity purposes without additional compensation. Your personal information will be treated in accordance with the Privacy Policy accessible <a href=\\\"\\/privacy-policy\\/\\\" target=\\\"_self\\\">here<\\/a>. From time to time, Arena Racing Company may send you details of its products, services (and those of selected marketing partners) and\\/or Competitions. You can unsubscribe from this information service at any time.<\\/li><li>Details of the prize are included in the information about the Competition.<\\/li><li>All components of the prize must be taken together.<\\/li><li>The prize winner and his\\/her prize companion must comply with the terms and conditions of the venues involved in the provision of the prize. In particular, the winner and his\\/her prize companion must comply with all health and safety guidelines and instructions and all applicable legal and regulatory requirements.<\\/li><li>By entering the Competition, all participants will be deemed to have accepted and be bound by these terms and conditions and by any other requirements set out in the information about the Competition.<\\/li><li>These terms and conditions shall be governed by English Law and the parties submit to the exclusive jurisdiction of the English courts.<\\/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\":\"\"}},\"image100fine\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module>\n\n</content>\n', 0, 0, 0, 0, '', NULL, 0, 1);

UNLOCK TABLES;