X6JXMiZH

1--
2-- Table structure for table `groupname`
3--
4
5DROP TABLE IF EXISTS `groupname`;
6SET @saved_cs_client     = @@character_set_client;
7SET character_set_client = utf8;
8CREATE TABLE `groupname` (
9  `product_id` int(10) NOT NULL auto_increment,
10  `groupname` varchar(100) NOT NULL,
11  `email` varchar(100) NOT NULL,
12  `adult` smallint(4) NOT NULL,
13  `child` smallint(4) NOT NULL,
14  `foc` tinyint(2) NOT NULL,
15  `standard` tinyint(2) NOT NULL,
16  `family` tinyint(2) NOT NULL,
17  `days` tinyint(3) NOT NULL,
18  `nights` tinyint(3) NOT NULL,
19  `active` varchar(1) NOT NULL default 'A',
20  `username` varchar(50) NOT NULL,
21  PRIMARY KEY  (`product_id`),
22  UNIQUE KEY `groupname` (`groupname`)
23) ENGINE=MyISAM AUTO_INCREMENT=440 DEFAULT CHARSET=latin1;
24SET character_set_client = @saved_cs_client;
25
26--
27-- Dumping data for table `groupname`
28--
29
30LOCK TABLES `groupname` WRITE;
31/*!40000 ALTER TABLE `groupname` DISABLE KEYS */;
32INSERT INTO `groupname` VALUES (130,'Al Azhar','hanie.alazhar@gmail.com',29,0,0,13,1,2,1,'A','hardi.bramantio@anaya.com.sg'),(11,'Aneka Graha Vista Tour','anekagrahavista@gmail.com',2,0,0,0,0,4,3,'N','hardi.bramantio@anaya.com.sg'),(5,'Happy Time','happytimetour@yahoo.co.id',7,5,0,6,0,6,5,'N','hardi.bramantio@anaya.com.sg'),(6,'Lily','teye19@gmail.com',21,0,0,11,0,3,0,'N','hardi.bramantio@anaya.com.sg'),(10,'Naomi Theresia','naomi.theresia@csf.co.id',8,0,0,4,0,3,2,'N','hardi.bramantio@anaya.com.sg'),(12,'Rudy','rudy_prmd@yahoo.com',23,6,0,15,0,4,3,'N','hardi.bramantio@anaya.com.sg'),(13,'Rudy Strand','rudy_prmd@yahoo.com',23,6,0,9,3,4,3,'N','hardi.bramantio@anaya.com.sg'),(14,'Irma','herryani.irma@gmail.com',6,0,0,3,0,3,2,'N','hardi.bramantio@anaya.com.sg'),(15,'Charm of Asia','tour2555@hotmail.co.th',3,0,1,0,1,6,5,'N','hardi.bramantio@anaya.com.sg'),(16,'Henny','',6,5,0,1,2,4,3,'N','hardi.bramantio@anaya.com.sg'),(17,'3D2N Package','david@anaya.com.sg',1,1,0,1,0,3,2,'N','hanselzen@gmail.com'),(18,'3D2N FIT','david@anaya.com.sg',1,1,0,1,0,3,2,'N','hanselzen@gmail.com'),(19,'4D3N Package','',1,1,0,1,0,4,3,'N','hanselzen@gmail.com'),(88,'Siska','siska@bdj.gpi-g.com',7,0,0,2,1,3,2,'A','dewi.dharez@anaya.com.sg'),(23,'Rika Sri Wahyuni','wahyunirikasri@gmail.com',2,1,0,0,0,1,1,'N','hardi.bramantio@anaya.com.sg'),(24,'anton','anton_elegant@yahoo.co.id',2,1,0,1,0,4,3,'A','dewi.dharez@anaya.com.sg'),(25,'Lidya Anindita','lidya.anindita@beraucoal.co.id',9,0,0,3,1,6,5,'N','hardi.bramantio@anaya.com.sg'),(26,'Fun Tour Medan','dewiskie@ymail.com',4,0,0,2,0,4,3,'N','hardi.bramantio@anaya.com.sg'),(125,'K Agency Bali','emma@kagencybali.com',30,0,0,15,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(29,'fredy','fredy_ozone@yahoo.com',25,0,0,13,0,3,2,'A','dewi.dharez@anaya.com.sg'),(30,'Ani Cahyani','ani.cahyani@holcim.com',3,2,0,0,0,4,3,'N','hardi.bramantio@anaya.com.sg'),(118,'Efata Tours','',32,0,2,16,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(133,'Conny','via BBM',18,4,0,5,4,5,4,'N','dewi.dharez@anaya.com.sg'),(35,'Maya','skp_tour@yahoo.com',14,16,0,15,0,4,3,'N','dewi.dharez@anaya.com.sg'),(36,'Matius','txgadingserpong.matius@gmail.com',21,0,1,11,0,3,2,'A','dewi.dharez@anaya.com.sg'),(264,'Intan Natalia','',4,1,0,2,0,6,5,'N','hanselzen@gmail.com'),(117,'Exotic Indonesia Holiday ','',15,0,1,7,1,3,2,'N','hanselzen@gmail.com'),(127,'NIKI TOUR','',16,0,1,7,1,4,3,'N','hanselzen@gmail.com'),(43,'savir travel','savirtravel@ymail.com',30,0,0,15,0,3,2,'A','dewi.dharez@anaya.com.sg'),(44,'daniel','danielawuy@yahoo.co.uk',2,2,0,2,0,2,1,'A','dewi.dharez@anaya.com.sg'),(45,'Fredy Gandana','fredy_ozone@yahoo.com',5,1,0,3,0,4,3,'A','dewi.dharez@anaya.com.sg'),(47,'Maria','maria.widjaja@mastrada.com',7,0,0,2,1,5,4,'N','dewi.dharez@anaya.com.sg'),(131,'Prayudhi Harmawan','',120,0,0,60,0,2,1,'N','hanselzen@gmail.com'),(132,'Syachrul Muslim','Syachrul Muslim',120,0,0,60,0,2,1,'N','hanselzen@gmail.com'),(50,'TL','',3,1,0,0,0,5,4,'A','hardi.bramantio@anaya.com.sg'),(51,'Yanuar','yanuar@ellatour.net',6,4,0,4,0,5,4,'A','dewi.dharez@anaya.com.sg'),(52,'agus','agus@ace-adventure-indonesia.com',10,0,0,5,0,3,2,'A','dewi.dharez@anaya.com.sg'),(129,'PW Bandung','PW bandung',120,0,0,60,0,3,2,'A','dewi.dharez@anaya.com.sg'),(54,'Indra','indra bekti kusuma',14,2,0,0,0,4,3,'N','hardi.bramantio@anaya.com.sg'),(128,'NIKI TOUR 2','',16,0,1,7,1,4,3,'N','hanselzen@gmail.com'),(155,'CENTRAL TRAVEL SERVICE BANDUNG','ida.domtix_cts@yahoo.com',136,0,6,68,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(113,'Solution Holiday','',20,0,0,10,0,3,2,'N','hanselzen@gmail.com'),(227,'Feni Zhou82','',12,5,0,7,1,5,4,'N','hanselzen@gmail.com'),(59,'amera','',4,1,0,1,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(60,'CLN','',6,0,0,3,0,4,3,'N','hardi.bramantio@anaya.com.sg'),(61,'PT Arai','',27,0,0,12,1,4,3,'A',''),(62,'taufik','fantastic_tour@yahoo.com',11,0,1,6,0,2,1,'A','dewi.dharez@anaya.com.sg'),(63,'Fatoni','kresnogroup@yahoo.co.id',20,0,0,10,0,3,2,'A','dewi.dharez@anaya.com.sg'),(64,'Huurul','surabaya.elmira@yahoo.com',40,0,0,20,0,3,2,'A','dewi.dharez@anaya.com.sg'),(67,'Marboen Tour','',10,0,0,5,0,3,2,'N','hardi.bramantio@anaya.com.sg'),(69,'NG MTR','itari_ok@yahoo.co.id',5,0,0,1,1,5,4,'A','hardi.bramantio@anaya.com.sg'),(90,'Raigina','raiginafalefianti@gmail.com',2,2,0,2,0,5,4,'A','dewi.dharez@anaya.com.sg'),(226,'Angelica Tour','Angelica',77,0,2,39,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(73,'Ajeng','syarasyalma@gmail.com',5,0,0,1,1,4,3,'A','dewi.dharez@anaya.com.sg'),(74,'Ravi','',10,2,0,2,3,3,2,'A','hardi.bramantio@anaya.com.sg'),(225,'Rinaldo Hadri','Rinaldo Hadri',28,0,1,15,0,2,1,'A','dewi.dharez@anaya.com.sg'),(346,'Melissa','',9,0,0,3,1,2,1,'N','hanselzen@gmail.com'),(79,'Harry','',9,0,0,3,1,5,4,'N','hanselzen@gmail.com'),(224,'Nico','',20,0,0,10,0,2,1,'N','hanselzen@gmail.com'),(123,'Dara','dara.ayunda@patra-sk.com',5,0,0,1,1,3,2,'A','dewi.dharez@anaya.com.sg'),(82,'Sukartinah','',9,1,0,2,2,5,4,'N','hanselzen@gmail.com'),(83,'Santie','',70,0,0,35,0,3,2,'N','hanselzen@gmail.com'),(91,'Tiarma Hutagalung ','',9,0,0,3,1,3,2,'N','hanselzen@gmail.com'),(92,'PATUNO RESORT WAKATOBI','sales_bali@wakatobipatunoresort.com',45,0,0,12,7,4,3,'A','hardi.bramantio@anaya.com.sg'),(93,'Kristina Evanali','',45,0,0,12,7,4,3,'N','hanselzen@gmail.com'),(94,'Caroline Russian','',10,0,0,5,0,4,3,'N','hanselzen@gmail.com'),(95,'teti heryani','teti_heryani@yahoo.com',31,0,1,16,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(122,'Lisala','',7,18,1,4,6,3,2,'N','hanselzen@gmail.com'),(126,'K Agency Bali 5D4N','emma@kagencybali.com',30,0,0,15,0,5,4,'A','hardi.bramantio@anaya.com.sg'),(98,'Fitri','fiet_379@xl.blackberry.com',2,2,0,2,0,6,5,'A','hardi.bramantio@anaya.com.sg'),(99,'Hidayah','',2,3,0,2,0,3,2,'A','dewi.dharez@anaya.com.sg'),(100,'Sri Wahyuni','',4,0,0,2,0,3,2,'A','dewi.dharez@anaya.com.sg'),(101,'Irana Rent A Car','iranarentacar@ymail.com',78,0,3,39,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(102,'Fredy Legoland','',7,0,0,2,1,5,4,'A','dewi.dharez@anaya.com.sg'),(103,'Oskar Hadinoto','',60,0,0,30,0,3,2,'N','hanselzen@gmail.com'),(251,'fitriah_h@ymail.com','fitriah_h@ymail.com',10,0,0,5,0,2,1,'A','dewi.dharez@anaya.com.sg'),(105,'Tri','Tri',3,0,0,0,1,4,3,'A','dewi.dharez@anaya.com.sg'),(106,'PT. ARREHLAH WISATA','',45,0,0,18,3,2,1,'N','hanselzen@gmail.com'),(107,'ARREHLAH WISATA','',45,0,0,18,3,2,1,'N','hanselzen@gmail.com'),(400,'Vibriana Manda Samsu','Vibriana Manda Samsu',32,0,0,16,0,4,3,'A','dewi.dharez@anaya.com.sg'),(110,'Kanyamon','',36,0,1,19,0,3,2,'N','hanselzen@gmail.com'),(134,'OV Tours Travel','',68,0,0,25,6,4,3,'N','hanselzen@gmail.com'),(398,'Nita Veronika','',16,0,0,8,0,2,1,'A','hanselzen@gmail.com'),(136,'riva fahlevi','rifa.fahlevi@millenniumhotels.com',25,5,0,5,5,3,2,'A','dewi.dharez@anaya.com.sg'),(137,'desy','desy.n.widya@banksinarmas.com',2,1,0,0,1,4,3,'A','dewi.dharez@anaya.com.sg'),(138,'endah','endah iswantie',11,1,0,6,0,2,1,'A','dewi.dharez@anaya.com.sg'),(139,'RIFA FAHLEVI','',25,5,0,15,0,3,2,'N','hanselzen@gmail.com'),(140,'HERU HARTONO','',18,0,3,3,4,3,2,'A','dewi.dharez@anaya.com.sg'),(399,'Fransiska 3D2N','',42,0,2,22,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(143,'INSTATOUR','',41,0,1,21,0,2,1,'N','hanselzen@gmail.com'),(144,'muhamad rafiq','muhamad rafiq',20,4,0,9,2,3,2,'A','dewi.dharez@anaya.com.sg'),(145,'Arna Tour','gitaayoend@gmail.com',21,0,1,11,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(146,'PT RHEMA RABAH WISATA','operational_3@rhematours.com',16,0,0,8,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(147,'Viva','vivanirmala@yahoo.com',10,0,0,5,0,2,1,'A','dewi.dharez@anaya.com.sg'),(148,'Wayan Rencana','',9,0,1,3,1,5,4,'N','hanselzen@gmail.com'),(254,'etravelhub Jane','',21,0,1,11,0,4,3,'N','hanselzen@gmail.com'),(150,'mitha','',6,0,0,3,0,4,3,'A','dewi.dharez@anaya.com.sg'),(151,'Dina','ticketing@altratour.com',25,0,0,11,1,3,2,'A','dewi.dharez@anaya.com.sg'),(152,'Pt trisanjaya utama','disandria@yahoo.com',30,0,0,15,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(153,'etravelhub','',30,0,0,15,0,4,3,'N','hanselzen@gmail.com'),(156,'Viva finhar insani Nirmala','',101,0,3,51,0,5,4,'N','hanselzen@gmail.com'),(157,'puput','puput.ind@gmail.com',10,0,0,5,0,3,2,'A','dewi.dharez@anaya.com.sg'),(158,'Try','utik_bunny@yahoo.com',8,0,0,4,0,3,2,'A','dewi.dharez@anaya.com.sg'),(159,'kiki','suryamesindo@yahoo.com',12,2,0,7,0,3,2,'A','dewi.dharez@anaya.com.sg'),(161,'PT. Bahati Jaya Tour and Travel','yantea_moffatts@yahoo.com',80,0,2,40,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(255,'Agus 7d6n','ACE Adventure®',9,0,0,5,0,7,6,'A','hardi.bramantio@anaya.com.sg'),(163,'herbalife','',80,0,0,40,0,5,4,'A','dewi.dharez@anaya.com.sg'),(164,'Alge 8','alaransel.info@gmail.com',8,0,0,4,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(165,'Bintang Abadi','bintangabadi_tech@yahoo.com',16,0,0,8,0,3,2,'A','dewi.dharez@anaya.com.sg'),(166,'InstaTour 3D2N','prayudhi@instatour-indo.com',51,0,1,26,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(168,'Kiki Juanda','kie_juanda@yahoo.com',2,2,0,0,1,3,2,'A','dewi.dharez@anaya.com.sg'),(169,'Asep Satia','asvsatia@hotmail.com',50,0,0,25,0,3,2,'A','dewi.dharez@anaya.com.sg'),(170,'Asep Satia Kusuma','',50,0,0,25,0,3,2,'N','hanselzen@gmail.com'),(171,'PT.  Megananda Trans','info.megananda@gmail.com',103,0,3,51,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(172,'Helena Cosmas','',23,0,0,11,1,3,2,'N','hanselzen@gmail.com'),(397,'Fransiska 4D3N','',70,0,2,36,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(174,'A2 Travel Indonesia','a2travelindonesia@gmail.com',31,0,1,16,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(175,'Agung Junaris','a2travelindonesia@gmail.com',30,0,0,15,0,3,2,'A','dewi.dharez@anaya.com.sg'),(176,'Trip Booking','',24,0,0,12,0,4,3,'N','dewi.dharez@anaya.com.sg'),(177,'Carry Chandra','carrycha@gmail.com',124,0,4,62,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(178,'Lilik Wardani','',110,0,2,55,0,3,2,'N','hanselzen@gmail.com'),(179,'Lilik Wardani 3D2N','balibedira.tour@yahoo.com',104,0,4,52,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(180,'Viva Nirmala','',10,0,0,5,0,3,2,'N','hanselzen@gmail.com'),(181,'Sitompul','',3,1,0,2,0,2,1,'A','dewi.dharez@anaya.com.sg'),(182,'Niken','',15,0,0,8,0,3,2,'A','dewi.dharez@anaya.com.sg'),(183,'Wiwit Handayani','',4,0,0,2,0,3,2,'A','dewi.dharez@anaya.com.sg'),(396,'Rifki wiener','',4,1,0,0,0,4,3,'A','feiny@anaya.com.sg'),(185,'Lilik Wardani 3D2N 52pax','balibedira.tour@yahoo.com',52,0,2,26,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(186,'25 Tour','info@25travel.com',164,0,4,82,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(188,'25 Tour 10pax','info@25travel.com',11,0,1,6,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(187,'Glow Tour And Travel','glowtourandtravel@yahoo.co.id',28,0,2,14,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(189,'CTS Tour and Travel 2pax','ida.domtix_cts@yahoo.com',1,1,0,1,0,3,2,'N','hardi.bramantio@anaya.com.sg'),(190,'Dulcet Travel','',10,10,0,10,0,3,2,'A','dewi.dharez@anaya.com.sg'),(191,'GNTT 18pax 3D2N','gntt.tours@gmail.com',19,0,1,10,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(192,'Lidya','lidya_marthauli@yahoo.com',6,1,0,3,0,4,3,'A','dewi.dharez@anaya.com.sg'),(193,'GNTT 14 pax 3D2N','gntt.tours@gmail.com',13,0,0,6,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(194,'25 Tour meeting 10pax','info@25travel.com',11,0,1,6,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(195,'Test','test',14,3,1,7,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(196,'Armanto','Armanto',8,0,0,4,0,3,2,'A','dewi.dharez@anaya.com.sg'),(197,'Royan','alkania_tour@yahoo.co.id',31,0,0,16,0,2,1,'A','dewi.dharez@anaya.com.sg'),(198,'Barianda','',40,0,0,21,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(199,'Tica','',119,0,3,51,6,2,1,'A','hardi.bramantio@anaya.com.sg'),(200,'Bahsuni','',2,0,0,1,0,5,4,'A','ella.veronica@anaya.com.sg'),(201,'Dedy Harmizon','dedyharmizon@yahoo.com',2,1,0,1,0,4,3,'A','ella.veronica@anaya.com.sg'),(202,'Adita','info@lotuswahanabali.com',2,0,0,1,0,5,4,'A','ella.veronica@anaya.com.sg'),(203,'ella tes','',2,0,1,1,0,3,2,'N','ella.veronica@anaya.com.sg'),(204,'Daisy 4D3N','',5,0,0,1,1,4,3,'N','hanselzen@gmail.com'),(205,'Pratmesh','praths12@hotmail.com',2,0,0,0,0,4,3,'A','ella.veronica@anaya.com.sg'),(206,'HANDY LIVE TRAVEL','',9,0,0,0,3,2,1,'N','hanselzen@gmail.com'),(207,'B 40pax','',50,0,0,26,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(208,'Ulla','w_ticket@yahoo.com',17,0,0,7,1,4,3,'A','ella.veronica@anaya.com.sg'),(209,'Freddy_Oz','',2,0,0,1,0,3,2,'N','ella.veronica@anaya.com.sg'),(210,'indie global tour and travel','',119,0,3,51,6,2,1,'N','hanselzen@gmail.com'),(211,'Citra Aimee','',7,0,0,2,1,4,3,'N','hanselzen@gmail.com'),(212,'Hovando Holidays','',14,3,1,6,2,3,2,'N','hanselzen@gmail.com'),(395,'maya hayati','',2,4,0,0,2,3,2,'N','hanselzen@gmail.com'),(214,'Ni-Co','nico',2,2,0,0,1,5,4,'A','dewi.dharez@anaya.com.sg'),(394,'maestro travel','maestro travel',7,0,0,4,0,3,2,'A','dewi.dharez@anaya.com.sg'),(217,'caraka','caraka',10,0,0,5,0,3,2,'A','dewi.dharez@anaya.com.sg'),(218,'PW BDG','100pax',100,0,0,50,0,3,2,'A','dewi.dharez@anaya.com.sg'),(220,'Ho-Vando','Hovando',11,0,1,6,0,2,1,'A','dewi.dharez@anaya.com.sg'),(221,'sri','study tour',18,3,0,0,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(263,'florensy','',59,0,0,28,1,3,2,'N','hanselzen@gmail.com'),(223,'Eva Raya Tour','',40,0,0,20,0,3,2,'A','hanselzen@gmail.com'),(229,'GNTT 11 pax','mahasiswa',11,0,1,2,1,4,3,'A','hardi.bramantio@anaya.com.sg'),(230,'INDOTOUR','Rifky',5,2,0,2,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(231,'Sesilia','2H1M + tiket airasia',60,0,0,30,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(232,'Labado Tour 26 Mei','3D2N',8,1,0,3,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(393,'Emin Rabali','',15,0,1,6,1,2,1,'N','hanselzen@gmail.com'),(234,'Clara Veraditha','',2,2,0,0,1,3,2,'N','hanselzen@gmail.com'),(235,'Anita Wijaya Karya','',2,0,0,1,0,3,2,'N','hanselzen@gmail.com'),(236,'Bank Swasta 3D 2N','Bank Swasta 3D 2N',250,0,0,65,40,3,2,'A','dewi.dharez@anaya.com.sg'),(237,'Nina Anjani','',40,0,2,25,0,3,2,'N','hanselzen@gmail.com'),(238,'zero wisata','zero wisata',84,0,4,42,0,3,2,'A','dewi.dharez@anaya.com.sg'),(239,'New zero wisata','New Zero Wisata',50,0,0,25,0,3,2,'A','dewi.dharez@anaya.com.sg'),(240,'Maya Herbalife','',9,0,0,3,1,5,4,'N','hanselzen@gmail.com'),(241,'Clara Veraditha 3D2N','',11,0,1,6,0,3,2,'N','hanselzen@gmail.com'),(242,' Marjorie Jayne Zamudio (Family)','',3,1,0,0,1,4,3,'N','hanselzen@gmail.com'),(243,'dhe riyadi','dhe riyadi',3,0,0,0,1,4,3,'A','dewi.dharez@anaya.com.sg'),(244,'Alexander Adrysakari P','apanengam@permatabank.co.id',40,0,0,20,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(245,'ALIF TRAVEL','',6,0,0,0,0,3,2,'N','hanselzen@gmail.com'),(246,'Alex Permata','',41,0,0,0,0,3,2,'N','hanselzen@gmail.com'),(247,'MW Lai','',3,2,0,0,2,6,5,'A','hardi.bramantio@anaya.com.sg'),(248,'Amillya','',49,0,3,25,0,3,2,'N','hanselzen@gmail.com'),(249,'Nina Anjani 2','',40,0,2,25,0,3,2,'N','hanselzen@gmail.com'),(250,'Chrismerry','Chrismerry',2,2,0,0,1,4,3,'A','dewi.dharez@anaya.com.sg'),(257,'Lia','Jayagiri',11,0,0,4,1,7,6,'A','hardi.bramantio@anaya.com.sg'),(258,'Ellyas Situmorang','',15,0,0,8,0,5,4,'N','hanselzen@gmail.com'),(259,'Ellyas Situmorang 120PAX','',123,0,3,60,1,3,2,'N','hanselzen@gmail.com'),(260,'Dragon 8a&1c','Dragon 8a&1c',8,1,0,3,1,5,4,'N','dewi.dharez@anaya.com.sg'),(261,'Sintan','Sintan',3,1,0,2,0,5,4,'A','dewi.dharez@anaya.com.sg'),(262,'Fredy 8a1c','Fredy 8a1c',8,1,0,3,1,5,4,'A','dewi.dharez@anaya.com.sg'),(265,'Erna Kaloka','',6,0,0,3,0,4,3,'N','hanselzen@gmail.com'),(266,'Afen','Afen',10,1,0,4,1,4,3,'A','dewi.dharez@anaya.com.sg'),(267,'Jittra Wattanavet','',1,10,0,6,0,3,2,'A','hanselzen@gmail.com'),(268,'Ani','',3,1,0,0,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(269,'Afen2','Afen2',3,2,0,2,0,4,3,'A','dewi.dharez@anaya.com.sg'),(270,'Risna','ATKPMKS',28,0,1,13,1,4,3,'A','hardi.bramantio@anaya.com.sg'),(271,'Claudia Ng','',40,0,0,0,0,1,1,'N','hanselzen@gmail.com'),(272,'Nico 6A2C','Nico 6A2C',6,2,0,4,0,4,3,'A','dewi.dharez@anaya.com.sg'),(273,'jmcshop@yahoo.com','jmcshop@yahoo.com',5,1,0,2,1,4,3,'A','dewi.dharez@anaya.com.sg'),(274,'Jessica Claudia','jche.cloud@gmail.com',10,0,0,2,2,4,3,'A','dewi.dharez@anaya.com.sg'),(275,'Mona','tinemona43@yahoo.com',20,0,0,10,0,2,1,'A','dewi.dharez@anaya.com.sg'),(276,' jaka sampun','',4,2,0,2,0,3,2,'N','hanselzen@gmail.com'),(392,'Sri Wahyuni 2','',19,0,1,8,1,2,1,'N','hanselzen@gmail.com'),(278,'lilianti','lilianti',16,1,0,9,0,3,2,'A','dewi.dharez@anaya.com.sg'),(279,'Sophia','Sophia',6,1,0,2,1,4,3,'A','dewi.dharez@anaya.com.sg'),(280,'Linda','',5,1,0,0,0,3,2,'N','hanselzen@gmail.com'),(281,'Reyna Ikhsanty','Reyna Ikhsanty',10,0,0,5,0,3,2,'A','dewi.dharez@anaya.com.sg'),(282,'Feiny','Feiny',6,4,0,3,2,4,3,'N','dewi.dharez@anaya.com.sg'),(283,'Ito','',12,0,0,6,0,5,4,'N','hanselzen@gmail.com'),(284,'Dede Saputra','',16,0,0,8,0,3,2,'N','hanselzen@gmail.com'),(285,'Dede Saputra 2','',16,0,0,8,0,3,2,'N','hanselzen@gmail.com'),(286,'ANNISA TRAVEL','',25,0,0,11,1,3,2,'N','hanselzen@gmail.com'),(287,'Farid','',40,0,0,20,0,2,1,'N','hanselzen@gmail.com'),(288,'Andrie Husein','',18,0,0,9,0,3,2,'A','hanselzen@gmail.com'),(289,'Tri Agus','',7,2,0,3,1,7,6,'A','hardi.bramantio@anaya.com.sg'),(290,'TriAgus1','',7,2,0,3,1,7,6,'A','hardi.bramantio@anaya.com.sg'),(291,'Every Joe Travel Services','',20,4,0,1,6,3,2,'N','hanselzen@gmail.com'),(292,'Linda Feiny','Linda Feiny',3,1,0,0,1,5,4,'A','dewi.dharez@anaya.com.sg'),(293,'Sonny Feiny','Sonny Feiny',6,4,0,1,2,4,3,'A','dewi.dharez@anaya.com.sg'),(294,'Yin Mar feiny','Yin Mar ',6,0,0,3,0,5,4,'A','dewi.dharez@anaya.com.sg'),(295,'ANA TOUR HOLIDAY','',21,0,1,11,0,3,2,'N','hanselzen@gmail.com'),(296,'Bang farid','',12,0,0,3,2,2,2,'A','dewi.dharez@anaya.com.sg'),(297,' Voltaire R Domingo','',5,0,0,1,1,3,2,'N','hanselzen@gmail.com'),(298,'prayitno 54pax','',54,0,0,28,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(299,'Lili','',7,4,0,0,0,9,8,'A','hardi.bramantio@anaya.com.sg'),(300,'Ito Narotomo','',15,0,0,6,1,3,2,'A','hanselzen@gmail.com'),(301,'Bapak Fuad','bapak fuad feiny',20,0,0,10,0,3,2,'A','dewi.dharez@anaya.com.sg'),(302,'Touch Me Travel','',11,0,1,11,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(303,'mybabycctv','',7,4,0,4,0,9,8,'N','hanselzen@gmail.com'),(304,'Diana Prastiti','Diana Prastiti',4,4,0,3,0,3,2,'A','dewi.dharez@anaya.com.sg'),(305,'Komang Feiny','sayudek@yahoo.com',20,10,0,15,0,5,4,'A','dewi.dharez@anaya.com.sg'),(306,'Fredy Dragor Tour','',16,0,1,7,1,3,2,'N','hanselzen@gmail.com'),(307,'Parlo Tours Sdn Bhd','',6,0,0,3,0,3,2,'N','hanselzen@gmail.com'),(308,'Ito Feiny','Ito ata ',16,0,1,9,0,3,2,'A','dewi.dharez@anaya.com.sg'),(309,'Ito Narotomo Oct','',6,0,0,3,0,3,2,'N','hanselzen@gmail.com'),(310,'ana','ana',21,0,1,11,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(311,'Stanley manado','stanley',2,0,0,1,0,3,2,'A','feiny@anaya.com.sg'),(312,'Ana Travel','Ana Travel',14,0,0,8,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(313,'ANJAR ','ATRA TOUR AND TRAVEL',3,0,0,2,0,5,4,'A','dewi.dharez@anaya.com.sg'),(314,'Endang Widiretno Setyarini','',30,0,0,15,0,3,2,'N','hanselzen@gmail.com'),(315,'Yuli Tjong','Yuli ',14,0,0,7,0,3,2,'A','feiny@anaya.com.sg'),(316,'Echo Tours','',21,0,1,11,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(317,'Family Fun ','family fun',4,0,0,2,0,3,2,'A','feiny@anaya.com.sg'),(318,'F1 tour','F1 tour ',4,0,0,2,0,4,3,'A','feiny@anaya.com.sg'),(319,'jessemarrino','jessemarrino',36,3,0,20,0,4,3,'A','dewi.dharez@anaya.com.sg'),(320,'Handy','Handy',13,0,0,7,0,4,3,'A','dewi.dharez@anaya.com.sg'),(321,'Firman Kamil ','',14,0,0,7,0,3,2,'N','hanselzen@gmail.com'),(322,'Luc Le Saos','luc.ls@salaun-holidays.com',19,0,1,11,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(323,'Ito Ata','Ito',16,0,0,8,0,3,2,'A','feiny@anaya.com.sg'),(324,' Stephen Adilukito Putra',' Stephen Adilukito Putra',2,0,0,1,0,3,2,'A','dewi.dharez@anaya.com.sg'),(325,'Ito Ata 1','Ito Ata 1 ',43,0,1,22,0,3,2,'A','feiny@anaya.com.sg'),(326,'Ito Ata 2 ','Ito Ata 2 ',62,0,2,31,0,3,2,'A','feiny@anaya.com.sg'),(327,'Ito Narotomo Oct 2','',20,0,0,10,0,3,2,'N','hanselzen@gmail.com'),(328,'Ena Maria','',12,75,0,87,0,3,2,'N','hanselzen@gmail.com'),(329,'Susi Bali','Susi Bali',8,3,0,4,0,4,3,'A','dewi.dharez@anaya.com.sg'),(330,'GNNT Finda','GNNT Finda',13,10,2,10,0,3,2,'A','dewi.dharez@anaya.com.sg'),(331,'Benny Darmadi','',22,0,0,11,0,3,2,'N','hanselzen@gmail.com'),(332,'Benny Darmadi 2','',22,0,0,11,0,3,2,'N','hanselzen@gmail.com'),(333,'Nico 12pax','Nico 12pax',12,0,0,6,0,3,2,'A','dewi.dharez@anaya.com.sg'),(334,'Viva 20pax','Viva 20pax',30,0,0,15,0,3,2,'A','dewi.dharez@anaya.com.sg'),(335,'Touch Travel 1','ishak@tm-group.com.my',23,1,1,14,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(336,'Eni Widiastuti','',2,2,0,2,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(337,'PW universitas','marketing@panduanwisata.com ',30,0,0,15,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(338,'Audrey','Audrey Syilby',100,0,0,0,0,1,0,'A','dewi.dharez@anaya.com.sg'),(339,'Rafindo Tour','Rafindo Tour',25,0,0,13,0,2,1,'A','dewi.dharez@anaya.com.sg'),(340,'Jessica Wong','',14,0,0,4,2,4,3,'A','hanselzen@gmail.com'),(341,'Neelam Palany','',39,1,1,20,0,4,3,'N','hanselzen@gmail.com'),(342,'Frans Rikardo','',42,0,2,21,0,3,2,'N','hanselzen@gmail.com'),(343,'afen wu 30','',30,0,0,15,0,3,2,'N','hanselzen@gmail.com'),(344,'Tor','',5,0,0,1,1,3,2,'N','hanselzen@gmail.com'),(345,'Januardi','',10,0,0,5,0,5,4,'A','hanselzen@gmail.com'),(347,'ATA 15pax','',15,0,0,6,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(348,'宏 thh','',14,0,0,7,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(349,'ong w/hotel','3D2N tour hotel',10,0,0,0,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(350,'INDONESIAN DYNASTY','',20,0,0,10,0,3,2,'A','hanselzen@gmail.com'),(351,'Wilhelm Jacobin','Wilhelm Jacobin',36,0,0,18,0,6,5,'A','dewi.dharez@anaya.com.sg'),(352,'Ong Sin Kwei','',10,0,0,5,0,3,2,'N','hanselzen@gmail.com'),(353,'Tania 60pax','',60,0,0,31,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(354,'Kingstour Travel','',16,0,1,16,0,2,1,'N','hanselzen@gmail.com'),(355,'PW 15px','',15,0,0,6,1,5,4,'A','hardi.bramantio@anaya.com.sg'),(356,'Paket 3D2N','',103,0,3,51,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(357,'SG+JB','4d3n',4,0,0,2,0,4,3,'A','feiny@anaya.com.sg'),(358,'Virgin Prily','',3,0,0,0,1,6,5,'A','hardi.bramantio@anaya.com.sg'),(359,'3D2N 100pax','',103,0,3,50,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(360,'100pax','',103,0,3,50,1,3,2,'N','hanselzen@gmail.com'),(361,'PT.Caldera Lintas Indonesia','debby@calderaindonesia.com',25,0,0,11,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(362,'PT Suzuki','',20,0,0,10,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(363,'60pax Sophia','',60,0,0,12,12,4,3,'N','hanselzen@gmail.com'),(364,'2 pax ','',2,0,0,1,0,5,4,'A','hardi.bramantio@anaya.com.sg'),(365,'SG wed','SG wed',15,0,0,8,0,4,3,'A','feiny@anaya.com.sg'),(366,'SD Tour','SD tour',16,0,1,8,0,2,1,'A','feiny@anaya.com.sg'),(377,'Anag Setiawan','',14,0,0,7,0,3,2,'N','hanselzen@gmail.com'),(367,'SMA Tour','SMA tour',26,0,1,26,0,3,2,'A','feiny@anaya.com.sg'),(368,'Kingstour 10pax','',1,15,1,16,0,3,2,'N','hanselzen@gmail.com'),(369,'Kings Tour 3d2n','',2,0,0,1,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(370,'AsiaWisata 3d2n 70pax','',72,0,2,36,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(371,'4pax 3d2n','',4,0,0,2,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(372,'FIF Bali','Transport Travel',14,0,0,7,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(373,'Tanaya Travel 3D2N','',26,0,1,13,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(374,'Anna Hasanah','Anna Hasanah',7,4,0,3,2,4,3,'N','dewi.dharez@anaya.com.sg'),(375,'sutotokh','by YM',7,5,0,4,0,5,4,'A','dewi.dharez@anaya.com.sg'),(376,'HMT','HMT',20,20,1,20,0,3,2,'A','dewi.dharez@anaya.com.sg'),(378,'Anna Hasanah 1','',8,4,0,3,2,4,3,'A','hardi.bramantio@anaya.com.sg'),(379,'ITO  24 - 26 oct','',26,0,1,26,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(380,'Albayt Wisata Universal','',40,0,0,20,0,4,3,'A','hanselzen@gmail.com'),(381,'Chen Loke Wah','',3,0,0,0,1,3,2,'N','hanselzen@gmail.com'),(382,'45pax Transit','',45,0,2,0,0,1,0,'N','hanselzen@gmail.com'),(383,'Wilan','Wilan',4,1,0,1,1,4,3,'A','dewi.dharez@anaya.com.sg'),(390,'Paket 3D2N USS WOT CT','',11,0,0,6,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(384,'ellyas','ata tour',21,0,1,11,0,3,2,'A','feiny@anaya.com.sg'),(385,'woro.wi3travel','woro.wi3travel',21,0,1,11,0,3,2,'A','dewi.dharez@anaya.com.sg'),(386,'Nico 20pax','',20,0,0,10,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(387,'jofanraditya@rocketmail.com','jofanraditya@rocketmail.com',40,0,0,20,0,3,2,'A','dewi.dharez@anaya.com.sg'),(388,'Nico F','Nico F',20,0,0,10,0,3,2,'A','dewi.dharez@anaya.com.sg'),(389,'Fransiska','',43,0,3,22,0,5,4,'A','hardi.bramantio@anaya.com.sg'),(391,'AsiaWisata 3d2n 4 pax','',4,0,0,2,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(401,'Rose Ann Policarpio','',5,0,0,1,1,8,7,'N','hanselzen@gmail.com'),(402,' indiraangga2311','',28,0,0,14,0,2,1,'N','hanselzen@gmail.com'),(403,'indiraangga2311@gmail.com','indiraangga2311@gmail.com',28,0,0,14,0,2,1,'N','dewi.dharez@anaya.com.sg'),(404,'lynnx.chang','lynnx.chang',9,0,0,3,1,3,2,'A','dewi.dharez@anaya.com.sg'),(405,'Etty','',6,5,0,3,2,3,2,'N','hanselzen@gmail.com'),(406,'Indra - Bimatama','',30,0,1,15,0,2,1,'A','hanselzen@gmail.com'),(407,'Happy Tour Mongolia LLC','happymongols@gmail.com',11,0,1,6,0,5,4,'A','hardi.bramantio@anaya.com.sg'),(408,'Duos Travel','',14,0,0,8,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(409,'Linawaty','',52,0,2,26,0,2,1,'A','hanselzen@gmail.com'),(410,'Charlie','',150,0,0,75,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(411,'Cintia','option A',6,2,0,4,0,3,2,'A','dewi.dharez@anaya.com.sg'),(412,'Cintia option B','option B',6,2,0,4,0,4,3,'A','dewi.dharez@anaya.com.sg'),(413,'Ananta Reza Mahendra Putra','',20,0,1,10,0,4,3,'A','hanselzen@gmail.com'),(414,'Bobby Bali 99','',50,0,2,25,0,3,2,'A','hanselzen@gmail.com'),(415,'Anang Family Gathering','',40,0,1,20,0,3,2,'A','hanselzen@gmail.com'),(416,' athalla wisata','fenty',20,0,0,10,0,4,3,'A','dewi.dharez@anaya.com.sg'),(417,'Asia Wisata 10pax 4D3N','',11,0,1,6,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(418,'PT. Masola Sejahtera','sekawansejati02@gmail.com',4,20,2,12,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(419,'Fenty','athallawisata',5,0,0,1,1,3,2,'A','dewi.dharez@anaya.com.sg'),(420,'Asia Wisata 10pax 3D2N','',11,0,1,6,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(421,'YOI TOURS TRAVEL','',16,0,1,7,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(422,'Ik Holidays 14 till 16 dec 2014','',35,0,1,18,0,3,2,'A','hardi.bramantio@anaya.com.sg'),(423,'TOUCH ME TRAVEL TOURS SDN BHD','ishak@tm-group.com.my',31,0,1,16,0,2,1,'A','hardi.bramantio@anaya.com.sg'),(424,'Albayt Wisata Universal 2','',10,0,0,5,0,4,3,'A','hanselzen@gmail.com'),(425,'IMPIAN KEMBARA HOLIDAY','',25,0,1,13,0,3,2,'A','hanselzen@gmail.com'),(426,'ari pesona wisata','',16,0,1,7,1,3,2,'A','hanselzen@gmail.com'),(427,'PT. Wahdan Sabilana','',16,7,1,11,0,4,3,'A','hardi.bramantio@anaya.com.sg'),(434,'puspa haryani widyowati <','puspa haryani widyowati <',2,0,0,1,0,4,3,'A','dewi.dharez@anaya.com.sg'),(428,'Shintia isabela','',11,5,1,7,1,2,1,'A','hanselzen@gmail.com'),(429,'Adi Pangarso','',7,2,0,3,1,5,4,'A','hanselzen@gmail.com'),(430,'sihntia isabela 2','',6,2,0,4,0,3,2,'A','hanselzen@gmail.com'),(431,'firman ilyas','',3,1,0,0,1,3,2,'A','hanselzen@gmail.com'),(432,'Fenty Augustine','',20,0,1,11,0,3,2,'A','hanselzen@gmail.com'),(433,' Iwan Batam Private Driver',' Iwan Batam Private Driver',100,0,0,0,0,1,0,'A','dewi.dharez@anaya.com.sg'),(435,'ellenzerlita_mwi','',30,0,1,16,0,3,2,'A','hanselzen@gmail.com'),(436,'Nelly Hotono','',40,0,1,21,0,4,3,'A','hanselzen@gmail.com'),(437,'Achyar','',103,0,3,50,1,3,2,'A','hardi.bramantio@anaya.com.sg'),(438,'dita ristia','ditaristia@ymail.com',3,0,0,0,1,3,2,'A','dewi.dharez@anaya.com.sg'),(439,'Rudyanto','',40,0,1,21,0,3,2,'A','hanselzen@gmail.com');