CREATE TABLE `staypay` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `StayNights` tinyint(4) unsigned DEFAULT '0',
  `PayNights` tinyint(4) unsigned DEFAULT '0',
  `Frequency` tinyint(4) unsigned DEFAULT '0',
  `RoomsID` int(11) unsigned DEFAULT NULL,
  `SeasonsID` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `RoomsID` (`RoomsID`),
  KEY `SeasonsID` (`SeasonsID`)
) ENGINE=MyISAM AUTO_INCREMENT=2985 DEFAULT CHARSET=latin1;

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

INSERT INTO `staypay` VALUES (2984,5,4,1,12974,5977),(2983,5,4,1,12973,5977),(2982,5,4,1,35290,6011),(2981,5,4,1,35289,6011),(2980,5,4,1,35288,6011),(2979,4,3,2,342,6010),(2978,4,3,2,341,6010),(2977,4,3,2,12833,6010),(2976,4,3,2,340,6010),(2975,4,3,2,339,6010),(2974,4,3,2,12288,6010),(2973,4,3,2,338,6010),(2972,4,3,2,337,6010),(2971,4,3,2,336,6010),(2970,4,3,2,12842,6010),(2969,4,3,2,335,6010),(2968,4,3,2,334,6010),(2967,4,3,2,333,6010),(2966,4,3,2,332,6010),(2965,3,2,1,280,4737),(2962,3,2,1,34732,5834),(2961,3,2,1,34732,5835),(2957,5,4,1,35082,5409),(2956,5,4,1,35082,5408),(2955,7,5,1,10501,6001),(2954,4,3,1,10501,6001),(2953,7,5,1,31305,6001),(2952,4,3,1,31305,6001),(2951,7,5,1,10500,6001),(2950,4,3,1,10500,6001),(2949,7,5,1,10499,6001),(2948,4,3,1,10499,6001),(2935,3,2,1,34949,5981),(2934,3,2,1,34948,5981),(2933,3,2,1,34947,5981),(2895,5,4,1,430,5913),(2894,5,4,1,13038,5908),(2893,5,4,1,13034,5908),(2892,5,4,1,1062,5906),(2891,5,4,1,1061,5906),(2890,5,4,1,957,5903),(2889,5,4,1,956,5903),(2888,5,4,1,955,5903),(2887,4,3,1,34653,5882),(2886,4,3,1,34652,5882),(2885,4,3,1,34651,5882),(2884,4,3,1,34650,5882),(2883,4,3,1,34649,5882),(2882,5,4,1,34633,5877),(2881,5,4,1,34633,5876);

--
-- Table structure for table `subregions`
--

CREATE TABLE `subregions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `RegionsID` int(11) unsigned DEFAULT NULL,
  `Name` varchar(80) DEFAULT NULL,
  `file_name` varchar(200) NOT NULL,
  `brief_descr` text,
  `descr` text,
  `longitude` decimal(11,7) DEFAULT NULL,
  `latitude` decimal(11,7) DEFAULT NULL,
  `map_zoom` int(10) DEFAULT NULL,
  `external_id` varchar(10) NOT NULL,
  `viator_external_id` int(10) NOT NULL DEFAULT '0',
  `property_count` int(10) NOT NULL DEFAULT '0',
  `SOrder` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `RegionsID` (`RegionsID`),
  KEY `file_name` (`file_name`)
) ENGINE=MyISAM AUTO_INCREMENT=815 DEFAULT CHARSET=latin1;

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

INSERT INTO `subregions` VALUES (814,8,'Miami','miami','','',153.4369000,28.0672000,0,'',0,1,0),(813,8,'Currumbin','currumbin','','',153.4871000,28.1277000,0,'',0,2,0),(812,8,'Robina','robina','','',0.0000000,0.0000000,0,'',0,1,0),(811,477,'Istanbul','istanbul','','',0.0000000,0.0000000,7,'',0,0,0),(810,478,'Gallipoli','Gallipoli','','',0.0000000,0.0000000,7,'',0,1,0),(809,472,'Rio de Janeiro','rio-de-janeiro','','',0.0000000,0.0000000,7,'',0,0,0),(808,449,'Kingscliff','kingscliff','Kingscliff is a seaside town just south of Tweed Heads on the far North Coast of New South Wales (also known as Queensland-extended). Together with the villages of Chinderah and Fingal, it is a tourist destination that provides beach and estuary access for swimming, surfing, fishing and water sports.','The Kingscliff coastline consists of a series of golden beaches cradled between headlands in our extended version of Queensland (also known as the north coast of NSW). There are world-class surf breaks and a reef break on the southern edge of Kingscliff. This region lies in close proximity to the Tweed Valley, the crater of a huge extinct volcano, now carpeted with a vivid green tapestry of farms and rainforest. The New Tweed Coast is just a 15-minute drive from the Gold Coast Airport, which makes this an ideal choice for a short break. Endowed with attractive street landscaping and some excellent cafes and restaurants, Kingscliff is becoming known as a gourmet destination.',153.5746190,-28.2543420,0,'',0,0,0),(807,20,'Mallacoota','Mallacoota','','',0.0000000,0.0000000,0,'',0,1,0),(806,60,'Hastings','Hastings','','',0.0000000,0.0000000,0,'',0,1,0),(805,28,'Bridgetown','','','',0.0000000,0.0000000,0,'',0,1,0),(804,446,'Dubrovnik','dubrovnik','','',0.0000000,0.0000000,7,'',0,1,0),(803,447,'Split','split','','',0.0000000,0.0000000,7,'',0,0,0),(802,448,'Zagreb','zagreb','','',0.0000000,0.0000000,7,'',0,0,0),(801,414,'Thimphu','thimphu','','',0.0000000,0.0000000,7,'',0,1,0),(800,413,'Paro','paro','','',0.0000000,0.0000000,7,'',0,0,0),(799,412,'Bora Bora','bora-bora','','',0.0000000,0.0000000,7,'',0,0,0),(798,411,'Moorea','moorea','','',0.0000000,0.0000000,7,'',0,0,0),(797,411,'Tahiti','tahiti','','',0.0000000,0.0000000,7,'',0,1,0),(796,407,'Lifou','lifou','','',0.0000000,0.0000000,7,'',0,0,0),(795,406,'Anse Vata','anse-vata','','',0.0000000,0.0000000,7,'',0,1,0),(794,406,'Noumea','noumea','','',0.0000000,0.0000000,7,'',0,0,0),(793,399,'Sihanoukville','sihanoukville','','',0.0000000,0.0000000,7,'',0,0,0),(792,382,'Phnom Penh','Phnom Penh','','',0.0000000,0.0000000,7,'',0,0,0),(791,381,'New Delhi','new-delhi','','',0.0000000,0.0000000,7,'',0,2,0),(790,378,'Agra','agra','','',0.0000000,0.0000000,7,'',0,0,0),(789,380,'Kolkata','Kolkata','','',0.0000000,0.0000000,7,'',0,0,0),(788,379,'Dehradun','dehradun','','',0.0000000,0.0000000,7,'',0,0,0),(787,378,'Kanpur','kanpur','','',0.0000000,0.0000000,7,'',0,0,0),(786,378,'Lucknow','lucknow','','',0.0000000,0.0000000,7,'',0,0,0),(785,377,'Agartala','agartala','','',0.0000000,0.0000000,7,'',0,0,0),(784,376,'Hyderabad','hyderabad','','',0.0000000,0.0000000,0,'',0,0,0),(783,375,'Chennai','chennai','','',0.0000000,0.0000000,7,'',0,0,0),(782,374,'Gangtok','gangtok','','',0.0000000,0.0000000,7,'',0,0,0),(781,373,'Jaipur','jaipur','','',0.0000000,0.0000000,7,'',0,0,0),(780,372,'Chandigarh','chandigarh','','',0.0000000,0.0000000,7,'',0,0,0),(779,372,'Ludhiana','ludhiana','','',0.0000000,0.0000000,7,'',0,0,0),(778,371,'Bhubaneswar','bhubaneswar','','',0.0000000,0.0000000,7,'',0,0,0),(777,370,'Dimapur','dimapur','','',0.0000000,0.0000000,7,'',0,0,0),(776,370,'Kohima','kohima','','',0.0000000,0.0000000,7,'',0,0,0),(775,369,'Aizawl','Aizawl','','',0.0000000,0.0000000,7,'',0,0,0),(774,368,'Shillong','shillong','','',0.0000000,0.0000000,7,'',0,0,0),(773,367,'Imphal','imphal','','',0.0000000,0.0000000,7,'',0,0,0),(772,366,'Mumbai','mumbai','','',0.0000000,0.0000000,7,'',0,0,0),(771,365,'Indore','indore','','',0.0000000,0.0000000,7,'',0,0,0),(770,364,'Kochi','kochi','','',0.0000000,0.0000000,7,'',0,0,0),(769,365,'Bhopal','bhopal','','',0.0000000,0.0000000,7,'',0,0,0),(768,364,'Thiruvananthapuram','thiruvananthapuram','','',0.0000000,0.0000000,7,'',0,0,0),(767,363,'Bangalore','bangalore','','',0.0000000,0.0000000,7,'',0,0,0),(766,362,'Jamshedpur','jamshedpur','','',0.0000000,0.0000000,7,'',0,0,0),(765,362,'Ranchi','ranchi','','',0.0000000,0.0000000,7,'',0,0,0);

--
-- Table structure for table `subregionsimages`
--

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

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

INSERT INTO `subregionsimages` VALUES (782,746,'image-2019-10-30-14-35-18.jpg','medium-image-2019-10-30-14-35-18.jpg','','Yes',99),(781,747,'image-2019-10-30-14-35-10.jpg','medium-image-2019-10-30-14-35-10.jpg','','Yes',99),(780,748,'image-2019-10-30-14-35-00.jpg','medium-image-2019-10-30-14-35-00.jpg','','Yes',99),(779,734,'image-2019-08-01-15-28-08.jpg','medium-image-2019-08-01-15-28-08.jpg','','Yes',99),(778,733,'image-2019-08-01-15-27-53.jpg','medium-image-2019-08-01-15-27-53.jpg','','Yes',99),(777,731,'image-2019-08-01-15-27-42.jpg','medium-image-2019-08-01-15-27-42.jpg','','Yes',99),(776,730,'image-2019-08-01-15-27-35.jpg','medium-image-2019-08-01-15-27-35.jpg','','Yes',99),(775,732,'image-2019-08-01-15-26-13.jpg','medium-image-2019-08-01-15-26-13.jpg','','Yes',99),(774,637,'image-2019-08-01-15-13-43.jpg','medium-image-2019-08-01-15-13-43.jpg','','Yes',99),(773,639,'image-2019-08-01-15-13-33.jpg','medium-image-2019-08-01-15-13-33.jpg','','Yes',99),(772,706,'image-2019-08-01-15-04-10.jpg','medium-image-2019-08-01-15-04-10.jpg','','No',99),(771,453,'image-2019-08-01-15-04-01.jpg','medium-image-2019-08-01-15-04-01.jpg','','No',99),(770,638,'image-2019-08-01-15-02-26.jpg','medium-image-2019-08-01-15-02-26.jpg','','Yes',99),(769,712,'image-2019-08-01-15-00-11.jpg','medium-image-2019-08-01-15-00-11.jpg','','Yes',99),(768,711,'image-2019-08-01-14-59-07.jpg','medium-image-2019-08-01-14-59-07.jpg','','Yes',99),(767,608,'image-2019-08-01-14-49-08.jpg','medium-image-2019-08-01-14-49-08.jpg','','Yes',99),(766,609,'image-2019-08-01-14-46-10.jpg','medium-image-2019-08-01-14-46-10.jpg','Borobudur, Central Java','Yes',99),(765,664,'image-2019-08-01-14-44-36.jpg','medium-image-2019-08-01-14-44-36.jpg','','Yes',99),(764,666,'image-2019-08-01-14-43-53.jpg','medium-image-2019-08-01-14-43-53.jpg','','Yes',99),(763,662,'image-2019-08-01-14-42-49.jpg','medium-image-2019-08-01-14-42-49.jpg','','Yes',99),(762,656,'image-2019-08-01-14-42-21.jpg','medium-image-2019-08-01-14-42-21.jpg','','Yes',99),(761,663,'image-2019-08-01-14-38-44.jpg','medium-image-2019-08-01-14-38-44.jpg','','Yes',99),(760,663,'image-2019-08-01-14-38-19.jpg','medium-image-2019-08-01-14-38-19.jpg','','No',99),(759,667,'image-2019-08-01-14-40-43.jpg','medium-image-2019-08-01-14-40-43.jpg','','Yes',99),(758,143,'image-2019-07-30-14-46-03.jpg','medium-image-2019-07-30-14-46-03.jpg','Haast, West Coast | New Zealand | photography by Fraser Clements | Global Explorer','Yes',99),(757,142,'image-2019-07-30-14-45-27.jpg','medium-image-2019-07-30-14-45-27.jpg','Franz Josef Glacier, West Coast | New Zealand | photography by Fraser Clements | Global Explorer','Yes',99),(756,153,'image-2019-07-30-14-44-23.jpg','medium-image-2019-07-30-14-44-23.jpg','Fox Glacier, West Coast | New Zealand | photography by Miles Holden | Global Explorer','Yes',99),(755,94,'image-2019-07-30-14-43-02.jpg','medium-image-2019-07-30-14-43-02.jpg','Tuatepere, Southland | New Zealand | Global Explorer','Yes',99),(754,375,'image-2019-07-30-14-40-33.jpg','medium-image-2019-07-30-14-40-33.jpg','Roys Peak, Wanaka | New Zealand | photography by Miles Holden | Global Explorer','Yes',99),(753,375,'image-2019-07-30-14-40-08.jpg','medium-image-2019-07-30-14-40-08.jpg','Lake Wanaka | New Zealand | photography by Julian Apse | Global Explorer','No',99),(752,442,'image-2019-07-30-14-38-52.jpg','medium-image-2019-07-30-14-38-52.jpg','Nugget Point Lighthouse, The Catlins | New Zealand | Global Explorer','Yes',99),(751,671,'image-2019-07-30-14-36-25.jpg','medium-image-2019-07-30-14-36-25.jpg','Tunnel Beach, Dunedin | New Zealand | Global Explorer','Yes',99),(750,440,'image-2019-07-30-14-30-59.jpg','medium-image-2019-07-30-14-30-59.jpg','Arrowtown, Otago | New Zealand | photography by David Wall | Global Explorer','Yes',99),(749,87,'image-2019-07-30-14-28-05.jpg','medium-image-2019-07-30-14-28-05.jpg','Marlborough Sounds | New Zealand | Global Explorer','Yes',99),(748,86,'image-2019-07-30-14-27-47.jpg','medium-image-2019-07-30-14-27-47.jpg','Marlborough Sounds | New Zealand | Global Explorer','Yes',99),(747,85,'image-2019-07-30-14-27-36.jpg','medium-image-2019-07-30-14-27-36.jpg','Marlborough Sounds | New Zealand | Global Explorer','Yes',99),(746,84,'image-2019-07-30-14-27-01.jpg','medium-image-2019-07-30-14-27-01.jpg','Marlborough Sounds | New Zealand | Global Explorer','Yes',99),(745,670,'image-2019-07-30-14-23-57.jpg','medium-image-2019-07-30-14-23-57.jpg','','Yes',99),(744,102,'image-2019-07-30-14-20-26.jpg','medium-image-2019-07-30-14-20-26.jpg','Split Apple Rock | Nelson, New Zealand | Global Explorer','Yes',99),(743,686,'image-2019-07-30-14-19-38.jpg','medium-image-2019-07-30-14-19-38.jpg','Lake Pukaki, Canterbury, New Zealand | Global Explorer','Yes',99),(742,100,'image-2019-07-30-14-18-57.jpg','medium-image-2019-07-30-14-18-57.jpg','Kaikoura, Canterbury, New Zealand | Global Explorer','Yes',99),(741,75,'image-2019-07-30-14-35-26.jpg','medium-image-2019-07-30-14-35-26.jpg','Port Hills, Christchurch | New Zealand | photography by Greame Murray | Global Explorer','Yes',99),(740,99,'image-2019-07-30-14-15-44.jpg','medium-image-2019-07-30-14-15-44.jpg','Hanmer Springs, Canterbury | Global Explorer','Yes',99),(739,97,'image-2019-07-30-14-13-40.jpg','medium-image-2019-07-30-14-13-40.jpg','Wellington City | New Zealand | photography by Hamish Johnson | Global Explorer','Yes',99),(738,727,'image-2019-07-30-14-12-21.jpg','medium-image-2019-07-30-14-12-21.jpg','Waitomo Caves | New Zealand | photography by Shaun Jeffers | Global Explorer','Yes',99),(737,330,'image-2019-07-30-14-11-42.jpg','medium-image-2019-07-30-14-11-42.jpg','','Yes',99),(736,572,'image-2019-07-30-14-11-02.jpg','medium-image-2019-07-30-14-11-02.jpg','Cathedral Cove, Coromandel | photography by Adam Bryce | Global Explorer','Yes',99),(735,565,'image-2019-07-30-14-09-33.jpg','medium-image-2019-07-30-14-09-33.jpg','','Yes',99),(734,329,'image-2019-07-30-14-05-48.jpg','medium-image-2019-07-30-14-05-48.jpg','','Yes',99),(733,141,'image-2019-07-30-14-01-51.jpg','medium-image-2019-07-30-14-01-51.jpg','Bay of Islands, Northland | photography by Alistair Guthrie | Global Explorer','Yes',99);

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `username` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `frequency` enum('Daily','Weekly','Monthly') NOT NULL DEFAULT 'Weekly',
  `distribution_id` int(10) NOT NULL DEFAULT '0',
  `source` varchar(200) NOT NULL,
  `is_subscribed` enum('Yes','No') NOT NULL DEFAULT 'No',
  `vision6_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=354928 DEFAULT CHARSET=latin1;

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

INSERT INTO `subscribers` VALUES (354927,'2020-08-24 00:46:16','','','','wgirtow@cox.net','','Weekly',10,'Website','Yes',0),(354926,'2020-08-24 00:32:00','','','','kecia_j@hotmail.com','','Weekly',10,'Website','Yes',0),(354925,'2020-08-24 00:10:30','','','','lisaanngates@yahoo.com','','Weekly',10,'Website','Yes',0),(354924,'2020-08-24 00:02:54','','','','chrisfurney@yahoo.com','','Weekly',10,'Website','Yes',0),(354923,'2020-08-23 23:22:44','','','','brent.collins75@yahoo.com','','Weekly',10,'Website','Yes',0),(354922,'2020-08-23 23:22:14','','','','lisaanngates@yahoo.com','','Weekly',10,'Website','Yes',0),(354921,'2020-08-23 23:10:22','','','','goaliechickn@aol.com','','Weekly',10,'Website','Yes',0),(354920,'2020-08-23 23:06:20','','','','rchareunsr@aol.com','','Weekly',10,'Website','Yes',0),(354919,'2020-08-23 23:02:11','','','','michelleakiko@aol.com','','Weekly',10,'Website','Yes',0),(354918,'2020-08-23 22:58:03','','','','awana6806@aol.com','','Weekly',10,'Website','Yes',0),(354917,'2020-08-23 22:57:22','','','','rchareunsr@aol.com','','Weekly',10,'Website','Yes',0),(354916,'2020-08-23 22:32:05','Carol','Thomas','','carolellenathomas@outlook.com','0418481636','Weekly',10,'Website','Yes',0),(354915,'2020-08-23 22:15:21','','','','normdanjou@aol.com','','Weekly',10,'Website','Yes',0),(354914,'2020-08-23 22:06:16','','','','normdanjou@aol.com','','Weekly',10,'Website','Yes',0),(354913,'2020-08-23 21:24:50','','','','mongof15@aol.com','','Weekly',10,'Website','Yes',0),(354912,'2020-08-23 19:56:05','','','','chrisfurney@yahoo.com','','Weekly',10,'Website','Yes',0),(354911,'2020-08-23 19:02:21','','','','craigrob45@comcast.net','','Weekly',10,'Website','Yes',0),(354910,'2020-08-23 17:45:07','Vicki','Beardmore','','vickib2755@gmail.com','','Weekly',10,'Website','Yes',0),(354909,'2020-08-23 17:16:15','Kara','Breuer','','Karambreuer@gmail.com','','Weekly',10,'Website','Yes',0),(354908,'2020-08-23 15:51:50','','','','jroberthaven@aol.com','','Weekly',10,'Website','Yes',0),(354907,'2020-08-23 15:20:49','','','','pbsteel@aol.com','','Weekly',10,'Website','Yes',0),(354906,'2020-08-23 15:06:42','','','','charles_cloud2003@yahoo.com','','Weekly',10,'Website','Yes',0),(354905,'2020-08-23 15:06:30','Hayley','Kamman','','uzo7@hotmail.com','','Weekly',10,'Website','Yes',0),(354904,'2020-08-23 14:27:41','','','','dtvice@yahoo.com','','Weekly',10,'Website','Yes',0),(354903,'2020-08-23 11:54:09','','','','normdanjou@aol.com','','Weekly',10,'Website','Yes',0),(354902,'2020-08-23 11:26:00','','','','mongof15@aol.com','','Weekly',10,'Website','Yes',0),(354901,'2020-08-23 11:06:33','Russell','Baills','','rusbaills@optusnet.com.au','0408878633','Weekly',10,'Website','Yes',0),(354900,'2020-08-23 09:01:48','','','','dlake49@aol.com','','Weekly',10,'Website','Yes',0),(354899,'2020-08-23 06:51:36','','','','noreply@amazon-service.xyz','','Weekly',115,'Website','Yes',0),(354898,'2020-08-23 05:29:35','','','','leochambers2266@gmail.com','','Weekly',10,'Website','Yes',0),(354897,'2020-08-23 05:29:22','','','','leochambers2266@gmail.com','','Weekly',10,'Website','Yes',0),(354896,'2020-08-23 05:23:54','','','','chrisfurney@yahoo.com','','Weekly',10,'Website','Yes',0),(354895,'2020-08-23 04:53:23','','','','pac524man@yahoo.com','','Weekly',10,'Website','Yes',0),(354894,'2020-08-23 04:26:59','','','','dlake49@aol.com','','Weekly',10,'Website','Yes',0),(354893,'2020-08-23 04:21:42','','','','markhamming@yahoo.com','','Weekly',10,'Website','Yes',0),(354892,'2020-08-23 04:09:06','','','','bnrgane@icloud.com','','Weekly',10,'Website','Yes',0),(354891,'2020-08-23 03:04:47','','','','michael_bracero@yahoo.com','','Weekly',10,'Website','Yes',0),(354890,'2020-08-23 02:39:43','','','','rsmith1737@aol.com','','Weekly',10,'Website','Yes',0),(354889,'2020-08-23 02:39:43','','','','goaliechickn@aol.com','','Weekly',10,'Website','Yes',0),(354888,'2020-08-23 01:54:26','','','','goaliechickn@aol.com','','Weekly',10,'Website','Yes',0),(354887,'2020-08-23 01:21:36','','','','charles_cloud2003@yahoo.com','','Weekly',10,'Website','Yes',0),(354886,'2020-08-23 01:10:35','','','','vicd1959@yahoo.com','','Weekly',10,'Website','Yes',0),(354885,'2020-08-23 00:54:17','','','','charles_cloud2003@yahoo.com','','Weekly',10,'Website','Yes',0),(354884,'2020-08-23 00:45:42','','','','korgs130@sbcglobal.net','','Weekly',10,'Website','Yes',0),(354883,'2020-08-23 00:20:54','','','','hackerr@cox.net','','Weekly',10,'Website','Yes',0),(354882,'2020-08-23 00:16:40','','','','slick11435@aol.com','','Weekly',10,'Website','Yes',0),(354881,'2020-08-23 00:14:49','','','','awana6806@aol.com','','Weekly',10,'Website','Yes',0),(354880,'2020-08-23 00:11:47','','','','mmcclellan001@yahoo.com','','Weekly',10,'Website','Yes',0),(354879,'2020-08-23 00:00:46','','','','swytdec69@aol.com','','Weekly',10,'Website','Yes',0),(354878,'2020-08-22 23:44:40','','','','awana6806@aol.com','','Weekly',10,'Website','Yes',0);

--
-- Table structure for table `subscriptionsummary`
--

CREATE TABLE `subscriptionsummary` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `start_dt` date NOT NULL,
  `end_dt` date NOT NULL,
  `added` int(10) NOT NULL DEFAULT '0',
  `bounce` int(10) NOT NULL DEFAULT '0',
  `unsubscribe` int(10) NOT NULL DEFAULT '0',
  `distribution_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `survey`
--

CREATE TABLE `survey` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `terms` text NOT NULL,
  `description` text NOT NULL,
  `update_dt` datetime NOT NULL,
  `end_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

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

INSERT INTO `survey` VALUES (23,'Staff Satisfaction Survey','','','','2016-10-17 12:12:24','2016-10-31 00:00:59'),(22,'DQ Survey - Post Sale','','','DQ Survey - Post Sale','2016-10-17 12:19:45','2016-10-18 00:00:59'),(21,'High Tide - Customer Satisfaction Survey (Email)','','','Customer Satisfaction survey post 12 - 18 months post purchase','2016-10-11 12:05:02','2016-10-11 00:00:59'),(20,'High Tide - Customer Satisfaction Survey (phone)','','','6 Months Post Sale Survey to check Customer Satisfaction Survey','2016-10-11 11:56:07','2016-10-11 00:00:59'),(19,'HighTide - Point of Sale Survey','','','HighTide - Point of Sale Survey','2016-10-11 11:53:18','2016-10-11 00:00:59'),(18,'Win a 5 Star Family Escape to Marriott Surfers Paradise','survey-2016-04-07-16-34-32.jpg','<p align=\"center\">\r\n	<strong>WIN A 5 STAR&nbsp;FAMILY ESCAPE TO MARRIOTT SURFERS PARADISE!</strong></p>\r\n<p align=\"center\">\r\n	<strong>COMPETITION TERMS AND CONDITIONS</strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is two nights&rsquo; accommodation for 2 adults and 2 children (2-14 years) OR 3 adults, staying at Marriott Surfers Paradise including breakfast daily, valet parking, and a cabana package including half day hire of a lagoon side cabana, two cocktails, and a bottle of water.</li>\r\n	<li>\r\n		Prize is valued at $1040</li>\r\n	<li>\r\n		The Competition starts 07/04/16 and ends 11pm 21/04/16 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 22/04/16.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;.&nbsp;</li>\r\n	<li>\r\n		Entrants who agree to the terms and conditions opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland). A re-draw will take place on 17/05/16 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n<p style=\"margin-left:36pt;\">\r\n</p>\r\n<p>\r\n	Conditions of Entry</p>\r\n<p>\r\n</p>\r\n<p>\r\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Except for any liability that cannot be excluded by law, the Promoter (including their respective officers, employees and agents) exclude all liability (including negligence), for any personal injury; or any loss or damage (including loss of opportunity); whether direct, indirect, special or consequential, arising in any way out of the offer, including, but not limited to, where arising out of the following: (a) any technical difficulties or equipment malfunction; (b) any theft, unauthorised access or third party interference; (c) any voucher that is late, lost, altered, damaged or misdirected due to any reason beyond the reasonable control of the Promoter; (d) during participation in the experience (e) any featured venues in the offer being cancelled for any reason beyond the reasonable control of the Promoter; (f) any tax liability incurred by a claimant; (g) quality or availability of any featured venue or (h) loss of opportunity to redeem the voucher because the customer failed to make a booking with the chosen in the timeframe stipulated as part of prize description, or failed to cancel</p>\r\n<p>\r\n</p>\r\n<p>\r\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In the event of unforeseen circumstances, the Promoter reserves the right to withdraw, change or substitute a reward with another reward of equal or greater value.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prices (if any) and information presented are valid at the time of going to press and may be subject to change.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The Promoter, its agents and distributors accept no responsibility, financial or otherwise for the misuse of vouchers and are not liable for any personal loss, injury or illness at participating venues, and cannot be held responsible for any disagreement concerning quality/availability of featured venues.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Any persons taking advantage of this promotion does so on complete acceptance of these terms &amp; conditions.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The Promoter shall also be bound by these Terms and Conditions and shall not encourage, persuade, promote, support or in any way assist in their breach.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	Prize Conditions</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prize will be awarded in the form of a holiday accommodation certificate.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flights are not included in the holiday prize.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The holiday component of the prize must be booked and taken six months from the draw date (or re-draw date if applicable). Holiday certificate is valued at the nominated amount.&nbsp; Prize cannot be taken during Australian school holidays, public holidays or other peak periods/special events and is subject to availability.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Altered, lost or stolen certificate will not be replaced, refunded or redeemed. Certificates are not redeemable for cash and must be redeemed before the expiry dates specified.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Spending money, meals, insurance, transport, items of a personal nature, in-room charges and all other ancillary costs are not included.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The winner (and his/her companions) is responsible for ensuring that they have valid travel documentation with them.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit card security or a cash bond will be required upon check-in at the resort.</p>\r\n<p>\r\n</p>\r\n<p style=\"margin-left:46.4pt;\">\r\n	8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Extra people or room upgrade will incur additional fees.</p>\r\n<p>\r\n</p>\r\n<p>\r\n	9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If for any reason, once the prize has been booked, you do not take the prize or an element of the prize at the time stipulated, then the prize or that element of the prize will be forfeited and will not be redeemable for cash.</p>\r\n','<p>\r\n	WIN a 5 Star Family Escape for 2 &nbsp;adults and 2 kids staying at the opulent and luxurious Marriott Surfers Paradise! Enjoy sheer luxury by the Gold Coast&#39;s most impressive lagoon pool filled with tropical fish, surrounded by luscious gardens, framed by a waterfall and accessible via two bridges! There is also a fresh water pool, waterside for the kids, and plenty of deck chairs to enjoy the sunshine. Of course you&#39;ll be lazing on your comfortable cabana with a cocktail in hand!&nbsp;</p>\r\n<p>\r\n	Indulge in a treatment in Ruby&#39;s spa, which is equipped with &nbsp;a separate mens barber shop, or hit the 24 hour fitness centre then stop for a drink at the lounge bar before you enjoy traditioanl Japanese at Misono. All this withtout leaving the resort! The Marriott Surfers Paradise promises pure luxury from the moment you arrive.&nbsp;</p>\r\n<p>\r\n	<strong>This amazing prize package includes:</strong></p>\r\n<div>\r\n	<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n		<tbody>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<b><span style=\"font-size: 14pt; line-height: 19.9733px; font-family: \'Calibri Light\', sans-serif;\">2 Nights</span></b><span style=\"font-size: 14pt; line-height: 19.9733px; font-family: \'Calibri Light\', sans-serif;\">&nbsp;at Marriott Surfers Paradise for up to 2 adults and 2 kids, OR 3 adults</span></td>\r\n			</tr>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<span style=\"font-size: 14pt; line-height: 19.9733px; font-family: \'Calibri Light\', sans-serif;\">Free&nbsp;<b>Buffet&nbsp;Breakfast Daily&nbsp;</b>at the award-winning Citrique&nbsp;</span></td>\r\n			</tr>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<span style=\"font-family: \'Calibri Light\', sans-serif; font-size: 18.6667px; line-height: 19.9733px;\"><strong>Cabana Hire </strong>for a half day including two cocktails and a bottle of water</span></td>\r\n			</tr>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<span style=\"font-size: 14pt; line-height: 19.9733px; font-family: \'Calibri Light\', sans-serif;\">Central location close to beaches, attractions, and restaurants.&nbsp;</span></td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<div style=\"clear: both;\">\r\n</div>\r\n<div style=\"clear: both;\">\r\n	<strong>Simply fill out the form below to enter.&nbsp;</strong></div>\r\n','2016-04-12 09:04:57','2016-04-21 00:00:59'),(17,'Win a Luxury Escape to Hilton Surfers Paradise ','survey-2016-02-26-09-54-01.jpg','<p align=\"center\">\r\n	<strong>WIN A 5 STAR&nbsp;LUXURY ESCAPE AT HILTON SURFERS PARADISE!</strong><br />\r\n	<strong>COMPETITION TERMS AND CONDITIONS</strong></p>\r\n<p>\r\n</p>\r\n<ul>\r\n	<li>\r\n		Prize is two nights&rsquo; accommodation for two people staying at Hilton Surfers Paradise in a Hotel Guest Room and includes breakfast daily for 2, and a bottle of sparkling wine on arrival.</li>\r\n	<li>\r\n		Prize is valued at $740</li>\r\n	<li>\r\n		The Competition starts 26/02/16 and ends 12am 11/03/16 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 15/03/16.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;.&nbsp; Entrants who select to opt in for the Discover Queensland enewsletter will receive one additional entry.</li>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland). A re-draw will take place on 15/04/16 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n<p>\r\n	Conditions of Entry</p>\r\n<p>\r\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Except for any liability that cannot be excluded by law, the Promoter (including their respective officers, employees and agents) exclude all liability (including negligence), for any personal injury; or any loss or damage (including loss of opportunity); whether direct, indirect, special or consequential, arising in any way out of the offer, including, but not limited to, where arising out of the following: (a) any technical difficulties or equipment malfunction; (b) any theft, unauthorised access or third party interference; (c) any voucher that is late, lost, altered, damaged or misdirected due to any reason beyond the reasonable control of the Promoter; (d) during participation in the experience (e) any featured venues in the offer being cancelled for any reason beyond the reasonable control of the Promoter; (f) any tax liability incurred by a claimant; (g) quality or availability of any featured venue or (h) loss of opportunity to redeem the voucher because the customer failed to make a booking with the chosen in the timeframe stipulated as part of prize description, or failed to cancel</p>\r\n<p>\r\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In the event of unforeseen circumstances, the Promoter reserves the right to withdraw, change or substitute a reward with another reward of equal or greater value.</p>\r\n<p>\r\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prices (if any) and information presented are valid at the time of going to press and may be subject to change.</p>\r\n<p>\r\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The Promoter, its agents and distributors accept no responsibility, financial or otherwise for the misuse of vouchers and are not liable for any personal loss, injury or illness at participating venues, and cannot be held responsible for any disagreement concerning quality/availability of featured venues.</p>\r\n<p>\r\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Any persons taking advantage of this promotion does so on complete acceptance of these terms &amp; conditions.</p>\r\n<p>\r\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The Promoter shall also be bound by these Terms and Conditions and shall not encourage, persuade, promote, support or in any way assist in their breach.</p>\r\n<p>\r\n	Prize Conditions</p>\r\n<p>\r\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prize will be awarded in the form of a holiday accommodation certificate.</p>\r\n<p>\r\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flights are not included in the holiday prize.</p>\r\n<p>\r\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The holiday component of the prize must be booked and taken six months from the draw date (or re-draw date if applicable). Holiday certificate is valued at the nominated amount.&nbsp; Prize cannot be taken during Australian school holidays, public holidays or other peak periods/special events and is subject to availability.</p>\r\n<p>\r\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Altered, lost or stolen certificate will not be replaced, refunded or redeemed. Certificates are not redeemable for cash and must be redeemed before the expiry dates specified.</p>\r\n<p>\r\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Spending money, meals, insurance, transport, items of a personal nature, in-room charges and all other ancillary costs are not included.</p>\r\n<p>\r\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The winner (and his/her companions) is responsible for ensuring that they have valid travel documentation with them.</p>\r\n<p>\r\n	7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit card security or a cash bond will be required upon check-in at the resort.</p>\r\n<p>\r\n	8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Extra people or room upgrade will incur additional fees.</p>\r\n<p>\r\n	9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If for any reason, once the prize has been booked, you do not take the prize or an element of the prize at the time stipulated, then the prize or that element of the prize will be forfeited and will not be redeemable for cash.</p>\r\n<p>\r\n</p>\r\n','<p>\r\n	WIN a 5 Star Luxury Escape for 2 people staying at Hilton Surfers Paradise in the vibrant heart of the Gold Coast. Enjoy 3 days / 2 nights including delicious buffet breakfast daily and welcome bottle of sparkling wine on arrival.</p>\r\n<p>\r\n	Indulge in sheer luxury in one of the four pools on &#39;The Deck&#39;, bliss out at eforea:Spa or hit the 24 hour fitness centre before choosing between the impressive range of restaurants and bars including Luke Mangan&#39;s Salt grill Restaurant and FIX lounge bar. All this as well as a completely personalised, 5 Star experience from the moment you arrive!</p>\r\n<p>\r\n	<strong>This amazing prize package includes:</strong></p>\r\n<div>\r\n	<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n		<tbody>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<b><span style=\"font-size: 14pt; line-height: 107%; font-family: \'Calibri Light\', sans-serif;\">2 Nights</span></b><span style=\"font-size: 14pt; line-height: 107%; font-family: \'Calibri Light\', sans-serif;\">&nbsp;at Hilton Surfers Paradise for up to 2 people</span><br />\r\n					<br />\r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<span style=\"font-size: 14pt; line-height: 107%; font-family: \'Calibri Light\', sans-serif;\">Free&nbsp;<b>Buffet&nbsp;Breakfast Daily&nbsp;</b>at Salt grill by Luke Mangan<b>&nbsp;</b>for 2 people</span><br />\r\n					<br />\r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<span style=\"font-size: 14pt; line-height: 107%; font-family: \'Calibri Light\', sans-serif;\">A Welcome&nbsp;<b>Bottle of Sparkling Wine</b>&nbsp;on Arrival&nbsp;</span><br />\r\n					<br />\r\n				</td>\r\n			</tr>\r\n			<tr>\r\n				<td valign=\"top\" width=\"30\">\r\n					<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n				<td valign=\"top\">\r\n					<span style=\"font-size: 14pt; line-height: 107%; font-family: \'Calibri Light\', sans-serif;\">Central location close to beaches, attractions, and restaurants.&nbsp;</span><br />\r\n					<br />\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<div style=\"clear:both;\">\r\n</div>\r\n<div style=\"clear:both;\">\r\n	<strong>Simply fill out the form below to enter.&nbsp;</strong></div>\r\n','2016-03-08 14:22:10','2016-03-10 00:00:59'),(16,'WIN a Grand Mercure Twin Waters Escape','survey-2016-02-12-12-15-43.png','&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;<strong>WIN a Grand Mercure Twin Waters Escape</strong>\r\n<p align=\"center\">\r\n	<strong>COMPETITION TERMS AND CONDITIONS</strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is FOUR nights accommodation at Grand Mercure Twin Waters for up to SIX people, subject to availability, not valid for travel during peak periods, school holidays, Christmas and New Year periods or during special events.</li>\r\n	<li>\r\n		Prize is valued up to $1224</li>\r\n	<li>\r\n		The Competition starts 12/02/16 and ends Midnight 26/02/16 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The prize is non-transferable, not redeemable for cash, not to be used in conjunction with any other offer or deal, cannot be exchanged for products, and must be used in one transaction.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 on 01/03/16.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n	<li value=\"1\">\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;.&nbsp;</li>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland). A re-draw will take place on 01/04/16 if the prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n<p align=\"center\">\r\n	<strong>CONDITIONS OF ENTRY</strong></p>\r\n<ol>\r\n	<li>\r\n		Except for any liability that cannot be excluded by law, the Promoter (including their respective officers, employees and agents) exclude all liability (including negligence), for any personal injury; or any loss or damage (including loss of opportunity); whether direct, indirect, special or consequential, arising in any way out of the offer, including, but not limited to, where arising out of the following: (a) any technical difficulties or equipment malfunction; (b) any theft, unauthorised access or third party interference; (c) any voucher that is late, lost, altered, damaged or misdirected due to any reason beyond the reasonable control of the Promoter; (d) during participation in the experience (e) any featured venues in the offer being cancelled for any reason beyond the reasonable control of the Promoter; (f) any tax liability incurred by a claimant; (g) quality or availability of any featured venue or (h) loss of opportunity to redeem the voucher because the customer failed to make a booking with the chosen in the timeframe stipulated as part of prize description, or failed to cancel</li>\r\n	<li>\r\n		In the event of unforeseen circumstances, the Promoter reserves the right to withdraw, change or substitute a reward with another reward of equal or greater value.</li>\r\n	<li>\r\n		Prices (if any) and information presented are valid at the time of going to press and may be subject to change.</li>\r\n	<li>\r\n		The Promoter, its agents and distributors accept no responsibility, financial or otherwise for the misuse of vouchers and are not liable for any personal loss, injury or illness at participating venues, and cannot be held responsible for any disagreement concerning quality/availability of featured venues.</li>\r\n	<li>\r\n		Any persons taking advantage of this promotion does so on complete acceptance of these terms &amp; conditions.</li>\r\n	<li>\r\n		The Promoter shall also be bound by these Terms and Conditions and shall not encourage, persuade, promote, support or in any way assist in their breach.</li>\r\n</ol>\r\n','<h2>\r\n	<span style=\"font-family: Calibri, sans-serif; font-size: 16px; line-height: 18.4px;\">WIN a Grand Mercure Twin Waters Escape <strong>with Discover Queensland! Getaway to the beautiful Sunshine Coast for 4 nights, for up to 6 people, and enjoy a range of complimentary water activities on the stunning lake, proximity to the beach, and luxury accommodation! Simply fill out the form below to enter.&nbsp;</strong></span></h2>\r\n<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<b><span style=\"font-size: 12pt; line-height: 115%; font-family: Calibri, sans-serif;\">4 Nights </span></b><span style=\"font-size: 12pt; line-height: 115%; font-family: Calibri, sans-serif;\">at Grand Mercure Twin Waters for up to 6 people.</span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span style=\"font-size: 12pt; line-height: 115%; font-family: Calibri, sans-serif;\"><strong>Located on the beautiful Twin Waters Lake</strong> and a 5 min walk from the beach.</span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span style=\"font-size: 12pt; line-height: 115%; font-family: Calibri, sans-serif;\">Complimentary&nbsp;<strong>catamaran sailing</strong>,</span><strong style=\"font-family: Calibri, sans-serif; font-size: 16px; line-height: 18.4px;\">water trampoline,&nbsp;</strong><span style=\"font-family: Calibri, sans-serif; font-size: 12pt; line-height: 115%;\">kayaking</span><span style=\"font-family: Calibri, sans-serif; font-size: 12pt; line-height: 115%;\">, snorkelling, 9 hole mini golf and more!</span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p align=\"center\">\r\n</p>\r\n<p align=\"center\">\r\n</p>\r\n','2016-07-26 16:55:12','2016-02-26 00:00:59'),(15,'WIN A Queenstown Escape','survey-2016-02-04-10-55-50.jpg','<h2 style=\"box-sizing: border-box; font-family: Arial, Verdana, helvetica, sans-serif; font-weight: 500; line-height: 1.1; color: rgb(51, 51, 51); margin-top: 20px; margin-bottom: 10px; font-size: 30px; background-color: rgb(255, 255, 255);\">\r\n	<span style=\"line-height: 1.1;\">WIN a Queenstown&nbsp;</span>Escape Competition Terms &amp; Conditions</h2>\r\n<ul style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\">\r\n	<li style=\"box-sizing: border-box;\">\r\n		The Prize: Three (3) consecutive nights&rsquo; accommodation in a lake view apartment and daily breakfast at Crowne Plaza Queenstown for up to two (2) people. Offer valid for 9 months from date of issue, accommodation is subject to availability and blackout dates, and advance bookings must be organised directly with the hotel. 5 Course Degustation at Gantleys Restaurant for two (2) people. Two (2) Thunder Jet Boat Passes, subject to availability and weather conditions. Two (2) passes for 90 minute Lake Cruise with Million Dollar Cruise Queenstown, subject to availability and weather conditions. NZ$200 Body Sanctum Spa Voucher subject to availability.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The Competition commences 5pm 28/01/16 and ends Midnight 29/02/16 AEST.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The winner will be drawn randomly from eligible entries at 79B Scarborough Street, Southport, QLD 4227 at 10am 1/03/16 AEST.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Entry is via Queenstown Holidays Facebook page:&nbsp;<a href=\"https://www.facebook.com/QueenstownHolidays/\" style=\"box-sizing: border-box; color: rgb(14, 139, 167); text-decoration: none; background: transparent;\" target=\"_blank\">https://www.facebook.com/QueenstownHolidays/</a>&nbsp;and/or Queenstown Holidays Instagram page:&nbsp;<a href=\"https://instagram.com/queenstownholidays\" style=\"box-sizing: border-box; color: rgb(14, 139, 167); text-decoration: none; background: transparent;\" target=\"_blank\">https://instagram.com/queenstownholidays</a>&nbsp;by entering the competition.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		By entering this competition you are opting in to receive future email communications from Queenstown Holidays. Your entry information will not be shared with anyone, we will not spam you and you can opt out of receiving communications any time. Email communications will include (but not be limited to) travel offers, competitions and special offers.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The winner will be notified via email and announced on Facebook&nbsp;<a href=\"https://www.facebook.com/QueenstownHolidays/\" style=\"box-sizing: border-box; color: rgb(14, 139, 167); text-decoration: none; background: transparent;\" target=\"_blank\">https://www.facebook.com/QueenstownHolidays/</a>&nbsp;and Instagram https://instagram.com/queenstownholidays.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		A re-draw will take place on 01/04/16 if prize winner is not able to be contacted within 30 days of the original draw date via the same drawing method.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The Promoter is LeisureCom Group Pty Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone 1300 552 235.</li>\r\n</ul>\r\n<br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<strong style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\">Conditions of Entry&nbsp;</strong><br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<ol style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\">\r\n	<li style=\"box-sizing: border-box;\">\r\n		Except for any liability that cannot be excluded by law, the Promoter (including their respective officers, employees and agents) exclude all liability (including negligence), for any personal injury; or any loss or damage (including loss of opportunity); whether direct, indirect, special or consequential, arising in any way out of the offer, including, but not limited to, where arising out of the following: (a) any technical difficulties or equipment malfunction; (b) any theft, unauthorised access or third party interference; (c) any voucher that is late, lost, altered, damaged or misdirected due to any reason beyond the reasonable control of the Promoter; (d) during participation in the experience (e) any featured venues in the offer being cancelled for any reason beyond the reasonable control of the Promoter; (f) any tax liability incurred by a claimant; (g) quality or availability of any featured venue or (h) loss of opportunity to redeem the voucher because the customer failed to make a booking with the chosen in the timeframe stipulated as part of prize description, or failed to cancel</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		In the event of unforeseen circumstances, the Promoter reserves the right to withdraw, change or substitute a reward with another reward of equal or greater value.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Prices (if any) and information presented are valid at the time of going to press and may be subject to change.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The Promoter, its agents and distributors accept no responsibility, financial or otherwise for the misuse of vouchers and are not liable for any personal loss, injury or illness at participating venues, and cannot be held responsible for any disagreement concerning quality/availability of featured venues.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Any persons taking advantage of this promotion does so on complete acceptance of these terms &amp; conditions.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The Promoter shall also be bound by these Terms and Conditions and shall not encourage, persuade, promote, support or in any way assist in their breach.</li>\r\n</ol>\r\n<br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<strong style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\">Prize Conditions</strong><span style=\"color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\">&nbsp;</span><br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<br style=\"box-sizing: border-box; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\" />\r\n<ol style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(51, 51, 51); font-family: Arial, Verdana, helvetica, sans-serif; font-size: 14px; line-height: 22.2222px; background-color: rgb(255, 255, 255);\">\r\n	<li style=\"box-sizing: border-box;\">\r\n		Prize will be awarded in the form of a Queenstown holiday certificate (for accommodation and tours and attractions component).</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		All components of the prize must be booked and taken within 9 months of the issue date (01/03/16) are all subject to availability. We strongly recommend the prize winner books all components of the prize at the same time as we cannot recommend or substitute any component of the prize if unavailable during the desired dates of travel.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		All components of the prize are non-transferable, not redeemable for cash, not to be used in conjunction with any other offer or deal, cannot be exchanged for products, and must be used in one transaction.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The prize is subject to availability and excludes school holidays, special events, public holidays and Christmas/New Year periods.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Altered, lost or stolen certificates will not be replaced, refunded or redeemed. Certificates are not redeemable for cash and must be redeemed before the expiry dates specified.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Spending money, meals (unless specified in the prize package), insurance, transport, items of a personal nature, in-room charges and all other ancillary costs are not included.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		The winner (and his/her companions) is responsible for ensuring that they have valid travel documentation with them.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Credit card security or a cash bond may be required upon check-in at the resort.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		Maximum occupants is up to two people. Extra people or room upgrade (if available) will incur additional fees.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		If for any reason, once the prize has been booked, you do not take the prize or an element of the prize at the time stipulated, then the prize or that element of the prize will be forfeited and will not be redeemable for cash. We strongly recommend all components of the prize are booked at the same time to avoid disappointment.</li>\r\n	<li style=\"box-sizing: border-box;\">\r\n		To book the holiday prize, select what dates you would like to travel then call Queenstown Holidays on 1300 552 235 and one of our reservations staff will assist you with booking your holiday. To book attraction prizes contact the suppliers directly with the contact details and vouchers provided. Please have your holiday certificate handy to quote the certificate number when making your booking which is located on the front of the certificate.</li>\r\n</ol>\r\n','<p>\r\n	WIN a Queenstown Escape for two people worth over $1700 including 3 nights&rsquo; accommodation for two people at Crowne Plaza Queenstown in a Lake View room with daily buffet breakfast, Million Dollar Cruise, Thunder Jet Experience, 5 Course Degustation at Gantleys Restaurant, and 2 x $100 Body Sanctum Day Spa Vouchers.&nbsp;</p>\r\n<p>\r\n	SIMPLY FILL OUT THE FORM BELOW FOR YOUR CHANCE TO WIN!</p>\r\n<p>\r\n	<strong>THE PRIZE:</strong></p>\r\n<ul>\r\n	<li>\r\n		<strong>3 NIGHTS ACCOMMODATION</strong>&nbsp;for up to 2 Guests in a Luxury Lake View Apartment at Crowne Plaza Queenstown</li>\r\n	<li>\r\n		<b>DAILY BUFFET BREAKFAST&nbsp;</b>for 2</li>\r\n	<li>\r\n		<strong>5 COURSE DEGUSTATION</strong>&nbsp;at Gantleys Restaurant&nbsp;</li>\r\n	<li>\r\n		2x&nbsp;<strong>THUNDER JET BOAT</strong>&nbsp;Rides</li>\r\n	<li>\r\n		4x&nbsp;<strong>MILLION DOLLAR BOAT CRUISE</strong></li>\r\n	<li>\r\n		2x<strong> $100 BODY SANCTUM&nbsp;</strong>Spa Voucher</li>\r\n</ul>\r\n<p>\r\n	&nbsp;The competition ends Midnight (AEST) on the 29th February 2016. Good Luck!!!</p>\r\n<p>\r\n	Prize values are NZ$</p>\r\n','2016-02-29 15:49:23','2016-02-29 23:00:59'),(14,'Mantra Towers Of Chevron Giveaway!','survey-2016-01-18-14-50-21.jpg','<div class=\"well well-sm\" style=\"font-size:11px; background-color:transparent;\">\r\n	<div style=\"max-height:150px; overflow-y:scroll;\">\r\n		<p align=\"center\">\r\n			<strong class=\"enternow\">MANTRA TOWERS OF CHEVRON GIVEAWAY<br />\r\n			COMPETITION TERMS AND CONDITIONS </strong></p>\r\n		<ul>\r\n			<li>\r\n				Prize is FIVE nights accommodation at the Mantra Towers of Chevron in a 2 bedroom superior apartment for 2 adults and 2 children. An extra person may be added to the room at additional cost.</li>\r\n			<li>\r\n				Prize is valued at $1499</li>\r\n			<li>\r\n				The Competition starts 18/01/16 and ends 10am 03/02/16 AEST.</li>\r\n			<li>\r\n				The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n			<li>\r\n				The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 03/02/16.</li>\r\n			<li>\r\n				Entry is via the Discover Queensland website.</li>\r\n		</ul>\r\n		<ol>\r\n			<li>\r\n				Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n		</ol>\r\n		<ul>\r\n			<li>\r\n				Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n			<li>\r\n				The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 03/02/16. A re-draw will take place on 03/03/16 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n			<li>\r\n				The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n		</ul>\r\n	</div>\r\n</div>\r\n<p>\r\n</p>\r\n','<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>5 Nights In A 2 Bedroom Apartment </strong>at the Mantra Towers Of Chevron for 2 adults and 2 kids.</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Superior Apartment</strong> on a higher floor so you get amazing views of the ocean, city and mountains.</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Centrally located in the heart of Surfers Paradise and close to shopping centres, public transport, restaurants and stores.</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 10am on Wednesday the 3rd February. Good luck!</p>\r\n','2016-01-19 12:03:15','2016-02-03 10:00:59'),(13,'The Sebel Coolangatta Giveaway!','survey-2016-01-08-12-05-42.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A LUXURY WEEKEND AT THE SEBEL COOLANGATTA!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is THREE nights accommodation at The Sebel Coolangatta in a 2 bedroom high floor apartment.</li>\r\n	<li>\r\n		Prize is valued at $804</li>\r\n	<li>\r\n		The Competition starts 08/01/16 and ends 10am 20/01/16 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 20/01/16.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Website entry: Entrants must visit http://discoverqueensland.com.au/comp/13 then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 20/01/16. A re-draw will take place on 20/02/16 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>3 Nights In A 2 Bedroom Apartment </strong>at The Sebel Coolangatta</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Gauranteed</strong> high floor for spectacular ocean views</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Centrally located opposite Coolangatta Beach and only minutes from Gold Coast Airport </span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 10am on Wednesday the 20th January. Good luck!</p>\r\n','2016-01-20 09:12:25','2016-01-20 10:00:59'),(12,'Paradise Resort Family Giveaway','survey-2015-10-28-11-54-34.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A PARADISE RESORT FAMILY GETAWAY<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is THREE nights accommodation in a Superior Resort Room at the Paradise Resort, Surfers Paradise including continental breakfast for 2 adults and children (0-12), buy 1 get 1 free at Planet Chill ice skating, 1 session per day per child at Z4K Kids Club, unlimited use of the Z4k waterpark and daily undercover parking.</li>\r\n	<li>\r\n		Prize is valued at $1045</li>\r\n	<li>\r\n		The Competition starts 28/10/15 and ends 12am 11/11/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 11/11/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 11/11/15. A re-draw will take place on 11/12/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>3 Nights In A Deluxe Resort Room </strong>at the award winning Paradise Resort on the Gold Coast!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>1x Free Kids Klub Session</strong> per child, per day for the length of your stay</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Unlimited Access </strong>to the Z4K waterpark and play area</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Continental Breakfast </strong>daily for 2 adults and children 0-12 years old</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Buy 1 get 1 free Planet Chill ice skating passes and daily undercover parking</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 12pm on Wednesday the 11th November. Good luck!</p>\r\n','2015-10-28 11:54:34','2015-11-11 00:00:59'),(11,'Win a 5 Star Luxury Gold Coast Escape','survey-2015-10-09-12-06-15.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A LUXURY WEEKEND AT THE MARRIOTT SURFERS PARADISE RESORT AND SPA!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is TWO nights accommodation at the Marriott Surfers Paradise Resort and spa for two people in an ocean view room. Includes buffet breakfast for two daily, a bottle of wine on arrival, free wifi, undercover parking and 12pm late checkout.</li>\r\n	<li>\r\n		Prize is valued at $804</li>\r\n	<li>\r\n		The Competition starts 09/10/15 and ends 12am 30/10/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 30/10/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 30/10/15. A re-draw will take place on 30/11/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>2 Nights In A Luxury Ocean View Room </strong>at the Marriott Surfers Paradise Resort And Spa on the Gold Coast!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Buffet Breakfast</strong> for two daily!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>BONUS </strong>12pm late check-out</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Free Wifi, Bottle of wine on arrival and undercover parking!</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 10am on Friday the 30th October. Good luck!</p>\r\n','2015-10-09 12:06:15','2015-10-30 10:00:59'),(10,'WIN THE ULTIMATE QUEENSTOWN HOLIDAY!','survey-2015-09-30-14-20-08.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN THE ULTIMATE QUEENSTOWN HOLIDAY<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		<strong>The Prize:</strong> Five (5) consecutive nights accommodation in a two bedroom self-contained apartment at ALTA Apartments, Queenstown for up to four people; Flight voucher valued at NZ$1,000, Prime Waterfront Restaurant &amp; Bar voucher valued at NZ$250, Four (4) Thunder Jet Boat Passes, Four (4) passes for 90 minute Lake Cruise with Million Dollar Cruise Queenstown, NZ$250 Body Sanctum Spa Voucher and Two (2) Paragliding Flight passes with G-Force Queenstown. Under cover parking and 1GB of WIFI also included.</li>\r\n	<li>\r\n		Prize valued at NZ$4,995.</li>\r\n	<li>\r\n		The Competition commences 9am 30/09/15 and ends 5pm 23/12/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The winner will be drawn randomly from eligible entries at 79B Scarborough Street, Southport, QLD 4227 at 3pm, 24/12/15 AEST.</li>\r\n	<li>\r\n		Entry is via www.queenstownholidays.com by completing the details requested and by clicking &ldquo;Enter Now&rdquo;.</li>\r\n	<li>\r\n		By entering this competition you are opting in to receive future email communications from Queenstown Holidays. Your entry information will not be shared with anyone, we will not spam you and you can opt out of receiving communications any time. Email communications will include (but not be limited to) travel offers, competitions and special offers.</li>\r\n	<li>\r\n		The winner will be notified via email and announced on Facebook (facebook.com/queenstownholidays) and their full name published at www.queenstownholidays.com/comp/10 on 24/12/15.</li>\r\n	<li>\r\n		A re-draw will take place on 25/01/16 if prize winner is not able to be contacted within 30 days of the original draw date via the same drawing method. The unclaimed prize draw (if applicable) will be notified via email on 26/03/16 and published on www.queenstownholidays.com/comp/10.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Pty Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone 1300 552 235.</li>\r\n</ul>\r\n<p>\r\n	<strong>Conditions of Entry</strong></p>\r\n<ol>\r\n	<li>\r\n		Except for any liability that cannot be excluded by law, the Promoter (including their respective officers, employees and agents) exclude all liability (including negligence), for any personal injury; or any loss or damage (including loss of opportunity); whether direct, indirect, special or consequential, arising in any way out of the offer, including, but not limited to, where arising out of the following: (a) any technical difficulties or equipment malfunction; (b) any theft, unauthorised access or third party interference; (c) any voucher that is late, lost, altered, damaged or misdirected due to any reason beyond the reasonable control of the Promoter; (d) during participation in the experience (e) any featured venues in the offer being cancelled for any reason beyond the reasonable control of the Promoter; (f) any tax liability incurred by a claimant; (g) quality or availability of any featured venue or (h) loss of opportunity to redeem the voucher because the customer failed to make a booking with the chosen in the timeframe stipulated as part of prize description, or failed to cancel</li>\r\n	<li>\r\n		In the event of unforeseen circumstances, the Promoter reserves the right to withdraw, change or substitute a reward with another reward of equal or greater value.</li>\r\n	<li>\r\n		Prices (if any) and information presented are valid at the time of going to press and may be subject to change.</li>\r\n	<li>\r\n		The Promoter, its agents and distributors accept no responsibility, financial or otherwise for the misuse of vouchers and are not liable for any personal loss, injury or illness at participating venues, and cannot be held responsible for any disagreement concerning quality/availability of featured venues.</li>\r\n	<li>\r\n		Any persons taking advantage of this promotion does so on complete acceptance of these terms &amp; conditions.</li>\r\n	<li>\r\n		The Promoter shall also be bound by these Terms and Conditions and shall not encourage, persuade, promote, support or in any way assist in their breach.</li>\r\n</ol>\r\n<p>\r\n	<strong>Prize Conditions</strong></p>\r\n<ol>\r\n	<li>\r\n		Prize will be awarded in the form of a Discover Queenstown holiday certificate (for accommodation and tours and attractions component) and a flight voucher (for flight component).</li>\r\n	<li>\r\n		All components of the prize must be booked and taken by 18 June 2016 and are all subject to availability. We strongly recommend the prize winner books all components of the prize at the same time as we cannot recommend or substitute any component of the prize if unavailable during the desired dates of travel.</li>\r\n	<li>\r\n		Holiday package is valued at the nominated amount.&nbsp; Prize is subject to availability and excludes the school holidays, special events and Christmas/New Year periods.</li>\r\n	<li>\r\n		Altered, lost or stolen certificate will not be replaced, refunded or redeemed. Certificates are not redeemable for cash and must be redeemed before the expiry dates specified.</li>\r\n	<li>\r\n		Spending money, meals (unless specified in the prize package), insurance, transport, items of a personal nature, in-room charges and all other ancillary costs are not included.</li>\r\n	<li>\r\n		The winner (and his/her companions) is responsible for ensuring that they have valid travel documentation with them.</li>\r\n	<li>\r\n		Credit card security or a cash bond may be required upon check-in at the resort.</li>\r\n	<li>\r\n		Maximum occupants is up to four people. Extra people or room upgrade (if available) will incur additional fees.</li>\r\n	<li value=\"9\">\r\n		If for any reason, once the prize has been booked, you do not take the prize or an element of the prize at the time stipulated, then the prize or that element of the prize will be forfeited and will not be redeemable for cash. We strongly recommend all components of the prize are booked at the same time to avoid disappointment.</li>\r\n	<li value=\"10\">\r\n		To&nbsp; book the holiday prize, select what dates you would like to travel then call Queenstown Holidays on 1300 552 235 &nbsp;and one of our reservations staff will assist you with booking your holiday. Please have your holiday certificate handy to quote the certificate number when making your booking which is located on the front of the certificate.</li>\r\n</ol>\r\n','<p>\r\n	We&#39;re giving <strong>you and</strong> <strong>3 lucky friends the chance to WIN the Ultimate Queenstown Holiday! </strong>Experience 5 nights staying at ALTA Apartments with an action-packed itinerary that will see you experience all the very best Queenstown has to offer!</p>\r\n<p>\r\n	SIMPLY FILL OUT THE FORM BELOW FOR YOUR CHANCE TO WIN!</p>\r\n<p>\r\n	<strong>THE PRIZE:</strong></p>\r\n<ul>\r\n	<li>\r\n		<strong>5 NIGHTS ACCOMMODATION</strong> for up to 4 Guests in a Luxury 2 Bedroom Apartment at ALTA Apartments, Queenstown</li>\r\n	<li>\r\n		<strong>$1,000 FLIGHT VOUCHER</strong> with Air New Zealand</li>\r\n	<li>\r\n		30 Minute <strong>SCENIC HELICOPTER FLIGHT </strong>with Over the Top</li>\r\n	<li>\r\n		<strong>$250 DINING VOUCHER</strong> at Prime Waterfront Restaurant &amp; Bar</li>\r\n	<li>\r\n		4x <strong>THUNDER JET BOAT</strong> Rides</li>\r\n	<li>\r\n		4x <strong>MILLION DOLLAR BOAT CRUISE</strong></li>\r\n	<li>\r\n		<strong>$250 BODY SANCTUM </strong>Spa Voucher</li>\r\n	<li>\r\n		2x <strong>PARAGLIDING FLIGHTS </strong>with G-Force Queenstown</li>\r\n</ul>\r\n<p>\r\n	&nbsp;The winner will be announced at 5pm (AEST) on the 24th December 2015. Good Luck!!!</p>\r\n<p>\r\n	Prize values are NZ$</p>\r\n','2015-10-01 10:50:32','2015-12-23 17:00:59'),(9,'Win a 5 Star Luxury Escape at the Hilton Surfers Paradise','survey-2015-09-16-08-51-02.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN 3 LUXURY NIGHTS AT THE HILTON SURFERS PARADISE!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is Three nights accommodation at the Hilton Surfers Paradise for two people in an Hilton Deluxe room and includes 2 for 1 Breakfast daily, 2x $25 vouchers for Salt Grill, 2x $25 vouchers for eForea Day Spa, 2 for 1 cocktail at Fix Bar, a bottle of wine on arrival, free wifi and undercover parking.</li>\r\n	<li>\r\n		Prize is valued at $1324</li>\r\n	<li>\r\n		The Competition starts 16/09/15 and ends 12am 30/09/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 30/09/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 30/09/15. A re-draw will take place on 30/10/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>3 Nights In A Luxury Hilton Deluxe Room </strong>at the Hilton Surfers Paradise on the Gold Coast!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>2 For 1</strong> Breakfast Daily</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>2x $25 Vouchers </strong>For both Salt Grill Restuarant and eForea Day Spa ($50 in total each)</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Free Wifi, Bottle of wine on arrival and undercover parking!</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 12pm on Wednesday the 30th September. Good luck!</p>\r\n','2015-09-16 15:26:24','2015-09-30 00:00:59'),(8,'Win a 5 Star Escape at Hilton Surfers Paradise!','survey-2015-09-14-11-30-27.jpg','<p>\r\n	<strong>Terms and Conditions</strong></p>\r\n<p>\r\n	Note: Flights are not included in the prize.</p>\r\n<p>\r\n	<strong>UPDATE REAL T&amp;Cs</strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is ......</li>\r\n	<li>\r\n		Prize is valued at $....</li>\r\n	<li>\r\n		The Competition starts ../04/15 and ends 12am ../04/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 01/05/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 01/05/15. A re-draw will take place on 01/06/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n<p>\r\n</p>\r\n','<p>\r\n	Simply fill in the below entry form for your chance to win a romantic escape for two people staying at the world-renowned 5 Star Hilton Surfers Paradise including:</p>\r\n<ul>\r\n	<li>\r\n		3 Nights in a Deluxe Room</li>\r\n	<li>\r\n		Welcome Bottle of Wine</li>\r\n	<li>\r\n		$25 Spa &amp; Salt Grill Dining Vouchers</li>\r\n	<li>\r\n		Free WiFi &amp; Secure Parking</li>\r\n	<li>\r\n		2 for 1 Breakfast</li>\r\n	<li>\r\n		+ Option to receive and extra entry for opting in.</li>\r\n</ul>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n','2015-09-14 11:55:25','2015-09-18 17:00:59'),(7,'Towers Of Chevron Giveaway','survey-2015-08-11-15-02-18.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A FUN FAMILY GETAWAY!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is a five night holiday for up to four people staying at Towers Of Chevron Renaissance in a two bedroom apartment. Includes Kids Eat Free Voucher at Northcliffe Surfclub and a Passport 2 Fun.</li>\r\n	<li>\r\n		Prize is valued at $665</li>\r\n	<li>\r\n		The Competition starts 11/08/15 and ends 10am 20/08/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 20/08/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland Facebook page or website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Facebook entry: Entrants must fill out the form supplied on the Discover Queensland Facebook App. Entrants who refer friends to the competition by sharing the SUPPLIED link will receive one additional entry for each referred person.</li>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		By signing up to our newsletter you receive and extra entry into the competition and you agree to receive future communications and will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 20/08/15. A re-draw will take place on 20/09/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h4 style=\"padding: 10px;\">\r\n	Win a 5 night stay at the amazing Towers of Chevron Renaissance in a 2 bedroom apartment for 4 people! Enjoy the amazing views and hige lagoon swimming pool in the prime location of central Surfers Paradise.</h4>\r\n<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>5 Nights In A 2 Bedroom, 2 Bathroom Apartment</strong> at the 4 Star Towers Of Chevron Renaissance on the Gold Coast.</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span style=\"font-size:16px;\"><strong>Kids Eat FREE </strong>at Northcliffe Surf Life Saving Club</span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span style=\"font-size:16px;\"><strong>FREE Passport 2 Fun </strong>for use during your stay including:</span></p>\r\n				<p>\r\n					<span style=\"font-size:16px;\">- <strong>$30 Endota</strong> <strong>Spa Voucher </strong><span style=\"font-size:12px;\">(unlimited usage with conditions)</span></span></p>\r\n				<p>\r\n					<span style=\"font-size:16px;\">- <strong>$40 Credit Per Adult</strong> ticket for Whale Watch Cruise or Broadwater Island Cruise</span></p>\r\n				<p>\r\n					<span style=\"font-size:16px;\">- <strong>25% off Dining </strong>at Baritalia, Yellowfin &amp; Sage Restaurants*</span></p>\r\n				<p>\r\n					<span style=\"font-size:16px;\">- Plus <strong>awesome discounts</strong> on a great range of popular Gold Coast tours &amp; attractions including Jet Boat Extreme, Infinity, Dolphin Cruise &amp; more!</span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span style=\"font-size:16px;\"><strong>Great Family Facilities</strong> at the resorts famous &#39;Beaches in the Sky&#39; recreation area featuring expansive lagoon pool with white sandy beaches &amp; grotto spas, health pavillion with heated indoor pool &amp; gym, entertainment areas &amp; more...!</span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 10am on Thursday the 20th August. Good luck!</p>\r\n<div style=\" background:#135694; padding:20px 0px ; text-align:center; width: 100%; margin-top:100px;\">\r\n	<h4 style=\"color:#fff;\">\r\n		ðŸ‘ Like Discover Queensland on Facebook for more great competitions, giveaways and amazing holiday deals!</h4>\r\n</div>\r\n<br />\r\n<br />\r\n<div style=\"text-align: center;\">\r\n	<div class=\"fb-page\" data-adapt-container-width=\"true\" data-height=\"600\" data-hide-cover=\"false\" data-href=\"https://www.facebook.com/discoverqueensland\" data-show-facepile=\"true\" data-show-posts=\"false\" data-small-header=\"false\" data-width=\"800\">\r\n		<div class=\"fb-xfbml-parse-ignore\">\r\n			<blockquote cite=\"https://www.facebook.com/discoverqueensland\">\r\n				<a href=\"https://www.facebook.com/discoverqueensland\">Discover Queensland</a></blockquote>\r\n		</div>\r\n	</div>\r\n</div>\r\n<p>\r\n</p>\r\n','2015-08-17 11:20:08','2015-08-20 10:00:59'),(5,'Region Training - Sunshine Coast','','','Training test for staff on Sunshine Coast','2015-04-27 11:03:28','2015-04-27 00:00:59'),(4,'Marriott Surfers Paradise Resort And Spa Competition','survey-2015-04-14-14-10-40.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A LUXURY WEEKEND AT THE MARRIOTT SURFERS PARADISE RESORT AND SPA!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is TWO nights accommodation at the Marriott Surfers Paradise Resort and spa for two people in an ocean view room. Includes buffet breakfast for two daily, a bottle of wine on arrival, free wifi, undercover parking and 12pm late checkout.</li>\r\n	<li>\r\n		Prize is valued at $804</li>\r\n	<li>\r\n		The Competition starts 14/04/15 and ends 12am 31/04/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 01/05/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 01/05/15. A re-draw will take place on 01/06/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>2 Nights In A Luxury Ocean View Room </strong>at the Marriott Surfers Paradise Resort And Spa on the Gold Coast!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Buffet Breakfast</strong> for two daily!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>BONUS </strong>12pm late check-out</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Free Wifi, Bottle of wine on arrival and undercover parking!</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 12pm on Friday the 1st May. Good luck!</p>\r\n','2015-09-16 06:56:41','2015-04-30 00:00:59'),(3,'Discover Queensland Phone Questionnaire for Mobile Site Development ','','.','Questionnaire to better understand our current customers and how they use their mobile and tablet devices to research and book accommodation to determine parameters for mobile website development. ','2015-04-08 14:09:31','2024-04-15 00:00:59'),(2,'Oaks Oasis 3DS Comp 20/03/15','survey-2015-03-24-14-07-43.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A SUNSHINE COAST FAMILY GETAWAY!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is a three night holiday for two adults and two children under 13 staying at the Oaks Oasis Resort in Caloundra. Includes kids eat free at the onsite restaurant, a bottle of wine on arrival, free wifi and 12pm late checkout.</li>\r\n	<li>\r\n		Prize is valued at $804</li>\r\n	<li>\r\n		The Competition starts 24/03/15 and ends 12am 07/03/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am, 24/02/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland Facebook page or website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Facebook entry: Entrants must fill out the form supplied on the Discover Queensland Facebook App. Entrants who refer friends to the competition by sharing the SUPPLIED link will receive one additional entry for each referred person.</li>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 07/03/15. A re-draw will take place on 07/04/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h4 style=\"padding: 10px;\">\r\n	Would you like to treat the family to the ultimate Sunshine Coast family Holiday? To enter simply fill in the form below and don&#39;t forget to check out the video so you can see how amazing this place really is!</h4>\r\n<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>3 Nights In An Executive Family Room</strong> for 2 adults and 2 children at the Oaks Oasis on the Sunshine Coast.</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Kids</strong> eat breakfast FREE!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>BONUS </strong>12pm late check-out</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Free Wifi, Bottle of wine on arrival and unlimited access to the family waterpark!</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 12pm on Tuesday the 7th April. Good luck!</p>\r\n','2015-03-24 14:07:43','2015-04-07 10:00:59'),(1,'Win A Sunshine Coast Family Holiday!','survey-2015-07-09-16-09-35.jpg','<p align=\"center\">\r\n	<strong class=\"enternow\">WIN A FUN FAMILY GETAWAY!<br />\r\n	COMPETITION TERMS AND CONDITIONS </strong></p>\r\n<ul>\r\n	<li>\r\n		Prize is a four night holiday for up to six people staying at Grand Mercure Twin Waters in a two or 3 bedroom apartment. Includes complimentary water activities including water trampolines, canoes, windsurfing and catamarans and access to all resort facilities at the adjacent Novotel resort including kid&#39;s club, bar and restaurants, circus school, daily activities and more.</li>\r\n	<li>\r\n		Prize is valued at $972</li>\r\n	<li>\r\n		The Competition starts 09/07/15 and ends 12am 30/07/15 AEST.</li>\r\n	<li>\r\n		The Competition is open to Australian and New Zealand residents only aged 18 years or older.</li>\r\n	<li>\r\n		The Draw will be conducted at 79B Scarborough Street, Southport, QLD 4227 at 10.00 am,30/07/15.</li>\r\n	<li>\r\n		Entry is via the Discover Queensland Facebook page or website.</li>\r\n</ul>\r\n<ol>\r\n	<li>\r\n		Facebook entry: Entrants must fill out the form supplied on the Discover Queensland Facebook App. Entrants who refer friends to the competition by sharing the SUPPLIED link will receive one additional entry for each referred person.</li>\r\n	<li>\r\n		Website entry: Entrants must visit www.discoverqueensland.com.au/competition then complete the details requested and send the data by clicking on &ldquo;Enter Now&rdquo;. Entrants who refer friends to the competition will receive one additional entry for each referred person.</li>\r\n</ol>\r\n<ul>\r\n	<li>\r\n		Entrants who opt in for future communications will be recorded in Discover Queensland&#39;s database.</li>\r\n	<li>\r\n		The winner will be notified by email and announced on Facebook (facebook.com/discoverqueensland) on 30/07/15. A re-draw will take place on 30/08/15 if prize winner is not able to be contacted within 30 days of the original draw date.</li>\r\n	<li>\r\n		The Promoter is LeisureCom Group Ltd, 79B Scarborough Street, Southport Qld 4215 ABN 84 143 885 367 Phone: 1300 788 553.</li>\r\n</ul>\r\n','<h4 style=\"padding: 10px;\">\r\n	Would you like to treat the family to the ultimate Sunshine Coast family Holiday? To enter simply fill in the form below and don&#39;t forget to check out the video so you can see how amazing this place really is!</h4>\r\n<h2>\r\n	This amazing prize package includes:</h2>\r\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"652\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>4 Nights In A Luxury 2 Bedroom Apartment</strong> at the 4.5 Star Grand Mercure Apartments Twin Waters on the Sunshine Coast.</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>Complimentary water activities</strong> including water trampolines, canoes, windsurfing and catamarans the whole family will love!</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\"><strong>BONUS </strong>12pm late check-out</span></span></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td valign=\"top\" width=\"30\">\r\n				<img alt=\"\" border=\"0\" height=\"17\" src=\"https://odms.leisurecom.com/newsletters/offers/10/t-tick.gif\" width=\"16\" /></td>\r\n			<td valign=\"top\">\r\n				<p>\r\n					<span class=\"opensans\"><span style=\"font-size:16px;\">Access to all <strong>resort facilities at the adjacent Novotel Resort</strong> including kids club, bar and restaurants, daily activities, water park... and more!</span></span></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p style=\"text-align:center;\">\r\n	The winner will be announced at 10am on Thursday the 30th July. Good luck!</p>\r\n<p style=\"text-align:center;\">\r\n</p>\r\n<div style=\"text-align: center;\">\r\n	<iframe allowfullscreen=\"\" frameborder=\"0\" height=\"315\" src=\"https://www.youtube.com/embed/h0ViZQpP_8w\" width=\"560\"></iframe></div>\r\n<div style=\"text-align: center;\">\r\n</div>\r\n<div style=\" background:#135694; padding:20px 0px ; text-align:center; width: 100%; margin-top:100px;\">\r\n	<h4 style=\"color:#fff;\">\r\n		ðŸ‘ Like Discover Queensland on Facebook for more great competitions, giveaways and amazing holiday deals!</h4>\r\n</div>\r\n<br />\r\n<br />\r\n<div style=\"text-align: center;\">\r\n	<div class=\"fb-page\" data-adapt-container-width=\"true\" data-height=\"600\" data-hide-cover=\"false\" data-href=\"https://www.facebook.com/discoverqueensland\" data-show-facepile=\"true\" data-show-posts=\"false\" data-small-header=\"false\" data-width=\"800\">\r\n		<div class=\"fb-xfbml-parse-ignore\">\r\n			<blockquote cite=\"https://www.facebook.com/discoverqueensland\">\r\n				<a href=\"https://www.facebook.com/discoverqueensland\">Discover Queensland</a></blockquote>\r\n		</div>\r\n	</div>\r\n</div>\r\n<p>\r\n</p>\r\n','2015-07-27 11:30:07','2015-07-30 12:00:59');

--
-- Table structure for table `tags`
--

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

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

INSERT INTO `tags` VALUES (13,'Retreats & Lodges'),(12,'Luxury'),(11,'Island Resort'),(10,'Farmstay'),(8,'Holiday Park'),(7,'Bed & Breakfast'),(6,'Motel'),(5,'Holiday Houses'),(4,'Backpacker'),(3,'Resort'),(2,'Hotel'),(1,'Apartment');

--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) NOT NULL,
  `TeamType` enum('Reservations','Holiday Consultants') NOT NULL,
  `Description` text NOT NULL,
  `DisplayBreaks` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `DisplayOnHome` enum('Yes','No') NOT NULL DEFAULT 'No',
  `DisplayRoster` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

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

INSERT INTO `team` VALUES (36,'FairGo Finance ','Holiday Consultants','Outbound Campaign ','Yes','No','No'),(35,'Entertainment Book Campaign','Holiday Consultants','','Yes','No','No'),(32,'Executives','Reservations','','Yes','No','No'),(31,'IT Team','','','Yes','No','No'),(30,'Finance and Administration','','','Yes','No','No'),(29,'Marketing','','','Yes','No','No'),(27,'Members - Tarnia','Reservations','membership reservations','No','Yes','Yes'),(25,'Day Team','Holiday Consultants','','Yes','Yes','Yes'),(12,'Evening Team','Holiday Consultants','','Yes','Yes','Yes'),(10,'Online','Reservations','','Yes','Yes','No'),(4,'Retail Team  - Logan','Reservations','Retail Team ','No','Yes','Yes');

--
-- Table structure for table `temp_packagepurchase`
--

CREATE TABLE `temp_packagepurchase` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `PurchaseDate` datetime DEFAULT NULL,
  `PackageName` text,
  `PackageID` int(11) DEFAULT '0',
  `PackageInclusions` text NOT NULL,
  `TotalCost` decimal(10,2) DEFAULT NULL,
  `RepeatTotalCost` decimal(10,2) DEFAULT '0.00',
  `Factored` decimal(10,2) DEFAULT '0.00',
  `GuestsID` int(10) unsigned DEFAULT NULL,
  `OperatorsID` int(10) unsigned DEFAULT NULL,
  `OperatorsName` varchar(50) DEFAULT NULL,
  `RepeatBillCode` varchar(50) DEFAULT NULL,
  `DistributionsID` int(10) unsigned DEFAULT NULL,
  `IsRenewal` enum('Yes','No') NOT NULL DEFAULT 'No',
  `Occurrence` varchar(100) DEFAULT NULL,
  `IsActive` enum('Yes','No') DEFAULT 'Yes',
  `CanBeDispatched` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`),
  KEY `GuestsID` (`GuestsID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `thirdpartyrates`
--

CREATE TABLE `thirdpartyrates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `RoomRate` decimal(10,2) NOT NULL,
  `PropertyDirect` decimal(10,2) NOT NULL,
  `IncGuests` int(5) NOT NULL,
  `IncludedCAX` int(5) NOT NULL DEFAULT '0',
  `ExtraPAX` decimal(10,2) NOT NULL,
  `ExtraCAX` decimal(10,2) NOT NULL,
  `MinNights` int(5) NOT NULL,
  `SDate` date NOT NULL,
  `Inclusions` text NOT NULL,
  `RoomsID` int(10) NOT NULL,
  `PlanID` int(10) NOT NULL DEFAULT '0',
  `FeedStatus` enum('Open','Close') NOT NULL DEFAULT 'Open',
  `LastUpdate` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `SDate` (`SDate`),
  KEY `RoomsID` (`RoomsID`),
  KEY `MinNights` (`MinNights`)
) ENGINE=MyISAM AUTO_INCREMENT=1560028519 DEFAULT CHARSET=latin1;

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

INSERT INTO `thirdpartyrates` VALUES (1560028518,1000.00,1000.00,4,0,0.00,0.00,1,'2021-08-22','',61289,0,'Open','2020-08-24 02:26:45'),(1560028517,435.70,544.62,2,0,0.00,0.00,1,'2021-08-22','',61288,0,'Open','2020-08-24 02:26:45'),(1560028516,201.60,252.00,4,0,28.00,28.00,7,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028515,201.60,252.00,4,0,28.00,28.00,7,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028514,201.60,252.00,4,0,28.00,28.00,7,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028513,201.60,252.00,4,0,28.00,28.00,7,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028512,201.60,252.00,4,0,28.00,28.00,7,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028511,201.60,252.00,4,0,28.00,28.00,7,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028510,201.60,252.00,4,0,28.00,28.00,7,'2020-11-30','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028509,201.60,252.00,4,0,28.00,28.00,7,'2020-11-29','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38251,0,'Open','2020-08-24 02:15:15'),(1560028508,208.80,261.00,4,0,32.00,32.00,5,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028507,208.80,261.00,4,0,32.00,32.00,5,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028506,208.80,261.00,4,0,32.00,32.00,5,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028505,208.80,261.00,4,0,32.00,32.00,5,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028504,208.80,261.00,4,0,32.00,32.00,5,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028503,208.80,261.00,4,0,32.00,32.00,5,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028502,208.80,261.00,4,0,32.00,32.00,5,'2020-11-30','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028501,208.80,261.00,4,0,32.00,32.00,5,'2020-11-29','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',38249,0,'Open','2020-08-24 02:15:14'),(1560028500,220.00,275.00,4,0,28.00,28.00,3,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028499,220.00,275.00,4,0,28.00,28.00,3,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028498,220.00,275.00,4,0,28.00,28.00,3,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028497,220.00,275.00,4,0,28.00,28.00,3,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028496,220.00,275.00,4,0,28.00,28.00,3,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028495,220.00,275.00,4,0,28.00,28.00,3,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028494,220.00,275.00,4,0,28.00,28.00,3,'2020-11-30','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028493,220.00,275.00,4,0,28.00,28.00,3,'2020-11-29','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',37894,0,'Open','2020-08-24 02:15:14'),(1560028492,145.60,182.00,4,0,32.00,32.00,7,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64780,0,'Open','2020-08-24 02:15:13'),(1560028491,145.60,182.00,4,0,32.00,32.00,7,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64780,0,'Open','2020-08-24 02:15:13'),(1560028490,145.60,182.00,4,0,32.00,32.00,7,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64780,0,'Open','2020-08-24 02:15:13'),(1560028489,145.60,182.00,4,0,32.00,32.00,7,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64780,0,'Open','2020-08-24 02:15:13'),(1560028488,145.60,182.00,4,0,32.00,32.00,7,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64780,0,'Open','2020-08-24 02:15:13'),(1560028487,145.60,182.00,4,0,32.00,32.00,7,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64780,0,'Open','2020-08-24 02:15:13'),(1560028486,151.20,189.00,4,0,32.00,32.00,5,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64781,0,'Open','2020-08-24 02:15:12'),(1560028485,151.20,189.00,4,0,32.00,32.00,5,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64781,0,'Open','2020-08-24 02:15:12'),(1560028484,151.20,189.00,4,0,32.00,32.00,5,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64781,0,'Open','2020-08-24 02:15:12'),(1560028483,151.20,189.00,4,0,32.00,32.00,5,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64781,0,'Open','2020-08-24 02:15:12'),(1560028482,151.20,189.00,4,0,32.00,32.00,5,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64781,0,'Open','2020-08-24 02:15:12'),(1560028481,151.20,189.00,4,0,32.00,32.00,5,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n',64781,0,'Open','2020-08-24 02:15:12'),(1560028480,159.20,199.00,4,0,32.00,32.00,3,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',64782,0,'Open','2020-08-24 02:15:11'),(1560028479,159.20,199.00,4,0,32.00,32.00,3,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',64782,0,'Open','2020-08-24 02:15:11'),(1560028478,159.20,199.00,4,0,32.00,32.00,3,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',64782,0,'Open','2020-08-24 02:15:11'),(1560028477,159.20,199.00,4,0,32.00,32.00,3,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',64782,0,'Open','2020-08-24 02:15:11'),(1560028476,159.20,199.00,4,0,32.00,32.00,3,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',64782,0,'Open','2020-08-24 02:15:11'),(1560028475,159.20,199.00,4,0,32.00,32.00,3,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',64782,0,'Open','2020-08-24 02:15:11'),(1560028474,112.00,140.00,4,0,32.00,32.00,7,'2020-12-06','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',66061,0,'Open','2020-08-24 02:15:11'),(1560028473,112.00,140.00,4,0,32.00,32.00,7,'2020-12-05','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',66061,0,'Open','2020-08-24 02:15:11'),(1560028472,112.00,140.00,4,0,32.00,32.00,7,'2020-12-04','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',66061,0,'Open','2020-08-24 02:15:11'),(1560028471,112.00,140.00,4,0,32.00,32.00,7,'2020-12-03','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',66061,0,'Open','2020-08-24 02:15:11'),(1560028470,112.00,140.00,4,0,32.00,32.00,7,'2020-12-02','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',66061,0,'Open','2020-08-24 02:15:11'),(1560028469,112.00,140.00,4,0,32.00,32.00,7,'2020-12-01','INCLUDES UNLIMITED ENTERTAINMENT PACKAGE FREE WIFI & FOXTEL SPECIAL COVID-19 RELAXED TERMS:  Payment can be made up to 3 Days prior to travel. Amendments or cancellations are permitted up to 3 days prior to travel at no charge.  Within 72 hours and no-shows - no refunds or cancellations permitted.\r\nUntil further notice please refer to our special flexible conditions. \r\nExtra Person rate is not eligible for the discount.  On arrival AUD $200 credit card pre-authorisation required.\r\n\r\n',66061,0,'Open','2020-08-24 02:15:11');

--
-- Table structure for table `thirdpartyratesqueue`
--

CREATE TABLE `thirdpartyratesqueue` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `RoomRate` decimal(10,2) NOT NULL,
  `PropertyDirect` decimal(10,2) NOT NULL,
  `IncGuests` int(5) NOT NULL,
  `IncludedCAX` int(5) NOT NULL DEFAULT '0',
  `ExtraPAX` decimal(10,2) NOT NULL,
  `ExtraCAX` decimal(10,2) NOT NULL,
  `MinNights` int(5) NOT NULL,
  `SDate` date NOT NULL,
  `Inclusions` text NOT NULL,
  `RoomsID` int(10) NOT NULL,
  `PlanID` int(10) NOT NULL DEFAULT '0',
  `FeedStatus` enum('Open','Close') NOT NULL DEFAULT 'Open',
  `LastUpdate` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `SDate` (`SDate`),
  KEY `RoomsID` (`RoomsID`),
  KEY `MinNights` (`MinNights`)
) ENGINE=MyISAM AUTO_INCREMENT=44991367 DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `thirdpartystaypay`
--

CREATE TABLE `thirdpartystaypay` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sale_start_dt` date NOT NULL,
  `sale_end_dt` date NOT NULL,
  `stay_nights` int(10) NOT NULL DEFAULT '0',
  `pay_nights` int(10) NOT NULL DEFAULT '0',
  `frequency` int(10) NOT NULL DEFAULT '0',
  `advance_purchase` int(10) NOT NULL DEFAULT '0',
  `extra_guests_pay` enum('Yes','No') NOT NULL DEFAULT 'No',
  `room_id` int(10) NOT NULL DEFAULT '0',
  `stay_pay_code` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sale_start_dt` (`sale_start_dt`),
  KEY `sale_end_dt` (`sale_end_dt`),
  KEY `room_id` (`room_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2880 DEFAULT CHARSET=latin1;

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

INSERT INTO `thirdpartystaypay` VALUES (2879,'2020-08-04','2020-08-18',7,5,1,0,'No',65901,'tHlPi0'),(2878,'2020-08-04','2020-08-18',7,5,1,0,'No',44322,'tHlPi0'),(2877,'2020-08-04','2020-08-18',7,5,1,0,'No',65900,'tHlPi0'),(2876,'2020-08-04','2020-08-18',7,5,1,0,'No',65899,'tHlPi0'),(2875,'2020-08-04','2020-08-18',7,5,1,0,'No',44319,'tHlPi0'),(2874,'2020-08-04','2020-08-18',7,5,1,0,'No',65898,'tHlPi0'),(2873,'2020-08-04','2020-08-18',7,5,1,0,'No',44317,'tHlPi0'),(2872,'2020-08-04','2020-08-18',7,5,1,0,'No',65897,'tHlPi0'),(2871,'2020-08-04','2020-08-18',7,5,1,0,'No',65896,'tHlPi0'),(2870,'2020-08-04','2020-08-18',7,5,1,0,'No',65895,'tHlPi0'),(2869,'2020-08-04','2020-08-18',7,5,1,0,'No',44316,'tHlPi0'),(2868,'2020-08-04','2020-08-18',7,5,1,0,'No',65894,'tHlPi0'),(2867,'2020-08-04','2020-08-18',7,5,1,0,'No',65893,'tHlPi0'),(2866,'2020-08-04','2020-08-18',7,5,1,0,'No',65892,'tHlPi0'),(2865,'2020-08-04','2020-08-18',7,5,1,0,'No',65891,'tHlPi0'),(2864,'2020-08-04','2020-08-18',7,5,1,0,'No',65890,'tHlPi0'),(2863,'2020-08-04','2020-08-18',7,5,1,0,'No',65889,'tHlPi0'),(2862,'2020-08-04','2020-08-18',7,5,1,0,'No',65888,'tHlPi0'),(2861,'2020-08-04','2020-08-18',7,5,1,0,'No',44315,'tHlPi0'),(2860,'2020-08-04','2020-08-18',7,5,1,0,'No',44313,'tHlPi0'),(2859,'2020-08-04','2020-08-18',7,5,1,0,'No',65887,'tHlPi0'),(2858,'2020-08-04','2020-08-18',7,5,1,0,'No',65886,'tHlPi0'),(2857,'2020-08-04','2020-08-18',7,5,1,0,'No',44312,'tHlPi0'),(2856,'2020-08-04','2020-08-18',7,5,1,0,'No',65885,'tHlPi0'),(2855,'2020-08-04','2020-08-18',7,5,1,0,'No',65884,'tHlPi0'),(2854,'2020-08-04','2020-08-18',7,5,1,0,'No',65883,'tHlPi0'),(2853,'2020-08-04','2020-08-18',7,5,1,0,'No',65882,'tHlPi0'),(2852,'2020-08-04','2020-08-18',7,5,1,0,'No',65881,'tHlPi0'),(2851,'2020-08-04','2020-08-18',7,5,1,0,'No',65880,'tHlPi0'),(2850,'2020-08-04','2020-08-18',7,5,1,0,'No',65879,'tHlPi0'),(2849,'2020-08-04','2020-08-18',7,5,1,0,'No',44311,'tHlPi0'),(2848,'2020-08-04','2020-08-18',4,3,1,0,'No',65901,'rSsgOJ'),(2847,'2020-08-04','2020-08-18',4,3,1,0,'No',44322,'rSsgOJ'),(2846,'2020-08-04','2020-08-18',4,3,1,0,'No',65900,'rSsgOJ'),(2845,'2020-08-04','2020-08-18',4,3,1,0,'No',65899,'rSsgOJ'),(2844,'2020-08-04','2020-08-18',4,3,1,0,'No',44319,'rSsgOJ'),(2843,'2020-08-04','2020-08-18',4,3,1,0,'No',65898,'rSsgOJ'),(2842,'2020-08-04','2020-08-18',4,3,1,0,'No',44317,'rSsgOJ'),(2841,'2020-08-04','2020-08-18',4,3,1,0,'No',65897,'rSsgOJ'),(2840,'2020-08-04','2020-08-18',4,3,1,0,'No',65896,'rSsgOJ'),(2839,'2020-08-04','2020-08-18',4,3,1,0,'No',65895,'rSsgOJ'),(2838,'2020-08-04','2020-08-18',4,3,1,0,'No',44316,'rSsgOJ'),(2837,'2020-08-04','2020-08-18',4,3,1,0,'No',65894,'rSsgOJ'),(2836,'2020-08-04','2020-08-18',4,3,1,0,'No',65893,'rSsgOJ'),(2835,'2020-08-04','2020-08-18',4,3,1,0,'No',65892,'rSsgOJ'),(2834,'2020-08-04','2020-08-18',4,3,1,0,'No',65891,'rSsgOJ'),(2833,'2020-08-04','2020-08-18',4,3,1,0,'No',65890,'rSsgOJ'),(2832,'2020-08-04','2020-08-18',4,3,1,0,'No',65889,'rSsgOJ'),(2831,'2020-08-04','2020-08-18',4,3,1,0,'No',65888,'rSsgOJ'),(2830,'2020-08-04','2020-08-18',4,3,1,0,'No',44315,'rSsgOJ');

--
-- Table structure for table `thirdpartystaypaydate`
--

CREATE TABLE `thirdpartystaypaydate` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `stay_pay_dt` date NOT NULL,
  `stay_pay_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `stay_pay_id` (`stay_pay_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1697799 DEFAULT CHARSET=latin1;

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

INSERT INTO `thirdpartystaypaydate` VALUES (1697798,'2020-10-15',2879),(1697797,'2020-10-15',2878),(1697796,'2020-10-15',2877),(1697795,'2020-10-15',2876),(1697794,'2020-10-15',2875),(1697793,'2020-10-15',2874),(1697792,'2020-10-15',2873),(1697791,'2020-10-15',2872),(1697790,'2020-10-15',2871),(1697789,'2020-10-15',2870),(1697788,'2020-10-15',2869),(1697787,'2020-10-15',2868),(1697786,'2020-10-15',2867),(1697785,'2020-10-15',2866),(1697784,'2020-10-15',2865),(1697783,'2020-10-15',2864),(1697782,'2020-10-15',2863),(1697781,'2020-10-15',2862),(1697780,'2020-10-15',2861),(1697779,'2020-10-15',2860),(1697778,'2020-10-15',2859),(1697777,'2020-10-15',2858),(1697776,'2020-10-15',2857),(1697775,'2020-10-15',2856),(1697774,'2020-10-15',2855),(1697773,'2020-10-15',2854),(1697772,'2020-10-15',2853),(1697771,'2020-10-15',2852),(1697770,'2020-10-15',2851),(1697769,'2020-10-15',2850),(1697768,'2020-10-15',2849),(1697767,'2020-10-14',2879),(1697766,'2020-10-14',2878),(1697765,'2020-10-14',2877),(1697764,'2020-10-14',2876),(1697763,'2020-10-14',2875),(1697762,'2020-10-14',2874),(1697761,'2020-10-14',2873),(1697760,'2020-10-14',2872),(1697759,'2020-10-14',2871),(1697758,'2020-10-14',2870),(1697757,'2020-10-14',2869),(1697756,'2020-10-14',2868),(1697755,'2020-10-14',2867),(1697754,'2020-10-14',2866),(1697753,'2020-10-14',2865),(1697752,'2020-10-14',2864),(1697751,'2020-10-14',2863),(1697750,'2020-10-14',2862),(1697749,'2020-10-14',2861);

--
-- Table structure for table `timeoff`
--

CREATE TABLE `timeoff` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `DateCreated` datetime NOT NULL,
  `DateApproved` datetime NOT NULL,
  `AdministratorsID` int(10) NOT NULL,
  `LeaveType` varchar(200) NOT NULL,
  `Comment` text NOT NULL,
  `DateOff` date NOT NULL,
  `Period` enum('Half Day','Full Day') NOT NULL DEFAULT 'Full Day',
  `IsApproved` enum('Yes','No','Pending') NOT NULL DEFAULT 'Pending',
  `ApprovedBy` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `AdministratorsID` (`AdministratorsID`)
) ENGINE=MyISAM AUTO_INCREMENT=9827 DEFAULT CHARSET=latin1;

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

INSERT INTO `timeoff` VALUES (9826,'2020-08-18 08:41:41','2020-08-18 08:42:07',997,'Personal Leave','SICK','2020-08-18','Full Day','Yes',34),(9825,'2020-08-12 15:55:05','2020-08-17 08:58:56',249,'Annual Leave','Mothers Birthday','2020-09-30','Full Day','Yes',16),(9824,'2020-08-12 15:55:05','2020-08-17 08:58:56',249,'Annual Leave','Mothers Birthday','2020-09-29','Full Day','Yes',16),(9823,'2020-08-12 15:55:05','2020-08-17 08:58:56',249,'Annual Leave','Mothers Birthday','2020-09-28','Full Day','Yes',16),(9822,'2020-08-10 09:04:49','2020-08-10 09:05:09',467,'Personal Leave','SICK LEAVE','2020-08-04','Full Day','Yes',34),(9821,'2020-08-03 13:21:31','2020-08-06 12:23:34',1207,'Annual Leave','','2020-10-30','Full Day','Yes',34),(9820,'2020-08-03 13:21:23','2020-08-06 12:23:34',1207,'Annual Leave','','2020-10-29','Full Day','Yes',34),(9819,'2020-08-03 13:21:15','2020-08-06 12:23:34',1207,'Annual Leave','','2020-10-28','Full Day','Yes',34),(9818,'2020-08-03 13:21:04','2020-08-06 12:23:34',1207,'Annual Leave','','2020-10-27','Full Day','Yes',34),(9817,'2020-08-03 13:20:52','2020-08-06 12:23:34',1207,'Annual Leave','','2020-10-26','Full Day','Yes',34),(9816,'2020-08-03 13:20:35','2020-08-06 12:23:34',1207,'Annual Leave','','2020-10-23','Full Day','Yes',34),(9815,'2020-08-03 13:19:46','2020-08-06 12:23:34',1212,'Annual Leave','','2020-10-16','Full Day','Yes',34),(9814,'2020-08-03 13:19:46','2020-08-06 12:23:34',1212,'Annual Leave','','2020-10-15','Full Day','Yes',34),(9813,'2020-07-15 16:15:15','2020-07-15 16:15:33',656,'Annual Leave','','2020-07-08','Half Day','Yes',34),(9812,'2020-07-15 16:14:17','2020-07-15 16:15:33',656,'Annual Leave','','2020-07-08','Half Day','Yes',34),(9811,'2020-07-15 16:13:53','2020-07-15 16:14:41',656,'Annual Leave','Leave','2020-07-07','Full Day','Yes',34),(9810,'2020-07-15 16:13:53','2020-07-15 16:14:41',656,'Annual Leave','Leave','2020-07-06','Full Day','Yes',34),(9809,'2020-07-02 08:30:13','2020-07-14 09:06:12',4,'Annual Leave','Mon 13, Tue 14, Thu 16 & Mon 20 July','2020-07-17','Full Day','Yes',1144),(9808,'2020-07-02 08:30:13','2020-07-14 09:06:12',4,'Annual Leave','Mon 13, Tue 14, Thu 16 & Mon 20 July','2020-07-16','Full Day','Yes',1144),(9807,'2020-07-02 08:30:13','2020-07-14 09:06:12',4,'Annual Leave','Mon 13, Tue 14, Thu 16 & Mon 20 July','2020-07-15','Full Day','Yes',1144),(9806,'2020-07-02 08:30:13','2020-07-14 09:06:12',4,'Annual Leave','Mon 13, Tue 14, Thu 16 & Mon 20 July','2020-07-14','Full Day','Yes',1144),(9805,'2020-07-02 08:30:13','2020-07-15 15:47:41',4,'Annual Leave','Mon 13, Tue 14, Thu 16 & Mon 20 July','2020-07-13','Full Day','Yes',508),(9804,'2020-06-30 11:03:11','2020-07-01 15:40:20',467,'Annual Leave','Friday 28/08/2020, Monday 31/08/2020 & Tuesday 01/09/2020 off work as in Airlie Beach ','2020-08-31','Full Day','Yes',34),(9803,'2020-06-30 11:03:11','2020-07-01 15:40:20',467,'Annual Leave','Friday 28/08/2020, Monday 31/08/2020 & Tuesday 01/09/2020 off work as in Airlie Beach ','2020-08-29','Full Day','Yes',34),(9802,'2020-06-30 11:03:11','2020-07-01 15:40:20',467,'Annual Leave','Friday 28/08/2020, Monday 31/08/2020 & Tuesday 01/09/2020 off work as in Airlie Beach ','2020-08-28','Full Day','Yes',34),(9801,'2020-06-25 10:10:18','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-11','Full Day','Yes',1144),(9800,'2020-06-25 10:10:18','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-10','Full Day','Yes',1144),(9799,'2020-06-25 10:10:18','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-09','Full Day','Yes',1144),(9798,'2020-06-25 10:10:18','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-08','Full Day','Yes',1144),(9797,'2020-06-25 10:10:18','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-07','Full Day','Yes',1144),(9796,'2020-06-25 10:09:54','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-04','Full Day','Yes',1144),(9795,'2020-06-25 10:09:54','2020-07-14 09:06:22',929,'Annual Leave','','2020-09-03','Full Day','Yes',1144),(9794,'2020-06-25 10:09:54','2020-07-14 09:06:21',929,'Annual Leave','','2020-09-02','Full Day','Yes',1144),(9793,'2020-06-25 10:09:54','2020-07-14 09:06:21',929,'Annual Leave','','2020-09-01','Full Day','Yes',1144),(9792,'2020-06-25 10:09:54','2020-07-14 09:06:21',929,'Annual Leave','','2020-08-31','Full Day','Yes',1144),(9791,'2020-06-23 09:08:34','2020-06-30 10:33:52',889,'Personal Leave','','2020-06-25','Full Day','Yes',745),(9790,'2020-06-23 09:07:21','2020-06-30 10:33:52',889,'Personal Leave','','2020-06-24','Full Day','Yes',745),(9789,'2020-06-22 12:00:31','2020-06-26 09:30:53',508,'Annual Leave','','2020-08-04','Full Day','Yes',182),(9788,'2020-06-22 12:00:31','2020-06-26 09:30:52',508,'Annual Leave','','2020-08-03','Full Day','Yes',182),(9787,'2020-06-22 12:00:22','2020-07-15 15:47:41',1144,'Annual Leave','','2020-07-07','Full Day','Yes',508),(9786,'2020-06-16 14:16:11','2020-06-18 13:50:57',929,'Annual Leave','','2020-08-04','Full Day','Yes',1144),(9785,'2020-06-16 14:16:11','2020-06-18 13:50:57',929,'Annual Leave','','2020-08-03','Full Day','Yes',1144),(9784,'2020-06-10 10:52:05','2020-07-15 15:47:41',732,'Personal Leave','SICK LEAVE','2019-06-04','Full Day','Yes',508),(9783,'2020-06-09 07:42:42','2020-06-09 10:14:21',745,'Personal Leave','Sick','2020-06-08','Full Day','Yes',508),(9782,'2020-06-05 10:38:42','2020-07-13 09:13:09',732,'Annual Leave','going away to Airlie beach for partner\'s birthday','2020-09-01','Full Day','No',16),(9781,'2020-06-05 10:38:42','2020-07-13 09:13:09',732,'Annual Leave','going away to Airlie beach for partner\'s birthday','2020-08-31','Full Day','No',16),(9778,'2020-06-05 09:15:34','2020-07-01 15:39:53',997,'Other','','2020-08-13','Full Day','Yes',34),(9777,'2020-06-05 09:15:34','2020-07-01 15:39:53',997,'Other','','2020-08-12','Full Day','Yes',34),(9776,'2020-06-05 09:15:34','2020-07-01 15:39:53',997,'Other','','2020-08-11','Full Day','Yes',34),(9774,'2020-05-19 11:04:19','2020-05-28 09:22:39',4,'Annual Leave','','2020-07-20','Full Day','Yes',1144);

--
-- Table structure for table `timesheets`
--

CREATE TABLE `timesheets` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `DateWE` date NOT NULL,
  `AdministratorsID` int(10) NOT NULL DEFAULT '0',
  `MondayS` varchar(200) NOT NULL,
  `MondayE` varchar(200) NOT NULL,
  `MondayB` varchar(200) NOT NULL,
  `TuesdayS` varchar(200) NOT NULL,
  `TuesdayE` varchar(200) NOT NULL,
  `TuesdayB` varchar(200) NOT NULL,
  `WednesdayS` varchar(200) NOT NULL,
  `WednesdayE` varchar(200) NOT NULL,
  `WednesdayB` varchar(200) NOT NULL,
  `ThursdayS` varchar(200) NOT NULL,
  `ThursdayE` varchar(200) NOT NULL,
  `ThursdayB` varchar(200) NOT NULL,
  `FridayS` varchar(200) NOT NULL,
  `FridayE` varchar(200) NOT NULL,
  `FridayB` varchar(200) NOT NULL,
  `SaturdayS` varchar(200) NOT NULL,
  `SaturdayE` varchar(200) NOT NULL,
  `SaturdayB` varchar(200) NOT NULL,
  `Comment` text NOT NULL,
  `IsApproved` enum('Yes','No','Pending') NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`id`),
  KEY `AdministratorsID` (`AdministratorsID`)
) ENGINE=MyISAM AUTO_INCREMENT=13769 DEFAULT CHARSET=latin1;

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

INSERT INTO `timesheets` VALUES (13767,'2020-08-17',997,'9:00 AM','5:00 PM','0.75','7:00 AM','5:00 PM','-1','9:00 AM','5:00 PM','0.75','9:00 AM','5:00 PM','0.75','9:00 AM','5:00 PM','0.75','7:00 AM','5:00 PM','-1','','Pending'),(13766,'2020-08-17',1199,'7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','3:00 PM','5:00 PM','0','7:00 AM','5:00 PM','-1','1:30 PM','5:00 PM','0','7:00 AM','5:00 PM','-1','','Pending'),(13765,'2020-08-17',656,'9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','7:00 AM','5:00 PM','-1','','Pending'),(13764,'2020-08-17',601,'9:00 AM','5:30 PM','0.167','8:30 AM','5:30 PM','0.5','7:00 AM','7:00 AM','-1','8:30 AM','4:30 PM','0','8:30 AM','10:30 AM','0','7:00 AM','7:00 AM','-1','','Pending'),(13763,'2020-08-17',1204,'9:00 AM','5:00 PM','0','9:00 AM','5:00 PM','0','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Pending'),(13762,'2020-08-17',467,'8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','8:45 AM','1:30 PM','0','12:30 PM','5:00 PM','0','7:00 AM','5:00 PM','-1','','Pending'),(13761,'2020-08-17',508,'9:00 AM','5:00 PM','0.5','8:45 AM','5:00 PM','0.167','9:00 AM','4:30 PM','0','9:00 AM','5:00 PM','1','8:30 AM','4:45 PM','0.167','7:00 AM','5:00 PM','-1','','Pending'),(13760,'2020-08-17',77,'8:00 AM','4:00 PM','0.5','8:00 AM','4:00 PM','0.5','8:00 AM','4:00 PM','0.5','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13759,'2020-08-17',1212,'8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','3:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','12:30 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13758,'2020-08-17',1207,'8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','','Pending'),(13757,'2020-08-17',1213,'8:45 AM','5:00 PM','0.75','8:45 AM','5:00 PM','0.75','8:45 AM','5:00 PM','0.75','8:45 AM','5:00 PM','0.75','8:45 AM','5:00 PM','0.75','7:00 AM','5:00 PM','-1','','Pending'),(13756,'2020-08-17',4,'8:00 AM','4:45 PM','1','8:00 AM','4:15 PM','1','7:00 AM','5:00 PM','-1','8:00 AM','5:45 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13755,'2020-08-17',745,'9:00 AM','5:15 PM','0.5','9:00 AM','5:15 PM','0.5','9:00 AM','5:15 PM','0.5','9:00 AM','5:00 PM','0.75','9:00 AM','5:00 PM','0.5','7:00 AM','5:00 PM','-1','','Pending'),(13754,'2020-08-17',1203,'8:00 AM','4:00 PM','0.5','8:00 AM','4:00 PM','0.5','7:00 AM','7:00 AM','-1','8:00 AM','4:00 PM','0.167','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Pending'),(13753,'2020-08-17',1180,'9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','','Pending'),(13752,'2020-08-17',1197,'9:00 AM','5:00 PM','0.5','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13751,'2020-08-17',1164,'9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13750,'2020-08-17',712,'8:00 AM','3:30 PM','0','8:45 AM','2:00 PM','-1','8:45 AM','2:00 PM','-1','9:00 AM','2:00 PM','-1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13749,'2020-08-10',656,'9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','7:00 AM','5:00 PM','-1','','Pending'),(13748,'2020-08-10',1199,'7:00 AM','5:00 PM','-1','12:00 PM','5:00 PM','1','1:00 PM','5:00 PM','0.167','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','i split my time between res and ent\r\ni have an hour break a day roughly','Pending'),(13747,'2020-08-10',77,'8:00 AM','4:00 PM','0.5','9:00 AM','2:00 PM','0','9:00 AM','2:00 PM','0','9:00 AM','2:00 PM','0','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13746,'2020-08-10',601,'8:30 AM','4:30 PM','0.167','8:30 AM','6:00 PM','1','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.75','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Pending'),(13745,'2020-08-10',508,'9:15 AM','5:15 PM','0.167','8:00 AM','4:00 PM','0.5','8:00 AM','4:00 PM','0.167','9:00 AM','5:15 PM','0.5','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13744,'2020-08-10',1207,'8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','8:45 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13743,'2020-08-10',249,'8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13742,'2020-08-10',1213,'8:45 AM','12:30 PM','0','8:45 AM','5:00 PM','0.75','8:45 AM','5:00 PM','0.75','8:45 AM','5:00 PM','0.75','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13741,'2020-08-10',1197,'9:00 AM','5:00 PM','0.5','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13740,'2020-08-10',1204,'9:00 AM','5:00 PM','0','9:00 AM','5:15 PM','0','7:00 AM','7:00 AM','-1','9:00 AM','5:15 PM','0','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Pending'),(13739,'2020-08-10',745,'9:00 AM','5:15 PM','0.5','9:00 AM','5:15 PM','0.5','9:00 AM','5:15 PM','0.5','9:00 AM','5:00 PM','0.75','9:00 AM','5:00 PM','0.5','8:00 AM','5:00 PM','-1','','Yes'),(13738,'2020-08-03',929,'7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Yes'),(13737,'2020-08-03',1144,'9:00 AM','5:00 PM','0.5','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Yes'),(13736,'2020-08-10',4,'8:00 AM','4:15 PM','1','8:00 AM','4:00 PM','1','7:00 AM','5:00 PM','-1','8:00 AM','4:30 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13735,'2020-07-27',1201,'8:00 AM','4:00 PM','0.5','7:00 AM','7:00 AM','0','12:00 PM','4:00 PM','0','12:00 PM','3:30 PM','0','7:00 AM','7:00 AM','0','7:00 AM','7:00 AM','0','','Yes'),(13734,'2020-07-27',1201,'8:00 AM','4:00 PM','-1','8:00 AM','8:00 AM','-1','12:00 PM','3:30 PM','-1','12:00 PM','3:30 PM','-1','8:00 AM','8:00 AM','-1','8:00 AM','8:00 AM','0','','Yes'),(13733,'2020-07-27',1144,'9:00 AM','5:00 PM','0.5','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Yes'),(13732,'2020-08-10',1203,'8:00 AM','4:00 PM','0.5','8:00 AM','4:00 PM','0.5','8:00 AM','11:45 AM','0','9:00 AM','5:00 PM','0','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Pending'),(13731,'2020-08-10',1212,'8:45 AM','5:00 PM','1','8:45 AM','12:45 PM','0','8:45 AM','1:45 PM','0.75','8:45 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','i worked 4 days this week and have an hour break per day. ','Pending'),(13730,'2020-08-10',34,'7:45 AM','4:30 PM','0.65','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13729,'2020-08-10',1180,'9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13728,'2020-08-10',467,'8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','8:45 AM','5:00 PM','0.65','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13727,'2020-08-03',467,'8:45 AM','5:00 PM','0.65','8:45 AM','7:00 AM','-1','8:45 AM','5:00 PM','0.65','8:45 AM','1:30 PM','0','12:30 PM','5:00 PM','0','7:00 AM','7:00 AM','0','','Yes'),(13726,'2020-08-10',1164,'9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','9:00 AM','5:00 PM','1','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13725,'2020-08-10',712,'8:00 AM','4:00 PM','0.5','9:00 AM','2:00 PM','0','9:00 AM','2:00 PM','0','9:00 AM','2:00 PM','0','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Pending'),(13724,'2020-08-03',1199,'1:00 PM','5:00 PM','0.167','1:00 PM','5:00 PM','0','1:00 PM','5:00 PM','0','1:00 PM','5:00 PM','0','1:00 PM','5:00 PM','0','7:00 AM','5:00 PM','-1','','Yes'),(13723,'2020-08-03',656,'9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','9:00 AM','1:30 PM','0','7:00 AM','5:00 PM','-1','','Yes'),(13722,'2020-08-03',1197,'9:00 AM','5:00 PM','0.5','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','9:00 AM','5:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','5:00 PM','-1','','Yes'),(13721,'2020-08-03',1201,'8:00 AM','4:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','8:00 AM','4:00 PM','0.5','7:00 AM','7:00 AM','-1','7:00 AM','7:00 AM','-1','','Yes'),(13720,'2020-08-03',508,'8:00 AM','5:00 PM','-1','8:00 AM','5:00 PM','-1','9:00 AM','5:15 PM','0.167','9:00 AM','5:00 PM','0.5','9:00 AM','4:30 PM','0','8:00 AM','5:00 PM','-1','','Yes'),(13719,'2020-08-03',77,'8:00 AM','4:00 PM','0.5','9:00 AM','2:00 PM','0','9:00 AM','2:00 PM','0','9:00 AM','2:00 PM','0','7:00 AM','5:00 PM','-1','7:00 AM','5:00 PM','-1','','Yes'),(13718,'2020-08-03',1160,'9:00 AM','5:00 PM','1','8:45 AM','5:00 PM','1','12:45 PM','5:00 PM','0','1:45 PM','5:00 PM','0','12:45 PM','5:00 PM','0','7:00 AM','5:00 PM','-1','','Yes');

--
-- Table structure for table `tinyurl`
--

CREATE TABLE `tinyurl` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `created_dt` datetime NOT NULL,
  `access_dt` datetime NOT NULL,
  `code` varbinary(6) NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=64421 DEFAULT CHARSET=latin1;

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

INSERT INTO `tinyurl` VALUES (64420,'2020-08-11 13:10:37','0000-00-00 00:00:00',_binary '5cTEXg','http://www.discoverqueensland.com.au/offers/21955/?source=SM-21955'),(64419,'2020-08-11 13:10:37','0000-00-00 00:00:00',_binary '2WLrIg','http://www.discoverqueensland.com.au/offers/21955/?source=FB-21955'),(64418,'2020-08-11 13:10:37','0000-00-00 00:00:00',_binary 'jNZgoV','http://www.discoverqueensland.com.au/offers/21955/?source=NL-21955'),(64417,'2020-08-11 13:10:37','0000-00-00 00:00:00',_binary 'mK3z1I','http://www.discoverqueensland.com.au/offers/21955/?source=GA-21955'),(64416,'2020-07-20 16:27:43','0000-00-00 00:00:00',_binary 'rS0fF7','http://www.discoverqueensland.com.au/offers/21779/?source=SM-21779'),(64415,'2020-07-20 16:27:43','0000-00-00 00:00:00',_binary 'ZzTwF3','http://www.discoverqueensland.com.au/offers/21779/?source=FB-21779'),(64414,'2020-07-20 16:27:43','0000-00-00 00:00:00',_binary 'pb69r4','http://www.discoverqueensland.com.au/offers/21779/?source=NL-21779'),(64413,'2020-07-20 16:27:43','0000-00-00 00:00:00',_binary 'mYafVr','http://www.discoverqueensland.com.au/offers/21779/?source=GA-21779'),(64412,'2020-07-16 11:32:51','0000-00-00 00:00:00',_binary 'kseb8T','http://www.discoverqueensland.com.au/offers/21843/?source=SM-21843'),(64411,'2020-07-16 11:32:51','0000-00-00 00:00:00',_binary 'jcl6Iw','http://www.discoverqueensland.com.au/offers/21843/?source=FB-21843'),(64410,'2020-07-16 11:32:51','0000-00-00 00:00:00',_binary 'lRgH4q','http://www.discoverqueensland.com.au/offers/21843/?source=NL-21843'),(64409,'2020-07-16 11:32:51','0000-00-00 00:00:00',_binary '3Mm14v','http://www.discoverqueensland.com.au/offers/21843/?source=GA-21843'),(64408,'2020-06-05 15:47:27','0000-00-00 00:00:00',_binary 'G7c8ke','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=d05930de5ed7dacbced5a83e419a11e6'),(64407,'2020-06-04 23:11:26','0000-00-00 00:00:00',_binary 'PKqVk6','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=517fe06e59a7ea59458aeb703cd7fd1c'),(64406,'2020-06-02 00:27:27','0000-00-00 00:00:00',_binary 'RuAMSw','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=cce8b6d3802cf80a524e4b2f41dacb73'),(64405,'2020-06-01 17:04:05','0000-00-00 00:00:00',_binary 'EoqDbP','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=8eff5a27256c49b1f1d20dcbd5971edb'),(64404,'2020-06-01 14:57:05','0000-00-00 00:00:00',_binary 'HeSXRK','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=777cd54c805c31c7a8e83c0fefa65353'),(64403,'2020-06-01 14:21:29','0000-00-00 00:00:00',_binary 'w1gA9m','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=56263a4461a9391b41b0e60bb325f185'),(64402,'2020-05-31 16:01:43','0000-00-00 00:00:00',_binary 'uhJtb9','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=41367720ec5a8378c4844f9a0a4b1f9a'),(64401,'2020-05-28 20:32:22','0000-00-00 00:00:00',_binary 'qB9aJe','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=48fc03fef219d33dd99d17d2baa12195'),(64400,'2020-05-28 13:08:33','0000-00-00 00:00:00',_binary 'lRUCFk','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=afe0981a8bbf01b4c0d47fbf2dd3cdc8'),(64399,'2020-05-27 12:23:17','0000-00-00 00:00:00',_binary 'o8ljvW','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=4456e76b4260be38da3b5fa06090473e'),(64398,'2020-05-26 13:15:23','0000-00-00 00:00:00',_binary 'uLoMiS','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=0c6e74d0739fb94e2f3c8e5605497bbd'),(64397,'2020-05-24 16:01:01','0000-00-00 00:00:00',_binary 'F4uotD','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=57dad63eb2dd641b052a52f70a55feb1'),(64396,'2020-05-24 04:41:16','0000-00-00 00:00:00',_binary 'MrEF41','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=bdc148daca09020e24c51436bc3e6299'),(64395,'2020-05-22 18:55:42','0000-00-00 00:00:00',_binary 'OGPeHg','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=5297403fb9e05a21cfb563de681d9245'),(64394,'2020-05-22 18:53:50','0000-00-00 00:00:00',_binary 'CKXQi8','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=5297403fb9e05a21cfb563de681d9245'),(64393,'2020-05-22 18:51:33','0000-00-00 00:00:00',_binary 'cUtmQ6','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=2295e0bcab507f1743f649a86280faaa'),(64392,'2020-05-22 16:58:53','0000-00-00 00:00:00',_binary 'theXJx','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=3510dcb581bc538dc5ab1335cccf46a9'),(64391,'2020-05-22 16:57:24','0000-00-00 00:00:00',_binary 'kZwClI','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=3510dcb581bc538dc5ab1335cccf46a9'),(64390,'2020-05-22 16:55:40','0000-00-00 00:00:00',_binary 'ph2ieB','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=3510dcb581bc538dc5ab1335cccf46a9'),(64389,'2020-05-21 16:02:51','0000-00-00 00:00:00',_binary 'ElBRVI','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=f5ae152b74f420b358a9d41948409010'),(64388,'2020-05-21 11:36:14','0000-00-00 00:00:00',_binary 'yJ0zti','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=6537f61afa4636ff5d13aba686e251e6'),(64387,'2020-05-21 10:34:16','0000-00-00 00:00:00',_binary 'qMeY4C','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=035d4429d7b8bf00a056a49b6d81ec46'),(64386,'2020-05-21 10:33:44','0000-00-00 00:00:00',_binary 'DZXAcL','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=035d4429d7b8bf00a056a49b6d81ec46'),(64385,'2020-05-21 07:50:25','0000-00-00 00:00:00',_binary 'Q7mu06','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=e5f81731e11e0dc211ae81199e9d795c'),(64384,'2020-05-21 07:01:51','2020-05-21 17:37:23',_binary 'v5cOob','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=ae2311a2cffb4c784fa218452123a21c'),(64383,'2020-05-21 06:59:20','2020-05-21 10:16:15',_binary 'hIfRNp','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=568a78fa8c4319f28f76acbd65f5b9fd'),(64382,'2020-05-21 06:23:25','0000-00-00 00:00:00',_binary '0L51PD','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=e6925a8a9f9c62ec861e2030f6e30a6e'),(64381,'2020-05-21 06:21:40','0000-00-00 00:00:00',_binary 'VAYnsd','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=e6925a8a9f9c62ec861e2030f6e30a6e'),(64380,'2020-05-18 22:22:22','0000-00-00 00:00:00',_binary '5FyL94','http://www.discoverqueensland.com.au/competition/discover-queensland-challenge-?entrant_id=19efdf9485857a645ee73e76a1d852b2'),(64379,'2020-05-12 12:23:27','0000-00-00 00:00:00',_binary '2oTbqM','http://www.discoverqueensland.com.au/offers/21767/?source=SM-21767'),(64378,'2020-05-12 12:23:27','2020-05-12 12:23:40',_binary 'PW4mjC','http://www.discoverqueensland.com.au/offers/21767/?source=FB-21767'),(64377,'2020-05-12 12:23:27','0000-00-00 00:00:00',_binary 'gjYnLQ','http://www.discoverqueensland.com.au/offers/21767/?source=NL-21767'),(64376,'2020-05-12 12:23:27','0000-00-00 00:00:00',_binary 'sw3WFC','http://www.discoverqueensland.com.au/offers/21767/?source=GA-21767'),(64375,'2020-02-29 22:13:06','0000-00-00 00:00:00',_binary 'eMdZzv','http://www.discoverqueensland.com.au/competition/win-your-choice-of-beachside-break-or-hinterland-escape-?entrant_id=89d235a72d0bdaa552061a2f1e3934d5'),(64374,'2020-02-29 22:12:09','0000-00-00 00:00:00',_binary 'bhCY2T','http://www.discoverqueensland.com.au/competition/win-your-choice-of-beachside-break-or-hinterland-escape-?entrant_id=3d0d2d71043fc80f456d2bdddd0ea814'),(64373,'2020-02-26 15:40:42','0000-00-00 00:00:00',_binary '0eThDG','http://www.discoverqueensland.com.au/competition/win-your-choice-of-beachside-break-or-hinterland-escape-?entrant_id=0dc06ac30f03a534f6837d7ccb5ce5b0'),(64372,'2020-02-26 15:39:15','0000-00-00 00:00:00',_binary 'YKpn4y','http://www.discoverqueensland.com.au/competition/win-your-choice-of-beachside-break-or-hinterland-escape-?entrant_id=0bfdde66adf8021554b8d71a46cf7a56'),(64371,'2020-02-26 10:57:39','0000-00-00 00:00:00',_binary 'ZERbx8','http://www.discoverqueensland.com.au/competition/win-your-choice-of-beachside-break-or-hinterland-escape-?entrant_id=cca8e3d89c59a65a8e7f3d6712bee658');

--
-- Table structure for table `tour`
--

CREATE TABLE `tour` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `meta_title` varchar(200) NOT NULL,
  `meta_descr` text NOT NULL,
  `description` text NOT NULL,
  `hours` text NOT NULL,
  `facilities` text NOT NULL,
  `category` text NOT NULL,
  `phone` varchar(45) NOT NULL,
  `fax` varchar(45) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(200) NOT NULL,
  `website` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `subregion_id` int(10) NOT NULL DEFAULT '0',
  `region_id` int(10) NOT NULL DEFAULT '0',
  `state_id` int(10) NOT NULL DEFAULT '0',
  `country_id` int(10) NOT NULL DEFAULT '0',
  `postcode` varchar(10) NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `is_hot_deal` enum('Yes','No') NOT NULL DEFAULT 'No',
  `is_loyalty_card` enum('Yes','No') NOT NULL DEFAULT 'No',
  `benefit_title` varchar(200) NOT NULL,
  `benefit_text` text NOT NULL,
  `benefits_terms` text NOT NULL,
  `qh_menu` enum('Yes','No') NOT NULL DEFAULT 'No',
  `longitude` decimal(11,7) NOT NULL DEFAULT '0.0000000',
  `latitude` decimal(11,7) NOT NULL DEFAULT '0.0000000',
  `contact_first_name` varchar(200) NOT NULL,
  `contact_last_name` varchar(200) NOT NULL,
  `contact_email` varchar(200) NOT NULL,
  `contact_phone` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;

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

INSERT INTO `tour` VALUES (127,'KJet Queenstown','KJet Queenstown | Queenstown Holidays','','Take on the mighty Kawarau & Shotover Rivers.\r\n\r\nYou can step onto a big yellow Kawarau Jet every hour at the Main Town Pier in the centre of Queenstown. In an unforgettable Jet boat experience you’ll be transported from the sophisticated downtown area into the channels of two of New Zealand’s most scenic rivers. \r\n\r\nAcross the pristine waters of Lake Wakatipu and through the tranquil beauty of the willow lined Kawarau River, the Jet boat then speeds into the shallow, fast moving braids of the Shotover River. The 43 kilometre, hour long adventure highlights the magnificent diversity of Queenstown’s waterways. \r\n\r\nThe excitement really begins to heighten on the Shotover River, where your driver’s skills are challenged as he navigates the shallow, braided channels of this world-renowned river.  At speeds of up to 90 kilometres per hour, in water often less than 10cm deep – this is where the Jet boat comes into its own.\r\n\r\nWhen you return to the Main Town Pier you’ll descend beneath the lake’s surface to Underwater Observatory where you can feed the fish that thrive close to the shore.  Photos and videos from your trip can be purchased here as mementos of your unique Jet boat adventure.','9am-6pm','','16,17,25,24','0800 52 92 72 / 03 409 0000','','bookings@kjet.co.nz','','www.kjet.co.nz','Main Town Pier, Marine Parade, Queenstown',373,177,10,157,'9300','','No','No','Save 10%','Book online and SAVE 10% when you book KJet.','','No',0.0000000,0.0000000,'Claire','Blackadder','claire@kjet.co.nz','0210436426'),(126,'THE GREAT PACIFIC OF INDIA','THE GREAT PACIFIC OF INDIA | Queenstown Holidays','','We are an inbound destination management and authentic holidays company in India who provides most authentic, off the beaten trek Tours in India.','5','','25','18002089898','18002089898','thegreatpacificofindia@hotmail.com','','www.tradeindia.com','www.tradeindia.com',373,177,10,157,'110021','','No','No','SAVE 25% ON MEALS!','Save 25% when purchasing 2 meals on a Saturday or Sunday!','','No',0.0000000,0.0000000,'Adam','Khan','thegreatpacificofindia@hotmail.com','18002089898'),(125,'Limousine Services Queenstown','Limousine Services | Queenstown','Queenstown\'s premier limousine and transfer company providing transfers and custom designed tours around Queenstown and surrounds','<p style=\"box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-variant-numeric: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;, HelveticaNeue, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; vertical-align: baseline; color: rgb(126, 126, 126); background-color: rgb(255, 255, 255);\">\r\n	For thirty years, Limousine Services Queenstown has provided its guests with unique travel experiences. With a focus on sightseeing and indulgence in equal parts, we provide our guests with unforgettable memories.</p>\r\n<p style=\"box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-variant-numeric: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;, HelveticaNeue, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; vertical-align: baseline; color: rgb(126, 126, 126); background-color: rgb(255, 255, 255);\">\r\n	Offering custom designed transfers and sightseeing experiences, the Limousine Services Queenstown team loves to share its passion for New Zealand&rsquo;s rich landscapes and heritage.</p>\r\n','','','7,25,15,10,24','+64 3 441 4405','+64 3 441 4406','info@lsq.co.nz','','www.limousineservicesqueenstown.co.nz','Queenstown',373,177,10,157,'9300','limousine-services-queenstown','No','No','','','','Yes',0.0000000,0.0000000,'','','',''),(124,'Koumoroy General Trading','Koumoroy General Trading | Queenstown Holidays','','Supply and deliver of goods\r\nbulk supplies\r\ncatering and hiring of equipment\r\ncleaning material\r\nsupply and deliver of office equipment and office furniture\r\nstationery\r\ntravelling and accommodation','08h00 - 16h30','','7,24','0732206637','0865070597','koumoroytrading@gmail.com','','n/a','2157 zone 1,Mdantsane,East London',373,177,10,157,'5219','','No','No','','','','No',0.0000000,0.0000000,'Solomzi','Siswana','koumoroytrading@gmail.com','0732206637'),(123,'Queenstown Photography Tours','Queenstown Photography Tours | Queenstown Holidays','','Queenstown Photography Tours is Queenstown\'s specialist photography tour company, running tours to Skippers Canyon, Rees Valley, Paradise - Glenorchy, Nevis Valley, Macetown and Astrophotography. Come and see Queenstown with local professional photographers able to teach you too!','8AM-10PM','','25','034090549','','info@qtphototours.com','','www.qtphototours.com','13 Poplar Drive',373,177,10,157,'9300','','No','No','Skippers Canyon','get 25% off second traveler with a full paying adult.','','No',0.0000000,0.0000000,'Blair','Pattinson','blair@rapaimages.com','021438423'),(122,'dasada','dasada | Queenstown Holidays','','adad','434','','7,10','9854787487','','x@yopmail.com','','https://www.queenstownholidays.com/supplier/1.php','sadasd',373,177,10,157,'34343','','No','No','','','','No',0.0000000,0.0000000,'asdasd asd','adadad','x@yopmail.com','9854787478'),(121,'Break One Clay Target Sports','Break One Clay Target Sports | Queenstown Holidays','','Come and share our passion for Clay Target Shooting and learn how to become a \'Top Gun\' in our exclusive range in a secret valley on Queenstown Hill.\r\n\r\nOur experienced instructors will ensure you a unique & exciting adventure like no other in Queenstown! We guarantee you will hit a target and have fun doing so!\r\n\r\nThe Experience - $140pp\r\nWith full instruction and a scored competition, this is an ideal & exciting introduction to Clay Target Shooting - and a great way for friends to compete against each other! Shoot a 24 target scored competition + practice shots.\r\n\r\nThe Challenge - $160pp\r\nPerfect for anyone looking for a challenging competition, yet also suitable for the first time shooter, with full instruction and coaching. Shoot a 32 target scored competition + practice shots including our Break One Challenge - 4 targets at once! \r\n\r\nWith courtesy return transport from Queenstown, instruction and a variety of targets, your experience will leave you enthralled with Clay Target Shooting!','8am - 8pm, 7 days a week','','16,17,24','0800 273251 NZ only','','info@breakone.co.nz','','www.breakone.co.nz','Queenstown HIll',373,177,10,157,'9300','','No','No','','','','No',0.0000000,0.0000000,'Sian','Jones','marketing@breakone.co.nz','276711114'),(120,'Break One Clay Target Sports','Break One Clay Target Sports | Queenstown Holidays','','Come and share our passion for Clay Target Shooting and learn how to become a \'Top Gun\' in our exclusive range in a secret valley on Queenstown Hill.\r\n\r\nOur experienced instructors will ensure you a unique & exciting adventure like no other in Queenstown! We guarantee you will hit a target and have fun doing so!','8.30am - 6pm','','16,17,24','0800 273251 NZ only','','info@breakone.co.nz','','www.breakone.co.nz','Queenstown HIll',373,177,10,157,'9300','','No','No','','','','No',0.0000000,0.0000000,'Sian','Jones','marketing@breakone.co.nz','0800273251'),(119,'ThrillZone - KidzClub','ThrillZone - KidzClub | Queenstown Holidays','','Leave them with us and we’ll indulge them with fun and entertainment while you enjoy Queenstown at your own pace! \r\n\r\nOur Kidzclub includes unlimited access to all our products, popcorn and slushy.. plus all kinds of fun & games conducted by our dedicated & enthusiastic staff! \r\n\r\nBookings are recommended but walk ins are welcome too! \r\n\r\nSessions can be any length you like from 1hr – all day!','10AM-10PM','','17','(03) 441 1159','','info@thrillzone.co.nz','','http://www.thrillzone.co.nz/kidz-club.html','53 Shotover Street',373,177,10,157,'9300','','No','No','Complimentry Gift','With every paid entry recieve a free coffee, hot chocolate, slushie or 3rd green-screen photo.','','No',0.0000000,0.0000000,'Sonja','Painter','info@thrillzone.co.nz','0276302532'),(118,'ThrillZone - 360°Battleground','ThrillZone - 360°Battleground | Queenstown Holidays','','Forget everything you previously knew about TRADITIONAL LASERTAG and PAINTBALL! \r\n\r\nWe have the most exhilarating indoor shooting activities with your very own Referees for action packed fun!\r\nReball is the newest way to play Paintball without the mess but still packs that paintball punch when you hit! \r\n\r\nOur Lasertag and Heroblast offers the most interactive experience! This is all the action with none of the impact! \r\n\r\nTake your weapon of choice and blast into the future with our revolutionary gear and exceptionally different gaming modes!','10AM-10PM','','17','(03) 441 1159','','info@thrillzone.co.nz','','www.thrillzone.co.nz/360deg-battleground1.html','53 Shotover Street',373,177,10,157,'9300','','No','No','Complimentry Gift','With every paid entry recieve a free coffee, hot chocolate, slushie or 3rd green-screen photo.','','No',0.0000000,0.0000000,'Sonja','Painter','info@thrillzone.co.nz','0276302532'),(117,'ThrillZone - VORTEX','ThrillZone - VORTEX | Queenstown Holidays','','Stimulate your senses with Vortex’s cutting edge motion theatre, a must do white knuckled adventure.\r\n\r\nWith up to 12 state of the art synchronised multi-sensory effects such as snow, rain, bubbles, fog, speed and a few other surprises, this fantastic unique experience is designed to fully immerse you into the movie!\r\n\r\n​Vortex has an incredible selection of over 80 movies to suit all ages, so we create packages that are tailored to you within your own private theatre.\r\n\r\nChoose from thrilling roller coasters, cyber races, haunted houses, alien adventures or even take a visit to the land of the dinosaurs.\r\n\r\nVortex has something perfect for the little ones as well as those who are young at heart and looking for an unforgettable experience!','10AM-10PM','','17','03 441 1159','','info@thrillzone.co.nz','','www.thrillzone.co.nz/12d-motion-360deg-vr.html','53 Shotover Street',373,177,10,157,'9300','','No','No','Complimentry Gift','With every paid entry recieve a free coffee, hot chocolate, slushie or 3rd green-screen photo','','No',0.0000000,0.0000000,'Sonja','Painter','info@thrillzone.co.nz','0276302532'),(116,'ThrillZone','ThrillZone | Queenstown Holidays','','Step into THRILL ZONE, right in the heart of Queenstown! A fun, high-energy, adrenaline fuelled experience with a huge range of indoor adventures to choose from...\r\n\r\nTake a journey to the edge of reality with our Vortex 12D Motion Thrill Ride. Experience the ride of your life time on our wild roller coasters, creepy haunted houses and crazy jetpack adventures! Or experience a brand new dimension in a world without limits with our 360°VR from fighting intergalactic wars on alien planets to casting spells in the darkest of dungeons.\r\n \r\nIf a shoot ‘em up mission is more your game you can choose the 360° Battleground where you can join in the high adrenaline action of 360° Indoor Reball (paintless paintball), Lasertag or Heroblast (Lasertag specially designed for youngsters). Choose from a wide range of game scenarios for your hour of warfare, complete with your very own dedicated referee. Fully interactive and action-packed!\r\n \r\nIf you’re looking at putting your drifting skills to the test then why not try out our 360° Drift? Drive, spin, or drift like a pro! Front wheel driven with unique drifting wheels, these karts provide an experience like no other. Feel your adrenalin pumping as you race to find out if you\'re a pro at controlling the unique drifting rear wheels.\r\n \r\nBut WAIT, the fun doesn\'t stop there! Strike a pose for our camera and let us capture some great action shots on our giant green screen! Our dedicated staff will work their magic to create your photos to take home with you, while you have fun on one of our many award winning indoor adventure activities!\r\n \r\nIf you haven\'t tried it out yet, then you definitely need to come along and give it a go!','10AM-10PM','','17','(03) 441 1159','','info@thrillzone.co.nz','','www.thrillzone.co.nz','53 Shotover Street',373,177,10,157,'9300','','No','No','Complimentry Gift','With every paid entry receive a free coffee, hot chocolate, slushie or 3rd green-screen photo.','','No',0.0000000,0.0000000,'Sonja','Painter','info@thrillzone.co.nz','0276302532'),(115,'Ziptrek Ecotours ','Ziptrek Ecotours | Queenstown Holidays ','Ziptrek Ecotours combine zip lining excitement with an educational element; the personal guided tours aim to deliver an eco-adventure that enthrals & educates. ','<p>\r\n	Ziptrek Ecotours combine zip lining excitement with an educational element; the personal guided tours aim to deliver an eco-adventure that enthralls guests as well as teaches them about sustainability in an engaging environment. Their spectacular zipline adventure offers some of the most stunning and unique views of Queenstown, Lake&nbsp;Wakatipu&nbsp;and the Remarkables!</p>\r\n<p>\r\n	The best part about Ziptrek Ecotours? With two personal guides, you can sit back and enjoy the ride while they take care of all the technical parts and show you an unforgettable time.</p>\r\n','7 Days, 8.30am til 7pm ','','16,17','0800-ziptrek','','nzinfo@ziptrek.com','','www.ziptrek.co.nz/ ','45 Camp St, Queenstown, New Zealand ',373,177,10,157,'9300','ziptrek-ecotours ','No','No','','','','No',168.6599590,-45.0297690,'','','',''),(114,'Remarkable Scenic Tours','Remarkable Scenic Tours | Queenstown Holidays','','Visit historic Arrowtown, stunning Wanaka and the world famous Cardrona hotel with a knowledgeable guide. The amazing landscape and scenery will truly be the highlight of your time in Queenstown.\r\n Full day tour has the same amazing sites plus Cromwells old town, morning tea & lots more photo stops.\r\n\r\n\r\n\r\n\r\n\r\n\r\nPhoto\r\n\r\n \r\n\r\nArrowtown Wanaka Lake Wanaka Cardrona Hotel Fork & Tap','All day','','7,17,27,25,15,26,10','03 441 8867','','info@remarkablescenictours.nz','','http://remarkablescenictours.nz','15 Acheron pl LHE',373,177,10,157,'9304','','No','No','Save 15% on all tours','Present your MyQT cart to receive a 15% discount when you book direct for any of our tours.','','No',0.0000000,0.0000000,'Wayne','Hansen','info@remarkablescenictours.nz','0273153451'),(113,'Family Adventures Ltd','Family Adventures Ltd | Queenstown Holidays','','Water and sightseeing fun for everyone from 3 years old.  Raft on the gentle grade 1 & 2 upper Shotover River, you don\'t even need to be able to swim!','10am & 2pm daily, except October when we operate at noon.','','17','03 442 8836','n/a','info@familyadventures.co.nz','','www.familyadventures.co.nz','39 Shotover Street',373,177,10,157,'9300','','No','No','','','','No',0.0000000,0.0000000,'Carolyn','Hill','info@familyadventures.co.nz','034418929'),(112,'Vertigo Bikes','Vertigo Bikes | Queenstown Holidays','','The largest and best maintained mountain bike fleet in Queenstown.  Great rides, great bikes from Pro Spec carbon frame DH & Enduro bikes, full suspension options and hard tails.  We even have full suspension, full on kids Norco bikes for little folks from 5 years old!','8am until 7pm daily','','14','+6434418929','+6434418929','info@vertigobikes.co.nz','','www.vertigobikes.co.nz','4 Brecon Street',373,177,10,157,'9300','','No','No','','','','No',0.0000000,0.0000000,'Carolyn','Hill','info@vertigobikes.co.nz','+6434418929'),(111,'Browns Ski Shop','Browns Ski Shop | Queenstown Holidays','','Quality ski, snowboard and clothing gear rental.','8am until 8pm daily','','13','03442 4005','n/a','info@brownsnz.com','','www.brownsnz.com','4 Brecon Street',373,177,10,157,'9300','','No','No','','','','No',0.0000000,0.0000000,'Carolyn','Hill','info@brownsnz.com','034418929'),(109,'Rock Ferry Wines ','Rock Ferry Wines | Queenstown Holidays ','Rock Ferry Wines is an organic estate vineyard &restaurant based in the Marlborough & Central Otago region with a philosophy to create wines that speak of their origins.','<p>\r\n	Rock Ferry Wines is an organic estate vineyard and restaurant based in the Marlborough and Central Otago region with a philosophy to create wines that speak of their home and origins. The aim of Rock Ferry Wines? To simply create good, pure wines to be enjoyed by locals and visitors alike.</p>\r\n<p>\r\n	Drop by 7 days a week to enjoy lunch in the atmospheric restaurant that boasts a home-style vibe and seasonally inspired cooking that is delicious, yet down to earth &ndash; exactly what New Zealand is famous for.</p>\r\n','10am til 4.30pm with lunch available from 11.30am til 3pm, 7 Days','','15,26','(+64) 3 579 6431','(+64) 3 579 6432','cafe@rockferry.co.nz','','www.rockferry.co.nz','80 Hammerichs Road, Blenheim, New Zealand',373,177,10,157,'7272','rock-ferry-wines','No','No','','','','No',173.9155100,-41.4923400,'','','',''),(108,'Aurum Wines ','Aurum Wines | Queenstown Holidays ','Aurum Wines lies in the Lowburn region of the beautiful Central Otago & is open 10am - 5pm daily, so you can relax & enjoy some delightful wine paired with breathtaking scenery.','<p>\r\n	A family owned and operated business, Aurum Wines lies in the Lowburn region of the beautiful Central Otago. Both the vineyard and winery are managed using certified organic practices and place a high value on producing a product that is a result of its origins and process of creation.</p>\r\n<p>\r\n	Just a kilometre away from Wanaka, tastings are easily accessible any day of the week with the cellar doors open 10am to 5pm daily, so you can sit back, relax and enjoy some truly delightful wine paired with breathtaking scenery.</p>\r\n','10am til 5pm, 7 Days','','15,26','(+64) 3 445 3620','','sales@aurumwines.com','','aurumwines.co.nz','140 State Highway, 6 Cromwell Central Otago, New Zealand',373,177,10,157,'9384','aurum-wines','No','No','','','','No',169.2028930,-45.0235990,'','','',''),(107,'Rippon Winery','Rippon Winery | Queenstown Holidays ','Rippon Winery is nestled in the Wanaka region of Central Otago boasting a variety of full bodied wines, beautiful scenery, and a dash of Wanaka charm.','<p>\r\n	Rippon Winery is nestled in the Wanaka region of Central Otago boasting wines created with high ultra violet light, long sunshine hours, highly refractive soils and an overarching temperate climate due to its proximity to the Southern Alps that result in a variety of full bodied flavours.</p>\r\n<p>\r\n	Visit year round to experience the beautiful scenery, aromatic wines, and range of cured meat and cheese platters along with a dash of Wanaka charm.</p>\r\n','11am til 5pm, 7 Days in Summer (December til April) <br/>\r\n12pm til 5pm, 7 Days in Winter (May and July til November) <br/>\r\nBy Appointment in June.\r\n','','15,26','(+64) 3 443 8084','','info@rippon.co.nz','','www.rippon.co.nz/','246 Mt Aspiring Rd, Wanaka, New Zealand',375,177,10,157,'9305','rippon-winery','No','No','','','','No',169.0989150,-44.6966560,'','','',''),(106,'Pisa Range Estate Vineyard','Pisa Range Estate Vineyard | Queenstown Holidays','Pisa Range Estate Vineyard is a popular winery situated in the Central Otago region that produces robust and complex wine varieties. ','<p>\r\n	With the firm belief of &#39;minimal intervention&#39; a focal point within their production process, Pisa Range Estate prides themselves on creating truly unique and robust wines. Enjoy a personalised wine tasting and experience fruity and intense flavours or simply take in the stunning Central Otago region, this is the perfect day out for those seeking an authentic wine tasting experience.&nbsp;</p>\r\n','Cellar Door - 11am till 5pm weekends\r\nPrivate Tastings - 11am till 5pm by appointment only ','','15,26','(+64) 27 440 9527','','info@pisarangeestate.co.nz','','www.pisarangeestate.co.nz','925 Luggate-Cromwell Road, Cromwell, New Zealand',373,177,10,157,'9384','pisa-range-estate-vineyard','No','No','','','','No',169.2442600,-45.9618630,'','','',''),(105,'Valli Wines','Valli Wines | Queenstown Holidays','Valli Wines is an internationally, award-winning winery located near the famous Gibbston Valley in Queenstown, New Zealand. ','<p>\r\n	Renowned for its award-winning Otago Pinot Noir, Valli Wines have been producing quality wines since its inception in 1993. The winery also specialises in a range of other wine varities including dry Riesling and botrytised Riesling which adds to their popularity amongst New Zealand and international visitors alike.&nbsp;</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n','7 Days, Bookings by Appointment Only','','15,26','(+64) 0 21 554 837','','grant@valliwine.com','','www.valliwine.com','2330 Gibbston Highway, Queenstown, New Zealand',373,177,10,157,'9371','valli-wines','No','No','','','','No',168.9757630,-45.0311210,'','','',''),(104,'Stoneridge Estate','Stoneridge Estate | Queenstown Holidays','Stoneridge Estate is a boutique vineyard specialising in a range of wine varieties including Pinot Gris and is located between Queenstown and Arrowtown, New Zealand. ','<p>\r\n	Ordained with beautifully crafted art masterpieces by artist and writer Da Vella Gore and a delicious blend of edible creations for all guests to enjoy, Stoneridge Estate is the ultimate escape for anyone seeking rest and relaxation. In conjunction with gorgeous English Cottage Gardens, the boutique vineyard allows visitors to taste refreshing Pinot Gris and other hand-picked wine varieties in an elegant setting.&nbsp;</p>\r\n','7 Days, 11am till 4pm\r\nNovember to April','','15,26','(+64) 3 442 1021','','enquiries@stoneridge.co.nz','','www.stoneridge.co.nz','756 State Highway 6, Queenstown, New Zealand',373,177,10,157,'9371','stoneridge-estate','No','No','','','','No',168.8152410,-44.9897890,'','','',''),(103,'Akarua','Akarua | Queenstown Holidays','Akarua is a popular winery based near Queenstown, New Zealand that focuses on optimising production processes to produce high quality wines. ','<p>\r\n	With a no-compromise philosophy to winemaking, Akarua is a unique winery focused on producing highly robust, quality wines. Their commitment to developing the best product possible and dedication to extracting optimum flavour from its&#39; grapes through the optimisation of production processes makes Akarua a winery to be remembered.&nbsp;</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n','7 Days, 10:30am till 4pm\r\nClosed weekends during June & July','','15,26','(+64) 3 445 0897','','info@akarua.com','','www.akarua.com','210 Cairmuir Road, Bannockburn, New Zealand',373,177,10,157,'9384','akarua','No','No','','','','No',169.1810410,-45.0851970,'','','',''),(102,'Rockburn Central Otago','Rockburn Central Otago | Queenstown Holidays','Rockburn Central Otago takes its name from the earthy landscape of Central Otago and produces a number of award-winning wines including Pinot Noir, Pinot Gris, Chardonnay, Riesling, Sauvignon Blanc and Gewurztraminer. ','<p>\r\n	Rockburn Central Otago takes its name from the earthy landscape of Central Otago and produces a number of award-winning wines including Pinot Noir, Pinot Gris, Chardonnay, Riesling, Sauvignon Blanc and Gewurztraminer.&nbsp;</p>\r\n','7 Days, 11am till 4pm (Summer)\r\nMonday to Friday, 11am till 4pm (Winter)','','15,26','(+64) 3 445 0555','','winery@rockburn.co.nz','','www.rockburn.co.nz','31 McNulty Road, Cromwell, New Zealand',373,177,10,157,'9310','rockburn-central-otago','No','No','','','','No',169.1855150,-45.0490570,'','','',''),(101,'Quartz Reef','Quartz Reef | Queenstown Holidays','Quartz Reef is located in the heart of Central Otago and specialises in producing a range of quality wines including Pinot Noir, Pinot Gris and Pinot-Chardonnay. ','Quartz Reef is located in the heart of Central Otago and specialises in producing a range of quality wines including Pinot Noir, Pinot Gris and Pinot-Chardonnay. Visitors can explore the stunning vineyard and surrounding scenery on a personal wine tour for the perfect afternoon out.&nbsp;','Tastings open Monday to Friday, 10am till 3pm or by appointment. ','','15,26','(+64) 3 445 3084','','rudi@quartzreef.co.nz','','www.quartzreef.co.nz','8 Hughes Crescent, Cromwell, New Zealand',373,177,10,157,'9310','quartz-reef','No','No','','','','No',169.1820680,-45.0511100,'','','',''),(100,'Olssens Winery','Olssens Winery | Queenstown Holidays','Olssens Winery is situated on a stunning 10 hectare vineyard within the Central Otago region, New Zealand.','<p>\r\n	Situated on a stunning 10 hectare vineyard within the Central Otago region, Olssens Winery offers guests an unforgettable experience through its lush grounds, garden art and Cellar Door.&nbsp;</p>\r\n<p>\r\n</p>\r\n','7 Days, 10am till 5pm (Summer) & 11am till 4pm (Winter)','','15,26','(+64) 3 445 1716','(+64) 3 445 0050','wine@olssens.co.nz','','www.olssens.co.nz','306 Felton Road, Bannockburn, New Zealand',373,177,10,157,'9310','olssens-winery','No','No','','','','No',169.1316120,-45.0713590,'','','',''),(99,'Carrick Winery','Carrick Winery | Queenstown Holidays ','There is a certain magic in enjoying wine where it was crafted. This experience is delivered with magnificent flair by Carrick Winery.','There is a certain magic in enjoying wine where it was crafted. Especially paired with delightful cuisine. This experience is delivered with magnificent flair by Carrick Winery. Open daily from 11am to 5pm you can enjoy the cellar door, restaurant, and even special functions and events. ','11am til 5pm, 7 Days','','15,26','(+64) 3 445 3480','(+64) 3 442 4620 ','wines@carrick.co.nz','','www.carrick.co.nz/','247 Cairnmuir Road, Bannockburn, New Zealand',373,177,10,157,'9384','carrick-winery','No','No','','','','No',169.1797650,-45.0804110,'','','',''),(98,'Gibbston Highgate Estate','Gibbston Highgate Estate | Queenstown Holidays','Gibbston Highgate Estate is a small estate winery near Queenstown, New Zealand. ','<p>\r\n	The Gibbston Highgate Estate is a small estate winery famous for its commitment to producing fine wines completely by hand, resulting in superior clarity and quality.</p>\r\n<p>\r\n	Nestled amongst cascading mountains, the property offers stunning views of the surrounding region including &nbsp;Rock Peak, Mount Rosa, Nevis Bluff and Coronet Peak. The winery has also received numerous awards including awards at the Royal Easter Wine Show, Sydney International Wine Competition and International Wine and Spirit Awards.&nbsp;</p>\r\n<p>\r\n	With so many accolades, it&#39;s easy to see why the Gibbston Highgate Estate is a favourite with visitors and locals alike.&nbsp;</p>\r\n','Open by appointment only','','26','(+64) 3 477 0300','(+64) 3 477 0671','info@queenstownholidays.com','','','110 Gibbston Back Road, Central Otago, New Zealand',373,177,10,157,'9371','gibbston-highgate-estate','No','No','','','','No',168.9773710,-45.0368080,'','','',''),(97,'Mount Edward Winery','Mount Edward Winery | Queenstown Holidays','The Mount Edward Winery is a popular winery based in Central Otago, New Zealand. ','<p>\r\n	The Mount Edward Winery consists of a small team of passionate wine producers who are committed to following an organic-certified approach to growing and developing quality wines.&nbsp;</p>\r\n<p>\r\n	Consisting of several vineyards across the sub regions of Central Otago including Gibbston, Lowburn and Bannockburn, each wine is lovingly produced with minimal interaction leading to a superior clarity, texture and quality.&nbsp;</p>\r\n<p>\r\n</p>\r\n','7 Days<br>\r\nBy Appointment Only','','26','(+64) 3 442 6113','','wines@mountedward.com','','www.mountedward.com','34 Coalpit Road, Gibbston Highway, Queenstown, New Zealand',373,177,10,157,'9371','mount-edward-winery','No','No','','','','No',168.9555670,-45.0258320,'','','',''),(96,'Waitiri Creek Wines Ltd','Waitiri Creek Wines Ltd | Queenstown Holidays','Waitiri Creek Wines Ltd is a vineyard and winery based in the Gibbston Valley, New Zealand. ','<p>\r\n	The Waitiri Creek Winery is a long established vineyard in the heart of the beautiful Gibbston Valley.&nbsp;</p>\r\n<p>\r\n	Aiming to deliver the best quality fruit possible, this quaint winery is passionate about producing the finest wines from refreshing chardonnays to full-bodied pinot gris wine varieties. The estate also features a beautifully restored church as its centrepiece, making it a popular stopover for visitors to the Gibbston Valley.&nbsp;</p>\r\n<p>\r\n	Pick up a bottle of their iconic Waitiri Creek Pinot Gris for a special treat and indulge in refreshing floral and pear notes that mature into sophisticated nashi pear, citrus and exotic spice flavours. &nbsp;&nbsp;</p>\r\n<p>\r\n</p>\r\n<p>\r\n</p>\r\n','Summer 10am till 5pm<br>\r\nTuesdays and Wednesdays closed in winter','','26','(+64) 3 441 3315','(+64) 3 441 3316','info@waitiricreek.co.nz','','www.waitiricreek.co.nz','2323 Church Lane, Gibbston Highway, Central Otago, New Zealand',373,177,10,157,'9371','waitiri-creek-wines-ltd','No','No','Waitiri Creek Wines Ltd | Queenstown Holidays','','','No',168.9749460,-45.0280670,'','','',''),(95,'Hawkshead Wines','Hawkshead Wines | Queenstown Holidays ','Hawkshead Wines is based in the Gibbston Valley wine region near Queenstown, New Zealand. ','<p>\r\n	Based in the stunning Gibbston Valley, Hawkshead Wines is owned and operated by Denis and Ulrike, two passionate wine producers who run and operate the winery from grape to bottle.&nbsp;</p>\r\n<p>\r\n	With a strong focus on careful land use, soil management and minimal interference with nature, this beautiful vineyard offers a range of stunning wines including pinot noir, pinot gris, riesling and rose.</p>\r\n<p>\r\n	Book a private vineyard tour with friends today for the perfect day trip!</p>\r\n','Thursday to Monday from 10am<br>\r\nPrivate tours by appointment only ','','26','(+64) 3 409 0210','','info@hawksheadwine.com','','www.hawksheadwine.com','2328 Gibbston Highway, Queenstown, New Zealand',373,177,10,157,'9371','hawkshead-wines','No','No','','','','No',168.9717380,-45.0300510,'','','',''),(94,'Chard Farm Winery','Chard Farm Winery | Queenstown Holidays','The Chard Farm Winery is a family owned Queenstown winery specialising in Single Vineyard and sub-regional specific pinots. ','<p>\r\n	Founded in 1987, the Chard Farm Winery is a family owned vineyard that is renowned as one of the pioneers of wine in the Central Otago region.&nbsp;</p>\r\n<p>\r\n	With the aim of developing wines that are perfect to enjoy with food, conversation and contemplation, the Chard Farm produce a stunning selection of Single Vineyard pinot noirs and sub-regional specific pinots.&nbsp;</p>\r\n<p>\r\n	Stop by for an afternoon tasting session at the on-site winery or simply take in the stunning valley views that surround the region.&nbsp;</p>\r\n','Monday to Friday 10am till 5pm<br>\r\nSaturday to Sunday 11am till 5pm<br>\r\n7 Days<br>\r\nGroups of 11+ by appointment only','','26','(+64) 3 441 8452','(+64) 3 441 8400','wine@chardfarm.co.nz','','www.chardfarm.co.nz','205 Chard Road, Queenstown, New Zealand',373,177,10,157,'9197','chard-farm-winery','No','No','','','','No',168.8851073,-45.0116442,'','','',''),(93,'Brennan Wines','Brennan Wines | Queenstown Holidays ','Brennan Wines are based in Queenstown, New Zealand and offer a range of Pinot Noir and speciality wines.  ','<p>\r\n	Offering a range of Pinot Noir vintages and other specialty wines, Brennan Wines aims to showcase the very best of the local Gibbston wine region.&nbsp;</p>\r\n<p>\r\n	Producing only a select number of wines per season in order to maintain the highest quality possible, visitors can expect a sophisticated tasting experience with beautifully refined flavours and palate pleasers.&nbsp;</p>\r\n<p>\r\n	Guests are encouraged to create their own experience through the many activities on offer including guided wine tastings, a game of petanque and picnics in the nearby vineyard.&nbsp;</p>\r\n','11am till 5pm<br>\r\n7 Days','','26','(+64) 3 442 4315','(+64) 3 442 4316','cellardoor@brennanwines.com','','www.brennanwines.com','86 Gibbston Back Road, Queenstown, New Zealand',373,177,10,157,'9371','brennan-wines','No','No','','','','No',168.9764693,-45.0377762,'','','',''),(92,'Coal Pit Wine','Coal Pit Wine | Queenstown Holidays','Coal Pit Wine is a family owned vineyard in the Gibbston Valley near Queenstown, New Zealand. ','<p>\r\n	Situated on 12 hectares of beautiful open plains, the family owned Coal Pit Winery is one of the Gibbston region&#39;s oldest vineyards. The rich history surrounding the winery stems across musterers, gold miners and pioneers and provides a captivating insight into the history of the Central Otago region.&nbsp;</p>\r\n<p>\r\n	Located only 20 minutes from Queenstown, this vineyard produces both Pinot Noir and Sauvignon Blanc.</p>\r\n<p>\r\n</p>\r\n','','','26','(+64) 27 269 1389','','sales@coalpitwine.com','','www.coalpitwine.com','121 Coal Pit Road, Central Otago, New Zealand',373,177,10,157,'9371','coal-pit-wine','No','No','','','','No',168.9535780,-45.0284670,'','','',''),(91,'Mt Rosa Winery ','Mt Rosa Winery | Queenstown Holidays','Mt Rosa Winery is based in the heart of the Gibbston Valley, near Queenstown, New Zealand. ','<p>\r\n	Based in the heart of the Gibbston Valley, Mt Rosa Wines is a long established Central Otago Winery that offers quality New Zealand Wines.&nbsp;</p>\r\n<p>\r\n	Mt Rosa produce a range of delicious wines including Pinot Noir, Pinot Gris, Pinot Blanc, Sauvignon Blanc, Riesling, Rose, Late Harvest Riesling and their iconic Mulled Wine. The team at Mt Rosa focus on creating wines that are accessible and approachable; perfect for enjoying with friends and family.&nbsp;</p>\r\n<p>\r\n	Stop by the tasting room on your next trip to Queenstown for a relaxing afternoon.&nbsp;</p>\r\n','11am till 5pm<br>\r\n7 Days','','26','(+64) 3 441 2493','(+64) 3 442 9093','office@mtrosa.co.nz','','www.mtrosa.co.nz','91 Gibbston Back Road, Queenstown, New Zealand',373,177,10,157,'9371','mt-rosa-winery','No','No','','','','No',168.9761500,-45.0387174,'','','',''),(90,'Queenstown Mall ','Queenstown Mall | Queenstown Holidays ','Queenstown Mall is in the quaint and charming town centre and offers shopping of every variety from boutique to high end fashion to sports clothing and more! ','<p>\r\n	Queenstown Mall is in the quaint and charming town centre and offers shopping of every variety from boutique to high end fashion to sports clothing and more! Being in the heart of Queenstown there are also plenty of dining options to quench your thirst and cure your hunger from a hard day of retail therapy.</p>\r\n<p>\r\n	Find the perfect outfit, search for a bargain, and find the best souvenirs at great prices at Queenstown Mall.</p>\r\n','','','17,27','','','info@queenstownholidays.com','','','Queenstown Mall, Queenstown, New Zealand ',373,177,10,157,'9300','queenstown-mall','No','No','','','','No',168.6613880,-45.0320770,'','','',''),(89,'Arrowtown Bike Hire ','Arrowtown Bike Hire | Queenstown Holidays ','Arrowtown Bike Hire is the perfect way to see the historic and culturally rich Arrowtown. Hire a bike and set off on your own adventure or join a guided tour!','<p>\r\n	Arrowtown Bike Hire is the perfect way to see the historic and culturally rich Arrowtown. Hire a bike and set off on your own adventure or join a guided tour with an experience guide and explore this naturally stunning setting.</p>\r\n<p>\r\n	There are several trails that suit all fitness levels as well as maps to assist in navigating the tracks and offer tips on the best stops for photography opportunities!</p>\r\n<p>\r\n	Arrowtown Bike Hire are the longest operating bike hire in the region and offer delivery to your hotel or accommodation or offer pick up and vehicle support options.</p>\r\n','Tuesday til Saturday <br/>\r\nSummer: 8.30am til 5.30pm <br/>\r\nWinter: 9am til 4.30pm ','','14','(+64) 3 441 1144','','ride@arrowtownbikehire.co.nz','','www.arrowtownbikehire.co.nz','59 Buckingham Street, Arrowtown, New Zealand  ',440,177,10,157,'9302','arrowtown-bike-hire','No','No','','','','No',168.8342900,-44.9386630,'','','',''),(88,'Queenstown Golf Centre ','Queenstown Golf Centre | Queenstown Holidays ','Queenstown Golf Centre is your one stop shop for everything golf related in Queenstown with the CBD shop boasting everything from gifts & tours to equipment hire.  ','Queenstown Golf Centre is your one stop shop for everything golf related in Queenstown with the CBD outlet shop boasting everything from information, gifts, and souvenirs to bookings and tours, to equipment hire. ','8am til 6pm, 7 Days ','','20','(+64) 3 442 5311','(+64) 3 442 5311','info@remarkablegolftours.co.nz','','www.remarkablegolftours.co.nz','48 Camp Street, Queenstown, New Zealand ',373,177,10,157,'9300','queenstown-golf-centre','No','No','','','','No',168.6598950,-45.0303940,'','','',''),(87,'Air Milford ','Air Milford | Queenstown Holidays ','Experience natural beauty and be inspired by some of the most breathtaking vistas in the world at Milford Sound via an Air Milford flightseeing tour. ','<p>\r\n	Experience natural beauty and be inspired by some of the most breathtaking vistas in the world at Milford Sound via an Air Milford flightseeing tour.</p>\r\n<p>\r\n	Air Milford is a family owned and operated aviation business that prides itself on delivering guests the very best personalised flightseeing tours possible. You can also charter flights to see further into Fiordland National Park, the Southern Alps, Queenstown, Mt Cook, and Mt Difficulty.</p>\r\n','7am til 9pm, 7 Days','','19','(+64) 3 442 2351','(+64) 3 442 3249','info@airmilford.co.nz','','www.airmilford.co.nz','1 Tex Smith Lane, Queenstown Airport, Queenstown, New Zealand ',373,177,10,157,'9300','air-milford','No','No','','','','No',168.7400360,-45.0210120,'','','',''),(86,'Escape Quest Queenstown','Escape Quest Queenstown | Queenstown Holidays ','Escapes Quest Queenstown delves you into a world of crime & mystery, a world where you have 60 minutes to beat clock, solve the crime & escape the room!','<p>\r\n	Delve into a world of crime and mystery, a world where you have 60 minutes to beat clock, solve the crime and escape the room&hellip; Escapes Quest Queenstown is a fantastic experience for the whole family based on a real-life escape game for 2 to 5 people.</p>\r\n<p>\r\n	Embracing the towns rich cultural heritage in gold mining, the game is set in Queenstown circa 1860 during the Gold Rush with rivers of fortune flowing! Play with your friends, family, or colleagues and use your teamwork skills to discover clues and codes to solve the puzzle.</p>\r\n','10am til 8.30pm, 7 Days','','17','(+64) 3 442 2140','','queenstown@escapequest.co.nz','','www.escapequest.co.nz','Level 1, 32 Rees Street, Queenstown, New Zealand ',373,177,10,157,'9300','escapes-quest-queenstown','No','No','','','','No',168.6591770,-45.0318210,'','','',''),(85,'O\'Connells Shopping Centre ','O\'Connells Shopping Centre | Queenstown Holidays','O’Connells Shopping Centre is a large multi-level retail precinct in the heart of Queenstown offering a range of stores from fashion & jewellery to local wines & more. ','<p>\r\n	O&rsquo;Connells Shopping Centre is a large multi-level retail precinct in the heart of Queenstown offering a range of stores including, fashion, jewellery, sportswear, hand bags, wine, shoes, and much more.</p>\r\n<p>\r\n	The lower level of O&rsquo;Connells Shopping Centre is a food court boasting a selection of cuisines with old faithful, McDonalds centre show.</p>\r\n','9am til 9pm, 7 Days ','','27,21','(+64) 3 441 0377','','bob@skyline.co.nz','','www.oconnells.net.nz/','Corner Camp and Beach Streets, Queenstown, New Zealand ',373,177,10,157,'9348','oconnells-shopping-centre ','No','No','','','','No',168.6610610,-45.0310800,'','','',''),(84,'Rabbit Ridge Bike Resort ','Rabbit Ridge Bike Resort | Queenstown Holidays ','Rabbit Ridge Bike Resort boasts over 40 kilometres of professionally built trails for riders of all levels to experience the best of the Central Otago region’s landscapes. ','<p>\r\n	Rabbit Ridge Bike Resort boasts over 40 kilometres of professionally built trails for riders of all levels to experience the best of the Central Otago region&rsquo;s landscapes.</p>\r\n<p>\r\n	Located 20 minutes from Queenstown, Rabbit Ridge Bike Resort is situated next to Gibbston Valley Winery and offers a myriad of packages to suit all ages, hire equipment and skill levels.</p>\r\n','1 April to 30 September: 10am til 4pm, 7 Days <br/>  \r\n1 October - 30 November: 9am til 5pm, 7 Days <br/> \r\n1 December - 31 March: 8am til 8pm, 7 Days','','14','(+64) 3 442 6910','(+64) 3 442 6909','ashling@gibbstonvalleynz.com','','www.rabbitridge.co.nz','1820 Gibbston Highway State Hwy 6 Gibbston, Queenstown, New Zealand',373,177,10,157,'9371','rabbit-ridge-bike-resort','No','No','','','','No',168.9150130,-45.0114290,'','','',''),(83,'Frankton Golf Centre ','Frankton Golf Centre | Queenstown Holidays ','Situated in Frankton Village, Frankton Golf Centre is the perfect spot for the beginner, casual, or senior golfer. ','<p>\r\n	Situated in Frankton Village, Frankton Golf Centre is the perfect spot for the beginner, casual, or senior golfer. The 18 hole course is just $15 for a round with cart and trolley hire also available.</p>\r\n<p>\r\n	Practise putting and chipping green are both available to finesse your skills, as are lessons from the resident PGA Professional Jamie McIsaac. For the smaller golfers, free junior coaching is available Saturday mornings.</p>\r\n','Winter: 9am til 5pm, 7 Days <br/>\r\nSummer: 9am til 8pm, 7 Days ','','20','(+64) 3 442 3584','(+64) 3 442 5439','golf@qldc.govt.nz','','sportrec.qldc.govt.nz/golf/','Frankton, Queenstown, New Zealand',441,177,10,157,'9371','frankton-golf-centre','No','No','','','','No',168.7337640,-45.0163300,'','','',''),(82,'Picnic in Paradise','Picnic in Paradise | Queenstown Holidays ','Picnic in Paradise is an absolutely breathtaking experience that flies guests over untouched New Zealand landscapes before stopping for a delicious antipasto picnic.  ','<p>\r\n	Picnic in Paradise is an absolutely breathtaking experience that swoops guests up and flies them over stunning lakes, native beech forest, undulated green pastures, historic gold mining remanets, meandering rivers, and remote country towns dotted with quaint farms, ranches, and wineries.</p>\r\n<p>\r\n	Upon landing you can enjoy a delicious antipasto picnic lunch in a private and remote setting before jet setting off again over picturesque Queenstown. The experience includes a 45 minute return flight, all food, wine and beer &ndash; the vistas are priceless.</p>\r\n','','','17,19','(+64) 3 451 0515','','info@helitours.co.nz','','www.helitours.co.nz/flight-experiences/queenstown-flights/picnic-in-paradise.3/','1 Sir Henry Wigley Drive Frankton, Queenstown, New Zealand  ',441,177,10,157,'9300','picnic-in-paradise','No','No','','','','No',168.7378270,-45.0220060,'','','',''),(81,'Kidz Club Queenstown','Kidz Club Queenstown | Queenstown Holidays ','Kidz Club Queenstown is the one and only kids club in picturesque Queenstown and allows the kids to have a GREAT time while you enjoy Queenstown at your own pace. ','<p>\r\n	Kidz Club Queenstown is the one and only kids club in picturesque Queenstown and allows the kids to have a GREAT time while you enjoy Queenstown at your own pace. Perfect for children between 4 to 13 years of age, Kidz Club Queenstown boasts a fun filled program that highlights the best Queenstown has to offer, including:</p>\r\n<ul>\r\n	<li>\r\n		12D Motion Rides at Vortex</li>\r\n	<li>\r\n		Xtreme Lasertag</li>\r\n	<li>\r\n		Xtreme Indoor Reball</li>\r\n	<li>\r\n		Green Screen Fun</li>\r\n	<li>\r\n		Nintendo Wii</li>\r\n	<li>\r\n		Colouring</li>\r\n	<li>\r\n		Face-painting</li>\r\n	<li>\r\n		And FREE slushies and popcorn!</li>\r\n</ul>\r\n<p>\r\n	Programs run hourly, half day, or for full days and are open from 10am til 10pm 7 days a week!</p>\r\n','10am til Late, 7 Days ','','17','(+64) 3 441 1159','','info@thrillzone.co.nz','','www.thrillzone.co.nz/kidz-club.html','53 Shotover Street, Queenstown, New Zealand ',373,177,10,157,'9300','kidz-club-queenstown ','No','No','','','','No',168.6582120,-45.0318820,'','','',''),(80,'Independent Mountain Guides','Independent Mountain Guides | Queenstown Holidays ','For all your Queenstown adventure & adrenalin needs, contact the folk at Independent Mountain Guides! ','<p>\r\n	Independent Mountain Guides offer mountain guides, rockclimbing instruction, snow shoeing, ice climbing, location safety, rescue techniques, Himalayan guided climbs, and backcountry skiing and riding.</p>\r\n<p>\r\n	So for all your Queenstown adventure and adrenalin needs, contact the folk at Independent Mountain Guides!</p>\r\n','','','16','(+64) 3 442 6393','(+64) 3 442 4455','imguides@xtra.co.nz','','www.independentmountainguides.co.nz/','17 Shotover Street, Queenstown, New Zealand ',373,177,10,157,'9300','independent-mountain-guides','No','No','','','','No',168.6607340,-45.0302790,'','','',''),(79,'Peregrine Winery','Peregrine Winery | Queenstown Holidays ','Peregrine Winery is nestled amongst the lakes of Queenstown framed by the dominant mountain ranges. ','<p>\r\n	Peregrine Winery is nestled amongst the lakes of Queenstown framed by the dominant mountain ranges. The vineyards are situated in the valleys below the winery enjoying a continental climate boasting hot, dry summers with cool nights that produces a unique and aromatic range of grapes.</p>\r\n<p>\r\n	Guests visit Peregrine Winery for its unique architecture that has won it the highest international accolades for architecture granted for the majestic wing spanned winery. Peregrine Wines Cellar Door is open to guests to enjoy tastings and enjoy the architecture from 10am til 5pm daily.</p>\r\n','10am til 5pm, 7 Days ','','15,26','(+64) 3 442 4000','(+64) 3 442 4038','info@peregrinewines.co.nz','','www.peregrinewines.co.nz','Kawarau Gorge Road, Queenstown, New Zealand   ',373,177,10,157,'9371','peregrine-winery','No','No','','','','No',168.7347550,-45.0145040,'','','',''),(78,'KJet Wine Sampler','KJet Wine Sampler | Queenstown Holidays ','The KJet Wine Sampler mixes world class wine with world class adventure; the KJet Boat whisks guests away on an river journey before ending with a beautiful wine tour. ','<p>\r\n	The KJet Wine Sampler mixes world class wine with world class adventure kicking off on Lake Wakatipu in the heart of Queenstown; the jet boat whisks guests away through two channels of New Zealand&rsquo;s most picturesque rivers for a 43 kilometre long journey.</p>\r\n<p>\r\n	After adventuring through the tranquil Kawaru River you will make your way through the exhilarating and shallow rapids Shotover River before arriving at your destination, the station building where the wine tour bus will meet you for the final leg of your journey.</p>\r\n','Tours Depart at 11am, 7 Days ','','15','(+64) 3 409 0000','Main Town Pier Marine Parade Queenstown','bookings@kjet.co.nz','','kjet.co.nz/our-products/kjet-wine-sampler/','Main Town Pier Marine Parade, Queenstown, New Zealand ',373,177,10,157,'9300','kjet-wine-sampler','No','No','','','','No',168.6599090,-45.0328770,'','','',''),(77,'Treble Cone','Treble Cone | Queenstown Holidays ','Treble Cone puts you on top of the Southern Alps & offer thrilling gullies, wide faces, & seemingly endless runs perfect for all skill levels & ages. ','<p>\r\n	Treble Cone offers a breathtaking landscape to have a true New Zealand snow experience. The slopes of Treble Cone boast the longest vertical rise in the Southern Lakes and boundaries that sprawl themselves across two basins, the Saddle and Home basin.</p>\r\n<p>\r\n	Both basins of Treble Cone put you on top of the Southern Alps and offer thrilling gullies, wide faces, and seemingly endless runs perfect for beginner, intermediate, and experienced skiers and snowboarders.</p>\r\n','Lift Operates 8am til 4pm, 7 Days <br/>\r\nSeason Dates: 25th June til 27th September 2015 <br/>\r\nMountain Cafe & Bar: 8am til 4.30pm, 7 Days ','','17,13','(+64) 3 443 7443','(+64) 3 443 8401','info@treblecone.com','','www.treblecone.com','24 Dungarvon Street, Wanaka, New Zealand',375,177,10,157,'9305','treble-cone','No','No','','','','No',169.1345300,-44.6970260,'','','','');

--
-- Table structure for table `tourcategory`
--

CREATE TABLE `tourcategory` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `meta_title` varchar(200) NOT NULL,
  `meta_descr` text NOT NULL,
  `description` text NOT NULL,
  `filename` varchar(200) NOT NULL,
  `qh_menu` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

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

INSERT INTO `tourcategory` VALUES (27,'Queenstown Shopping','Queenstown Shopping | Queenstown Holidays ','Queenstown Shopping is extensive, eclectic, & boasts a plethora of variety from luxury brands & iconic New Zealand stores to funky boutiques & hipster alcoves. ','<p>\r\n	Queenstown Shopping is extensive, eclectic, and boasts a plethora of variety from luxury brands and iconic New Zealand stores to funky boutiques and hipster alcoves to adventure and sporting stores.</p>\r\n<p>\r\n	In fact, Queenstown are experts in delivering retail therapy in bucket loads across the compact, pedestrian-friendly city centre. There is also plenty on offer in neighbouring suburbs Arrowtown, Frankton, Jack&rsquo;s Point, and Wanaka. So don your comfy walking shoes, pack some water and start exploring Queenstown&rsquo;s shopping district for your new outfit, that cute hat, or some new hiking boots to get out and about!</p>\r\n','queenstown-shopping','Yes'),(26,'Queenstown Wineries ','Queenstown Wineries | Queenstown Holidays ','The picturesque and mountainous region is home to over 200 Queenstown Wineries each producing their own unique flavours and wine varieties.','<p>\r\n	Queenstown and the wider Otago region is one of the world&rsquo;s premier winery destinations. With a climate favourable to growing grapes destined to become full-bodied, complex, aromatic wines, it is no wonder Queenstown Wineries are some of the most popular in the world.</p>\r\n<p>\r\n	The picturesque and mountainous region is home to over 200 Queenstown Wineries each producing their own unique flavours and wine varieties. That is one of the attractions to the Central Otago region, the altitude and climate vary heavily meaning an excellent range of wines with vastly differing palates are produced. Having said that, the region&rsquo;s sweetheart is the Pinot Noir which is a #NZMustDo!</p>\r\n<p>\r\n	Whether your palate prefers a light, crisp white, an opulent red, or something a little bit sweet there is a Queenstown Winery happy to customise your experience.</p>\r\n','queenstown-wineries ','Yes'),(25,'Queenstown Sightseeing & Tours','Queenstown Sightseeing & Tours | Queenstown Holidays ','Queenstown is a region with a unique and exquisite beauty born from harbouring a dynamic landscape. See the best the region has to offer with a Queenstown tour!','<p>\r\n	Queenstown is a region with a unique and exquisite beauty born from harbouring a dynamic landscape that flows from snow-capped mountain peaks to crystalline lakes into undulating green pastures. Rich and historic townships share these stunning backdrops with a cosmopolitan and urban city centre.</p>\r\n<p>\r\n	Explore the best the region has to offer with a Queenstown sightseeing tour. From bus trips to the glaciers to peer at towers of ice to visiting old mining towns to seeing the landmarks that make Queenstown great, there is a tour for every taste.</p>\r\n<p>\r\n	Book your next Queenstown tour with Queenstown Holidays today!</p>\r\n','queenstown-sightseeing-tours','Yes'),(24,'Wedding, Conference & Event Hire','','','<p>\r\n	Queenstown is the ideal deal spot for a conference or wedding with an array or spectacular venues and services.</p>\r\n<p>\r\n</p>\r\n','wedding-conference','Yes'),(21,'Relaxation & Day Spa','','','','','No'),(20,'Queenstown Golf','Queenstown Golf','Queenstown is a Golfer’s haven. With six separate golf courses all within 25 minutes of Queenstown, this little nook of New Zealand is a must-visit for the avid golfer.','<p>\r\n	Queenstown is a Golfer&rsquo;s haven. With six separate golf courses all within 25 minutes of Queenstown, this little nook of New Zealand is a must-visit for the avid golfer.</p>\r\n<p>\r\n	Each Queenstown golf course is unique while some offer immaculate scissor cut grass others pride themselves on their majestic mountain range views that never grow old or tiresome. Each come with either a clubhouse or nearby restaurant offering alcoholic beverages, light meals and snacks to 3 course meals &ndash; completing the luxury experience.</p>\r\n<p>\r\n	Whether you are a professional, enthusiasts, or simply enjoy a put, no visit to Queenstown is complete without a round of golf. Book your game with Queenstown Holidays now.</p>\r\n','queenstown-golf','Yes'),(19,'Queenstown Flights & Air Activities','Queenstown Flights & Air Activities','Have you ever dreamed of soaring through the clouds like a bird? Then take to the sky with a Queenstown flight or air activity! ','<p>\r\n	Have you ever dreamed of soaring through the clouds like a bird? Then take to the sky with a Queenstown flight or air activity!</p>\r\n<p>\r\n	Queenstown offers up some of the most picturesque vistas available in New Zealand with incredible aerial views of meandering rivers, tranquil lakes, and the soaring heights of the mountain ranges.</p>\r\n<p>\r\n	Those with a hefty appetite for adventure will enjoy sky diving or an acrobatic flight for a real adrenalin rush. Perhaps a scenic flight or tranquil hot air balloon ride is more your cup of tea?</p>\r\n<p>\r\n	For the best of the adventure world with a hint of relaxation then why not try your hand at hang gliding?</p>\r\n<p>\r\n	Take off on an air adventure of a lifetime, book your Queenstown flight or air activity today.</p>\r\n','queenstown-flights-air-activities','Yes'),(17,'Queenstown Family Activities','Queenstown Family Activities','Queenstown is an exciting and engaging destination filled with great family fun activities and entertainment.','<p>\r\n	Queenstown is an exciting and engaging destination filled with great family fun activities and entertainment.</p>\r\n<p>\r\n	A renowned holiday destination, Queenstown has an excellent array of entertainment for all ages that changes as the distinct four seasons do. Take the kids to the cinemas, playgrounds and parklands, swimming pools or for cruises and boat rides. For the older munchkins try white water rafting, zip lining or skiing.</p>\r\n<p>\r\n	No matter what season you visit or age group your children fall into Queenstown has a myriad of family activities to suit your style and budget.</p>\r\n','queenstown-family-activities','Yes'),(16,'Queenstown Adventure & Adrenalin','Queenstown Adventure & Adrenalin','Queenstown Adventure & Adrenalin','<p>\r\n	Queenstown is the adventure and adrenalin capital of the world!</p>\r\n<p>\r\n	The regions dynamic landscapes allow Queenstown to offer every type of thrill seeking activity imaginable. From iconic bungy jumping to white water rafting, canyon swinging, and jet boating, to 4WD and quad biking madness there is an adventure to get even the tin man&rsquo;s blood pumping.</p>\r\n<p>\r\n	Fling yourself from a plane with a parachute strapped to your back, or throw yourself out of a helicopter atop a mountain with nothing but a bike to brake your fall, hurtle yourself from a cliff face and abseil to safety, or grow your own wings and take flight paragliding. The options are endless and Queenstown Holidays have found them all.</p>\r\n<p>\r\n	Get your adrenalin stores ready and book your next Queenstown adventure today.</p>\r\n','queenstown-adrenaline-rush','Yes'),(15,'Queenstown Wine Tours & Experiences','Queenstown Wine Tours & Experiences','Whether you have a well refined palate are a wine enthusiast or simply love the atmosphere there is a tailored Queenstown wine tour or experience for you. ','<p>\r\n	Whether you have a well refined palate, are a wine enthusiast or simply love the atmosphere and panoramic scenery that is paired with visiting world-class cellar doors there will be a tailored Queenstown wine tour or experience for you.</p>\r\n<p>\r\n	The region is home to over 200 vineyards producing a wide range of wine varieties. The differing altitude and climate of Queenstown allows an impressive array of flavours to come from this all-encompassing region. What better way to discover them all than to do a winery tour?</p>\r\n<p>\r\n	Queenstown wineries also come armed with award winning restaurants to match their famed fermented grapes so your day will leave you full of delicious wines, breathtaking views, and gourmet cuisine.</p>\r\n<p>\r\n	Book your Queenstown wine tour and experience now.</p>\r\n','queenstown-wine-tours-experiences','Yes'),(14,'Queenstown Mountain Biking ','Queenstown Mountain Biking ','Queenstown mountain biking is internationally recognised as one of the best biking destinations in the southern hemisphere with the world’s first gondola-accessed bike track!','<p>\r\n	Queenstown has an inescapably beautiful landscape that lends itself to a thriving biking culture that has become internationally recognised and appreciated.</p>\r\n<p>\r\n	There are several styles of biking tracks available in Queenstown to suit all fitness levels and varieties of biking from the Southern Hemisphere&rsquo;s only gondola-accessed downhill mountain biking to casual rides along the lake front or overlooking the famed country side, Queenstown has it all. There are even jump tracks that are child and family friendly to test your speed, endurance, and relationship with gravity!</p>\r\n<p>\r\n	Book your next Queenstown mountain biking experience today.</p>\r\n','queenstown-mountain-biking','Yes'),(13,'Queenstown Skiing and Snowboarding','Queenstown Skiing and Snowboarding','Queenstown skiing & snowboarding is available across four fields each with their own unique appeal. Book your next snow holiday with Queenstown Holidays today.','<p>\r\n	Queenstown is a magical winter playground that attracts visitors from across New Zealand and abroad to exult over the majesty of the powdery snow covered slopes native to Queenstown.</p>\r\n<p>\r\n	A snow lover&rsquo;s paradise you are spoilt for choice in Queenstown with four snow fields within easy reach. Each option caters for beginners through to advanced skiers and snowboarders and offer learn to ski and snow board classes and facilities.</p>\r\n<p>\r\n	One of the perks of Queenstown skiing and snowboarding are the treeless slopes unimpeded by sporadic forests that ruin a perfectly good run.</p>\r\n<p>\r\n	These in-demand slopes offer alpine vistas reminiscent of Europe with a modern twist that includes proximity to temperate attractions such as beaches, cruises, wineries and more that are all a mere drive away. This natural cocktail of attractions is unique to Queenstown, New Zealand.</p>\r\n<p>\r\n	As is the welcoming apres culture which becomes quickly addictive. Hooked after the first visit, many return year after year between June to October for one of the longest ski seasons in the Southern Hemisphere.</p>\r\n<p>\r\n	Plan your next Queenstown skiing or snowboarding holiday with Queenstown Holidays today!</p>\r\n','queenstown-skiing-snowboarding','Yes'),(10,'Transfers & Ground Transport','','','','transfers-ground-transport','No'),(7,'Multi-day & Extended Tours','','','','multi-day-extended-tours','No');

--
-- Table structure for table `tourfacilities`
--

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

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


--
-- Table structure for table `tourimages`
--

CREATE TABLE `tourimages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tour_id` int(10) NOT NULL DEFAULT '0',
  `original` varchar(100) NOT NULL,
  `resized` varchar(100) NOT NULL,
  `caption` varchar(200) NOT NULL,
  `is_main_image` enum('Yes','No') NOT NULL DEFAULT 'No',
  `sort_order` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=337 DEFAULT CHARSET=latin1;

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

INSERT INTO `tourimages` VALUES (336,115,'image-2016-08-25-10-43-48.jpg','medium-image-2016-08-25-10-43-48.jpg','Ziptrek Ecotours - looking up - Queenstown Holidays ','No',3),(335,115,'image-2016-06-23-14-49-11.jpg','medium-image-2016-06-23-14-49-11.jpg','Ziptrek Ecotours - Showing off over the Queenstown Landscapes - Queenstown Holidays ','No',2),(334,115,'image-2016-06-23-14-48-29.jpg','medium-image-2016-06-23-14-48-29.jpg','Ziptrek Ecotours Queenstown - Queenstown Holidays ','Yes',1),(333,53,'image-2016-03-08-16-36-42.jpg','medium-image-2016-03-08-16-36-42.jpg','GForce Paragliding Queenstown Holidays ','No',3),(332,109,'image-2016-02-17-23-04-05.jpg','medium-image-2016-02-17-23-04-05.jpg','Rock Ferry Wines Outdoor Seating in Autumn - Queenstown Holidays ','No',3),(331,109,'image-2016-02-17-23-02-55.jpg','medium-image-2016-02-17-23-02-55.jpg','Rock Ferry Wines Vineyard - Queenstown Holidays ','No',2),(330,109,'image-2016-02-17-23-01-38.jpg','medium-image-2016-02-17-23-01-38.jpg','Rock Ferry Wines - Queenstown Holidays','Yes',1),(329,108,'image-2016-02-17-22-37-51.jpg','medium-image-2016-02-17-22-37-51.jpg','Platters at Aurum Wines - Queenstown Holidays ','No',3),(328,108,'image-2016-02-17-22-36-32.jpg','medium-image-2016-02-17-22-36-32.jpg','Aurum Winery - Queenstown Holidays','Yes',0),(327,108,'image-2016-02-17-22-32-00.jpg','medium-image-2016-02-17-22-32-00.jpg','Aurum Wines - Queenstown Holidays ','No',1),(326,107,'image-2016-02-17-17-53-10.jpg','medium-image-2016-02-17-17-53-10.jpg','Rippon Wines - Queenstown Holidays','No',3),(325,107,'image-2016-02-17-17-52-36.jpg','medium-image-2016-02-17-17-52-36.jpg','Rippon Vineyard - Queenstown Holidays ','No',2),(324,107,'image-2016-02-17-17-52-02.jpg','medium-image-2016-02-17-17-52-02.jpg','Rippon Winery - Queenstown Holidays','Yes',1),(323,100,'image-2016-02-03-15-55-03.jpg','medium-image-2016-02-03-15-55-03.jpg','Olssens | Queenstown Holidays','Yes',0),(322,100,'image-2016-02-03-15-54-45.jpg','medium-image-2016-02-03-15-54-45.jpg','Olssens | Queenstown Holidays','No',2),(321,100,'image-2016-02-03-15-54-34.jpg','medium-image-2016-02-03-15-54-34.jpg','Olssens | Queenstown Holidays','No',1),(320,101,'image-2016-02-03-15-49-19.jpg','medium-image-2016-02-03-15-49-19.jpg','Quartz Reef | Queenstown Holidays','No',3),(319,101,'image-2016-02-03-15-48-53.jpg','medium-image-2016-02-03-15-48-53.jpg','Quartz Reef | Queenstown Holidays','Yes',2),(318,101,'image-2016-02-03-15-48-40.jpg','medium-image-2016-02-03-15-48-40.jpg','Quartz Reef | Queenstown Holidays','No',1),(317,102,'image-2016-02-03-15-43-39.jpg','medium-image-2016-02-03-15-43-39.jpg','Rockburn Central Otago | Queenstown Holidays','Yes',3),(316,102,'image-2016-02-03-15-42-58.jpg','medium-image-2016-02-03-15-42-58.jpg','Rockburn Central Otago | Queenstown Holidays','No',2),(315,102,'image-2016-02-03-15-41-22.jpg','medium-image-2016-02-03-15-41-22.jpg','Rockburn Central Otago | Queenstown Holidays','No',1),(314,103,'image-2016-02-03-15-35-59.jpeg','medium-image-2016-02-03-15-35-59.jpeg','Akarua | Queenstown Holidays','Yes',1),(313,103,'image-2016-02-03-15-35-47.png','medium-image-2016-02-03-15-35-47.png','Akarua | Queenstown Holidays','No',2),(312,103,'image-2016-02-03-15-35-35.jpg','medium-image-2016-02-03-15-35-35.jpg','Akarua | Queenstown Holidays','No',0),(311,104,'image-2016-02-03-15-24-33.jpg','medium-image-2016-02-03-15-24-33.jpg','Stoneridge Estate | Queenstown Holidays','No',3),(310,104,'image-2016-02-03-15-23-46.jpg','medium-image-2016-02-03-15-23-46.jpg','Stoneridge Estate | Queenstown Holidays','Yes',2),(309,104,'image-2016-02-03-15-22-55.jpg','medium-image-2016-02-03-15-22-55.jpg','Stoneridge Estate | Queenstown Holidays','No',1),(308,105,'image-2016-02-03-15-13-57.jpg','medium-image-2016-02-03-15-13-57.jpg','Valli Wines | Queenstown Holidays','No',3),(307,105,'image-2016-02-03-15-13-43.jpg','medium-image-2016-02-03-15-13-43.jpg','Valli Wines | Queenstown Holidays','Yes',2),(306,105,'image-2016-02-03-15-13-27.jpg','medium-image-2016-02-03-15-13-27.jpg','Valli Wines | Queenstown Holidays','No',1),(305,106,'image-2016-02-03-15-02-34.jpg','medium-image-2016-02-03-15-02-34.jpg','Pisa Range Estate Vineyard | Queenstown Holidays','Yes',0),(304,106,'image-2016-02-03-15-02-02.jpeg','medium-image-2016-02-03-15-02-02.jpeg','Pisa Range Estate | Queenstown Holidays','No',1),(303,106,'image-2016-02-03-15-01-01.jpeg','medium-image-2016-02-03-15-01-01.jpeg','Pisa Range Estate | Queenstown Holidays','No',2),(302,57,'image-2016-01-13-13-50-30.jpg','medium-image-2016-01-13-13-50-30.jpg','Over The Top - The Helicopter Co. in the cock pit with the captain - Queenstown Holidays ','No',3),(301,99,'image-2016-01-07-17-07-22.jpg','medium-image-2016-01-07-17-07-22.jpg','Carrick Winery Vineyard - Queenstown Holidays','No',3),(300,99,'image-2016-01-07-17-08-27.jpg','medium-image-2016-01-07-17-08-27.jpg','Carrick Winery Aerial View - Queenstown Holidays','Yes',0),(299,99,'image-2016-01-07-17-06-00.jpg','medium-image-2016-01-07-17-06-00.jpg','Carrick Winery Pinot Gris with a View - Queenstown Holidays','No',1),(298,98,'image-2015-12-14-16-04-52.jpg','medium-image-2015-12-14-16-04-52.jpg','Gibbston Highgate Estate \'Soul Taker\' Pinot Noir 2011 - Queenstown Holidays','No',2),(297,98,'image-2015-12-14-16-04-09.jpg','medium-image-2015-12-14-16-04-09.jpg','Gibbston Highgate Estate - Queenstown Holidays','Yes',1),(296,97,'image-2015-12-11-14-35-56.jpg','medium-image-2015-12-11-14-35-56.jpg','Mount Edward Winery - Queenstown Holidays','Yes',3),(295,97,'image-2015-12-11-14-33-23.jpg','medium-image-2015-12-11-14-33-23.jpg','Mount Edward Winery Riesling - Queenstown Holidays','No',2),(294,97,'image-2015-12-11-14-32-24.jpg','medium-image-2015-12-11-14-32-24.jpg','Mount Edward Winery - Queenstown Holidays','No',1),(293,96,'image-2015-12-11-14-03-50.jpg','medium-image-2015-12-11-14-03-50.jpg','Waitiri Creek Wines Ltd - Queenstown Holidays','No',3),(292,96,'image-2015-12-11-14-02-58.jpg','medium-image-2015-12-11-14-02-58.jpg','Waitiri Creek Wines Ltd - Queenstown Holidays','No',2),(291,96,'image-2015-12-11-14-02-20.jpg','medium-image-2015-12-11-14-02-20.jpg','Waitiri Creek Wines Ltd restored church - Queenstown Holidays','Yes',1),(290,95,'image-2015-12-11-11-03-43.jpg','medium-image-2015-12-11-11-03-43.jpg','Hawkshead Wines Pinot Noir - Queenstown Holidays','No',2),(289,95,'image-2015-12-11-11-02-51.jpg','medium-image-2015-12-11-11-02-51.jpg','Hawkshead Wines - Queenstown Holidays','Yes',0),(288,95,'image-2015-12-11-11-01-28.jpg','medium-image-2015-12-11-11-01-28.jpg','Denis and Ulrike, owners of Hawkshead Wines - Queenstown Holidays','No',1),(287,94,'image-2015-12-10-16-42-55.jpg','medium-image-2015-12-10-16-42-55.jpg','Chard Farm Winery - Queenstown Holidays','Yes',3);

--
-- Table structure for table `tracking`
--

CREATE TABLE `tracking` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `tracking_code` varchar(200) NOT NULL,
  `arguments` varchar(200) NOT NULL,
  `referer` varchar(200) NOT NULL,
  `entry_code` varchar(200) DEFAULT NULL,
  `guest_id` int(10) NOT NULL DEFAULT '0',
  `enquiry_id` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(200) NOT NULL,
  `user_agent` varchar(200) NOT NULL,
  `page_reference` varchar(200) NOT NULL,
  `website_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tracking_code` (`tracking_code`)
) ENGINE=MyISAM AUTO_INCREMENT=34171535 DEFAULT CHARSET=latin1;

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

INSERT INTO `tracking` VALUES (34171534,'2020-10-31 21:22:21','34171532','','https://travel-dev.entdigital.net/login/index.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/login/index.php',2),(34171533,'2020-10-31 21:22:21','34171532','','https://travel-dev.entdigital.net/login/index.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/login/index.php',2),(34171532,'2020-10-31 21:22:15','34171532','','https://travel-dev.entdigital.net/login/index.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/login/index.php',2),(34171531,'2020-10-30 14:49:03','34171381','','https://dev.entertainmenttravel.com.au/login/index.php','',0,0,'180.150.46.33','mozilla/5.0 (macintosh; intel mac os x 10_15_7) applewebkit/605.1.15 (khtml, like gecko) version/14.0 safari/605.1.15','/login/index.php',2),(34171530,'2020-10-30 14:27:55','34171522','','https://discoverqueensland-dev.entdigital.net/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/secure/step-2.php',1),(34171529,'2020-10-30 14:27:53','34171522','guests-adults=0&guests-children=0&date=2020-11-17&num_nights=3&next=next_value','https://discoverqueensland-dev.entdigital.net/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/secure/step-1.php?guests-adults=0&guests-children=0&date=2020-11-17&num_nights=3&next=next_value',1),(34171528,'2020-10-30 14:27:51','34171522','','https://discoverqueensland-dev.entdigital.net/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/_cfg/get_deal_price.php',1),(34171527,'2020-10-30 14:27:51','34171522','','https://discoverqueensland-dev.entdigital.net/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/_cfg/get_deal_price.php',1),(34171526,'2020-10-30 14:27:48','34171522','','https://discoverqueensland-dev.entdigital.net/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/_cfg/get_deal_price.php',1),(34171525,'2020-10-30 14:27:43','34171522','','https://discoverqueensland-dev.entdigital.net/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/_cfg/get_deal_price.php',1),(34171524,'2020-10-30 14:27:35','34171522','property_id=140&room_id=66205&promotion_id=21830','https://discoverqueensland-dev.entdigital.net/accommodation/gold-coast/coolangatta/oaks-calypso-plaza','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/secure/step-1.php?property_id=140&room_id=66205&promotion_id=21830',1),(34171523,'2020-10-30 14:27:32','34171522','url_info=gold-coast/coolangatta/oaks-calypso-plaza','https://discoverqueensland-dev.entdigital.net/','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/accommodation/gold-coast/coolangatta/oaks-calypso-plaza',1),(34171522,'2020-10-30 14:27:29','34171522','','https://discoverqueensland-dev.entdigital.net/','',0,0,'49.197.254.68','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/_cfg/property_typeahead.php',1),(34171521,'2020-10-29 22:27:36','34171521','','https://travel-dev.entdigital.net/login/index.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/login/index.php',2),(34171520,'2020-10-28 21:14:53','34171519','','https://discoverqueensland-dev.entdigital.net/','web01.blueboxit.com.au:2087/',0,0,'77.237.100.180','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/_cfg/property_typeahead.php',1),(34171519,'2020-10-28 21:14:51','34171519','','https://web01.blueboxit.com.au:2087/','web01.blueboxit.com.au:2087/',0,0,'77.237.100.180','mozilla/5.0 (windows nt 10.0; win64; x64; rv:82.0) gecko/20100101 firefox/82.0','/',1),(34171518,'2020-10-27 14:24:16','34171518','','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171517,'2020-10-27 07:53:41','34171352','','https://travel-dev.entdigital.net/login/index.php','',0,0,'123.243.152.227','mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/86.0.4240.111 safari/537.36','/login/index.php',2),(34171516,'2020-10-26 21:30:20','34171516','','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171515,'2020-10-23 09:05:57','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-casino-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171514,'2020-10-23 08:59:37','34171486','url_info=brisbane/brisbane-cbd/oaks-casino-towers','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-casino-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-casino-towers',1),(34171513,'2020-10-23 08:59:33','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-casino-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171512,'2020-10-23 08:59:32','34171486','url_info=brisbane/brisbane-cbd/oaks-casino-towers','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-casino-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-casino-towers',1),(34171511,'2020-10-23 08:59:18','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-casino-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171510,'2020-10-23 08:59:17','34171486','url_info=brisbane/brisbane-cbd/oaks-casino-towers','https://discoverqueensland-dev.entdigital.net/hot-deals/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-casino-towers',1),(34171509,'2020-10-23 08:59:16','34171486','','https://discoverqueensland-dev.entdigital.net/hot-deals/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171508,'2020-10-23 08:59:16','34171486','','https://discoverqueensland-dev.entdigital.net/thank-you.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/hot-deals/',1),(34171507,'2020-10-23 08:58:38','34171486','','https://discoverqueensland-dev.entdigital.net/thank-you.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171506,'2020-10-23 08:58:37','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/thank-you.php',1),(34171505,'2020-10-23 08:58:37','34171486','url_info=brisbane/brisbane-cbd/oaks-festival-towers','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-festival-towers',1),(34171504,'2020-10-23 08:58:26','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171503,'2020-10-23 08:58:03','34171486','url_info=brisbane/brisbane-cbd/oaks-festival-towers','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-festival-towers',1),(34171502,'2020-10-23 08:57:52','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171501,'2020-10-23 08:56:31','34171486','url_info=brisbane/brisbane-cbd/oaks-festival-towers','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-festival-towers',1),(34171500,'2020-10-23 08:56:19','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/brisbane/brisbane-cbd/oaks-festival-towers','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171499,'2020-10-23 08:56:19','34171486','url_info=brisbane/brisbane-cbd/oaks-festival-towers','https://discoverqueensland-dev.entdigital.net/hot-deals/','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/brisbane/brisbane-cbd/oaks-festival-towers',1),(34171498,'2020-10-23 08:56:18','34171486','','https://discoverqueensland-dev.entdigital.net/hot-deals/','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171497,'2020-10-23 08:56:18','34171486','','https://discoverqueensland-dev.entdigital.net/thank-you.php','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/hot-deals/',1),(34171496,'2020-10-23 08:55:13','34171486','','https://discoverqueensland-dev.entdigital.net/thank-you.php','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171495,'2020-10-23 08:55:13','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/gold-coast/coolangatta/oaks-calypso-plaza','',0,620872,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/thank-you.php',1),(34171494,'2020-10-23 08:55:13','34171486','url_info=gold-coast/coolangatta/oaks-calypso-plaza','https://discoverqueensland-dev.entdigital.net/accommodation/gold-coast/coolangatta/oaks-calypso-plaza','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/gold-coast/coolangatta/oaks-calypso-plaza',1),(34171493,'2020-10-23 08:54:59','34171486','','https://discoverqueensland-dev.entdigital.net/accommodation/gold-coast/coolangatta/oaks-calypso-plaza','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171492,'2020-10-23 08:54:59','34171486','url_info=gold-coast/coolangatta/oaks-calypso-plaza','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/accommodation/gold-coast/coolangatta/oaks-calypso-plaza',1),(34171491,'2020-10-23 08:54:56','34171486','','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171490,'2020-10-23 08:42:09','34171486','selected=&id=','https://discoverqueensland-dev.entdigital.net/holiday-homes/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/get_holiday_subregions.php?selected=&id=',1),(34171489,'2020-10-23 08:42:09','34171486','','https://discoverqueensland-dev.entdigital.net/holiday-homes/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171488,'2020-10-23 08:42:08','34171486','','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/holiday-homes/',1),(34171487,'2020-10-23 08:42:07','34171486','','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171486,'2020-10-23 08:41:37','34171486','','https://discoverqueensland-dev.entdigital.net/','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/_cfg/property_typeahead.php',1),(34171485,'2020-10-22 18:48:41','34171485','','https://travel-dev.entdigital.net/login/index.php','',0,0,'124.191.4.64','mozilla/5.0 (windows nt 10.0; win64; x64; rv:81.0) gecko/20100101 firefox/81.0','/login/index.php',2);

--
