-- Table structure for table `general_weather`
--

CREATE TABLE `general_weather` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `min_temp` varchar(200) NOT NULL,
  `max_temp` varchar(200) NOT NULL,
  `icon` varchar(200) NOT NULL,
  `alt_tag` varchar(200) NOT NULL,
  `rss_url` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `general_weather` VALUES (8,'Sydney','13','25','https://www.weather.com.au/images/icons/2.gif','Mostly Sunny','nsw/sydney'),(7,'Perth','10','23','https://www.weather.com.au/images/icons/2.gif','Mostly Sunny','wa/perth'),(6,'Melbourne','9','19','https://www.weather.com.au/images/icons/4.gif','Afternoon Clouds','vic/melbourne'),(5,'Hobart','8','18','https://www.weather.com.au/images/icons/33.gif','Passing Showers','tas/hobart'),(4,'Darwin','23','34','https://www.weather.com.au/images/icons/1.gif','Sunny','nt/darwin'),(3,'Canberra','1','21','https://www.weather.com.au/images/icons/5.gif','High Level Clouds','act/canberra'),(2,'Brisbane','16','28','https://www.weather.com.au/images/icons/18.gif','Light Rain Early','qld/brisbane '),(1,'Adelaide','12','19','https://www.weather.com.au/images/icons/4.gif','Morning Clouds','sa/adelaide ');

--
-- Table structure for table `gswrates`
--

CREATE TABLE `gswrates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `Year` int(4) NOT NULL DEFAULT '2011',
  `RoomsID` int(10) NOT NULL DEFAULT '0',
  `PropertiesID` int(10) NOT NULL DEFAULT '0',
  `RoomRate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate5` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate6` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate7` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate8` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate9` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate10` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RoomRate11` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate5` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate6` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate7` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate8` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate9` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate10` decimal(10,2) NOT NULL DEFAULT '0.00',
  `NetRate11` decimal(10,2) NOT NULL DEFAULT '0.00',
  `IsOnline` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  PRIMARY KEY (`id`),
  KEY `RoomsID` (`RoomsID`)
) ENGINE=MyISAM AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;

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

INSERT INTO `gswrates` VALUES (97,2015,38894,9170,0.00,0.00,1390.00,1125.00,970.00,865.00,825.00,795.00,0.00,0.00,0.00,0.00,0.00,787.50,590.63,472.50,393.75,363.75,341.25,0.00,0.00,0.00,'Yes'),(96,2015,38893,9170,0.00,0.00,1130.00,935.00,815.00,735.00,705.00,680.00,0.00,0.00,0.00,0.00,0.00,593.75,445.31,356.25,296.88,273.21,255.47,0.00,0.00,0.00,'No'),(95,2015,38892,9170,0.00,0.00,835.00,710.00,635.00,590.00,565.00,550.00,0.00,0.00,0.00,0.00,0.00,371.25,278.44,222.75,185.63,170.36,158.91,0.00,0.00,0.00,'No'),(94,2015,38891,9170,0.00,1565.00,1155.00,955.00,880.00,830.00,0.00,0.00,0.00,0.00,0.00,0.00,918.75,612.50,459.38,404.25,367.50,0.00,0.00,0.00,0.00,0.00,'Yes'),(93,2015,38890,9170,0.00,1275.00,965.00,810.00,750.00,710.00,0.00,0.00,0.00,0.00,0.00,0.00,703.13,468.75,351.56,307.50,278.13,0.00,0.00,0.00,0.00,0.00,'No'),(92,2015,38889,9170,0.00,935.00,735.00,635.00,600.00,575.00,0.00,0.00,0.00,0.00,0.00,0.00,444.38,296.25,222.19,193.50,174.38,0.00,0.00,0.00,0.00,0.00,'No'),(91,2015,38888,9170,1285.00,815.00,895.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,708.75,354.38,297.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Yes'),(90,2015,38887,9170,1165.00,755.00,675.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,618.75,309.38,250.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'No'),(89,2015,38886,9170,925.00,635.00,570.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,438.75,219.38,172.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'No'),(88,2015,38577,9316,2388.00,1364.00,1193.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1778.00,959.00,799.75,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Yes'),(87,2015,38576,9316,2230.00,1285.00,1141.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1652.00,896.00,757.82,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Yes'),(86,2015,38575,9316,2073.00,1206.00,1088.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1526.00,833.00,715.82,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Yes'),(85,2015,38574,9316,1915.00,1128.00,1036.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1400.00,770.00,666.82,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Yes');

--
-- Table structure for table `guestsassets`
--

CREATE TABLE `guestsassets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DCreated` date DEFAULT NULL,
  `DExpires` date NOT NULL,
  `Name` varchar(50) NOT NULL,
  `IsSuspended` enum('Yes','No') NOT NULL DEFAULT 'No',
  `Price` decimal(10,2) NOT NULL,
  `PackageID` int(10) DEFAULT '0',
  `GuestsID` int(10) unsigned DEFAULT NULL,
  `AssetsMaxPeriod` int(11) DEFAULT '3',
  `IsUsable` enum('Yes','No') DEFAULT 'No',
  `IsRedeemed` enum('Yes','No') DEFAULT 'No',
  `RCreated` date DEFAULT NULL,
  `RComments` text NOT NULL,
  `BookingsID` int(11) DEFAULT '0',
  `ExternalID` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `GuestsID` (`GuestsID`),
  KEY `BookingsID` (`BookingsID`)
) ENGINE=MyISAM AUTO_INCREMENT=15264725 DEFAULT CHARSET=latin1;

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

INSERT INTO `guestsassets` VALUES (15264724,'2020-08-22','2021-08-22','Ambassador Discover Queensland Card','No',199.00,1915140,1562353,3,'No','No',NULL,'',0,123345),(15264723,'2020-08-21','2021-08-21','Ambassador Discover Queensland Card','No',199.00,1915139,1561904,0,'No','No',NULL,'',0,123339),(15264722,'2020-08-21','2021-08-21','Ambassador Discover Queensland Card','No',199.00,1915138,1546489,0,'No','No',NULL,'',0,123338),(15264721,'2020-08-20','2021-08-20','Ambassador Discover Queensland Card','No',199.00,1915137,1606508,3,'No','No',NULL,'',0,123327),(15264720,'2020-08-20','2021-08-20','Ambassador Discover Queensland Card','No',199.00,1915136,1606507,3,'No','No',NULL,'',0,123326),(15264719,'2020-08-20','2021-08-20','Ambassador Discover Queensland Card','No',199.00,1915135,1517248,3,'No','No',NULL,'',0,69790),(15264718,'2020-08-20','2021-08-20','Ambassador Discover Queensland Card','No',199.00,1915134,1603950,3,'No','No',NULL,'',0,105776),(15264717,'2020-08-20','2021-08-20','Ambassador Discover Queensland Card','No',199.00,1915133,1606493,3,'No','No',NULL,'',0,123325),(15264716,'2020-08-20','0000-00-00','HOT CREDIT $700','No',700.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264715,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264714,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264713,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264712,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264711,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264710,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264709,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264708,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264707,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264706,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264705,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264704,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264703,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264702,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264701,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264700,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264699,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264698,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264697,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264696,'2020-08-20','0000-00-00','Hightide+ VIP Accommodation Voucher','No',99.00,1915132,248069,1,'Yes','No',NULL,'',0,0),(15264695,'2020-08-20','0000-00-00','Hightide+ Holidays Gift Wallet','No',9.95,1915132,248069,1,'No','No',NULL,'',0,0),(15264694,'2020-08-20','0000-00-00','Hightide+ Holidays Gift Wallet','No',9.95,1915132,248069,1,'No','No',NULL,'',0,0),(15264693,'2020-08-20','0000-00-00','Hightide Holidays+ Holiday & Travel Guide','No',19.95,1915132,248069,1,'No','No',NULL,'',0,0),(15264692,'2020-08-20','2021-08-20','Hightide Holidays VIP Ambassador Card','No',199.00,1915132,248069,1,'No','No',NULL,'',0,68141),(15264691,'2020-08-20','2021-08-20','Ambassador Discover Queensland Card','No',199.00,1915131,1606481,0,'No','No',NULL,'',0,123324),(15264690,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915130,1606488,3,'No','No',NULL,'',0,123318),(15264689,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915129,1605078,3,'No','No',NULL,'',0,123317),(15264688,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915128,1605928,3,'No','No',NULL,'',0,123316),(15264687,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915127,1606407,3,'No','No',NULL,'',0,123315),(15264686,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915126,1565045,3,'No','No',NULL,'',0,123314),(15264685,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915125,1606488,3,'No','No',NULL,'',0,123318),(15264684,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915124,1605078,3,'No','No',NULL,'',0,123317),(15264683,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915123,1605928,3,'No','No',NULL,'',0,123316),(15264682,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915122,1606407,3,'No','No',NULL,'',0,123315),(15264681,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915121,1565045,3,'No','No',NULL,'',0,123314),(15264680,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915120,1606488,3,'No','No',NULL,'',0,123318),(15264679,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915119,1605078,3,'No','No',NULL,'',0,123317),(15264678,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915118,1605928,3,'No','No',NULL,'',0,123316),(15264677,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915117,1606407,3,'No','No',NULL,'',0,123315),(15264676,'2020-08-19','2021-08-19','Ambassador Discover Queensland Card','No',199.00,1915116,1565045,3,'No','No',NULL,'',0,123314),(15264675,'2020-08-19','0000-00-00','Entertainment $50 Voucher','No',50.00,0,1602645,3,'Yes','Yes','2020-08-19','	BNDH870198205731',0,0);

--
-- Table structure for table `guestsassetsinstallments`
--

CREATE TABLE `guestsassetsinstallments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_dt` date DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  `is_suspended` enum('Yes','No') NOT NULL DEFAULT 'No',
  `price` decimal(10,2) NOT NULL,
  `package_id` int(10) DEFAULT '0',
  `guest_id` int(10) unsigned DEFAULT NULL,
  `assets_max_period` int(11) DEFAULT '3',
  `is_usable` enum('Yes','No') DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `guest_id` (`guest_id`)
) ENGINE=MyISAM AUTO_INCREMENT=49781 DEFAULT CHARSET=latin1;

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

INSERT INTO `guestsassetsinstallments` VALUES (49780,'2020-08-18','HOT CREDIT $900','No',900.00,6915,16000,1,'No'),(49779,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49778,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49777,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49776,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49775,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49774,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49773,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49772,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49771,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49770,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49769,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49768,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49767,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49766,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49765,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49764,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49763,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49762,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49761,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49760,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49759,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49758,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49757,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49756,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49755,'2020-08-18','Hightide+ VIP Accommodation Voucher','No',99.00,6915,16000,1,'Yes'),(49754,'2020-08-18','Hightide+ Holidays Gift Wallet','No',9.95,6915,16000,1,'No'),(49753,'2020-08-18','Hightide+ Holidays Gift Wallet','No',9.95,6915,16000,1,'No'),(49752,'2020-08-18','Hightide Holidays+ Holiday & Travel Guide','No',19.95,6915,16000,1,'No'),(49751,'2020-08-18','Hightide Holidays+ Holiday & Travel Guide','No',19.95,6915,16000,1,'No'),(49750,'2020-08-18','Hightide Holidays VIP Ambassador Card','No',199.00,6915,16000,1,'No'),(49626,'2020-07-28','HOT CREDIT $700','No',700.00,6912,266521,1,'Yes'),(49625,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49624,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49623,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49622,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49621,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49620,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49619,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49618,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49617,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49616,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49615,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49614,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49613,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49612,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49611,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49610,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49609,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes'),(49608,'2020-07-28','Hightide+ VIP Accommodation Voucher','No',99.00,6912,266521,1,'Yes');

--
-- Table structure for table `guestscomments`
--

CREATE TABLE `guestscomments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Title` varchar(200) NOT NULL,
  `Comment` text NOT NULL,
  `DateCreated` datetime NOT NULL,
  `GuestsID` int(11) NOT NULL,
  `AdministratorsID` int(11) NOT NULL,
  `CommentType` enum('Booking','Profile','Membership','Travel Package') NOT NULL DEFAULT 'Profile',
  `BookingsID` int(11) NOT NULL DEFAULT '0',
  `UserCreated` enum('Yes','No') NOT NULL DEFAULT 'No',
  `IsDeleted` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `GuestsID` (`GuestsID`),
  KEY `BookingsID` (`BookingsID`),
  KEY `DateCreated` (`DateCreated`),
  KEY `CommentType` (`CommentType`)
) ENGINE=MyISAM AUTO_INCREMENT=6419758 DEFAULT CHARSET=latin1;

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

INSERT INTO `guestscomments` VALUES (6419757,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',356676,0,'Profile',0,'No','No'),(6419756,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',312777,0,'Profile',0,'No','No'),(6419755,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',1507040,0,'Profile',0,'No','No'),(6419754,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',1328060,0,'Profile',0,'No','No'),(6419753,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',1278423,0,'Profile',0,'No','No'),(6419752,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',314640,0,'Profile',0,'No','No'),(6419751,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',279100,0,'Profile',0,'No','No'),(6419750,'','Member unassigned as there was no contact for over 12 months.','2020-08-23 23:27:23',276440,0,'Profile',0,'No','No'),(6419749,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNRC698198203914 - Q1 Resort & Spa [2 Bedroom Spa]','2020-08-23 09:00:05',1606485,997,'Booking',209908,'No','No'),(6419748,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNDH870198205731 - Pavillions on 1770 [3 Bedroom - Stay 3 & Save]','2020-08-23 09:00:05',1602645,249,'Booking',209905,'No','No'),(6419747,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNST357198202230 - Turtle Beach Resort [2 Bedroom Family - 3 NIGHT SALE]','2020-08-23 09:00:05',1529435,1212,'Booking',209883,'No','No'),(6419746,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNPD304188209186 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Penthouse - LGAD]','2020-08-23 09:00:05',1605271,1213,'Booking',209829,'No','No'),(6419745,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNTS454178204445 - Sea Temple Private Apartments Port Douglas BC [1 Bedroom Swimout - LGAM]','2020-08-23 09:00:05',1606438,467,'Booking',209816,'No','No'),(6419744,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNNG459118206725 - Oaks Sunshine Coast Oasis Resort [Executive Family - FLASH SALE]','2020-08-23 09:00:05',1599959,1213,'Booking',209649,'No','No'),(6419743,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNMD634582034017 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool]','2020-08-23 09:00:05',1590048,467,'Booking',209462,'No','No'),(6419742,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNRP618482064746 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Swimout]','2020-08-23 09:00:05',1606232,997,'Booking',209433,'No','No'),(6419741,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNGH914382011077 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Penthouse - LGAC]','2020-08-23 09:00:05',1601210,467,'Booking',209376,'No','No'),(6419740,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNLC495382029597 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool]','2020-08-23 09:00:05',1606021,467,'Booking',209374,'No','No'),(6419739,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNNB294382074492 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool - LGAA]','2020-08-23 09:00:05',1571360,467,'Booking',209367,'No','No'),(6419738,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNHS423277204400 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Swimout - LGAC]','2020-08-23 09:00:05',1606130,467,'Booking',209205,'No','No'),(6419737,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNCZ389227204534 - Niramaya Villas & Spa [1 Bedroom Villa - Stay 7 & Save]','2020-08-23 09:00:05',1600415,467,'Booking',209075,'No','No'),(6419736,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4217203704 - Cayman Quays Noosaville [2 Bedroom Apartment]','2020-08-23 09:00:05',1600108,467,'Booking',209040,'No','No'),(6419735,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNKLB11177206070 - Aria Penthouse [Aria Penthouse]','2020-08-23 09:00:05',1603123,656,'Booking',208943,'No','No'),(6419734,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNPS520177206477 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Apartment]','2020-08-23 09:00:05',1519353,656,'Booking',208939,'No','No'),(6419733,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNKS704167203581 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','2020-08-23 09:00:05',1605957,1168,'Booking',208910,'No','No'),(6419732,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNRZ755167201851 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Penthouse - LGAC]','2020-08-23 09:00:05',1599411,467,'Booking',208895,'No','No'),(6419731,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNBG175157208766 - Spicers Clovelly Estate [Estate Suite]','2020-08-23 09:00:05',1599977,467,'Booking',208865,'No','No'),(6419730,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNAB249147206609 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool]','2020-08-23 09:00:05',1591540,997,'Booking',208835,'No','No'),(6419729,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNDC299137208859 - Sea Temple Private Apartments Port Douglas BC [1 Bedroom Plunge Pool - LGAB]','2020-08-23 09:00:05',1604404,467,'Booking',208820,'No','No'),(6419728,'Booking still not confirmed by Property','Booking still not confirmed by Property for BN89244137208692 - Paradise Resort [Superior Junior Bunkhouse - 4 Night Stay & Save]','2020-08-23 09:00:05',289244,997,'Booking',208803,'No','No'),(6419727,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNJW108107208014 - Fitzroy Island Resort [Beach Cabin - FLASH SALE]','2020-08-23 09:00:05',1599156,1212,'Booking',208761,'No','No'),(6419726,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNAH395972082632 - Q1 Resort & Spa [1 Bedroom Spa Family - SALE]','2020-08-23 09:00:05',1605844,997,'Booking',208739,'No','No'),(6419725,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNJC490772042086 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Swimout]','2020-08-23 09:00:05',1600620,997,'Booking',208662,'No','No'),(6419724,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNRJ415372014104 - The Sebel Pelican Waters [Classic Room - FLASH SALE]','2020-08-23 09:00:05',1600462,249,'Booking',208491,'No','No'),(6419723,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNAS369256209211 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','2020-08-23 09:00:05',1580775,249,'Booking',208137,'No','No'),(6419722,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNRO391246205154 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','2020-08-23 09:00:05',1602684,249,'Booking',208116,'No','No'),(6419721,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNMM831246203005 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','2020-08-23 09:00:05',1588080,249,'Booking',208087,'No','No'),(6419720,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNNG444226204512 - Q1 Resort & Spa [2 Bedroom Ocean - SALE]','2020-08-23 09:00:05',1605232,467,'Booking',207907,'No','No'),(6419719,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNAS715226202056 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Apartment]','2020-08-23 09:00:05',1530003,997,'Booking',207881,'No','No'),(6419718,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4156205262 - Ivory Palms Resort [2 Bedroom Townhouse - 2 Nights]','2020-08-23 09:00:05',1600108,467,'Booking',207695,'No','No'),(6419717,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4156205287 - Ivory Palms Resort [3 Bedroom Townhouse - 2 Nights]','2020-08-23 09:00:05',1600108,467,'Booking',207694,'No','No'),(6419716,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNNA217116205245 - Qube Broadbeach [ICON] [2 Bedroom Partial Ocean View - GLG]','2020-08-23 09:00:05',1605323,997,'Booking',207652,'No','No'),(6419715,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNCR172106208910 - Qube Broadbeach [ICON] [2 Bedroom Partial Ocean View - GLG]','2020-08-23 09:00:05',1605322,467,'Booking',207629,'No','No'),(6419714,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNAK197962057823 - Qube Broadbeach [ICON] [2 Bedroom Partial Ocean View - GLG]','2020-08-23 09:00:05',1593367,467,'Booking',207611,'No','No'),(6419713,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNBD950562014656 - Villa 308 BC [3 Bedroom Villa]','2020-08-23 09:00:05',1601083,249,'Booking',207585,'No','No'),(6419712,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNCG326265209111 - BreakFree Diamond Beach [2 Bedroom Deluxe - FLASH SALE 7 NIGHTS]','2020-08-23 09:00:05',1600128,249,'Booking',207460,'No','No'),(6419711,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNFP367265208975 - BreakFree Diamond Beach [2 Bedroom Deluxe - FLASH SALE 7 NIGHTS]','2020-08-23 09:00:05',1600125,249,'Booking',207459,'No','No'),(6419710,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNGS822245209566 - Q1 Resort & Spa [1 Bedroom Spa - SALE]','2020-08-23 09:00:05',1605259,249,'Booking',207443,'No','No'),(6419709,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNJRR53205207950 - Fitzroy Island Resort [Island Suite]','2020-08-23 09:00:05',1599154,889,'Booking',207425,'No','No'),(6419708,'Booking still not confirmed by Property','Booking still not confirmed by Property for BNTAH54205202715 - Q1 Resort & Spa [1 Bedroom Spa Family - SALE]','2020-08-23 09:00:05',1601278,249,'Booking',207424,'No','No');

--
-- Table structure for table `guestsletters`
--

CREATE TABLE `guestsletters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `descr` text NOT NULL,
  `letter` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

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



--
-- Table structure for table `guestsreferrals`
--

CREATE TABLE `guestsreferrals` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `Title` varchar(20) DEFAULT NULL,
  `LastName` varchar(100) DEFAULT NULL,
  `FirstName` varchar(50) DEFAULT NULL,
  `Phone` varchar(20) DEFAULT NULL,
  `Work` varchar(20) DEFAULT NULL,
  `Mobile` varchar(20) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `ReferrerPhone` varchar(25) DEFAULT NULL,
  `ReferrerAddress` varchar(255) DEFAULT NULL,
  `ReferrerSuburb` varchar(100) DEFAULT NULL,
  `StatesID` int(10) DEFAULT NULL,
  `CountriesID` int(10) DEFAULT '0',
  `Postcode` varchar(5) DEFAULT NULL,
  `DateContact` date DEFAULT NULL,
  `DateCallback` datetime DEFAULT NULL,
  `Comments` text,
  `ReferrerName` varchar(255) DEFAULT NULL,
  `GuestCode` varchar(50) DEFAULT NULL,
  `GuestsID` int(10) DEFAULT '0',
  `AdministratorsID` int(11) DEFAULT NULL,
  `DistributionsID` int(10) DEFAULT '0',
  `DoNotCall` tinyint(2) DEFAULT '0',
  `AuthorisedBy` varchar(50) NOT NULL DEFAULT '0',
  `DateAuthorised` date DEFAULT NULL,
  `DateWashed` date DEFAULT NULL,
  `DateModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `IsSubscribed` enum('Yes','No') DEFAULT 'No',
  `IsFinished` enum('Yes','No') DEFAULT 'No',
  `Voucher` varchar(25) DEFAULT NULL,
  `IsSale` enum('Yes','No') DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `phone_h` (`Phone`) USING BTREE,
  KEY `phone_w` (`Work`) USING BTREE,
  KEY `phone_m` (`Mobile`) USING BTREE,
  KEY `last_name` (`LastName`) USING BTREE,
  KEY `first_name` (`FirstName`) USING BTREE,
  KEY `email` (`Email`) USING BTREE,
  KEY `tm_code` (`AdministratorsID`) USING BTREE,
  KEY `date_contact` (`DateContact`) USING BTREE,
  KEY `date_callback` (`DateCallback`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=83710 DEFAULT CHARSET=latin1;

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

INSERT INTO `guestsreferrals` VALUES (83709,'Mr','gomouldy','cathy','','','0418280679',NULL,'g.,h;lk;lffhlf','11 Hannell Street','BONNE\'LLS BAY',2,1,'2264',NULL,'2019-11-16 09:30:00',NULL,'Tracey goodwin','TG42750',1281285,1146,64,0,'0',NULL,'2019-11-18','2019-11-15 00:46:23','No','No',NULL,'Yes'),(83708,'Mr','','machelle','','','0404428225',NULL,'g.,h;lk;lffhlf','11 Hannell Street','BONNE\'LLS BAY',2,1,'2264',NULL,'2019-11-16 09:30:00',NULL,'Tracey goodwin','TG42750',1281285,1146,64,0,'0',NULL,'2019-11-18','2019-11-15 00:46:23','No','No',NULL,'Yes'),(83707,'Mr','okeefe ','cheryl ','','','0416256977',NULL,'g.,h;lk;lffhlf','11 Hannell Street','BONNE\'LLS BAY',2,1,'2264',NULL,'2019-11-16 09:30:00',NULL,'Tracey goodwin','TG42750',1281285,1146,64,0,'0',NULL,'2019-11-18','2019-11-15 00:46:23','No','No',NULL,'Yes'),(83706,'Ms','Giles','Brittany','','','0403109443','','0419344265','21 Waterview Street','Mount Martha',3,1,'3934',NULL,'2019-11-16 09:30:00','Referee is a friend Natalie Johnson $199 pack purchased on 15/11/19 & 2017, 2008, 2005 purchases.','Natalie Johnson','134370',334370,573,64,0,'0',NULL,'2019-11-18','2019-11-15 00:35:06','No','No','$199 15/11/19','Yes'),(83704,'Mr','do not say who reffered ','julie','','','0411 044 961',NULL,'0412123100','68 blue grass cres','eightmile planes',1,1,'4113',NULL,'2019-11-08 09:30:00',NULL,'Julie Tymms','34990',234990,1146,64,0,'0',NULL,'2019-11-08','2019-11-07 01:28:59','No','No',NULL,'Yes'),(83703,'Mr','do not say who reffered ','jane','','','0431 689 090',NULL,'0412123100','68 blue grass cres','eightmile planes',1,1,'4113',NULL,'2019-11-08 09:30:00',NULL,'Julie Tymms','34990',234990,1146,64,0,'0',NULL,'2019-11-08','2019-11-07 01:28:59','No','No',NULL,'Yes'),(83702,'Mr','do not say who reffered ','chelsea','','','0438 118 357',NULL,'0412123100','68 blue grass cres','eightmile planes',1,1,'4113',NULL,'2019-11-08 09:30:00',NULL,'Julie Tymms','34990',234990,1146,64,0,'0',NULL,'2019-11-08','2019-11-07 01:28:59','No','No',NULL,'Yes'),(83701,'Mr','do not say who reffered ','linda','','','0478 411 801',NULL,'0412123100','68 blue grass cres','eightmile planes',1,1,'4113',NULL,'2019-11-08 09:30:00',NULL,'Julie Tymms','34990',234990,1146,64,0,'0',NULL,'2019-11-08','2019-11-07 01:28:59','No','No',NULL,'Yes'),(83700,'Mr','do not say who reffered ','christie ','','','0424 400 740',NULL,'0412123100','68 blue grass cres','eightmile planes',1,1,'4113',NULL,'2019-11-08 09:30:00',NULL,'Julie Tymms','34990',234990,1146,64,0,'0',NULL,'2019-11-08','2019-11-07 01:28:59','No','No',NULL,'Yes'),(83699,'Mr','Frost','Erica','','','0402249769',NULL,'0733501363','29 Magenta Street','WAVELL HEIGHTS',1,1,'4012',NULL,'2019-11-03 09:30:00',NULL,'Lorraine Higgins','159961',359961,1154,64,0,'0',NULL,'2019-11-04','2019-11-02 02:18:01','No','No',NULL,'Yes'),(83698,'Mr','Swallow','Lynne','','','0408872524',NULL,'0733501363','29 Magenta Street','WAVELL HEIGHTS',1,1,'4012',NULL,'2019-11-03 09:30:00',NULL,'Lorraine Higgins','159961',359961,1154,64,0,'0',NULL,'2019-11-04','2019-11-02 02:18:01','No','No',NULL,'Yes'),(83697,'Mr','','lynette','','','0439823705',NULL,'0749461332','P O Box 367','PROSERPINE',1,1,'4800',NULL,'2019-10-31 09:30:00',NULL,'Sandra And Ronald Donnelly','43318',243318,1146,64,0,'0',NULL,'2019-10-31','2019-10-30 09:17:13','No','No',NULL,'Yes'),(83696,'Mr','','peter','','','0475422790',NULL,'0749461332','P O Box 367','PROSERPINE',1,1,'4800',NULL,'2019-10-31 09:30:00',NULL,'Sandra And Ronald Donnelly','43318',243318,1146,64,0,'0',NULL,'2019-10-31','2019-10-30 09:17:13','No','No',NULL,'Yes'),(83695,'Mr','','daryl','','','0408062185',NULL,'0749461332','P O Box 367','PROSERPINE',1,1,'4800',NULL,'2019-10-31 09:30:00',NULL,'Sandra And Ronald Donnelly','43318',243318,1146,64,0,'0',NULL,'2019-10-31','2019-10-30 09:17:13','No','No',NULL,'Yes'),(83694,'Mr','','keegan','','','0417105023',NULL,'0749461332','P O Box 367','PROSERPINE',1,1,'4800',NULL,'2019-10-31 09:30:00',NULL,'Sandra And Ronald Donnelly','43318',243318,1146,64,0,'0',NULL,'2019-10-31','2019-10-30 09:17:13','No','No',NULL,'Yes'),(83693,'Mr','','alanna ','','','0499618741',NULL,'0749461332','P O Box 367','PROSERPINE',1,1,'4800',NULL,'2019-10-31 09:30:00',NULL,'Sandra And Ronald Donnelly','43318',243318,1146,64,0,'0',NULL,'2019-10-31','2019-10-30 09:17:13','No','No',NULL,'Yes'),(83692,'Mr','stanley','dainne','','','0438772139',NULL,'0265510853','52 Edindurgh Dr','TAREE SOUTH',2,1,'2430',NULL,'2019-10-29 09:30:00',NULL,'Rob & Daryl Wells','70165',270165,1146,64,0,'0',NULL,'2019-10-29','2019-10-28 08:15:39','No','No',NULL,'Yes'),(83691,'Mr','steen','brian ','','','0402496942',NULL,'0265510853','52 Edindurgh Dr','TAREE SOUTH',2,1,'2430',NULL,'2019-10-29 09:30:00',NULL,'Rob & Daryl Wells','70165',270165,1146,64,0,'0',NULL,'2019-10-29','2019-10-28 08:15:39','No','No',NULL,'Yes'),(83690,'Mr','attkinson','terry ','','','0411509451',NULL,'0265510853','52 Edindurgh Dr','TAREE SOUTH',2,1,'2430',NULL,'2019-10-29 09:30:00',NULL,'Rob & Daryl Wells','70165',270165,1146,64,0,'0',NULL,'2019-10-29','2019-10-28 08:15:39','No','No',NULL,'Yes'),(83689,'Mr','buttsworth','micah','65565108','','',NULL,'0265510853','52 Edindurgh Dr','TAREE SOUTH',2,1,'2430',NULL,'2019-10-29 09:30:00',NULL,'Rob & Daryl Wells','70165',270165,1146,64,0,'0',NULL,'2019-10-29','2019-10-28 08:15:39','No','No',NULL,'Yes'),(83688,'Mr','buttsworth','racheal ','65565310','','',NULL,'0265510853','52 Edindurgh Dr','TAREE SOUTH',2,1,'2430',NULL,'2019-10-29 09:30:00',NULL,'Rob & Daryl Wells','70165',270165,1146,64,0,'0',NULL,'2019-10-29','2019-10-28 08:15:39','No','No',NULL,'Yes'),(83687,'Mr','Anderson/Kirby','Sandy','','','0412511816',NULL,'0733130187','2a McKoy Street','COOPERS PLAINS',1,1,'4108',NULL,'2019-10-23 09:30:00',NULL,'Dianna Davis','54934',254934,1148,64,0,'0',NULL,'2019-10-23','2019-10-22 03:04:41','No','No',NULL,'Yes'),(83686,'Mr','cooper','christine ','3388 4362','','',NULL,'0741661359','7 Mitchell Street','MONTO',1,1,'4630',NULL,'2019-10-20 09:30:00',NULL,'Brian Kachel','16732',216732,1146,64,0,'0',NULL,'2019-10-21','2019-10-19 03:19:41','No','No',NULL,'Yes'),(83685,'','Moir','Shirley ','0741661665','','00000000000000000000','','0427435731','PO Box 145','Monto',1,1,'4630',NULL,'2019-10-18 09:30:00','Referred by her friend Helen Thomas who purchased a large package today 17/10/19 and has been a repeat data client for years. 19/10/19 Contact with Shirley who said when they get away they like to go camping away from everything. I told her all the different holiday options we have that\'s as far as I got because she hung up.','Helen & Trudie Thomas & Payne','120501',320501,573,64,0,'0','0000-00-00','2019-10-18','2019-10-19 02:49:54','No','No','17/9/19','Yes'),(83684,'','Wood','Jeanie','0741661452','','00000000000000000000','','0427435731','PO Box 145','Monto',1,1,'4630',NULL,'2019-11-09 09:00:59','Referred by Helen Thomas who purchased off me  today 17/10/19 and has been a repeat data client for many years. Jeanie is Helen\'s best friend.','Helen & Trudie Thomas & Payne','120501',320501,573,64,0,'0','0000-00-00','2019-10-18','2019-11-08 04:12:19','No','No','17/9/19','Yes'),(83683,'Mr','Kinnear','Coby','','','0477076022',NULL,'0754282116','18 Beereegan Court','CABOOLTURE',1,1,'4510',NULL,'2019-10-11 09:30:00',NULL,'Alan & Jenny.... Kinnear','111380',311380,573,64,0,'0',NULL,'2019-10-11','2019-10-10 06:34:23','No','No',NULL,'Yes'),(83682,'Mr','Kinnear','Travis ','','','0488774065',NULL,'0754282116','18 Beereegan Court','CABOOLTURE',1,1,'4510',NULL,'2019-10-11 09:30:00',NULL,'Alan & Jenny.... Kinnear','111380',311380,573,64,0,'0',NULL,'2019-10-11','2019-10-10 06:34:23','No','No',NULL,'Yes'),(83681,'Mr','Lette step daughter','Alysia ','','','0432643148',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83680,'Mr','Lette step daughter','Melissa','','','0407031702',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83679,'Mr','Clews fr','Karen ','','','0428425385',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83678,'Mr','Van Den Dreg fr','Emily','','','0406126156',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83677,'Mr','Gaston fr ','Melissa','','','0400069643',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83676,'Mr',' Mckay son in law','Glen','','','0437281266',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83675,'Mr','McKay son in law mum','Jacqui','','','0439860870',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83674,'Mr','McIntosh fr','Margaret','','','0438282714',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83673,'Mr','Stephenson fr','Michelle ','','','0420533895',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83672,'Mr','Hunt fr','Elena','','','0447668186',NULL,'0749541049','PO Box 96','Eaton',1,1,'4741',NULL,'2019-10-10 09:30:00',NULL,'Vicky Lette','NR410491',1421651,176,64,0,'0',NULL,'2019-10-11','2019-10-08 23:33:05','No','No',NULL,'Yes'),(83671,'Mr','arnold','ben ','','0499777874','0408 502 041','angellandben19@hotmail.com','0407639008','791 Matchbox Road','DEEPWATER',1,1,'4674',NULL,'2019-11-26 17:00:59','','Wayne Wenzel','148366',348366,1146,64,1,'0','0000-00-00','2019-10-09','2019-11-27 01:47:57','No','No','','Yes'),(83670,'Mr','johnston ','Angela ','','','0401 673 271',NULL,'0407639008','791 Matchbox Road','DEEPWATER',1,1,'4674',NULL,'2019-10-09 09:30:00',NULL,'Wayne Wenzel','148366',348366,1146,64,0,'0',NULL,'2019-10-09','2019-10-08 09:04:19','No','No',NULL,'Yes'),(83669,'Mr','green','catherine ','','','0408 619 773',NULL,'0407639008','791 Matchbox Road','DEEPWATER',1,1,'4674',NULL,'2019-10-09 09:30:00',NULL,'Wayne Wenzel','148366',348366,1146,64,0,'0',NULL,'2019-10-09','2019-10-08 09:04:19','No','No',NULL,'Yes'),(83666,'Mr','Baddage','Belinda ','','','0403647501',NULL,'0403647501','68 Errol Avenue','Paradise Point',1,1,'4216',NULL,'2019-06-06 09:30:00',NULL,'Belinda Babbage','BB96893',1534308,1116,64,0,'0',NULL,'2019-06-07','2019-06-05 09:09:11','No','No',NULL,'Yes'),(83665,'','','Loretta Fletcher','','','0402262210','','','','',0,1,'',NULL,'2019-03-21 09:30:00','','Joanne Trinder','',0,175,64,0,'0',NULL,'2019-03-21','2019-03-19 22:51:17','No','No','','No'),(83664,'','','Sophie Dorney','','','0409886559','','','','',0,1,'',NULL,'2019-03-21 09:30:00','','Joanne Trinder','',0,175,64,0,'0',NULL,'2019-03-21','2019-03-19 22:51:17','No','No','','No'),(83663,'','Cobb','Karen','','','0422900816','','','','',0,1,'',NULL,'2019-03-21 09:30:00','','Joanne Trinder','',0,175,64,0,'0',NULL,'2019-03-21','2019-03-19 22:51:17','No','No','','No'),(83662,'Mr','Shields - Friend','Colleen','','','0409645774','','0741552391','54 Appaloosa Drive','PARKLANDS',1,1,'4670',NULL,'2019-09-25 09:30:59','','Glenda Scotney','142553',342553,1068,64,0,'0','0000-00-00','2019-03-18','2019-03-19 01:53:18','No','No','','Yes'),(83661,'Mr','Jamison - Friend','Jenny','','','0401607447','','0741552391','54 Appaloosa Drive','PARKLANDS',1,1,'4670',NULL,'2019-03-23 09:30:59','asked for a sat cb','Glenda Scotney','142553',342553,1068,64,0,'0','0000-00-00','2019-03-18','2019-03-19 01:45:20','No','No','','Yes'),(83660,'Mr','Binder - Friend','Sherine','','','0408980409','','0741552391','54 Appaloosa Drive','PARKLANDS',1,1,'4670',NULL,'2019-03-22 09:30:59','','Glenda Scotney','142553',342553,1068,64,0,'0','0000-00-00','2019-03-18','2019-03-21 00:40:18','No','No','','Yes'),(83624,'Mr','Adams','Brett','0428848270','','0428848270','','0407434003','14 McTavish Boulevard','Horsham',3,1,'3402',NULL,'2018-02-07 16:00:00','VIC Friend of referee Noel Janetzki of Horsham','Noel Janetzki','164823',364823,573,64,0,'0','0000-00-00','2018-01-18','2018-02-04 04:00:13','No','No','$249 8/12/17 & data','Yes'),(83623,'Mr','Miatke','Ben','0402326174','','0402326174','','0407434003','14 McTavish Boulevard','Horsham',3,1,'3402',NULL,'2018-01-07 09:30:00','VIC Friend of referee Noel Janetzki of Horsham','Noel Janetzki','164823',364823,573,64,0,'0',NULL,'2018-01-18','2018-01-06 02:10:46','No','No','$249 sale 8/12/17','Yes'),(83622,'Mr','Barber','Chris ','0402544313','','0402544313','','0407434003','14 McTavish Boulevard','Horsham',3,1,'3402',NULL,'2018-01-07 09:30:00','VIC  Associate of Shed Happens and friend of referee Noel Janetzki of Horsham','Noel Janetzki','164823',364823,573,64,0,'0',NULL,'2018-01-18','2018-01-06 02:10:46','No','No','$249 sale 8/12/17','Yes');

--
-- Table structure for table `guestssupport`
--

CREATE TABLE `guestssupport` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `AdministratorsID` int(10) NOT NULL,
  `AssignedTo` int(10) NOT NULL DEFAULT '0',
  `DateCreated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `Callback` datetime NOT NULL,
  `Subject` varchar(200) NOT NULL,
  `Message` text NOT NULL,
  `SStatus` enum('New','In Progress','Escalate','Completed') NOT NULL DEFAULT 'New',
  `Priority` enum('Urgent','High','Medium','Low','Not Prioritised') NOT NULL DEFAULT 'Not Prioritised',
  `GuestsID` int(10) NOT NULL,
  `IsDeleted` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `GuestsID` (`GuestsID`),
  KEY `AdministratorsID` (`AdministratorsID`),
  KEY `AssignedTo` (`AssignedTo`)
) ENGINE=MyISAM AUTO_INCREMENT=248606 DEFAULT CHARSET=latin1;

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

INSERT INTO `guestssupport` VALUES (248605,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNRC698198203914 - Q1 Resort & Spa [2 Bedroom Spa]','New','High',1606485,'No'),(248604,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNDH870198205731 - Pavillions on 1770 [3 Bedroom - Stay 3 & Save]','New','High',1602645,'No'),(248603,1212,1212,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNST357198202230 - Turtle Beach Resort [2 Bedroom Family - 3 NIGHT SALE]','New','High',1529435,'No'),(248602,1213,1213,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNPD304188209186 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Penthouse - LGAD]','New','High',1605271,'No'),(248601,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNTS454178204445 - Sea Temple Private Apartments Port Douglas BC [1 Bedroom Swimout - LGAM]','New','High',1606438,'No'),(248600,1213,1213,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNNG459118206725 - Oaks Sunshine Coast Oasis Resort [Executive Family - FLASH SALE]','New','High',1599959,'No'),(248599,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNMD634582034017 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool]','New','High',1590048,'No'),(248598,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNRP618482064746 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Swimout]','New','High',1606232,'No'),(248597,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNGH914382011077 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Penthouse - LGAC]','New','High',1601210,'No'),(248596,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNLC495382029597 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool]','New','High',1606021,'No'),(248595,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNNB294382074492 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool - LGAA]','New','High',1571360,'No'),(248594,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHS423277204400 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Swimout - LGAC]','New','High',1606130,'No'),(248593,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNCZ389227204534 - Niramaya Villas & Spa [1 Bedroom Villa - Stay 7 & Save]','New','High',1600415,'No'),(248592,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4217203704 - Cayman Quays Noosaville [2 Bedroom Apartment]','New','High',1600108,'No'),(248591,656,656,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNKLB11177206070 - Aria Penthouse [Aria Penthouse]','New','High',1603123,'No'),(248590,656,656,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNPS520177206477 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Apartment]','New','High',1519353,'No'),(248589,1168,1168,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNKS704167203581 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','New','High',1605957,'No'),(248588,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNRZ755167201851 - Sea Temple Private Apartments Port Douglas BC [3 Bedroom Penthouse - LGAC]','New','High',1599411,'No'),(248587,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNBG175157208766 - Spicers Clovelly Estate [Estate Suite]','New','High',1599977,'No'),(248586,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNAB249147206609 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Plunge Pool]','New','High',1591540,'No'),(248585,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNDC299137208859 - Sea Temple Private Apartments Port Douglas BC [1 Bedroom Plunge Pool - LGAB]','New','High',1604404,'No'),(248584,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BN89244137208692 - Paradise Resort [Superior Junior Bunkhouse - 4 Night Stay & Save]','New','High',289244,'No'),(248583,1212,1212,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNJW108107208014 - Fitzroy Island Resort [Beach Cabin - FLASH SALE]','New','High',1599156,'No'),(248582,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNAH395972082632 - Q1 Resort & Spa [1 Bedroom Spa Family - SALE]','New','High',1605844,'No'),(248581,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNJC490772042086 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Swimout]','New','High',1600620,'No'),(248580,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNRJ415372014104 - The Sebel Pelican Waters [Classic Room - FLASH SALE]','New','High',1600462,'No'),(248579,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNAS369256209211 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','New','High',1580775,'No'),(248578,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNRO391246205154 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','New','High',1602684,'No'),(248577,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNMM831246203005 - Sofitel Gold Coast Broadbeach [Superior Ocean View for Families - SALE]','New','High',1588080,'No'),(248576,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNNG444226204512 - Q1 Resort & Spa [2 Bedroom Ocean - SALE]','New','High',1605232,'No'),(248575,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNAS715226202056 - Sea Temple Private Apartments Palm Cove BC [2 Bedroom Apartment]','New','High',1530003,'No'),(248574,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4156205262 - Ivory Palms Resort [2 Bedroom Townhouse - 2 Nights]','New','High',1600108,'No'),(248573,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4156205287 - Ivory Palms Resort [3 Bedroom Townhouse - 2 Nights]','New','High',1600108,'No'),(248572,997,997,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNNA217116205245 - Qube Broadbeach [ICON] [2 Bedroom Partial Ocean View - GLG]','New','High',1605323,'No'),(248571,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNCR172106208910 - Qube Broadbeach [ICON] [2 Bedroom Partial Ocean View - GLG]','New','High',1605322,'No'),(248570,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNAK197962057823 - Qube Broadbeach [ICON] [2 Bedroom Partial Ocean View - GLG]','New','High',1593367,'No'),(248569,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNBD950562014656 - Villa 308 BC [3 Bedroom Villa]','New','High',1601083,'No'),(248568,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNCG326265209111 - BreakFree Diamond Beach [2 Bedroom Deluxe - FLASH SALE 7 NIGHTS]','New','High',1600128,'No'),(248567,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNFP367265208975 - BreakFree Diamond Beach [2 Bedroom Deluxe - FLASH SALE 7 NIGHTS]','New','High',1600125,'No'),(248566,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNGS822245209566 - Q1 Resort & Spa [1 Bedroom Spa - SALE]','New','High',1605259,'No'),(248565,889,889,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNJRR53205207950 - Fitzroy Island Resort [Island Suite]','New','High',1599154,'No'),(248564,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNTAH54205202715 - Q1 Resort & Spa [1 Bedroom Spa Family - SALE]','New','High',1601278,'No'),(248563,249,249,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNKN188145203140 - Q1 Resort & Spa [2 Bedroom Spa - SALE]','New','High',1605236,'No'),(248562,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHM609115207220 - Fitzroy Island Resort [Resort Studio - FLASH SALE]','New','High',1599581,'No'),(248561,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHM609115204560 - Fitzroy Island Resort [2 Bedroom Suite - FLASH SALE]','New','High',1599581,'No'),(248560,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNRS272552027901 - Sea Temple Private Apartments Port Douglas BC [1 Bedroom Swimout - LGAL]','New','High',1604883,'No'),(248559,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4284204617 - Ivory Palms Resort [2 Bedroom Townhouse - 2 Nights]','New','High',1600108,'No'),(248558,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4284202157 - Ivory Palms Resort [3 Bedroom Townhouse - 2 Nights]','New','High',1600108,'No'),(248557,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNHDNA4284203807 - Ivory Palms Resort [2 Bedroom Townhouse - 2 Nights]','New','High',1600108,'No'),(248556,467,467,'2020-08-23 09:00:05','2020-08-23 09:00:05','Booking still not confirmed by Property','Booking still not confirmed by Property for BNDF970313201773 - Sea Temple Private Apartments Port Douglas BC [2 Bedroom Swimout]','New','High',1576014,'No');

--
-- Table structure for table `incentivebids`
--

CREATE TABLE `incentivebids` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `created_dt` datetime NOT NULL,
  `bid` decimal(10,2) NOT NULL DEFAULT '0.00',
  `administrator_id` int(10) NOT NULL DEFAULT '0',
  `lot` int(10) NOT NULL DEFAULT '0',
  `is_winning` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=251 DEFAULT CHARSET=latin1;

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

INSERT INTO `incentivebids` VALUES (250,'2017-03-24 16:46:29',3950.00,175,30,'Yes'),(249,'2017-03-24 16:45:46',1900.00,255,30,'No'),(248,'2017-03-24 16:45:40',1550.00,834,30,'No'),(247,'2017-03-24 16:45:20',1450.00,573,30,'No'),(246,'2017-03-24 16:34:40',3549.00,148,29,'Yes'),(245,'2017-03-24 16:30:14',1900.00,255,29,'No'),(244,'2017-03-24 16:30:07',104.00,712,29,'No'),(243,'2017-03-24 16:18:38',1901.00,148,28,'Yes'),(242,'2017-03-24 16:15:56',1900.00,255,28,'No'),(241,'2017-03-24 16:15:54',169.00,700,28,'No'),(240,'2017-03-24 16:15:43',140.00,579,28,'No'),(239,'2017-03-24 16:15:32',105.00,716,28,'No'),(238,'2017-03-24 16:15:29',104.00,712,28,'No'),(237,'2017-03-24 16:15:22',75.00,716,28,'No'),(236,'2017-03-24 16:15:14',70.00,700,28,'No'),(235,'2017-03-24 16:12:29',2000.00,176,27,'Yes'),(234,'2017-03-24 16:00:36',1900.00,255,27,'No'),(233,'2017-03-24 16:00:28',5.00,716,27,'No'),(232,'2017-03-24 16:00:11',1.00,712,27,'No'),(231,'2017-03-24 15:59:49',2000.00,833,26,'Yes'),(230,'2017-03-24 15:54:13',1900.00,255,26,'No'),(229,'2017-03-24 15:46:30',1451.00,833,26,'No'),(228,'2017-03-24 15:45:18',1450.00,573,26,'No'),(227,'2017-03-24 15:45:08',69.00,782,26,'No'),(226,'2017-03-24 15:45:07',1.00,700,26,'No'),(225,'2017-03-24 15:41:35',2000.00,176,25,'Yes'),(224,'2017-03-24 15:39:41',1801.00,833,25,'No'),(223,'2017-03-24 15:36:55',1800.00,176,25,'No'),(222,'2017-03-24 15:34:58',1651.00,737,25,'No'),(221,'2017-03-24 15:32:11',1650.00,176,25,'No'),(220,'2017-03-24 15:30:36',1451.00,737,25,'No'),(219,'2017-03-24 15:30:27',1450.00,573,25,'No'),(218,'2017-03-24 15:30:12',1100.00,700,25,'No'),(217,'2017-03-24 15:26:18',2040.00,120,24,'Yes'),(216,'2017-03-24 15:25:55',1910.00,176,24,'No'),(215,'2017-03-24 15:25:53',1901.00,120,24,'No'),(214,'2017-03-24 15:25:39',1900.00,255,24,'No'),(213,'2017-03-24 15:24:45',1673.00,737,24,'No'),(212,'2017-03-24 15:23:59',1672.00,120,24,'No'),(211,'2017-03-24 15:21:53',1671.00,737,24,'No'),(210,'2017-03-24 15:21:12',1670.00,176,24,'No'),(209,'2017-03-24 15:19:40',1669.00,120,24,'No'),(208,'2017-03-24 15:18:55',1660.00,737,24,'No'),(207,'2017-03-24 15:18:48',1651.00,833,24,'No'),(206,'2017-03-24 15:18:16',1650.00,176,24,'No'),(205,'2017-03-24 15:17:38',1450.00,573,24,'No'),(204,'2017-03-24 15:17:38',104.00,712,24,'No'),(203,'2017-03-24 15:17:25',103.00,77,24,'No'),(202,'2017-03-24 15:17:19',102.00,833,24,'No'),(201,'2017-03-24 15:17:13',101.00,712,24,'No');

--
-- Table structure for table `incentiveoperators`
--

CREATE TABLE `incentiveoperators` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `points` decimal(10,2) NOT NULL,
  `status` varchar(200) NOT NULL,
  `admin_id` int(10) DEFAULT '0',
  `team_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;

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

INSERT INTO `incentiveoperators` VALUES (84,'Dianne Sellars',2.00,'Active',710,7),(79,'Liam Ford',6.00,'Active',700,8),(78,'Suzzanna Wallace',7.00,'Active',638,8),(76,'Robyn Smith',18.00,'Active',702,7),(75,'Danielle Laning',51.00,'Active',591,12),(73,'Tarnia Henderson',59.00,'Active',249,12),(72,'Tammy Frew',63.00,'Active',726,12),(69,'Brooke Gunning',56.00,'Active',16,12),(68,'Caitlin Savage',15.00,'Active',327,12),(67,'Christie Thompson',69.00,'Active',366,12),(66,'Rachel Watson',17.00,'Active',631,11),(65,'Melissa Alaga',10.00,'Active',74,11),(64,'Kamania-Lee Smith',50.00,'Active',579,11),(63,'Daniel Sein',50.00,'Active',148,11),(62,'Susan Dysart',64.00,'Active',255,11),(61,'Tara Gaul',4.00,'Active',656,10),(60,'Logan Cogswell',60.00,'Active',467,10),(59,'Jessica Schofield',15.00,'Active',514,10),(57,'Ian \'Gilmore\' Gilmartin',51.00,'Active',381,10),(56,'Lindsay Garnham',23.00,'Active',120,10),(55,'Ben Debreceny',0.00,'Active',718,9),(53,'Gaye Chapman',7.00,'Active',711,9),(52,'Sarsha-Jane Duncan',4.00,'Active',716,9),(51,'Grant Goding',24.00,'Active',712,9),(50,'Nathan Brown',0.00,'Active',713,9),(49,'Valerie Curry',1.00,'Active',626,8),(48,'Michelle Matthey',24.00,'Active',573,8),(47,'Samantha Lazzarini',10.00,'Active',242,8),(46,'Joy Roden',15.00,'Active',235,8),(45,'Liam Jenkinson',13.00,'Active',178,8),(44,'Martin Roden',50.00,'Active',174,8),(43,'Anna Monsour',62.00,'Active',176,8),(42,'Rebecca Matthew',25.00,'Active',699,7),(41,'Lucy Arnold',47.00,'Active',516,7),(40,'Jan Claire',55.00,'Active',175,7),(38,'Brooke Muker',27.00,'Active',77,7),(37,'Melissa Miers',41.00,'Active',186,7),(36,'',60.00,'Active',0,3),(35,'',180.00,'Exiled',0,1),(34,'Sandi',380.00,'Active',0,4),(33,'Nancy',180.00,'Active',0,5),(32,'Sean',50.00,'Active',0,5),(31,'Joy',130.00,'Active',0,5),(30,'Sam',250.00,'Active',0,5),(29,'Liam',170.00,'Active',0,5),(28,'Marty',230.00,'Active',0,5),(27,'Anna',590.00,'Active',0,5),(26,'Jamie',330.00,'Active',0,4),(25,'Rebecca',150.00,'Active',0,4),(24,'Dom',120.00,'Active',0,4);

--
-- Table structure for table `incentives`
--

CREATE TABLE `incentives` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `modified_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

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

INSERT INTO `incentives` VALUES (5,'LeisureCom Cup 2015','','0000-00-00 00:00:00'),(4,'LeisureCom Cup 2013','','0000-00-00 00:00:00'),(3,'Passport to party','','2016-05-06 08:21:41'),(2,'LeisureCom Cup 2012','','0000-00-00 00:00:00'),(1,'Survivor LeisureCom Island','Are you ready to outwit, outplay and outlast? Do you have what it takes to match wits with other Tribes and become the sole Survivor? Take a step forward and begin the journey of a lifetime to Survivor Island.','2012-10-24 10:08:24');

--
-- Table structure for table `incentiveteams`
--

CREATE TABLE `incentiveteams` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `incentive_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

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

INSERT INTO `incentiveteams` VALUES (12,'Team #6',3),(11,'Team #5',3),(10,'Team #4',3),(9,'Team #3',3),(8,'Team #2',3),(7,'Team #1',3),(5,'Yindigi',1),(4,'Yirrganydji',1),(3,'Kukanunjara',1),(2,'Bundjalung',1),(1,'Yugambeh',1);

--
-- Table structure for table `inclusions`
--

CREATE TABLE `inclusions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `inclusions` VALUES (3,'Package Add on C','lorem'),(2,'UPGRADE TO VIP PACKAGE $499','<ul>\r\n<li>Room Upgrade to Lake View Room^</li>\r\n<li>Bottle of Veuve Clicquot on arrival</li>\r\n<li>$100 Body Sanctum Day Spa Credit</li>\r\n<li>$100 Prime Restaurant Credit</li>\r\n<li>$100 Future Bars Credit</li>\r\n</ul>'),(1,'FLY.STAY.PLAY PACKAGE','<ul>\r\n<li>Pink Flight - Return Airfares</li (From originating city - Melb, Syd, Bris, Gold Coast, Auckland)</li>\r\n<li>Airport Transfers (Queenstown Airport to Host Hotel)</li>\r\n<li>WhiteOUT NZ - Gay Ski Week Essentials Pack</li>\r\n<li>7 Nights Accommodation at Host Hotel - Crowne Plaza Queenstown</li>\r\n<li>Buffet Breakfast Daily</li>\r\n<li>Pink Bus (Not Actually Pink!)</li>\r\n<li>Mountain Transfers (Sun, Mon, Tues, Wed)</li>\r\n<li>VIP Dinner & All Access Events Pass</li>\r\n<li>Free Queenstown Holidays MyQT Card</li>\r\n</ul>');

--
-- Table structure for table `incompletebookings`
--

CREATE TABLE `incompletebookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Title` varchar(10) NOT NULL,
  `FirstName` varchar(50) NOT NULL,
  `LastName` varchar(50) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `StreetAddress` varchar(50) NOT NULL,
  `Suburb` varchar(50) NOT NULL,
  `StatesID` int(11) NOT NULL,
  `CountriesID` int(11) NOT NULL,
  `Postcode` varchar(15) NOT NULL,
  `ContactPhone` varchar(50) NOT NULL,
  `Mobile` varchar(50) NOT NULL,
  `PropertyName` varchar(50) NOT NULL,
  `RoomName` varchar(50) NOT NULL,
  `ArrivalDate` date NOT NULL,
  `NumNights` int(11) NOT NULL,
  `NumRooms` int(11) NOT NULL,
  `PropertiesID` int(11) NOT NULL,
  `RoomsID` int(11) NOT NULL,
  `ExtraAdults` int(5) NOT NULL,
  `ExtraChildren` int(5) NOT NULL,
  `TotalCost` decimal(10,2) NOT NULL,
  `Inclusions` text NOT NULL,
  `IncludedGuests` tinyint(3) NOT NULL,
  `DistributionsID` int(11) NOT NULL,
  `BookingDate` datetime NOT NULL,
  `SessionGUID` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31786 DEFAULT CHARSET=latin1;

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

INSERT INTO `incompletebookings` VALUES (31785,'','Trevor','Zaffiro','trevor@wheredesign.net','','',1,1,'0','0407751515','0407751515','Oaks Gold Coast Calypso Plaza Suites','1 Bedroom Premier - Together Again','2020-10-14',2,1,140,66205,0,0,0.00,'',0,10,'2020-10-12 23:31:23','5f845a92b27de5.24395326');

--
-- Table structure for table `insurance`
--

CREATE TABLE `insurance` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `policy_type` varchar(45) NOT NULL,
  `plan_type` varchar(2) NOT NULL,
  `descr` text NOT NULL,
  `min_coverage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `max_coverage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `min_nights` int(10) NOT NULL DEFAULT '0',
  `max_nights` int(10) NOT NULL DEFAULT '0',
  `sale_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `net_price` decimal(10,2) NOT NULL,
  `change_prices` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `insurance` VALUES (3,'nib Cancellation Policy','Australian cancellation','E3','nib Cancellation Policy up covering up to $3000',1000.00,3000.00,0,200,68.00,34.00,'No'),(2,'nib Cancellation Policy','Australian cancellation','E1','nib Cancellation Policy up covering up to $1000',500.00,1000.00,0,200,51.00,25.50,'No'),(1,'nib Cancellation Policy','Australian cancellation','E1','nib Cancellation Policy up covering up to $500',0.00,500.00,0,200,32.00,16.00,'No');

--
-- Table structure for table `insurancepolicy`
--

CREATE TABLE `insurancepolicy` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `created_dt` datetime NOT NULL,
  `insurance_id` int(10) NOT NULL DEFAULT '0',
  `policy_no` int(5) NOT NULL,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `depart_dt` date NOT NULL,
  `return_dt` date NOT NULL,
  `state_id` int(10) NOT NULL DEFAULT '0',
  `country_id` int(10) NOT NULL DEFAULT '0',
  `total_premium` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_discount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_net` decimal(10,2) NOT NULL DEFAULT '0.00',
  `administrator_id` int(10) NOT NULL DEFAULT '0',
  `distribution_id` int(10) NOT NULL DEFAULT '0',
  `guest_id` int(10) NOT NULL DEFAULT '0',
  `batch_no` varchar(6) NOT NULL,
  `is_cancelled` enum('Yes','No') NOT NULL DEFAULT 'No',
  `cancelled_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9546 DEFAULT CHARSET=latin1;

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

INSERT INTO `insurancepolicy` VALUES (9545,'2019-11-30 11:27:30',3,9533,'Donna','Leembuggen','2020-01-07','2020-01-13',1,1,68.00,0.00,34.00,467,10,1600500,'000910','No','0000-00-00 00:00:00'),(9544,'2019-11-30 11:26:37',3,9532,'Donna','Leembuggen','2020-01-07','2020-01-13',1,1,68.00,0.00,34.00,467,10,1600500,'000910','No','0000-00-00 00:00:00'),(9543,'2019-11-29 12:01:53',3,9531,'Rosemary','Lampe','2020-01-10','2020-01-20',2,1,68.00,0.00,34.00,249,64,306414,'000909','No','0000-00-00 00:00:00'),(9542,'2019-11-28 16:44:26',1,9530,'Margaret','Fox','2020-02-26','2020-02-28',1,1,32.00,0.00,16.00,591,64,1346577,'000695','No','0000-00-00 00:00:00'),(9541,'2019-11-28 13:04:56',3,9529,'Darren','Kane','2020-03-03','2020-03-11',1,1,68.00,0.00,34.00,467,10,1602744,'000908','No','0000-00-00 00:00:00'),(9540,'2019-11-28 09:50:16',3,9528,'Jordan','Hoare','2020-02-01','2020-02-15',1,1,68.00,0.00,34.00,467,10,1602737,'000908','No','0000-00-00 00:00:00'),(9539,'2019-11-27 14:09:56',3,9527,'Gillian','Murray','2020-01-04','2020-01-13',1,1,68.00,0.00,34.00,249,64,366515,'000907','No','0000-00-00 00:00:00'),(9538,'2019-11-26 20:38:46',1,9526,'','','2020-01-12','2020-01-14',1,1,32.00,0.00,16.00,0,10,1602711,'000694','No','0000-00-00 00:00:00'),(9537,'2019-11-26 20:36:46',1,9525,'','','2020-01-08','2020-01-10',1,1,32.00,0.00,16.00,0,10,1602710,'000694','No','0000-00-00 00:00:00'),(9536,'2019-11-26 15:54:03',3,9524,'Hyacinth','Patrick','2019-12-26','2019-12-29',2,1,68.00,0.00,34.00,591,64,1465903,'000906','No','0000-00-00 00:00:00'),(9535,'2019-11-26 15:08:45',2,9523,'Nicole','Viscio','2020-02-25','2020-03-01',1,1,51.00,0.00,25.50,1160,10,1602692,'000906','No','0000-00-00 00:00:00'),(9534,'2019-11-26 13:55:33',1,9522,'June','Henry ','2019-12-10','2019-12-13',1,1,32.00,0.00,16.00,591,64,1525407,'000694','No','0000-00-00 00:00:00'),(9533,'2019-11-26 12:01:28',1,9521,'Janeese','Kenyon','2020-02-02','2020-02-05',1,1,32.00,0.00,16.00,997,10,1599913,'000694','No','0000-00-00 00:00:00'),(9532,'2019-11-26 10:33:41',2,9520,'Linda','Stilgoe','2019-12-01','2019-12-05',2,1,51.00,0.00,25.50,591,64,251547,'000906','No','0000-00-00 00:00:00'),(9531,'2019-11-26 10:29:04',3,9519,'Skye','Whitley','2020-03-08','2020-03-15',1,1,68.00,0.00,34.00,467,10,1602682,'000906','No','0000-00-00 00:00:00'),(9530,'2019-11-26 09:17:15',3,9518,'Lorraine','So','2020-04-05','2020-04-10',1,1,68.00,0.00,34.00,467,10,1602681,'000906','No','0000-00-00 00:00:00'),(9529,'2019-11-25 12:13:56',3,9517,'Diane','Ramsay','2019-11-29','2019-12-01',1,1,68.00,0.00,34.00,591,64,356841,'000905','No','0000-00-00 00:00:00'),(9528,'2019-11-25 11:58:45',3,9516,'Trudy-Lee','Anrep','2019-12-11','2019-12-15',1,1,68.00,0.00,34.00,467,10,1602677,'000905','No','0000-00-00 00:00:00'),(9527,'2019-11-25 10:10:14',3,9515,'Connie','Greco','2020-02-29','2020-03-08',1,1,68.00,0.00,34.00,656,10,1602674,'000905','No','0000-00-00 00:00:00'),(9526,'2019-11-25 09:45:39',3,9514,'Elena','Fahmy','2020-04-19','2020-04-24',1,1,68.00,0.00,34.00,997,10,1602673,'000905','No','0000-00-00 00:00:00'),(9525,'2019-11-25 09:40:42',3,9513,'Michael ','Lillywhite','2020-01-13','2020-01-22',1,1,68.00,0.00,34.00,656,10,1602671,'000905','No','0000-00-00 00:00:00'),(9524,'2019-11-25 09:30:38',3,9512,'Michael','Lillywhite','2020-01-13','2020-01-22',1,1,68.00,0.00,34.00,656,10,1602671,'000905','No','0000-00-00 00:00:00'),(9523,'2019-11-25 09:14:12',3,9511,'Leigh','Corrigan','2020-06-09','2020-06-14',1,1,68.00,0.00,34.00,656,10,1427852,'000905','No','0000-00-00 00:00:00'),(9522,'2019-11-23 10:10:54',3,9510,'Brenda','McDowell','2020-01-17','2020-01-20',1,1,68.00,0.00,34.00,591,64,363491,'000904','No','0000-00-00 00:00:00'),(9521,'2019-11-22 20:07:13',1,9509,'','','2020-02-13','2020-02-16',1,1,32.00,0.00,16.00,0,10,1602665,'000693','No','0000-00-00 00:00:00'),(9520,'2019-11-22 11:48:04',3,9508,'Jemma ','Williams','2020-03-08','2020-03-14',1,1,68.00,0.00,34.00,1159,10,1575362,'000903','No','0000-00-00 00:00:00'),(9519,'2019-11-21 12:40:32',2,9507,'Denise ','Lewis','2020-05-28','2020-06-02',1,1,51.00,0.00,25.50,1159,10,1602654,'','No','0000-00-00 00:00:00'),(9518,'2019-11-21 10:55:00',3,9506,'Troy','Sachs','2020-01-16','2020-01-19',1,1,68.00,0.00,34.00,997,10,1602651,'000902','No','0000-00-00 00:00:00'),(9517,'2019-11-21 10:47:32',3,9505,'Troy','Sachs','2020-01-16','2020-01-19',1,1,68.00,0.00,34.00,997,10,1602651,'000902','No','0000-00-00 00:00:00'),(9516,'2019-11-21 10:38:13',3,9504,'Christian','Brookhouse','2019-12-09','2019-12-15',1,1,68.00,0.00,34.00,467,10,1602650,'000902','No','0000-00-00 00:00:00'),(9515,'2019-11-20 19:48:48',1,9503,'','','2020-04-17','2020-04-20',1,1,32.00,0.00,16.00,0,10,1602648,'000692','No','0000-00-00 00:00:00'),(9514,'2019-11-20 16:16:28',3,9502,'Debra','Newton','2019-12-29','2020-01-05',1,1,68.00,0.00,34.00,467,10,1602646,'000901','No','0000-00-00 00:00:00'),(9513,'2019-11-20 09:24:38',3,9501,'Kara','Stokes','2020-04-20','2020-04-29',1,1,68.00,0.00,34.00,656,10,1601242,'000901','No','0000-00-00 00:00:00'),(9512,'2019-11-19 17:55:05',2,9500,'Ben','Hornsby','2020-01-30','2020-02-05',1,1,51.00,0.00,25.50,997,71,1601284,'000900','No','0000-00-00 00:00:00'),(9511,'2019-11-19 16:54:59',1,9499,'Brendan','Murray','2020-02-26','2020-02-28',2,1,32.00,0.00,16.00,889,64,1352280,'000691','No','0000-00-00 00:00:00'),(9510,'2019-11-19 16:53:54',1,9498,'Rachel','Murray','2020-02-26','2020-02-26',2,1,32.00,0.00,16.00,889,64,1352280,'000691','No','0000-00-00 00:00:00'),(9509,'2019-11-19 16:52:42',1,9497,'Anita','Murray','2020-02-24','2020-02-26',2,1,32.00,0.00,16.00,889,64,1352280,'000691','No','0000-00-00 00:00:00'),(9508,'2019-11-19 16:51:44',1,9496,'Anita','Murray','2020-02-26','2020-02-28',2,1,32.00,0.00,16.00,889,64,1352280,'000691','No','0000-00-00 00:00:00'),(9507,'2019-11-19 16:21:02',3,9495,'Bhadrani','Palihenage','2020-03-30','2020-04-05',1,1,68.00,0.00,34.00,1159,10,1601281,'000900','No','0000-00-00 00:00:00'),(9506,'2019-11-19 16:19:50',1,9494,'','','2020-01-24','2020-01-27',1,1,32.00,0.00,16.00,0,10,1601282,'000691','No','0000-00-00 00:00:00'),(9505,'2019-11-19 14:20:56',2,9493,'','','2020-06-06','2020-06-11',2,1,51.00,0.00,25.50,0,10,1601279,'000900','No','0000-00-00 00:00:00'),(9504,'2019-11-19 13:36:46',2,9492,'Andrea','Berthelsen','2019-12-09','2019-12-14',1,1,51.00,0.00,25.50,656,10,1586397,'000900','No','0000-00-00 00:00:00'),(9503,'2019-11-19 12:06:17',1,9491,'Skye','Hazelton','2019-12-05','2019-12-08',1,1,32.00,0.00,16.00,591,64,355145,'000691','No','0000-00-00 00:00:00'),(9502,'2019-11-19 11:46:11',2,9490,'Marie','Otto','2020-05-04','2020-05-12',1,1,51.00,0.00,25.50,591,64,331946,'000900','No','0000-00-00 00:00:00'),(9501,'2019-11-18 17:27:34',2,9489,'','','2020-02-01','2020-02-06',1,1,51.00,0.00,25.50,0,10,1601265,'000899','No','0000-00-00 00:00:00'),(9500,'2019-11-18 15:50:38',3,9488,'Damiana and Luciano','Pinioti','2020-03-19','2020-03-24',1,1,68.00,0.00,34.00,656,10,1601260,'000899','No','0000-00-00 00:00:00'),(9499,'2019-11-18 11:31:30',2,9487,'Lena','Goreal','2020-01-20','2020-01-25',1,1,51.00,0.00,25.50,656,10,1583354,'000899','No','0000-00-00 00:00:00'),(9498,'2019-11-17 19:53:29',2,9486,'','','2020-01-12','2020-01-17',3,1,51.00,0.00,25.50,0,10,1601251,'000898','No','0000-00-00 00:00:00'),(9497,'2019-11-16 13:12:18',3,9485,'','','2020-04-20','2020-04-25',2,1,68.00,0.00,34.00,0,10,1601240,'000897','No','0000-00-00 00:00:00'),(9496,'2019-11-15 16:57:20',2,9484,'','','2020-04-20','2020-04-25',2,1,51.00,0.00,25.50,0,10,1601232,'000896','No','0000-00-00 00:00:00');

--
-- Table structure for table `insurancepolicyremittance`
--

CREATE TABLE `insurancepolicyremittance` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `PolicyTypeID` int(10) NOT NULL DEFAULT '0',
  `PolicyID` int(11) unsigned DEFAULT NULL,
  `Amount` decimal(10,2) DEFAULT '0.00',
  `PDate` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `PolicyID` (`PolicyID`)
) ENGINE=MyISAM AUTO_INCREMENT=9237 DEFAULT CHARSET=latin1;

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

INSERT INTO `insurancepolicyremittance` VALUES (9236,1,9542,16.00,'2019-12-23'),(9235,3,9541,34.00,'2019-12-23'),(9234,3,9540,34.00,'2019-12-23'),(9233,3,9539,34.00,'2019-12-23'),(9232,1,9538,16.00,'2019-12-23'),(9231,1,9537,16.00,'2019-12-23'),(9230,3,9536,34.00,'2019-12-23'),(9229,2,9535,25.50,'2019-12-23'),(9228,1,9534,16.00,'2019-12-23'),(9227,1,9533,16.00,'2019-12-23'),(9226,2,9532,25.50,'2019-12-23'),(9225,3,9531,34.00,'2019-12-23'),(9224,3,9530,34.00,'2019-12-23'),(9223,3,9529,34.00,'2019-12-23'),(9222,3,9528,34.00,'2019-12-23'),(9221,3,9527,34.00,'2019-12-23'),(9220,3,9526,34.00,'2019-12-23'),(9219,3,9525,34.00,'2019-12-23'),(9218,3,9524,34.00,'2019-12-23'),(9217,3,9523,34.00,'2019-12-23'),(9216,3,9522,34.00,'2019-12-23'),(9215,1,9521,16.00,'2019-12-23'),(9214,3,9520,34.00,'2019-12-23'),(9213,3,9518,34.00,'2019-12-23'),(9212,3,9517,34.00,'2019-12-23'),(9211,3,9516,34.00,'2019-12-23'),(9210,1,9515,16.00,'2019-12-23'),(9209,3,9514,34.00,'2019-12-23'),(9208,3,9513,34.00,'2019-12-23'),(9207,2,9512,25.50,'2019-12-23'),(9206,1,9511,16.00,'2019-12-23'),(9205,1,9510,16.00,'2019-12-23'),(9204,1,9509,16.00,'2019-12-23'),(9203,1,9508,16.00,'2019-12-23'),(9202,3,9507,34.00,'2019-12-23'),(9201,1,9506,16.00,'2019-12-23'),(9200,2,9505,25.50,'2019-12-23'),(9199,2,9504,25.50,'2019-12-23'),(9198,1,9503,16.00,'2019-12-23'),(9197,2,9502,25.50,'2019-12-23'),(9196,2,9501,25.50,'2019-12-23'),(9195,3,9500,34.00,'2019-12-23'),(9194,2,9499,25.50,'2019-12-23'),(9193,2,9498,25.50,'2019-12-23'),(9192,3,9497,34.00,'2019-12-23'),(9191,2,9496,25.50,'2019-12-23'),(9190,1,9495,16.00,'2019-12-23'),(9189,3,9494,34.00,'2019-12-23'),(9188,2,9493,25.50,'2019-12-23'),(9187,3,9492,34.00,'2019-12-23');

--
-- Table structure for table `keywords`
--

CREATE TABLE `keywords` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(200) NOT NULL,
  `google` int(10) NOT NULL,
  `msn` int(10) NOT NULL,
  `yahoo` int(10) NOT NULL,
  `website_id` int(10) NOT NULL DEFAULT '0',
  `date_created` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6524 DEFAULT CHARSET=latin1;

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

INSERT INTO `keywords` VALUES (6516,'0°<µxx¹ãËQ‹|äQÔ\"Ÿ3µÈçß°E-òˆZäC/¢\0ÖQÔ\"4J]¨©R(j‘ëYÔºˆZ\0pQ‹|ØQÔ\"Ÿ3µÈžû¢QÔâæ¿\\Ôâ±åÎ|E-òƒ‰Z€#Q‹|äYÔ\"õ¨¨ÅcôL‘¨Å“ËíœBQ‹|ÞXÔ\"Ÿ8µx`€d^D-Zn¢ù¸LÔ\"–‹ZäÓ¢ù¸±¨E>q',0,0,0,1,'2018-02-01'),(6515,'ûõÉãÓç_g—gSÀ\\ˆƒ#QéòÆ“³]3W…ÇsŽÍö´k›ZÝhÕéœªæ³§Ïò{åcb—&Èh×R„åwu÷È)]ÖD¥£¶dn{UÙë´Û7¯¶³Mæ¡RM„îdt×\'77ež\\Óø¡K.3êé¨¾\rÕaü¼u™1íIÿqŽqØ1 )È®ÆÓ¡ócjx¨ÿû•®ÍNEÜ‚q­QùŽª¥‡\0µc_k•m#öán\\ŠKËl\Zf»±AòÆõx0!',0,0,0,1,'2018-02-01'),(6514,'+s¬Î‡§®J\\(ÊÉÅY·Šo±ò²š¿$#U(·ÙÊtVé+¼¢·ÌG¶x°˜Œ|-‰^øxÜ§úÒ3T!’9À“9ìÒœØ{è„å‰ÿÍ ',0,0,0,1,'2018-02-01'),(6513,'Vs',0,0,0,1,'2018-01-01'),(6512,'Š†_åe+ÕnP4ã|†à—I¢Ë‰VA’/¨Na¼Rãa¼P£‚z~´Uñ#JØÎVÍ¶*‚D+$õüh«âGœê	ÒVE(Ôó£­Šq2¨\'HGýÒQÏÎó£¦uùUNé1ˆó§ÚvÙVP> ¢Ê¬X—måkôäÁX·ÍŸ´žvEP	÷×PMÇM’Â:E¦©m*Ø•šÖ7›³/aÑó(L-›Ò=Âê=\Z',0,0,0,1,'2018-01-01'),(6511,'Î™Fz“3©™Pb/3 tSÙºqyjuiª½E¤-#Œt³0Ò0‚á',0,0,0,1,'2018-01-01'),(6510,'Ì±Ôœÿ¦Õ+Â;gû Õ£Ô\ZžÉÈ#ù ',0,0,0,1,'2018-01-01'),(6509,'&g|\'âé©…G¿„s)·R®]x¦[@ŸCl–;ÜE8<ÛÓ.CI\'\0Æ%Í¡&ù/*aœH>Eoß½;íä<s–¦€+Üzàìò_vn½‘Èb€á”‘à5Ö0ŽÌ‰èˆ{€¿šRê¹æ\rl°Š^ßÄwf:h\rïfeZ^1¸òQ<åÑY\0v…f\'3Ú:©S',0,0,0,1,'2018-08-01'),(6508,'\0\0&C\0\0\0\0\0xl/sharedStrings.xmlœ\\ÝoÛ6°ÿAðKŸ¶¤Û°nEâÂ±:hœdŽÛ¬{cdÆ&\"‹%Åu±?~\'[2?Ä;‰ò’èHÞw?söáÛ:‰^¸Ê„LÏ{o>íE<åB¤ËóÞçùåOô¢',0,0,0,1,'2018-08-01'),(6507,'·',0,0,0,1,'2018-08-01'),(6506,'T1s†¿˜È°÷(Ã_æõkRj@:gŒ‰Dù1ìe^×0)¡€{™ö’À1§',0,0,0,1,'2018-08-01'),(6505,'œxÍÃ‹½>ÓÔH\"',0,0,0,1,'2018-08-01'),(6504,'˜‘Œ”VB\'i	¤qI©cÐ2L0\0•\"¤p‰I	q­gÅ ôø–@ÑšQ²<w†F™Ô1ÁT¬” …QÌˆQÄYÆ Å·BÆFãJ»š@&˜ë‘¤ð‰ñ‰¸Ú€1èp-ð;Âè†©2A`%%Há³Ø%¢Q&ˆB{k„3í„Ñ³hñtü…LWIRxÄŒxD¼#Í­%u0cr„Ñ¸Ø¸&	*IRÄ',6,0,0,1,'2018-08-01'),(6503,'µr·[j%e~£Y¨•J;¨·ý ý +c`å)}d¾\0÷j»¶ÿ\0\0ÿÿ\0PK\0\0\0\0\0!\0–	à‚Ó\0\0ÍU\0\0\0\0\0xl/worksheets/sheet2.xml¬œ[oãº…ßô?~Ol’ºØA’ƒ©LÐEÑË³ÇQcì(µ=7ýï¥¤$æ^\\9“qœ9žŒ¾lYKµ¸Héü·ï›õèk³Ý­Ú‡‹±:ŽGÍÃ²½Y=Ü]Œÿù«“Ùx´',0,0,0,1,'2018-08-01'),(6502,'Î™Fz“3©™Pb/3 tSÙºqyjuiª½E¤-#Œt³0Ò0‚á',0,0,0,1,'2018-08-01'),(6496,'when is schoolies week 2014',6,20,6,5,'2014-05-01'),(6495,'when is schoolies week',7,17,7,5,'2014-05-01'),(6494,'when is schoolies gold coast',9,0,9,5,'2014-05-01'),(6493,'when is schoolies 2014',8,17,8,5,'2014-05-01'),(6492,'when is schoolies',8,8,8,5,'2014-05-01'),(6491,'what is schoolies week',5,18,5,5,'2014-05-01'),(6490,'what is schoolies',10,25,10,5,'2014-05-01'),(6489,'surfers paradise schoolies',6,0,4,5,'2014-05-01'),(6488,'schoolies week queensland',8,0,7,5,'2014-05-01'),(6487,'schoolies week qld',7,0,7,5,'2014-05-01'),(6486,'schoolies week gold coast',5,12,5,5,'2014-05-01'),(6485,'schoolies week dates',6,0,6,5,'2014-05-01'),(6484,'schoolies week australia',0,0,0,5,'2014-05-01'),(6483,'schoolies week 2015',15,7,0,5,'2014-05-01'),(6482,'schoolies week 2014 dates',6,0,6,5,'2014-05-01'),(6481,'schoolies week 2014',5,18,5,5,'2014-05-01'),(6480,'schoolies week',4,13,4,5,'2014-05-01'),(6479,'schoolies website',3,17,3,5,'2014-05-01'),(6478,'schoolies videos',48,7,40,5,'2014-05-01'),(6477,'schoolies surfers paradise',6,0,4,5,'2014-05-01'),(6476,'schoolies statistics',0,0,0,5,'2014-05-01'),(6475,'schoolies queensland',6,0,7,5,'2014-05-01'),(6474,'schoolies playground party',0,0,0,5,'2014-05-01'),(6473,'schoolies photos',17,8,14,5,'2014-05-01'),(6472,'schoolies party',3,14,4,5,'2014-05-01'),(6471,'schoolies parties',4,5,5,5,'2014-05-01'),(6470,'schoolies on the gold coast',8,0,7,5,'2014-05-01'),(6469,'schoolies information',0,16,0,5,'2014-05-01'),(6468,'schoolies hotels gold coast',19,0,17,5,'2014-05-01'),(6467,'schoolies goldcoast',6,4,6,5,'2014-05-01'),(6466,'schoolies gold coast dates',9,0,9,5,'2014-05-01'),(6465,'schoolies gold coast accommodation',14,13,15,5,'2014-05-01'),(6464,'schoolies gold coast 2014',5,13,5,5,'2014-05-01'),(6463,'schoolies gold coast',9,15,6,5,'2014-05-01'),(6462,'schoolies forum',0,0,0,5,'2014-05-01');

--
-- Table structure for table `landingpages`
--

CREATE TABLE `landingpages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(250) NOT NULL,
  `star_rating` varchar(200) NOT NULL,
  `category` varchar(200) NOT NULL,
  `tag` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;

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

INSERT INTO `landingpages` VALUES (95,'kids-club-holiday-houses','','','Holiday Houses'),(94,'5-star-holiday-houses','','','Holiday Houses'),(93,'luxury-holiday-houses','','','Holiday Houses'),(92,'cheap-holiday-houses','','','Holiday Houses'),(91,'island-resorts','','','Island Resort'),(90,'holiday-parks','','','Holiday Park'),(89,'farmstays','','','Farmstay'),(88,'bed-and-breakfasts','','','Bed & Breakfast'),(86,'waterfront-family-holiday-houses','','Holiday Houses',''),(85,'waterfront-family-apartments','','Waterfront',''),(84,'waterfront-family-resorts','','Waterfront',''),(83,'waterfront-family-hotels','','Waterfront',''),(82,'waterfront-family-holidays','','Waterfront',''),(81,'ocean-views-family-holiday-houses','','Ocean Views','Holiday Houses'),(80,'ocean-views-family-apartments','','Ocean Views',''),(79,'ocean-views-family-resorts','','Ocean Views',''),(78,'ocean-views-family-hotels','','Family',''),(77,'ocean-views-family-holidays','','Ocean Views',''),(76,'kids-club-family-holiday-houses','','Kids Club',''),(75,'kids-club-family-apartments','','Kids Club',''),(74,'kids-club-family-resorts','','Kids Club',''),(73,'kids-club-family-hotels','','Kids Club',''),(72,'kids-club-family-holidays','','Kids Club',''),(71,'5-star-family-holiday-houses','','','Holiday Houses'),(70,'5-star-family-apartments','5.0','Family',''),(69,'5-star-family-resorts','5.0','Family',''),(68,'5-star-family-hotels','5.0','Family',''),(67,'5-star-family-holidays','5.0','Family',''),(66,'luxury-family-holiday-houses','','','Holiday Houses'),(65,'luxury-family-apartments','','Family',''),(64,'luxury-family-resorts','','Family',''),(63,'luxury-family-hotels','','Family',''),(62,'luxury-family-holidays','5.0,4.5,4.0','Farmstay',''),(61,'cheap-family-holiday-houses','','Holiday Houses','Holiday Houses'),(60,'cheap-family-apartments','','Family',''),(59,'cheap-family-hotels','','Family',''),(58,'cheap-family-holidays','','Family',''),(57,'discount-family-holiday-houses','','Holiday Houses',''),(56,'discount-family-apartments','','Family',''),(55,'discount-family-resorts','','Family',''),(54,'discount-family-apartments','','Family',''),(53,'discount-family-hotels','','Family',''),(52,'discount-family-holidays','','Family',''),(51,'waterfront-island-resorts','','Island Resort',''),(50,'waterfront-holiday-houses','','Waterfront',''),(49,'waterfront-apartments','','Waterfront',''),(48,'waterfront-resorts','','Waterfront',''),(47,'waterfront-hotels','','Waterfront',''),(46,'waterfront-holidays','','Waterfront',''),(45,'romantic-island-resorts','','','Island Resort');

--
-- Table structure for table `leadscomments`
--

CREATE TABLE `leadscomments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `DateCreated` datetime NOT NULL,
  `Comment` text NOT NULL,
  `AdministratorsID` int(10) unsigned NOT NULL,
  `DateCallback` datetime NOT NULL,
  `LeadID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=76853 DEFAULT CHARSET=latin1;

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

INSERT INTO `leadscomments` VALUES (76852,'2019-11-06 10:08:37','Field [Comments] changed from: 12/11/18 asked if I can call her back 13-11-18 when she has time to talk<br />\r\n13/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) voicemail<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n31/10/2019 - Has 3 kids, the youngest being 5months. Cb Tuesday 10:00 when gets paid. Would like to sign up with Mastercard.<br />\r\n06/11/2019 - Spoke to Krystal briefly before being cut off. Tried calling again, no answer. to 12/11/18 asked if I can call her back 13-11-18 when she has time to talk<br />\r\n13/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) voicemail<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n31/10/2019 - Has 3 kids, the youngest being 5months. Cb Tuesday 10:00 when gets paid. Would like to sign up with Mastercard.<br />\r\n06/11/2019 - Spoke to Krystal briefly before being cut off. Tried calling again, no answer x2.<br />',1154,'0000-00-00 00:00:00',507469),(76851,'2019-11-06 09:49:36','Field [Comments] changed from: 12/11/18 asked if I can call her back 13-11-18 when she has time to talk<br />\r\n13/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) voicemail<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n31/10/2019 - Has 3 kids, the youngest being 5months. Cb Tuesday 10:00 when gets paid. Would like to sign up with Mastercard. to 12/11/18 asked if I can call her back 13-11-18 when she has time to talk<br />\r\n13/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) voicemail<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n31/10/2019 - Has 3 kids, the youngest being 5months. Cb Tuesday 10:00 when gets paid. Would like to sign up with Mastercard.<br />\r\n06/11/2019 - Spoke to Krystal briefly before being cut off. Tried calling again, no answer.<br />',1154,'0000-00-00 00:00:00',507469),(76850,'2019-11-06 09:47:30','Field [Comments] changed from: 13/11/18&nbsp; messagebank<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n06/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n01/11/2019 - requested cb next week. Cb 05/11/2019. Tried calling again upon orders but no answer. to 13/11/18&nbsp; messagebank<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n06/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n01/11/2019 - requested cb next week. Cb 05/11/2019. Tried calling again upon orders but no answer.<br />\r\n06/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',507357),(76849,'2019-11-04 13:34:32','Field [Comments] changed from: 16/07/18 - no ans<br />\r\n08/11/2018 - no ans<br />\r\n12/11/18 - answering machine<br />\r\n13/11/18 - wants a call back at 5pm, Jan is going to call him back this afternoon for me&nbsp;<br />\r\n14/11/18 didn&#39;t answer when Jan called&nbsp;wants a call back at 5pm&nbsp;<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n07/08/19 - no answer<br />\r\n1/11/19 - wants cb 1-2pm monday to 16/07/18 - no ans<br />\r\n08/11/2018 - no ans<br />\r\n12/11/18 - answering machine<br />\r\n13/11/18 - wants a call back at 5pm, Jan is going to call him back this afternoon for me&nbsp;<br />\r\n14/11/18 didn&#39;t answer when Jan called&nbsp;wants a call back at 5pm&nbsp;<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n07/08/19 - no answer<br />\r\n1/11/19 - wants cb 1-2pm monday<br />\r\n4/11/19 - na x 2<br />',1148,'0000-00-00 00:00:00',507413),(76848,'2019-11-04 11:53:20','Field [Comments] changed from: not interested<br />\r\n08/11/2018 - not interested<br />\r\n1/08/19 - messagebank<br />\r\n2/08/19 - not interested<br />\r\n1/11/19 - would like me to cb monday due to work to not interested<br />\r\n08/11/2018 - not interested<br />\r\n1/08/19 - messagebank<br />\r\n2/08/19 - not interested<br />\r\n1/11/19 - would like me to cb monday due to work<br />\r\n4/11/19 - foreign family, passing the phone between eachother trying to mess with me. dnc<br />',1148,'0000-00-00 00:00:00',507392),(76847,'2019-11-01 14:40:48','Field [Comments] changed from: busy<br />\r\n08/11/2018 - message bank<br />\r\n12/11/18 - no ans x2<br />\r\n13/11/18 - no ans - straight to am<br />\r\n31/07/19 incoming call restrictions<br />\r\n2/08/19 - incoming call restrictions<br />\r\n31/10/2019 - no answer to busy<br />\r\n08/11/2018 - message bank<br />\r\n12/11/18 - no ans x2<br />\r\n13/11/18 - no ans - straight to am<br />\r\n31/07/19 incoming call restrictions<br />\r\n2/08/19 - incoming call restrictions<br />\r\n31/10/2019 - no answer<br />\r\n01/11/2019 - hung up during pitch<br />',1154,'0000-00-00 00:00:00',507568),(76846,'2019-11-01 14:06:05','Field [Comments] changed from: couldnt talk<br />\r\n08/11/2018 - no ans<br />\r\n08/11/2018 - message bank<br />\r\n12/11/18 - no ans - straight to am x2<br />\r\n13/11/18 - no ans<br />\r\n31/07/19 hung up mid way<br />\r\n31/10/2019 - no answer to couldnt talk<br />\r\n08/11/2018 - no ans<br />\r\n08/11/2018 - message bank<br />\r\n12/11/18 - no ans - straight to am x2<br />\r\n13/11/18 - no ans<br />\r\n31/07/19 hung up mid way<br />\r\n31/10/2019 - no answer<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',507569),(76845,'2019-11-01 14:05:32','Field [Comments] changed from: 12/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) messagebank<br />\r\n31/07/19 answering machine<br />\r\n2/08/19 - answerijng machine\\<br />\r\n05/08/19 - answered but told his friends to be quiet so we couldnt hear anyone.....<br />\r\n31/10/2019 - answering machine to 12/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) messagebank<br />\r\n31/07/19 answering machine<br />\r\n2/08/19 - answerijng machine\\<br />\r\n05/08/19 - answered but told his friends to be quiet so we couldnt hear anyone.....<br />\r\n31/10/2019 - answering machine<br />\r\n01/11/2019 - not available<br />',1154,'0000-00-00 00:00:00',507570),(76844,'2019-11-01 14:04:39','Field [Comments] changed from: am<br />\r\nNumber does not work<br />\r\n12/11/18 - no ans x2<br />\r\n13/11/18 - no ans<br />\r\n31/07/19 hung up mid way through pitch<br />\r\n31/10/2019 - answering machine to am<br />\r\nNumber does not work<br />\r\n12/11/18 - no ans x2<br />\r\n13/11/18 - no ans<br />\r\n31/07/19 hung up mid way through pitch<br />\r\n31/10/2019 - answering machine<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',507571),(76843,'2019-11-01 14:03:50','Field [Comments] changed from: am<br />\r\nA.M 11:33am 08/11/18<br />\r\nA.M 8:40am 09/11/18<br />\r\n31/07/19 answering machine<br />\r\n2/08/19 - answering machine<br />\r\n05/08/19 - no answer<br />\r\n07/08/19 - answering machine<br />\r\n31/10/2019 - no answer to am<br />\r\nA.M 11:33am 08/11/18<br />\r\nA.M 8:40am 09/11/18<br />\r\n31/07/19 answering machine<br />\r\n2/08/19 - answering machine<br />\r\n05/08/19 - no answer<br />\r\n07/08/19 - answering machine<br />\r\n31/10/2019 - no answer<br />\r\n01/11/2019 - voicemail<br />',1154,'0000-00-00 00:00:00',507572),(76842,'2019-11-01 14:01:06','Field [Comments] changed from: 13/11/18&nbsp; messagebank<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n06/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n01/11/2019 - requested cb next week. Cb 05/11/2019. to 13/11/18&nbsp; messagebank<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n06/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n01/11/2019 - requested cb next week. Cb 05/11/2019. Tried calling again upon orders but no answer.<br />',1154,'0000-00-00 00:00:00',507357),(76841,'2019-11-01 13:58:16','Field [Comments] changed from: 12/11/18 answering machine<br />\r\n14/11/18 call another time as she is working<br />\r\n15/11/18 voicemail<br />\r\n1/08/19 - working not interested<br />\r\n01/11/2019 - requested cb at 12:30 during lunch break. Tried again at 12:30, no answer.<br />\r\n to 12/11/18 answering machine<br />\r\n14/11/18 call another time as she is working<br />\r\n15/11/18 voicemail<br />\r\n1/08/19 - working not interested<br />\r\n01/11/2019 - requested cb at 12:30 during lunch break. Tried again at 12:30, no answer x2.<br />\r\n<br />',1154,'0000-00-00 00:00:00',507425),(76840,'2019-11-01 13:56:55','Field [Comments] changed from: 9/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n1/08/19 - not interested<br />\r\n01/11/2019 - sounds interested, requested cb in ~1 hour. Called back, no answer. Tried again at 12:30, no answer.<br />\r\n to 9/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n1/08/19 - not interested<br />\r\n01/11/2019 - sounds interested, requested cb in ~1 hour. Called back, no answer. Tried again at 12:30, no answer x2.<br />\r\n<br />',1154,'0000-00-00 00:00:00',507154),(76839,'2019-11-01 13:54:34','Field [Comments] changed from: Pregnant / Will not be not travelling / 10:33am 09/11/18 to Pregnant / Will not be not travelling / 10:33am 09/11/18<br />\r\n01/11/2019 - line busy<br />',1154,'0000-00-00 00:00:00',506962),(76838,'2019-11-01 13:54:05','Field [Comments] changed from: Requested a CB at 3pm 09/11/18 to Requested a CB at 3pm 09/11/18<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506963),(76837,'2019-11-01 13:53:23','Field [Comments] changed from: 26/08/2019 - Straight to voicemail to 26/08/2019 - Straight to voicemail<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506964),(76836,'2019-11-01 13:51:47','Field [Comments] changed to 01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506965),(76835,'2019-11-01 13:51:05','Field [Comments] changed from: 9/11/18 - no ans - straight to voice mail x2<br />\r\n10/11/18 - no ans - straight to am x2<br />\r\n31/7/19 spoke to Ami just got back from holidays in Uruguay to 9/11/18 - no ans - straight to voice mail x2<br />\r\n10/11/18 - no ans - straight to am x2<br />\r\n31/7/19 spoke to Ami just got back from holidays in Uruguay<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506966),(76834,'2019-11-01 13:50:28','Field [Comments] changed from: 9/11/18 - no ans<br />\r\n9/11/18 - cb next year<br />\r\n01/11/2019 -&nbsp; to 9/11/18 - no ans<br />\r\n9/11/18 - cb next year<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506967),(76833,'2019-11-01 13:50:19','Field [LastName] changed from:  Panetta to Panetta<br />Field [Comments] changed from: 9/11/18 - no ans<br />\r\n9/11/18 - cb next year to 9/11/18 - no ans<br />\r\n9/11/18 - cb next year<br />\r\n01/11/2019 -&nbsp;<br />',1154,'0000-00-00 00:00:00',506967),(76832,'2019-11-01 13:49:50','Field [Comments] changed from: 9/11/18 - no ans x2<br />\r\n10/11/18 - not interested to 9/11/18 - no ans x2<br />\r\n10/11/18 - not interested<br />\r\n01/11/2019 - not available<br />',1154,'0000-00-00 00:00:00',506968),(76831,'2019-11-01 13:49:25','Field [Comments] changed from: 9/11/18 - no ans x2 - straight to message bank<br />\r\n10/11/18 - no ans - straight to am to 9/11/18 - no ans x2 - straight to message bank<br />\r\n10/11/18 - no ans - straight to am<br />\r\n01/11/2019 - number is switched off / unavailable<br />',1154,'0000-00-00 00:00:00',506969),(76830,'2019-11-01 13:48:52','Field [Comments] changed from: 9/11/18 - no ans x2<br />\r\n10/11/18 - not interested - loss in the family to 9/11/18 - no ans x2<br />\r\n10/11/18 - not interested - loss in the family<br />\r\n01/11/2019 - not available<br />',1154,'0000-00-00 00:00:00',506970),(76829,'2019-11-01 13:48:12','Field [Comments] changed from: 9/11/18 - no ans<br />\r\n9/11/18 - not interested to 9/11/18 - no ans<br />\r\n9/11/18 - not interested<br />\r\n01/11/2019 - hung up on intro. NI.<br />',1154,'0000-00-00 00:00:00',506971),(76828,'2019-11-01 13:47:07','Field [Comments] changed from: 26/08/2019 Mahmoud is no longer insterested to 26/08/2019 Mahmoud is no longer insterested<br />\r\n01/11/2019 - possibly interested, needs to speak to wife and will check out website. Cb next week 2:00pm.<br />',1154,'0000-00-00 00:00:00',506972),(76827,'2019-11-01 13:39:42','Field [Comments] changed from: 9/11/18 - no ans<br />\r\n31/7/19 - spoke to Sheree hung up to 9/11/18 - no ans<br />\r\n31/7/19 - spoke to Sheree hung up<br />\r\n01/11/2019 - straight to voicemail<br />',1154,'0000-00-00 00:00:00',506973),(76826,'2019-11-01 13:39:14','Field [Comments] changed from: 9/11/18 - no ans x2<br />\r\n10/11/18 - no ans x2<br />\r\n12/11/18 - no ans<br />\r\n12/11/18 - send info. cb<br />\r\n31/07/19&nbsp; - spoke with Melissa, needs to speak with husband re: $99 membership deal asked to call back 1730 when husband is home.<br />\r\n26/08/2019 - No answer straight to voice mail&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; &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; &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; &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; &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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; to 9/11/18 - no ans x2<br />\r\n10/11/18 - no ans x2<br />\r\n12/11/18 - no ans<br />\r\n12/11/18 - send info. cb<br />\r\n31/07/19&nbsp; - spoke with Melissa, needs to speak with husband re: $99 membership deal asked to call back 1730 when husband is home.<br />\r\n26/08/2019 - No answer straight to voice mail<br />\r\n01/11/2019 - voicemail<br />',1154,'0000-00-00 00:00:00',506974),(76825,'2019-11-01 13:38:07','Field [Comments] changed from: 26/08/2019 - Call back tomorrow 5pm to 26/08/2019 - Call back tomorrow 5pm<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506975),(76824,'2019-11-01 13:37:27','Field [Comments] changed from: 9/11/18 - d/c<br />\r\n31/7/19 not in service to 9/11/18 - d/c<br />\r\n31/7/19 not in service<br />\r\n01/11/2019 - not in service<br />',1154,'0000-00-00 00:00:00',506976),(76823,'2019-11-01 13:36:43','Field [Comments] changed from: Hung Up 1:51pm on 08/11/18<br />\r\n01/11/2019 - call cut out / hung up. Tried again, no answer. to Hung Up 1:51pm on 08/11/18<br />\r\n01/11/2019 - call cut out / hung up. Tried again, no answer x2.<br />',1154,'0000-00-00 00:00:00',507040),(76822,'2019-11-01 13:36:03','Field [Comments] changed from: A.M 1:54pm on 08/11/18<br />\r\nA.M 10:25am 09/11/18 to A.M 1:54pm on 08/11/18<br />\r\nA.M 10:25am 09/11/18<br />\r\n01/11/2019 - voicemail<br />',1154,'0000-00-00 00:00:00',506977),(76821,'2019-11-01 13:35:26','Field [Comments] changed from: A.M 1:53pm 08/11/08<br />\r\nA.M 10:23am 09/11/18<br />\r\nPM 3:34pm 31/7/19 to A.M 1:53pm 08/11/08<br />\r\nA.M 10:23am 09/11/18<br />\r\nPM 3:34pm 31/7/19<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',506978),(76820,'2019-11-01 13:34:32','Field [Comments] changed from: Hung Up 1:51pm on 08/11/18<br />\r\n to Hung Up 1:51pm on 08/11/18<br />\r\n01/11/2019 - call cut out / hung up. Tried again, no answer.<br />',1154,'0000-00-00 00:00:00',507040),(76819,'2019-11-01 13:29:34','Field [Comments] changed from: CB at 5pm 08/11/18<br />\r\n1/8/19 - voicemail<br />\r\n2/08/19 - call back befor 2pm needs to talk to hubby<br />\r\n2/08/19 - no answer on call back, will try again shortly<br />\r\n2/08/19 - no answer x2<br />\r\n05/08/19 - no answer x2<br />\r\n06/08/19 - no answer<br />\r\n08/08/19 - voicemail to CB at 5pm 08/11/18<br />\r\n1/8/19 - voicemail<br />\r\n2/08/19 - call back befor 2pm needs to talk to hubby<br />\r\n2/08/19 - no answer on call back, will try again shortly<br />\r\n2/08/19 - no answer x2<br />\r\n05/08/19 - no answer x2<br />\r\n06/08/19 - no answer<br />\r\n08/08/19 - voicemail<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',507042),(76818,'2019-11-01 13:28:54','Field [Comments] changed from: AM 1:36pm on 08/11/18<br />\r\nNot Interested 10:16am 09/11/18<br />\r\n1/8/19 - not interested to AM 1:36pm on 08/11/18<br />\r\nNot Interested 10:16am 09/11/18<br />\r\n1/8/19 - not interested<br />\r\n01/11/2019 - NI<br />',1154,'0000-00-00 00:00:00',507043),(76817,'2019-11-01 13:27:27','Field [Comments] changed from: A.M 1:32pm on 08/11/18<br />\r\nHung Up 10:05am 09/11/18<br />\r\n1/8/19 - voicemail<br />\r\n2/08/19 - hung up during pitch to A.M 1:32pm on 08/11/18<br />\r\nHung Up 10:05am 09/11/18<br />\r\n1/8/19 - voicemail<br />\r\n2/08/19 - hung up during pitch<br />\r\n01/11/2019 - voicemail<br />',1154,'0000-00-00 00:00:00',507045),(76816,'2019-11-01 13:26:56','Field [Mobile] changed to 0416675283<br />Field [Comments] changed from: A.M 1:30pm on 08/11/18<br />\r\nA.M 10:04am 08/11/18<br />\r\n1/8/19 - no answer<br />\r\n2/08/19 - told to call 0416675283 as thats his number. did not answer<br />\r\n06/08/19 - call wouldnt connect<br />\r\n08/08/19 - call wouldnt connect<br />\r\n<br />\r\n to A.M 1:30pm on 08/11/18<br />\r\nA.M 10:04am 08/11/18<br />\r\n1/8/19 - no answer<br />\r\n2/08/19 - told to call 0416675283 as thats his number. did not answer<br />\r\n06/08/19 - call wouldnt connect<br />\r\n08/08/19 - call wouldnt connect<br />\r\n01/11/2019 - &quot;your call couldn&#39;t be connected, please check the number and try again&quot;.<br />\r\n<br />\r\n<br />',1154,'0000-00-00 00:00:00',507046),(76815,'2019-11-01 13:26:51','Field [Comments] changed from: CB to inform her<br />\r\nA.M 1:17pm&nbsp; 08/11/18<br />\r\nA.M 8:52am 09/11/18<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n08/08/19 - interested, just didnt have time to talk<br />\r\n31/10/19 - wants a call back soon to CB to inform her<br />\r\nA.M 1:17pm&nbsp; 08/11/18<br />\r\nA.M 8:52am 09/11/18<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n08/08/19 - interested, just didnt have time to talk<br />\r\n31/10/19 - wants a call back soon<br />\r\n1/11/19 - spoke to husband and not interested<br />',1148,'0000-00-00 00:00:00',507384),(76814,'2019-11-01 13:25:39','Field [Comments] changed from: A.M 1:23pm 08/11/18&nbsp;<br />\r\nA.M 9:56am 09/11/18<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - not interested to A.M 1:23pm 08/11/18&nbsp;<br />\r\nA.M 9:56am 09/11/18<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - not interested<br />\r\n01/11/2019 - no answer<br />',1154,'0000-00-00 00:00:00',507052),(76813,'2019-11-01 13:24:12','Field [Comments] changed from: A.M 1:22pm on 08/11/18<br />\r\nBusy at work / 9:55am 09/11/18 CB after hours<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n05/08/19 - voicemail<br />\r\n06/08/19 - voicemail<br />\r\n08/08/19 - messagebank to A.M 1:22pm on 08/11/18<br />\r\nBusy at work / 9:55am 09/11/18 CB after hours<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n05/08/19 - voicemail<br />\r\n06/08/19 - voicemail<br />\r\n08/08/19 - messagebank<br />\r\n01/11/2019 - requested cb 8:00am. Try again Monday 04/11.<br />',1154,'0000-00-00 00:00:00',507053),(76812,'2019-11-01 13:23:52','Field [Comments] changed from: 13/11/18 voicemail<br />\r\n14/11/18 messagebank<br />\r\n15/11/18 call bank<br />\r\n31/07/19 requested call back 1:30pm<br />\r\n1/08/19 - not interested<br />\r\n31/10/19 - call back tomorrow<br />\r\n1/11/19 - getting phone screen fixed, cb 1pm to 13/11/18 voicemail<br />\r\n14/11/18 messagebank<br />\r\n15/11/18 call bank<br />\r\n31/07/19 requested call back 1:30pm<br />\r\n1/08/19 - not interested<br />\r\n31/10/19 - call back tomorrow<br />\r\n1/11/19 - getting phone screen fixed, cb 1pm<br />\r\n1/11/19 - no answer on cbx3<br />',1148,'0000-00-00 00:00:00',507368),(76811,'2019-11-01 13:13:05','Field [Comments] changed from: 13/11/18 very interested &amp; wants a call back 14/11/18<br />\r\n1/08/19 - voicemail<br />\r\n2/08/19 - not interested<br />\r\n01/11/2019 - requested cb 12:45pm today to 13/11/18 very interested &amp; wants a call back 14/11/18<br />\r\n1/08/19 - voicemail<br />\r\n2/08/19 - not interested<br />\r\n01/11/2019 - requested cb 12:45pm today. Called back, said he has membership with Accor group, not sure if we what we offer is better. Gave him some examples and website to check out. CB 2 weeks.<br />',1154,'0000-00-00 00:00:00',507352),(76810,'2019-11-01 13:08:46','Field [Comments] changed from: call rejected<br />\r\n8/11/18 not interested<br />\r\n1/08/19 - not interested<br />\r\n31/10/19 - no answer to call rejected<br />\r\n8/11/18 not interested<br />\r\n1/08/19 - not interested<br />\r\n31/10/19 - no answer<br />\r\n1/11/19 - not interested<br />',1148,'0000-00-00 00:00:00',507489),(76809,'2019-11-01 13:07:19','Field [Comments] changed from: 2/08/19 - not interested<br />\r\n31/10/19 - no answer to 2/08/19 - not interested<br />\r\n31/10/19 - no answer<br />\r\n1/11/19 - no a<br />',1148,'0000-00-00 00:00:00',507483),(76808,'2019-11-01 13:04:59','Field [Comments] changed from: 8/11/18 voicemail<br />\r\n14/11/18 waste of time calling. she didn&#39;t even bother listening<br />\r\n2/08/19 - not interested<br />\r\n31/10/19 - no answer to 8/11/18 voicemail<br />\r\n14/11/18 waste of time calling. she didn&#39;t even bother listening<br />\r\n2/08/19 - not interested<br />\r\n31/10/19 - no answer<br />\r\n1/11/19 - no answer<br />',1148,'0000-00-00 00:00:00',507479),(76807,'2019-11-01 13:03:49','Field [Comments] changed from: 8-11-18 very interested but not until beginning of 2019<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 -&nbsp;call back at 1pm<br />\r\n2/08/19 - no answer on call back x3<br />\r\n31/10/19 - no answer to 8-11-18 very interested but not until beginning of 2019<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 -&nbsp;call back at 1pm<br />\r\n2/08/19 - no answer on call back x3<br />\r\n31/10/19 - no answer<br />\r\n1/11/19 - no a<br />',1148,'0000-00-00 00:00:00',507477),(76806,'2019-11-01 13:02:38','Field [Comments] changed from: 13/7/18 - no ans<br />\r\n16/07/18 - no ans<br />\r\n8/11/18 voicemail<br />\r\n9/11/18 voicemail<br />\r\n12/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) voicemail<br />\r\n1/08/19 - at work, not interested<br />\r\n31/10/19 - no answer to 13/7/18 - no ans<br />\r\n16/07/18 - no ans<br />\r\n8/11/18 voicemail<br />\r\n9/11/18 voicemail<br />\r\n12/11/18 voicemail<br />\r\n14/11/18 voicemail<br />\r\n15/11/18 (am) voicemail<br />\r\n1/08/19 - at work, not interested<br />\r\n31/10/19 - no answer<br />\r\n1/11/19 - no a<br />',1148,'0000-00-00 00:00:00',507476),(76805,'2019-11-01 13:01:20','Field [Comments] changed from: am<br />\r\n08/11/2018 - line busy<br />\r\n12/11/18 - message bank<br />\r\n14/11/18 voicemail<br />\r\n1/08/19 - messagebank<br />\r\n2/08/19 - messagebank<br />\r\n07/08/19 - messagebank<br />\r\n08/08/19 - messagebank<br />\r\n1/11/19 - cb in 30 minutes to am<br />\r\n08/11/2018 - line busy<br />\r\n12/11/18 - message bank<br />\r\n14/11/18 voicemail<br />\r\n1/08/19 - messagebank<br />\r\n2/08/19 - messagebank<br />\r\n07/08/19 - messagebank<br />\r\n08/08/19 - messagebank<br />\r\n1/11/19 - cb in 30 minutes<br />\r\n1/11/19 - didnt answer cb<br />',1148,'0000-00-00 00:00:00',507395),(76804,'2019-11-01 12:56:56','Field [Comments] changed from: 12/11/18 voicemail<br />\r\n13/11/18 voicemail<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - not at the phone to 12/11/18 voicemail<br />\r\n13/11/18 voicemail<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - not at the phone<br />\r\n1/11/19 - no a<br />',1148,'0000-00-00 00:00:00',507418),(76803,'2019-11-01 12:55:58','Field [Comments] changed from: offered99<br />\r\n12/11/18 answering machine<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n07/08/19 - no answer<br />\r\n08/08/19 - no answer to offered99<br />\r\n12/11/18 answering machine<br />\r\n1/08/19 - no answer<br />\r\n2/08/19 - no answer<br />\r\n07/08/19 - no answer<br />\r\n08/08/19 - no answer<br />\r\n1/11/19 - no a<br />',1148,'0000-00-00 00:00:00',507417);

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `action` text NOT NULL,
  `administrator_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `administrator_id` (`administrator_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3507742 DEFAULT CHARSET=latin1;

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

INSERT INTO `log` VALUES (3507741,'2020-10-29 22:07:22','Logged into ODMS',1217),(3507740,'2020-10-06 22:52:31','Logged into ODMS',0),(3507739,'2020-09-30 00:00:43','Logged into ODMS',4),(3507738,'2020-09-29 23:57:58','Logged into ODMS',0),(3507737,'2020-09-29 23:55:44','Logged into ODMS',0),(3507736,'2020-09-17 04:46:02','Administrator Password Updated: Philip Scott',1141),(3507735,'2020-09-17 04:45:41','Logged into ODMS',1141),(3507734,'2020-09-17 04:16:29','Logged into ODMS',1199),(3507733,'2020-09-03 11:31:31','Logged into ODMS',1199),(3507732,'2020-09-03 10:55:27','Logged into ODMS',1199),(3507731,'2020-09-03 10:53:23','Logged into ODMS',4),(3507730,'2020-08-23 17:58:20','Exported Enquiries<br>\n		Operator: <br>\n		Search Type: e.`FirstName`<br>\n		Search Keyword: <br>\n		Enquiry Status: Array<br>\n		Enquiry Type: <br>\n		Distributions: <br>\n		From Date: 01/08/2020 00:00:00<br>\n		To Date: 23/08/2020 17:57:59',1204),(3507729,'2020-08-23 17:44:35','Exported Enquiries<br>\n		Operator: <br>\n		Search Type: e.`PropertyName`<br>\n		Search Keyword: Oaks Sunshine Coast Oasis Resort<br>\n		Enquiry Status: Array<br>\n		Enquiry Type: <br>\n		Distributions: Discover Queensland,DQ - Portals,DQ Online Chat,Discover Queensland Deals<br>\n		From Date: 19/08/2020 00:00:00<br>\n		To Date: 23/08/2020 23:59:59',1204),(3507728,'2020-08-23 17:03:47','Exported Enquiries<br>\n		Operator: <br>\n		Search Type: e.`FirstName`<br>\n		Search Keyword: <br>\n		Enquiry Status: Array<br>\n		Enquiry Type: <br>\n		Distributions: Discover Queensland,Champions Youth Cup,Group Holidays,Queensland Holiday Sale,The Ambassador Card Website,Discover Western Australia,Discover NSW,Hello Gold Coast,Surf Breaks,The West Island,Gold Coast Beach Soccer Championships,Discover Victoria,Surf Breaks - Retail,Discover South Australia,Hightide Holidays,DQ - Portals,Discover Northern Territory,Discover Tasmania,Discover ACT,DQ Online Chat,Resort Vouchers,Global Explorer,Hot Offer Escapes - AGL,eTourism Holidays,Discover Queensland Deals,EAE,Presidential Card Holidays,CTrip,Hello Gold Coast - Group,LeisureCom Staff and Family,DNSW Online Chat,TwoforOne Hotel,nib Travel Club,Travelzoo,Gay Ski Week,Hightide Holidays GEX,LeisureCom Staff and Family - GEX,UBookDirect,Blues on Broadbeach,Country Music Festival,Travel Megastore,Showcase Dance,All Star Cheer and Dance,Entertainment Travel,Entertainment TRIAL,Hot Offer Escapes - Union Shopper,Discover Club,DQ Trade Distribution<br>\n		From Date: 16/08/2020 00:00:00<br>\n		To Date: 22/08/2020 23:59:59',1204),(3507727,'2020-08-23 17:02:25','Exported Enquiries<br>\n		Operator: <br>\n		Search Type: e.`FirstName`<br>\n		Search Keyword: <br>\n		Enquiry Status: Array<br>\n		Enquiry Type: <br>\n		Distributions: Hightide Holidays,Hightide Holidays GEX<br>\n		From Date: 16/08/2020 00:00:00<br>\n		To Date: 22/08/2020 23:59:59',1204),(3507726,'2020-08-23 16:59:23','Exported Enquiries<br>\n		Operator: <br>\n		Search Type: e.`FirstName`<br>\n		Search Keyword: <br>\n		Enquiry Status: Array<br>\n		Enquiry Type: <br>\n		Distributions: Discover Queensland,DQ - Portals,DQ Online Chat,Discover Queensland Deals<br>\n		From Date: 16/08/2020 00:00:00<br>\n		To Date: 22/08/2020 23:59:59',1204),(3507725,'2020-08-23 16:54:18','Logged into ODMS',1204),(3507724,'2020-08-22 15:47:14','Opportunity Updated: ',1203),(3507723,'2020-08-22 15:41:30','Opportunity Created: ',1203),(3507722,'2020-08-22 15:37:01','Opportunity Updated: ',1203),(3507721,'2020-08-22 15:29:49','Opportunity Created: ',1203),(3507720,'2020-08-22 15:26:25','Opportunity Updated: ',1203),(3507719,'2020-08-22 15:26:17','Opportunity Updated: ',1203),(3507718,'2020-08-22 15:20:14','Opportunity Created: ',1203),(3507717,'2020-08-22 15:18:40','Opportunity Updated: ',1203),(3507716,'2020-08-22 15:17:21','Opportunity Updated: ',1203),(3507715,'2020-08-22 15:12:55','Opportunity Updated: ',1203),(3507714,'2020-08-22 15:07:01','Opportunity Updated: ',1203),(3507713,'2020-08-22 14:54:39','Opportunity Updated: ',1203),(3507712,'2020-08-22 14:51:12','Opportunity Created: ',1203),(3507711,'2020-08-22 14:50:31','Logged into ODMS',1203),(3507710,'2020-08-21 17:00:23','Deleted Enquiry Callbacks: Carla ,Mark & Pauline Hohenhaus,Grant ,Fleur Sutherland,Jade ,Ann ,Katie ,Katie Hill,Sueann ,Tegan Smith,Karen Mackney',467),(3507709,'2020-08-21 16:59:45','SMS sent to: 0437545114',1213),(3507708,'2020-08-21 16:59:45','Enquiry updated for: Janene Hayden ',1213),(3507707,'2020-08-21 16:59:38','Enquiry Email sent to: nene.kev@outlook.com',1213),(3507706,'2020-08-21 16:59:38','Enquiry updated for: Janene Hayden ',1213),(3507705,'2020-08-21 16:59:26','SMS sent to: 0421181780',1213),(3507704,'2020-08-21 16:59:26','Enquiry updated for: Daniel fisher ',1213),(3507703,'2020-08-21 16:59:18','Enquiry Email sent to: dannyfisher1980@hotmail.com',1213),(3507702,'2020-08-21 16:59:18','Enquiry updated for: Daniel fisher ',1213),(3507701,'2020-08-21 16:59:00','Enquiry Email sent to: janetstephens73@gmail.com',1213),(3507700,'2020-08-21 16:59:00','Enquiry updated for: Janet Stephens ',1213),(3507699,'2020-08-21 16:58:45','SMS sent to: 0407671797',1213),(3507698,'2020-08-21 16:58:45','Enquiry updated for: Angela Ford ',1213),(3507697,'2020-08-21 16:58:39','Enquiry Email sent to: Ange.ford@gmail.com',1213),(3507696,'2020-08-21 16:58:39','Enquiry updated for: Angela Ford ',1213),(3507695,'2020-08-21 16:58:27','SMS sent to: 0421248618',1213),(3507694,'2020-08-21 16:58:27','Enquiry updated for: Lauren ',1213),(3507693,'2020-08-21 16:58:22','Enquiry Email sent to: Loz.burns86@gmail.com',1213),(3507692,'2020-08-21 16:58:22','Enquiry updated for: Lauren ',1213);

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `date_schedule` datetime NOT NULL,
  `from_id` int(10) NOT NULL DEFAULT '0',
  `to_id` int(10) NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `is_deleted` enum('Yes','No') NOT NULL DEFAULT 'No',
  `date_deleted` datetime NOT NULL,
  `is_new` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `is_seen` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  PRIMARY KEY (`id`),
  KEY `to_id` (`to_id`),
  KEY `date_schedule` (`date_schedule`)
) ENGINE=MyISAM AUTO_INCREMENT=1007 DEFAULT CHARSET=latin1;

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

INSERT INTO `messages` VALUES (1006,'2020-07-31 11:24:23','2020-07-31 11:24:23',656,656,'Name: Joanna & Steven Clements<br>Guest Code: 155945<br><br><br><br />\r\n<br />\r\n<br />\r\nCALL FOR INSURANCE 11.30 CALL&nbsp;<br />\r\n<br />\r\nOR 1.45&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(1005,'2020-07-30 09:07:27','2020-07-30 09:07:27',656,656,'Name: Tas Savusa<br>Guest Code: TT65806<br><br><br>call re email&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(1004,'2020-07-24 14:21:17','2020-07-24 14:21:17',656,656,'Name: Darren & Annette Brown<br>Guest Code: DAB29414<br><br><br>call to book extra 5 nights 2nd NOV&nbsp; Port Doug','No','0000-00-00 00:00:00','Yes','Yes'),(1003,'2020-07-22 12:34:03','2020-07-22 12:34:03',656,656,'Name: Lisa Kopp<br>Guest Code: LK85274<br><br><br>wants to call tomorrow checking dates with hubby as not sure&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(1002,'2020-07-20 13:51:29','2020-07-20 13:51:29',656,656,'Name: Melanie Pinner<br>Guest Code: MP80634<br><br><br>CALL to book&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(1001,'2020-06-30 15:55:08','2020-06-30 15:55:08',732,732,'Name: Michael De Hommel<br>Guest Code: MDH39254<br><br><br>date change for guest traveling this month','No','0000-00-00 00:00:00','No','Yes'),(1000,'2020-06-29 10:36:09','2020-06-29 10:36:09',997,656,'Name: Sarah Clark<br>Guest Code: SC88526<br><br><br>Can you check if we have an email back? She wants to move to Jan 11th&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(999,'2020-06-25 13:13:25','2020-06-25 13:13:25',656,656,'Name: Angela Scarcella<br>Guest Code: AS54985<br><br><br>new dates requested for 13th May 3 nights, , she is traveling from Vic and has a booking following in noosa for th 16th May onwards&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(998,'2020-06-25 13:00:48','2020-06-25 13:00:48',656,656,'Name: John Lewes<br>Guest Code: JL95932<br><br><br>change of date to october requested with braam<br />\r\n<br />\r\n5th OCT 3 night together again package&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(997,'2020-06-24 13:42:17','2020-06-24 13:42:17',656,997,'Name: Adam Biddles<br>Guest Code: AB91208<br><br><br>Can you please call this guest , i tried but they are NA,&nbsp;<br />\r\n<br />\r\nBec Called from RES&nbsp; to let us know as the resort will be closed until the 1st September we need to contact him&nbsp;','No','0000-00-00 00:00:00','No','Yes'),(996,'2020-06-24 13:11:32','2020-06-24 13:11:32',591,591,'Name: Faith Dawson<br>Guest Code: FD31037<br><br><br>Check to see hotel has received booking','No','0000-00-00 00:00:00','No','No'),(995,'2020-06-24 13:11:07','2020-06-24 13:11:07',591,591,'Name: Robert Lock<br>Guest Code: RL52113<br><br><br>Check to see hotel has received booking','No','0000-00-00 00:00:00','No','No'),(994,'2020-06-24 13:09:57','2020-06-24 13:09:57',591,591,'Name: Faith Dawson<br>Guest Code: FD31037<br><br><br>CHECK TO SEE IF HOTEL HAS BOOKING','No','0000-00-00 00:00:00','No','No'),(993,'2020-06-23 12:15:18','2020-06-23 12:15:18',656,656,'Name: Sharon Hay<br>Guest Code: MH53452<br><br><br>request to change dates, spoke to airlie ..not open yet emailed','No','0000-00-00 00:00:00','Yes','Yes'),(992,'2020-06-16 13:35:52','2020-06-16 13:35:52',656,656,'Name: Liam Saif<br>Guest Code: LS20386<br><br><br>book peppers or pullman on price match&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(991,'2020-06-16 12:57:08','2020-06-16 12:57:08',732,732,'Name: Sharon  Jarrold<br>Guest Code: SJ21535<br><br><br>check if guest has made bpay payment yet&nbsp;','No','0000-00-00 00:00:00','No','No'),(990,'2020-06-16 09:19:41','2020-06-16 09:19:41',656,656,'Name: Justin Busch<br>Guest Code: JB92921<br><br><br>dates to re book&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(989,'2020-06-10 12:01:19','2020-06-10 12:01:19',656,656,'Name: Jeannette Spaninks<br>Guest Code: JS71325<br><br><br>follow up with change of dates 21july&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(988,'2020-06-09 11:31:46','2020-06-09 11:31:46',656,656,'Name: Catherine Russell<br>Guest Code: CR23872<br><br><br>wants to change to 2nd sep 3 nights ,SEP ,&nbsp; approved resort&nbsp;<br />\r\n<br />\r\ncalled guest na call back to confirm&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(987,'2020-06-09 10:45:43','2020-06-09 10:45:43',467,467,'Name: Andrew Klavins<br>Guest Code: AK19740<br><br><br>make sure dpoeisit is paid, tarnia calling tonight&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(986,'2020-06-09 10:12:30','2020-06-09 10:12:30',656,656,'Name: Tamara Christoforou<br>Guest Code: TC59580<br><br><br>call to change dates as sale cannot be honoured during december&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(985,'2020-06-05 12:10:15','2020-06-05 12:10:15',656,591,'Name: Carol Myers<br>Guest Code: CM59722<br><br><br>i called this guest who was sure her dates have changed, i just needed to follow up on this as she is still in&nbsp; for arrival in June&nbsp;<br />\r\n<br />\r\nshe needs to be called before 2 pm&nbsp;','Yes','2020-06-05 16:11:38','No','Yes'),(984,'2020-06-03 11:51:08','2020-06-03 11:51:08',656,656,'Name: Jackie Doherty<br>Guest Code: JD16928<br><br><br>looking to change dates as per email to Mikaela&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(983,'2020-06-02 14:07:57','2020-06-02 14:07:57',656,656,'Name: Jackie Doherty<br>Guest Code: JD16928<br><br><br>call for date change&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(982,'2020-06-01 11:57:57','2020-06-01 11:57:57',656,656,'Name: Ruth Daley<br>Guest Code: RD93039<br><br><br>call mid july as has appointments to attend in QLD once they can travel here&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(981,'2020-06-01 10:10:01','2020-06-01 10:10:01',656,656,'Name: Sara Tanner<br>Guest Code: ST79466<br><br><br>request to change dates sent to Mikaela&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(980,'2020-05-28 11:09:49','2020-05-28 11:09:49',732,732,'Name: Marcel Stronach<br>Guest Code: MS11578<br><br><br>still thinking about which dates.','No','0000-00-00 00:00:00','No','Yes'),(979,'2020-05-27 13:27:38','2020-05-27 13:27:38',656,656,'Name: Justin Busch<br>Guest Code: JB92921<br><br><br>request to change to 2021 sale sent to res to follow up&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(978,'2020-05-27 12:55:59','2020-05-27 12:55:59',656,656,'Name: Ruth Daley<br>Guest Code: RD93039<br><br><br>wants to change dates to JULY but has to check on appointment&nbsp;<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n','No','0000-00-00 00:00:00','Yes','Yes'),(977,'2020-05-27 11:27:16','2020-05-27 11:27:16',656,656,'Name: Lindsay Davies<br>Guest Code: LD13407<br><br><br>request to date change to 1-3 AUG and upgrade to a canopy suite&nbsp;','No','0000-00-00 00:00:00','Yes','Yes'),(976,'2020-05-27 11:00:12','2020-05-27 11:00:12',656,656,'Name: Debby Davies<br>Guest Code: DD24484<br><br><br>emailed Mikaela to check if sale can change to 2021<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n','No','0000-00-00 00:00:00','Yes','Yes'),(975,'2020-05-26 10:08:04','2020-05-26 10:08:04',656,656,'Name: Birte Benecke-Uhrig<br>Guest Code: BB32190<br><br><br><span style=\"color: rgb(51, 51, 51); font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; background-color: rgb(249, 249, 249);\">wanting to change dates to 2021, follow up for credit to be applied to accounts sent for balance to correct</span>','No','0000-00-00 00:00:00','Yes','Yes'),(974,'2020-05-26 10:07:08','2020-05-26 10:07:08',656,656,'Name: Birte Benecke-Uhrig<br>Guest Code: BB32190<br><br><br>wanting to change dates to 2021, follow up for credit to be applied to accounts sent for balance to correct','No','0000-00-00 00:00:00','Yes','Yes'),(973,'2020-05-25 11:28:27','2020-05-25 11:28:27',656,656,'Name: Danijela Puliafito<br>Guest Code: DP13874<br><br><br>guest called to see options on changing dates, Sea temple Na on call, calling her back.<br />\r\n<br />\r\nShe is still intending to travel, if borders open.&nbsp;<br />\r\n<br />\r\n<br />\r\n','No','0000-00-00 00:00:00','Yes','Yes'),(972,'2020-05-12 13:11:37','2020-05-12 13:11:37',1197,591,'Name: Margaret  Hassall<br>Guest Code: MH53778<br><br><br>Call Desert Palms Alice Springs about cancellation policy ','Yes','2020-05-26 11:22:06','No','Yes'),(971,'2020-05-12 13:09:03','2020-05-12 13:09:03',1197,1197,'Name: Margaret  Hassall<br>Guest Code: MH53778<br><br><br>Call&nbsp;Desert Palms Alice Springs about cancellation policy','No','0000-00-00 00:00:00','No','No'),(970,'2020-04-20 11:37:28','2020-04-20 11:37:28',997,997,'Name: Cecilia Hollingsworth<br>Guest Code: CH43102<br><br><br>WANTS DATE CHANGE TO 5TH FEB 2021','No','0000-00-00 00:00:00','No','Yes'),(969,'2020-04-17 16:29:50','2020-04-17 16:29:50',997,889,'Name: Maureen Baker<br>Guest Code: MB83473<br><br><br>Hey Maureen has spoken with you about a credit? She says the hotel and youself have organised it all... are you able to action it for me please :)','No','0000-00-00 00:00:00','No','Yes'),(968,'2020-04-06 15:47:01','2020-04-06 15:47:01',997,467,'Name: Shirley Brown<br>Guest Code: SB70754<br><br><br>Hey, Shirley has been told by qube that her dates can be moved to May next year but obviously she is on the manifest.&nbsp;<br />\r\n<br />\r\nShe said she has been speaking to you. I cant get a rate anywhere near what she has already paid so told her you would give her a buzz','No','0000-00-00 00:00:00','Yes','Yes'),(967,'2020-04-06 10:50:12','2020-04-06 10:50:12',1197,591,'Name: Craig & Tammy Parker <br>Guest Code: 73393<br><br><br>Tammy called and asked for me to CB - not at home, left message with husband to say that I will call her on Tuesday','Yes','2020-05-26 11:22:01','No','Yes'),(966,'2020-04-03 10:50:14','2020-04-03 10:50:14',997,997,'Name: Lee Graham<br>Guest Code: LG10680<br><br><br>DONE','No','0000-00-00 00:00:00','No','Yes'),(965,'2020-04-03 10:40:07','2020-04-03 10:40:07',997,889,'Name: David Raeside<br>Guest Code: DR53434<br><br><br>Hey, David called. I explained he can call and move his dates forward if he wants to travel before Oct 31 he really wants to go as early as possible','No','0000-00-00 00:00:00','No','Yes'),(964,'2020-04-01 10:54:09','2020-04-01 10:54:09',997,467,'Name: Glenn Hayden<br>Guest Code: GH91454<br><br><br>Hey Any update on these?&nbsp;<br />\r\n<br />\r\nI cant get a hold of him and he is in my excel sheet to contact....','No','0000-00-00 00:00:00','Yes','Yes'),(963,'2020-04-01 10:44:44','2020-04-01 10:44:44',997,467,'Name: Lester Chua<br>Guest Code: TC63441<br><br><br>Hey can you see what is going on with this I am so confused. Is he credditing? or leaving the booking as is and calling back?','No','0000-00-00 00:00:00','Yes','Yes'),(962,'2020-03-31 16:08:18','2020-03-31 16:08:18',1197,1197,'Name: Lindsey Whale<br>Guest Code: LW35876<br><br><br>Call Sebel Twin Waters for school holiday dates','No','0000-00-00 00:00:00','No','No'),(961,'2020-03-31 15:25:49','2020-03-31 15:25:49',1197,1197,'Name: Allison Parkinson<br>Guest Code: 59182<br><br><br>Call to get CC deets for new booking','No','0000-00-00 00:00:00','No','No'),(960,'2020-03-31 15:24:41','2020-03-31 15:24:41',1197,591,'Name: Allison Parkinson<br>Guest Code: 59182<br><br><br>Call to get CC deets for Paradise resort booking','Yes','2020-05-26 11:21:57','No','Yes'),(959,'2020-03-25 10:29:24','2020-03-25 10:29:24',656,656,'Name: Paul Reid<br>Guest Code: PR97988<br><br><br>spoke to Fitzroy in regards to changing dates, advised OK to do but rates not in for next year and they cannot check at the moment as the system down<br />\r\n<br />\r\nguest is aware I am calling them back in 48hrs.&nbsp;<br />\r\n<br />\r\nwants to change to 30th May&nbsp;<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n','No','0000-00-00 00:00:00','Yes','Yes'),(958,'2020-03-23 09:36:06','2020-03-23 09:36:06',656,656,'Name: John Cummins<br>Guest Code: JC45183<br><br><br>email corr sent to request change of date on sale rates&nbsp;<br />\r\n<br />\r\n<br />\r\n..................<br />\r\n<br />\r\nHi Mikaelah<br />\r\n&nbsp;<br />\r\nCan the booking below please be change with the same rate they booked 1 Bedroom Premier - SALE For new dates of the 26<sup>th</sup> October<br />\r\n&nbsp;<br />\r\nOaks Calypso Plaza<br />\r\n&nbsp;<br />\r\nKind regards<br />\r\n<br />\r\n','No','0000-00-00 00:00:00','Yes','Yes'),(957,'2020-03-23 08:22:58','2020-03-23 08:22:58',656,656,'Name: trevor thornton<br>Guest Code: DT71023<br><br><br>debbie requested to cancel forwarding email Oaks to call now&nbsp;<br />\r\n','No','0000-00-00 00:00:00','Yes','Yes');

--
-- Table structure for table `opportunity`
--

CREATE TABLE `opportunity` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `start_dt` datetime NOT NULL,
  `end_dt` datetime NOT NULL,
  `type` varchar(40) NOT NULL,
  `property_id` int(10) NOT NULL DEFAULT '0',
  `inc_card` enum('Yes','No') NOT NULL DEFAULT 'No',
  `provider` 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=479 DEFAULT CHARSET=latin1;

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

INSERT INTO `opportunity` VALUES (478,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',13383,'Yes','Direct','Pending','','','','','','','','','','','25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21','','19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21','','07 - 22 Jan, 02 Apr - 18 Apr 21','','22 Dec 20 - 06 Jan 21','','Low season   (anytime outside school holidays ) \r\n25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21\r\n\r\nMid season    (June/July/ sept school holidays)\r\n19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21\r\n\r\nHigh season   (easter break ,   Jan 7-22nd)\r\n07 - 22 Jan, 02 Apr - 18 Apr 21\r\n\r\nPeak    22nd dec- 6th Jan \r\n22 Dec 20 - 06 Jan 21','',10),(477,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',13393,'Yes','Direct','Pending','','','','','','','','','','','25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21','','19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21','','07 - 22 Jan, 02 Apr - 18 Apr 21','','22 Dec 20 - 06 Jan 21','','Low season   (anytime outside school holidays ) \r\n25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21\r\n\r\nMid season    (June/July/ sept school holidays)\r\n19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21\r\n\r\nHigh season   (easter break ,   Jan 7-22nd)\r\n07 - 22 Jan, 02 Apr - 18 Apr 21\r\n\r\nPeak    22nd dec- 6th Jan \r\n22 Dec 20 - 06 Jan 21','',10),(476,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',13385,'Yes','Direct','Pending','','','','','','','','','','','25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21','','19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21','','07 - 22 Jan, 02 Apr - 18 Apr 21','','22 Dec 20 - 06 Jan 21','','Low season   (anytime outside school holidays ) \r\n25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21\r\n\r\nMid season    (June/July/ sept school holidays)\r\n19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21\r\n\r\nHigh season   (easter break ,   Jan 7-22nd)\r\n07 - 22 Jan, 02 Apr - 18 Apr 21\r\n\r\nPeak    22nd dec- 6th Jan \r\n22 Dec 20 - 06 Jan 21','',10),(475,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',13382,'Yes','Direct','Pending','','','','','','','','','','','25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21','','19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21','','07 - 22 Jan, 02 Apr - 18 Apr 21','','22 Dec 20 - 06 Jan 21','','Low season   (anytime outside school holidays ) \r\n25 Aug - 18 Sep, 06 Oct - 21 Dec 20, 23 Jan - 01 Apr, 19 Apr - 25 Jun, 12 Jul - 31 Jul 21\r\n\r\nMid season    (June/July/ sept school holidays)\r\n19 Sep - 05 Oct 20, 26 Jun - 11 Jul 21\r\n\r\nHigh season   (easter break ,   Jan 7-22nd)\r\n07 - 22 Jan, 02 Apr - 18 Apr 21\r\n\r\nPeak    22nd dec- 6th Jan \r\n22 Dec 20 - 06 Jan 21','',10),(474,'2020-09-01 00:00:00','2020-09-15 00:00:00','Flash Sale',9597,'No','Direct','Completed','Bottle of wine on arrival','20','Late check out 12pm','15','F&B  credit ','25','Free breakfast','150','','','','31st December ,   1-3 May 2021','','','','','','','1st Sept 2020- June 31st 2021\r\n\r\nPromo called  Shine on Townsville','1. This special is available for purchase until 11.00pm (AEST) Tuesday 15 September 2020.\r\n2. Valid for travel from 1st September 2020 to 30 June 2021 (excluding 31 December 2020, & 1-3 May 2021).\r\n3. Your booking must be confirmed by 1st October 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. A voucher will be sent to you by email on confirmation of payment.\r\n6. The special is valid for up to 2 people in a Executive King Room or 2 adults & 2 children (0-12 years) in a Standard Twin Room.\r\n7. Maximum room capacity is 2 adults in a Executive King Room &  2 adults & 2 children (0-12 years) or 3 adults in a Standard Twin Room.\r\n8. Extra adult charge is $50 per night including breakfast daily. Children (0-12 years) stay free of charge using existing bedding (breakfast payable direct).\r\n9. Extra nights may be purchased at time of booking at the same per night price. \r\n10. Full payment is required at time of booking.\r\n11. Changes are permitted up to 4 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.\r\n12. Cancellations are permitted up to 4 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n\r\n<b>Food & Beverage Credit Terms & Conditions</b>\r\n1. Valid for room service, hotel restaurant and bar.\r\n2. Not applicable to in-room mini bar.\r\n3. Credit is not redeemeable for cash and is not transferable.\r\n4. Any unused credit is non-refundable.',10),(473,'2020-09-01 00:00:00','2020-09-15 00:00:00','Flash Sale',9597,'No','Direct','Completed','Bottle of wine on arrival','20','Late check out 12pm','15','F&B  credit ','25','Free breakfast','150','','','1st Sept 2020- June 31st 2021','31st December ,   1-3 May 2021','','','','','','','1st Sept 2020- June 31st 2021\r\n\r\nPromo called  Shine on Townsville','1. This special is available for purchase until 11.00pm (AEST) Tuesday 15 September 2020.\r\n2. Valid for travel from 1st September 2020 to 30 June 2021 (excluding 31 December 2020, & 1-3 May 2021).\r\n3. Your booking must be confirmed by 1st October 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. A voucher will be sent to you by email on confirmation of payment.\r\n6. The special is valid for up to 2 people in a Executive King Room or 2 adults & 2 children (0-12 years) in a Standard Twin Room.\r\n7. Maximum room capacity is 2 adults in a Executive King Room &  2 adults & 2 children (0-12 years) or 3 adults in a Standard Twin Room.\r\n8. Extra adult charge is $50 per night including breakfast daily. Children (0-12 years) stay free of charge using existing bedding (breakfast payable direct).\r\n9. Extra nights may be purchased at time of booking at the same per night price. \r\n10. Full payment is required at time of booking.\r\n11. Changes are permitted up to 4 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.\r\n12. Cancellations are permitted up to 4 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n\r\n<b>Food & Beverage Credit Terms & Conditions</b>\r\n1. Valid for room service, hotel restaurant and bar.\r\n2. Not applicable to in-room mini bar.\r\n3. Credit is not redeemeable for cash and is not transferable.\r\n4. Any unused credit is non-refundable.',64),(472,'2020-09-01 00:00:00','2020-09-15 00:00:00','Flash Sale',2944,'No','Direct','Completed','Late check out guaranteed until 1PM','90','Wifi','','1 x car park included','','','','','','05 Oct - 18 Oct, 21 Oct - 22 Oct, 25 Oct - 17 Dec 20, 28 Jan - 01 Apr 21','19 Oct - 20 Oct, 23 - 24 Oct, 18 Dec 20 - 27 Jan 21','','','','','','','No voucher redemption','1. This special is available for purchase until 5.00pm (AEST) Tuesday 15 September 2020.\r\n2. Valid for travel from 05 Oct 2020 to 01 Apr 2021.\r\n3. The travel period has black-out dates: 19 Oct - 20 Oct, 23 - 24 Oct, 18 Dec 20 - 27 Jan 21.\r\n4. Your booking must be confirmed by 15 Sep 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Ocean view apartment or 4 people in a 2 Bedroom Ocean view apartment. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom Ocean view apartment or 5 people in a 2 Bedroom Ocean view apartment.\r\n9. Extra person charge is $62 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 7 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.\r\n13. Cancellations are permitted up to 7 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(471,'2020-09-01 00:00:00','2020-09-15 00:00:00','Flash Sale',2944,'Yes','Direct','Completed','Late check out guaranteed until 1PM','90','Wifi','','1 x car park included','','My DQ Card','199','','','05 Oct - 18 Oct, 21 Oct - 22 Oct, 25 Oct - 17 Dec 20, 28 Jan - 01 Apr 21','19 Oct - 20 Oct, 23 - 24 Oct, 18 Dec 20 - 27 Jan 21','','','','','','','No voucher redemption','1. This special is available for purchase until 5.00pm (AEST) Tuesday 15 September 2020.\r\n2. Valid for travel from 05 Oct 2020 to 01 Apr 2021.\r\n3. The travel period has black-out dates: 19 Oct - 20 Oct, 23 - 24 Oct, 18 Dec 20 - 27 Jan 21. \r\n4. Your booking must be confirmed by 15 Sep 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Ocean view apartment or 4 people in a 2 Bedroom Ocean view apartment. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom Ocean view apartment or 5 people in a 2 Bedroom Ocean view apartment.\r\n9. Extra person charge is $62 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 7 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.\r\n13. Cancellations are permitted up to 7 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(470,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',11987,'No','Direct','Completed','Welcome bottle of wine & chocolates ','30','Guaranteed 12pm late check-out','60','10% daily dining discount (up to $50) per sitting at Bread n Butter & St Helens','','1 x free beach towel hire per guest','20','Undercover car parking','','25 Aug 2020 - 25 Jun 2021<br>\r\n(25 Aug - 10 Sep 2020, 19 Apr - 1 Jun, 7 - 9 Jun, 14 - 25 Jun 2021)\r\n','11 Sep - 10 Oct, 11 Dec 2020 - 26 Jan, 2 - 18 Apr, 2 - 6 Jun & 9 - 13 Jun 2021','11 Oct - 10 Dec 2020, 27 Jan - 1 Apr 2021','','','','','','Other inclusions: (TOTAL $309)<br>\r\n-Undercover car parking<br>\r\n-1 x premium Foxtel package<br>\r\n-Daily unlimited high speed Wifi with Netflix<p>\r\n\r\nVoucher redemption period: 25.08.20 - 22.09.20<p>\r\n\r\nSurcharge Peak time - $15 Nett per night<br>\r\n11 Oct - 10 Dec 2020, 27 Jan - 01 Apr 2021','1. This special is available for purchase until 5.00pm (AEST) Tuesday 08 September 2020.\r\n2. Valid for travel from 25 August 2020 to 25 June 2021. Surcharges apply for Peak season travel dates: 11 Oct - 10 Dec 2020, 27 Jan - 01 Apr 2021.\r\n3. The travel period has black-out dates: 11 Sep - 10 Oct, 11 Dec 2020 - 26 Jan, 02 Apr - 18 Apr, 02 Jun - 06 Jun, 09 Jun - 13 Jun 2021. \r\n4. Your booking must be confirmed by 22 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom apartment & 6 people in a 3 Bedroom apartment. \r\n8. Maximum room capacity is 5 people in a 2 Bedroom apartment & 6 people in a 3 Bedroom apartment. \r\n9. Extra person charge is $63 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 60 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. No Schoolies bookings will be accepted between 21 Nov - 5 Dec 2020.\r\n19. A 2.5% booking fee applies.',64),(469,'2020-09-08 00:00:00','2020-09-22 00:00:00','Flash Sale',13015,'Yes','Direct','Pending','Guaranteed late checkout ','80','Bottle of wine on arrival','30','10% discount on touring booked at hotel','','','','','','TRAVEL DATES\r\n1 SEPT 20 â€“ 18 DEC 20 & 9JAN 21 â€“ 2 APR 21, 17 APR - 25 JUN 21\r\n','18th dec- 09 Jan ','','','','','','','Infants 0 up to 2 years are Free of Charge using existing bedding. \r\n                     		Children over 3 years of age are as per adult rates.  \r\nCots are available at a rate of $7.50 per night, payable direct and to be pre-booked. \r\nOne Infant is permitted to be added to the maximum room capacity when a cot is booked for the infant to sleep in. \r\n','7)	Cancellation Conditions\r\nChange of dates permitted up to 7 days prior to arrival. Any change of dates required due to state border closures are permitted with any lead time. Credit for travel due to pandemic conditions can be extended to 20 Dec 2021 subject to availability. \r\n',10),(468,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',3675,'No','Direct','Completed','Bottle of wine & gourmet chocolates ','25','1 x tennis court hire with rackets and balls','10','Northcliffe Surf Club - 20% off breakfast (min 2 guests)','','Wifi unlimited ','10','1 x beach towel hire','5pp','25 August 2020 - 25 June 2021<br>\r\n(25 Aug - 18 Sep, 06 Oct - 18 Dec 2020, 27 Jan - 01 Apr, 27 Apr - 25 Jun 2021)','19 Sep - 05 Oct, 19 Dec 2020 - 26 Jan, 02 - 26 Apr 2021','','','','','','','Voucher redemption: 25.08.20 - 22.09.20','1. This special is available for purchase until 5.00pm (AEST) Tuesday 08 September 2020.\r\n2. Valid for travel from 25 August 2020 to 25 June 2021.\r\n3. The travel period has black-out dates: 19 Sep - 05 Oct, 19 Dec 2020 - 26 Jan, 02 - 26 Apr 2021. \r\n4. Your booking must be confirmed by 22 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom & 4 people in a 2 Bedroom. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom & 5 people in a 2 Bedroom. \r\n9. Extra person charge is $31 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 45 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. No Schoolies bookings will be accepted between 21 Nov - 5 Dec 2020.\r\n19. A 2.5% booking fee applies.',64),(467,'2020-08-18 00:00:00','2020-09-01 00:00:00','Flash Sale',9230,'No','Direct','Completed','Bottle of wine & chocolates in room on arrival','30','Early check-in â€“ Subject to availability 12 noon','60','Wifi â€“ Unlimited','60','10% off your total bill & 1 Olive saltate @ www.belvederestonemill.com','','Beach Towel hire ','72','18 Aug 2020 - 25 Jun 2021<br>\r\n(18 Aug - 17 Sep, 12 Oct - 18 Dec 2020, 28 Jan - 1 Apr & 27 Apr - 25 Jun 2021)','18 Sep - 11 Oct, 19 Dec 2020 - 15 Jan & 2 - 10 Apr 2021','15 - 27 Jan & 11 - 26 Apr 2021','','','','','','Offer inclusions continue: (TOTAL $436)<br>\r\nâ€¢ Tennis Court hire<br>\r\nâ€¢ Racquet and Balls hire $5pp per day (15)<br>\r\nâ€¢ My DQ Card $199<p>\r\n\r\n3 / 5 / 7 night packages apply (see tactical agreement for the 7 night package rates)<p>\r\n\r\n$30 net surcharge for Saturday evenings for 3-night bookings only <br>\r\nLow Season Only 18 Aug â€“ 17 Sep, 12 Oct â€“ 18 Dec 20, 28 Jan â€“ 01 Apr, 27 Apr â€“ 25 Jun 21<p>\r\n\r\nPEAK TIME SURCHARGE: $40 Net per night surcharge (5 or 7 night min only) <br>\r\n15 Jan â€“ 27 Jan, 11 Apr â€“ 26 Apr 21<br>','1. This special is available for purchase until 5.00pm (AEST) Tuesday 1 September 2020.\r\n2. Valid for travel from 18 August 2020 to 25 June 2021. \r\nLow season travel dates: 18 Aug - 17 Sep, 12 Oct - 18 Dec 2020, 28 Jan - 1 Apr & 27 Apr - 25 Jun 2021. A $38 surcharge applies on Saturday nights for 3 night stays.\r\nSurcharges apply for Holiday season travel dates: 15 - 27 Jan & 11 - 26 Apr 2021.\r\n3. The travel period has black-out dates: 18 Sep - 11 Oct, 19 Dec 2020 - 15 Jan & 2 - 10 Apr 21. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom Standard Oceanview, 4 people in a 2 Bedroom Superior Oceanview & 6 people in a 3 Bedroom Superior Oceanview. \r\n8. Maximum room capacity is 5 people in a 2 Bedroom Standard Oceanview, 5 people in a 2 Bedroom Superior Oceanview & 7 people in a 3 Bedroom Superior Oceanview.\r\n9. Extra person charge is $50 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 45 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. No Schoolies bookings will be accepted between 21 Nov - 5 Dec 2020.\r\n19. A 2.5% booking fee applies.',64),(466,'2020-08-18 00:00:00','2020-09-01 00:00:00','Flash Sale',9230,'Yes','Direct','Approved','Bottle of wine & chocolates in room on arrival','30','Early check-in â€“ Subject to availability 12 noon','60','Wifi â€“ Unlimited','60','10% off your total bill & 1 Olive saltate @ www.belvederestonemill.com','','Beach Towel hire ','72','18 Aug 2020 - 25 Jun 2021<br>\r\n(18 Aug - 17 Sep, 12 Oct - 18 Dec 2020, 28 Jan - 1 Apr & 27 Apr - 25 Jun 2021)','18 Sep - 11 Oct, 19 Dec 2020 - 15 Jan & 2 - 10 Apr 2021','15 - 27 Jan & 11 - 26 Apr 2021','','','','','','Offer inclusions continue: (TOTAL $436)<br>\r\nâ€¢ Tennis Court hire<br>\r\nâ€¢ Racquet and Balls hire $5pp per day (15)<br>\r\nâ€¢ My DQ Card $199<p>\r\n\r\n3 / 5 / 7 night packages apply (see tactical agreement for the 7 night package rates)<p>\r\n\r\n$30 net surcharge for Saturday evenings for 3-night bookings only <br>\r\nLow Season Only 18 Aug â€“ 17 Sep, 12 Oct â€“ 18 Dec 20, 28 Jan â€“ 01 Apr, 27 Apr â€“ 25 Jun 21<p>\r\n\r\nPEAK TIME SURCHARGE: $40 Net per night surcharge (5 or 7 night min only) <br>\r\n15 Jan â€“ 27 Jan, 11 Apr â€“ 26 Apr 21<br>\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 1 September 2020.\r\n2. Valid for travel from 18 August 2020 to 25 June 2021. \r\nLow season travel dates: 18 Aug - 17 Sep, 12 Oct - 18 Dec 2020, 28 Jan - 1 Apr & 27 Apr - 25 Jun 2021. A $38 surcharge applies on Saturday nights for 3 night stays.\r\nSurcharges apply for Holiday season travel dates: 15 - 27 Jan & 11 - 26 Apr 2021.\r\n3. The travel period has black-out dates: 18 Sep - 11 Oct, 19 Dec 2020 - 15 Jan & 2 - 10 Apr 21. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom Standard Oceanview, 4 people in a 2 Bedroom Superior Oceanview & 6 people in a 3 Bedroom Superior Oceanview. \r\n8. Maximum room capacity is 5 people in a 2 Bedroom Standard Oceanview, 5 people in a 2 Bedroom Superior Oceanview & 7 people in a 3 Bedroom Superior Oceanview.\r\n9. Extra person charge is $50 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 45 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. No Schoolies bookings will be accepted between 21 Nov - 5 Dec 2020.\r\n19. A 2.5% booking fee applies.',10),(465,'2020-08-18 00:00:00','2020-09-01 00:00:00','Flash Sale',3677,'No','Direct','Approved','Bottle of wine & chocolates on arrival','30','12pm Early Check-In (on request)','60','High Speed WiFi','40','Beach Towel Hire for 2 people','24','','','18 Aug 2020 - 25 Jun 2021<br>\r\n(18 Aug - 17 Sep, 11 Oct - 17 Dec 2020, 27 Jan - 1 Apr & 26 Apr - 25 Jun 2021)','18 Sep - 10 Oct & 18 Dec 2020 - 11 Jan 2021','12 - 26 Jan & 2 - 25 Apr 21','','','','','','Saturday Surcharge - Low Season Only<br>\r\n$30 nett surcharge for Saturday evenings for 2, 3 & 5 night bookings<br>\r\nLow Season Dates: 18 Aug 20 - 11 Jan, 27 Jan - 01 Apr & 26 Apr - 25 Jun 21<p>\r\n\r\nPeak time surcharge (Season 2): $25 nett per night (no Saturday surcharge in peak time)<br>   \r\nPeak Season Dates: 12 Jan - 26 Jan & 02 Apr - 25 Apr 21<p>\r\n\r\nVoucher redemption: 18 Sep - 15 Sep 2020','1. This special is available for purchase until 5.00pm (AEST) Tuesday 1 September 2020.\r\n2. Valid for travel from 18 August 2020 to 25 June 2021. \r\nLow season travel dates: 18 Aug - 17 Sep, 11 Oct - 17 Dec 2020, 27 Jan - 1 Apr & 26 Apr - 25 Jun 2021. A $38 surcharge applies on Saturday nights.\r\nSurcharges apply for Holiday season travel dates: 12 - 26 Jan & 2 - 25 Apr 2021.\r\n3. The travel period has black-out dates: 18 Sep - 10 Oct & 18 Dec 2020 - 11 Jan 2021.  \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom or 4 people in a 2 Bedroom. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom or 5 people in a 2 Bedroom.\r\n9. Extra person charge is $32 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject\r\nto availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 60 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. A 2.5% booking fee applies.',64),(464,'2020-08-11 00:00:00','2020-08-25 00:00:00','Flash Sale',13381,'No','Direct','Completed','$50 dining credit in Drift and Wood Restaurant','50','11am late check-out guaranteed','30','','','','','','','11 Aug - 17 Sep, 7 Oct - 10 Dec 2020 & 27 Jan - 1 Apr 2021\r\n','8 Sep - 6 Oct & 11 Dec 2020 - 26 Jan 2021\r\n','','','','','','','','1. This special is available for purchase until 5.00pm (AEST) Tuesday 25 August 2020.\r\n2. Valid for travel from 11 August 2020 to 01 April 2021.\r\n3. The travel period has black-out dates: 18 Sep - 06 Oct & 11 Dec 2020 - 26 Jan 2021. \r\n4. Your booking must be confirmed by 08 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Beach home, 4 people in a 2 Bedroom Beach home or 6 people in a 3 Bedroom Beach home. \r\n8. Maximum room capacity is 2 people in a 1 Bedroom Beach home, 4 people in a 2 Bedroom Beach home or 7 people in a 3 Bedroom Beach home. \r\n9. Extra person charge is $38 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.\r\n\r\n<b>Dining Credit T&Cs<b>\r\n1. Applicable at Drift and Wood Restaurant only.\r\n2. Credit is not redeemeable for cash and is not transferable.\r\n3. Any unused credit is non-refundable.',64),(463,'2020-08-14 00:00:00','2020-09-08 00:00:00','Flash Sale',9593,'No','Direct','Approved','Free 12pm late check out ','15','Free bottle of wine upon arrival','20','Free parking ','20','F&B Credit ','25','Breakfast for 2 people daily','50','14 August - 30 June 2021<br>\r\n(14 Aug - 30 Dec 2020 & 1 Jan - 30 Jun 2021)','31 Dec 2020','','','','','','','Sale is called \'Spring into Brisbane\' \r\ntheir cxl Policy to us   24hrs prior   full refund \r\n\r\n','1. This special is available for purchase until 11.00pm (AEST) Tuesday 8 September 2020.\r\n2. Valid for travel from 14 August 2020 to 30 June 2021 (excluding 31 December 2020).\r\n3. Your booking must be confirmed by 22 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. A voucher will be sent to you by email on confirmation of payment.\r\n6. The special is valid for up to 2 people in a Superior King Room or 2 adults & 2 children (0-12 years) in a Deluxe Twin Room.\r\n7. Maximum room capacity is 2 adults in a Superior King Room, 2 adults & 2 children (0-12 years) or 3 adults in a Deluxe Twin Room.\r\n8. Extra adult charge is $70 per night including breakfast daily. Children (0-12 years) stay free of charge using existing bedding (breakfast payable direct).\r\n9. Extra nights may be purchased at time of booking at the same per night price. \r\n10. Full payment is required at time of booking.\r\n11. Changes are permitted up to 3 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.\r\n12. Cancellations are permitted up to 3 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n\r\n<b>Food & Beverage Credit Terms & Conditions</b>\r\n1. Valid for room service, hotel restaurant and bar.\r\n2. Not applicable to in-room mini bar.\r\n3. Credit is not redeemeable for cash and is not transferable.\r\n4. Any unused credit is non-refundable.',10),(462,'2020-08-11 00:00:00','2020-08-25 00:00:00','Flash Sale',13381,'Yes','Direct','Completed','$50 dining credit in Drift and Wood Restaurant','50','11am late check-out guaranteed','30','My DQ Card','199','','','','','11 Aug - 17 Sep, 7 Oct - 10 Dec 2020 & 27 Jan - 1 Apr 2021','18 Sep - 6 Oct & 11 Dec 2020 - 26 Jan 2021\r\n','','','','','','','','1. This special is available for purchase until 5.00pm (AEST) Tuesday 25 August 2020.\r\n2. Valid for travel from 11 August 2020 to 01 April 2021.\r\n3. The travel period has black-out dates: 18 Sep - 06 Oct & 11 Dec 2020 - 26 Jan 2021. \r\n4. Your booking must be confirmed by 08 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Beach home, 4 people in a 2 Bedroom Beach home or 6 people in a 3 Bedroom Beach home. \r\n8. Maximum room capacity is 2 people in a 1 Bedroom Beach home, 4 people in a 2 Bedroom Beach home or 7 people in a 3 Bedroom Beach home. \r\n9. Extra person charge is $38 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.\r\n\r\n<b>Dining Credit T&Cs<b>\r\n1. Applicable at Drift and Wood Restaurant only.\r\n2. Credit is not redeemeable for cash and is not transferable.\r\n3. Any unused credit is non-refundable.',10),(461,'2020-08-14 00:00:00','2020-09-08 00:00:00','Flash Sale',9593,'No','Direct','Approved','Free 12pm late check out ','15','Free bottle of wine upon arrival','20','Free parking ','20','F&B Credit ','25','Breakfast for 2 people daily','50','14 August 2020 - 30 June 2021<br>\r\n(14 Aug - 30 Dec 2020 & 1 Jan - 30 Jun 2021)','31 Dec 2020','','','','','','','Sale is called \'Spring into Brisbane\' \r\ntheir cxl Policy to us   24hrs prior   full refund \r\n\r\n','1. This special is available for purchase until 11.00pm (AEST) Tuesday 8 September 2020.\r\n2. Valid for travel from 14 August 2020 to 30 June 2021 (excluding 31 December 2020).\r\n3. Your booking must be confirmed by 22 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. A voucher will be sent to you by email on confirmation of payment.\r\n6. The special is valid for up to 2 people in a Superior King Room or 2 adults & 2 children (0-12 years) in a Deluxe Twin Room.\r\n7. Maximum room capacity is 2 adults in a Superior King Room, 2 adults & 2 children (0-12 years) or 3 adults in a Deluxe Twin Room.\r\n8. Extra adult charge is $70 per night including breakfast daily. Children (0-12 years) stay free of charge using existing bedding (breakfast payable direct).\r\n9. Extra nights may be purchased at time of booking at the same per night price. \r\n10. Full payment is required at time of booking.\r\n11. Changes are permitted up to 3 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.\r\n12. Cancellations are permitted up to 3 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n\r\n<b>Food & Beverage Credit Terms & Conditions</b>\r\n1. Valid for room service, hotel restaurant and bar.\r\n2. Not applicable to in-room mini bar.\r\n3. Credit is not redeemeable for cash and is not transferable.\r\n4. Any unused credit is non-refundable.',64),(460,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',13379,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 9 Sep, 11 Oct - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','10 Sep - 10 Oct, 23 Dec 2020 - 6 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $32 per night nett.','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\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.  \r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Ocean view & 4 people in a 2 Bedroom Garden view. \r\n8. Maximum room capacity is 2 people in a 1 Bedroom Ocean view & 4 people in a 2 Bedroom Garden view.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \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.\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.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(459,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',9392,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 9 Sep, 11 Oct - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','10 Sep - 10 Oct, 23 Dec 2020 - 6 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $69.70 per night nett.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\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.  \r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom LUXE Ocean view & 4 people in a 2 Bedroom LUXE Pool Deck. \r\n8. Maximum room capacity is 4 people.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \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.\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.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(458,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',13379,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 9 Sep, 11 Oct - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','10 Sep - 10 Oct, 23 Dec 2020 - 6 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $32 per night nett.','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\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.  \r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Ocean view & 4 people in a 2 Bedroom Garden view. \r\n8. Maximum room capacity is 2 people in a 1 Bedroom Ocean view & 4 people in a 2 Bedroom Garden view.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \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.\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.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(457,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',9392,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 9 Sep, 11 Oct - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','10 Sep - 10 Oct, 23 Dec 2020 - 06 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $69.70 per night nett.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\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.  \r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom LUXE Ocean view & 4 people in a 2 Bedroom LUXE Pool Deck. \r\n8. Maximum room capacity is 4 people.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \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.\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.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(456,'2020-08-04 00:00:00','2020-08-18 00:00:00','Hot Deal',115,'Yes','Direct','Approved','','','','','','','','','','','4 Aug - 15 Sep 2020','','16 Sep - 15 Oct 2020','','','','','','<b>Stay 4 Pay 3 & Stay 7 Pay 5 </b><br>\r\nPremium Peak Season rates (season 2) are the same for 1 & 2 Bedrooms.','1. Valid for sale up to 18 August 2020.\r\n2. Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020.\r\n3. Bookings are essential and subject to availability.\r\n4. Valid for up to 2 people in a Studio or 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom, 8 people in a 4 Bedroom.\r\n5. 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.\r\n6. 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.\r\n7. 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.\r\n8. We recommend taking out a travel insurance policy at the point of booking.\r\n9. Please note all advertised pricing is in AUD (Australian Dollars).\r\n10. A 2.5% booking fee applies.\r\n\r\nStay 4 Pay 3, Swim-Out and Penthouse options are available  - please enquire for details.',10),(455,'2020-08-04 00:00:00','2020-08-18 00:00:00','Hot Deal',114,'Yes','Direct','Approved','','','','','','','','','','','4 Aug - 15 Sep 2020','','16 Sep - 15 Oct 2020','','','','','','<b>Stay 4 Pay 3 & Stay 7 Pay 5 </b><br>\r\nPremium Peak Season rates (season 2) are the same for 1, 2 & 3 Bedrooms.','1. Valid for sale up to 18 August 2020.\r\n2. Travel Dates: 4 Aug - 15 Sep 2020. Surcharge applies 16 Sep - 15 Oct 2020.\r\n3. Bookings are essential and subject to availability.\r\n4. Valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom, 6 people in a 3 Bedroom.\r\n5. 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.\r\n6. 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.\r\n7. 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.\r\n8. We recommend taking out a travel insurance policy at the point of booking.\r\n9. Please note all advertised pricing is in AUD (Australian Dollars).\r\n10. A 2.5% booking fee applies.\r\n\r\nStay 4 Pay 3, Swim-Out, Plunge Pool and Penthouse options are available  - please enquire for details.',10),(454,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',9393,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','23 Dec 2020 - 6 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 06 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $32 per night nett.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\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.  \r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom LUXE Ocean view & 4 people in a 2 Bedroom LUXE Pool Deck. \r\n8. Maximum room capacity is 4 people.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \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.\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.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(453,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',9372,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','23 Dec 2020 - 6 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 08.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $32 per night nett.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\r\n2. Valid for travel from 11 August 2020 to 13 June 2021. Low season travel dates: 11 Aug - 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. \r\n3. The travel period has black-out dates: 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a Tropical or Club Studio. \r\n8. Maximum room capacity is 3 people in a Tropical or Club Studio.\r\n9. Extra person charge is $46 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. 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.\r\n13. 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.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. A 2.5% booking fee applies.',64),(452,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',11987,'Yes','Direct','Completed','Welcome bottle of wine & chocolates ','30','Guaranteed 12pm late check-out','60','10% daily dining discount (up to $50) per sitting at Bread n Butter & St Helens','','1 x free beach towel hire per guest','20','My DQ card','199','25 Aug 2020 - 25 Jun 2021<br>\r\n(25 Aug - 10 Sep 2020, 19 Apr - 1 Jun, 7 - 9 Jun, 14 - 25 Jun 2021)\r\n','11 Sep - 10 Oct, 11 Dec 2020 - 26 Jan, 2 - 18 Apr, 2 - 6 Jun & 9 - 13 Jun 2021','11 Oct - 10 Dec 2020, 27 Jan - 1 Apr 2021','','','','','','Other inclusions: (TOTAL $309)<br>\r\n-Undercover car parking<br>\r\n-1 x premium Foxtel package<br>\r\n-Daily unlimited high speed Wifi with Netflix<p>\r\n\r\nVoucher redemption period: 25.08.20 - 22.09.20<p>\r\n\r\nSurcharge Peak time - $15 Nett per night<br>\r\n11 Oct - 10 Dec 2020, 27 Jan - 01 Apr 2021','1. This special is available for purchase until 5.00pm (AEST) Tuesday 08 September 2020.\r\n2. Valid for travel from 25 August 2020 to 25 June 2021. Surcharges apply for Peak season travel dates: 11 Oct - 10 Dec 2020, 27 Jan - 01 Apr 2021.\r\n3. The travel period has black-out dates: 11 Sep - 10 Oct, 11 Dec 2020 - 26 Jan, 02 Apr - 18 Apr, 02 Jun - 06 Jun, 09 Jun - 13 Jun 2021. \r\n4. Your booking must be confirmed by 22 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom apartment & 6 people in a 3 Bedroom apartment. \r\n8. Maximum room capacity is 5 people in a 2 Bedroom apartment & 6 people in a 3 Bedroom apartment. \r\n9. Extra person charge is $63 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 60 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. No Schoolies bookings will be accepted between 21 Nov - 5 Dec 2020.\r\n19. A 2.5% booking fee applies.',10),(451,'2020-08-25 00:00:00','2020-09-08 00:00:00','Flash Sale',3675,'Yes','Direct','Completed','Bottle of wine & gourmet chocolates ','25','1 x tennis court hire with rackets and balls','10','Northcliffe Surf Club - 20% off breakfast (min 2 guests)','','Wifi unlimited ','10','My DQ Card','199','25 August 2020 - 25 June 2021<br>\r\n(25 Aug - 18 Sep, 06 Oct - 18 Dec 2020, 27 Jan - 01 Apr, 27 Apr - 25 Jun 2021)','19 Sep - 05 Oct, 19 Dec 2020 - 26 Jan, 02 - 26 Apr 2021','','','','','','','Offer inclusions continue (TOTAL $254<br>)\r\n- 1 x beach towel hire per person $5pp<p>\r\n\r\nVoucher redemption: 25.08.20 - 22.09.20\r\n\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 08 September 2020.\r\n2. Valid for travel from 25 August 2020 to 25 June 2021.\r\n3. The travel period has black-out dates: 19 Sep - 05 Oct, 19 Dec 2020 - 26 Jan, 02 - 26 Apr 2021. \r\n4. Your booking must be confirmed by 22 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom & 4 people in a 2 Bedroom. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom & 5 people in a 2 Bedroom. \r\n9. Extra person charge is $31 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 45 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. No Schoolies bookings will be accepted between 21 Nov - 5 Dec 2020.\r\n19. A 2.5% booking fee applies.',10),(450,'2020-08-18 00:00:00','2020-09-01 00:00:00','Flash Sale',3677,'Yes','Direct','Approved','Bottle of wine & chocolates on arrival','30','12pm Early Check-In (on request)','60','High Speed WiFi','40','Beach Towel Hire for 2 people','24','My DQ Card','199','18 Aug 2020 - 25 Jun 2021<br>\r\n(18 Aug - 17 Sep, 11 Oct - 17 Dec 2020, 27 Jan - 1 Apr & 26 Apr - 25 Jun 2021)','18 Sep - 10 Oct & 18 Dec 2020 - 11 Jan 2021','12 - 26 Jan & 2 - 25 Apr 21','','','','','','Saturday Surcharge - Low Season Only<br>\r\n$30 nett surcharge for Saturday evenings for 2, 3 & 5 night bookings<br>\r\nLow Season Dates: 18 Aug 20 - 11 Jan, 27 Jan - 01 Apr & 26 Apr - 25 Jun 21<p>\r\n\r\nPeak time surcharge (Season 2): $25 nett per night (no Saturday surcharge in peak time)<br>   \r\nPeak Season Dates: 12 Jan - 26 Jan & 02 Apr - 25 Apr 21<p>\r\n\r\nVoucher redemption: 18 Sep - 15 Sep 2020','1. This special is available for purchase until 5.00pm (AEST) Tuesday 1 September 2020.\r\n2. Valid for travel from 18 August 2020 to 25 June 2021. \r\nLow season travel dates: 18 Aug - 17 Sep, 11 Oct - 17 Dec 2020, 27 Jan - 1 Apr & 26 Apr - 25 Jun 2021. A $38 surcharge applies on Saturday nights.\r\nSurcharges apply for Holiday season travel dates: 12 - 26 Jan & 2 - 25 Apr 2021.\r\n3. The travel period has black-out dates: 18 Sep - 10 Oct & 18 Dec 2020 - 11 Jan 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom or 4 people in a 2 Bedroom. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom or 5 people in a 2 Bedroom.\r\n9. Extra person charge is $32 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 30 days prior to travel date provided the amended dates are of an equal value and are available. You can make one (1) change to the date of your booking provided. Any change to booking dates is subject to availability. A service charge of $50 per booking will be applied to changes.\r\n13. Cancellations are permitted up to 60 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. The resort, facilities and dining are subject to government regulations and restrictions.\r\n16. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. A 2.5% booking fee applies.',10),(449,'2020-08-01 00:00:00','2020-08-05 00:00:00','Hot Deal',254,'No','Direct','Approved','Welcome Gift Pack on Arrival','30','Sea World Entry @ $99 per adult / $89 per child','198','Paradise Country Entry @ $44 per adult / $34 per child','88','','','','','1 - 31 August 2020','','','','','','','','Includes Unlimited entry to Sea World & Paradise Country<p>\r\n\r\nNormal rates based on travel 24 - 27 Aug 2020<br>\r\nResort Double - $235 <br>\r\nResort Queen - $260 <br>\r\nDeluxe Double - $260 <br>\r\nDeluxe Studio - $285 <br>\r\nPremium Double - $285 <br>\r\nPremium Double View - $310 <br>\r\nPremium Queen - $310 <br>\r\nPremium Queen View - $335 <br>\r\nPremium King View - $310 <p>','1. Valid for stays up to 31 August 2020 (subject to availability).\r\n2. A $30 surcharge applies on Saturday nights.\r\n3. Payment required in full by credit card at time of booking.\r\n4. 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.\r\n5. The special is valid for 2 people.\r\n6. Maximum room capacity is 4 or 5 people depending on room type selected.\r\n7. Extra person rate is $25 per person including theme park admission.\r\n8. A surcharge of $85 per person per night applies for 5th person which includes a rollaway bed and theme park admission.\r\n9. A two night minimum stay may apply on some dates.\r\n10. Please note all advertised pricing is in AUD (Australian Dollars).\r\n11. A 2.5% booking fee applies.',64),(448,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',9393,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','23 Dec 2020 - 06 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $32 per night nett.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\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.  \r\n3. The travel period has black-out dates: 10 Sep - 10 Oct 2020 & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom LUXE Ocean view & 4 people in a 2 Bedroom LUXE Pool Deck. \r\n8. Maximum room capacity is 4 people.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \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.\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.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(447,'2020-08-01 00:00:00','2020-08-05 00:00:00','Hot Deal',254,'No','Direct','Approved','Welcome Gift Pack on Arrival','30','Sea World Entry @ $99 per adult / $89 per child','198','Paradise Country Entry @ $44 per adult / $34 per child','88','','','','','1 - 31 August 2020','','','','','','','','Includes Unlimited entry to Sea World & Paradise Country<p>\r\n\r\nNormal rates based on travel 24 - 27 Aug 2020<br>\r\nResort Double - $235 <br>\r\nResort Queen - $260 <br>\r\nDeluxe Double - $260 <br>\r\nDeluxe Studio - $285 <br>\r\nPremium Double - $285 <br>\r\nPremium Double View - $310 <br>\r\nPremium Queen - $310 <br>\r\nPremium Queen View - $335 <br>\r\nPremium King View - $310 <p>','1. Valid for stays up to 31 August 2020 (subject to availability).\r\n2. A $30 surcharge applies on Saturday nights.\r\n3. Payment required in full by credit card at time of booking.\r\n4. 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.\r\n5. The special is valid for 2 people.\r\n6. Maximum room capacity is 4 or 5 people depending on room type selected.\r\n7. Extra person rate is $25 per person including theme park admission.\r\n8. A surcharge of $85 per person per night applies for 5th person which includes a rollaway bed and theme park admission.\r\n9. A two night minimum stay may apply on some dates.\r\n10. Please note all advertised pricing is in AUD (Australian Dollars).\r\n11. A 2.5% booking fee applies.',10),(446,'2020-08-06 00:00:00','2020-08-20 00:00:00','Hot Deal',254,'No','SiteMinder','Approved','Grab \'n\' Go Breakfast for 4 people daily @ $15 per adult / $10 per child','50','Bottle of Sparkling Wine on Arrival','30','Unlimited Entry to Movie World, Sea World, Wet\'n\'Wild and Paradise Country @ $148pp (3 theme park pass)','592','Paradise Country Entry @ $44 per adult / $34 per child','156','','','6 August - 11 December 2020<br>\r\n(6 Aug - 18 Sep & 12 Oct - 11 Dec 2020)','','19 September - 11 October 2020','','','','','','Normal rates based on travel 24 - 27 Aug / 19 - 22 Sep 2020<br>\r\nResort Double - $235 / $310 <br>\r\nResort Queen - $260 / $335 <br>\r\nDeluxe Double - $260 / $335 <br>\r\nDeluxe Studio - $285 / $360 <br>\r\nPremium Double - $285 / $360 <br>\r\nPremium Double View - $310 / $385 <br>\r\nPremium Queen - $310 / $385 <br>\r\nPremium Queen View - $335 / $410 <br>\r\nPremium King View - $310 / $385<p>','1. Valid for stays up to 11 December 2020 (subject to availability).\r\n2. A $30 surcharge applies on Saturday nights. A surcharge of $75 per night applies 19 Sep - 11 Oct 2020.\r\n3. Payment required in full by credit card at time of booking.\r\n4. 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.\r\n5. The special is valid for 4 people.\r\n6. Maximum room capacity is 4 or 5 people depending on room type selected.\r\n7. A surcharge of $75 per person per night applies for 5th person which includes a rollaway bed, breakfast and theme park admission.\r\n9. Please note all advertised pricing is in AUD (Australian Dollars).\r\n10. A 2.5% booking fee applies.',64),(445,'2020-08-06 00:00:00','2020-08-20 00:00:00','Hot Deal',254,'No','SiteMinder','Approved','Grab \'n\' Go Breakfast for 4 people daily @ $15 per adult / $10 per child','50','Bottle of Sparkling Wine on Arrival','30','Unlimited Entry to Movie World, Sea World, Wet\'n\'Wild and Paradise Country @ $148pp (3 theme park pass)','592','Paradise Country Entry @ $44 per adult / $34 per child','156','','','6 August - 11 December 2020<br>\r\n(6 Aug - 18 Sep & 12 Oct - 11 Dec 2020)','','19 September - 11 October 2020','','','','','','Normal rates based on travel 24 - 27 Aug / 19 - 22 Sep 2020<br>\r\nResort Double - $235 / $310 <br>\r\nResort Queen - $260 / $335 <br>\r\nDeluxe Double - $260 / $335 <br>\r\nDeluxe Studio - $285 / $360 <br>\r\nPremium Double - $285 / $360 <br>\r\nPremium Double View - $310 / $385 <br>\r\nPremium Queen - $310 / $385 <br>\r\nPremium Queen View - $335 / $410 <br>\r\nPremium King View - $310 / $385<p>','1. Valid for stays up to 11 December 2020 (subject to availability).\r\n2. A $30 surcharge applies on Saturday nights. A surcharge of $75 per night applies 19 Sep - 11 Oct 2020.\r\n3. Payment required in full by credit card at time of booking.\r\n4. 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.\r\n5. The special is valid for 4 people.\r\n6. Maximum room capacity is 4 or 5 people depending on room type selected.\r\n7. A surcharge of $75 per person per night applies for 5th person which includes a rollaway bed, breakfast and theme park admission.\r\n9. Please note all advertised pricing is in AUD (Australian Dollars).\r\n10. A 2.5% booking fee applies.',10),(444,'2020-08-11 00:00:00','2020-09-01 00:00:00','Flash Sale',9372,'No','Direct','Completed','Bottle of sparkling wine on arrival','20','Midday check out (Subject to availability)','50','1 adult ticket for a selected sunset cruise (Valid for stays completed by 23 December 2020 only)','40','','','','','11 Aug 2020 - 13 Jun 2021<br>\r\n(11 Aug - 22 Dec 2020, 7 Jan - 1 Apr, 6 Apr - 13 Jun 2021)','23 Dec 2020 - 6 Jan, 2 - 5 Apr 2021','23 Dec 2020 - 6 Jan 2021','','','','','','Voucher Redemption: 11.08.20 â€“ 15.09.2020\r\n\r\n1 adult ticket for a selected sunset cruise when booked via our onsite tour desk. Valid for stays completed by 23 December 2020 only\r\n\r\nChristmas/New Year surcharge for stays 23 Dec 2020 to 6 Jan 2021 inclusive. $32 per night nett.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 01 September 2020.\r\n2. Valid for travel from 11 August 2020 to 13 June 2021. Low season travel dates: 11 Aug - 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.  \r\n3. The travel period has black-out dates: 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 15 September 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a Tropical or Club Studio. \r\n8. Maximum room capacity is 3 people in a Tropical or Club Studio.\r\n9. Extra person charge is $46 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. 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.\r\n13. 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.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Offer inclusions: Adult ticket for selected sunset cruise is only valid for stays completed by 23 December 2020 only.\r\n17. Please note all advertised pricing is in AUD (Australian Dollars).\r\n18. A 2.5% booking fee applies.',10),(443,'2020-07-28 00:00:00','2020-08-12 00:00:00','Flash Sale',13352,'No','Direct','Completed','1 x $50 resort voucher per stay','50','Free use of non-motorised sports','','','','','','','','29 Jul 2020 - 20 Dec 2021','20 Dec 2020 - 10 Jan 2021, 02 - 05 Apr 2021','','','','','','','-STAY 3 PAY 2 OFFER\r\n-Voucher redemption period: 28 JUL - 25 AUG\r\n-Free use of non-motorised sports including kayaks, snorkelling & tennis','1. This special is available for purchase until 5.00pm (AEST) Wednesday 12 August 2020.\r\n2. Valid for travel from 29 July 2020 to 20 December 2021.\r\n3. The travel period has black-out dates: 20 Dec 2020 - 10 Jan & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 25 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a Beachfront Villa or in a Oceanview/Serenity/Beachfront Bure. \r\n8. Maximum room capacity is 2 people in a Beachfront Villa or in a Oceanview/Serenity/Beachfront Bure. \r\n9. Getting to Palm Bay, Long Island: Guests will need to contact Island Transfers directly for rates/bookings for transfers to the island \r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. 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.\r\n13. 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.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(442,'2020-07-21 00:00:00','2020-08-04 00:00:00','Flash Sale',318,'No','Direct','Completed','Free pool towels 1 per guest per stay','10','Free parking','','Free Wifi','','20% discount at Freddy Fuddpuckers CafÃ© Coolum','','','','18 September - 01 October 2020\r\n','','','','','','','','\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 04 August 2020.\r\n2. Valid for travel from 18 September to 01 October 2020.\r\n3. Your booking must be confirmed by 04 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. A voucher will be sent to you by email on confirmation of payment.\r\n6. The special is valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom or 6 people in a 3 Bedroom. \r\n7. Maximum room capacity is 2 people in a 1 Bedroom, 5 people in a 2 Bedroom or 7 people in a 3 Bedroom.\r\n8. Extra person charge is $34 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \r\n11. Changes are permitted up to 14 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.\r\n12. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. A security bond of $150 per apartment is required upon check-in and $250 per villa. \r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(441,'2020-07-21 00:00:00','2020-08-31 00:00:00','Flash Sale',153,'No','SiteMinder','Completed','2 for 1 Whale Watch Cruise with Whales in Paradise for adults + $20 discount for children ','49','25% Off Game Over adventures including Go Karting, Rock Climbing, Lazer Tag & MORE!','','','','','','','','21 July 2020 - 30 June 2021\r\n(21 Jul - 25 Sep, 06 - 29 Oct, 02 - 06 Nov, 08 - 13 Nov, 15 - 18 Nov, 07 - 24 Dec 2020 & 27 Jan - 30 Jun 2021)','26 Sep - 05 Oct, 30 Oct - 01 Nov, 07 Nov, 14 Nov, 19 Nov - 06 Dec, 25 Dec 2020 - 26 Jan 2021 \r\n','',' \r\n','','','','','','1. This special is available for purchase until 5.00pm (AEST) Monday 31 August 2020.\r\n2. Valid for travel from 21 July 2020 to 30 June 2021.\r\n3. The travel period has black-out dates: 26 Sep - 05 Oct, 30 Oct - 01 Nov, 07 Nov, 14 Nov, 19 Nov - 06 Dec & 25 Dec 2020 - 26 Jan 2021..\r\n4. Your booking must be confirmed by 31 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 4 people in a 2 Bedroom. \r\n8. Maximum room capacity is 5 people in a 2 Bedroom.\r\n9. Extra person charge is $50 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.\r\n\r\n<b>Other Terms & Conditions</b>\r\n1. Please refer to the individual tour / attraction Terms & Conditions on the Holiday Voucher attached to your booking confirmation.\r\n\r\n** Please download your Holiday Voucher from your Hightide account. Your log in details will be sent upon completion of your holiday booking and your voucher will be available under â€˜download vouchersâ€™',64),(440,'2020-07-28 00:00:00','2020-08-12 00:00:00','Flash Sale',13352,'No','Direct','Completed','1 x $50 resort voucher per stay','50','Free use of non-motorised sports','','','','','','','','29 Jul 2020 - 20 Dec 2021','20 Dec 2020 - 10 Jan 2021, 02 - 05 Apr 2021','','','','','','','-STAY 3 PAY 2 OFFER\r\n-Voucher redemption period: 28 JUL - 25 AUG\r\n-Free use of non-motorised sports including kayaks, snorkelling & tennis','1. This special is available for purchase until 5.00pm (AEST) Wednesday 12 August 2020.\r\n2. Valid for travel from 29 July 2020 to 20 December 2021.\r\n3. The travel period has black-out dates: 20 Dec 2020 - 10 Jan & 02 - 05 Apr 2021. \r\n4. Your booking must be confirmed by 25 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a Beachfront Villa or in a Oceanview/Serenity/Beachfront Bure. \r\n8. Maximum room capacity is 2 people in a Beachfront Villa or in a Oceanview/Serenity/Beachfront Bure. \r\n9. Getting to Palm Bay, Long Island: Guests will need to contact Island Transfers directly for rates/bookings for transfers to the island \r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. 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.\r\n13. 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.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(439,'2019-11-06 00:00:00','2019-11-19 00:00:00','Flash Sale',153,'No','SiteMinder','Pending','Buy 1 Get 1 Free Breakfast at Nosh Pan Asian','','Buy 1 Get 1 Free Dinner at Fables Restaurant','','endota Spa Voucher','25','Dolphin & Whale Watch Cruise','80','2 x $30 Watersports Vouchers','60','10 November 2019 - 31 July 2020 <br>\r\n(10 - 29 Nov, 1 - 5 Dec 2019, 28 Jan - 8 Apr, 20 Apr - 26 Jun & 13 - 31 Jul 2020','30 Nov, 6 Dec 2019 - 27 Jan, 9 - 19 Apr & 27 Jun - 12 Jul 2020. Additional black-out dates 15 - 30 Nov in 2 Bedroom / 1 Bathroom and 3 Bedroom Apartments.','','','','','','','Entertainment Book included in value<br>\r\nValues based on dinner per day of stay & one breakfast per stay<br>\r\n2 Bedroom - 4ads for breakfast & dinner<br>\r\n3 Bedroom - 4ads for breakfast & dinner','1. This special is available for purchase until 5.00pm (AEST) Tuesday 19 November 2019.\r\n2. Valid for travel from 10 November 2019 to 31 July 2020.\r\n3. The travel period has black-out dates: 30 Nov, 6 Dec 2019 - 27 Jan, 9 - 19 Apr & 27 Jun - 12 Jul 2020. Additional black-out dates 15 - 30 Nov in 2 Bedroom / 1 Bathroom and 3 Bedroom Apartments.\r\n4. Your booking must be confirmed by 3 December 2019. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The voucher is valid for up to 4 people in a 2 Bedroom or 6 people in a 3 Bedroom.\r\n8. Maximum room capacity is 5 people in a 2 Bedroom or 7 people in a 3 Bedroom.\r\n9. Extra person charge is $40 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. 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.\r\n12. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n13. Please note all advertised pricing is in AUD (Australian Dollars).\r\n14. A 2.5% booking fee applies.\r\n15. The Entertainment Book is for Gold Coast & Northern NSW discounts and is valid until 30 June 2020. The Book can be collected from Mantra Towers of Chevron reception upon check-in.\r\n16. Please note: from 16 November to 30 November (inclusive) the Schoolies Festival is on in Surfers Paradise and Mantra Towers of Chevron is an official Schoolies Hotel. Schoolies House Rules & a No Party Policy will apply for all bookings.\r\n<p>\r\n<b>Nosh Pan Asian Terms & Conditions</b> (Mantra on View)\r\n1. Buffet Breakfast cost is $25 for adults, children 0 - 4 years are free of charge and 5 - 12 years are $14.00.\r\n3. Voucher must be shown on arrival at restaurant to receive the discount.\r\n4. It is a one off use and voucher will be collected.\r\n5. Valid only for guests during the period staying at the resort.\r\n<p>\r\n<b>Fables Restaurant Terms & Conditions</b> (Mantra Legends)\r\n1. Seafood Buffet Dinner cost is $79 for adults, children are up to and including the age of 12 years and are charged $1 per year of age to dine.\r\n2. Discount applies to any number of adults, not just multiples of 2.\r\n3. Voucher must be shown on arrival at restaurant to receive the discount.\r\n4. The discount can be used multiple times.\r\n5. Valid only for guests during the period staying at the resort.\r\n6. Surcharges apply to credit card transactions and on public holidays.\r\n7. Not valid on special event dinners.\r\n<p>\r\n<b>Other Terms & Conditions</b>\r\n1. Please refer to the individual tour / attraction Terms & Conditions on the Holiday Voucher attached to your booking confirmation.\r\n2. Gold Coast Watersports Discount Voucher requires a minimum spend of $100 per voucher.\r\n\r\n<b>** Please login to download your Holiday Vouchers</b>',10),(438,'2020-07-21 00:00:00','2020-08-04 00:00:00','Flash Sale',318,'Yes','Direct','Completed','Free pool towels 1 per guest per stay','10','Free parking','','Free Wifi','','20% discount at Freddy Fuddpuckers CafÃ© Coolum','','My DQ card','199','18 September - 01 October 2020\r\n','','','','','','','','Includes value of MyDQ Card\r\n\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 04 August 2020.\r\n2. Valid for travel from 18 September to 01 October 2020.\r\n3. Your booking must be confirmed by 04 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. A voucher will be sent to you by email on confirmation of payment.\r\n6. The special is valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom or 6 people in a 3 Bedroom. \r\n7. Maximum room capacity is 2 people in a 1 Bedroom, 5 people in a 2 Bedroom or 7 people in a 3 Bedroom.\r\n8. Extra person charge is $34 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \r\n11. Changes are permitted up to 14 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.\r\n12. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. A security bond of $150 per apartment is required upon check-in and $250 per villa. \r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(437,'2020-07-21 00:00:00','2020-08-04 00:00:00','Flash Sale',2956,'No','Direct','Completed','Bottle of sparkling wine on arrival','30','Late checkout till 11am','20','','','','','','','01/08/20 â€“ 18/09/20, 05/10/20 - 10/10/20, 15/10/20 â€“ 30/11/20, 16/01/21 â€“ 31/03/21','19/09/20 - 04/10/20, 11/10/20 - 14/10/20, 01/12/20 - 15/01/21','','','','','','','Voucher redemption period until 18/08/20\r\nCan guarantee the late checkout of 11am.','1. This special is available for purchase until 5.00pm (AEST) Tuesday 04 August 2020.\r\n2. Valid for travel from 1 August 2020 to 31 March 2021.\r\n3. The travel period has black-out dates: 19 Sep - 04 Oct, 11 Oct - 14 Oct, 01 Dec 2020 - 15 Jan 2021. \r\n4. Your booking must be confirmed by 18 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Sunset or 4 people in a 2 Bedroom Ocean. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom Sunset or 5 people in a 2 Bedroom Ocean.\r\n9. Extra person charge is $30 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(436,'2020-07-21 00:00:00','2020-08-04 00:00:00','Flash Sale',2956,'No','Direct','Completed','Bottle of sparkling wine on arrival','30','Late checkout till 11am','20','','','','','','','01/08/20 â€“ 18/09/20, 05/10/20 - 10/10/20, 15/10/20 â€“ 30/11/20, 16/01/21 â€“ 31/03/21','19/09/20 - 04/10/20, 11/10/20 - 14/10/20, 01/12/20 - 15/01/21','','','','','','','Voucher redemption period until 18/08/20\r\nCan guarantee the late checkout of 11am.','1. This special is available for purchase until 5.00pm (AEST) Tuesday 04 August 2020.\r\n2. Valid for travel from 1 August 2020 to 31 March 2021.\r\n3. The travel period has black-out dates: 19 Sep - 04 Oct, 11 Oct - 14 Oct, 01 Dec 2020 - 15 Jan 2021. \r\n4. Your booking must be confirmed by 18 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom Sunset or 4 people in a 2 Bedroom Ocean. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom Sunset or 5 people in a 2 Bedroom Ocean.\r\n9. Extra person charge is $30 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',10),(435,'2020-07-14 00:00:00','2020-08-11 00:00:00','Flash Sale',304,'Yes','Direct','Completed','Late Check out - subject to availability â€“ not available if checking out on a Friday or Saturday','20','Bottle of Wine and Chocolates ','40','Free WIFI','','Free Car Parking','','My DQ card','199','Sunday to Thursday: 14 July 2020 to 31 March 2021<br>\r\n(14 Jul - 17 Sep, 12 Oct - 10 Dec 2020 & 26 Jan - 31 Mar 2021)','18 Sep - 11 Oct & 11 Dec 2020 - 25 Jan 2021','Includes Fri & Sat: 14 July 2020 to 31 March 2021<br>\r\n(14 Jul - 17 Sep, 12 Oct - 10 Dec 2020 & 26 Jan - 31 Mar 2021)','18 Sep - 11 Oct & 11 Dec 2020 - 25 Jan 2021','','','','','Weekend Surcharge NETT $40 per night (Friday and Saturday nights)\r\n\r\nVoucher redemption: 14.07.2020 â€“ 11.08.2020\r\n\r\n72 hour cancellation policy.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 28 July 2020.\r\n2. Valid for travel from 14 July 2020 to 31 March 2021. A $50 per night surcharge applies on Friday & Saturday nights.\r\n3. The travel period has black-out dates: 18 Sep - 11 Oct & 11 Dec 2020 - 25 Jan 2021.\r\n4. Your booking must be confirmed by 11 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom or 6 people in a 3 Bedroom. \r\n8. Maximum room capacity is 2 adults in a 1 Bedroom, 4 adults in a 2 Bedroom or 6 adults in a 3 Bedroom.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \r\n11. Changes are permitted up to 14 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.\r\n12. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n17. Late check-out is subject to availability and not available if checking out on a Friday or Saturday.',10),(434,'2020-07-14 00:00:00','2020-08-11 00:00:00','Flash Sale',304,'No','Direct','Completed','Late Check out - subject to availability â€“ not available if checking out on a Friday or Saturday','20','Bottle of Wine and Chocolates ','40','Free WIFI','','Free Car Parking','','','','Sunday to Thursday: 14 July 2020 to 31 March 2021<br>\r\n(14 Jul - 17 Sep, 12 Oct - 10 Dec 2020 & 26 Jan - 31 Mar 2021)','18 Sep - 11 Oct & 11 Dec 2020 - 25 Jan 2021','Includes Fri & Sat: 14 July 2020 to 31 March 2021<br>\r\n(14 Jul - 17 Sep, 12 Oct - 10 Dec 2020 & 26 Jan - 31 Mar 2021)','18 Sep - 11 Oct & 11 Dec 2020 - 25 Jan 2021','','','','','Weekend Surcharge NETT $40 per night (Friday and Saturday nights)\r\n\r\nVoucher redemption: 14.07.2020 â€“ 11.08.2020\r\n\r\n72 hour cancellation policy.\r\n','1. This special is available for purchase until 5.00pm (AEST) Tuesday 28 July 2020.\r\n2. Valid for travel from 14 July 2020 to 31 March 2021. A $50 per night surcharge applies on Friday & Saturday nights.\r\n3. The travel period has black-out dates: 18 Sep - 11 Oct & 11 Dec 2020 - 25 Jan 2021.\r\n4. Your booking must be confirmed by 11 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a 1 Bedroom, 4 people in a 2 Bedroom or 6 people in a 3 Bedroom. \r\n8. Maximum room capacity is 2 adults in a 1 Bedroom, 4 adults in a 2 Bedroom or 6 adults in a 3 Bedroom.\r\n9. Extra nights may be purchased at time of booking. \r\n10. Full payment is required at time of booking. \r\n11. Changes are permitted up to 14 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.\r\n12. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n17. Late check-out is subject to availability and not available if checking out on a Friday or Saturday.',64),(433,'2020-07-28 00:00:00','2020-08-11 00:00:00','Flash Sale',257,'Yes','Direct','Completed','Breakfast','38','My DQ card ','199','','','','','','','1 September 2020 - 31 March 2021\r\n\r\n','4 - 7 Sep, 12 - 14 Sep, 17 - 20 Sep, 25 - 26 Sep, 1 - 3 Oct, 15 - 17 Oct, 30 Oct, 13 - 14 Nov, 18 - 19 Nov, 26 - 27 Nov & 18 Dec 2020 - 10 Jan 2021.','','','','','','','Freesell from siteminder\r\n\r\nHotels cancelation is 48 hrs prior to check in \r\nOctober    1/2/3   15/16/17   \r\nDecember  19th\r\n','1. This special is available for purchase until 5.00pm (AEST) 11 August  2020.\r\n2. Valid for travel from 1 September 2020 to 31 March 2021\r\n3. The travel period has black-out dates: 4 - 7 Sep, 12 - 14 Sep, 17 - 20 Sep, 25 - 26 Sep, 1 - 3 Oct, 15 - 17 Oct, 30 Oct, 13 - 14 Nov, 18 - 19 Nov, 26 - 27 Nov & 18 Dec 2020 - 10 Jan 2021.\r\n4. Your booking must be confirmed by 11 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a Ocean View Twin room.\r\n8. Maximum room capacity is 4 people in a Ocean View Twin room.\r\n9. Extra adult charge is $25 per night or child (3-12 years) is $13 per night (using existing bedding).\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.\r\n',10),(432,'2020-07-28 00:00:00','2020-08-11 00:00:00','Flash Sale',257,'No','Direct','Completed','Breakfast','20','','','','','','','','','1 September 2020 - 31 March 2021','4 - 7 Sep, 12 - 14 Sep, 17 - 20 Sep, 25 - 26 Sep, 1 - 3 Oct, 15 - 17 Oct, 30 Oct, 13 - 14 Nov, 18 - 19 Nov, 26 - 27 Nov & 18 Dec 2020 - 10 Jan 2021.\r\n','','','','','','','Freesell from siteminder\r\n\r\nHotels cancelation is 48 hrs prior to check in \r\n','1. This special is available for purchase until 5.00pm (AEST) 11 August  2020.\r\n2. Valid for travel from 1 September 2020 to 31 March 2021\r\n3. The travel period has black-out dates: 4 - 7 Sep, 12 - 14 Sep, 17 - 20 Sep, 25 - 26 Sep, 1 - 3 Oct, 15 - 17 Oct, 30 Oct, 13 - 14 Nov, 18 - 19 Nov, 26 - 27 Nov & 18 Dec 2020 - 10 Jan 2021.\r\n4. Your booking must be confirmed by 11 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The special is valid for up to 2 people in a Ocean View Twin room.\r\n8. Maximum room capacity is 4 people in a Ocean View Twin room.\r\n9. Extra adult charge is $25 per night or child (3-12 years) is $13 per night (using existing bedding).\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64),(431,'2020-07-14 00:00:00','2020-07-29 00:00:00','Flash Sale',13358,'No','Direct','Completed','Free room upgrade (standard room to studio & family room to 2brm apartment)','188 & 448','Free late checkout (subject to availability)','50','$50 credit in Bayleaf Balinese Restaurant (per room)','50','Free Wifi & secure parking','','25% off Fitzroy Island day trip','33','14 Jul 2020 - 31 Mar 2021','31 Dec 2020','','','','','','','STAY 4 PAY 3\r\n\r\n25% off Fitzroy Island day trip - bookings done direct with hotel\r\n\r\nChildren Policy\r\nInfants 0-2 years inclusive are granted free of charge (FOC) accommodation using existing bedding only.\r\nChildren 3-12 years inclusive will be charged as extra person.\r\nChildren breakfast rates: 0-4 years FOC. Children rates apply for age groups 5 to 12 years.\r\nChildrenâ€™s menu is also available.\r\n','1. This special is available for purchase until midnight (AEST) 29 July 2020.\r\n2. Valid for travel from 14 July 2020 to 31 March 2021. \r\n3. The travel period has black-out dates: 31 Dec 2020.\r\n4. Your booking must be confirmed by 12 August 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. This special is valid for up to 2 people in a Studio or 4 people in a 2 Bedroom.\r\n8. Maximum room capacity is 3 people in a Studio or 5 people in a 2 Bedroom.\r\n9. Extra person charge is $35 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking.\r\n9. Full payment is required at time of booking. \r\n11. Changes are permitted up to 14 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.\r\n12. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n13. We recommend taking out a travel insurance policy at the point of booking.\r\n14. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n15. Please note all advertised pricing is in AUD (Australian Dollars).\r\n16. A 2.5% booking fee applies.\r\n17. Bookings for the Fitzroy Island Day Trip are to be made direct with Bay Village Tropical Retreat.',64),(430,'2020-07-07 00:00:00','2020-08-04 00:00:00','Flash Sale',3898,'No','Direct','Completed','$30 Food & Beverage credit for 3 & 4 night stays','30','$80 Food & Beverage credit for 5+ night stays','80','11am late checkout ','20','1 x Club Turtle Kids session per child aged 4-12 years','50','','','8 Jul - 18 Sep, 11 Oct - 24 Nov 2020, 31 Jan - 31 Mar, 26 Apr - 26 Jun 2021\r\n','25 Nov 2020 - 30 Jan, 1 - 25 Apr 2021','19 Sep - 10 Oct 2020\r\n\r\n','','','','','','0-2 years FOC on existing bedding and 3 years + adult rates apply.\r\n\r\nThe late checkout is guaranteed\r\n\r\nClub Turtle Kids Club session is valued at $25 per child and yes all children aged 4-12 years listed receive the 1 x Kids Club voucher\r\n\r\n\r\n','1. This special is available for purchase until midnight (AEST) 04 August 2020.\r\n2. Valid for travel from 8 July 2020 to 26 June 2021. A surcharge applies 19 Sep - 10 Oct 2020.\r\n3. The travel period has black-out dates: 19 Sep - 10 Oct, 25 Nov 2020 - 30 Jan & 01 - 25 Apr 2021.\r\n4. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n5. This special is valid for up to 4 people in a 2 Bedroom or 2 Bedroom Superior & up to 6 people in a 2 Bedroom Family.\r\n6. Maximum room capacity is 5 people in a 2 Bedroom or 2 Bedroom Superior & 6 people in a 2 Bedroom Family.\r\n7. Extra person charge is $42 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n8. Extra nights may be purchased at time of booking at the same per night price.\r\n9. Full payment is required at time of booking. \r\n10. Changes are permitted up to 14 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.\r\n11. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n12. We recommend taking out a travel insurance policy at the point of booking.\r\n13. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n14. Please note all advertised pricing is in AUD (Australian Dollars).\r\n15. A 2.5% booking fee applies.\r\n\r\n',64),(429,'2020-07-02 00:00:00','2020-07-31 00:00:00','Flash Sale',3008,'No','SiteMinder','Completed','','','','','','','','','','','01 July 2020 to 31 May 2021<br>\r\n(01 July - 10 Sep, 14 Sep - 25 Sep, 11 Oct - 10 Dec 2020, 27 Jan - 11 Mar, 15 Mar - 01 Apr, 26 Apr - 30 Apr, 03 - 31 May 2021)','11 Sep - 13 Sep, 26 Sep - 10 Oct, 11 Dec - 26 Jan, 12 Mar - 14 Mar, 02 Apr - 25 Apr, 01 May - 02 May 2021','','','','','','','','1. This special is available for purchase until 5.00pm (AEST) Friday 31 July 2020.\r\n2. Valid for travel from 01 July 2020 to 31 May 2021.\r\n3. The travel period has black-out dates: 11 - 13 Sep, 26 Sep - 10 Oct, 11 Dec 2020 - 26 Jan, 12 - 14 Mar, 2 - 25 Apr & 1 - 2 May 2021. \r\n4. Your booking must be confirmed by 31 July 2020. If your booking is not confirmed you will forfeit the purchase price.\r\n5. Bookings are essential and subject to availability. To book your stay call us or book online.\r\n6. A voucher will be sent to you by email on confirmation of payment.\r\n7. The voucher is valid for up to 2 people in a 1 Bedroom or 4 people in a 2 Bedroom. \r\n8. Maximum room capacity is 3 people in a 1 Bedroom or 5 people in a 2 Bedroom.\r\n9. Extra person charge is $44 per night. Infants (0-2 years) stay free of charge using existing bedding.\r\n10. Extra nights may be purchased at time of booking. \r\n11. Full payment is required at time of booking. \r\n12. Changes are permitted up to 14 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.\r\n13. Cancellations are permitted up to 14 days prior to travel and will incur a $50 per adult cancellation fee in addition to any supplier fees.\r\n14. We recommend taking out a travel insurance policy at the point of booking.\r\n15. This offer cannot be used in conjunction with any other offer or combined with any other form of discount or membership.\r\n16. Please note all advertised pricing is in AUD (Australian Dollars).\r\n17. A 2.5% booking fee applies.',64);

--
-- Table structure for table `opportunityrooms`
--

CREATE TABLE `opportunityrooms` (
  `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',
  `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',
  `opportunity_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18481 DEFAULT CHARSET=latin1;

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

INSERT INTO `opportunityrooms` VALUES (18480,'5 Bedroom House',7,10,0,6283.00,20.05,7859.00,897.60,0.00,0.00,9240.00,'','','','','','',4,20,478),(18479,'5 Bedroom House',4,10,0,3590.00,20.03,4489.00,897.60,0.00,0.00,5280.00,'','','','','','',4,19,478),(18478,'5 Bedroom House',7,10,0,4512.00,19.41,5599.00,644.64,0.00,0.00,6636.00,'','','','','','',3,14,478),(18477,'5 Bedroom House',4,10,0,2579.00,19.38,3199.00,644.64,0.00,0.00,3792.00,'','','','','','',3,13,478),(18476,'5 Bedroom House',7,10,0,3142.00,19.42,3899.00,448.80,0.00,0.00,4620.00,'','','','','','',2,8,478),(18475,'5 Bedroom House',4,10,0,1795.00,20.19,2249.00,448.80,0.00,0.00,2640.00,'','','','','','',2,7,478),(18474,'5 Bedroom House',7,10,0,2171.00,19.56,2699.00,310.08,0.00,0.00,3192.00,'','','','','','',1,2,478),(18473,'5 Bedroom House',4,10,0,1240.00,19.95,1549.00,310.08,0.00,0.00,1824.00,'','','','','','',1,1,478),(18472,'4 Bedroom House',7,8,0,8568.00,19.77,10679.00,1224.00,0.00,0.00,12600.00,'','','','','','',4,20,477),(18471,'4 Bedroom House',4,8,0,4896.00,19.72,6099.00,1224.00,0.00,0.00,7200.00,'','','','','','',4,19,477),(18470,'4 Bedroom House',7,8,0,5969.00,19.98,7459.00,852.72,0.00,0.00,8778.00,'','','','','','',3,14,477),(18469,'4 Bedroom House',4,8,0,3411.00,19.91,4259.00,852.72,0.00,0.00,5016.00,'','','','','','',3,13,477),(18468,'4 Bedroom House',7,8,0,3834.00,18.93,4729.00,546.72,0.00,0.00,5628.00,'','','','','','',2,8,477),(18467,'4 Bedroom House',4,8,0,2187.00,18.97,2699.00,546.72,0.00,0.00,3216.00,'','','','','','',2,7,477),(18466,'4 Bedroom House',7,8,0,2856.00,18.38,3499.00,408.00,0.00,0.00,4200.00,'','','','','','',1,2,477),(18465,'4 Bedroom House',4,8,0,1632.00,18.36,1999.00,408.00,0.00,0.00,2400.00,'','','','','','',1,1,477),(18464,'5 Bedroom House',7,12,0,8568.00,19.92,10699.00,1224.00,0.00,0.00,12600.00,'','','','','','',4,20,475),(18463,'5 Bedroom House',4,12,0,4896.00,19.72,6099.00,1224.00,0.00,0.00,7200.00,'','','','','','',4,19,475),(18462,'5 Bedroom House',7,12,0,5969.00,19.98,7459.00,852.72,0.00,0.00,8778.00,'','','','','','',3,14,475),(18461,'5 Bedroom House',4,12,0,3410.00,19.93,4259.00,852.72,0.00,0.00,5016.00,'','','','','','',3,13,475),(18460,'5 Bedroom House',7,12,0,4455.00,18.99,5499.00,636.48,0.00,0.00,6552.00,'','','','','','',2,8,475),(18459,'5 Bedroom House',4,12,0,2546.00,17.84,3099.00,636.48,0.00,0.00,3744.00,'','','','','','',2,7,475),(18458,'5 Bedroom House',7,12,0,3369.00,19.77,4199.00,481.25,0.00,0.00,4956.00,'','','','','','',1,2,475),(18457,'5 Bedroom House',4,12,0,1925.00,19.76,2399.00,481.25,0.00,0.00,2832.00,'','','','','','',1,1,475),(18456,'5 Bedroom House',7,14,0,8568.00,19.92,10699.00,1224.00,0.00,0.00,12600.00,'','','','','','',4,20,476),(18455,'5 Bedroom House',4,14,0,4896.00,19.72,6099.00,1224.00,0.00,0.00,7200.00,'','','','','','',4,19,476),(18454,'5 Bedroom House',7,14,0,5969.00,19.98,7459.00,852.72,0.00,0.00,8778.00,'','','','','','',3,14,476),(18453,'5 Bedroom House',4,14,0,3410.00,19.93,4259.00,852.72,0.00,0.00,5016.00,'','','','','','',3,13,476),(18452,'5 Bedroom House',7,14,0,4455.00,18.99,5499.00,636.48,0.00,0.00,6552.00,'','','','','','',2,8,476),(18451,'5 Bedroom House',4,14,0,2546.00,17.84,3099.00,636.48,0.00,0.00,3744.00,'','','','','','',2,7,476),(18450,'5 Bedroom House',7,14,0,3369.00,19.77,4199.00,481.25,0.00,0.00,4956.00,'','','','','','',1,2,476),(18449,'5 Bedroom House',4,14,0,1925.00,19.76,2399.00,481.25,0.00,0.00,2832.00,'','','','','','',1,1,476),(18420,'Standard Twin Room - SALE',3,2,0,230.00,14.50,269.00,0.00,50.00,0.00,560.00,'','','','','','',1,2,473),(18419,'Executive King Room - SALE',3,2,0,230.00,14.50,269.00,0.00,50.00,0.00,560.00,'','','','','','',1,1,473),(18416,'Standard Twin Room - SALE',3,2,0,230.00,23.08,299.00,0.00,50.00,0.00,560.00,'','','','','','',1,2,474),(18415,'Executive King Room - SALE',3,2,0,230.00,23.08,299.00,0.00,50.00,0.00,560.00,'','','','','','',1,1,474),(18406,'2 Bedroom Superior - SALE',5,4,0,675.00,20.49,849.00,225.00,45.00,45.00,1465.00,'','','','','','',1,4,409),(18405,'2 Bedroom - SALE',5,4,0,630.00,20.15,789.00,210.00,45.00,45.00,1390.00,'','','','','','',1,3,409),(18404,'1 Bedroom Superior - SALE',5,2,0,525.00,20.33,659.00,175.00,45.00,45.00,1265.00,'','','','','','',1,2,409),(18403,'1 Bedroom - SALE',5,2,0,480.00,19.87,599.00,160.00,45.00,45.00,1014.00,'','','','','','',1,1,409),(18402,'2 Bedroom Superior - SALE',5,4,0,675.00,9.88,749.00,225.00,45.00,45.00,1465.00,'','','','','','',1,4,424),(18401,'2 Bedroom - SALE',5,4,0,630.00,9.87,699.00,210.00,45.00,45.00,1390.00,'','','','','','',1,3,424),(18400,'1 Bedroom Superior - SALE',5,2,0,525.00,10.87,589.00,175.00,45.00,45.00,1265.00,'','','','','','',1,2,424),(18399,'1 Bedroom - SALE',5,2,0,480.00,10.95,539.00,160.00,45.00,45.00,1014.00,'','','','','','',1,1,424),(18394,'1 Bedroom Apartment - 7 NIGHT XMAS SALE',7,2,0,973.00,9.82,1079.00,139.00,36.90,36.90,1615.00,'','','','','','',2,8,454),(18393,'Studio - 7 NIGHT XMAS SALE',7,2,0,721.00,9.76,799.00,103.00,0.00,0.00,1405.00,'','','','','','',2,7,454),(18392,'1 Bedroom Apartment - 7 NIGHT SALE',7,2,0,749.00,9.65,829.00,107.00,36.90,36.90,1654.00,'','','','','','',1,2,454),(18391,'Studio - 7 NIGHT SALE',7,2,0,497.00,9.47,549.00,71.00,0.00,0.00,1402.00,'','','','','','',1,1,454),(18390,'1 Bedroom Apartment - 7 NIGHT XMAS SALE',7,2,0,973.00,18.85,1199.00,139.00,36.90,36.90,1615.00,'','','','','','',2,8,448),(18389,'Studio - 7 NIGHT XMAS SALE',7,2,0,721.00,19.80,899.00,103.00,0.00,0.00,1405.00,'','','','','','',2,7,448);

--
-- Table structure for table `outgoing_mail`
--

CREATE TABLE `outgoing_mail` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `from_name` varchar(200) NOT NULL,
  `from_email` varchar(200) NOT NULL,
  `to_name` varchar(200) NOT NULL,
  `to_email` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `comment_id` int(10) NOT NULL DEFAULT '0',
  `enquiry_id` int(10) NOT NULL DEFAULT '0',
  `response_id` int(10) NOT NULL DEFAULT '0',
  `distribution_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=67704 DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `outlets`
--

CREATE TABLE `outlets` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `region` varchar(200) DEFAULT NULL,
  `suburb` varchar(200) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `post_code` varchar(200) DEFAULT NULL,
  `phone_1` varchar(200) DEFAULT NULL,
  `phone_2` varchar(200) DEFAULT NULL,
  `fax` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `descr` text,
  `web` varchar(200) DEFAULT NULL,
  `benefit_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `benefit_id` (`benefit_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3672599 DEFAULT CHARSET=latin1;

--
