(4,'','','competition-2014-03-24-11-22-56.jpg','','','','<p>\r\n	<strong>Simply enter to win a tropical holiday staying at Oaks Lagoons, Port Douglas.</strong></p>\r\n<p>\r\n	Win four relaxing nights staying in a one bedroom deluxe apartment at Oaks Lagoons, Port Douglas including a complimentary bottle of wine on arrival, 12pm late check-out, 1 day free bike hire and daily use of pool towel valued at $942.</p>\r\n<p>\r\n	Increase your chance of winning just by telling your friends!</p>\r\n','<ul>\r\n	<li>\r\n		Prize is a four nights accommodation for two people staying at Oaks Lagoons, Port Douglas in a one bedroom deluxe apartment. Includes a complimentary bottle of wine on arrival, 12pm late check-out, 1 day free bike hire and daily use of pool towel.</li>\r\n	<li>\r\n		Prize is valued at $942</li>\r\n	<li>\r\n		The Competition starts 26/03/14 and ends 12am 07/04/14 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 07/04/14.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland Facebook page or website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Facebook entry: Entrants must fill out the form supplied on the Discover Queensland Facebook App. Entrants who refer friends to the competition by sharing the SUPPLIED link will receive one additional entry for each referred person.</li>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 07/04/14. A re-draw will take place on 10/06/14 if prize winner is not able to be contacted within 60 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n<p>\r\n	<br />\r\n	<strong>Conditions of Entry</strong></p>\r\n<ol>\r\n	<li>\r\n		Except for any liability that cannot be excluded by law, the Promoter (including their respective officers, employees and agents) exclude all liability (including negligence), for any personal injury; or any loss or damage (including loss of opportunity); whether direct, indirect, special or consequential, arising in any way out of the offer, including, but not limited to, where arising out of the following: (a) any technical difficulties or equipment malfunction; (b) any theft, unauthorised access or third party interference; (c) any voucher that is late, lost, altered, damaged or misdirected due to any reason beyond the reasonable control of the Promoter; (d) during participation in the experience (e) any featured venues in the offer being cancelled for any reason beyond the reasonable control of the Promoter; (f) any tax liability incurred by a claimant; (g) quality or availability of any featured venue or (h) loss of opportunity to redeem the voucher because the customer failed to make a booking with the chosen in the timeframe stipulated as part of prize description, or failed to cancel</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"2\">\r\n		In the event of unforeseen circumstances, the Promoter reserves the right to withdraw, change or substitute a reward with another reward of equal or greater value.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"3\">\r\n		Prices (if any) and information presented are valid at the time of going to press and may be subject to change.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"4\">\r\n		The Promoter, its agents and distributors accept no responsibility, financial or otherwise for the misuse of vouchers and are not liable for any personal loss, injury or illness at participating venues, and cannot be held responsible for any disagreement concerning quality/availability of featured venues.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"5\">\r\n		Any persons taking advantage of this promotion does so on complete acceptance of these terms &amp; conditions.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"6\">\r\n		The Promoter shall also be bound by these Terms and Conditions and shall not encourage, persuade, promote, support or in any way assist in their breach.</li>\r\n</ol>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Prize Conditions</strong></p>\r\n<ol>\r\n	<li>\r\n		Prize will be awarded in the form of a holiday accommodation certificate.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"2\">\r\n		Flights are not included in the holiday prize.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"3\">\r\n		The holiday component of the prize must be booked and taken six months from the draw date (or re-draw date if applicable). Holiday certificate is valued at the nominated amount.&nbsp; Prize cannot be taken during Australian school holidays, public holidays or other peak periods/special events and is subject to availability.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"4\">\r\n		Altered, lost or stolen certificate will not be replaced, refunded or redeemed. Certificates are not redeemable for cash and must be redeemed before the expiry dates specified.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"5\">\r\n		Spending money, meals, insurance, transport, items of a personal nature, in-room charges and all other ancillary costs are not included.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"6\">\r\n		The winner (and his/her companions) is responsible for ensuring that they have valid travel documentation with them.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"7\">\r\n		Credit card security or a cash bond will be required upon check-in at the resort.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"8\">\r\n		Prize is valid for up to two people. Extra people or room upgrade will incur additional fees.</li>\r\n</ol>\r\n<ol>\r\n	<li value=\"9\">\r\n		If for any reason, once the prize has been booked, you do not take the prize or an element of the prize at the time stipulated, then the prize or that element of the prize will be forfeited and will not be redeemable for cash.</li>\r\n</ol>\r\n','Kym P','Yes',43),(2,'','','competition-2014-02-07-11-11-22.jpg','','','','<p>\r\n	<strong>Simply enter to win a luxury Broadbeach holiday!</strong><br />\r\n	Win a fantastic Gold Coast holiday for two people staying 3 relaxing nights at the spectacular 4.5 Star Wave Resort in the heart of Broadbeach.</p>\r\n','<p>\r\n	Here are the Terms and Conditions. Yes Maaaaaate!</p>\r\n','Barry W','Yes',8);

--
-- Table structure for table `promotiongexhotdeal`
--

CREATE TABLE `promotiongexhotdeal` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `priority` int(10) NOT NULL DEFAULT '0',
  `offer_1` varchar(200) NOT NULL,
  `offer_2` varchar(200) NOT NULL,
  `from_price` varchar(20) NOT NULL,
  `was_price` varchar(200) NOT NULL,
  `save_percent` varchar(200) NOT NULL,
  `overlay_1` varchar(200) NOT NULL,
  `overlay_2` varchar(200) NOT NULL,
  `bullet_1` text NOT NULL,
  `bullet_2` text NOT NULL,
  `bullet_3` text NOT NULL,
  `enquire_now` text NOT NULL,
  `main_image` varchar(200) NOT NULL,
  `travel_start_dt` date NOT NULL,
  `travel_end_dt` date NOT NULL,
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotiongexhotdeal`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotiongexhotdeal` VALUES (11,0,'Mantra Amphora','3 Nights accommodation\r\nDaily buffet breakfast for two adults\r\nDining discounts & Bonuses!','449','835','46','3 Nights','Palm Cove','<span><span class=\"_ZCm r-i_4vUmJ3VhrI kno-desc-sh\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q200I9gEwFA\">Across the street from Palm Cove Beach, this relaxed resort is also 8 km from hiking in Smithfield Conservation Park.<span> </span><br />\r\n<br />\r\n<span class=\"_dgc kd-hc\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q3E0I-AEwFA\"><span class=\"_I5e\"><span>Modern rooms (stair-access only) come with air-conditioning, flat-screen TVs, minifridges, and tea and coffeemaking facilities, plus Wi-Fi (surcharge). Some rooms have bathtubs and ocean views. Bright 1- to 3-bedroom apartments add kitchens, washing machines and dining/living areas, as well as patios.</span></span><br />\r\n<br />\r\n<span class=\"_I5e\"><span>Amenities include a casual Italian restaurant with a bar and pool and ocean views. There are also 2 pools, a hot tub and free parking.</span></span></span></span></span>','<span><span class=\"_ZCm r-i_4vUmJ3VhrI kno-desc-sh\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q200I9gEwFA\">Across the street from Palm Cove Beach, this relaxed resort is also 8 km from hiking in Smithfield Conservation Park.<span> </span><br />\r\n<br />\r\n<span class=\"_dgc kd-hc\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q3E0I-AEwFA\"><span class=\"_I5e\"><span>Modern rooms (stair-access only) come with air-conditioning, flat-screen TVs, minifridges, and tea and coffeemaking facilities, plus Wi-Fi (surcharge). Some rooms have bathtubs and ocean views. Bright 1- to 3-bedroom apartments add kitchens, washing machines and dining/living areas, as well as patios.</span></span><br />\r\n<br />\r\n<span class=\"_I5e\"><span>Amenities include a casual Italian restaurant with a bar and pool and ocean views. There are also 2 pools, a hot tub and free parking.</span></span></span></span></span>','<span><span class=\"_ZCm r-i_4vUmJ3VhrI kno-desc-sh\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q200I9gEwFA\">Across the street from Palm Cove Beach, this relaxed resort is also 8 km from hiking in Smithfield Conservation Park.<span> </span><br />\r\n<br />\r\n<span class=\"_dgc kd-hc\" data-ved=\"0ahUKEwi1se-AiPfWAhXHJJQKHR-jAe8Q3E0I-AEwFA\"><span class=\"_I5e\"><span>Modern rooms (stair-access only) come with air-conditioning, flat-screen TVs, minifridges, and tea and coffeemaking facilities, plus Wi-Fi (surcharge). Some rooms have bathtubs and ocean views. Bright 1- to 3-bedroom apartments add kitchens, washing machines and dining/living areas, as well as patios.</span></span><br />\r\n<br />\r\n<span class=\"_I5e\"><span>Amenities include a casual Italian restaurant with a bar and pool and ocean views. There are also 2 pools, a hot tub and free parking.</span></span></span></span></span>','','main_image-2017-10-12-15-13-34.jpg','2017-10-12','2018-02-01',1927),(10,1,'Kupu Kupu Barong Villas and Tree Spa','Daily Breakfast for two adults\r\nDaily Lunch for two adults\r\nSpa treatment by L’OCCITANE + bonuses!','378','939','561','2 nights','Bali','<p>\r\n	Set over 3 hectares of lush tropical greenery, this resort delivers luxury and the quintessential Ayung Valley experience</p>\r\n<p>\r\n	<span>These small group of private and luxurious pool villas is served by private butlers, epitomising the beauty and elegance of Balinese architecture; thatched roofs, redwood walls, teak and coconut shell paneling and sumptuous local fabrics weave a spell of exotic refinement. Engage with art, connect with culture, pursue pampering, seek enlightenment or simply listen to the rice grow.</span></p>\r\n<p>\r\n	<span>Kupu Kupu Barong Villas and Tree Spa by L&rsquo;OCCITANE is located in Ubud. It offers a well-appointed spa, restaurant and spacious villas with sweeping views of the tropical landscape. It also has an outdoor pool and provides free WiFi, free parking, and free daily afternoon tea.</span></p>\r\n<p>\r\n	<span>The luxurious villas at Kupu Kupu Barong Villas and Tree Spa by L&rsquo;OCCITANE come with traditional Balinese d&eacute;cor. Each spacious villa is fitted with a TV and DVD player. Select villas have private plunge pools.</span></p>\r\n<p>\r\n	<span>La View Restaurant serves local dishes and features sweeping views of the Ayung River. Light snacks and refreshing beverages are available at the Pool Bar.</span></p>\r\n','<h3 class=\"style_inclusionsHeading__1h2fi\">\r\n	6 bonus inclusions:</h3>\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily Breakfast for two adults</li>\r\n	<li>\r\n		Daily Lunch for two adults</li>\r\n	<li>\r\n		1 x Spa treatment (60 mins) by L&rsquo;OCCITANE with spectacular views overlooking the Ayung valley.</li>\r\n	<li>\r\n		Daily afternoon tea at La view Bar 3-5 pm</li>\r\n	<li>\r\n		1 x Cocktail per adult per stay</li>\r\n	<li>\r\n		Free cancellations permitted outside 14 days of travel</li>\r\n</ul>\r\n<hr />\r\n<div>\r\n	<h3 class=\"style_extraGuestHeading__2aZUX\">\r\n		Bedding</h3>\r\n	<div class=\"style_extraGuestInfo__3V3KE\">\r\n		<div>\r\n			<ul>\r\n				<li>\r\n					<span>1 x Double bed</span></li>\r\n			</ul>\r\n		</div>\r\n	</div>\r\n</div>\r\n<div>\r\n	<h3 class=\"style_extraGuestHeading__2aZUX\">\r\n		Extra Guests</h3>\r\n	<div class=\"style_extraGuestInfo__3V3KE\">\r\n		<div>\r\n			<ul>\r\n				<li>\r\n					<span>Package is valid for two adults</span></li>\r\n			</ul>\r\n		</div>\r\n	</div>\r\n</div>\r\n<div>\r\n	<h3 class=\"style_extraGuestHeading__2aZUX\">\r\n		Features</h3>\r\n	<div class=\"style_extraGuestInfo__3V3KE\">\r\n		<div>\r\n			<ul>\r\n				<li>\r\n					<p>\r\n						<span>Room size: 55 m&sup2;</span></p>\r\n				</li>\r\n				<li>\r\n					<p>\r\n						<span>Room facilities: Balcony, Pool view, TV, Telephone, Satellite Channels, Flat-screen TV, Safety Deposit Box, Air conditioning, Desk, Wardrobe/Closet, Shower, Bath, Hairdryer, Bathrobe, Free toiletries, Toilet, Bathroom, Slippers, Minibar, Electric kettle, Wake-up service, Towels</span></p>\r\n				</li>\r\n			</ul>\r\n		</div>\r\n	</div>\r\n</div>\r\n','<p>\r\n	<span>Valid for stays until 30 June 2018</span></p>\r\n<p>\r\n	<span>Strictly subject to availability.</span></p>\r\n<p>\r\n	<span>Please note: Payment will not be charged until the resort has confirmed your stay.</span></p>\r\n<p>\r\n	<span>High-Season Surcharge: now until 31 August 2017 and Peak Season Surcharge: 24 December 2017 - 5 January 2018. A nightly surcharge is automatically calculated at the time of booking for stays during this period.</span></p>\r\n<p>\r\n	<span>Compulsory New Year&rsquo;s Eve dinner on 31 December 2017 - Surcharge of $90 per person is payable direct to resort.</span></p>\r\n<p>\r\n	<span>Check-in or Check-out on 31 December 2017 is not permitted.</span></p>\r\n<p>\r\n	<span>Once confirmed, any cancellations, early check-out or no-shows within 14 days of travel are non-refundable and full cancellation penalties will apply. Travel date amendments are permitted subject to availability and approval by resort management.</span></p>\r\n<p>\r\n	<span>Two Bedroom Villa package is valid for four guests, however, can accommodate up to five guests</span></p>\r\n<p>\r\n	<span>Please refer to Extra Guest Policy under room terms and conditions. Any type of extra bed is upon request and needs to be confirmed by management.</span></p>\r\n<p>\r\n	<span>Extra guest supplements are not calculated automatically in the total costs and will have to be paid for separately during your stay.</span></p>\r\n','','main_image-2017-09-29-09-25-56.jpg','2017-09-29','2017-12-31',1892),(9,2,'Agata Resort Nusa Dua','7 Nights accommodation\r\nDaily buffet breakfast\r\nPlus Bonuses!','847','2411','65','7 NIGHTS','Bali','<h2>\r\n	Luxurious, Tranquil and Stylish Villas Nusa Dua</h2>\r\n<p dir=\"ltr\">\r\n	<span>The stunning 5 star resort offers an elegance and comfort tropical accommodation at the elite location of Nusa Dua Bali. The minimalist modern stylist concept is designed smartly to peace of mind your living and holidays. The villas are built on the cliff hill with open area which those are direct view at parcel of green fantastic trees. The experience and atmosphere brings the truly paradise, reflected from our 5 star facilities and personalized service.</span></p>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily breakfast served in the privacy of your own villa with over 15 menu choices</li>\r\n	<li>\r\n		VIP round trip airport transfers in a private vehicle</li>\r\n	<li>\r\n		2 x 60-minute Balinese massage per adult</li>\r\n	<li>\r\n		1 x Full Day Tour for two adults</li>\r\n	<li>\r\n		Daily afternoon High Tea at The Sky Bar</li>\r\n	<li>\r\n		Welcome drink, fresh fruit and cold towels upon arrival</li>\r\n	<li>\r\n		20% off spa treatments to amp up the indulgence</li>\r\n	<li>\r\n		20% off food and beverages across the resort</li>\r\n	<li>\r\n		Complimentary unlimited wireless internet (at Resort Area)</li>\r\n	<li>\r\n		Complimentary drop-off transportation to BTDC Nusa Dua , Geger White sand Beach area</li>\r\n	<li>\r\n		Early check-in and late check-out (subject to availability)</li>\r\n</ul>\r\n','<p>\r\n	<span>Valid for stays until 30 June 2018.</span></p>\r\n<p>\r\n	<span>High-Season Surcharge: now until 31 August 2017 and Peak Season Surcharge: 20 December 2017 - 5 January 2018. A nightly surcharge is automatically calculated at the time of booking for stays during this period.</span></p>\r\n','','main_image-2017-09-25-16-02-19.jpg','2017-09-21','2017-09-21',1883),(8,2,'Manathai Koh Samui','3 Nights accommodation\r\nDaily buffet breakfast\r\nPlus Bonuses!','261','525','50','3 NIGHTS','Thailand','<p class=\"Hotel_overviewLead__z_QL9\">\r\n	An elegant sanctuary set on the serene sands of Lamai Beach defined by its history, soft colonial elegance and world-class service</p>\r\n<p>\r\n	<span>Set on the sand of Lamai Beach within a peaceful enclave of coconut trees, Manathai Koh Samui Hotel feels a world away from everyday life, while positioning guests within easy reach of the island&rsquo;s best shopping and dining attractions.</span></p>\r\n<p>\r\n	<span><span>Manathai </span>Koh Samui continues to be the ideal choice for travelers to Thailand&rsquo;s most delightful island destination. Wander into an oasis of old-world charm where walls adorned in cheerful yellow jasmine hues are complimented with soft white details to frame a vision of a bygone Thai era.</span></p>\r\n<p>\r\n	<span>The resort channels colonial elegance to create an oasis of gardens, courtyards, polished teak hallways and guest quarters that echo old world charm. Weary travelers recline in the shade of swaying palm fronds while lapping waves offer a soothing lullaby fit to induce an indulgent afternoon nap.</span></p>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily Buffet Breakfast</li>\r\n	<li>\r\n		Welcome cocktail per adult</li>\r\n	<li>\r\n		1 x Lunch or Dinner at Pad Thai Restaurant for up to two guests</li>\r\n	<li>\r\n		Free Wi-Fi</li>\r\n	<li>\r\n		Free cancellations until 14 days prior to travel (low seasons)</li>\r\n</ul>\r\n','<p>\r\n	<span>Valid for stays until 30 June 2018</span></p>\r\n<p>\r\n	<span>Black-out dates (period not valid): 24 December 2017 - 6 January 2018</span></p>\r\n<p>\r\n	<span>High-Season Surcharge: now until 31 August 2017 and 7 January - 31 March 2018. A nightly surcharge is automatically calculated at the time of booking for stays during this period.</span></p>\r\n','','main_image-2017-09-25-15-46-02.jpg','2017-09-21','2017-09-21',1882),(7,2,'Beyond Resort Khaolak','7 Nights accommodation\r\nDaily buffet breakfast\r\nPlus Bonuses!','900','3899','77','7 NIGHTS','Bali','<p>\r\n	<span>Award winning Adults-Only villa resort with a gorgeous setting on the white sands of Pakweep Beach.</span></p>\r\n<p>\r\n	<span>This property is 3 minutes walk from the beach. This luxurious resort enjoys a prime beachfront location and only a short drive to many popular attractions. Beyond Resort provides elegant villas, an outdoor pool, and a fitness center.</span></p>\r\n<p>\r\n	<span>Nestled away in a jungle landscape, the villas have an air of privacy and seclusion, and excursions to nearby islands or the extensive national parklands of Khaolak can be arranged.</span></p>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Daily Full Breakfast</li>\r\n	<li>\r\n		Return Airport Transfers from Phuket International Airport</li>\r\n	<li>\r\n		2 x Dinners per person per stay</li>\r\n	<li>\r\n		14 credit-vouchers (30 Mins) Thai Massage per room for 2 persons</li>\r\n	<li>\r\n		1 Mini Thai Cooking Class per person</li>\r\n	<li>\r\n		1 Invite to Management Cocktail per person</li>\r\n	<li>\r\n		45 Minutes of Thai Lesson with 1 Mai Tai Cocktail per person</li>\r\n	<li>\r\n		Free Wi-Fi, Free&nbsp;In&nbsp;room&nbsp;refreshments, Discount&nbsp;with&nbsp;10%&nbsp;discount&nbsp;on&nbsp;Food and Beverages&nbsp;and&nbsp;20%&nbsp;discount&nbsp;on&nbsp;Spa&nbsp;treatments</li>\r\n	<li>\r\n		Free cancellations permitted outside 21 days from travel</li>\r\n</ul>\r\n','<p>\r\n	<span>Valid for stays 1 October 2017 until 31 October 2018.</span></p>\r\n<p>\r\n	<span>This package is valid for two adults (18 years and over). No children are permitted at the resort</span></p>\r\n<p>\r\n	<span>Strictly subject to availability.</span></p>\r\n','','main_image-2017-09-25-15-17-32.jpg','2017-10-01','2018-10-31',1881),(6,0,'JW Marriott Marquis Dubai','5 Nights accommodation\r\nReturn flights\r\nDaily buffet breakfast\r\nPlus Bonuses!','1899','100','100','5 NIGHTS','Dubai','In a city of unsurpassed luxury, the 1,608-room JW Marriott Marquis Hotel Dubai is one of the region&rsquo;s most desirable destinations for business and leisure travelers. The two iconic towers in Business Bay on Sheikh Zayed Road offers exceptional amenities, an array of 5 bars and 9 restaurants and the world class Saray Spa.<br />\r\n<br />\r\nFeaturing 5-star comfort, technology and personalized service for discerning travelers, the hotel puts Dubai firmly on the global business destination map. Located nearby The Dubai Mall, Burj Khalifa and Dubai Opera ensure you make the most of your stay.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights in upgraded Guest Sea View Room<br />\r\n&bull; Return economy flights incl. 30 kg of checked luggage and inflight meals and entertainment<br />\r\n&bull; Buffet breakfast daily<br />\r\n&bull; Return airport transfers<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; VIP Arrival Concierge services including meet and greet<br />\r\n&bull; Traditional Dubai City Tour<br />\r\n&bull; Guaranteed late check-out of 4pm<br />\r\n&bull; Complimentary room upgrade from a Guest Room included<br />\r\n&bull; 20% discount on all food &amp; beverages<br />\r\n&bull; Buy 1 spa treatment &amp; get the 2nd treatment of equal or lesser value for free<br />\r\n&bull; Complimentary WiFi','<strong>Travel Dates:</strong><br />\r\n1 October - 28 November 2017; 16 January - 28 March 2018.<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n16 - 19 October 2017; 12 - 22 November 2017; 9 December 2017 - 15 January 2018; 28 - 31 January 2018.<br />\r\n<strong>High Season Surcharges:</strong><br />\r\nAdd from $200 per person for travel 29 November - 8 December 2018.<br />\r\nAdditional high season and air surcharges may apply over school holidays and peak travel periods. Blackout dates may apply.','','main_image-2017-09-22-14-55-02.png','2017-09-21','2017-09-21',1880),(5,1,'Maharaja Villas Seminyak','5 Nights accommodation\r\nDaily breakfast\r\nDining discounts & Bonuses!','888','1771','50','5 NIGHTS','Bali','Nestled in the heart of Seminyak Area,&nbsp; Maharaja Villas &amp; Spa Seminyak will delight you with its Private Seminyak Villas designed by renowned architect that values Balinese royal heritage.<br />\r\n<br />\r\nSwimming pool, royal garden and all necessary home comforts are available in each Villa, along with the legendary Balinese royal treatment.<br />\r\n<br />\r\nMaharaja Villas and Spa Seminyak is the place where you can explore your senses. Let us imagining for a while. From the smell of beautiful flower garden to delicious Balinese tropical fruits and meals, From the smooth sands to beautiful sunset, From the fresh air from the mountain breeze to the lush green Padi fields, From the beautiful sound of traditional music instruments to the Royal treatments, all of them are available for you to celebrate.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<ul class=\"style_inclusionsList__3IMHE\">\r\n	<li>\r\n		Breakfast Daily</li>\r\n	<li>\r\n		Return Airport Transfers</li>\r\n	<li>\r\n		1 x 60 minute massage per person per stay</li>\r\n	<li>\r\n		1 x Half Day Tour for two guests</li>\r\n	<li>\r\n		Welcome drink and fruit basket on arrival</li>\r\n	<li>\r\n		Free unlimited Wi-Fi</li>\r\n	<li>\r\n		Daily afternoon tea</li>\r\n	<li>\r\n		20% Discount on all Spa treatments during stay</li>\r\n	<li>\r\n		20% Discount on all food purchased during stay (excluding beverages)</li>\r\n	<li>\r\n		Daily shuttle service around Seminyak and Kuta areas (subject to shuttle schedule)</li>\r\n</ul>\r\n','<span>Valid for stays until 23 December 2018.</span>\r\n<p>\r\n	<span>Subject to availability.</span></p>\r\n','','main_image-2017-09-22-15-07-00.jpg','2017-09-21','2017-09-21',1879),(4,0,'Novotel Phuket Kata Avista Resort and Spa','5 Nights accommodation\r\nDaily buffet breakfast for two adults\r\nDining discounts & Bonuses!','649','100','60','5 NIGHTS','Thailand','<p class=\"Hotel_overviewLead__z_QL9\">\r\n	Novotel Phuket Kata Avista Resort and Spa overlooks the aquamarine Andaman Sea and pristine white sands of Kata Beach in Southern Phuket, Thailand. Whether you are travelling individually, or with your loved one or as a family, you will find a gloriously relaxing and tranquil beach getaway experience in our spa resort.<br />\r\n	<br />\r\n	Chill, indulge and enjoy our celebrated spa, two generous meandering swimming pools, five star amenities and the magical views from your private balconies.</p>\r\n<div>\r\n	<p>\r\n		<span>This resort is a 5 minutes walk from the beach. Located on Kata Beach, Novotel Phuket Kata Avista Resort and Spa is set among green hills and offers sweeping sea views. The luxurious accommodation features spacious rooms with a balcony or terrace.</span></p>\r\n	<p>\r\n		<span>Guests can enjoy a massage and body treatment at Sukko Spa or have a relaxing swim in the infinity pool. Kids can play at the Kids Club while adults take it easy at the putting green or go on a hiking adventure.</span></p>\r\n	<p>\r\n		<span>Fresh seafood, Thai, Asian and international dishes are served at the Avista&#39;s cafe. An extensive beverage list is available at the Wine Lounge. Room service and a breakfast buffet are offered.</span></p>\r\n</div>\r\n','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights accommodation<br />\r\n&bull; Every room offers private balcony<br />\r\n&bull; Welcome drink<br />\r\n&bull; Free Wi-Fi<br />\r\n&bull; 10% discount at hotel restaurant and bar and 15% discount for all spa treatments<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; 1 x Thai-set Dinner for two adults (one evening of stay)','<strong>Travel Dates:</strong><br />\r\n<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n<br />\r\n<strong>High Season Surcharges:</strong><br />\r\n','','main_image-2017-09-29-09-52-34.jpg','2017-09-21','2017-09-21',1878),(3,0,'JW Marriott Marquis Dubai','5 Nights accommodation\r\nReturn flights\r\nBuffet breakfast daily\r\nPlus Bonuses!','1899','xxxx','xx','5 NIGHTS','Dubai','In a city of unsurpassed luxury, the 1,608-room JW Marriott Marquis Hotel Dubai is one of the region&rsquo;s most desirable destinations for business and leisure travelers. The two iconic towers in Business Bay on Sheikh Zayed Road offers exceptional amenities, an array of 5 bars and 9 restaurants and the world class Saray Spa.<br />\r\n<br />\r\nFeaturing 5-star comfort, technology and personalized service for discerning travelers, the hotel puts Dubai firmly on the global business destination map. Located nearby The Dubai Mall, Burj Khalifa and Dubai Opera ensure you make the most of your stay.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights in upgraded Guest Sea View Room<br />\r\n&bull; Return economy flights incl. 30 kg of checked luggage and inflight meals and entertainment<br />\r\n&bull; Buffet breakfast daily<br />\r\n&bull; Return airport transfers<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; VIP Arrival Concierge services including meet and greet<br />\r\n&bull; Traditional Dubai City Tour<br />\r\n&bull; Guaranteed late check-out of 4pm<br />\r\n&bull; Complimentary room upgrade from a Guest Room included<br />\r\n&bull; 20% discount on all food &amp; beverages<br />\r\n&bull; Buy 1 spa treatment &amp; get the 2nd treatment of equal or lesser value for free<br />\r\n&bull; Complimentary WiFi','<strong>Travel Dates:</strong><br />\r\n1 October - 28 November 2017; 16 January - 28 March 2018.<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n16 - 19 October 2017; 12 - 22 November 2017; 9 December 2017 - 15 January 2018; 28 - 31 January 2018.<br />\r\n<strong>High Season Surcharges:</strong><br />\r\nAdd from $200 per person for travel 29 November - 8 December 2018.<br />\r\nAdditional high season and air surcharges may apply over school holidays and peak travel periods. Blackout dates may apply.','','main_image-2017-09-21-13-13-23.png','2017-09-21','2017-09-21',1877),(2,0,'JW Marriott Marquis Dubai','5 Nights accommodation\r\nReturn flights\r\nDaily buffet breakfast\r\nPlus Bonuses!','1899','100','100','5 NIGHTS','Dubai','In a city of unsurpassed luxury, the 1,608-room JW Marriott Marquis Hotel Dubai is one of the region&rsquo;s most desirable destinations for business and leisure travelers. The two iconic towers in Business Bay on Sheikh Zayed Road offers exceptional amenities, an array of 5 bars and 9 restaurants and the world class Saray Spa.<br />\r\n<br />\r\nFeaturing 5-star comfort, technology and personalized service for discerning travelers, the hotel puts Dubai firmly on the global business destination map. Located nearby The Dubai Mall, Burj Khalifa and Dubai Opera ensure you make the most of your stay.','<strong>PACKAGE INCLUDES:</strong><br />\r\n<br />\r\n&bull; 5 nights in upgraded Guest Sea View Room<br />\r\n&bull; Return economy flights incl. 30 kg of checked luggage and inflight meals and entertainment<br />\r\n&bull; Buffet breakfast daily<br />\r\n&bull; Return airport transfers<br />\r\n<br />\r\n<strong>PLUS EXCLUSIVE BONUSES:</strong><br />\r\n<br />\r\n&bull; VIP Arrival Concierge services including meet and greet<br />\r\n&bull; Traditional Dubai City Tour<br />\r\n&bull; Guaranteed late check-out of 4pm<br />\r\n&bull; Complimentary room upgrade from a Guest Room included<br />\r\n&bull; 20% discount on all food &amp; beverages<br />\r\n&bull; Buy 1 spa treatment &amp; get the 2nd treatment of equal or lesser value for free<br />\r\n&bull; Complimentary WiFi','<strong>Travel Dates:</strong><br />\r\n1 October - 28 November 2017; 16 January - 28 March 2018.<br />\r\n<strong>Blackouts Dates:</strong><br />\r\n16 - 19 October 2017; 12 - 22 November 2017; 9 December 2017 - 15 January 2018; 28 - 31 January 2018.<br />\r\n<strong>High Season Surcharges:</strong><br />\r\nAdd from $200 per person for travel 29 November - 8 December 2018.<br />\r\nAdditional high season and air surcharges may apply over school holidays and peak travel periods. Blackout dates may apply.','<p class=\"title\">\r\n	Need extra nights?</p>\r\nVoucher is for a consecutive stay of 3, 5 or 7 Nights. Please note: extra nights are subject to availability until confirmation of your voucher. Extra nights may be arranged by contacting email or calling <a href=\"tel:1300886779\">1300 886 779</a>.<br />\r\n<br />\r\n<strong>How to Redeem</strong><br />\r\n<ul>\r\n	<li>\r\n		Can travel to: 15 Dec 2017</li>\r\n	<li>\r\n		Must book by: 30 Sep 2017</li>\r\n	<li>\r\n		Purchase your voucher and book online via <a href=\"http://globalexplorer.com.au\">globalexplorer.com.au</a></li>\r\n	<li>\r\n		If you received your voucher as a gift, sign in or register for an account then click on the &#39;BOOK A GIFT&#39; button</li>\r\n	<li>\r\n		Select date of booking and enter details</li>\r\n	<li>\r\n		You&#39;ll receive an email to confirm reservation details</li>\r\n</ul>\r\n','main_image-2017-09-22-14-55-02.png','2017-09-21','2017-09-21',1875),(1,0,'9 Nights Paradise in Thailand','1 Night in Phuket\r\n8 Nights at Paradise Koh Yao\r\nAirport + Flights & Transfers','4999','1000','40','12 Nights','Thailand','The Experience','What you get','Booking Info','<p class=\"title\">\r\n	Need extra nights?</p>\r\nVoucher is for a consecutive stay of 3, 5 or 7 Nights. Please note: extra nights are subject to availability until confirmation of your voucher. Extra nights may be arranged.<br />\r\n<br />\r\n<strong>How to Redeem</strong><br />\r\n<ul>\r\n	<li>\r\n		Can travel to: 15 Dec 2017</li>\r\n	<li>\r\n		Must book by: 30 Sep 2017</li>\r\n	<li>\r\n		Purchase your voucher and book online via <a href=\"http://globalexplorer.com.au\">globalexplorer.com.au</a></li>\r\n	<li>\r\n		If you received your voucher as a gift, sign in or register for an account then click on the &#39;BOOK A GIFT&#39; button</li>\r\n	<li>\r\n		Select date of booking and enter details</li>\r\n	<li>\r\n		You&#39;ll receive an email to confirm reservation details</li>\r\n</ul>\r\n','','2017-09-13','2017-09-30',1869);

--
-- Table structure for table `promotionhotdeal`
--

CREATE TABLE `promotionhotdeal` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_1` varchar(200) NOT NULL,
  `offer_2` varchar(200) NOT NULL,
  `terms` varchar(200) NOT NULL,
  `terms_conditions` text NOT NULL,
  `image_text` varchar(200) NOT NULL,
  `from_price` varchar(20) NOT NULL,
  `from_price_type` enum('Night','Person','Room') NOT NULL DEFAULT 'Night',
  `value` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bullet_1` text NOT NULL,
  `bullet_2` text NOT NULL,
  `bullet_3` text NOT NULL,
  `travel_start_dt` date NOT NULL,
  `travel_end_dt` date NOT NULL,
  `large_tile` enum('Yes','No') NOT NULL DEFAULT 'No',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2123 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionhotdeal`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionhotdeal` VALUES (2122,'7 Nights','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only), Bottle of sparkling wine on arrival & a midday check out (Subject to availability)','Travel between 11 August 2020 to 13 June 2021 (subject to availability)<p>','1. This special is available for purchase until 5.00pm (AEST) Tuesday 25 August 2020.<br />\r\n2. Valid for travel from 11 August 2020 to 13 June 2021. Low season travel dates: 11 Aug - 09 Sep, 11 Oct - 22 Dec 20, 07 Jan - 01 Apr, 06 Apr - 13 Jun 2021. Surcharges apply for High season travel dates: 23 Dec 2020 - 06 Jan 2021.<br />\r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 &amp; 02 - 05 Apr 2021.<br />\r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.<br />\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.<br />\r\n6. A voucher will be sent to you by email on confirmation of payment.<br />\r\n7. The special is valid for up to 4 people in a 2 Bedroom LUXE Ocean view &amp; 4 people in a 2 Bedroom LUXE Pool Deck.<br />\r\n8. Maximum room capacity is 4 people.<br />\r\n9. Extra nights may be purchased at time of booking.<br />\r\n10. Full payment is required at time of booking.<br />\r\n11. Changes are permitted up to 33 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.<br />\r\n12. Cancellations are permitted up to 33 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.<br />\r\n13. We recommend taking out a travel insurance policy at the point of booking.<br />\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.<br />\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.<br />\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).<br />\r\n17. A 2.5% booking fee applies','','1279.00','Night',3986.00,'<span style=\"color:#0000ff;\"><strong>Includes:&nbsp;</strong></span><br />\r\n* Bottle of sparkling wine on arrival&nbsp;<br />\r\n* Midday check out (Subject to availability)&nbsp;<br />\r\n* 1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)&nbsp;','Located on the corner of the Esplanade and Mowbray Streets and offers spacious fully self-contained apartments for guests wanting a beachside holiday location.','Located right on Four Mile Beach at Port Douglas','2020-08-11','2021-06-13','No',21946),(2121,'2 Nights ','Whale Watch Tour Discount, Bottle of Wine & Whale Watching Gift Pack!','Valid for travel up to 11 October 2020','1. Book by 5:00pm (AEST) Wed 30 Sep 2020.<br />\r\n2. Valid for travel: 03/08/2020-11/10/2020.&nbsp;&nbsp;<br />\r\n3. Subject to availability at time of booking.<br />\r\n4. 2 night minimum stay applies.<br />\r\n5. Surcharge applies Fri &amp; Sat nights.<br />\r\n6. Please note all advertised pricing is in AUD (Australian Dollars).<br />\r\n7. A 2.5% booking fee applies.','','117.00','Night',139.00,'<span style=\"color: rgb(0, 0, 255);\"><strong>WHALE WATCH PACKAGE INCLUDES:&nbsp;</strong></span><br />\r\n* <strong>10% discount off a Whale Watching tour</strong>&nbsp;<em>(with Mantra&#39;s preferred tour operator.)<br />\r\n*&nbsp;</em>A <strong>Bottle of Wine </strong>on Arrival!<br />\r\n* A <strong>Whale Watching Gift Pack</strong>!<br />\r\n<br />\r\n','Stunning Marina Views&nbsp;<br />\r\n<br />\r\n','Located close to Hervey Bay&#39;s Esplanade&nbsp;<br />\r\n<br />\r\n','2020-08-03','2020-10-11','No',21945),(2120,'2 Nights ','Whale Watch Tour Discount, Bottle of Wine & Whale Watching Gift Pack!','Valid for travel up to 11 October 2020','1. Book by 5:00pm (AEST) Wed 30 Sep 2020.<br />\r\n2. Valid for travel: 03/08/2020-11/10/2020.&nbsp;&nbsp;<br />\r\n3. Subject to availability at time of booking.<br />\r\n4. 2 night minimum stay applies.<br />\r\n5. Surcharge applies Fri &amp; Sat nights.<br />\r\n6. Please note all advertised pricing is in AUD (Australian Dollars).<br />\r\n7. A 2.5% booking fee applies.','','117.00','Night',139.00,'<strong style=\"color: rgb(0, 0, 255);\">WHALE WATCH PACKAGE INCLUDES:&nbsp;</strong><br />\r\n* <strong>10% discount off a Whale Watching Tour</strong> <em>(with Mantra&#39;s preferred tour operator.)<br />\r\n*&nbsp;</em>A <strong>Bottle of Wine</strong> on Arrival!<br />\r\n* A <strong>Whale Watching Gift Pack</strong>!<br />\r\n','Stunning Marina Views&nbsp;<br />\r\n','Located close to Hervey Bay&#39;s Esplanade&nbsp;<br />\r\n','2020-08-03','2020-10-11','No',21944),(2119,'1 Night','Unlimited Entry to Sea World, Movie World, Wet\'n\'Wild & Paradise Country, Free Breakfast for 4 + More!','Travel between 6 August - 11 December 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 11 December 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights. A surcharge of $75 per night applies 19 Sep - 11 Oct 2020.</div>\r\n<div>\r\n	3. Full payment required at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Dates may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 4 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. A surcharge of $75 per person per night applies for 5th person which includes a rollaway bed, breakfast and theme park admission which is payable direct to Sea World Resort.<br />\r\n	8.&nbsp;A two night minimum stay may apply on some dates.</div>\r\n<div>\r\n	9. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	10. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','236','Night',1063.00,'<strong><span>&middot; </span>Unlimited Entry to&nbsp;Sea World, Movie World, Wet&#39;n&#39;Wild &amp; Paradise Country<br />\r\n<span>&middot;&nbsp;</span>Grab &#39;n&#39; Go Breakfast</strong> for 4 people daily&nbsp;<br />\r\n<strong><span>&middot; </span>Bottle of Wine</strong>&nbsp;on Arrival<br />\r\n','<strong><span>&middot; </span>School Holidays Availability</strong>&nbsp;during September/October for $75 surcharge per night<br />\r\n<strong><span>&middot; </span>Flexible Booking Conditions </strong>- cancel or change your booking up to 48 hours prior!<br />\r\n<strong><span>&middot; </span>Stay Over a Saturday</strong> for only $30 surcharge&nbsp;<br />\r\n<br />\r\n','Travelling with more than 4 people? Please call us for details.','2020-08-06','2020-12-11','Yes',21943),(2118,'1 Night','Unlimited Entry to Sea World, Movie World, Wet\'n\'Wild & Paradise Country, Free Breakfast for 4 + More!','Travel between 6 August - 11 December 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 11 December 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights. A surcharge of $75 per night applies 19 Sep - 11 Oct 2020.</div>\r\n<div>\r\n	3. Full payment required at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Dates may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 4 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. A surcharge of $75 per person per night applies for 5th person which includes a rollaway bed, breakfast and theme park admission which is payable direct to Sea World Resort.<br />\r\n	8.&nbsp;A two night minimum stay may apply on some dates.</div>\r\n<div>\r\n	9. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	10. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','259','Night',1063.00,'<strong><span>&middot; </span>Unlimited Entry to&nbsp;Sea World, Movie World, Wet&#39;n&#39;Wild &amp; Paradise Country</strong><br />\r\n<strong>&middot; Includes 4 Guests!&nbsp;</strong><br />\r\n<strong><span>&middot;&nbsp;</span>Grab &#39;n&#39; Go Breakfast</strong> for 4 people daily&nbsp;<br />\r\n<strong><span>&middot; </span>Bottle of Wine</strong>&nbsp;on Arrival<br />\r\n<br />\r\n','<strong><span>&middot; </span>School Holidays Availability</strong>&nbsp;during September/October for $75 surcharge per night<br />\r\n<strong><span>&middot; </span>Flexible Booking Conditions -</strong> cancel or change your booking up to 48 hours prior!<br />\r\n<strong><span>&middot; </span>Stay Over a Saturday</strong> for only $30 surcharge&nbsp;<br />\r\n<br />\r\n','Travelling with more than 4 people? Please call us for details.','2020-08-06','2020-12-11','Yes',21942),(2117,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020 (Studios not available).</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a Studio or 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom or 8 people in a 4 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','122','Night',200.00,'Perfectly situated on the beachfront at the southern end of Palm Cove with direct beach access\r\n<p>\r\n</p>\r\n','<p>\r\n	<span style=\"color: rgb(255, 0, 0);\">Stay 4 Pay 3, Swim-Out, Penthouse &amp; High Season discounts also available - please enquire for details.</span></p>\r\n','<br />\r\n<p>\r\n</p>\r\n','2020-08-04','2020-10-15','No',21939),(2116,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020 (Studios not available).</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a Studio or 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom or 8 people in a 4 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','143','Night',200.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>','Perfectly situated on the beachfront at the southern end of Palm Cove with direct beach access','<span style=\"color:#ff0000;\">Stay 4 Pay 3, Swim-Out, Penthouse &amp; High Season discounts also available - please enquire for details.</span>','2020-08-04','2020-10-15','Yes',21938),(2115,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020.</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','250','Night',410.00,'Perfectly located on the secluded beachfront of Four Mile Beach and only a short distance from the heart of Port Douglas.','<p>\r\n	<span style=\"color: rgb(255, 0, 0);\">Stay 4 Pay 3, Swim-Out, Plunge Pool, Penthouse &amp; High Season discounts also available - please enquire for details.</span></p>\r\n','<br />\r\n<p>\r\n</p>\r\n','2020-08-04','2020-10-15','No',21937),(2114,'7 Nights','Free Night Offer','Valid for travel: 4 Aug to 15 Oct 2020 (subject to availability)','<ol>\r\n	<li>\r\n		Valid for sale up to 18 August 2020.</li>\r\n	<li>\r\n		Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020.</li>\r\n	<li>\r\n		Bookings are essential and subject to availability.</li>\r\n	<li>\r\n		Valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom.</li>\r\n	<li>\r\n		Payments: A deposit of $200 is required at time of booking. Final balance is due 35 days prior to travel date and will automatically be deducted.</li>\r\n	<li>\r\n		Changes are permitted up to 17 days prior to travel date provided the amended dates are of an equal value and are available. A service charge of $50 per booking will be applied to changes.</li>\r\n	<li>\r\n		&nbsp;Cancellations are permitted up to 17 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.</li>\r\n	<li>\r\n		We recommend taking out a travel insurance policy at the point of booking.</li>\r\n	<li>\r\n		Please note all advertised pricing is in AUD (Australian Dollars).</li>\r\n	<li>\r\n		A 2.5% booking fee applies.</li>\r\n</ol>\r\nStay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available&nbsp; - please enquire for details.<br />\r\n<br />\r\n<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em>','','293','Night',410.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>','Perfectly located on the secluded beachfront of Four Mile Beach and only a short distance from the heart of Port Douglas.','<span style=\"color:#ff0000;\">Stay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available - please enquire for details.</span>','2020-08-04','2020-10-15','Yes',21936),(2113,'1 Night','Includes Admission to Sea World & Paradise Country','Travel between 1 August - 31 August 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 31 August 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights.&nbsp;</div>\r\n<div>\r\n	3. Payment required in full by credit card at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Date may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 2 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. Extra person rate is $25 per person including theme park admission.</div>\r\n<div>\r\n	8. A surcharge of $85 per person per night applies for 5th person which includes a rollaway bed and theme park admission.</div>\r\n<div>\r\n	9. A 2 night minimum stay may apply on some dates.</div>\r\n<div>\r\n	10. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	11. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','136','Night',551.00,'<strong>&middot;&nbsp;Unlimited Entry to Sea World &amp; Paradise Country<br />\r\n&middot; Welcome Gift Pack on Arrival</strong>&nbsp;','<strong>&middot;&nbsp;Flexible Booking Conditions&nbsp;</strong>- cancel or change your booking up to 48 hours prior!<br />\r\n<strong>&middot;&nbsp;Stay Over a Saturday</strong>&nbsp;for only $30 surcharge&nbsp;','','2020-08-01','2020-08-31','Yes',21935),(2112,'1 Night','Includes Admission to Sea World & Paradise Country','Travel between 1 August - 31 August 2020 (subject to availability)<p>','<div>\r\n	1. Valid for stays up to 31 August 2020 (subject to availability).</div>\r\n<div>\r\n	2. A $30 surcharge applies on Saturday nights.&nbsp;</div>\r\n<div>\r\n	3. Payment required in full by credit card at time of booking.</div>\r\n<div>\r\n	4. Cancellations or booking changes without any penalties will be accommodated up to 48 hours prior to arrival. Date may be changed subject to availability and within the sell period time frame.</div>\r\n<div>\r\n	5. The special is valid for 2 people.</div>\r\n<div>\r\n	6. Maximum room capacity is 4 or 5 people depending on room type selected.</div>\r\n<div>\r\n	7. Extra person rate is $25 per person including theme park admission.</div>\r\n<div>\r\n	8. A surcharge of $85 per person per night applies for 5th person which includes a rollaway bed and theme park admission.</div>\r\n<div>\r\n	9. A 2 night minimum stay may apply on some dates.</div>\r\n<div>\r\n	10. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n<div>\r\n	11. A 2.5% booking fee applies.</div>\r\n','Award Winning Gold Coast Resort ','149','Night',551.00,'<strong><span>&middot; </span>Unlimited Entry to Sea World &amp; Paradise Country<br />\r\n<span>&middot; Welcome Gift Pack on Arrival</span></strong>&nbsp;<br />\r\n<br />\r\n<br />\r\n','<strong><span>&middot; </span>Flexible Booking Conditions </strong>- cancel or change your booking up to 48 hours prior!<br />\r\n<strong><span>&middot; </span>Stay Over a Saturday</strong> for only $30 surcharge&nbsp;','','2020-08-01','2020-08-31','Yes',21933),(2111,'3 Nights','Absolute Beachfront with Stunning Views','Valid for travel up to 17 September 2020 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 19/07/2020-30/07/2020, 03/08/2020-18/09/2020, 11/10/2020-15/10/2020, 19/10/2020-29/10/2020, 02/11/2020-11/12/2020, 27/01/2021-11/02/2021, 14/02/2021-03/03/2021, 08/03/2021-25/03/2021, 29/03/2021-01/04/2021, 18/04/2021-17/06/2021, 21/06/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 2 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','126','Night',149.00,'Relaxing, beachfront tropical style resort on the stunning Northern NSW Coast.','<p>\r\n	Fantastic range of family activities including outdoor rock pool with slide, children&#39;s pool and mini putt putt golf.</p>\r\n','','2020-07-19','2021-09-17','No',21929),(2110,'3 Nights','Located right opposite the beach','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-01/10/2020, 05/10/2020-22/10/2020, 24/10/2020-17/12/2020, 01/02/2021-01/04/2021, 06/04/2021-22/04/2021, 26/04/2021-14/05/2021, 16/05/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','141','Night',221.00,'Located in the beautiful beachside town of Ettalong and right opposite the beach','Resort style Pool, Spa, Ettalong Diggers Gym &amp; Swim, Advanced Skin Spa','','2020-07-19','2021-09-30','No',21928),(2109,'3 Nights','Featuring stunning ocean and river views','Valid for travel up to 16 September 2020 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 20/07/2020-23/07/2020, 27/07/2020-10/09/2020, 15/09/2020-24/09/2020, 12/10/2020-17/12/2020, 01/02/2021-17/02/2021, 22/02/2021-31/03/2021, 19/04/2021-22/04/2021, 27/04/2021-30/04/2021, 03/05/2021-05/05/2021, 11/05/2021-10/06/2021, 14/06/2021-24/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Fri &amp; Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','141','Night',229.00,'Featuring stunning ocean and river views and winner of multiple tourism awards','<p>\r\n	Positioned across the road from Port Macquarie&rsquo;s main beach and just 400 metres from the town centre</p>\r\n','<p>\r\n	Indoor Heated Pool &amp; Spa, Sauna, Barbecue Area &amp; Bike Hire</p>\r\n','2020-07-19','2021-09-16','No',21927),(2108,'3 Nights','Relaxing Beachside Escape','Valid for travel up to 17 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 24/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-22/07/2021, 26/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','132','Night',175.00,'Central location in Salt Village on the beachfront<br />\r\n<p>\r\n</p>\r\n','<p>\r\n	Close to Salt Village restaurants and bars</p>\r\n','Large Lagoon Style Pool, Children&#39;s Wading Pool, Tennis Courts, Spa &amp; Bike Hire','2020-07-22','2021-09-17','No',21926),(2107,'3 Nights','Gorgeous Coral Sea Views','Valid for travel up to 18 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-16/07/2020, 26/07/2020-05/08/2020, 23/08/2020-27/08/2020, 31/08/2020-02/09/2020, 08/09/2020-18/09/2020, 11/10/2020-04/11/2020, 08/11/2020-20/11/2020, 29/11/2020-18/12/2020, 10/01/2021-01/04/2021, 07/04/2021-25/06/2021, 11/07/2021-08/08/2021, 22/08/2021-18/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','209','Night',293.00,'','Perfectly situated right on the Port of Airlie Marina\r\n<p>\r\n</p>\r\n','Facilities include swimming pool and sundeck, tennis court, barbeque area plus children&rsquo;s playground','2020-07-22','2021-09-18','No',21925),(2106,'3 Nights','5 Star Island Escape','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-26/08/2020, 03/09/2020-24/12/2020, 05/01/2021-01/04/2021, 06/04/2021-02/09/2021, 09/09/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',295.00,'','Elegantly laid out at the water&rsquo;s edge overlooking the Coral Sea and private marina\r\n<p>\r\n</p>\r\n','Two Swimming Pools, Bike Hire, Restaurant, Day Spa &amp; WiFi','2020-07-22','2021-09-30','No',21924),(2105,'3 Nights','Luxury in Tropical Palm Cove ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','212','Night',387.00,'','Iconic North Queensland resort, with lush green gardens, a rainforest rock pool and lagoon pool with sandy beaches\r\n<p>\r\n</p>\r\n','Day Spa, Lime &amp; Pepper Restaurant, Tennis Club House with Gym Facilities','2020-07-22','2021-09-30','No',21923),(2104,'3 Nights','Right in the heart of Cairns CBD','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',260.00,'','Located right on Cairns Esplanade overlooking the waterfront\r\n<p>\r\n</p>\r\n','Relax on the pool deck, cook up a barbeque or have an invigorating workout at the gym.','2020-07-22','2021-09-30','No',21922),(2103,'3 Nights','Fantastic Resort Facilities','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',189.00,'','Explore the nearby Daintree Rainforest or take a boat ride out to the magnificent Great Barrier Reef\r\n<p>\r\n</p>\r\n','Lagoon Pool, Plunge Pool, Tennis Courts, Waterslide, Fitness Room, Barbecue Area','2020-07-22','2021-09-30','No',21921),(2102,'3 Nights','Perfect for Couples & Families','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','136','Night',189.00,'','Located in the heart of Port Douglas close to restaurants &amp; cafes\r\n<p>\r\n</p>\r\n','4 Outdoor Lagoon Pools, Spas, Barbecue Area','2020-07-22','2021-09-30','No',21920),(2101,'3 Nights','Tropical Waterfront Getaway ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',235.00,'','Waterfront resort with gorgeous lagoon-style pool, spa and restaurant\r\n<p>\r\n</p>\r\n','Close to The Esplanade with its range of restaurants, bars and bistros','2020-07-22','2021-09-30','No',21919),(2100,'3 Nights','Lavish Hotel in the heart of Surfers Paradise ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-20/11/2020, 06/12/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','128','Night',195.00,'','<p>\r\n	Luxury Resort in the heart of Surfers Paradise</p>\r\n','Enjoy a great location near the Iconic Beaches&nbsp;','2020-07-22','2021-09-17','No',21918),(2099,'3 Nights','Hervey Bay\'s only absolute waterfront resort','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-17/09/2020, 11/10/2020-17/12/2020, 10/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-06/07/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','87','Night',119.00,'','<p>\r\n	Hervey Bay&#39;s only absolute waterfront resort located right next to the marina and beach</p>\r\n','Enjoy uninterrupted ocean or marina views from your balcony or patio','2020-07-22','2021-09-17','No',21917),(2098,'3 Nights ','Right on the Esplanade','Valid for travel up to 23 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-11/09/2020, 14/09/2020-24/09/2020, 11/10/2020-17/12/2020, 10/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-23/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',210.00,'','<p>\r\n	Luxury Beachfront Getaway right on Mooloolaba Esplanade</p>\r\n','<p>\r\n	Facilities include an observation deck, outdoor pool, indoor heated pool, spa and gym</p>\r\n','2020-07-06','2021-09-23','No',21916),(2097,'3 Nights ','Noosa Escape on Hastings St','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-03/08/2020, 17/08/2020-02/09/2020, 06/09/2020-10/09/2020, 15/09/2020-17/09/2020, 25/10/2020-29/10/2020, 02/11/2020-04/11/2020, 09/11/2020-19/11/2020, 24/11/2020-04/12/2020, 24/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-13/05/2021, 17/05/2021-25/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','158','Night',261.00,'','<p>\r\n	Conveniently Located for a Relaxing Family Getaway!</p>\r\n','<p>\r\n	Heated Lagoon Pool, Children&#39;s Wading Pool, Heated Spas, Barbecue Area &amp; Complimentary Parking</p>\r\n','2020-07-06','2021-09-16','No',21915),(2096,'3 Nights ','Close to Family Friendly Restaurants & Cafes','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 17/08/2020-10/09/2020, 11/10/2020-29/10/2020, 03/11/2020-10/12/2020, 24/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','108','Night',181.00,'','<p>\r\n	Perfectly positioned directly opposite a patrolled beach &amp; just metres from family friendly restaurants &amp; cafes.</p>\r\n','<p>\r\n	<span style=\"font-size: 16px;\">Two heated tropical lagoon pools &amp; spas, kids waterslide, gymnasium, children&#39;s playground &amp; barbeque area.</span></p>\r\n','2020-07-06','2021-09-16','No',21914),(2095,'3 Nights ','Luxury in the Heart of Surfers Paradise','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 29/08/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','249','Night',308.00,'','<p>\r\n	Stay Connected to Loved Ones with WiFi</p>\r\n','<p>\r\n	Enjoy Free Parking &amp; Daily Servicing</p>\r\n','2020-07-06','2021-09-17','No',21913),(2094,'3 Nights ','5 Star Broadbeach Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','167','Night',255.00,'','<p>\r\n	Located in the heart of Broadbeach surrounded by restaurants&nbsp;</p>\r\n','<p>\r\n	Resort facilities include Tai Chi lawn, Zen Gardens, Teppanyaki Barbecue, Heated Pool, Spa &amp; more!</p>\r\n','2020-07-06','2021-09-17','No',21912),(2093,'3 Nights ','Amazing Broadbeach Family Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','128','Night',209.00,'','<p>\r\n	Popular resort for families in a relaxed, friendly atmosphere</p>\r\n','<p>\r\n	Kids will love the two large lagoon pools, wading pool, shaded playground and games room</p>\r\n','2020-07-06','2021-09-17','No',21911),(2092,'3 Nights ','Studio, 1 & 2 Bedroom Ocean Apartments','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-11/12/2020, 24/01/2021-16/03/2021, 28/03/2021-01/04/2021, 18/04/2021-23/04/2021, 03/05/2021-09/06/2021, 14/06/2021-25/06/2021, 11/07/2021-22/07/2021, 26/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','146','Night',248.00,'','<p>\r\n	Beachfront Coolangatta Resort</p>\r\n','Swimming Pool, Spa, Sauna, Tennis Courts, Gym &amp; Barbecue Area','2020-07-06','2021-09-17','No',21910),(2091,'3 Nights ','Great Value Gold Coast Escape','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-20/11/2020, 06/12/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',225.00,'','<p>\r\n	Iconic Surfers Paradise Beach just across the road</p>\r\n','<p>\r\n	Easy walking distance to shops, restaurants and famous Cavill Avenue</p>\r\n','2020-07-06','2021-09-17','No',21909),(2090,'3 Nights ','Amazing Ocean Views! ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-20/11/2020, 06/12/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','121','Night',215.00,'','<p>\r\n	Spectacular location across the road from the beach</p>\r\n','<p>\r\n	Resort facilities include indoor and outdoor heated pools, tennis court, spa and sauna</p>\r\n','2020-07-06','2021-09-17','No',21908),(2089,'3 Nights','Located right opposite the beach','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-01/10/2020, 05/10/2020-22/10/2020, 24/10/2020-17/12/2020, 01/02/2021-01/04/2021, 06/04/2021-22/04/2021, 26/04/2021-14/05/2021, 16/05/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','149','Night',221.00,'Located in the beautiful beachside town of Ettalong and right opposite the beach','Resort style Pool, Spa, Ettalong Diggers Gym &amp; Swim, Advanced Skin Spa','','2020-07-19','2021-09-30','No',21905),(2088,'3 Nights','Featuring stunning ocean and river views','Valid for travel up to 16 September 2020 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 20/07/2020-23/07/2020, 27/07/2020-10/09/2020, 15/09/2020-24/09/2020, 12/10/2020-17/12/2020, 01/02/2021-17/02/2021, 22/02/2021-31/03/2021, 19/04/2021-22/04/2021, 27/04/2021-30/04/2021, 03/05/2021-05/05/2021, 11/05/2021-10/06/2021, 14/06/2021-24/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Fri &amp; Sat nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note: </strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','149','Night',229.00,'Featuring stunning ocean and river views and winner of multiple tourism awards','<p>\r\n	Positioned across the road from Port Macquarie&rsquo;s main beach and just 400 metres from the town centre</p>\r\n','<p>\r\n	Indoor Heated Pool &amp; Spa, Sauna, Barbecue Area &amp; Bike Hire</p>\r\n','2020-07-19','2021-09-16','No',21904),(2087,'3 Nights','Relaxing Beachside Escape','Valid for travel up to 17 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 24/01/2021-01/04/2021, 18/04/2021-25/06/2021, 11/07/2021-22/07/2021, 26/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','140','Night',175.00,'Central location in Salt Village on the beachfront<br />\r\n<p>\r\n</p>\r\n','<p>\r\n	Close to Salt Village restaurants and bars</p>\r\n','Large Lagoon Style Pool, Children&#39;s Wading Pool, Tennis Courts, Spa &amp; Bike Hire','2020-07-22','2021-09-17','No',21903),(2086,'3 Nights','Gorgeous Coral Sea Views','Valid for travel up to 18 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-16/07/2020, 26/07/2020-05/08/2020, 23/08/2020-27/08/2020, 31/08/2020-02/09/2020, 08/09/2020-18/09/2020, 11/10/2020-04/11/2020, 08/11/2020-20/11/2020, 29/11/2020-18/12/2020, 10/01/2021-01/04/2021, 07/04/2021-25/06/2021, 11/07/2021-08/08/2021, 22/08/2021-18/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies on Saturday nights.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','229','Night',293.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Perfectly situated right on the Port of Airlie Marina\r\n<p>\r\n</p>\r\n','Facilities include swimming pool and sundeck, tennis court, barbeque area plus children&rsquo;s playground','2020-07-22','2021-09-18','No',21902),(2085,'3 Nights','5 Star Island Escape','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-26/08/2020, 03/09/2020-24/12/2020, 05/01/2021-01/04/2021, 06/04/2021-02/09/2021, 09/09/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','233','Night',295.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Elegantly laid out at the water&rsquo;s edge overlooking the Coral Sea and private marina\r\n<p>\r\n</p>\r\n','Two Swimming Pools, Bike Hire, Restaurant, Day Spa &amp; WiFi','2020-07-22','2021-09-30','No',21901),(2084,'3 Nights','Luxury in Tropical Palm Cove ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','233','Night',387.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Iconic North Queensland resort, with lush green gardens, a rainforest rock pool and lagoon pool with sandy beaches\r\n<p>\r\n</p>\r\n','Day Spa, Lime &amp; Pepper Restaurant, Tennis Club House with Gym Facilities','2020-07-22','2021-09-30','No',21900),(2083,'3 Nights','Right in the heart of Cairns CBD','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',260.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Located right on Cairns Esplanade overlooking the waterfront\r\n<p>\r\n</p>\r\n','Relax on the pool deck, cook up a barbeque or have an invigorating workout at the gym.','2020-07-22','2021-09-30','No',21899),(2082,'3 Nights','Fantastic Resort Facilities','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',189.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Explore the nearby Daintree Rainforest or take a boat ride out to the magnificent Great Barrier Reef\r\n<p>\r\n</p>\r\n','Lagoon Pool, Plunge Pool, Tennis Courts, Waterslide, Fitness Room, Barbecue Area','2020-07-22','2021-09-30','No',21898),(2081,'3 Nights','Perfect for Couples & Families','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','150','Night',189.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Located in the heart of Port Douglas close to restaurants &amp; cafes\r\n<p>\r\n</p>\r\n','4 Outdoor Lagoon Pools, Spas, Barbecue Area','2020-07-22','2021-09-30','No',21897),(2080,'3 Nights','Tropical Waterfront Getaway ','Valid for travel up to 30 September 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-18/09/2020, 11/10/2020-20/12/2020, 05/01/2021-01/04/2021, 11/04/2021-03/06/2021, 07/06/2021-25/06/2021.&nbsp;Surcharge applies 19/09/2020-24/09/2020, 28/09/2020-10/10/2020, 26/06/2021-30/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.</p>\r\n<p>\r\n	<br />\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',235.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>\r\n<p>\r\n</p>\r\n','Waterfront resort with gorgeous lagoon-style pool, spa and restaurant\r\n<p>\r\n</p>\r\n','Close to The Esplanade with its range of restaurants, bars and bistros','2020-07-22','2021-09-30','No',21896),(2079,'3 Nights','Hervey Bay\'s only absolute waterfront resort','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-17/09/2020, 11/10/2020-17/12/2020, 10/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-06/07/2021, 11/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','95','Night',119.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card (valued at $199)&nbsp;&amp; enjoy up to 50% off dining, attractions, gift cards, movie tickets &amp; more including:<br />\r\n<p>\r\n	- 20% Off Reef World Admission&nbsp;<br />\r\n	- 10% Off Whale Watching&nbsp;<br />\r\n	- 10% Off Half Day Fraser Island Beach &amp; BBQ Cruise&nbsp;</p>\r\n','Hervey Bay&#39;s only absolute waterfront resort located right next to the marina and beach\r\n<p>\r\n</p>\r\n','Enjoy uninterrupted ocean or marina views from your balcony or patio','2020-07-22','2021-09-17','No',21895),(2078,'3 Nights ','Right on the Esplanade','Valid for travel up to 23 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 17/08/2020-11/09/2020, 14/09/2020-24/09/2020, 11/10/2020-17/12/2020, 10/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-23/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','133','Night',210.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Luxury Beachfront Getaway right on Mooloolaba Esplanade</p>\r\n','<p>\r\n	Facilities include an observation deck, outdoor pool, indoor heated pool, spa and gym</p>\r\n','2020-07-06','2021-09-23','No',21894),(2077,'3 Nights ','Noosa Escape on Hastings St','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-03/08/2020, 17/08/2020-02/09/2020, 06/09/2020-10/09/2020, 15/09/2020-17/09/2020, 25/10/2020-29/10/2020, 02/11/2020-04/11/2020, 09/11/2020-19/11/2020, 24/11/2020-04/12/2020, 24/01/2021-01/04/2021, 18/04/2021-22/04/2021, 26/04/2021-13/05/2021, 17/05/2021-25/06/2021, 11/07/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','173','Night',261.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Conveniently Located for a Relaxing Family Getaway!</p>\r\n','<p>\r\n	Heated Lagoon Pool, Children&#39;s Wading Pool, Heated Spas, Barbecue Area &amp; Complimentary Parking</p>\r\n','2020-07-06','2021-09-16','No',21893),(2076,'3 Nights ','Close to Family Friendly Restaurants & Cafes','Valid for travel up to 16 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 12/07/2020-13/08/2020, 17/08/2020-10/09/2020, 11/10/2020-29/10/2020, 03/11/2020-10/12/2020, 24/01/2021-11/03/2021, 15/03/2021-01/04/2021, 26/04/2021-25/06/2021, 11/07/2021-12/08/2021, 16/08/2021-09/09/2021, 13/09/2021-16/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','119','Night',181.00,'<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em>','Perfectly positioned directly opposite a patrolled beach &amp; just metres from family friendly restaurants &amp; cafes.\r\n','<span style=\"font-size: 16px;\">Two heated tropical lagoon pools &amp; spas, kids waterslide, gymnasium, children&#39;s playground &amp; barbeque area.</span>\r\n','2020-07-06','2021-09-16','No',21892),(2075,'3 Nights ','Luxury in the Heart of Surfers Paradise','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-18/12/2020, 25/01/2021-01/04/2021, 18/04/2021-25/06/2021, 29/08/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','273','Night',308.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Stay Connected to Loved Ones with WiFi</p>\r\n','<p>\r\n	Enjoy Free Parking &amp; Daily Servicing</p>\r\n','2020-07-06','2021-09-17','No',21891),(2074,'3 Nights ','5 Star Broadbeach Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','183','Night',255.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Located in the heart of Broadbeach surrounded by restaurants&nbsp;</p>\r\n','<p>\r\n	Resort facilities include Tai Chi lawn, Zen Gardens, Teppanyaki Barbecue, Heated Pool, Spa &amp; more!</p>\r\n','2020-07-06','2021-09-17','No',21890),(2073,'3 Nights ','Amazing Broadbeach Family Holiday ','Valid for travel up to 17 Sep 2021 (black-out dates apply)','<p>\r\n	1. Book by 5:00pm (AEST) 30 Sep 2020.<br />\r\n	2. Valid for travel: 06/07/2020-13/08/2020, 16/08/2020-18/09/2020, 11/10/2020-24/11/2020, 01/12/2020-24/12/2020, 24/01/2021-01/04/2021, 18/04/2021-20/05/2021, 23/05/2021-25/06/2021, 11/07/2021-22/07/2021, 25/07/2021-17/09/2021.<br />\r\n	3. Subject to availability at time of booking.<br />\r\n	4. 3 night minimum stay applies.<br />\r\n	5. Surcharge applies Sat nights.</p>\r\n<p>\r\n	<em><strong>Please note:&nbsp;</strong>Advertised prices are a &quot;From&quot; price and may change subject to availability and season.</em></p>\r\n','','140','Night',209.00,'<p>\r\n	<span style=\"color:#ff0000;\"><strong>BONUS:</strong></span> receive a <strong>Free</strong> My DQ card <em>(valued at $199)</em></p>\r\n','<p>\r\n	Popular resort for families in a relaxed, friendly atmosphere</p>\r\n','<p>\r\n	Kids will love the two large lagoon pools, wading pool, shaded playground and games room</p>\r\n','2020-07-06','2021-09-17','No',21889);

--
-- Table structure for table `promotionhotdealrates`
--

CREATE TABLE `promotionhotdealrates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `RoomIntro` text NOT NULL,
  `room_id` int(10) NOT NULL DEFAULT '0',
  `num_nights` varchar(200) NOT NULL DEFAULT '0',
  `normally` decimal(10,2) NOT NULL DEFAULT '0.00',
  `you_pay` decimal(10,2) NOT NULL DEFAULT '0.00',
  `action` enum('Enquire','Book After Hours','Book Only','Book and Enquire') NOT NULL DEFAULT 'Enquire',
  `property_id` int(10) NOT NULL DEFAULT '0',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22536 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionhotdealrates`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionhotdealrates` VALUES (22535,'',66735,'7',4060.00,2169.00,'Enquire',9392,21946),(22534,'',66733,'7',4100.00,1599.00,'Enquire',9392,21946),(22533,'',66734,'7',3946.00,1999.00,'Enquire',9392,21946),(22532,'',66732,'7',3986.00,1439.00,'Enquire',9392,21946),(22531,'',44216,'2',474.00,396.00,'Enquire',3022,21945),(22530,'',44215,'2',354.00,277.00,'Enquire',3022,21945),(22529,'',44214,'2',306.00,250.00,'Enquire',3022,21945),(22528,'',44213,'2',277.00,213.00,'Enquire',3022,21945),(22506,'',44216,'2',474.00,434.00,'Enquire',3022,21944),(22505,'',44215,'2',354.00,304.00,'Enquire',3022,21944),(22504,'',44214,'2',306.00,274.00,'Enquire',3022,21944),(22503,'',44213,'2',277.00,234.00,'Enquire',3022,21944),(22498,'',2,'2',2.00,0.00,'Enquire',2,21943),(22497,'',2,'2',2.00,0.00,'Enquire',2,21943),(22496,'',0,'B',0.00,0.00,'Enquire',0,21943),(22495,'',3,'3',3.00,0.00,'Enquire',3,21943),(22494,'',1,'1',1.00,0.00,'Enquire',1,21943),(22493,'',1,'1',1.00,0.00,'Enquire',1,21943),(22492,'',6,'6',6.00,0.00,'Enquire',6,21943),(22491,'',0,'',0.00,0.00,'Enquire',0,21943),(22490,'',2,'2',2.00,0.00,'Enquire',2,21943),(22489,'',66663,'1',1138.00,334.00,'Book and Enquire',254,21942),(22488,'',66662,'1',1113.00,309.00,'Book and Enquire',254,21942),(22487,'',66661,'1',1113.00,309.00,'Book and Enquire',254,21942),(22486,'',66660,'1',1088.00,284.00,'Book and Enquire',254,21942),(22485,'',66659,'1',1088.00,284.00,'Book and Enquire',254,21942),(22484,'',66658,'1',1063.00,259.00,'Book and Enquire',254,21942),(22483,'',66526,'7',1239.00,679.00,'Book and Enquire',3891,21887),(22482,'',66362,'3',675.00,399.00,'Book and Enquire',3891,21887),(22481,'',66525,'7',1239.00,679.00,'Book and Enquire',3891,21887),(22480,'',66361,'3',675.00,399.00,'Book and Enquire',3891,21887),(22479,'',44319,'Stay 7 Pay 5',3150.00,2250.00,'Enquire',115,21938),(22478,'',44315,'Stay 7 Pay 5',2730.00,1950.00,'Enquire',115,21938),(22477,'',44311,'Stay 7 Pay 5',2380.00,1700.00,'Enquire',115,21938),(22476,'',44310,'Stay 7 Pay 5',1400.00,1000.00,'Enquire',115,21938),(22471,'',44072,'Stay 7 Pay 5',4130.00,2950.00,'Enquire',114,21936),(22470,'',44068,'Stay 7 Pay 5',3430.00,2450.00,'Enquire',114,21936),(22469,'',44064,'Stay 7 Pay 5',2870.00,2050.00,'Enquire',114,21936),(22468,'',66613,'7',2751.00,2002.00,'Book and Enquire',3720,21901),(22467,'',66469,'3',1287.00,999.00,'Book and Enquire',3720,21901),(22466,'',66612,'7',2352.00,1666.00,'Book and Enquire',3720,21901),(22465,'',66468,'3',1095.00,829.00,'Book and Enquire',3720,21901),(22464,'',66611,'7',2233.00,1596.00,'Book and Enquire',3720,21901),(22463,'',66503,'3',1035.00,799.00,'Book and Enquire',3720,21901),(22462,'',66610,'7',1918.00,1400.00,'Book and Enquire',3720,21901),(22461,'',66466,'3',885.00,699.00,'Book and Enquire',3720,21901),(22460,'',66507,'7',1687.00,1400.00,'Enquire',3005,21879),(22459,'',66506,'3',699.00,675.00,'Enquire',3005,21879),(22458,'',66505,'7',1071.00,875.00,'Enquire',3005,21879),(22457,'',66631,'3',447.00,399.00,'Enquire',3005,21879);

--
-- Table structure for table `promotionmystery`
--

CREATE TABLE `promotionmystery` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `content_middle` text NOT NULL,
  `content_bottom` text NOT NULL,
  `property_details` enum('Yes','No') NOT NULL DEFAULT 'No',
  `separator` int(10) NOT NULL DEFAULT '10',
  `colour` varchar(6) NOT NULL,
  `url_type` int(10) NOT NULL DEFAULT '1',
  `url_custom` varchar(200) NOT NULL,
  `image_1` varchar(200) NOT NULL,
  `image_2` varchar(200) NOT NULL,
  `input_1` text NOT NULL,
  `input_2` text NOT NULL,
  `input_3` text NOT NULL,
  `input_4` text NOT NULL,
  `input_5` text NOT NULL,
  `input_6` text NOT NULL,
  `input_7` text NOT NULL,
  `input_8` text NOT NULL,
  `input_9` text NOT NULL,
  `input_10` text NOT NULL,
  `bg_colour` varchar(6) NOT NULL,
  `padding` int(10) NOT NULL DEFAULT '0',
  `margin_btm` int(10) NOT NULL DEFAULT '0',
  `room_id` int(10) NOT NULL DEFAULT '0',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  `block_type` int(10) NOT NULL DEFAULT '0',
  `show_on_website` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sort_order` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1384 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionmystery`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionmystery` VALUES (1382,'','','','No',10,'',1,'','image-1-2019-07-29-09-55-20.jpg','','','','','','','','','','','','',0,0,0,21408,2,'No',0),(1381,'','','','No',10,'',1,'','image-1-2017-02-21-13-22-27.jpg','','','','','','','','','','','','',1,1,0,1510,2,'Yes',0),(1379,'','','','No',10,'',1,'','','','2 Nights + Breakfast ','Hinterland View Room ','For 2 People (Kids 0-14 Stay Free)','Sale Price','$529','Normally $966','Save $436','200','','','ffffff',4,1,45517,1510,4,'Yes',3),(1378,'<span style=\"font-size:12px;\"><strong>Booking Terms &amp; Conditions</strong></span><br />\r\n<div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		1. This special is available for purchase until 5.00pm (AEST) Tuesday 28 February 2017.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		2. Valid for travel from 22 February to 15 December 2017.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		3. The travel period has black-out dates: 24 Feb, 18 - 19 Mar, 22 - 23 Mar, 10 - 18 Apr, 22 Apr, 17 May, 23 - 25 May, 9 - 10 Jun &amp; 30 Jun - 2 Jul, 18 Sep, 23 Sep, 14 Oct, 20 - 23 Oct &amp; 11 Nov 2017.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		4. Bookings are essential and subject to availability. To book your stay call us on 1300 788 553.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		5. An email will be sent to you on confirmation of payment.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		6. The special is valid for up to 2 people in a Hinterland View Room.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		7. Maximum room capacity is 3 adults or 2 adults &amp; 2 children (0-14 years).</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		8. Extra person charge is $40 per night room only or $80 per night including breakfast. Up to 2 children (0-14 years) stay free of charge using existing bedding (room only).</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		9. Extra nights may be purchased at time of booking at the same per night price</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		10. Bookings are non-refundable, non-exchangeable and no cancellations or amendments under ANY circumstances. We strongly recommend taking out a travel insurance policy at the point of booking.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		11. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		12. Please note all advertised pricing is in AUD (Australian Dollars).</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		13. A 2.5% booking fee applies to phone bookings only.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n		14. Please note height restrictions apply to childrens use of the resort waterslide.</div>\r\n	<div>\r\n	</div>\r\n	<div>\r\n	</div>\r\n</div>\r\n<p>\r\n</p>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','ffffff',0,1,0,1510,1,'Yes',12),(1373,'*Subject to availability &amp; black-out dates apply. Phone bookings attract a 2.5% booking fee. Extra person permitted for extra charge and you can purchase extra nights when booking. Refer full terms &amp; conditions below.<br />\r\n<br />\r\n<span style=\"color:#155896;\"><span style=\"font-size: 18px;\">We&#39;re here to help you find the perfect holiday!</span></span><br />\r\n<span style=\"color: #ff7f00; font-size: 22px;\">Call us 1300 788 553</span>','','','No',10,'',2,'','','','','','','','','','','','','','ffffff',3,0,0,1510,7,'Yes',5),(1372,'<p align=\"center\">\r\n	<span style=\"color:#ff8c00;\"><span style=\"font-size:24px;\"><strong>CALL US OR BOOK ONLINE NOW</strong></span><br />\r\n	<span style=\"font-size:18px;\"><strong>AND SECURE YOUR HOLIDAY DATES TODAY!</strong></span></span><br />\r\n	<br />\r\n	<span style=\"font-size:24px;\"><strong>Sale ends strictly 5pm Tuesday and is valid for travel between 22 February 2017 - 15 December 2017*</strong></span></p>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','ffffff',0,1,0,1510,1,'Yes',4),(1371,'','','','No',10,'',1,'','','','2 Nights','Hinterland View Room','For 2 People (Kids 0-14 Stay Free)','Sale Price','$449','Normally $714','Save $264','200','','','ffffff',4,1,45516,1510,4,'Yes',2),(1369,'','','','No',0,'',1,'','image-1-2017-02-21-13-00-31.jpg','','','','','','','','','','','','2371b9',1,1,45516,1510,2,'Yes',0),(1368,'<span style=\"font-size: 16px;\">Escape to one of the most popular luxury resorts on the Gold Coast with our Ultimate Mystery 5 Star Getaway! Indulge with a cocktail by the lavish lagoon pool, be pampered with a facial &amp; massage at the spa &amp; dine at the most famous restaurants in Surfers Paradise &ndash; all without leaving the resort!&nbsp;</span>\r\n<p>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:18px;color:#fa6b0e;\"><strong>This amazing offer includes:</strong></span></p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n','','','No',10,'',1,'','','','<strong>2 Nights in a Spacious Hinterland View Room</strong>&nbsp;with a private balcony offering spectacular Gold Coast &amp; waterway views.&nbsp;','<strong>Delicious Full Buffet Breakfast Daily</strong> for Two People when you upgrade to the Breakfast Package <span style=\"font-size:12px;\">(valued at $168)</span>','<span style=\"font-size:16px;\"><strong>Luxurious Resort Facilities</strong> including renowned salt water lagoon pool, waterslide, spas, poolside cabanas, sauna, gym, day spa, tennis court, daily room servicing, kids club &amp; more!&nbsp;</span>\r\n','<span style=\"font-size:16px;\">Enjoy&nbsp;<strong>Award-Winning Dining</strong> without leaving the resort including pool bar, lounge &amp; tapas bar, 2 world-class restaurants &amp; room service!&nbsp;</span>\r\n','<b>Complimentary Car Parking&nbsp;</b><span style=\"font-size: 12px;\">(valued at $30)</span>','<strong>Bottle of Wine&nbsp;</strong>on arrival to kick start your induldgent holiday<span style=\"font-size: 12px;\">&nbsp;(valued at $38)</span>','<b>Unlimited In-Room Movies&nbsp;</b>to enjoy&nbsp;<span style=\"font-size: 12px;\">(valued at $14.95 each)</span>','<strong>Kids Stay FREE!</strong>&nbsp;Rooms accommodate up to 2 adults &amp; 2 children<span style=\"font-size:12px;\"> (under 14 years using existing bedding in a Double Room).</span>','<b>Stay Extra Nights for the Same Per Night Price!&nbsp;</b><span style=\"font-size:12px;\">Plus 1 Night Packages also available.</span>','','ffffff',0,1,0,1510,3,'Yes',1);

--
-- Table structure for table `promotionnewsletter`
--

CREATE TABLE `promotionnewsletter` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `content_middle` text NOT NULL,
  `content_bottom` text NOT NULL,
  `property_details` enum('Yes','No') NOT NULL DEFAULT 'No',
  `separator` int(10) NOT NULL DEFAULT '10',
  `colour` varchar(6) NOT NULL,
  `url_type` int(10) NOT NULL DEFAULT '1',
  `url_custom` varchar(200) NOT NULL,
  `image_1` varchar(200) NOT NULL,
  `image_2` varchar(200) NOT NULL,
  `input_1` text NOT NULL,
  `input_2` text NOT NULL,
  `input_3` text NOT NULL,
  `input_4` text NOT NULL,
  `input_5` text NOT NULL,
  `input_6` text NOT NULL,
  `input_7` text NOT NULL,
  `input_8` text NOT NULL,
  `input_9` text NOT NULL,
  `input_10` text NOT NULL,
  `input_11` text NOT NULL,
  `input_12` text NOT NULL,
  `room_id` int(10) NOT NULL DEFAULT '0',
  `bg_colour` varchar(6) NOT NULL,
  `padding` int(10) NOT NULL DEFAULT '0',
  `margin_btm` int(10) NOT NULL DEFAULT '0',
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  `block_type` int(10) NOT NULL DEFAULT '0',
  `show_on_website` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sort_order` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5248 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionnewsletter`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionnewsletter` VALUES (5245,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/cruise/pando-cruises-program-release-2021','image-1-2020-01-07-12-31-06.jpg','','','','','','','','','','','','','',0,'',1,0,21549,2,'No',2),(5244,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/accommodation/gold-coast/burleigh-heads/boardwalk-burleigh-beach','image-1-2020-01-07-09-39-51.jpg','','','Boardwalk Burleigh Beach','Burleigh Heads, Gold Coast','7 Nights','From','$180pn','','','','','','',0,'',1,0,21549,20,'No',4),(5243,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/accommodation/gold-coast/broadbeach/qube-broadbeach','image-1-2020-01-06-13-32-14.jpg','','','Qube Broadbeach','Broadbeach, Gold Coast','7 Nights','From','$173pn','','','','','','',0,'',1,0,21549,20,'No',3),(5242,'','','','No',10,'',3,'https://www.discoverqueensland.com.au/accommodation/gold-coast/surfers-paradise/artique-resort-apartments','image-1-2020-01-06-15-16-31.jpg','','The ULTIMATE Gold Coast Theme Park Holiday','Artique Resort','Surfers Paradise, Gold Coast','3 Nights','','$749','2 Bedroom Apartment','','','','','',0,'',0,0,21549,20,'No',5),(5240,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">BRISBANE</span></span> ','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'No',4),(5239,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">WHITSUNDAYS</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',13),(5238,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">TROPICAL NORTH QLD</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',10),(5237,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">SUNSHINE COAST</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',7),(5234,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mirage-whitsundays.php','image-1-2019-12-31-10-28-25.jpg','','Mirage Whitsundays','Airlie Beach, Whitsundays','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',15),(5232,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$2xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/sea-temple-port-douglas.php','image-1-2019-12-31-10-26-17.jpg','','Sea Temple Private Apartments','Port Douglas, Tropical North QLD','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',12),(5231,' \r\n<div style=\"text-align: center;\">\r\n	<span style=\"color:#007889;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\">We&#39;re here to help you find your perfect getaway today</span>!</span></span><br />\r\n	<a href=\"tel:1300769765\" style=\"font-size:26px;color:#ff8c00;text-decoration:none;\">Call us 1300 769 765</a></div>\r\n','','','No',10,'',2,'','','','','','','','','','','','','','','',0,'ffffff',0,0,21607,7,'Yes',23),(5229,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/rolling-surf.php','image-1-2019-12-31-10-22-35.jpg','','Rolling Surf Resort','Caloundra, Sunshine Coast','x Bedroom Deluxe','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',9),(5228,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">GOLD COAST</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21607,1,'Yes',1),(5227,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-crown-towers.php','image-1-2019-12-31-10-11-45.jpg','','Mantra Crown Towers','Surfers Paradise, Gold Coast','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'Yes',3),(5226,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xpn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes</span></span></span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/treasury-brisbane.php','image-1-2019-12-31-10-18-59.jpg','','Treasury Brisbane','Brisbane CBD','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'No',6),(5225,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'','image-1-2019-12-31-10-10-42.jpg','','Oaks Gold Coast Hotel','Surfers Paradise, Gold Coast','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',2),(5223,'','','','No',10,'',0,'','image-1-2019-12-31-10-07-25.jpg','','','','','','','','','','','','','',0,'',1,0,21607,2,'No',0),(5221,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/next-hotel-brisbane.php','image-1-2019-12-31-10-17-54.jpg','','NEXT Hotel Brisbane','Queen Street, Brisbane','x Bedroom Apartment','sales message','','','','','','','','',0,'',0,0,21607,5,'No',5),(5220,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-alexandra-beach.php','image-1-2019-12-31-10-20-20.jpg','','BreakFree Alexandra Beach','Alexandra Headland, Sunshine Coast','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',8),(5218,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/fitzroy-island-resort.php','image-1-2019-12-31-10-23-48.jpg','','Fitzroy Island Resort','Fitzroy Island, Via Cairns`','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',11),(5217,'<span style=\"font-size:18px; color:#ee4421;\">x Nights from <span style=\"font-size:30px;\">$xxxpn</span></span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/daydream-island-resort.php','image-1-2019-12-31-10-27-25.jpg','','Daydream Island Resort & Spa','Daydream Island, Whitsundays','x Bedroom Apartment','sales message','','','','','','','','',0,'ffffff',0,0,21607,5,'Yes',14),(5215,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">SYDNEY CBD</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'No',20),(5214,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">PERTH CBD</span></span> ','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'No',22),(5213,'<span style=\"font-size:18px; color:#ee4421;\">1 Nights from <span style=\"font-size:30px;\">$169pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Breakfast &amp; Late Checkout</span></span></span><br />\r\n(Min. Spend $244)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-on-hay.php','image-1-2019-12-23-15-03-42.jpg','','Mantra on Hay','Perth CBD, Western Australia','1 Bedroom Apartment','Central CBD Location with Great Facilities','','','','','','','','',0,'',0,0,21605,5,'No',23),(5212,'<span style=\"font-size:18px; color:#ee4421;\">1 Nights from <span style=\"font-size:30px;\">$179pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $179)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-2-bond-street.php','image-1-2019-12-23-15-01-54.jpg','','Mantra 2 Bond Street','Sydney CBD, NSW','Executive Studio','Central Location','','','','','','','','',0,'',0,0,21605,5,'No',21),(5211,'','','','No',10,'',0,'','image-1-2019-12-23-14-58-03.jpg','','','','','','','','','','','','','',0,'',1,0,21605,2,'No',19),(5210,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">FRASER COAST</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'No',14),(5209,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$81pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $162)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-hervey-bay.php','image-1-2019-12-23-14-51-09.jpg','','Mantra Hervey Bay','Hervey Bay, Fraser Coast','Hotel Room','Stunning Marina Location!','','','','','','','','',0,'',0,0,21605,5,'No',15),(5208,'','','','No',10,'',0,'','image-1-2019-12-24-14-50-33.jpg','','','','','','','','','','','','','',0,'',1,0,21605,2,'No',0),(5207,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">WHITSUNDAYS</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',12),(5206,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">TROPICAL NORTH QLD</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',8),(5205,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">SUNSHINE COAST</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',5),(5204,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$122pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Buffet Breakfast Daily!</span></span></span><br />\r\n(Min. Spend $244)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-aanuka-beach-resort.php','image-1-2019-12-23-14-55-28.jpg','','BreakFree Aanuka Beach','Coffs Harbour, NSW','Hotel Room','Absolute Beachfront with Stunning Views!','','','','','','','','',0,'',0,0,21605,5,'Yes',18),(5203,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$108pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $217)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-club-croc.php','image-1-2019-12-23-14-43-54.jpg','','Mantra Club Croc','Airlie Beach, Whitsundays','Garden Deluxe Room','Freshly Renovated & Centrally Located!','','','','','','','','',0,'',0,0,21605,5,'Yes',13),(5202,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$200pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Breakfast, WiFi &amp; Spa Discounts!</span></span></span><br />\r\n(Min. Spend $400)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/peppers-beach-club-spa-palm-cove.php','image-1-2019-12-23-14-38-53.jpg','','Peppers Beach Club & Spa','Palm Cove, Tropical North QLD','Resort Spa','Indulgent 5 Star Bliss','','','','','','','','',0,'',0,0,21605,5,'Yes',10),(5200,' \r\n<div style=\"text-align: center;\">\r\n	<span style=\"color:#007889;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 20px;\">We&#39;re here to help you find your perfect getaway today</span>!</span></span><br />\r\n	<a href=\"tel:1300769765\" style=\"font-size:26px;color:#ff8c00;text-decoration:none;\">Call us 1300 769 765</a></div>\r\n','','','No',10,'',2,'','','','','','','','','','','','','','','',0,'ffffff',0,0,21605,7,'Yes',24),(5199,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$136pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Breakfast, In-Room Movies &amp; Dining Discounts!</span></span></span><br />\r\n(Min. Spend $272)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/peppers-blue-on-blue.php','image-1-2019-12-23-14-40-37.jpg','','Peppers Blue on Blue','Magnetic Island, Tropical North QLD','Hotel Room','Idyllic Island Escape','','','','','','','','',0,'',0,0,21605,5,'Yes',11),(5198,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$181pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $363)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-french-quarter.php','image-1-2019-12-23-14-35-17.jpg','','Mantra French Quarter','Noosa, Sunshine Coast','1 Bedroom Deluxe','Prime Location in the Heart of Noosa!','','','','','','','','',0,'',0,0,21605,5,'Yes',7),(5197,'<span style=\"font-size:26px;\"><span style=\"color: rgb(169, 169, 169);\">GOLD COAST</span></span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',1),(5196,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$145pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $290)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-circle-on-cavill.php','image-1-2019-12-23-14-25-30.jpg','','Mantra Circle on Cavill','Surfers Paradise, Gold Coast','1 Bedroom ','Luxury in Paradise','','','','','','','','',0,'',0,0,21605,5,'Yes',3),(5195,'<span style=\"font-size:18px; color:#ee4421;\">3 Nights from <span style=\"font-size:30px;\">$112pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $336)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-moroccan.php','image-1-2019-12-23-14-16-35.jpg','','BreakFree Moroccan','Surfers Paradise, Gold Coast','1 Bedroom Apartment','Great for Families, Great Value & Close to Everything!','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',2),(5194,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$112pn</span></span><br />\r\n<span style=\"font-size: 14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Dining Discounts &amp; Parking!</span></span></span><br />\r\n(Min. Spend $225)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-on-salt-beach.php','image-1-2019-12-23-14-54-14.jpg','','Mantra on Salt Beach','Kingscliff, NSW','Hotel Room','Beachfront Bliss, Untouched Paradise','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',17),(5192,'<span style=\"color: rgb(169, 169, 169); font-size: 26px;\">NORTHERN NSW</span>','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',1,0,21605,1,'Yes',16),(5191,'<span style=\"font-size:18px; color:#ee4421;\">3 Nights from <span style=\"font-size:30px;\">$118pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $353)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/breakfree-grand-pacific.php','image-1-2019-12-23-14-32-52.jpg','','BreakFree Grand Pacific','Caloundra, Sunshine Coast','1 Bedroom Garden View','Absolute Beachfront Bliss!','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',6),(5190,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$99pn</span></span><br />\r\n<span style=\"font-size:14px;\">(Min. Spend $189)</span><br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/mantra-amphora.php','image-1-2019-12-23-14-37-08.jpg','','Mantra Amphora','Palm Cove, Tropical North QLD','Hotel Spa Room','Palm Cove Tropical Bliss!','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',9),(5189,'<span style=\"font-size:18px; color:#ee4421;\">2 Nights from <span style=\"font-size:30px;\">$263pn</span></span><br />\r\n<span style=\"font-size:14px;\"><span style=\"font-size:14px;\"><span style=\"color:#007889;\"><span style=\"background-color: rgb(255, 255, 255); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px;\">Includes Parking &amp; WiFi!</span></span></span><br />\r\n(Min. Spend $527)</span><br />\r\n<br />\r\n','','','No',10,'00788a',3,'https://www.hightide.com.au/properties/soul-surfers.php','image-1-2019-12-23-14-27-01.jpg','','Peppers Soul','Surfers Paradise, Gold Coast','1 Bedroom Ocean View','Redefines World-Class Luxury','','','','','','','','',0,'ffffff',0,0,21605,5,'Yes',4),(5187,'','','','No',0,'',3,'http://www.discoverqueensland.com.au/giftvouchers/','2-image-1-2018-12-10-13-08-25.jpg','','','','','','','','','','','','','',0,'',1,0,21576,2,'No',0),(5186,'<div style=\"text-align: center;\">\r\n	<font face=\"arial, helvetica, sans-serif\"><span style=\"font-size: 24px;\"><b>Unlimited Dining &amp; Kids Club Await on your Cruise</b></span></font></div>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',0,0,21575,1,'No',8),(5185,'<div style=\"text-align: center;\">\r\n	<span style=\"font-family:arial,helvetica,sans-serif;\"><span style=\"font-size: 24px;\"><b>Indulge in a Brisbane City Retreat</b></span></span></div>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',0,0,21575,1,'No',4),(5184,'<div style=\"text-align: center;\">\r\n	<span style=\"font-family:arial,helvetica,sans-serif;\"><span style=\"font-size: 24px;\"><b>Escape to the Gold Coast for Family Fun</b></span></span></div>\r\n','','','No',10,'',1,'','','','','','','','','','','','','','','',0,'',0,0,21575,1,'No',1);

--
-- Table structure for table `promotionsms`
--

CREATE TABLE `promotionsms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `from` varchar(200) NOT NULL,
  `sms_start_dt` datetime NOT NULL,
  `content` text NOT NULL,
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionsms`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionsms` VALUES (4,'','2020-02-04 00:00:59','',21666),(3,'','2017-07-06 00:00:59','',1742),(2,'','2015-12-16 00:00:59','',842),(1,'MyHightide','2013-12-26 09:00:59','Testing again',4);

--
-- Table structure for table `promotionsocial`
--

CREATE TABLE `promotionsocial` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `repeat_ad` int(10) NOT NULL DEFAULT '0',
  `frequency` enum('NA','Daily','Weekly') NOT NULL DEFAULT 'NA',
  `repeat_end_dt` datetime NOT NULL,
  `message` text NOT NULL,
  `use_exact` enum('Yes','No') NOT NULL DEFAULT 'No',
  `keywords` text NOT NULL,
  `explanation` text NOT NULL,
  `promotion_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotionsocial`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotionsocial` VALUES (2,0,'NA','2015-12-16 00:00:59','','No','','',842),(1,0,'NA','2013-12-25 00:00:59','Message','Yes','gold coast\r\nfamily','First you get the money.',4);

--
-- Table structure for table `promotiontracking`
--

CREATE TABLE `promotiontracking` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `src` varchar(40) NOT NULL,
  `suffix` varchar(200) NOT NULL,
  `comment` varchar(200) NOT NULL,
  `code` varchar(200) NOT NULL,
  `promotion_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotiontracking`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `promotiontracking` VALUES (95,'SM','','','5cTEXg',21955),(94,'FB','','','2WLrIg',21955),(93,'NL','','','jNZgoV',21955),(92,'GA','','','mK3z1I',21955),(91,'SM','','','rS0fF7',21779),(90,'FB','','','ZzTwF3',21779),(89,'NL','','','pb69r4',21779),(88,'GA','','','mYafVr',21779),(87,'SM','','','kseb8T',21843),(86,'FB','','','jcl6Iw',21843),(85,'NL','','','lRgH4q',21843),(84,'GA','','','3Mm14v',21843),(83,'SM','','','2oTbqM',21767),(82,'FB','','','PW4mjC',21767),(81,'NL','','','gjYnLQ',21767),(80,'GA','','','sw3WFC',21767),(79,'SM','','','MNXPI7',21623),(78,'FB','','','nPQqc3',21623),(77,'NL','','','bC9Paf',21623),(76,'GA','','','KA1Sdo',21623),(75,'SM','','','E6AjG3',21492),(74,'FB','','','cdW3jU',21492),(73,'NL','','','G8e5RY',21492),(72,'GA','','','lAQ5Fp',21492),(71,'SM','','','4lFDw9',21449),(70,'FB','','asdf','JWQXOy',21449),(69,'NL','','','TtEaoK',21449),(68,'GA','','','veFmJK',21449),(67,'SM','','','mCKzSF',21459),(66,'FB','','','cuYZgP',21459),(65,'NL','','','OMAd26',21459),(64,'GA','','','2Ck4xI',21459),(63,'SM','','','6NO7FG',21464),(62,'FB','','','l2MZvF',21464),(61,'NL','','','A37GKN',21464),(60,'GA','','','BWdo7n',21464),(59,'SM','','','eATZIU',21039),(58,'FB','','','dQPnxc',21039),(57,'NL','','','tLVJcG',21039),(56,'GA','','','xabIMp',21039),(55,'SM','','','ZuJqwC',20829),(54,'FB','','','RTHtLW',20829),(53,'NL','','','9tJ1X7',20829),(52,'GA','','','5tU7Or',20829),(51,'SM','','','5EP2vr',20655),(50,'FB','','','K347rY',20655),(49,'NL','','','4aPuJr',20655),(48,'GA','','','14L8HE',20655),(47,'SM','','','YF6azy',20627),(46,'FB','','','6aXlt0',20627);

--
-- Table structure for table `propertycomments`
--

CREATE TABLE `propertycomments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `comment` text NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `administrator_id` int(10) NOT NULL DEFAULT '0',
  `created_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertycomments`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertycomments` VALUES (43,'','<strong>From:</strong> The Phoenician Administration &lt;<a href=\"mailto:admin@phoenician.com.au\">admin@phoenician.com.au</a>&gt;<br />\r\n<strong>Sent:</strong> Thursday, 23 July 2020 3:24 PM<br />\r\n<strong>To:</strong> Katrina South &lt;<a href=\"mailto:Katrina.South@leisure.com.au\">Katrina.South@leisure.com.au</a>&gt;<br />\r\n<strong>Subject:</strong> RE: agreement<br />\r\n&nbsp;<br />\r\nHi Katrina,<br />\r\n&nbsp;<br />\r\nThank you for your time on the phone.<br />\r\n&nbsp;<br />\r\nPlease find attached signed copy of agreement.<br />\r\n&nbsp;<br />\r\nLook forward to working with you and the team.<br />\r\n&nbsp;<br />\r\nThanks Katrina<br />\r\n&nbsp;<br />\r\nKind regards,<br />\r\n&nbsp;<br />\r\nIsabelle Lofthouse<br />\r\n<br />\r\n',3076,4,'2020-07-27 13:48:45'),(42,'','27 Jul 2020 - Property reinstated and added to distribution channels',3076,4,'2020-07-27 13:47:23'),(41,'','<strong>From:</strong> Michelle Wyer [<a href=\"mailto:michelle.wyer@leisure.com.au\">mailto:michelle.wyer@leisure.com.au</a>]<br />\r\n<strong>Sent:</strong> Friday, 25 May 2018 10:37 AM<br />\r\n<strong>To:</strong> &#39;reservations@phoenician.com.au&#39;<br />\r\n<strong>Subject:</strong> RE: Leisure Group<br />\r\n<strong>Importance:</strong> High<br />\r\n&nbsp;<br />\r\nHi Renae<br />\r\n&nbsp;<br />\r\nHope you are well.<br />\r\nI just realised that I haven&#39;t terminated you in our system as yet. I will do this now...My apologies.<br />\r\nCould you please advise if you would like to continue working with us?<br />\r\nPhoenician is a very popular product with our customers and it would be fantastic to come to an arrangement that benefits us both.<br />\r\n&nbsp;<br />\r\nKind regards<br />\r\n&nbsp;<br />\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				Michelle Wyer<br />\r\n				Product Executive<br />\r\n				<strong>Leisure Group</strong><br />\r\n				<strong>e: </strong><a href=\"mailto:michelle.wyer@leisure.com.au\">michelle.wyer@leisure.com.au</a><br />\r\n				<strong>t:</strong> 07 5555 1818</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<br />\r\n',3076,4,'2020-07-27 13:46:43'),(40,'','<strong>From:</strong> <a href=\"mailto:reservations@phoenician.com.au\">reservations@phoenician.com.au</a> [<a href=\"mailto:reservations@phoenician.com.au\">mailto:reservations@phoenician.com.au</a>]<br />\r\n<strong>Sent:</strong> Tuesday, 9 January 2018 3:53 PM<br />\r\n<strong>To:</strong> Michelle Wyer<br />\r\n<strong>Subject:</strong> RE: Leisure Group<br />\r\n&nbsp;<br />\r\nHi,<br />\r\n&nbsp;<br />\r\nThank you for your email. I have spoken to Roger and we would like to give notice to terminate the&nbsp; attached contract. We understand that this will take 3 months. We will then look at either a reduction in commission or look at doing another contract with contracted nett rates. Thank you.<br />\r\n&nbsp;<br />\r\n&nbsp;<br />\r\nKind Regards,<br />\r\n&nbsp;<br />\r\n<strong>Renae Ireland </strong><br />\r\n&nbsp;<br />\r\nReservations Manager&nbsp;<br />\r\n<br />\r\n',3076,4,'2020-07-27 13:46:14'),(39,'','21Apr20 - Property disabled as it has gone to residential',13088,4,'2020-04-21 09:15:55'),(38,'','15Apr20 - disabled due to no bookings since 2017 and no rates received or channel manager',8845,4,'2020-04-15 15:51:52'),(37,'','Originally contracted with Dreamtime Resorts',2978,4,'2020-04-09 14:23:37'),(36,'','19Dec19 - Change of management',27,4,'2020-04-09 13:44:13'),(35,'','10Oct2016 - Management changed',3945,4,'2020-04-09 10:37:49'),(34,'','24Jul19 - name change from Coral Sea Resort to Coral Sea Marina Resort',257,4,'2020-04-08 11:38:23'),(33,'','Property removed from distribution channels on 10Sep19 due to bushfire loss',11873,4,'2020-04-08 11:04:47'),(32,'','Property disabled. No bookings since 2015 and no response to contract rate requests.',284,4,'2020-04-08 10:26:55'),(31,'','Property disabled due to management change. Now ibis Styles Port Macqarie.<br />\r\nLast booking made August 2017.',9018,4,'2020-04-08 10:25:37'),(30,'','Property closed from 4 April to 31 May 2020 due to COVID-19',12569,4,'2020-04-08 08:21:01'),(29,'','Property removed from distribution channels as resort closed permanently due to COVID-19.',12269,4,'2020-04-08 08:16:33'),(28,'','21Jul16 - property added via email (no contract)',9564,4,'2020-04-01 09:43:05'),(27,'','21Jul16 - property added via email (no contract)',3917,4,'2020-04-01 09:42:49'),(26,'','21Jul16 - property added via email (no contract)',9563,4,'2020-04-01 09:42:23'),(25,'','9Sep19 - Property closed',211,4,'2020-04-01 09:16:34'),(24,'','Spoke to Jess, confirmed happy for us to go out on Monday the 3rd and the affiliates on tghe 20th (thereablouts) Sep.&nbsp;',9413,5,'2018-08-29 11:22:36'),(23,'','Removed from distribution channels until new contract is received.<br />\r\n<br />\r\nGood afternoon,<br />\r\n<br />\r\nThank you for your support of the Chifley Plaza Townsville. The hotel has re-branded to Madison Plaza Townsville effective immediately.<br />\r\n<br />\r\nIt is our understanding that the new management are keen to continue working with LeisureCom Travel Group and welcoming your travellers to Townsville.&nbsp;<br />\r\n<br />\r\nIf you would like to confirm your contracted rates with the property please contact the hotel directly on the below details:<br />\r\n<br />\r\nSharna Baldonado<br />\r\nMadison Plaza Townsville<br />\r\nPh: 07 4772 1888 E: <a href=\"mailto:manager@madisontownsville.com.au\">manager@madisontownsville.com.au</a><br />\r\n<br />\r\nWe appreciate the support shown to Chifley Plaza Townsville by LeisureCom Travel Group, and we look forward to continuing to work with you across our network of Next Hotels.<br />\r\n<br />\r\nWarm Regards,<br />\r\n<br />\r\nSharon Cauldwell<br />\r\n<a href=\"mailto:sales@nextstory.com\">sales@nextstory.com</a><br />\r\n0416 010 129',9210,4,'2017-08-31 13:24:32'),(22,'','Spoke to Rod sent LC information about reconnecting - Will follow up next week :)',128,5,'2017-03-01 16:03:42'),(21,'','<p>\r\n	<br />\r\n	Hi Sharyon,<br />\r\n	<br />\r\n	Thanks for the quick chat today, as discussed I have temporarily held the date of 27<sup>th</sup> March to run our promotion for Elysium Palm Cove.<br />\r\n	<br />\r\n	The promotion I had in mind was a <strong>HOT DEAL</strong> for both our Retail and Member Program. The deal should run exclusively with LeisureCom for the sale period which would be one week from the 27<sup>th</sup> March.<br />\r\n	<br />\r\n	Deals that typically work are our <strong>&lsquo;Stay Pay&rsquo;</strong> offers and value add deals for example Breakfast included, Late check out, Free Wifi, Spa vouchers etc. If the value of the offer is what we would consider a Catalogy A offer we may be able to run an Property Specific EDM, Deal of the Week or even a 3 Day Sale.<br />\r\n	<br />\r\n	I have also attached our company PDF for your perusal, I am sure Martin went through this with you anyway as well as a marketing Agreement <em><u>please only complete the Specials section as we already have the other details</u></em> J<br />\r\n	<br />\r\n	<br />\r\n	<strong><u>Applicable LeisureCom Brands</u></strong></p>\r\n<p>\r\n</p>\r\n<ul>\r\n	<li>\r\n		Discover Queensland</li>\r\n	<li>\r\n		Hightide Holidays Membership Travel Club (Paid Closed- User Member)</li>\r\n</ul>\r\n<p style=\"margin-left:36.0pt;\">\r\n</p>\r\n<p>\r\n	<strong><u>Promotion Channels</u></strong></p>\r\n<p>\r\n</p>\r\n<p>\r\n	The majority of business will be driven from our Discover Queensland brand, and as a partnered property Hamilton Island will have access to be featured to our loyal customers via:</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Facebook </strong>- 182,000 Followers - &nbsp;<a href=\"www.facebook.com/discoverqueensland\">www.facebook.com/discoverqueensland</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Instagram</strong> - 65,000 Followers - <a href=\"https://www.instagram.com/discoverqueensland/\">https://www.instagram.com/discoverqueensland/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	170,000 <strong>Email Database</strong> - Strong female (35 - 55yrs) &amp; family skew who have signed up to receive premium 4-5 Star Queensland holiday offers</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>Hightide Holidays</strong> - 80,000 Email Database with baby-boomer skew and marginal family skew</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong><u>Promotion Opportunities</u></strong></p>\r\n<p>\r\n</p>\r\n<p>\r\n	In additional to year-round business, we also offer the following campaign options to assist with driving base business or to fill gaps as required:</p>\r\n<p>\r\n</p>\r\n<p>\r\n	- Hot Deals (premium website placement): <a href=\"http://www.discoverqueensland.com.au/hot-deals/\">http://www.discoverqueensland.com.au/hot-deals/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	- 3 Day Sales (Avg. 1,000 - 2,500 room nights per sale) <a href=\"http://www.discoverqueensland.com.au/offers/979/email/\">http://www.discoverqueensland.com.au/offers/979/email/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	- Deal of the Week (Avg. 500 - 1,500 room nights per sale) &nbsp;<a href=\"http://www.discoverqueensland.com.au/newsletter/1190/email/\">http://www.discoverqueensland.com.au/newsletter/1190/email/</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	- Monthly featured Hot Deals EDM &nbsp;<a href=\"http://www.discoverqueensland.com.au/newsletter/1186/email/?preview=true\">http://www.discoverqueensland.com.au/newsletter/1186/email/?preview=true</a></p>\r\n<p>\r\n	<br />\r\n	Thanks again Sharyon,</p>\r\n',9641,5,'2017-02-22 14:33:38'),(20,'','<p>\r\n	Hey Mish,</p>\r\n<p>\r\n	Can you please change the e-mail for Ibis Styles Katherine to</p>\r\n<p>\r\n	<a href=\"mailto:h3112-re01@accor.com\">h3112-re01@accor.com</a></p>\r\n<p>\r\n	the one that is currently loaded is for Ibis Styles Alice Springs. Cheers J</p>\r\n<p>\r\n	Kind Regards,<br />\r\n	Dee Riediger</p>\r\n<p>\r\n	<strong>Reservations Consultant </strong><br />\r\n	Email: <a href=\"mailto:dee.riediger@leisurecom.com\">dee.riediger@leisurecom.com</a><br />\r\n	Direct: 07 5581 2409</p>\r\nLevel 1 - 2, 79B Scarborough St, Southport, QLD 4215<br />\r\nPO Box 3419, Australia Fair, QLD 4215<br />\r\nT: +61 7 5555 1800<br />\r\nF: +61 7 5531 1350<br />\r\nW: <a href=\"http://www.leisurecom.com\">www.leisurecom.com</a>',9035,4,'2017-01-12 13:54:58'),(19,'','Property disabled from channels due to closure (see email)',3714,4,'2016-09-20 14:14:00'),(18,'','<p>\r\n	All fixed :)</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Christie [<a href=\"mailto:christie@1800schoolies.com.au\">mailto:christie@1800schoolies.com.au</a>]<br />\r\n	<strong>Sent:</strong> Wednesday, 7 September 2016 1:48 PM<br />\r\n	<strong>To:</strong> Michelle Wyer<br />\r\n	<strong>Subject:</strong> Hilton Week 1, 2016</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					Hey Mish,</p>\r\n				<p>\r\n					<br />\r\n					Can you please update the website for Hilton Week 1 this year 2 Deluxe Residence to available as we have had a lot of cancellation.</p>\r\n				<p>\r\n					If we could please add 10 to the allotment that would be awesome.</p>\r\n				<p>\r\n					Kind Regards,<br />\r\n					Christie Thompson</p>\r\n				<p>\r\n					<strong>Reservations Consultant </strong><br />\r\n					Email: <a href=\"mailto:Christie@1800schoolies.com.au\">Christie@1800schoolies.com.au</a><br />\r\n					Direct: 07 5581 2453</p>\r\n				<p>\r\n					Level 1 - 2, 79B Scarborough St, Southport, QLD 4215<br />\r\n					PO Box 3419, Australia Fair, QLD 4215<br />\r\n					T: +61 7 5555 1800<br />\r\n					F: +61 7 5531 1350<br />\r\n					W: <a href=\"http://www.1800schoolies.com.au\">www.1800schoolies.com.au</a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n</p>\r\n',3944,4,'2016-09-07 13:58:27'),(17,'','<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks for sending these through, much appreciated.</p>\r\n<p>\r\n	As requested please find attached our Credit Application form for your completion.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I&rsquo;ll complete your marketing agreements for both 16.17 and 17.18 and get these back to you ASAP.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n',9589,4,'2016-09-07 11:16:44'),(16,'','<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	As promised please find attached your completed Marketing Agreement for both 16.17 and 17.18.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I noticed your agreements didn&rsquo;t have any sections to include our bonus offers. Do you have another form for me to complete for these?</p>\r\n<p>\r\n	I&rsquo;m quite interested in looking to promote our upcoming Stay 4, Pay 3 offer to your databases &ndash; the travel period starts 17 October through to 09 December 2016, inclusive.</p>\r\n<p>\r\n	Can you let me know if this will be possible?</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Please let me know if you require any further assistance or information.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n',9589,4,'2016-09-07 11:16:09'),(15,'','<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Please find attached our current activities list &ndash; please note that all prices are non-commissionable.<br />\r\n	Also listed in this attachment are a sample of our daily Orpheus Experience tours/activities that are included in our room rates.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Let me know if you have any further queries.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Michelle Wyer [<a href=\"mailto:michelle.wyer@leisurecom.com\">mailto:michelle.wyer@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Monday, 5 September 2016 4:43 PM<br />\r\n	<strong>To:</strong> Tammy Baczynski &lt;<a href=\"mailto:Tammy@orpheus.com.au\">Tammy@orpheus.com.au</a>&gt;<br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Tammy</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Appreciate your quick reply thanks.</p>\r\n<p>\r\n	I&#39;m wondering if you have a simple list of resort activities?</p>\r\n<p>\r\n	I&#39;ve had a look through your website and your e-brochure etc and the main things I can see are diving, snorkelling, dinghy adventure, research station tour and cruises.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks</p>\r\n<p>\r\n	Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Tammy Baczynski [<a href=\"mailto:Tammy@orpheus.com.au\">mailto:Tammy@orpheus.com.au</a>]<br />\r\n	<strong>Sent:</strong> Monday, 5 September 2016 3:40 PM<br />\r\n	<strong>To:</strong> &#39;Michelle Wyer&#39;<br />\r\n	<strong>Cc:</strong> &#39;Rebecca Tarrant&#39;; &#39;martin.peirone@leisurecom.com&#39;<br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks for sending these through, much appreciated.</p>\r\n<p>\r\n	As requested please find attached our Credit Application form for your completion.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I&rsquo;ll complete your marketing agreements for both 16.17 and 17.18 and get these back to you ASAP.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thanks,</p>\r\n<p>\r\n	Tammy</p>\r\n<p>\r\n	ph: +61 (0)7 4722 2223 | Mob: + 61 (0) 476 814 865</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Michelle Wyer [<a href=\"mailto:michelle.wyer@leisurecom.com\">mailto:michelle.wyer@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Monday, 5 September 2016 2:56 PM<br />\r\n	<strong>To:</strong> Tammy Baczynski &lt;<a href=\"mailto:Tammy@orpheus.com.au\">Tammy@orpheus.com.au</a>&gt;<br />\r\n	<strong>Cc:</strong> &#39;Rebecca Tarrant&#39; &lt;<a href=\"mailto:rebecca.tarrant@leisurecom.com\">rebecca.tarrant@leisurecom.com</a>&gt;; <a href=\"mailto:martin.peirone@leisurecom.com\">martin.peirone@leisurecom.com</a><br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Tammy</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Many thanks for sending through the contracts. I have attached the signed copies of each.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	For our records, could you please complete and return our 2016/17 Marketing Agreement?</p>\r\n<p>\r\n	Also attached is our remittance process to explain how we pay you.</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Do we need to complete a credit application? If so, please forward it to me and I&#39;ll pass it onto our accounts department.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	If you have any questions, please don&#39;t hesitate to contact me.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Kind regards</p>\r\n<p>\r\n	Michelle</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<img alt=\"email footer10.jpg\" border=\"0\" height=\"252\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image001.jpg\" style=\"height:2.625in;width:9.916in;\" width=\"952\" /></p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Rebecca Tarrant [<a href=\"mailto:rebecca.tarrant@leisurecom.com\">mailto:rebecca.tarrant@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Thursday, 1 September 2016 1:43 PM<br />\r\n	<strong>To:</strong> <a href=\"mailto:martin.peirone@leisurecom.com\">martin.peirone@leisurecom.com</a>; &#39;Michelle Wyer&#39;<br />\r\n	<strong>Cc:</strong> <a href=\"mailto:karsha.stewart@leisurecom.com\">karsha.stewart@leisurecom.com</a>; &#39;Dan Berman&#39;<br />\r\n	<strong>Subject:</strong> FW: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Tammy Baczynski [<a href=\"mailto:Tammy@orpheus.com.au\">mailto:Tammy@orpheus.com.au</a>]<br />\r\n	<strong>Sent:</strong> Thursday, September 1, 2016 1:39 PM<br />\r\n	<strong>To:</strong> &#39;Rebecca Tarrant&#39;<br />\r\n	<strong>Subject:</strong> RE: LeisureCom</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Hi Rebecca</p>\r\n<p>\r\n</p>\r\n<p>\r\n	It was great to chat with you the other week and in reviewing this information we would love to work with Leisure.com.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	As this is a new relationship, I have attached 20% commissionable contracts for both the remainder of 2016.17 and 2017.18.</p>\r\n<p>\r\n	We can review this in 12months to discuss a possible change in commission.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	For 2016.17 there are 3 x contracts:</p>\r\n<p>\r\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Nightly rates</p>\r\n<p>\r\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pay 3, Stay 4</p>\r\n<p>\r\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Orpheus Experience (10% off all year, min 4nts)</p>\r\n<p>\r\n</p>\r\n<p>\r\n	For 2017.18, I have consolidated the contracts into one document (much easier).</p>\r\n<p>\r\n	Can you please review, sign off and return a copy by email to accept?</p>\r\n<p>\r\n	FYI, there is no signature page on the 2016.17 documents, however please print and sign your name and date the front page of each.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	At present our Stay 4, Pay 3 offer kicks in for travel from 18 Oct &ndash; 09 Dec 16. I&rsquo;d be interested in working with you on a campaign for this offer.</p>\r\n<p>\r\n	FYI our domestic avg. booking lead in is 6-8 weeks.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Also here is a <a href=\"https://www.dropbox.com/sh/yorgpt177zvtz93/AABs3dbXdlEYvIoA5SODj3QFa?dl=0\">Dropbox download link</a> to our gorgeous image library for your use, please credit all images to Orpheus Island.</p>\r\n<p>\r\n	It is a requirement to send a proof for sign off to myself before distribution of any of our images.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I have also attached some editorial and here is a link to our <a href=\"http://www.orpheus.com.au/wp-content/uploads/2015/04/Orpheus-E-Brochure.pdf\">Orpheus eBrochure</a></p>\r\n<p>\r\n</p>\r\n<p>\r\n	I think I have covered everything to get us started. Please let me know if there is anything else I can help you with.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	I look forward to working with you.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	magical Orpheus awaits,</p>\r\n<p>\r\n	Tammy Baczynski</p>\r\n<p>\r\n	Sales &amp; Marketing Manager</p>\r\n<p>\r\n	<strong><img alt=\"Orpheus_logo_Olive small (HR)\" border=\"0\" height=\"116\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image002.jpg\" style=\"height:1.208in;width:2.166in;\" width=\"208\" /></strong></p>\r\n<p>\r\n	Direct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +61 (0) 7 4722 2223</p>\r\n<p>\r\n	Email&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"mailto:tammy@orpheus.com.au\">tammy@orpheus.com.au</a></p>\r\n<p>\r\n	Web&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http://www.orpheus.com.au/\">www.orpheus.com.au</a></p>\r\n<p>\r\n	Mob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +61 476 814 865</p>\r\n<p>\r\n	Fax&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +61 (0) 3 8644 4001</p>\r\n<p>\r\n	Mail&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;PO Box 549, Garbutt East QLD Australia 4814</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n<p>\r\n	<strong>From:</strong> Rebecca Tarrant [<a href=\"mailto:rebecca.tarrant@leisurecom.com\">mailto:rebecca.tarrant@leisurecom.com</a>]<br />\r\n	<strong>Sent:</strong> Wednesday, 17 August 2016 3:29 PM<br />\r\n	<strong>To:</strong> Tammy Baczynski &lt;<a href=\"mailto:Tammy@orpheus.com.au\">Tammy@orpheus.com.au</a>&gt;<br />\r\n	<strong>Subject:</strong> LeisureCom<br />\r\n	<strong>Importance:</strong> High</p>\r\n<p>\r\n</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td style=\"height:10px;\">\r\n				<p>\r\n					<img alt=\"http://www.leisurecom.com/images/ems/1px-trans.gif\" border=\"0\" height=\"32\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image003.gif\" style=\"height:.333in;width:.333in;\" width=\"32\" /></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					<img alt=\"LeisureCom Group Ltd\" border=\"0\" height=\"179\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image004.jpg\" style=\"height:1.864in;width:4.281in;\" width=\"411\" /></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					Hi Tammy,<br />\r\n					<br />\r\n					Was so lovely speaking with you and I am so excited about working together. Here is the company information and Channel manager form for any properties you have with Siteminder or Levart, we can connect pretty quickly and start sending 365 business. As discussed there may be some upcoming promotions that may suit your resorts. We have our 3 Day Sales these are heavily discounted specials usually up to 505 off with inclusions and we can typically produce around 2000 &ndash; 4000 room nights in the 3 days (depending on the deal). Other options are our Deal of the Week and normal EDM these would suit a lower discounted offer and could produce up to 1000 room nights, again depending on the offer. We have a database of 250,000 in our Discover Queenlsand brand and over 200,000 Closed user in our HighTide Member program, we could also access another 1,000,000 through our partners including Ambassador Card, AGL, NIB and more.<br />\r\n					<br />\r\n					Please check out our retail site <a href=\"http://www.discoverqueensland.com.au\">www.discoverqueensland.com.au</a> &nbsp;also our corporate site <a href=\"http://www.leisurecom.com\">www.leisurecom.com</a><br />\r\n					<br />\r\n					Here is an example of our Marriott Surfers Paradise offer we did in April &ndash; This produced just shy of 2000 room nights<br />\r\n					<br />\r\n					<br />\r\n					EDM&nbsp; <a href=\"http://www.discoverqueensland.com.au/offers/436/email/?source=Newsletter\">http://www.discoverqueensland.com.au/offers/436/email/?source=Newsletter</a> &nbsp;<br />\r\n					<br />\r\n					TVC <a href=\"https://www.youtube.com/watch?v=TzYkQFOiO9k\">https://www.youtube.com/watch?v=TzYkQFOiO9k</a><br />\r\n					<br />\r\n					We typically work off a wholesale 25% for 365 business but can move on this when doing tactical campaigns like the above which would be 20%.<br />\r\n					<br />\r\n					There is no cost to you other than the commissions we make as we pay to promote your resort through our own networks and SEO/SEM.<br />\r\n					<br />\r\n					I think I covered everything if there is anything else please let me know, Thanks again<br />\r\n					<br />\r\n					Kind Regards,<br />\r\n					Rebecca Tarrant<br />\r\n					<br />\r\n					Email: <a href=\"mailto:Rebecca.Tarrant@leisurecom.com\">Rebecca.Tarrant@leisurecom.com</a><br />\r\n					Mobile: 0402 525 968</p>\r\n				<p>\r\n					Level 1 - 2, 79B Scarborough St, Southport, QLD 4215<br />\r\n					PO Box 3419, Australia Fair, QLD 4215<br />\r\n					T: +61 7 5555 1800<br />\r\n					F: +61 7 5531 1350<br />\r\n					W: <a href=\"http://www.leisurecom.com\">www.leisurecom.com</a></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n</p>\r\n',9589,4,'2016-09-07 11:15:23'),(14,'','<p>\r\n	Hi Everyone,</p>\r\n<p>\r\n	An issue has just been discovered with the swimming pool at Artique Resort which has resulted in the need to drain the pool and instigate emergency repairs effective immediately.</p>\r\n<p>\r\n	At this stage we have been informed that the pool may be out of order up until approximately 9th September 2016, however we will update this site once a date has been confirmed as we hope the repairs will be completed sooner.</p>\r\n<p>\r\n	All other facilities, including our beautiful spa, steam room, sauna, gym, theatre &amp; BBQ area are available for guests to enjoy and we are currently sourcing temporary access for our guests to a pool at a nearby resort and will confirm when determined.</p>\r\n<p>\r\n	We deeply regret any inconvenience to our guests and should you have any questions or ongoing concerns, please do not hesitate to call us on 07 5564 3100. As a gesture of good faith, we have temporarily reduced rates at the resort during this time for new bookings.&nbsp; For existing bookings we are managing this at resort level as guests vary in their requirements however, we would welcome the opportunity to resolve any issues with your clients should there be any concerns.&nbsp;&nbsp;</p>\r\n<p>\r\n	We are very sorry for the inconvenience and appreciate your understanding in this unexpected situation.&nbsp;&nbsp; Could you please advise your who may be staying at Artique during this period and also place a notification on your website to cover guests wishing to <strong>TRAVEL</strong> before 9<sup>th</sup> September, 2016. &nbsp;&nbsp;WE will update you as soon as we are aware of the completion date.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Thank you for your co-operation.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Kindest regards</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Steve Brewster&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n<p>\r\n	<strong>Director of Sales &amp; Marketing</strong></p>\r\n<p>\r\n	<strong><img alt=\"Icon jpeg for signature\" height=\"104\" src=\"file:///C:\\Users\\MICHEL~1\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image001.jpg\" style=\"height:1.083in;width:2.239in;\" width=\"215\" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></p>\r\n<p>\r\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n<p>\r\n	<strong>Icon Resort Apartments</strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>Mobile:</strong> &nbsp;+61 412 641 203&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />\r\n	<strong>25 Surf Parade&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email:&nbsp;&nbsp; </strong>&nbsp;<u><a href=\"mailto:steve@iconresortapartments.com.au\">steve@iconresortapartments.com.au</a></u><br />\r\n	<strong>Broadbeach QLD 4218&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Web:</strong>&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http://www.iconresortapartments.com.au/\">www.iconresortapartments.com.au</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\r\n',30,4,'2016-08-29 09:32:07'),(13,'test','abakljl;jdfl;kjasd;lfkjas',2,4,'2016-08-24 10:00:44'),(12,'','Emailed Karla - Marketing &amp; Sales',130,5,'2015-06-17 12:19:42'),(11,'','new managers come is - GAVIN cb in a couple of weeks',18,5,'2015-05-13 14:05:37'),(10,'','call back week starting 18th as sandra on holidays',3883,5,'2015-05-13 14:03:24'),(9,'','called left msg for Heidi as Australian escapes rates cheaper ',3974,5,'2015-05-13 13:54:31'),(8,'','Spoke to Sandra she received email spending next week to go through and will touch base then :)',3883,5,'2015-04-16 11:37:29'),(7,'','Hi Larry,<br />\r\n<br />\r\nIt was great speaking with you today, we are constantly receiving requests for your resort as it was always very popular amongst our members both Escapes Club &amp; HighTide and would love to be able to send some bookings through. We also have our Retail distribution channel Discover QLD who would love to work with you and run some hot deals.<br />\r\n<br />\r\nI have put together some information about us at <a href=\"http://www.hightidemarketing.com.au\">www.hightidemarketing.com.au</a> as well as attached some info.<br />\r\n<br />\r\nWe are not a typical OTA we facilitate the whole booking including payments and remittances as well as marketing your resort to our members through EDM, website and social media promotions, our Discover QLD has over 120,000 followers on Social Media. We spend money marketing your resort for periods when the occupancy is low to help fill these otherwise empty rooms.<br />\r\n<br />\r\nSome other information that may not be included online is that we have over 250,000 active travelling members and our main demographic are semi-retirees and young families who typically travel in your off peak seasons.<br />\r\n<br />\r\nWe have over 500,000 vouchers in the market place that need to be redeemed.<br />\r\n<br />\r\nAlso you will notice the rates we promote are 3 night packages, we pro-rata extra nights however we do encourage members to use two back to back vouchers (2 x 3 nights) and receive the 7<sup>th</sup> night Free, this is optional however does help push the longer stays.<br />\r\n<br />\r\nWe also work with channel managers to make the reservations process very easy.<br />\r\n<br />\r\nLet me know if you have any questions and I will be in touch with you shortly, If your happy to move forward just send me back the agreement and we can get you loaded into our system and start sending some bookings your way J',18,5,'2015-04-16 11:33:36'),(6,'','Spoke to Larry and sending him information re HIGHTIDE and LC',18,5,'2015-04-16 11:27:09'),(5,'','<p>\r\n	9Jan15 - Restaurant is now being managed by Oaks Hotels &amp; Resorts. Open for breakfast, lunch and dinner 7 days a week with indoor and outdoor dining available.</p>\r\n',190,4,'2015-01-15 11:58:28');

--
-- Table structure for table `propertycontact`
--

CREATE TABLE `propertycontact` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `mobile` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `position` varchar(200) NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertycontact`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertycontact` VALUES (82,'Mr','Craig & Zsofi','Popplewell','07 5448 1955','','info@glenedenresort.com.au','Manager',2949),(81,'Mr','Michael','Goh','07 5538 2099','','info@genesisapartments.com.au','Manager',12851),(80,'Mr','Rob & Carolyne','Moore','07 5471 9800','','holiday@endlesssummerresort.com','Manager',2979),(79,'Ms','Carolyn','Mather','07 5570 1511','','holidays@enderleyresort.com.au','Manager',3909),(78,'Ms','Emma','Taylor','02 4938 8233','','emma@eaglereach.com.au','Manager',289),(77,'Mr','Sting','Pilapil','02 9358 1211','','info@devere.com.au','Manager',3921),(76,'Ms','Rebecca','Rouzbehi','07 5597 9999','','rebecca@courancove.com.au','Sales & Marketing',11930),(75,'Ms','Vicki','Tolhurst','02 4472 6111','','relax@corriganscove.com.au','Manager',287),(74,'Ms','Joscelyn','O\'Keefe','07 4946 2415','','hotel@csmr.com.au','Sales & Marketing',257),(73,'Ms','Cary','Xue','07 5538 7933','','info@chevronpalms.com.au','Manager',8858),(72,'Mr','Tom','Cox','07 5538 9955','','info@centrepointresort.com','Manager',3880),(71,'Ms','Suzi','Cadigan','08 8625 2008','','frontoffice@cednahotel.com.au','Manager',9138),(70,'Mr','Gary','Fitzjohn','07 5592 0011','','info@carmelbythesea.com.au','Manager',67),(69,'Ms','Hannah','Campion','.','0474 447 311','res@caribbeanresort.com.au','Manager',3678),(68,'Ms','Amisha','Jain','07 5538 5877','','info@carltonapartments.com.au','Manager',9071),(67,'Ms','Emma','.','07 4037 0400','','info@cairnsbeachresort.com.au','Other',8801),(66,'Ms','Karla','Haraldstad','07 5535 7188','','karla@burleighresort.com.au','Sales & Marketing',9583),(65,'Mr','Jason','Agnew','07 5589 0000','','gm@blueccoolangatta.com.au','General Manager',2948),(64,'Mr','Leighton','Pitcher','07 5533 3622','','leighton@binnaburralodge.com.au','Sales & Marketing',11873),(63,'Mr','Mark','Small','07 5584 9600','','mark@belairbroadbeach.com','Manager',3019),(62,'Mr','James','Boreham','07 5478 4000','','info@beachsideresort.com.au','Manager',285),(61,'Ms','Sarah','Caton','07 5478 7476','','reception@beachclub.com.au','Manager',3512),(60,'Mr','John & Viv','Tritton','.','0448 508 570','info@bargarablue.com.au','Manager',2963),(59,'Ms','Serena','Chan','07 5527 5933','','info@arubabeach.com.au','Manager',3041),(58,'Ms','Danielle','Oppes','02 6646 8600','','gm@angourieresort.com.au','Manager',39),(57,'Mr','Peter','Gow','07 5592 0966','','info@anacapri.com.au','Manager',9124),(56,'Ms','Kym','Roe','07 4055 6066','','info@amarooresort.com','Manager',340),(55,'Ms','Lorraine','Roughton','08 9754 3311','','stay@amalfiresort.com.au','Manager',206),(54,'Mr','David & Carol','.','07 5444 1600','','info@alexandraonthepacific.com','Manager',37),(53,'Ms','Ruth','Carroll','07 3124 7000','','rom@alexperryhotel.com.au','Manager',11496),(52,'Mr','Jeremy & Christine','Giles','07 4055 6776','','info@trinitybeachclub.com.au','Manager',316),(51,'Ms','Olwyn','Money','07 5584 0700','','info@trilogygoldcoast.com.au','Manager',118),(50,'Ms','Beth','Van Kooten','07 4722 2201','','beth.vankooten@the-ville.com.au','Sales & Marketing',11860),(49,'Mrs','Megan','Zerafa','07 5531 5651','','info@theritzresort.com.au','Other',9675),(48,'Mr','Dan & Nora','Gleeson','07 5448 1922','','info@theretreat.com.au','Manager',3001),(47,'Ms','Carol','Dolling','07 5538 9100','','info@thepenthouses.com.au','Manager',9205),(46,'Ms','Vicki','Scott','07 4053 9400','','gm@thelakescairns.com.au','Manager',236),(45,'Ms','Stacy','Luck','07 5538 8000','','manager@theislandgoldcoast.com.au','Manager',3714),(44,'Mr','Heath','Batterham','02 6639 2138','','heathb@thebyronatbyron.com.au','Sales & Marketing',233),(43,'Ms','Lyn','.','07 5538 5311','','info@thebreakers.com.au','Manager',3761),(42,'Mr','Wade','Bowen','07 4098 5700','','wade@thalabeach.com.au','Sales & Marketing',353),(41,'Ms','Kathryn','Meek','07 6344 3222','','kmeek@tasvillas.com','General Manager',3905),(40,'Ms','Lucy','Tsicalas','07 3637 2141','','contracts@tangalooma.com','Manager',9727),(39,'Mr','Dustin','Allen','07 5538 8863','','info@surfparaderesort.com.au','Manager',337),(38,'Mr','Paul','Kirkpatrick','07 5538 2188','','holidays@silvertonapartments.com.au','Manager',8920),(37,'Mr','Peter','Brown','07 4084 1400','','manager@shantara.com.au','Manager',9146),(36,'Mr','Chuzhang','.','07 5538 7755','','holiday@seacrest.com.au','Manager',2990),(35,'Mr','Simon','Batt','07 4057 5822','','info@seachange-beachfront-apartments.com','Manager',147),(34,'Mr','Garry & Therese','Gray','07 3897 3100','','office@scarboroughbeachresort.com.au','Manager',2991),(33,'Ms','Virginia','Nicolls','07 5534 5077','','enquiries@sansimeon.com.au','Manager',151);

--
-- Table structure for table `propertydocuments`
--

CREATE TABLE `propertydocuments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `group_id` int(10) NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL,
  `doc_type` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `doc` varchar(200) NOT NULL,
  `promotion_type` varchar(200) NOT NULL,
  `promotion_dt` date NOT NULL,
  `contract_year` varchar(200) NOT NULL,
  `added_dt` date NOT NULL,
  `created_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=784 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertydocuments`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertydocuments` VALUES (783,0,'2020/21 Agreement','Rates','',13379,'document-2020-08-06-14-39-06.docx','3 Day Sale','2020-08-06','2020/21','2020-08-06','2020-08-06 14:39:06'),(782,0,'2020-21 Contract','Rates','',3076,'document-2020-07-27-13-54-56.pdf','3 Day Sale','2020-07-27','2020-21','2020-07-27','2020-07-27 13:54:56'),(781,0,'22Jun20 - Resort Closure Email','Emails','',338,'document-2020-06-25-14-46-38.msg','3 Day Sale','2020-06-25','','2020-06-25','2020-06-25 14:46:38'),(780,153,'1Apr20 - Contract Email','Emails','',9601,'document-2020-05-20-09-42-03.msg','3 Day Sale','2020-05-20','','2020-05-20','2020-05-20 09:42:03'),(779,152,'2020/21 Property Contract','Rates','',9601,'document-2020-05-20-09-41-31.pdf','3 Day Sale','2020-05-20','2020/21','2020-05-20','2020-05-20 09:41:31'),(778,151,'2020-21 Agreement','Rates','',9601,'document-2020-05-20-09-40-58.docx','3 Day Sale','2020-05-20','2020/21','2020-05-20','2020-05-20 09:40:58'),(777,147,'2013/14 Contract','Rates','',316,'document-2020-04-15-16-40-46.pdf','3 Day Sale','2020-04-15','2013/14','2020-04-15','2020-04-15 16:40:46'),(776,146,'2012/13 Contract','Rates','',118,'document-2020-04-15-16-34-05.pdf','3 Day Sale','2020-04-15','2012/13','2020-04-15','2020-04-15 16:34:05'),(775,141,'2017/18 Contract','Rates','',9675,'document-2020-04-15-15-59-14.docx','3 Day Sale','2020-04-15','2017/18','2020-04-15','2020-04-15 15:59:14'),(774,139,'2017/18 Contract','Rates','',3001,'document-2020-04-15-15-53-43.pdf','3 Day Sale','2020-04-15','2017/18','2020-04-15','2020-04-15 15:53:43'),(773,136,'2016/17 New Management Form','General Info','',14,'document-2020-04-15-15-41-55.pdf','3 Day Sale','2020-04-15','','2020-04-15','2020-04-15 15:41:55'),(772,135,'2009/10 Contract','Rates','',233,'document-2020-04-15-15-36-46.doc','3 Day Sale','2020-04-15','2009/10','2020-04-15','2020-04-15 15:36:46'),(771,134,'2011/12 Contract','Rates','',3761,'document-2020-04-15-15-29-02.pdf','3 Day Sale','2020-04-15','2011/12','2020-04-15','2020-04-15 15:29:02'),(770,133,'2010/11 Contract','Rates','',353,'document-2020-04-15-15-08-13.doc','3 Day Sale','2020-04-15','2010/11','2020-04-15','2020-04-15 15:08:13'),(769,108,'2014/15 Rates','Rates','',346,'document-2020-04-09-15-36-38.pdf','3 Day Sale','2020-04-09','2014/15','2020-04-09','2020-04-09 15:36:38'),(768,108,'2013/14 Rates','Rates','',346,'document-2020-04-09-15-36-12.pdf','3 Day Sale','2020-04-09','2013/14','2020-04-09','2020-04-09 15:36:12'),(767,108,'2012/13 Rates','Rates','',346,'document-2020-04-09-15-35-47.pdf','3 Day Sale','2020-04-09','2012/13','2020-04-09','2020-04-09 15:35:47'),(766,108,'2011/12 Rates','Rates','',346,'document-2020-04-09-15-34-59.pdf','3 Day Sale','2020-04-09','2011/12','2020-04-09','2020-04-09 15:34:59'),(765,108,'2010/11 Rates','Rates','',346,'document-2020-04-09-15-34-26.pdf','3 Day Sale','2020-04-09','2010/11','2020-04-09','2020-04-09 15:34:26'),(764,105,'12Jun13 - Change of Mangement email','Emails','',8835,'document-2020-04-09-15-28-10.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 15:28:10'),(762,101,'18Dec13 - Rate contract email','Emails','',9168,'document-2020-04-09-15-12-32.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 15:12:32'),(761,98,'1Jun12 - Contract email','Emails','',8865,'document-2020-04-09-14-55-29.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 14:55:29'),(760,95,'22Apr15 - New Management email','Emails','',332,'document-2020-04-09-14-39-47.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 14:39:47'),(759,91,'2019/20 Contract','Rates','',9599,'document-2020-04-09-14-22-25.pdf','3 Day Sale','2020-04-09','2019/20','2020-04-09','2020-04-09 14:22:25'),(758,88,'2018-20 Rates','Rates','',27,'document-2020-04-09-11-11-00.pdf','3 Day Sale','2020-04-09','2018-20','2018-06-08','2020-04-09 11:11:00'),(757,88,'2011/12 Rates','Rates','',27,'document-2020-04-09-11-10-15.xls','3 Day Sale','2020-04-09','2011/12','2010-09-17','2020-04-09 11:10:15'),(756,85,'2016/17 Rates','Rates','',9337,'document-2020-04-09-11-05-06.doc','3 Day Sale','2020-04-09','2016/17','2015-06-18','2020-04-09 11:05:06'),(755,85,'2015/16 Rates','Rates','',9337,'document-2020-04-09-11-04-29.doc','3 Day Sale','2020-04-09','2015/16','2015-06-18','2020-04-09 11:04:29'),(754,84,'16Jul15 - Property Contract email','Emails','',9337,'document-2020-04-09-11-03-44.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 11:03:44'),(753,81,'2012/13 Rates','Rates','',3945,'document-2020-04-09-10-40-41.xls','3 Day Sale','2020-04-09','2012/13','2011-08-30','2020-04-09 10:40:41'),(752,81,'2011/12 Rates','Rates','',3945,'document-2020-04-09-10-40-08.xls','3 Day Sale','2020-04-09','2011/12','2011-02-22','2020-04-09 10:40:08'),(751,82,'10Oct16 - Management Change','Emails','',3945,'document-2020-04-09-10-39-24.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 10:39:24'),(750,79,'2012/13 Rate Email','Emails','',8861,'document-2020-04-09-10-17-23.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 10:17:23'),(749,80,'2011/12 Rate Sheet','Rates','',8861,'document-2020-04-09-10-16-37.docx','3 Day Sale','2020-04-09','2011/12','2020-04-09','2020-04-09 10:16:37'),(748,74,'2012/13 Rates','Rates','',247,'document-2020-04-09-09-51-59.xls','3 Day Sale','2020-04-09','2012/13','2020-04-09','2020-04-09 09:51:59'),(747,73,'2009/10 Contract','Rates','',247,'document-2020-04-09-09-50-05.pdf','3 Day Sale','2020-04-09','2009/10','2020-04-09','2020-04-09 09:50:05'),(746,73,'2008/09 Contract','Rates','',247,'document-2020-04-09-09-49-29.pdf','3 Day Sale','2020-04-09','2008/09','2020-04-09','2020-04-09 09:49:29'),(745,73,'2007/08 Contract','Rates','',247,'document-2020-04-09-09-47-57.pdf','3 Day Sale','2020-04-09','2007/08','2020-04-09','2020-04-09 09:47:57'),(744,71,'2019/20 Contract Email','Emails','',9778,'document-2020-04-09-09-30-11.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 09:30:11'),(743,70,'2019/20 Contract','Rates','',9778,'document-2020-04-09-09-28-42.pdf','3 Day Sale','2020-04-09','2019/20','2019-03-16','2020-04-09 09:28:42'),(742,70,'2018/19 Contract','Rates','',9778,'document-2020-04-09-09-27-58.pdf','3 Day Sale','2020-04-09','2018/19','2018-04-24','2020-04-09 09:27:58'),(741,69,'2017/18 Contract Email','Emails','',2949,'document-2020-04-09-09-20-14.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 09:20:14'),(740,68,'2012/13 Contract','Rates','',2949,'document-2020-04-09-09-19-34.doc','3 Day Sale','2020-04-09','2012/13','2020-04-09','2020-04-09 09:19:34'),(739,68,'2010/11 Contract','Rates','',2949,'document-2020-04-09-09-18-04.pdf','3 Day Sale','2020-04-09','2010/11','2020-04-09','2020-04-09 09:18:04'),(738,67,'2019/20 Contract Email','Emails','',12851,'document-2020-04-09-09-03-57.msg','3 Day Sale','2020-04-09','','2020-04-09','2020-04-09 09:03:57'),(737,66,'2019/20 Contract','Rates','',12851,'document-2020-04-09-09-02-05.pdf','3 Day Sale','2020-04-09','2019/20','2020-04-09','2020-04-09 09:02:05'),(736,64,'2016 Schoolies Contract','Rates','',3909,'document-2020-04-09-08-53-59.pdf','3 Day Sale','2020-04-09','2016','2020-04-09','2020-04-09 08:53:59'),(735,64,'2015 Schoolies Contract','Rates','',3909,'document-2020-04-09-08-53-26.pdf','3 Day Sale','2020-04-09','2015','2020-04-09','2020-04-09 08:53:26'),(734,64,'2014 Schoolies Contract','Rates','',3909,'document-2020-04-09-08-52-37.pdf','3 Day Sale','2020-04-09','2014','2020-04-09','2020-04-09 08:52:37'),(733,64,'2013 Schoolies Agreement','Rates','',3909,'document-2020-04-09-08-51-55.pdf','3 Day Sale','2020-04-09','2013','2020-04-09','2020-04-09 08:51:55');

--
-- Table structure for table `propertydocumentsgroup`
--

CREATE TABLE `propertydocumentsgroup` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `created_dt` datetime NOT NULL,
  `name` varchar(200) NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertydocumentsgroup`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertydocumentsgroup` VALUES (153,'2020-05-20 09:41:39','EMAILS',9601),(152,'2020-05-20 09:40:12','PROPERTY RATE CONTRACTS',9601),(151,'2020-05-20 09:40:00','LEISURE GROUP CONTRACTS',9601),(150,'2020-04-15 16:44:32','SPECIALS',8834),(149,'2020-04-15 16:44:16','PROPERTY RATE CONTRACTS',8834),(148,'2020-04-15 16:44:02','LEISURE GROUP CONTRACTS',8834),(147,'2020-04-15 16:39:40','LEISURE GROUP CONTRACTS',316),(146,'2020-04-15 16:33:33','LEISURE GROUP CONTRACTS',118),(145,'2020-04-15 16:32:28','LEISURE GROUP CONTRACTS',2998),(144,'2020-04-15 16:28:14','PROPERTY RATE CONTRACTS',11860),(143,'2020-04-15 16:27:35','LEISURE GROUP CONTRACTS',11860),(142,'2020-04-15 16:01:49','LEISURE GROUP CONTRACTS',28),(141,'2020-04-15 15:58:01','LEISURE GROUP CONTRACTS',9675),(140,'2020-04-15 15:55:23','LEISURE GROUP CONTRACTS',12),(139,'2020-04-15 15:53:13','LEISURE GROUP CONTRACTS',3001),(138,'2020-04-15 15:48:06','LEISURE GROUP CONTRACTS',9205),(137,'2020-04-15 15:46:52','LEISURE GROUP CONTRACTS',236),(136,'2020-04-15 15:37:52','LEISURE GROUP CONTRACTS',14),(135,'2020-04-15 15:31:23','LEISURE GROUP CONTRACTS',233),(134,'2020-04-15 15:27:47','LEISURE GROUP CONTRACTS',3761),(133,'2020-04-15 15:07:35','LEISURE GROUP CONTRACTS',353),(132,'2020-04-15 14:47:14','LEISURE GROUP CONTRACTS',337),(131,'2020-04-15 14:38:37','LEISURE GROUP CONTRACTS',217),(130,'2020-04-15 14:34:51','SCHOOLIES CONTRACTS',8920),(129,'2020-04-15 14:34:47','LEISURE GROUP CONTRACTS',8920),(128,'2020-04-15 14:25:08','LEISURE GROUP CONTRACTS',2990),(127,'2020-04-15 14:19:47','LEISURE GROUP CONTRACTS',147),(126,'2020-04-15 13:53:07','LEISURE GROUP CONTRACTS',2991),(125,'2020-04-15 13:51:20','LEISURE GROUP CONTRACTS',151),(124,'2020-04-15 13:48:04','LEISURE GROUP CONTRACTS',213),(123,'2020-04-15 11:59:26','LEISURE GROUP CONTRACTS',9174),(122,'2020-04-15 11:57:42','LEISURE GROUP CONTRACTS',209),(121,'2020-04-15 11:55:02','LEISURE GROUP CONTRACTS',9359),(120,'2020-04-15 11:52:15','LEISURE GROUP CONTRACTS',3974),(119,'2020-04-15 11:35:22','LEISURE GROUP CONTRACTS',258),(118,'2020-04-15 10:44:50','LEISURE GROUP CONTRACTS',11639),(117,'2020-04-15 10:40:03','LEISURE GROUP CONTRACTS',3965),(116,'2020-04-15 10:37:47','EMAILS',17),(115,'2020-04-15 10:37:42','LEISURE GROUP CONTRACTS',17),(114,'2020-04-15 10:03:24','LEISURE GROUP CONTRACTS',11808),(113,'2020-04-15 09:31:38','EMAILS',125),(112,'2020-04-15 09:31:33','SPECIALS',125),(111,'2020-04-15 09:31:27','PROPERTY RATE CONTRACTS',125),(110,'2020-04-15 09:31:19','LEISURE GROUP CONTRACTS',125),(109,'2020-04-09 15:49:48','LEISURE GROUP CONTRACTS',3760),(108,'2020-04-09 15:33:37','PROPERTY RATE CONTRACTS',346),(107,'2020-04-09 15:33:27','LEISURE GROUP CONTRACTS',346),(106,'2020-04-09 15:30:27','LEISURE GROUP CONTRACTS',2984),(105,'2020-04-09 15:26:40','EMAILS',8835),(104,'2020-04-09 15:26:33','LEISURE GROUP CONTRACTS',8835);

--
-- Table structure for table `propertyimages`
--

CREATE TABLE `propertyimages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `PropertiesID` int(11) unsigned DEFAULT NULL,
  `Original` varchar(100) DEFAULT NULL,
  `Resized` varchar(100) DEFAULT NULL,
  `Caption` varchar(200) NOT NULL,
  `MembersCaption` varchar(200) NOT NULL,
  `SchooliesCaption` varchar(200) NOT NULL,
  `IsMainImage` enum('Yes','No') NOT NULL DEFAULT 'No',
  `SOrder` int(10) NOT NULL DEFAULT '0',
  `is_changed` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `PropertiesID` (`PropertiesID`),
  KEY `IsMainImage` (`IsMainImage`)
) ENGINE=MyISAM AUTO_INCREMENT=112079 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertyimages`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertyimages` VALUES (112078,3677,'image-2020-08-19-12-24-01.jpg','medium-image-2020-08-19-12-24-01.jpg','1 Bedroom Apartment Living Room','1 Bedroom Apartment Living Room','','No',18,'No'),(112077,3677,'image-2020-08-19-12-23-32.jpg','medium-image-2020-08-19-12-23-32.jpg','2 Bedroom Apartment, Dining and Views','2 Bedroom Apartment, Dining and Views','','No',17,'No'),(112076,3677,'image-2020-08-19-12-22-15.jpg','medium-image-2020-08-19-12-22-15.jpg','3 Bedroom Spa Apartment Balcony Views','3 Bedroom Spa Apartment Balcony Views','','No',16,'No'),(112075,3677,'image-2020-08-19-12-21-58.jpg','medium-image-2020-08-19-12-21-58.jpg','2 Bedroom Apartment Spa Pool','2 Bedroom Apartment Spa Pool','','No',15,'No'),(112074,3677,'image-2020-08-19-12-21-42.jpg','medium-image-2020-08-19-12-21-42.jpg','2 Bedroom Apartment Twin Bedroom','2 Bedroom Apartment Twin Bedroom','','No',14,'No'),(112073,3677,'image-2020-08-19-12-21-32.jpg','medium-image-2020-08-19-12-21-32.jpg','2 Bedroom Apartment Master Bedroom','2 Bedroom Apartment Master Bedroom','','No',13,'No'),(112072,3677,'image-2020-08-19-12-21-16.jpg','medium-image-2020-08-19-12-21-16.jpg','1 Bedroom Apartment','1 Bedroom Apartment','','No',12,'No'),(112071,13391,'image-2020-08-19-11-17-58.jpg','medium-image-2020-08-19-11-17-58.jpg','Entrance','Entrance','','No',19,'No'),(112070,13391,'image-2020-08-19-11-17-25.jpg','medium-image-2020-08-19-11-17-25.jpg','Bathroom','Bathroom','','No',18,'No'),(112069,13391,'image-2020-08-19-11-17-09.jpg','medium-image-2020-08-19-11-17-09.jpg','Swimming Pool','Swimming Pool','','Yes',17,'No'),(112068,13391,'image-2020-08-19-11-16-24.jpg','medium-image-2020-08-19-11-16-24.jpg','Bedroom','Bedroom','','No',16,'No'),(112067,13391,'image-2020-08-19-11-16-18.jpg','medium-image-2020-08-19-11-16-18.jpg','Bedroom','Bedroom','','No',15,'No'),(112066,13391,'image-2020-08-19-11-16-09.jpg','medium-image-2020-08-19-11-16-09.jpg','Bedroom','Bedroom','','No',14,'No'),(112065,13391,'image-2020-08-19-11-15-58.jpg','medium-image-2020-08-19-11-15-58.jpg','Upstairs Living Area','Upstairs Living Area','','No',13,'No'),(112064,13391,'image-2020-08-19-11-15-40.jpg','medium-image-2020-08-19-11-15-40.jpg','Pool Table','Pool Table','','No',12,'No'),(112063,13391,'image-2020-08-19-11-15-31.jpg','medium-image-2020-08-19-11-15-31.jpg','Movie Room','Movie Room','','No',11,'No'),(112062,13391,'image-2020-08-19-11-15-22.jpg','medium-image-2020-08-19-11-15-22.jpg','Kitchen','Kitchen','','No',10,'No'),(112061,13391,'image-2020-08-19-11-15-13.jpg','medium-image-2020-08-19-11-15-13.jpg','Ensutie','Ensutie','','No',9,'No'),(112060,13391,'image-2020-08-19-11-13-38.jpg','medium-image-2020-08-19-11-13-38.jpg','Bedroom','Bedroom','','No',8,'No'),(112059,13391,'image-2020-08-19-11-13-30.jpg','medium-image-2020-08-19-11-13-30.jpg','Canal Side','Canal Side','','No',7,'No'),(112058,13391,'image-2020-08-19-11-13-22.jpg','medium-image-2020-08-19-11-13-22.jpg','Street View','Street View','','No',6,'No'),(112057,13391,'image-2020-08-19-11-12-57.jpg','medium-image-2020-08-19-11-12-57.jpg','BBQ Area','BBQ Area','','No',5,'No'),(112056,13391,'image-2020-08-19-11-12-51.jpg','medium-image-2020-08-19-11-12-51.jpg','Dining Area','Dining Area','','No',4,'No'),(112055,13391,'image-2020-08-19-11-12-32.jpg','medium-image-2020-08-19-11-12-32.jpg','Outside Lounge','Outside Lounge','','No',3,'No'),(112054,13391,'image-2020-08-19-11-12-14.jpg','medium-image-2020-08-19-11-12-14.jpg','Living Area','Living Area','','No',2,'No'),(112053,13391,'image-2020-08-19-11-11-45.jpg','medium-image-2020-08-19-11-11-45.jpg','Swimming Pool','Swimming Pool','','No',1,'No'),(112052,13387,'image-2020-08-19-10-46-30.jpg','medium-image-2020-08-19-10-46-30.jpg','','','','No',21,'No'),(112051,13387,'image-2020-08-19-10-46-23.jpg','medium-image-2020-08-19-10-46-23.jpg','','','','No',20,'No'),(112050,13387,'image-2020-08-19-10-46-16.jpg','medium-image-2020-08-19-10-46-16.jpg','','','','No',19,'No'),(112049,13387,'image-2020-08-19-10-45-15.jpg','medium-image-2020-08-19-10-45-15.jpg','House from the Canal','House from the Canal','','No',18,'No'),(112048,13387,'image-2020-08-19-10-44-58.jpg','medium-image-2020-08-19-10-44-58.jpg','Pool Table','Pool Table','','No',17,'No'),(112047,13387,'image-2020-08-19-10-44-24.jpg','medium-image-2020-08-19-10-44-24.jpg','Street View','Street View','','No',16,'No'),(112046,13387,'image-2020-08-19-10-44-11.jpg','medium-image-2020-08-19-10-44-11.jpg','Table Tennis and Kayaks','Table Tennis and Kayaks','','No',15,'No'),(112045,13387,'image-2020-08-19-10-43-57.jpg','medium-image-2020-08-19-10-43-57.jpg','Bunkbeds','Bunkbeds','','No',14,'No'),(112044,13387,'image-2020-08-19-10-43-44.jpg','medium-image-2020-08-19-10-43-44.jpg','Twin Room','Twin Room','','No',13,'No'),(112043,13387,'image-2020-08-19-10-43-33.jpg','medium-image-2020-08-19-10-43-33.jpg','Terrace','Terrace','','No',12,'No'),(112042,13387,'image-2020-08-19-10-43-16.jpg','medium-image-2020-08-19-10-43-16.jpg','Butlers Pantry','Butlers Pantry','','No',11,'No'),(112041,13387,'image-2020-08-19-10-43-05.jpg','medium-image-2020-08-19-10-43-05.jpg','Bedroom','Bedroom','','No',10,'No'),(112040,13387,'image-2020-08-19-10-42-56.jpg','medium-image-2020-08-19-10-42-56.jpg','Bedroom','Bedroom','','No',9,'No'),(112039,13387,'image-2020-08-19-10-27-19.jpg','medium-image-2020-08-19-10-27-19.jpg','Laundry','Laundry','','No',8,'No'),(112038,13387,'image-2020-08-19-10-26-55.jpg','medium-image-2020-08-19-10-26-55.jpg','Bathroom','Bathroom','','No',7,'No'),(112037,13387,'image-2020-08-19-10-21-23.jpg','medium-image-2020-08-19-10-21-23.jpg','Living Area','Living Area','','No',6,'No'),(112036,13387,'image-2020-08-19-10-20-14.jpg','medium-image-2020-08-19-10-20-14.jpg','Bedroom','Bedroom','','No',5,'No'),(112035,13387,'image-2020-08-19-10-20-01.jpg','medium-image-2020-08-19-10-20-01.jpg','Kitchen','Kitchen','','No',4,'No'),(112034,13387,'image-2020-08-19-10-19-52.jpg','medium-image-2020-08-19-10-19-52.jpg','Swimming Pool','Swimming Pool','','No',3,'No'),(112033,13387,'image-2020-08-19-10-19-40.jpg','medium-image-2020-08-19-10-19-40.jpg','Deck','Deck','','No',2,'No'),(112032,13387,'image-2020-08-19-10-19-03.jpg','medium-image-2020-08-19-10-19-03.jpg','Living and Dining Area','Living and Dining Area','','Yes',1,'No'),(112031,13393,'image-2020-08-19-09-45-33.jpg','medium-image-2020-08-19-09-45-33.jpg','','','','No',14,'No'),(112030,13393,'image-2020-08-19-09-44-32.jpg','medium-image-2020-08-19-09-44-32.jpg','','','','No',13,'No'),(112029,13393,'image-2020-08-19-09-44-23.jpg','medium-image-2020-08-19-09-44-23.jpg','','','','No',12,'No');

--
-- Table structure for table `propertymaintenance`
--

CREATE TABLE `propertymaintenance` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `start_dt` datetime NOT NULL,
  `end_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=317 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertymaintenance`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertymaintenance` VALUES (316,3079,'IMPORTANT INFORMATION','<em><span style=\"color:#000080;\">In accordance with recent Government directives in response to slowing the spread of COVID-19, Hotel facilities may experience temporary closures or changes to operating times and/or services provided. Please contact our reception for further details. We are sorry for any inconvenience this may cause and thank you for your understanding during this time.<br />\r\n<br />\r\nPlease Note: Mantra Twin Towns Hotel &amp; Apartments is situated directly on the NSW/QLD border. In order to check-in you will be required to cross the border and enter NSW, therefore it will be a requirement of your stay to comply with Queensland Government regulations and border controls should you be seeking to re-enter Queensland following your stay.<br />\r\n<br />\r\nFor further information, please access the Queensland Government website:</span></em>&nbsp;<em><a href=\"https://www.qld.gov.au/border-pass\">https://www.qld.gov.au/border-pass</a></em>','2020-08-17 09:00:00','2021-03-31 23:59:59'),(315,11540,'RESORT CLOSURE','<span style=\"color:#000080;\"><em>RACV Royal Pines is currently closed due to COVID-19 and is due to re-open on 22 October 2020.</em></span>','2020-08-06 09:00:00','2020-10-22 23:59:59'),(314,3076,'MAINTENANCE NOTICE','The outdoor pool will be closed from 27 July 2020 for renovations. It is anticipated that the work will be completed by 8 September 2020. The indoor pool, sauna and spa will be remain open.','2020-07-27 09:00:00','2020-09-08 23:59:59'),(313,140,'MAINTENANCE NOTICE','<em><span style=\"color:#000080;\">Please note the pool island and slides are currently closed, the pool itself is still open.</span></em>','2020-04-01 09:00:00','2020-10-31 23:59:59'),(312,254,'Theme park currently closed. Re-opening dates have not been confirmed.','Theme park currently closed. Re-opening dates have not been confirmed.','2020-06-08 09:00:00','2020-06-29 23:59:59'),(311,9601,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Please note the main pool area and the Aussie muster area are being renovated and are currently closed. The heated spas are still operational.</em></span>','2020-06-02 09:00:00','2020-10-31 23:59:59'),(310,3004,'RESTAURANT CLOSURE','<span style=\"color:#000080;\"><em>Please note that Koastal Kitchen is currently closed for renovations.</em></span>','2020-06-01 09:00:00','2020-12-31 23:59:59'),(309,3096,'MAINTENANCE NOTICE','<em><span style=\"color:#000080;\">Please be advised that the pool is currently closed due to COVID-19 and will remain closed until further notice due to renovations.</span></em>','2020-05-25 09:00:00','2020-12-31 23:59:59'),(308,9137,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Due to current hotel renovation and COVID-19, some hotel facilities or services may not be available to guests until December 2020. Some noise disruption is expected. This includes hotel room renovations, public areas and banquet floors.&nbsp;</em></span><br />\r\n<br />\r\n<em><span style=\"color:#000080;\"><strong>Hotel rooms</strong> - currently under renovation work and will be closed from 17&nbsp;August to 21&nbsp;September 2020.<br />\r\n<strong>Pool closure</strong> - &nbsp;this is estimated to be closed from around 17&nbsp;August to 23&nbsp;November 2020.<br />\r\n<strong>Restaurants</strong> &ndash; all outlets will be closed from 31&nbsp;August until Mid December (dates may vary across the month)<br />\r\n<br />\r\nNoise disruption is expected to be impacted on most days of the week between 9am &ndash; 4pm Monday to Friday and could be particularly disruptive during bathroom works.</span></em><br />\r\n<br />\r\n','2020-05-21 09:00:00','2020-12-18 23:59:59'),(307,9174,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Please note that the Rumba Beach Resort will undertaking major pool renovation to its Lagoon and Jacuzzi Spa pools.&nbsp;The building works will take several months to complete. During traditional working hours Monday &ndash; Friday between 8am and 4pm construction work will be ongoing which will involve noise and debris removal. The building area will be securely fenced off.<br />\r\nThe heated lap pool will remain open for guests.&nbsp;Bar &amp; Breakfast Services are currently unavailable due to COVID-19 restrictions (subject to change).</em></span>','2020-05-21 09:00:00','2020-12-31 23:59:59'),(306,257,'RESORT POLICY - CORONAVIRUS','<em><span style=\"color:#000080;\">Regrettably, due to current restrictions the hotel will remain closed until re-opening for check ins on August 14<sup>th</sup> 2020.</span></em>','2020-05-21 09:00:00','2020-08-05 23:59:59'),(304,13067,'RESORT CLOSURE','<em style=\"color: rgb(0, 0, 128);\">Due to the ongoing impacts of COVID-19 and to ensure the safety and well-being of guests and staff, El Questro will be closed until 31 March 2021.</em>','2020-04-22 09:00:00','2021-03-31 23:59:59'),(303,13010,'RESORT CLOSURE','<em style=\"color: rgb(0, 0, 128);\">Due to the ongoing impacts of COVID-19 and to ensure the safety and well-being of guests and staff, El Questro will be closed until 31 March 2021.</em>','2020-04-22 09:00:00','2021-03-31 23:59:59'),(302,9021,'RESORT CLOSURE','<span style=\"color:#000080;\"><em>Due to the ongoing impacts of COVID-19 and to ensure the safety and well-being of guests and staff, Lizard Island will be closed until 31 August 2020.</em></span>','2020-04-22 09:00:00','2020-08-31 23:59:59'),(301,8931,'HOTEL CLOSURE','<span style=\"color:#000080;\"><em>Due to the impact of COVID-19, Hilton Adelaide will temporarily be suspending hotel operations beginning Friday 3 April, 2020 for a period of 12 weeks (subject to change). Hilton is committed to fully restoring operations and look forward to welcoming back guests later this year.</em></span> ','2020-04-16 09:00:00','2020-07-15 23:59:59'),(300,12669,'RESORT CLOSURE','<em><span style=\"color:#000080;\">In the ongoing fight against the COVID-19 outbreak, the Thai government has mandated a nationwide State of Emergency in effect from 26 March 2020. As a result, Keemala will temporarily cease operations from 4 April to 30 June 2020.&nbsp;</span></em>','2020-04-08 09:00:00','2020-06-30 23:59:59'),(299,12569,'RESORT CLOSURE','<em><span style=\"color:#000080;\">Due to Covid-19 situation, the Governor of Phang-Nga has recently announced the closure all hotels, resorts and other accommodations to contain the spread of the Covid-19 outbreak. This new measures take into effect today on April 04, 2020 until the Covid-19 situation eases. In compliance with the order by the Provincial Governor, Khaolak Laguna Resort has temporarily closed all operations, starting from April 04, 2020 until September 30, 2020.</span></em>','2020-04-08 09:00:00','2020-09-30 23:59:59'),(298,9111,'RESORT CLOSURE','<em><span style=\"color:#000080;\">Following the notification received from the Northern Territory Government on the closure of Watarrka National Park as of 5pm, 26 March 2020, the decision was made to totally close Kings Canyon Resort and Holiday Park until 30 June 2020.</span></em>','2020-03-31 09:00:00','2020-06-30 23:59:59'),(297,8929,'RESORT CLOSURE','<span style=\"color:#000080;\"><em>Fitzroy Island Resort have suspended all resort operations to ensure the health and safety of guests, colleagues, and community. At this stage the Resort plans to resume operations starting May 15th, 2020. Stay safe and healthy!</em></span>','2020-03-31 09:00:00','2020-05-15 23:59:59'),(296,9727,'RESORT CLOSURE','<em><span style=\"color:#000080;\">Following the Australian Government&rsquo;s announcement on March 22 restricting all non-essential travel, Tangalooma Island Resort is temporarily closed and advising guests who hold future bookings to postpone travel for the foreseeable future. We apologise for any inconvenience this may cause, but it is essential to follow government advice to avoid the spread of COVID-19 at this time.</span></em>','2020-03-31 09:00:00','2020-05-31 23:59:59'),(295,125,'PROPERTY CLOSURE','<span style=\"color:#000080;\"><em>To ensure the well-being of our entire community Paradise Resort is closed effective immediately and will remain closed until further notice. At this stage we are hoping to re-open on the 1st September 2020 and will continue to seek advice from the government before doing so.<br />\r\n<br />\r\nParadise Resort understands this is a difficult time for everyone and hope you keep your families safe and healthy. On behalf of the Schwartz Family Group and the entire team here at Paradise Resort we sincerely thank you for your support and look forward to welcoming you and your family back to Australia&rsquo;s Favourite Family Resort again in the future</em></span>','2020-03-26 09:00:00','2020-08-31 23:59:59'),(294,9019,'PROPERTY CLOSURE','<span style=\"color:#000080;\"><em>Due to the Australian Government&rsquo;s announcement restricting all non-essential travel, combined with self-isolating requirements Heron Island will temporarily suspend welcoming guests from Wednesday, March 25. Currently, we plan to recommence welcoming guests to Heron Island from 1 May 2020.</em></span>','2020-03-24 09:00:00','2020-05-01 23:59:59'),(293,9012,'PROPERTY CLOSURE','<span style=\"color:#000080;\"><em>Following the Australian Government&rsquo;s announcement Sunday 22nd March 2020 restricting all non-essential travel and enforcing social distancing, Daydream Island Resort has made the decision to place further restrictions onto the island and will close between 25 March to at least 31 May 2020.&nbsp;</em></span>','2020-03-24 09:00:00','2020-06-30 23:59:59'),(292,9276,'PROPERTY CLOSURE','<span style=\"color:#000080;\"><em>Please be advised that from 1 April 2020 to 30 June 2020, Daintree Wilderness Lodge will be closing to all guests. Due to the international travel ban, non-essential domestic travel being discouraged and the lodge being based in a remote region of Australia with vulnerable local communities the owners have had to make the hard decision of a short term closure.&nbsp;</em></span>','2020-03-23 09:00:00','2020-06-30 23:59:59'),(291,214,'CONSTRUCTION NOTICE','<span style=\"color:#000080;\"><em>Please be advised that the land adjacent to Oaks Santai at Casuarina is now being redeveloped into commercial and residential space. Whilst the works do not specifically affect the property, guests views maybe impacted by way of machinery and dust during earthmoving work. Expected timeframe around this is currently unknown. More information will be advised once known.</em></span>','2020-03-01 09:00:00','2020-10-31 23:59:59'),(290,193,'CONSTRUCTION NOTICE','<span style=\"color:#000080;\"><em style=\"color: rgb(0, 0, 128);\">Please be advised that construction of a new building adjacent to the Auckland Harbour Suite property has just commenced and may impact guest views and experience. This constuction is located on the Sputher side of the property. Construction completion dates are yet to be advised, however we are anticipating that this could be a year long project.</em></span><br />\r\n<br />\r\n<br />\r\n<br />\r\n','2020-03-01 09:00:00','2021-02-28 23:59:59'),(287,3891,'MAINTENANCE NOTICE','<em style=\"color: rgb(0, 0, 128);\">BreakFree Moroccan is undertaking repairs and refurbishment of the indoor pool, spa, sauna and gym which will be ongoing until 15 September 2020. The&nbsp;indoor pool, spa, sauna and gym will be closed during this time.&nbsp;</em>','2020-02-19 09:00:00','2020-09-15 23:59:59'),(286,347,'MAINTENANCE NOTICE','<em style=\"color: rgb(0, 0, 128);\">Peppers Cradle Mountain Lodge will be undergoing a renovation of the cabins and central buildings spread over the 23 acre property. From February until beginning of April, the Tavern Bar &amp; Bistro will be closed as it undergoes upgrade. During this time, Highland Restuatnt will offer a large range of options for diners, with the guest lounge and the Devil&#39;s Bar remaining cosy spaces to enjoy a drink by the fire.</em>','2020-02-01 09:00:00','2020-04-01 23:59:59'),(285,3032,'ROAD CLOSURE','<font color=\"#000080\"><i>There will be road closures on Gunnamatta Avenue between Bells Boulevard and Mantra on Salt Beach Resort roundabout from 17 February until 2 March 2020. This is expected to affect the access into the hotel for an estimated 2 weeks however a detour will be in place via Barrell Street.&nbsp;</i></font>','2020-02-17 09:00:00','2020-03-02 23:59:59'),(284,3073,'MAINTENANCE NOTICE','<em><span style=\"color:#000080;\">Please note that the hotel will be undergoing refurbishment works in the lobby from the beginning until the end of March 2020. There will be no disruptions to any guest rooms throughout this period and noise will be kept to a minimum.</span></em>','2020-03-02 09:00:00','2020-03-20 23:59:59'),(283,3719,'MAINTENANCE NOTICE','<em><span style=\"color: rgb(0, 0, 128);\">As part of our commitment to maintain the quality of Mantra Circle on Cavill we are excited to advise that we are undertaking a full refurbishment of the indoor pool. This will result in the indoor pool being closed for the duration, however both outdoor pool and will remain open.</span></em>','2020-02-17 09:00:00','2020-04-17 23:59:59'),(282,3086,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Please be advised that there will be lift maintenance commencing in mid January to end of October. During this time one lift will be out of action and there will be some noise associated with the work. Work will be carried out on Monday to Friday during business hours.</em></span>','2020-01-13 09:00:00','2020-10-26 23:59:59'),(281,3898,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Turtle Beach Resort is excited to announce a complete upgrade to the TB2 Resort Pool. Located on the northern side of the resort, the pool area will undergo renovations and area resurfacing. Works will commence on 27 April 2020 and are expected to take 7 weeks approximately, weather permitting. All renovations will be done during business hours causing minimal inconvenience. Turtle Beach Resort is pleased to advise that the recently renovated TB1 Mushroom pool and Splash Zone Water Park as well as the two other pools will be operating for our valued guests during this period.</em></span>','2020-02-11 09:00:00','2020-06-15 23:59:59'),(280,11798,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong>&nbsp;<em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors&nbsp;<strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n&nbsp;<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nFor guests who have purchased using a tariff which does not offer a flexible cancellation policy, or for guests who have purchased a flexible tariff which is now in the non cancellation period, please note we are unable to refund or amend these bookings unless it can be shown that the guest has been directly affected by the Coronavirus (medical proof will be required).<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-31 23:59:59'),(279,2,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong>&nbsp;<em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors&nbsp;<strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-16 23:59:59'),(278,108,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong>&nbsp;<em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors&nbsp;<strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n&nbsp;<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nFor guests who have purchased using a tariff which does not offer a flexible cancellation policy, or for guests who have purchased a flexible tariff which is now in the non cancellation period, please note we are unable to refund or amend these bookings unless it can be shown that the guest has been directly affected by the Coronavirus (medical proof will be required).<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-16 23:59:59'),(277,9394,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong>&nbsp;<em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors&nbsp;<strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n&nbsp;<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nFor guests who have purchased using a tariff which does not offer a flexible cancellation policy, or for guests who have purchased a flexible tariff which is now in the non cancellation period, please note we are unable to refund or amend these bookings unless it can be shown that the guest has been directly affected by the Coronavirus (medical proof will be required).<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-16 23:59:59'),(276,12039,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong>&nbsp;<em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors&nbsp;<strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n&nbsp;<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nFor guests who have purchased using a tariff which does not offer a flexible cancellation policy, or for guests who have purchased a flexible tariff which is now in the non cancellation period, please note we are unable to refund or amend these bookings unless it can be shown that the guest has been directly affected by the Coronavirus (medical proof will be required).<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-16 23:59:59'),(275,142,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong>&nbsp;<em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors&nbsp;<strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n&nbsp;<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nFor guests who have purchased using a tariff which does not offer a flexible cancellation policy, or for guests who have purchased a flexible tariff which is now in the non cancellation period, please note we are unable to refund or amend these bookings unless it can be shown that the guest has been directly affected by the Coronavirus (medical proof will be required).<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-16 23:59:59'),(274,30,'RESORT POLICY - CORONAVIRUS','<strong>Resort Policy in Response to Coronavirus Situation</strong> <em>(updated 2 March&nbsp;2020)</em><br />\r\nIn light of the developing Coronavirus situation, this resort will be monitoring the situation and will be adopting policies in line with major tourism operators and organisations (including the relevant statutory bodies). As such, this policy will change as the situation becomes clearer.<br />\r\n&nbsp;<br />\r\nCurrently, any visitors <strong>t</strong>raveling to, from and within China &amp; Iran and checking in on or before 31st March, 2020, and for visitors from South Korea providing the reservation was made before 25th February, 2020 may be permitted to cancel without penalty.&nbsp;&nbsp;Proof of travel to, from and within these locations should be provided (eg copy of original itinerary or flight details or any Government of relative Medical instruction prohibiting travel to Australia) to contact the Customer Service division of your original agent.<br />\r\n&nbsp;<br />\r\nFor all other future guests, if you have purchased your stay using one of the flexible policies, you may already be eligible to cancel or amend your reservation under the terms of this policy. This may be checked and confirmed through your original booking agent or direct with the property if you booked direct with the property.<br />\r\n&nbsp;<br />\r\nFor guests who have purchased using a tariff which does not offer a flexible cancellation policy, or for guests who have purchased a flexible tariff which is now in the non cancellation period, please note we are unable to refund or amend these bookings unless it can be shown that the guest has been directly affected by the Coronavirus (medical proof will be required).<br />\r\n&nbsp;<br />\r\nIt is our strongest recommendation that all guests (current and future whether purchasing a flexible or non flexible tariff) consider the purchase of an appropriate travel insurance policy to safeguard against unforeseen cancellation due to the Coronavirus or other incidents.&nbsp;<br />\r\n&nbsp;<br />\r\nWe are constantly monitoring the Coronavirus situation and will update our policy as the situation develops.<br />\r\n&nbsp;<br />\r\nFor up to date details, please refer to the Smart Traveller website:<br />\r\n<a href=\"https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak\">https://www.smartraveller.gov.au/news-and-updates/novel-coronavirus-outbreak</a>','2020-01-31 09:00:00','2020-03-16 23:59:59'),(273,2967,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>The Western pool area will be under renovation from the end of January until Early May 2020. Please note the two other pools will be fully functioning whilst these works will be taking place.<br />\r\n<br />\r\nFurther to this from the 1&nbsp;May 2020, building renovations are commencing for the replacement of windows, doors &amp; balustrades. There will be minor to medium noise during this time. All arriving guests will be located away from the renovation rooms and the views will not be impacted.</em></span>','2020-01-22 09:00:00','2021-09-15 23:59:59'),(272,142,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Belle Maison will be undergoing minor renovations exclusively to the limited exterior grounds commencing 1&nbsp;February 2020.&nbsp; It is expected these works will take place over a ten day period.&nbsp;&nbsp;The Reflection Pond (water feature) and some pathways and garden areas, will be upgraded to keep them looking stunning. All guest facilities will be available as per normal and the provision of all services is unaffected.&nbsp; There may, however, be some noise from works at times (particularly the first two days).&nbsp; As works are only permitted between the hours of 7.30am and 4pm on Monday to Fridays and 7.30am to 2pm on Saturdays.&nbsp; There will be no renovation noise outside of these hours.&nbsp; No works at all permitted on Sundays. Apartments and internal facilities will not be affected.</em></span>\r\n<p>\r\n	<o:p></o:p></p>\r\n<br />\r\n','2020-01-22 09:00:00','2020-02-12 23:59:59'),(271,2975,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Effective from 10 February to 17 June 2020, Landmark Resort will be installing new lifts. During this period there will be one lift operating. A porter service will be offered during this time to assist guests on arrival and departure.</em></span>','2020-01-07 09:00:00','2020-06-17 23:59:59'),(270,3898,'MAINTENANCE NOTICE','<em><span style=\"color:#000080;\">Please be advised that the TB1 Mushroom Pool will be closed for 2 weeks from 27 January 2020 to 10 February 2020 (weather permitting) to resurface the flooring. All other pools including the Splash Zone Water Park will be open for use during this time.</span></em>','2020-01-07 09:00:00','2020-02-10 23:59:59'),(269,210,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Please note that the Water Park at Oaks Oasis will be closed from 3 February 2020 for approx. 8 weeks as the water park structure is removed and a brand new structure is built. The Adventure Zone (mini golf, jumping pillow and climbing frame) will remain open but the Water Park and Kiosk will be closed over this period. Oaks Hotels &amp; Resorts thank you for your patience whilst this work is completed</em></span>','2019-12-23 09:00:00','2020-03-31 23:59:59'),(268,140,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Further to previous updates, the pool re-opened on 15 December however the waterslide and island are still out of action and will commence construction in the new year. Details to be advised.</em></span>','2019-12-16 09:00:00','2020-03-31 23:59:59'),(267,347,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Peppers Cradle Mountain Lodge will be undergoing a renovation of the cabins and central buildings spread over the 23 acre property. From 29 July, reception will be located in the boutique at the front of the property. During the renovtaion, the full a la carte, Highland menu will be available for in-house guests in the lounge in front of the roaring fire with full buffet breakfast served in The Tavern and lounge area. In the later stages of the renovation, The Tavern Bar &amp; Bistro will be affected and alternative options will be made available to ensure the best comfort during your wilderness escape.</em></span>','2019-10-04 09:00:00','2020-03-31 23:59:59'),(266,3704,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>As part of ongoing property improvements, Paradise Centre Apartments wish to advise that maintenance will be taking place to the exterior of the building for the immediate future.</em></span>','2019-10-04 09:00:00','2020-03-31 23:59:59'),(265,3078,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>Mantra Sierra Grand is pleased to advise, that in line with the continual aim to improve guest experience, external building painting will commence on Monday 9 September through to March 2020. All works will occur between the hours of 7:30am to 4:00pm Monday to Friday. It is anticipated that there will be little to no impact on guests. Thank you for your patience and understanding during this period.</em></span>','2019-10-04 09:00:00','2020-03-31 23:59:59'),(264,3891,'MAINTENANCE NOTICE','<span style=\"color:#000080;\"><em>BreakFree Moroccan is undertaking repairs and refurbishment of the indoor pool, spa and sauna until 30 January 2020. The&nbsp;indoor pool, spa and sauna will be closed during this time. Accor is sorry for any inconvenience and thank you for your patience and understanding during this time.</em></span>','2019-10-04 09:00:00','2020-01-30 23:59:59');

--
-- Table structure for table `propertyresponses`
--

CREATE TABLE `propertyresponses` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `response` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertyresponses`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `propertyresponses` VALUES (1,'Test','<p>\r\n	This is a test. sss</p>\r\n','<p>\r\n	I told you it was a test.</p>\r\n');

--
-- Table structure for table `prospect`
--

CREATE TABLE `prospect` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `start_dt` datetime NOT NULL,
  `end_dt` datetime NOT NULL,
  `country` varchar(200) NOT NULL,
  `property_name` varchar(200) NOT NULL DEFAULT '0',
  `currency` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL DEFAULT 'Pending',
  `inclusion_1` varchar(200) NOT NULL,
  `inclusion_1_value` varchar(20) NOT NULL,
  `inclusion_2` varchar(200) NOT NULL,
  `inclusion_2_value` varchar(20) NOT NULL,
  `inclusion_3` varchar(200) NOT NULL,
  `inclusion_3_value` varchar(20) NOT NULL,
  `inclusion_4` varchar(200) NOT NULL,
  `inclusion_4_value` varchar(20) NOT NULL,
  `inclusion_5` varchar(200) NOT NULL,
  `inclusion_5_value` varchar(20) NOT NULL,
  `s1_travel_dates` text NOT NULL,
  `s1_blockout_dates` text NOT NULL,
  `s2_travel_dates` text NOT NULL,
  `s2_blockout_dates` text NOT NULL,
  `s3_travel_dates` text NOT NULL,
  `s3_blockout_dates` text NOT NULL,
  `s4_travel_dates` text NOT NULL,
  `s4_blockout_dates` text NOT NULL,
  `comments` text NOT NULL,
  `terms` text NOT NULL,
  `distribution_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prospect`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `prospect` VALUES (39,'2020-05-11 00:00:00','2020-05-25 00:00:00','Australia','Q1','AUD','Completed','2 x $25 Spa voucher ','50','25% off Skypoint climb voucher ','','1 free bottle wine with main meals','','buy 1 get 1 free drink in social house ','','free parking ,  free wifi ','','12/07/20--17/12/20\r\n\r\nschool holidays surcharge\r\n12th - 18th July 2020 / 18th - 24th September 2020 / 11th - 17th December 2020\r\n\r\n','25th September - 10th October 2020 / 30th October - 2nd November 2020\r\n','','','','','','','Value Ad Inclusions\r\n2 x $25.00 spa voucher **Cannot be booked consecutively and treatment must be 1 hour minimum however can be used at the same time for couples having two separate massages – advise guests to pre book treatments direct with Spa Attendants to avoid any disappointment in preferred treatment times\r\n25% Off Skypoint climb voucher\r\n1 x Dine in Clifford’s Grill & Lounge during your stay and receive a free bottle of wine with your main meals\r\n1 x Buy one get one free on any drink purchase in social house\r\n1 x Receive 20% off dinner in Waves Buffet Restaurant\r\nFOC Parking\r\nFOC Wifi','',0),(38,'2020-05-06 00:00:00','2020-06-30 00:00:00','Australia','Grand Chancellor Palm Cove','AUD','Completed','Free 12pm late check out ','15','Free bottle wine of upon arrival','20','','','Free upgrade','15','','','01/06-31/12/20\r\n','N/A','','','','','','','','',0),(37,'2020-05-06 00:00:00','2020-06-30 00:00:00','Australia','Grand Chancellor Brisbane','AUD','Completed','Free 12pm late check out ','15','Free bottle of wine upon arrival','20','Free parking ','20','Free upgrade','15','Breakfast','50','01/06-31/12/20\r\n','N/A','','','','','','','','',0),(35,'2020-05-06 00:00:00','2020-06-30 00:00:00','Australia','Grand Chancellor Townsville','AUD','Completed','Free 12pm late check out ','15','Free bottle of wine upon arrival','20','Free upgrade ','15','Breakfast ','50','','','01/06-31/12/20\r\n','n/a','','','','','','','','',0),(34,'2020-03-30 00:00:00','2020-04-13 00:00:00','Australia','Burleigh Mediterranean Resort','AUD','Pending','Free daily use of beach equipment','$60','Free unlimited Wifi','','Free membership to North Burleigh Surf Club for 10% discount on all food & beverages','$10','My DQ Card','$199','','','30/03/20 - 17/09/20','10/11/12 April 2020 (Easter weekend); 3/4/5 July 2020 (GC Marathon)\r\n13-18 April 2020 all 3 Bedroom Apartments \r\n26 June - 19 July 2020 2 Bedroom Ocean View and all 3 bedroom apartments \r\n','30/03/20 - 17/09/20','10/11/12 April 2020 (Easter weekend); 3/4/5 July 2020 (GC Marathon)\r\n13-18 April 2020 all 3 Bedroom Apartments \r\n26 June - 19 July 2020 2 Bedroom Ocean View and all 3 bedroom apartments','30/03/20 - 17/09/20','10/11/12 April 2020 (Easter weekend); 3/4/5 July 2020 (GC Marathon)\r\n13-18 April 2020 all 3 Bedroom Apartments \r\n26 June - 19 July 2020 2 Bedroom Ocean View and all 3 bedroom apartments','','','','',0),(33,'2020-03-23 00:00:00','2020-04-06 00:00:00','Australia','Ultra Broadbeach','AUD','Completed','Late Check-out (12pm)','$40','Bottle of sparkling wine','$20','Car Parking','','Wifi included','','My DQ Card','$199','1 - 13 May, 18 May - 2 Jul, 18 Jul - 8 Sep & 13 - 18 Sep 2020','','11 - 18 Jul, 7 - 13 Oct & 19 - 28 Oct 2020','','','','','','Late Check-out subject to availability ','',0),(31,'2020-03-23 00:00:00','2020-04-06 00:00:00','Australia','DQ - The Rise Noosa','AUD','Pending','Bottle of Wine ','','2 x Beach hire vouchers','$40','DQ Card','$199','','','','','Now - 18/12/20 ****TBA****','19/09/20-11/10/20\r\n30/10/2020-02/11/20 \r\n19/12/20-17/01/21\r\n','','','','','','','@Michelle - Uplift $75 net weekend (Fri/Sat) ','',0),(29,'2020-03-18 00:00:00','2020-03-18 00:00:00','Australia','DQ - Test property','AUD','Approved','Breakfast daily @ $25 per day','150','Tour','100','','','','','','','18 Mar - 30 Jun 2020','10 - 12 Apr 2020','','','','','','','','',0),(28,'2019-10-31 00:00:00','2019-10-31 00:00:00','Fiji','Yasawa Fiji','FJD','Pending','','','','','','','','','','','','','','','','','','','ALL Meals included','',0),(27,'2019-07-30 00:00:00','2019-07-30 00:00:00','Australia','Pavillions 1770','AUD','Pending','Late Check out 11:00am','','Free Upgrade (subject to availability)','','','','','','','','','','','','','','','','','',0),(26,'2019-08-08 00:00:00','2019-08-22 00:00:00','Maldives','RIU Atoll Maldives','USD','Pending','All inclusive ','','','','','','','','','','1 November - 20 December 2019','','21 December 2019 - 8 January 2020','','9 January 2020 - 12 April 2020','','13 - 30 April 2020','','','',0),(25,'2019-08-08 00:00:00','2019-08-22 00:00:00','Maldives','SAii Lagoon Maldives, Curio Collection by Hilton','USD','Pending','Breakfast Daily ','0','Return Airport Transfers','260','','','','','','','1 - 30 September 2019','','1 October 2019 - 21 December 2019','','22 December 2019 - 10 January 2020','','11 January 2020 - 31 March 2020','','','',0),(24,'2019-07-29 00:00:00','2019-07-29 00:00:00','Australia','Avani Auckland','AUD','Pending','','','','','','','','','','','','','','','','','','','','',0),(23,'2019-07-29 00:00:00','2019-07-29 00:00:00','Australia','Auckland Harbour Residences','AUD','Pending','','','','','','','','','','','','','','','','','','','','',0),(22,'2019-07-31 00:00:00','2019-07-31 00:00:00','New Zealand','Waitomo Caves Hotel','NZD','Pending','Continental Breakfast Daily','','','','','','','','','','1 August to 30 November 2019','','','','','','','','','',0),(21,'2019-07-19 00:00:00','2019-07-10 00:00:00','Australia','Mirage Whitsundays','AUD','Pending','Chocolates ','15','Deluxe Apartment Upgrade per night','100','','','','','','','until 20th Dec','','','','','','','','','',0),(20,'2019-05-30 00:00:00','2019-06-11 00:00:00','Australia','The Old Phuket','THB','Completed','Free upgrade to Deluxe Pool View room ','0','1 x Thai Set Dinner for 2 person per stay','82','2 x 30 minutes foot massage per stay ','15','7 Cocktails to share per stay ','51','Buffet Breakfast Daily ','0','30 May 19 - 31 Oct 19; 1 Apr 20 – 31 Oct 20 ','','1 Nov- 23 Dec 19 ','','11 Jan 20 - 31 Mar 20','','','','Sceenshot dates based on the following:\r\nSeason 1 - 1 April 2020\r\nSeason 2 - 16 Dec 19\r\nSeason 3 - 11 Jan 20','',0),(19,'2019-05-20 00:00:00','2019-06-03 00:00:00','Australia','Avani Broadbeach','AUD','Negotiation','Wifi','','Late Check Out','','Wine','','','','','','','','','','','','','','','',0),(18,'2019-05-14 00:00:00','2019-06-30 00:00:00','Thailand','Splash Beach Resort Phuket','THB','Completed','Upgrade from Double Double to Deluxe 1 Bedroom Family Suite or Apartment','13625','2 x 60min Spa Treatments for 2 adults (once per stay)','3600 / AUD160','Kids Dine Free - Buffet & Kids Menu (0-11 years)','0','Free Kids Club (0-11 years)','0','20% Discount on Spa Massage','0','Low Season<br>\r\n14 May - 30 Jun & 20 Aug - 31 Oct 2019','15 - 17 Jun 2019','High Season<br>\r\n1 Jul - 19 Aug ','','','','','','','',75),(17,'2019-05-30 00:00:00','2019-06-12 00:00:00','Australia','North Star Holiday Resort','AUD','Completed','Late check out 12:00','30','Full Breakfast Buffet','148.80 ','$25 F & B credit','25','Welcome Cocktail','32','','','Valid for Travel: 6 May – 5 December 2019\r\nBlockout dates: 29 -30 August 2019 (Gold Coast Show); 18-21 July 2019 (Splendour weekend); 20 September – 12 October 2019 (School Hols); 25-26 October 2019 (Halloween Weekend)\r\nAllotment reduction: Only 1 per day (all categories) from the 1st September – 5 December 2019 \r\nMin Stay: 3 nights \r\n','','','','','','','','Surcharge Friday & Saturday nights/Winter School Holidays (28 June - 13th July 2019): +$35 per night Nett \r\nAdditional people: CABIN $25 per person/ per night Nett \r\nCommission: 18%\r\n','',0),(16,'2019-04-16 00:00:00','2019-05-14 00:00:00','Australia','Outrigger Koh Samui','THB','Completed','Welcome Cocktail at the Wet Bar ','AUD26','Flexible Half Board daily for 2 people','AUD617','Return Airport Transfers','AUD53','2 x 1 hour massages per person ','AUD70','One Time Cooking Class for 2 ','AUD154','16 Apr 19 – 7 Jul 19; 26 Aug 19 – 22 Dec 19; 16 April 20 – 7 Jul 20','','8 Jul 19 – 25 Aug 19; 1st Feb 20 – 15 Apr 20','','','','','','Breakfast is included daily\r\nClient must inform resort of arrival and departure flight details for transfer.  \r\nIncludes double room upgrade','',0),(15,'2019-04-17 00:00:00','2019-04-30 00:00:00','Australia','Oaks Mon Komo','AUD','Pending','WiFi @ $18 per day','54','Bottle of wine','20','12pm late Check-Out','20','Upgrade to Ocean View','','','','Sunday to Thursday 22 Apr 2019 - 31 Mar 2020<br>\r\n(22 Apr - 2 May, 6 My - 4 Jul, 9 - 31 Jul, 4 Aug - 26 Sep, 5 Oct - 19 Dec 2019, 6 - 23 Jan & 27 Jan - 31 Mar 2020','18 - 21 Apr, 3 - 5 May, 5 - 8 Jul, 1 - 3 Aug, 27 Sep - 4 Oct, 20 Dec 2019 - 5 Jan & 24 - 26 Jan 2020','Sunday to Thursday 22 Apr 2019 - 31 Mar 2020<br>\r\n(22 Apr - 2 May, 6 My - 4 Jul, 9 - 31 Jul, 4 Aug - 26 Sep, 5 Oct - 19 Dec 2019, 6 - 23 Jan & 27 Jan - 31 Mar 2020','18 - 21 Apr, 3 - 5 May, 5 - 8 Jul, 1 - 3 Aug, 27 Sep - 4 Oct, 20 Dec 2019 - 5 Jan & 24 - 26 Jan 2020','','','','','1 BEDROOM INCLUSIONS<br>\r\nWiFi per day, Bottle of wine, 12pm Late Check-out, Breakfast Buy One, Get One Free daily, Upgrade to Ocean View, 1 x FOC bottle of wine with 2 x main meals purchased in Cabana Bar + Kitchen + Garden<p>\r\n\r\n2 BEDROOM INCLUSIONS<br>\r\nWiFi per day, Bottle of wine, 12pm Late Check-out, Breakfast Buy One, Get One Free daily, Upgrade to Ocean View, Kids Eat Free (Available Lunch and Dinner Only, 1 kid eats free with every paying adult at Cabana Bar + Kitchen + Garden).<p>\r\n\r\nNormal Rates based on travel 4 June 2019<br>\r\n1 Bedroom Ocean (Sun-Thu) $209pn / (Fri-Sat) $237  <br>\r\n2 Bedroom Ocean (Sun-Thu) $263pn / (Fri-Sat) $322','',0),(14,'2019-04-23 00:00:00','2019-05-21 00:00:00','Australia','Crest Resort & Pool Villas','THB','Completed','4 times x 30 minutes Thai or Foot Massage per stay','140','one time Thai Set Dinner, food only for 2 people per stay','60','20% discount on spa treatment (a la carte menus)','0','20% discount on food & beverages except alcoholic drinks and minibar','0','Buffet Breakfast Daily ','0','1 Apr 19 – 31 Oct 19; 1 Apr 20 – 31 Oct 20   ','','1 – 30 Nov 19 ','','1 – 25 Dec 19; 11 Jan 20 – 31 Mar 20 ','','26 Dec 19 – 10 Jan 20','','Book the Deluxe Pool Villa and receive 1 time complementary high-tea at Pano Executive Lounge Complimentary shuttle bus service from the resort to Patong Beach, subject to resort’s schedule  Complimentary shuttle bus service from the resort to Paradise Beach inclusive of access fee waiver and a welcome drink, subject to resort’s schedule  \r\nComplimentary WiFi Internet connection for entire stay.  \r\nComplimentary use of fitness and sauna for entire stay. \r\n \r\nInclude booking code – AUSflash Compulsory Gala Dinner on New Year Eve, 31 Dec 2019 at 6,900 Baht net per person, child 3,500 net per person.  Chinese New Year surcharge is applied between 22 – 31 Jan 2020 (inclusive): THB 1,500 per night   \r\n\r\nIf possible please bundle with return airport transfers from our Expedia account and a tour or activity. Happy to discuss when I get back - Kyra\r\n \r\n ','',0),(13,'2019-04-02 00:00:00','2019-04-16 00:00:00','Thailand','Evason Hua Hin','THB','Completed','Daily Breakfast for 2 Adults  & 1 Child (>8yr)','','1 x 75 Minutes Spa Massage for 2 people','319.00','1 x Set Dinner for two People','133.30','20% Discount on Full priced Food & Beverage','','Free daily bike hire','','2 Apr 2019 - 31 Mar 2020 (Sunday to Friday)<br>\r\n(2 - 12 Apr, 24 Apr - 23 Dec, 26 - 30 Dec 2019, 2 Jan - 4 Feb & 20 Feb - 31 Mar 2020','','Festival Season: 13 - 23 Apr, 24 - 25 Dec 2019, 31 Dec - 1 Jan & 5 - 19 Feb 2020','','','','','','Saturday night Surcharge THB2,700 (AUD$145) applies. <p>\r\n\r\nFestival season surcharge of THB6,000 (approx AUD$266) per room, per night (surcharge includes Saturday night) applies to the following dates:\r\nChristmas and New Year\'s Eve/Day: 24 December ; 25 December:  31 December; 1 January \r\nEaster holidays & Thai New Year – 13 – 23 April 2019, 2020\r\nChinese New Year - 05 to 19 February 2020','',0),(12,'2019-04-24 00:00:00','2019-05-01 00:00:00','Australia','The Rise Noosa','AUD','Completed','Bottle of Wine','30','Beach Hire ','20','Discount Vouchers x $20','40','Restaurant Credit ?? TBC','','River Cruise x 2 ','','Sunday to Thursday 29 April to 12 December 2019<br>\r\n(29 Apr - 27 Jun, 22 Jul - 19 Sep, 7 - 31 Oct & 4 Nov - 12 Dec 2019)','28 Jun - 21 Jul, 20 Sep - 6 Oct & 1 - 3 Nov 2019','','','','','','','Friday and Saturday night Surcharge $100 per night','',0),(11,'2019-04-09 00:00:00','2019-05-21 00:00:00','Thailand','180 Wellness','THB','Completed','Return Airport Transfers','90','','','','','','','','','20 Apr 19 – 31 Oct 19; 1 May 20 – 31 Oct 20','','1 Nov 19 – 19 Dec 19; 16 Jan 20 – 30 Apr 20','','','','','','Please include the program inclusions for Bliss Spa. \r\nArrivals and departures on Saturdays – programs run from Monday to Friday\r\n1 bedroom Suite upgrade available for 2,800 per night - not sure how we want to load this?','',0),(10,'2019-03-18 00:00:00','2019-05-12 00:00:00','Vanuatu','Chantilly\'s on the Bay','AUD','Pending','','','','','','','','','','','','','','','','','','','','',0),(9,'2019-03-27 00:00:00','2019-03-27 00:00:00','Vanuatu','Ratua Island Resort & Spa','VUV','Approved','Stay 6 Pay 5','','2 x 4000vuv Spa Vouchers','AUD98','Bottle of wine on arrival','AUD100','','','','','1 Apr 2019 - 31 Mar 2020','','','','','','','','Prices are Vanuatu currency - Vatu<p>\r\n\r\nIsland Dining Meal Plan is MANDATORY for every guest for the entire duration of the stay which includes breakfast, lunch, snacks, evening canapes, and dinner<p>\r\n\r\n<b>Cost</b><br>\r\nAdults 10,000 Vt per person per day<br>\r\nChild 5,000 Vt per child per day<br>\r\nChilren under 5 years old FOC','',0),(8,'2019-03-21 00:00:00','2019-04-18 00:00:00','Thailand','Cape Sienna Phuket Gourmet Hotel & Villas','THB','Completed','Guaranteed Room upgrade from Sea View Studio to Sea View Deluxe Room','0','1 x 45min Spa Treatment (Thai or Aroma) for 2 people','90','1 x Cocktail making class for 2 people','45','','','','','1 May - 31 October 2019','N/A','','','','','','','**Internal comment only**\r\nTravel outside of the campaign dates available as per standard wholesale contract\r\nProperty not child friendly \r\n\r\nNormal sell price from Expedia 22 Aug for 7 nights','',0),(7,'2019-03-28 00:00:00','2020-03-31 00:00:00','Fiji','Toberua Island Resort','NZD','Pending','Tropical Breakfast for 2 Daily','','Bottle of Sparkling Wine','','2 x 30 Min Massage','','1 x Romantic Dinner Set Up','','1 x Snorkel Excursion','','','','','','','','','','','',0),(6,'2019-04-01 00:00:00','2019-04-15 00:00:00','Thailand','Splash Beach Resort Phuket','THB','Completed','Upgrade to Deluxe 1 Bedroom Family Suite or Apartment','13625','2 x 60min Spa Treatments for 2 adults (once per stay)','3600 / AUD160','Kids Dine Free - Buffet & Kids Menu (0-11 years)','0','Free Kids Club (0-11 years)','0','20% Discount on Spa Massage','0','Low Season<br>\r\n28 Apr - 30 Jun & 20 Aug - 31 Oct 2019','15 - 17 Jun 2019','High Season<br>\r\n1 Jul - 19 Aug & 1 Nov - 12 Dec 2019','','','','','','Normal rate based on travel dates 25 - 30 March 2019.','',0),(5,'2019-03-18 00:00:00','2019-03-31 00:00:00','Thailand','Absolute Twin Sands Resort & Spa','THB','Pending','','','','','','','','','','','','','','','','','','','','',0),(4,'2019-04-09 00:00:00','2019-05-02 00:00:00','Indonesia','Wyndham Sundancer Resort Lombok','AUD','Completed','Daily 2 course set menu Lunch or Dinner @ $25 per day','125','Daily afternoon tea @ $15 per day','75','One daily cocktail each at any restaurant or bar in the resort @ $15 per day','75','One time relaxing 60 minutes massage each @ $35pp','70','Private return airport transfer @ $40 each way','80','1 Mar - 30 Jun & 1 Sep - 31 Dec 2019\r\n\r\n','n/a','1 Jul - 31 Aug 2019','','','','','','Normal rates based on travel 3 June & 21 July 2019<br>\r\n1 Bedroom Deluxe - 1,800,000 IDR = AUD$179pn<br>\r\n2 Bedroom Deluxe = 3,100,000 IDR = AUD$307pn<br>\r\nExchange rate: 1 IDR = 0.0000991958 AUD<p>\r\n\r\nHigh Season Surcharge @ $36 nett per night\r\n\r\nAllotment<br>\r\n1 Bedroom Deluxe Suite - 2 per day<br>\r\n2 Bedroom Deluxe Suite - 1 per day<br>','',0),(3,'2019-05-07 00:00:00','2019-06-04 00:00:00','Indonesia','Grand Mirage Resort & Thalasso Bali','USD','Completed','Room Upgrade','100','Return Airport Transfer','80','All-inclusive meal package','0','1 x 60min beach massage per person for 2 adults','60','$30 spa voucher at Thalasso Spa','30','6 May 2019 – 30 June 2019; 1 September 2019 – 23 December 2019; 6 January 2020 – 30 June 2020','','1 July 2019 – 31 August 2019','','','','','','TREV - MISH DID THIS BIT A WHOLE AGO SO I AM NOT SURE IF IT NEEDS CHANGING\r\n\r\n\r\n\r\nPackage Rates @ exchange rate 1 USD = 1.41060 AUD<p>\r\n\r\n<b>5 Nights</b><br>\r\nPremiere Garden - USD1169 = AUD1649<br>\r\nPremiere Ocean - USD1219= AUD1720<br>\r\nOcean View Suite - USD1644 = AUD2319<p>\r\n\r\n<b>7 Nights</b><br>\r\nPremiere Garden - USD1619 = AUD2284<br>\r\nPremiere Ocean - USD1689 = AUD2383<br>\r\nOcean View Suite - USD2294 = AUD3236<p>\r\n\r\n<b>10 Nights</b><br>\r\nPremiere Garden - USD2289 = AUD3229<br>\r\nPremiere Ocean - USD2389 = AUD3370<br>\r\nOcean View Suite - USD3219 = AUD4541<p>\r\n\r\nHigh Season (1 Jul - 31 Aug) Surcharge @ USD25 = AUD35 per room per night<p>\r\n\r\nExtra Adult @ USD75 = AUD106 per night <br>\r\nExtra Child (6-12yrs) @ USD35 = AUD50 per night<p>','> Package code: SPC-AU301119.LEISURE\r\n> Non refundable, not able to amend\r\n> Room is subject to availability\r\n> This special rate and condition is applicable for only new reservation FIT only. Not to be combine with other offers or promotion.\r\n > The \"Code Booking\" should be mentioned when the reservation is made, and please mention  on the voucher.  Code Booking : \"SPC-AUS301119.LEISURE\" \r\n> The Grand Mirage Resort & Thalasso Bali reserves the right to reduce, stop the promo rate or close out (for a very limited time) during high occupancy.',0);

--
-- Table structure for table `prospectrooms`
--

CREATE TABLE `prospectrooms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `room` varchar(200) NOT NULL,
  `min_nights` int(10) NOT NULL DEFAULT '0',
  `included_pax` int(10) NOT NULL DEFAULT '0',
  `included_cax` int(10) NOT NULL DEFAULT '0',
  `nett` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_nett` decimal(10,2) NOT NULL DEFAULT '0.00',
  `percent` decimal(10,2) NOT NULL DEFAULT '0.00',
  `sell` decimal(10,2) NOT NULL DEFAULT '0.00',
  `extra_night` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `normally` decimal(10,2) NOT NULL DEFAULT '0.00',
  `inclusion_1` varchar(200) NOT NULL,
  `inclusion_1_value` varchar(20) NOT NULL,
  `inclusion_2` varchar(200) NOT NULL,
  `inclusion_2_value` varchar(20) NOT NULL,
  `inclusion_3` varchar(200) NOT NULL,
  `inclusion_3_value` varchar(20) NOT NULL,
  `season` int(10) NOT NULL DEFAULT '0',
  `room_no` int(10) NOT NULL DEFAULT '0',
  `prospect_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=935 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prospectrooms`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `prospectrooms` VALUES (934,'Superior',3,0,0,95.00,285.00,23.00,370.00,95.00,0.00,10.00,530.00,'','','','','','',1,1,38),(932,'Superior',2,0,0,115.00,230.00,23.00,299.00,115.00,0.00,10.00,440.00,'','','','','','',1,1,37),(931,'Executive room',3,2,0,115.24,345.73,23.00,449.00,115.00,0.00,10.00,580.00,'','','','','','',1,1,35),(929,'Superior',3,0,0,94.71,284.13,23.00,369.00,95.00,0.00,10.00,446.00,'','','','','','',1,1,36),(912,'3 Bedroom Ocean View Apartment',7,6,0,205.00,1435.00,20.00,1794.00,205.00,40.00,0.00,2677.00,'','','','','','',3,18,34),(911,'3 Bedroom Standard Apartment',7,6,0,185.00,1295.00,20.00,1619.00,185.00,40.00,0.00,2467.00,'','','','','','',3,17,34),(910,'2 Bedroom Ocean View Apartment',7,4,0,159.00,1113.00,20.00,1391.00,159.00,40.00,0.00,2327.00,'','','','','','',3,16,34),(909,'2 Bedroom Apartment',7,4,0,141.00,987.00,20.00,1234.00,141.00,40.00,0.00,2117.00,'','','','','','',3,15,34),(908,'1 Bedroom Ocean View Apartment',7,2,0,135.00,945.00,20.00,1181.00,135.00,40.00,0.00,2047.00,'','','','','','',3,14,34),(907,'1 Bedroom Standard Apartment',7,2,0,117.00,819.00,20.00,1024.00,117.00,40.00,0.00,1844.00,'','','','','','',3,13,34),(906,'3 Bedroom Ocean View Apartment',5,6,0,218.00,1090.00,20.00,1363.00,218.00,40.00,0.00,2004.00,'','','','','','',2,12,34),(905,'3 Bedroom Standard Apartment',5,6,0,198.00,990.00,20.00,1238.00,198.00,40.00,0.00,1854.00,'','','','','','',2,11,34),(904,'2 Bedroom Ocean View Apartment',5,4,0,171.00,855.00,20.00,1069.00,171.00,40.00,0.00,1754.00,'','','','','','',2,10,34),(903,'2 Bedroom Apartment',5,4,0,153.00,765.00,20.00,956.00,153.00,40.00,0.00,1604.00,'','','','','','',2,9,34),(902,'1 Bedroom Ocean View Apartment',5,2,0,147.00,735.00,20.00,919.00,147.00,40.00,0.00,1554.00,'','','','','','',2,8,34),(901,'1 Bedroom Standard Apartment',5,2,0,129.00,645.00,20.00,806.00,129.00,40.00,0.00,1404.00,'','','','','','',2,7,34),(900,'3 Bedroom Ocean View Apartment',3,6,0,255.00,765.00,20.00,956.00,255.00,40.00,0.00,1424.00,'','','','','','',1,6,34),(899,'3 Bedroom Standard Apartment',3,6,0,235.00,705.00,20.00,881.00,235.00,40.00,0.00,1334.00,'','','','','','',1,5,34),(898,'2 Bedroom Ocean View Apartment',3,4,0,205.00,615.00,20.00,769.00,205.00,40.00,0.00,1274.00,'','','','','','',1,4,34),(897,'2 Bedroom Apartment',3,4,0,186.00,558.00,20.00,698.00,186.00,40.00,0.00,1184.00,'','','','','','',1,3,34),(896,'1 Bedroom Ocean View Apartment',3,2,0,165.00,495.00,20.00,619.00,165.00,40.00,0.00,1154.00,'','','','','','',1,2,34),(895,'1 Bedroom Standard Apartment',3,2,0,147.00,441.00,20.00,551.00,147.00,40.00,0.00,1064.00,'','','','','','',1,1,34),(816,'3 Bedroom Ocean View',4,6,0,212.00,848.00,20.00,1060.00,0.00,0.00,0.00,0.00,'','','','','','',2,9,33),(815,'2 Bedroom Ocean View',4,4,0,192.00,768.00,20.00,960.00,0.00,0.00,0.00,0.00,'','','','','','',2,8,33),(814,'1 Bedroom Garden View',4,2,0,140.00,560.00,20.00,700.00,0.00,0.00,0.00,0.00,'','','','','','',2,7,33),(813,'3 Bedroom Ocean View',4,6,0,206.00,824.00,20.00,1030.00,0.00,0.00,0.00,0.00,'','','','','','',1,3,33),(812,'2 Bedroom Ocean View',4,4,0,156.00,624.00,20.00,780.00,0.00,0.00,0.00,0.00,'','','','','','',1,2,33),(811,'1 Bedroom Garden View',4,2,0,129.00,516.00,20.00,645.00,0.00,0.00,0.00,0.00,'','','','','','',1,1,33),(744,'3 Bedroom Penthouse/Premium Townhouse',3,6,0,262.66,787.98,20.00,985.00,0.00,0.00,0.00,0.00,'','','','','','',1,5,31),(743,'3 Bedroom Apartment/Townhouse',3,6,0,243.66,730.98,20.00,914.00,0.00,0.00,0.00,0.00,'','','','','','',1,4,31),(742,'2 Bedroom Penthouse ',3,4,0,225.00,675.00,20.00,844.00,0.00,0.00,0.00,0.00,'','','','','','',1,3,31),(741,'2 Bedroom Apartment/Townhouse',3,4,0,206.33,618.99,20.00,774.00,0.00,0.00,0.00,0.00,'','','','','','',1,2,31),(740,'1 Bedroom Apartment',3,2,0,186.33,558.99,20.00,699.00,0.00,0.00,0.00,0.00,'','','','','','',1,1,31),(716,'1 bedroom apartment',3,2,0,186.33,558.99,0.00,0.00,0.00,0.00,0.00,0.00,'','','','','','',1,1,32),(698,'Standard Room',3,2,0,159.73,479.20,20.00,599.00,159.73,30.00,30.00,850.00,'','','','','','',1,1,29),(695,'Standard Room',3,2,0,159.73,479.20,20.00,599.00,159.73,30.00,30.00,850.00,'','','','','','',1,1,30),(689,'Beachfront Bure',5,2,0,1225.00,6125.00,10.00,0.00,0.00,0.00,0.00,5889.00,'','','','','','',1,1,28),(687,'Deluxe Pool View Room',7,2,0,3300.00,23100.00,20.00,1321.00,3300.00,1200.00,600.00,2837.00,'','','','','','',3,13,20),(686,'Deluxe Pool View Room',7,7,0,2800.00,19600.00,20.00,1121.00,2800.00,1200.00,600.00,2948.00,'','','','','','',2,7,20),(685,'Deluxe Pool View Room',7,2,0,1400.00,9800.00,20.00,560.00,1400.00,1200.00,600.00,2166.00,'','','','','','',1,1,20),(681,'3 Bedroom',0,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'','','','','','',1,3,27),(680,'2 Bedroom',0,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'','','','','','',1,2,27),(679,'1 Bedroom',0,0,0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'','','','','','',1,1,27),(678,'Ocean Front Beach Room',5,2,0,297.75,1488.75,15.00,2538.00,297.75,165.00,100.00,0.00,'','','','','','',4,19,26),(677,'Ocean Front Beach Room',5,2,0,351.00,1755.00,15.00,2991.00,351.00,196.00,118.00,0.00,'','','','','','',3,13,26),(676,'Ocean Front Beach Room',5,2,0,373.50,1867.50,15.00,3183.00,373.50,208.00,125.00,0.00,'','','','','','',2,7,26),(675,'Ocean Front Beach Room',5,2,0,313.50,1567.50,15.00,2672.00,313.50,174.00,105.00,0.00,'','','','','','',1,1,26),(674,'Overwater Villa',5,2,0,581.25,2906.25,15.00,4954.00,581.25,71.25,36.00,0.00,'','','','','','',4,20,25),(673,'Sky Room',5,2,0,356.25,1781.25,15.00,3036.00,356.25,71.25,36.00,0.00,'','','','','','',4,19,25),(672,'Overwater Villa',5,2,0,712.50,3562.50,15.00,6072.00,712.50,71.25,36.00,0.00,'','','','','','',3,14,25);

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `answer_type` enum('Drop Down','Checkbox','Radio','Textbox') NOT NULL,
  `answer_options` text NOT NULL,
  `use_other` enum('Yes','No') NOT NULL DEFAULT 'No',
  `opt_in` enum('Yes','No') NOT NULL DEFAULT 'No',
  `opt_in_text` text NOT NULL,
  `is_required` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sort_order` int(10) NOT NULL DEFAULT '0',
  `survey_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `questions`
--
-- WHERE:  1 ORDER BY id DESC limit 50

INSERT INTO `questions` VALUES (100,'What can we do as management to make your job better?','Textbox','','No','No','','Yes',0,23),(99,'I have the appropriate amount of training to make correct decisions about your work?','Radio','Strongly Disagree|Disagree|Neutral/Neither agree nor disagree|Agree|Strongly Agree','No','No','','Yes',0,23),(98,'I am a proud to be a member of my team?','Radio','Strongly Disagree|Disagree|Neutral/Neither agree nor disagree|Agree|Strongly Agree','No','No','','Yes',0,23),(97,'Do you know what you should do to help the company meet its goals and objectives?','Radio','Yes I Understand what is required and I do whatever it takes to achieve this|Yes I understand as long as it fits in my hours|Yes I believe I do this|No I dont know','No','No','','Yes',0,23),(96,'Do you understand the strategic goals of our division?','Radio','Yes, I understand exactly|I am a little unsure, but I sort of understand|No I have no idea','No','No','','Yes',0,23),(95,'Communication between Team Leaders and employees is good in my team','Radio','Strongly Disagree|Disagree|Neutral/Neither agree nor disagree|Agree|Strongly Agree','No','No','','Yes',0,23),(94,'My Team Leader and I have a good working relationship.','Radio','Strongly Disagree|Disagree|Neutral/Neither agree nor disagree|Agree|Strongly Agree','No','No','','Yes',0,23),(93,'I am inspired to meet my goals at work.','Radio','Strongly Disagree|Disagree|Neutral/Neither agree nor disagree|Agree|Strongly Agree','No','No','','Yes',0,23),(92,'I am satisfied with my opportunities for professional growth.','Radio','Strongly Disagree|Disagree|Neutral/Neither agree nor disagree|Agree|Strongly Agree','No','No','','Yes',0,23),(91,'How often do you travel to Queensland a year?','Radio','Once a Year|2 - 3 times|4 or more','No','No','','Yes',0,22),(90,'Outside of Queensland, What other states do you travel to wither for business or holidays','Checkbox','NSW|VIC|SA|TAS|WA|NT|ACT','No','No','','Yes',1,22),(88,'I agree to the Terms and Conditions ','Drop Down','Yes |\r\nNo ','No','No','','Yes',4,18),(87,'Email ','Textbox','','No','No','','Yes',2,18),(86,'Last Name','Textbox','','No','No','','Yes',1,18),(85,'First Name ','Textbox','','No','No','','Yes',0,18),(84,'Earn an extra entry by signing up to the Discover Queensland Newsletter!','Checkbox','','No','Yes','','No',0,17),(83,'Email','Textbox','','No','No','','Yes',0,17),(82,'Last Name','Textbox','','No','No','','Yes',0,17),(81,'First Name','Textbox','','No','No','','Yes',0,17),(80,'Earn an extra entry by signing up to the Discover Queensland Newsletter!','Radio','','No','Yes','','No',0,16),(79,'Email','Textbox','','No','No','','Yes',0,16),(78,'Last Name','Textbox','','No','No','','Yes',0,16),(77,'First Name','Textbox','','No','No','','Yes',0,16),(76,'Email','Textbox','','No','No','','Yes',0,15),(75,'Last Name','Textbox','','No','No','','Yes',0,15),(74,'First Name','Textbox','','No','No','','Yes',0,15),(73,'Terms & Conditions.','Checkbox','By entering this competition, I agree to the Terms & Conditions.','No','No','','Yes',1,15),(72,'Email Address','Textbox','','No','Yes','Earn an extra entry by joining the Discover Queensland Newsletter!','Yes',0,14),(71,'Last Name','Textbox','','No','No','','Yes',0,14),(70,'First Name','Textbox','','No','No','','Yes',0,14),(68,'Email Address','Textbox','','No','Yes','Earn an extra entry by joining the Discover Queensland Newsletter!','Yes',0,13),(67,'Last Name','Textbox','','No','No','','Yes',0,13),(66,'First Name','Textbox','','No','No','','Yes',0,13),(65,'<B>Earn an extra entry by signing up to the Discover Queensland Newsletter!<B>','Checkbox','Yes Please!','No','No','','No',0,12),(64,'Email Address','Textbox','','No','No','','Yes',0,12),(63,'Last Name','Textbox','','No','No','','Yes',0,12),(62,'First Name','Textbox','','No','No','','Yes',0,12),(61,'<B>Earn an extra entry by signing up to the Discover Queensland Newsletter!<B>','Checkbox','Yes Please!','No','No','','No',0,11),(60,'Email Address','Textbox','','No','No','','Yes',0,11),(59,'Last Name','Textbox','','No','No','','Yes',0,11),(58,'First Name','Textbox','','No','No','','Yes',0,11),(57,'By entering this competition, I agree to the Terms & Conditions.','Checkbox','Yes','No','No','','Yes',3,10),(56,'Email','Textbox','','No','No','','Yes',2,10),(55,'Last Name','Textbox','','No','No','','Yes',1,10),(54,'First Name','Textbox','','No','No','','Yes',0,10),(53,'State/Country','Drop Down','Queensland|New South Wales|Victoria|Australian Capital Territories|South Australia |Tasmania| Western Australia|Northern Territories |New Zealand ','No','No','','No',3,9),(52,'Email Address','Textbox','','No','No','','Yes',2,9),(51,'<B>Earn an extra entry by signing up to the Discover Queensland Newsletter!<B>','Radio','Yes, I\'ll have an extra entry!|No Thanks','No','No','','No',4,9),(50,'Last Name','Textbox','','No','No','','Yes',1,9),(49,'First Name','Textbox','','No','No','','Yes',0,9);

--
