LOCK TABLES `news_article` WRITE, `site` WRITE, `news_article_category` WRITE, `user` WRITE, `site_user` WRITE, `seo_data` WRITE, `article_seo` WRITE;

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

# Get site user
select id into @userId
from user
where email_address = 'sheath@arenaracingcompany.co.uk';

select id
from site_user
where user_id = @userId;

# Get racing category
select id into @categoryId
from news_article_category
where slug = 'racing';

# Insert article
INSERT INTO `news_article` ( `site_id`, `site_user_id`, `news_article_category_id`, `created_date`, `published_date`, `title`, `slug`, `content`, `published`, `featured`)
VALUES
(@siteId, @userId, @categoryId, '2021-03-08 09:45:26', '2021-03-08 09:46:13', 'What To Expect – 17 May to 20 June FAQs', 'what-to-expect-17-may-to-20-june-faqs', '<h3>Welcoming You Back!<br>Fixtures taking place from 17th May – 20th June 2021</h3><p>Thank you for supporting the return of racegoers to Uttoxeter Racecourse.</p><p>With social distancing still in place during this time, we have put in place a range of new safety measures to welcome back spectators in a Covid-secure way.</p><p>We ask everybody to work together along with our staff and stewards to ensure a safe and thoroughly enjoyable event for all.</p><p><strong>Before you arrive</strong><br>Your responsibilities as a spectator, are as follows;</p><ul><li>If you display any Covid 19 symptoms on the day you are due to attend the racecourse or are required to self-isolate, please email, <a href=\"mailto:info@uttoxeter-racecourse.co.uk \">info@uttoxeter-racecourse.co.uk</a> to receive a transfer or full refund. You cannot attend the meeting if displaying Covid symptoms, neither can any member of your social bubble or household.</li><li>All guests MUST adhere to the requirements of the racecourse Code Of Conduct and all social distancing protocols</li><li>Ensure you have completed the test and trace requirements.</li></ul><p><strong>How do I book tickets and are there any restrictions?</strong></p><p>All tickets must be booked online and must be booked in advance for fixtures taking place between 17th May until 20th June 2021. We are unable to sell tickets on the gate. Advance tickets close at midnight the day before racing (or when capacity has been reached).</p><p>Government rules and regulations on household mixing apply. Therefore, you can only attend the racecourse:</p><ul><li>As a maximum of two separate households (proof of address may be requested)</li><li>As a group of six from different households</li></ul><p>From 17th May, there are no limits on how many people can meet outside. Therefore, you may attend in larger groups outside only. However, indoors remain as either a ‘rule of six or a maximum of two households.</p><p>Everyone who attends must complete the NHS Track &amp; Trace details at the checkout.</p><p><strong>How do I book a table in the restaurant or a hospitality facility?</strong></p><p>All restaurant and hospitality bookings must be made in advance.</p><p>Our available restaurant packages will be available online only.</p><p>For any private hospitality bookings, please contact us to discuss:<br><a href=\"mailto:racingnorth@arenaracingcompany.co.uk\">racingnorth@arenaracingcompany.co.uk</a> | Tel: 01302 499 732</p><p><strong>What should I expect when I arrive at the course?</strong><br>When arriving at the racecourse, please have your photo ID and e-ticket ready to be checked. We also ask customers to maintain social distancing if having to queue.</p><p>Only customers who have booked or registered for their ticket in advance will be allowed to enter the racecourse.</p><p>Face masks will be compulsory (unless medically exempt) throughout the event except whilst eating or drinking.&nbsp;</p><p>Please be aware that your temperature may be taken upon entry.</p><p><strong>How to get to the racecourse?</strong><br>You can arrive at the racecourse on foot, by public transport and by car with your own household or support bubble.</p><p>Spectators are encouraged to use private transport where possible.<br><br><a href=\"/raceday-experience/get-here/\">Please check our ‘how to find us’ page for more information.</a><br><br><strong>What can I/can’t I bring with me?&nbsp;</strong><br>Everyone attending must ensure they bring with them:</p><ul><li>Your e-ticket. This can either be printed or shown on your phone</li><li>Photographic ID to gain access with your ticket</li><li>A face mask&nbsp;</li></ul><p><br>Please keep bags no larger than A4 size. Please be aware that no food or drink can be brought into the racecourse.</p><p><br><strong>What shall I wear?</strong><br>This is an outdoor event with limited indoor facilities therefore please dress accordingly and for the weather/time of year.&nbsp;With current dress codes relaxed during this period, we do still ask that guests in either hospitality or the restaurant opt for a smart-casual attire. We politely request that no sportswear is worn.</p><p><strong>What time shall I arrive?</strong><br>Please check the website for the most up-to-date times. Gates normally open two-hours before the first race. Please allow extra time for entry as there may be delays for ID and other checks due to Covid-19 Regulations.&nbsp;</p><p>You may be asked to arrive at the racecourse within a specific timeslot. If required, this information will clearly be shown on you e-ticket confirmation email.</p><p><strong>What security measures should I expect?</strong><br>You may be subject to a bag search on arrival. Please ensure bags are no larger than A4 size as these will not be permitted.</p><p>Please be aware that only food and drink purchased at the racecourse can be consumed whilst visiting. No food or drink can be brought into the racecourse.</p><p><strong>What food and drink will be available?</strong><br>A range of non-alcoholic drinks and food can be purchased from our outlets in accordance with the Code Of Conduct.&nbsp;<br>Alcohol can only be served alongside a substantial meal and only when seated. A range of food and substantial meals will be available to purchase on the day.&nbsp;<br>We have taken steps to reduce queues for ordering and ensure social distancing is maintained at all times.&nbsp;</p><ul><li>Rule of Six applies OR a maximum of two separate households to groups in all inside areas</li><li>Card payment only (no cash option)</li><li>Bars close before the penultimate race. &nbsp;</li></ul><p><br><strong>Can I smoke?</strong><br>If you smoke, please use the designated smoking circles on the lawns.&nbsp;</p><p><strong>Can I still buy a racecard?</strong><br>As a Covid secure venue, we are unable to provide any printed material including racecards. Racecards will be available to view via our social media channels as well as emailed prior to the fixture you are attending.</p><p><strong>Are you accepting cash payments?</strong><br>The racecourse will operate as a cashless venue and we will only be accepting card payments at our bars and payment points.</p><p>The only outlet that will accept cash is the on-course Bookmakers.</p><p>Our ATM’s will not be in operation, so if you wish to place a cash bet with a bookmaker please bring this with you. The tote accepts debit card payments (not credit card).</p><p><strong>Can I place a bet?</strong></p><p>We are delighted to welcome back Tote betting on-course.</p><p>There will be Tote kiosks throughout the racecourse offering the full range of bets on all UK and Irish racing.</p><p>Bets can be placed via debit card or via mobile, though a cash service with the Tote will be available if needed. You also have the option to bet with the Tote website on your mobile phone or use the on-course bookmakers.</p><p><strong>How do I leave the racecourse?</strong><br>Please be considerate to all those leaving and maintain social distancing. We request that you leave the racecourse and make your way safely directly home.</p><p>Thank you for your support. We are looking forward to welcoming back racegoers to once again enjoy watching exciting live horse racing.</p><p><br><a href=\"/whats-on\">Click here for tickets and what’s on.</a></p>', 1, 0);

# Get the article id
SELECT LAST_INSERT_ID() into @articleId;

# Insert article SEO
INSERT INTO `seo_data` (`description`, `cannonical_tag`)
VALUES
	('Thank you for supporting the return of racegoers to Uttoxeter Racecourse.', 'https://www.uttoxeter-racecourse.co.uk/news/racing/what-to-expect-17-may-to-20-june-faqs/');

# Get the seo id
SELECT LAST_INSERT_ID() into @seoId;

# Link the seo with the article
INSERT INTO `article_seo` ( `news_article_id`, `seo_data_id`)
VALUES
	(@articleId, @seoId);

UNLOCK TABLES;