   KEY `IDX_BE5782F071B1AE2B` (`warclan_id`),
   CONSTRAINT `FK_BE5782F071B1AE2B` FOREIGN KEY (`warclan_id`) REFERENCES `Warclan` (`id`),
   CONSTRAINT `FK_BE5782F099E6F5DF` FOREIGN KEY (`player_id`) REFERENCES `Player` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=3298 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+) ENGINE=InnoDB AUTO_INCREMENT=3348 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --


LOCK TABLES `Membership` WRITE;
/*!40000 ALTER TABLE `Membership` DISABLE KEYS */;
INSERT INTO `Membership` VALUES (1,1,1,'2015-04-01 00:00:00',NULL),(2,2,1,'2015-04-01 00:00:00',NULL),(3,3,1,'2015-04-01 00:00:00','2015-06-19 00:00:00'),(4,4,1,'2015-04-01 00:00:00','2015-06-09 00:00:00'),(5,5,1,'2015-04-01 00:00:00','2015-06-07 00:00:00'),(6,6,1,'2015-04-01 00:00:00',NULL),(7,7,1,'2015-04-01 00:00:00','2015-05-03 00:00:00'),(8,8,1,'2015-04-01 00:00:00',NULL),(9,9,1,'2015-04-01 00:00:00','2015-04-27 00:00:00'),(10,10,1,'2015-04-01 00:00:00','2015-06-09 00:00:00'),(11,11,1,'2015-04-01 00:00:00','2015-06-10 00:00:00'),(12,12,1,'2015-04-01 00:00:00','2015-06-19 00:00:00'),(13,13,1,'2015-04-01 00:00:00','2015-04-03 00:00:00'),(14,14,1,'2015-04-01 00:00:00',NULL),(15,15,1,'2015-04-01 00:00:00','2015-07-12 00:00:00'),(16,16,1,'2015-04-01 00:00:00',NULL),(17,17,1,'2015-04-01 00:00:00',NULL),(18,21,1,'2015-04-01 00:00:00','2015-06-03 00:00:00'),(19,20,1,'2015-04-01 00:00:00',NULL),(20,19,1,'2015-04-01 00:00:00','2015-07-30 00:00:00'),(21,18,1,'2015-04-01 00:00:00','2015-05-28 00:00:00'),(22,25,1,'2015-04-01 00:00:00','2015-06-11 00:00:00'),(23,24,1,'2015-04-01 00:00:00','2015-06-29 00:00:00'),(24,23,1,'2015-04-01 00:00:00','2015-06-13 00:00:00'),(25,22,1,'2015-04-01 00:00:00','2015-05-17 00:00:00'),(26,29,1,'2015-04-01 00:00:00','2015-04-23 00:00:00'),(27,28,1,'2015-04-01 00:00:00',NULL),(28,27,1,'2015-04-01 00:00:00','2015-04-16 00:00:00'),(29,26,1,'2015-04-01 00:00:00',NULL),(30,33,1,'2015-04-01 00:00:00',NULL),(31,32,1,'2015-04-01 00:00:00','2015-07-16 00:00:00'),(32,31,1,'2015-04-01 00:00:00',NULL),(33,30,1,'2015-04-01 00:00:00','2015-04-22 00:00:00'),(34,34,1,'2015-04-01 00:00:00','2015-08-07 00:00:00'),(44,46,5,'2015-04-01 00:00:00',NULL),(45,47,5,'2015-04-01 00:00:00',NULL),(46,48,5,'2015-04-01 00:00:00',NULL),(47,49,5,'2015-04-01 00:00:00',NULL),(48,50,5,'2015-04-01 00:00:00',NULL),(49,51,5,'2015-04-01 00:00:00',NULL),(50,52,5,'2015-04-01 00:00:00',NULL),(51,53,5,'2015-04-01 00:00:00',NULL),(52,54,5,'2015-04-01 00:00:00',NULL),(53,55,5,'2015-04-01 00:00:00',NULL),(54,56,5,'2015-04-01 00:00:00',NULL),(56,58,5,'2015-04-01 00:00:00',NULL),(57,59,5,'2015-04-01 00:00:00',NULL),(58,60,5,'2015-04-01 00:00:00',NULL),(59,61,5,'2015-04-01 00:00:00',NULL),(60,62,5,'2015-04-01 00:00:00',NULL),(61,63,5,'2015-04-01 00:00:00',NULL),(62,64,5,'2015-04-01 00:00:00',NULL),(63,65,5,'2015-04-01 00:00:00',NULL),(64,66,5,'2015-04-01 00:00:00',NULL),(65,67,5,'2015-04-01 00:00:00',NULL),(66,68,5,'2015-04-01 00:00:00',NULL),(67,69,5,'2015-04-01 00:00:00',NULL),(68,70,5,'2015-04-01 00:00:00',NULL),(69,71,5,'2015-04-01 00:00:00',NULL),(70,72,5,'2015-04-01 00:00:00',NULL),(71,73,5,'2015-04-01 00:00:00',NULL),(72,74,5,'2015-04-01 00:00:00',NULL),(73,75,5,'2015-04-01 00:00:00',NULL),(74,76,5,'2015-04-01 00:00:00',NULL),(75,78,11,NULL,NULL),(76,79,11,NULL,NULL),(77,80,11,NULL,NULL),(78,81,11,NULL,NULL),(79,82,11,NULL,NULL),(80,83,11,NULL,NULL),(81,84,11,NULL,NULL),(82,85,11,NULL,NULL),(83,86,11,NULL,NULL),(84,87,11,NULL,NULL),(85,88,11,NULL,NULL),(86,89,11,NULL,NULL),(87,90,11,NULL,NULL),(88,91,11,NULL,NULL),(89,92,11,NULL,NULL),(90,93,11,NULL,NULL),(91,94,11,NULL,NULL),(92,95,11,NULL,NULL),(93,96,11,NULL,NULL),(94,97,11,NULL,NULL),(95,98,11,NULL,NULL),(96,99,11,NULL,NULL),(97,100,11,NULL,NULL),(98,101,11,NULL,NULL),(99,102,11,NULL,NULL),(100,103,11,NULL,NULL),(101,104,11,NULL,NULL),(102,105,11,NULL,NULL),(103,106,11,NULL,NULL),(104,107,11,NULL,NULL),(105,108,1,'2015-04-17 00:00:00','2015-06-23 00:00:00'),(106,109,12,NULL,NULL),(107,110,12,NULL,NULL),(108,111,12,NULL,NULL),(109,112,12,NULL,NULL),(110,113,12,NULL,NULL),(111,114,12,NULL,NULL),(112,115,12,NULL,NULL),(113,116,12,NULL,NULL),(114,117,12,NULL,NULL),(115,118,12,NULL,NULL),(116,119,12,NULL,NULL),(117,120,12,NULL,NULL),(118,121,12,NULL,NULL),(119,122,12,NULL,NULL),(120,123,12,NULL,NULL),(121,124,12,NULL,NULL),(122,125,12,NULL,NULL),(123,126,12,NULL,NULL),(124,127,12,NULL,NULL),(125,128,12,NULL,NULL),(126,129,12,NULL,NULL),(127,130,12,NULL,NULL),(128,131,12,NULL,NULL),(129,132,12,NULL,NULL),(130,133,12,NULL,NULL),(131,134,12,NULL,NULL),(132,135,12,NULL,NULL),(133,136,12,NULL,NULL),(134,137,12,NULL,NULL),(135,138,12,NULL,NULL),(136,139,1,'2015-04-19 00:00:00','2015-05-01 00:00:00'),(137,140,13,NULL,NULL),(138,141,13,NULL,NULL),(139,142,13,NULL,NULL),(140,143,13,NULL,NULL),(141,144,13,NULL,NULL),(142,145,13,NULL,NULL),(143,146,13,NULL,NULL),(144,147,13,NULL,NULL),(145,148,13,NULL,NULL),(146,149,13,NULL,NULL),(147,150,13,NULL,NULL),(148,151,13,NULL,NULL),(149,152,13,NULL,NULL),(150,153,13,NULL,NULL),(151,154,13,NULL,NULL),(152,155,13,NULL,NULL),(153,156,13,NULL,NULL),(154,157,13,NULL,NULL),(155,158,13,NULL,NULL),(156,159,13,NULL,NULL),(157,160,13,NULL,NULL),(158,161,13,NULL,NULL),(159,162,13,NULL,NULL),(160,163,13,NULL,NULL),(161,164,13,NULL,NULL),(162,165,13,NULL,NULL),(163,166,13,NULL,NULL),(164,167,13,NULL,NULL),(165,168,13,NULL,NULL),(166,169,13,NULL,NULL),(167,170,14,NULL,NULL),(168,171,14,NULL,NULL),(169,172,14,NULL,NULL),(170,173,14,NULL,NULL),(171,174,14,NULL,NULL),(172,175,14,NULL,NULL),(173,176,14,NULL,NULL),(174,177,14,NULL,NULL),(175,178,14,NULL,NULL),(176,179,14,NULL,NULL),(177,180,14,NULL,NULL),(178,181,14,NULL,NULL),(179,182,14,NULL,NULL),(180,183,14,NULL,NULL),(181,184,14,NULL,NULL),(182,185,14,NULL,NULL),(183,186,14,NULL,NULL),(184,187,14,NULL,NULL),(185,188,14,NULL,NULL),(186,189,14,NULL,NULL),(187,190,14,NULL,NULL),(188,191,14,NULL,NULL),(189,192,14,NULL,NULL),(190,193,14,NULL,NULL),(191,194,14,NULL,NULL),(192,195,15,NULL,NULL),(193,196,15,NULL,NULL),(194,197,15,NULL,NULL),(195,198,15,NULL,NULL),(196,199,15,NULL,NULL),(197,200,1,'2015-04-25 00:00:00','2015-05-01 00:00:00'),(198,201,15,NULL,NULL),(199,202,15,NULL,NULL),(200,203,15,NULL,NULL),(201,204,15,NULL,NULL),(202,205,15,NULL,NULL),(203,206,15,NULL,NULL),(204,207,15,NULL,NULL),(205,208,15,NULL,NULL),(206,209,15,NULL,NULL),(207,210,15,NULL,NULL),(208,211,15,NULL,NULL),(209,212,15,NULL,NULL),(210,213,15,NULL,NULL),(211,214,15,NULL,NULL),(212,215,15,NULL,NULL),(213,216,15,NULL,NULL),(214,217,15,NULL,NULL),(215,218,15,NULL,NULL),(216,219,15,NULL,NULL),(217,220,15,NULL,NULL),(218,221,15,NULL,NULL),(219,222,15,NULL,NULL),(220,223,15,NULL,NULL),(221,224,15,NULL,NULL),(222,225,15,NULL,NULL),(223,226,1,'2015-04-27 00:00:00',NULL),(224,227,1,'2015-04-27 00:00:00','2015-04-29 00:00:00'),(225,228,1,'2015-04-27 00:00:00','2015-05-03 00:00:00'),(226,229,1,'2015-04-27 00:00:00','2015-05-01 00:00:00'),(227,230,16,NULL,NULL),(228,231,16,NULL,NULL),(229,232,16,NULL,NULL),(230,233,16,NULL,NULL),(231,234,16,NULL,NULL),(232,235,16,NULL,NULL),(233,236,16,NULL,NULL),(234,237,16,NULL,NULL),(235,238,16,NULL,NULL),(236,239,16,NULL,NULL),(237,240,16,NULL,NULL),(238,241,16,NULL,NULL),(239,242,16,NULL,NULL),(240,243,16,NULL,NULL),(241,244,16,NULL,NULL),(242,245,16,NULL,NULL),(243,246,16,NULL,NULL),(244,247,16,NULL,NULL),(245,248,16,NULL,NULL),(246,249,16,NULL,NULL),(247,250,16,NULL,NULL),(248,251,16,NULL,NULL),(249,252,16,NULL,NULL),(250,253,16,NULL,NULL),(251,254,16,NULL,NULL),(252,255,16,NULL,NULL),(253,256,16,NULL,NULL),(254,257,16,NULL,NULL),(255,258,16,NULL,NULL),(256,259,16,NULL,NULL),(257,260,17,NULL,NULL),(258,261,17,NULL,NULL),(259,262,17,NULL,NULL),(260,263,17,NULL,NULL),(261,264,17,NULL,NULL),(262,265,17,NULL,NULL),(263,266,17,NULL,NULL),(264,267,17,NULL,NULL),(265,268,17,NULL,NULL),(266,269,17,NULL,NULL),(267,270,17,NULL,NULL),(268,271,17,NULL,NULL),(269,272,17,NULL,NULL),(270,273,17,NULL,NULL),(271,274,17,NULL,NULL),(272,275,17,NULL,NULL),(273,276,17,NULL,NULL),(274,277,17,NULL,NULL),(275,278,17,NULL,NULL),(276,279,17,NULL,NULL),(277,280,17,NULL,NULL),(278,281,17,NULL,NULL),(279,282,17,NULL,NULL),(280,283,17,NULL,NULL),(281,284,17,NULL,NULL),(282,285,17,NULL,NULL),(283,286,17,NULL,NULL),(284,287,17,NULL,NULL),(285,288,17,NULL,NULL),(286,289,17,NULL,NULL),(288,291,1,'2015-05-01 00:00:00','2015-05-15 00:00:00'),(289,292,1,'2015-05-01 00:00:00','2015-05-03 00:00:00'),(290,293,18,NULL,NULL),(291,294,18,NULL,NULL),(292,295,18,NULL,NULL),(293,296,18,NULL,NULL),(294,297,18,NULL,NULL),(295,298,18,NULL,NULL),(296,299,18,NULL,NULL),(297,300,18,NULL,NULL),(298,301,18,NULL,NULL),(299,302,18,NULL,NULL),(300,303,18,NULL,NULL),(301,304,18,NULL,NULL),(302,305,18,NULL,NULL),(303,306,18,NULL,NULL),(304,307,18,NULL,NULL),(305,308,18,NULL,NULL),(306,309,18,NULL,NULL),(307,310,18,NULL,NULL),(308,311,18,NULL,NULL),(309,312,18,NULL,NULL),(310,313,18,NULL,NULL),(311,314,18,NULL,NULL),(312,315,18,NULL,NULL),(313,316,18,NULL,NULL),(314,317,18,NULL,NULL),(315,318,19,NULL,NULL),(316,319,19,NULL,NULL),(317,320,19,NULL,NULL),(318,321,19,NULL,NULL),(319,322,19,NULL,NULL),(320,323,19,NULL,NULL),(321,324,19,NULL,NULL),(322,325,19,NULL,NULL),(323,326,19,NULL,NULL),(324,327,19,NULL,NULL),(325,328,19,NULL,NULL),(326,329,19,NULL,NULL),(327,330,19,NULL,NULL),(328,331,19,NULL,NULL),(329,332,19,NULL,NULL),(330,333,19,NULL,NULL),(331,334,19,NULL,NULL),(332,335,19,NULL,NULL),(333,336,19,NULL,NULL),(334,337,19,NULL,NULL),(335,338,19,NULL,NULL),(336,339,19,NULL,NULL),(337,340,19,NULL,NULL),(338,341,19,NULL,NULL),(339,342,19,NULL,NULL),(340,343,1,'2015-05-03 00:00:00','2015-06-15 00:00:00'),(341,344,1,'2015-05-03 00:00:00','2015-06-25 00:00:00'),(342,345,1,'2015-05-03 00:00:00','2015-05-05 00:00:00'),(343,346,1,'2015-05-03 00:00:00','2015-05-27 00:00:00'),(344,347,1,'2015-05-05 00:00:00','2015-05-09 00:00:00'),(345,348,20,NULL,NULL),(346,349,20,NULL,NULL),(347,350,20,NULL,NULL),(348,351,20,NULL,NULL),(349,352,20,NULL,NULL),(350,353,20,NULL,NULL),(351,354,20,NULL,NULL),(352,355,20,NULL,NULL),(353,356,20,NULL,NULL),(354,357,20,NULL,NULL),(355,358,20,NULL,NULL),(356,359,20,NULL,NULL),(357,360,20,NULL,NULL),(358,361,20,NULL,NULL),(359,362,20,NULL,NULL),(360,363,20,NULL,NULL),(361,364,20,NULL,NULL),(362,365,20,NULL,NULL),(363,366,20,NULL,NULL),(364,367,20,NULL,NULL),(365,368,20,NULL,NULL),(366,369,20,NULL,NULL),(367,370,20,NULL,NULL),(368,371,20,NULL,NULL),(369,372,20,NULL,NULL),(371,374,1,'2015-05-07 00:00:00','2015-05-09 00:00:00'),(372,375,1,'2015-05-07 00:00:00','2015-05-09 00:00:00'),(373,376,21,NULL,NULL),(374,377,21,NULL,NULL),(375,378,21,NULL,NULL),(376,379,21,NULL,NULL),(377,380,21,NULL,NULL),(378,381,21,NULL,NULL),(379,382,21,NULL,NULL),(380,383,21,NULL,NULL),(381,384,21,NULL,NULL),(382,385,21,NULL,NULL),(383,386,21,NULL,NULL),(384,387,21,NULL,NULL),(385,388,21,NULL,NULL),(386,389,21,NULL,NULL),(387,390,21,NULL,NULL),(388,391,21,NULL,NULL),(389,392,21,NULL,NULL),(390,393,21,NULL,NULL),(391,394,21,NULL,NULL),(392,395,21,NULL,NULL),(393,396,21,NULL,NULL),(394,397,21,NULL,NULL),(395,398,21,NULL,NULL),(396,399,21,NULL,NULL),(397,400,21,NULL,NULL),(398,401,21,NULL,NULL),(399,402,21,NULL,NULL),(400,403,21,NULL,NULL),(401,404,21,NULL,NULL),(402,405,21,NULL,NULL),(403,406,1,'2015-05-09 00:00:00','2015-05-26 00:00:00'),(404,407,1,'2015-05-09 00:00:00','2015-05-13 00:00:00'),(405,408,1,'2015-05-09 00:00:00','2015-05-10 00:00:00'),(406,409,22,NULL,NULL),(407,410,22,NULL,NULL),(408,411,22,NULL,NULL),(409,412,22,NULL,NULL),(410,413,22,NULL,NULL),(411,414,22,NULL,NULL),(412,415,22,NULL,NULL),(413,416,22,NULL,NULL),(414,417,22,NULL,NULL),(415,418,22,NULL,NULL),(416,419,22,NULL,NULL),(417,420,22,NULL,NULL),(418,421,22,NULL,NULL),(419,422,22,NULL,NULL),(420,423,22,NULL,NULL),(421,424,22,NULL,NULL),(422,425,22,NULL,NULL),(423,426,22,NULL,NULL),(424,427,22,NULL,NULL),(425,428,22,NULL,NULL),(426,429,22,NULL,NULL),(427,430,22,NULL,NULL),(428,431,22,NULL,NULL),(429,432,22,NULL,NULL),(430,433,22,NULL,NULL),(431,434,22,NULL,NULL),(432,435,22,NULL,NULL),(433,436,22,NULL,NULL),(434,437,22,NULL,NULL),(435,438,22,NULL,NULL),(436,439,1,'2015-05-11 00:00:00','2015-05-15 00:00:00'),(437,440,23,NULL,NULL),(438,441,23,NULL,NULL),(439,442,23,NULL,NULL),(440,443,23,NULL,NULL),(441,444,23,NULL,NULL),(442,445,23,NULL,NULL),(443,446,23,NULL,NULL),(444,447,23,NULL,NULL),(445,448,23,NULL,NULL),(446,449,23,NULL,NULL),(447,450,23,NULL,NULL),(448,451,23,NULL,NULL),(449,452,23,NULL,NULL),(450,453,23,NULL,NULL),(451,454,23,NULL,NULL),(452,455,23,NULL,NULL),(453,456,23,NULL,NULL),(454,457,23,NULL,NULL),(455,458,23,NULL,NULL),(456,459,23,NULL,NULL),(457,460,23,NULL,NULL),(458,461,23,NULL,NULL),(459,462,23,NULL,NULL),(460,463,23,NULL,NULL),(461,464,23,NULL,NULL),(462,465,23,NULL,NULL),(463,466,23,NULL,NULL),(464,467,23,NULL,NULL),(465,468,23,NULL,NULL),(466,469,23,NULL,NULL),(467,470,1,'2015-05-13 00:00:00','2015-05-17 00:00:00'),(468,471,1,'2015-05-13 00:00:00','2015-05-15 00:00:00'),(469,472,24,NULL,NULL),(470,473,24,NULL,NULL),(471,474,24,NULL,NULL),(472,475,24,NULL,NULL),(473,476,24,NULL,NULL),(474,477,24,NULL,NULL),(475,478,24,NULL,NULL),(476,479,24,NULL,NULL),(477,480,24,NULL,NULL),(478,481,24,NULL,NULL),(479,482,24,NULL,NULL),(480,483,24,NULL,NULL),(481,484,24,NULL,NULL),(482,485,24,NULL,NULL),(483,486,24,NULL,NULL),(484,487,24,NULL,NULL),(485,488,24,NULL,NULL),(486,489,24,NULL,NULL),(487,490,24,NULL,NULL),(488,491,24,NULL,NULL),(489,492,24,NULL,NULL),(490,493,24,NULL,NULL),(491,494,24,NULL,NULL),(492,495,24,NULL,NULL),(493,496,24,NULL,NULL),(494,497,24,NULL,NULL),(495,498,24,NULL,NULL),(496,499,24,NULL,NULL),(497,500,24,NULL,NULL),(498,501,24,NULL,NULL),(499,502,25,NULL,NULL),(500,503,25,NULL,NULL),(501,504,25,NULL,NULL),(502,505,25,NULL,NULL),(503,506,25,NULL,NULL),(504,507,25,NULL,NULL),(505,508,25,NULL,NULL),(506,509,25,NULL,NULL),(507,510,25,NULL,NULL),(508,511,25,NULL,NULL),(509,512,25,NULL,NULL),(510,513,25,NULL,NULL),(511,514,25,NULL,NULL),(512,515,25,NULL,NULL),(513,516,25,NULL,NULL),(514,517,25,NULL,NULL),(515,518,25,NULL,NULL),(516,519,25,NULL,NULL),(517,520,25,NULL,NULL),(518,521,25,NULL,NULL),(519,522,25,NULL,NULL),(520,523,25,NULL,NULL),(521,524,25,NULL,NULL),(522,525,25,NULL,NULL),(523,526,25,NULL,NULL),(524,527,1,'2015-05-17 00:00:00','2015-06-21 00:00:00'),(525,528,1,'2015-05-18 00:00:00',NULL),(526,529,26,NULL,NULL),(527,530,26,NULL,NULL),(528,531,26,NULL,NULL),(529,532,26,NULL,NULL),(530,533,26,NULL,NULL),(531,534,26,NULL,NULL),(532,535,26,NULL,NULL),(533,536,26,NULL,NULL),(534,537,26,NULL,NULL),(535,538,26,NULL,NULL),(536,539,26,NULL,NULL),(537,540,26,NULL,NULL),(538,541,26,NULL,NULL),(539,542,26,NULL,NULL),(540,543,26,NULL,NULL),(541,544,26,NULL,NULL),(542,545,26,NULL,NULL),(543,546,26,NULL,NULL),(544,547,26,NULL,NULL),(545,548,26,NULL,NULL),(546,549,26,NULL,NULL),(547,550,26,NULL,NULL),(548,551,26,NULL,NULL),(549,552,26,NULL,NULL),(550,553,26,NULL,NULL),(551,554,1,'2015-05-18 00:00:00','2015-05-22 00:00:00'),(552,555,1,'2015-05-18 00:00:00','2015-05-19 00:00:00'),(553,556,27,NULL,NULL),(554,557,27,NULL,NULL),(555,558,27,NULL,NULL),(556,559,27,NULL,NULL),(557,560,27,NULL,NULL),(558,561,27,NULL,NULL),(559,562,27,NULL,NULL),(560,563,27,NULL,NULL),(561,564,27,NULL,NULL),(562,565,27,NULL,NULL),(563,566,27,NULL,NULL),(564,567,27,NULL,NULL),(565,568,27,NULL,NULL),(566,569,27,NULL,NULL),(567,570,27,NULL,NULL),(568,571,27,NULL,NULL),(569,572,27,NULL,NULL),(570,573,27,NULL,NULL),(571,574,27,NULL,NULL),(572,575,27,NULL,NULL),(573,576,27,NULL,NULL),(574,577,27,NULL,NULL),(575,578,27,NULL,NULL),(576,579,27,NULL,NULL),(577,580,27,NULL,NULL),(578,581,27,NULL,NULL),(579,582,27,NULL,NULL),(580,583,27,NULL,NULL),(581,584,27,NULL,NULL),(582,585,27,NULL,NULL),(583,586,1,'2015-05-21 00:00:00','2015-05-27 00:00:00'),(584,587,1,'2015-05-21 00:00:00','2015-06-01 00:00:00'),(585,588,1,'2015-05-21 00:00:00','2015-05-29 00:00:00'),(586,589,28,NULL,NULL),(587,590,28,NULL,NULL),(588,591,28,NULL,NULL),(589,592,28,NULL,NULL),(590,593,28,NULL,NULL),(591,594,28,NULL,NULL),(592,595,28,NULL,NULL),(593,596,28,NULL,NULL),(594,597,28,NULL,NULL),(595,598,28,NULL,NULL),(596,599,28,NULL,NULL),(597,600,28,NULL,NULL),(598,601,28,NULL,NULL),(599,602,28,NULL,NULL),(600,603,28,NULL,NULL),(601,604,28,NULL,NULL),(602,605,28,NULL,NULL),(603,606,28,NULL,NULL),(604,607,28,NULL,NULL),(605,608,28,NULL,NULL),(606,609,28,NULL,NULL),(607,610,28,NULL,NULL),(608,611,28,NULL,NULL),(609,612,28,NULL,NULL),(610,613,28,NULL,NULL),(611,614,28,NULL,NULL),(612,615,28,NULL,NULL),(613,616,28,NULL,NULL),(614,617,28,NULL,NULL),(615,618,28,NULL,NULL),(617,13,1,'2015-05-22 00:00:00','2015-05-23 00:00:00'),(618,619,1,'2015-05-23 00:00:00','2015-05-27 00:00:00'),(619,620,1,'2015-05-23 00:00:00','2015-05-28 00:00:00'),(620,621,1,'2015-05-23 00:00:00','2015-05-27 00:00:00'),(621,622,29,NULL,NULL),(622,623,29,NULL,NULL),(623,624,29,NULL,NULL),(624,625,29,NULL,NULL),(625,626,29,NULL,NULL),(626,627,29,NULL,NULL),(627,628,29,NULL,NULL),(628,629,29,NULL,NULL),(629,630,29,NULL,NULL),(630,631,29,NULL,NULL),(631,632,29,NULL,NULL),(632,633,29,NULL,NULL),(633,634,29,NULL,NULL),(634,635,29,NULL,NULL),(635,636,29,NULL,NULL),(636,637,29,NULL,NULL),(637,638,29,NULL,NULL),(638,639,29,NULL,NULL),(639,640,29,NULL,NULL),(640,641,29,NULL,NULL),(641,642,29,NULL,NULL),(642,643,29,NULL,NULL),(643,644,29,NULL,NULL),(644,645,29,NULL,NULL),(645,646,29,NULL,NULL),(646,647,29,NULL,NULL),(647,648,29,NULL,NULL),(648,649,29,NULL,NULL),(649,650,29,NULL,NULL),(650,651,29,NULL,NULL),(651,652,29,NULL,NULL),(652,653,29,NULL,NULL),(653,654,29,NULL,NULL),(654,655,29,NULL,NULL),(655,656,29,NULL,NULL),(656,657,30,NULL,NULL),(657,658,30,NULL,NULL),(658,659,30,NULL,NULL),(659,660,30,NULL,NULL),(660,661,30,NULL,NULL),(661,662,30,NULL,NULL),(662,663,30,NULL,NULL),(663,664,30,NULL,NULL),(664,665,30,NULL,NULL),(665,666,30,NULL,NULL),(666,667,30,NULL,NULL),(667,668,30,NULL,NULL),(668,669,30,NULL,NULL),(669,670,30,NULL,NULL),(670,671,30,NULL,NULL),(671,672,30,NULL,NULL),(672,673,30,NULL,NULL),(673,674,30,NULL,NULL),(674,675,30,NULL,NULL),(675,676,30,NULL,NULL),(676,677,30,NULL,NULL),(677,678,30,NULL,NULL),(678,679,30,NULL,NULL),(679,680,30,NULL,NULL),(680,681,30,NULL,NULL),(681,682,30,NULL,NULL),(682,683,30,NULL,NULL),(683,684,30,NULL,NULL),(684,685,30,NULL,NULL),(685,686,30,NULL,NULL),(686,687,30,NULL,NULL),(687,688,30,NULL,NULL),(688,689,30,NULL,NULL),(689,690,30,NULL,NULL),(690,691,30,NULL,NULL),(691,692,1,'2015-05-28 00:00:00','2015-06-05 00:00:00'),(692,693,31,NULL,NULL),(693,694,31,NULL,NULL),(694,695,31,NULL,NULL),(695,696,31,NULL,NULL),(696,697,31,NULL,NULL),(697,698,31,NULL,NULL),(698,699,31,NULL,NULL),(699,700,31,NULL,NULL),(700,701,31,NULL,NULL),(701,702,31,NULL,NULL),(702,703,31,NULL,NULL),(703,704,31,NULL,NULL),(704,705,31,NULL,NULL),(705,706,31,NULL,NULL),(706,707,31,NULL,NULL),(707,708,31,NULL,NULL),(708,709,31,NULL,NULL),(709,710,31,NULL,NULL),(710,711,31,NULL,NULL),(711,712,31,NULL,NULL),(712,713,31,NULL,NULL),(713,714,31,NULL,NULL),(714,715,31,NULL,NULL),(715,716,31,NULL,NULL),(716,717,31,NULL,NULL),(717,228,1,'2015-05-28 00:00:00','2015-06-05 00:00:00'),(718,718,1,'2015-05-30 00:00:00','2015-06-01 00:00:00'),(719,719,32,NULL,NULL),(720,720,32,NULL,NULL),(721,721,32,NULL,NULL),(722,722,32,NULL,NULL),(723,723,32,NULL,NULL),(724,724,32,NULL,NULL),(725,725,32,NULL,NULL),(726,726,32,NULL,NULL),(727,727,32,NULL,NULL),(728,728,32,NULL,NULL),(729,729,32,NULL,NULL),(730,730,32,NULL,NULL),(731,731,32,NULL,NULL),(732,732,32,NULL,NULL),(733,733,32,NULL,NULL),(734,734,32,NULL,NULL),(735,735,32,NULL,NULL),(736,736,32,NULL,NULL),(737,737,32,NULL,NULL),(738,738,32,NULL,NULL),(739,739,32,NULL,NULL),(740,740,32,NULL,NULL),(741,741,32,NULL,NULL),(742,742,32,NULL,NULL),(743,743,32,NULL,NULL),(744,22,1,'2015-05-31 00:00:00','2015-06-29 00:00:00'),(745,744,1,'2015-06-01 00:00:00','2015-06-03 00:00:00'),(746,745,33,NULL,NULL),(747,746,33,NULL,NULL),(748,747,33,NULL,NULL),(749,748,33,NULL,NULL),(750,749,33,NULL,NULL),(751,750,33,NULL,NULL),(752,751,33,NULL,NULL),(753,752,33,NULL,NULL),(754,753,33,NULL,NULL),(755,754,33,NULL,NULL),(756,755,33,NULL,NULL),(757,756,33,NULL,NULL),(758,757,33,NULL,NULL),(759,758,33,NULL,NULL),(760,759,33,NULL,NULL),(761,760,33,NULL,NULL),(762,761,33,NULL,NULL),(763,762,33,NULL,NULL),(764,763,33,NULL,NULL),(765,764,33,NULL,NULL),(766,765,33,NULL,NULL),(767,766,33,NULL,NULL),(768,767,33,NULL,NULL),(769,768,33,NULL,NULL),(770,769,33,NULL,NULL),(771,770,33,NULL,NULL),(772,771,33,NULL,NULL),(773,772,33,NULL,NULL),(774,773,33,NULL,NULL),(775,774,33,NULL,NULL),(776,775,1,'2015-06-03 00:00:00','2015-06-12 00:00:00'),(777,776,1,'2015-06-03 00:00:00','2015-06-05 00:00:00'),(778,777,34,NULL,NULL),(779,778,34,NULL,NULL),(780,779,34,NULL,NULL),(781,780,34,NULL,NULL),(782,781,34,NULL,NULL),(783,782,34,NULL,NULL),(784,783,34,NULL,NULL),(785,784,34,NULL,NULL),(786,785,34,NULL,NULL),(787,786,34,NULL,NULL),(788,787,34,NULL,NULL),(789,788,34,NULL,NULL),(790,789,34,NULL,NULL),(791,790,34,NULL,NULL),(792,791,34,NULL,NULL),(793,792,34,NULL,NULL),(794,793,34,NULL,NULL),(795,794,34,NULL,NULL),(796,795,34,NULL,NULL),(797,796,34,NULL,NULL),(798,797,34,NULL,NULL),(799,798,34,NULL,NULL),(800,799,34,NULL,NULL),(801,800,34,NULL,NULL),(802,801,34,NULL,NULL),(803,802,34,NULL,NULL),(804,803,34,NULL,NULL),(805,804,34,NULL,NULL),(806,805,34,NULL,NULL),(807,806,34,NULL,NULL),(808,18,1,'2015-06-05 00:00:00',NULL),(809,807,35,NULL,NULL),(810,808,35,NULL,NULL),(811,809,35,NULL,NULL),(812,810,35,NULL,NULL),(813,811,35,NULL,NULL),(814,812,35,NULL,NULL),(815,813,35,NULL,NULL),(816,814,35,NULL,NULL),(817,815,35,NULL,NULL),(818,816,35,NULL,NULL),(819,817,35,NULL,NULL),(820,818,35,NULL,NULL),(821,819,35,NULL,NULL),(822,820,35,NULL,NULL),(823,821,35,NULL,NULL),(824,822,35,NULL,NULL),(825,823,35,NULL,NULL),(826,824,35,NULL,NULL),(827,825,35,NULL,NULL),(828,826,35,NULL,NULL),(829,827,35,NULL,NULL),(830,828,35,NULL,NULL),(831,829,35,NULL,NULL),(832,830,35,NULL,NULL),(833,831,35,NULL,NULL),(834,832,36,NULL,NULL),(835,833,36,NULL,NULL),(836,834,36,NULL,NULL),(837,835,36,NULL,NULL),(838,836,36,NULL,NULL),(839,837,36,NULL,NULL),(840,838,36,NULL,NULL),(841,839,36,NULL,NULL),(842,840,36,NULL,NULL),(843,841,36,NULL,NULL),(844,842,36,NULL,NULL),(845,843,36,NULL,NULL),(846,844,36,NULL,NULL),(847,845,36,NULL,NULL),(848,846,36,NULL,NULL),(849,847,36,NULL,NULL),(850,848,36,NULL,NULL),(851,849,36,NULL,NULL),(852,850,36,NULL,NULL),(853,851,36,NULL,NULL),(854,852,36,NULL,NULL),(855,853,36,NULL,NULL),(856,854,36,NULL,NULL),(857,855,36,NULL,NULL),(858,856,36,NULL,NULL),(859,857,36,NULL,NULL),(860,858,36,NULL,NULL),(861,859,36,NULL,NULL),(862,860,36,NULL,NULL),(863,861,36,NULL,NULL),(864,862,1,'2015-06-09 00:00:00','2015-06-17 00:00:00'),(865,863,37,NULL,NULL),(866,864,37,NULL,NULL),(867,865,37,NULL,NULL),(868,866,37,NULL,NULL),(869,867,37,NULL,NULL),(870,868,37,NULL,NULL),(871,869,37,NULL,NULL),(872,870,37,NULL,NULL),(873,871,37,NULL,NULL),(874,872,37,NULL,NULL),(875,873,37,NULL,NULL),(876,874,37,NULL,NULL),(877,875,37,NULL,NULL),(878,876,37,NULL,NULL),(879,877,37,NULL,NULL),(880,878,37,NULL,NULL),(881,879,37,NULL,NULL),(882,880,37,NULL,NULL),(883,881,37,NULL,NULL),(884,882,37,NULL,NULL),(885,883,1,'2015-06-11 00:00:00','2015-06-15 00:00:00'),(886,884,1,'2015-06-11 00:00:00','2015-06-13 00:00:00'),(887,885,1,'2015-06-11 00:00:00','2015-06-13 00:00:00'),(888,886,1,'2015-06-11 00:00:00','2015-06-19 00:00:00'),(889,887,38,NULL,NULL),(890,888,38,NULL,NULL),(891,889,38,NULL,NULL),(892,890,38,NULL,NULL),(893,891,38,NULL,NULL),(894,892,38,NULL,NULL),(895,893,38,NULL,NULL),(896,894,38,NULL,NULL),(897,895,38,NULL,NULL),(898,896,38,NULL,NULL),(899,897,38,NULL,NULL),(900,898,38,NULL,NULL),(901,899,38,NULL,NULL),(902,900,38,NULL,NULL),(903,901,38,NULL,NULL),(904,902,38,NULL,NULL),(905,903,38,NULL,NULL),(906,904,38,NULL,NULL),(907,905,38,NULL,NULL),(908,906,38,NULL,NULL),(909,907,38,NULL,NULL),(910,908,38,NULL,NULL),(911,909,38,NULL,NULL),(912,910,38,NULL,NULL),(913,911,38,NULL,NULL),(914,912,39,NULL,NULL),(915,913,39,NULL,NULL),(916,914,39,NULL,NULL),(917,915,39,NULL,NULL),(918,916,39,NULL,NULL),(919,917,39,NULL,NULL),(920,918,39,NULL,NULL),(921,919,39,NULL,NULL),(922,920,39,NULL,NULL),(923,921,39,NULL,NULL),(924,922,39,NULL,NULL),(925,923,39,NULL,NULL),(926,924,39,NULL,NULL),(927,925,39,NULL,NULL),(928,926,39,NULL,NULL),(929,927,39,NULL,NULL),(930,928,39,NULL,NULL),(931,929,39,NULL,NULL),(932,930,39,NULL,NULL),(933,931,39,NULL,NULL),(934,932,39,NULL,NULL),(935,933,39,NULL,NULL),(936,934,39,NULL,NULL),(937,935,39,NULL,NULL),(938,936,39,NULL,NULL),(939,937,40,NULL,NULL),(940,938,40,NULL,NULL),(941,939,40,NULL,NULL),(942,940,40,NULL,NULL),(943,941,40,NULL,NULL),(944,942,40,NULL,NULL),(945,943,40,NULL,NULL),(946,944,40,NULL,NULL),(947,945,40,NULL,NULL),(948,946,40,NULL,NULL),(949,947,40,NULL,NULL),(950,948,40,NULL,NULL),(952,950,40,NULL,NULL),(953,951,40,NULL,NULL),(954,952,40,NULL,NULL),(955,953,40,NULL,NULL),(956,954,40,NULL,NULL),(957,955,40,NULL,NULL),(958,956,40,NULL,NULL),(959,957,40,NULL,NULL),(960,958,40,NULL,NULL),(961,959,40,NULL,NULL),(962,960,40,NULL,NULL),(963,961,40,NULL,NULL),(964,962,40,NULL,NULL),(965,963,41,'2015-06-17 00:00:00',NULL),(966,964,42,NULL,NULL),(967,965,42,NULL,NULL),(968,966,42,NULL,NULL),(969,967,42,NULL,NULL),(970,968,42,NULL,NULL),(971,969,42,NULL,NULL),(972,970,42,NULL,NULL),(973,971,42,NULL,NULL),(974,972,42,NULL,NULL),(975,973,42,NULL,NULL),(976,974,42,NULL,NULL),(977,975,42,NULL,NULL),(978,976,42,NULL,NULL),(979,977,42,NULL,NULL),(980,978,42,NULL,NULL),(981,979,42,NULL,NULL),(982,980,42,NULL,NULL),(983,981,42,NULL,NULL),(984,982,42,NULL,NULL),(985,983,42,NULL,NULL),(986,343,1,'2015-06-18 00:00:00','2015-06-29 00:00:00'),(987,692,1,'2015-06-19 00:00:00','2015-06-21 00:00:00'),(988,984,1,'2015-06-19 00:00:00','2015-06-25 00:00:00'),(989,985,1,'2015-06-19 00:00:00','2015-06-22 00:00:00'),(990,986,43,NULL,NULL),(991,987,43,NULL,NULL),(992,988,43,NULL,NULL),(993,989,43,NULL,NULL),(994,990,43,NULL,NULL),(995,991,43,NULL,NULL),(996,992,43,NULL,NULL),(997,993,43,NULL,NULL),(998,994,43,NULL,NULL),(999,995,43,NULL,NULL),(1000,996,43,NULL,NULL),(1001,997,43,NULL,NULL),(1002,998,43,NULL,NULL),(1003,999,43,NULL,NULL),(1004,1000,43,NULL,NULL),(1005,1001,43,NULL,NULL),(1006,1002,43,NULL,NULL),(1007,1003,43,NULL,NULL),(1008,1004,43,NULL,NULL),(1009,1005,43,NULL,NULL),(1010,1006,1,'2015-06-20 00:00:00','2015-07-04 00:00:00'),(1011,1007,44,NULL,NULL),(1012,1008,44,NULL,NULL),(1013,1009,44,NULL,NULL),(1014,1010,44,NULL,NULL),(1015,1011,44,NULL,NULL),(1016,1012,44,NULL,NULL),(1017,1013,44,NULL,NULL),(1018,1014,44,NULL,NULL),(1019,1015,44,NULL,NULL),(1020,1016,44,NULL,NULL),(1021,1017,44,NULL,NULL),(1022,1018,44,NULL,NULL),(1023,1019,44,NULL,NULL),(1024,1020,44,NULL,NULL),(1025,1021,44,NULL,NULL),(1026,1022,1,'2015-06-23 00:00:00',NULL),(1027,1023,1,'2015-06-23 00:00:00','2015-06-25 00:00:00'),(1028,1024,45,NULL,NULL),(1029,1025,45,NULL,NULL),(1030,1026,45,NULL,NULL),(1031,1027,45,NULL,NULL),(1032,1028,45,NULL,NULL),(1033,1029,45,NULL,NULL),(1034,1030,45,NULL,NULL),(1035,1031,45,NULL,NULL),(1036,1032,45,NULL,NULL),(1037,1033,45,NULL,NULL),(1038,1034,45,NULL,NULL),(1039,1035,45,NULL,NULL),(1040,1036,45,NULL,NULL),(1041,1037,45,NULL,NULL),(1042,1038,45,NULL,NULL),(1043,1039,45,NULL,NULL),(1044,1040,45,NULL,NULL),(1045,1041,45,NULL,NULL),(1046,1042,45,NULL,NULL),(1047,1043,45,NULL,NULL),(1048,1044,1,'2015-06-25 00:00:00','2015-07-01 00:00:00'),(1049,1045,1,'2015-06-25 00:00:00','2015-06-27 00:00:00'),(1050,1046,46,NULL,NULL),(1051,1047,46,NULL,NULL),(1052,1048,46,NULL,NULL),(1053,1049,46,NULL,NULL),(1054,1050,46,NULL,NULL),(1055,1051,46,NULL,NULL),(1056,1052,46,NULL,NULL),(1057,1053,46,NULL,NULL),(1058,1054,46,NULL,NULL),(1059,1055,46,NULL,NULL),(1060,1056,47,NULL,NULL),(1061,1057,47,NULL,NULL),(1062,1058,47,NULL,NULL),(1063,1059,47,NULL,NULL),(1064,1060,47,NULL,NULL),(1065,1061,47,NULL,NULL),(1066,1062,47,NULL,NULL),(1067,1063,47,NULL,NULL),(1068,1064,47,NULL,NULL),(1069,1065,47,NULL,NULL),(1070,1066,47,NULL,NULL),(1071,1067,47,NULL,NULL),(1072,1068,47,NULL,NULL),(1073,1069,47,NULL,NULL),(1074,1070,47,NULL,NULL),(1075,1071,47,NULL,NULL),(1076,1072,47,NULL,NULL),(1077,1073,47,NULL,NULL),(1078,1074,47,NULL,NULL),(1079,1075,47,NULL,NULL),(1080,527,1,'2015-06-27 00:00:00','2015-06-29 00:00:00'),(1081,1076,1,'2015-06-27 00:00:00','2015-06-29 00:00:00'),(1082,1077,1,'2015-06-27 00:00:00','2015-06-29 00:00:00'),(1083,1078,48,NULL,NULL),(1084,1079,48,NULL,NULL),(1085,1080,48,NULL,NULL),(1086,1081,48,NULL,NULL),(1087,1082,48,NULL,NULL),(1088,1083,48,NULL,NULL),(1089,1084,48,NULL,NULL),(1090,1085,48,NULL,NULL),(1091,1086,48,NULL,NULL),(1092,1087,48,NULL,NULL),(1093,1088,48,NULL,NULL),(1094,1089,48,NULL,NULL),(1095,1090,48,NULL,NULL),(1096,1091,48,NULL,NULL),(1097,1092,48,NULL,NULL),(1098,1093,1,'2015-06-29 00:00:00','2015-07-01 00:00:00'),(1099,1094,1,'2015-06-29 00:00:00','2015-07-22 00:00:00'),(1100,1095,49,NULL,NULL),(1101,1096,49,NULL,NULL),(1102,1097,49,NULL,NULL),(1103,1098,49,NULL,NULL),(1104,1099,49,NULL,NULL),(1105,1100,49,NULL,NULL),(1106,1101,49,NULL,NULL),(1107,1102,49,NULL,NULL),(1108,1103,49,NULL,NULL),(1109,1104,49,NULL,NULL),(1110,1105,49,NULL,NULL),(1111,1106,49,NULL,NULL),(1112,1107,49,NULL,NULL),(1113,1108,49,NULL,NULL),(1114,1109,49,NULL,NULL),(1115,343,1,'2015-07-01 00:00:00','2015-08-05 00:00:00'),(1116,1110,50,NULL,NULL),(1117,1111,50,NULL,NULL),(1118,1112,50,NULL,NULL),(1119,1113,50,NULL,NULL),(1120,1114,50,NULL,NULL),(1121,1115,50,NULL,NULL),(1122,1116,50,NULL,NULL),(1123,1117,50,NULL,NULL),(1124,1118,50,NULL,NULL),(1125,1119,50,NULL,NULL),(1126,1120,50,NULL,NULL),(1127,1121,50,NULL,NULL),(1128,1122,50,NULL,NULL),(1129,1123,50,NULL,NULL),(1130,1124,50,NULL,NULL),(1131,1125,1,'2015-07-04 00:00:00',NULL),(1132,1126,1,'2015-07-04 00:00:00','2015-07-08 00:00:00'),(1133,1127,1,'2015-07-04 00:00:00','2015-07-06 00:00:00'),(1134,1128,1,'2015-07-04 00:00:00','2015-07-10 00:00:00'),(1135,1129,1,'2015-07-05 00:00:00','2015-07-06 00:00:00'),(1136,1130,1,'2015-07-04 00:00:00','2015-07-13 00:00:00'),(1137,1131,1,'2015-07-04 00:00:00',NULL),(1138,1132,51,NULL,NULL),(1139,1133,51,NULL,NULL),(1140,1134,51,NULL,NULL),(1141,1135,51,NULL,NULL),(1142,1136,51,NULL,NULL),(1143,1137,51,NULL,NULL),(1144,1138,51,NULL,NULL),(1145,1139,51,NULL,NULL),(1146,1140,51,NULL,NULL),(1147,1141,51,NULL,NULL),(1148,1142,51,NULL,NULL),(1149,1143,51,NULL,NULL),(1150,1144,51,NULL,NULL),(1151,1145,51,NULL,NULL),(1152,1146,51,NULL,NULL),(1153,1147,51,NULL,NULL),(1154,1148,51,NULL,NULL),(1155,1149,51,NULL,NULL),(1156,1150,51,NULL,NULL),(1157,1151,51,NULL,NULL),(1158,1152,52,NULL,NULL),(1159,1153,52,NULL,NULL),(1160,1154,52,NULL,NULL),(1161,1155,52,NULL,NULL),(1162,1156,52,NULL,NULL),(1163,1157,52,NULL,NULL),(1164,1158,52,NULL,NULL),(1165,1159,52,NULL,NULL),(1166,1160,52,NULL,NULL),(1167,1161,52,NULL,NULL),(1168,1162,52,NULL,NULL),(1169,1163,52,NULL,NULL),(1170,1164,52,NULL,NULL),(1171,1165,52,NULL,NULL),(1172,1166,52,NULL,NULL),(1173,1167,52,NULL,NULL),(1174,1168,52,NULL,NULL),(1175,1169,52,NULL,NULL),(1176,1170,52,NULL,NULL),(1177,1171,52,NULL,NULL),(1178,1172,1,'2015-07-08 00:00:00',NULL),(1179,23,1,'2015-07-08 00:00:00','2015-07-12 00:00:00'),(1180,1173,1,'2015-07-08 00:00:00','2015-07-30 00:00:00'),(1181,1174,1,'2015-07-08 00:00:00','2015-07-13 00:00:00'),(1182,29,1,'2015-07-09 00:00:00','2015-07-18 00:00:00'),(1183,1175,53,NULL,NULL),(1184,1176,53,NULL,NULL),(1185,1177,53,NULL,NULL),(1186,1178,53,NULL,NULL),(1187,1179,53,NULL,NULL),(1188,1180,53,NULL,NULL),(1189,1181,53,NULL,NULL),(1190,1182,53,NULL,NULL),(1191,1183,53,NULL,NULL),(1192,1184,53,NULL,NULL),(1193,1185,53,NULL,NULL),(1194,1186,53,NULL,NULL),(1195,1187,53,NULL,NULL),(1196,1188,53,NULL,NULL),(1197,1189,53,NULL,NULL),(1198,1190,53,NULL,NULL),(1199,1191,53,NULL,NULL),(1200,1192,53,NULL,NULL),(1201,1193,53,NULL,NULL),(1202,1194,53,NULL,NULL),(1203,1195,54,NULL,NULL),(1204,1196,54,NULL,NULL),(1205,1197,54,NULL,NULL),(1206,1198,54,NULL,NULL),(1207,1199,54,NULL,NULL),(1208,1200,54,NULL,NULL),(1209,1201,54,NULL,NULL),(1210,1202,54,NULL,NULL),(1211,1203,54,NULL,NULL),(1212,1204,54,NULL,NULL),(1213,1205,54,NULL,NULL),(1214,1206,54,NULL,NULL),(1215,1207,54,NULL,NULL),(1216,1208,54,NULL,NULL),(1217,1209,54,NULL,NULL),(1218,1210,54,NULL,NULL),(1219,1211,54,NULL,NULL),(1220,1212,54,NULL,NULL),(1221,1213,54,NULL,NULL),(1222,1214,54,NULL,NULL),(1223,1215,1,'2015-07-12 00:00:00','2015-07-26 00:00:00'),(1224,1216,55,NULL,NULL),(1225,1217,55,NULL,NULL),(1226,1218,55,NULL,NULL),(1227,1219,55,NULL,NULL),(1228,1220,55,NULL,NULL),(1229,1221,55,NULL,NULL),(1230,1222,55,NULL,NULL),(1231,1223,55,NULL,NULL),(1232,1224,55,NULL,NULL),(1233,1225,55,NULL,NULL),(1234,1226,55,NULL,NULL),(1235,1227,55,NULL,NULL),(1236,1228,55,NULL,NULL),(1237,1229,55,NULL,NULL),(1238,1230,55,NULL,NULL),(1239,1231,55,NULL,NULL),(1240,1232,55,NULL,NULL),(1241,1233,55,NULL,NULL),(1242,1234,55,NULL,NULL),(1243,1235,55,NULL,NULL),(1244,1236,1,'2015-07-14 00:00:00',NULL),(1245,1237,1,'2015-07-13 00:00:00','2015-07-24 00:00:00'),(1246,1238,1,'2015-07-15 00:00:00','2015-07-24 00:00:00'),(1247,1239,1,'2015-07-15 00:00:00','2015-07-15 00:00:00'),(1248,1240,1,'2015-07-15 00:00:00','2015-07-18 00:00:00'),(1249,1241,1,'2015-07-15 00:00:00',NULL),(1250,1242,1,'2015-07-15 00:00:00',NULL),(1251,1243,56,NULL,NULL),(1252,1244,56,NULL,NULL),(1253,1245,56,NULL,NULL),(1254,1246,56,NULL,NULL),(1255,1247,56,NULL,NULL),(1256,1248,56,NULL,NULL),(1257,1249,56,NULL,NULL),(1258,1250,56,NULL,NULL),(1259,1251,56,NULL,NULL),(1260,1252,56,NULL,NULL),(1261,1253,56,NULL,NULL),(1262,1254,56,NULL,NULL),(1263,1255,56,NULL,NULL),(1264,1256,56,NULL,NULL),(1265,1257,56,NULL,NULL),(1266,1258,56,NULL,NULL),(1267,1259,56,NULL,NULL),(1268,1260,56,NULL,NULL),(1269,1261,56,NULL,NULL),(1270,1262,56,NULL,NULL),(1271,1263,56,NULL,NULL),(1272,1264,56,NULL,NULL),(1273,1265,56,NULL,NULL),(1274,1266,56,NULL,NULL),(1275,1267,56,NULL,NULL),(1276,1268,1,'2015-07-17 00:00:00','2015-07-20 00:00:00'),(1277,1269,1,'2015-07-18 00:00:00','2015-07-20 00:00:00'),(1278,1270,57,NULL,NULL),(1279,1271,57,NULL,NULL),(1280,1272,57,NULL,NULL),(1281,1273,57,NULL,NULL),(1282,1274,57,NULL,NULL),(1283,1275,57,NULL,NULL),(1284,1276,57,NULL,NULL),(1285,1277,57,NULL,NULL),(1286,1278,57,NULL,NULL),(1287,1279,57,NULL,NULL),(1288,1280,57,NULL,NULL),(1289,1281,57,NULL,NULL),(1290,1282,57,NULL,NULL),(1291,1283,57,NULL,NULL),(1292,1284,57,NULL,NULL),(1293,1285,57,NULL,NULL),(1294,1286,57,NULL,NULL),(1295,1287,57,NULL,NULL),(1296,1288,57,NULL,NULL),(1297,1289,57,NULL,NULL),(1298,1290,57,NULL,NULL),(1299,1291,57,NULL,NULL),(1300,1292,57,NULL,NULL),(1301,1293,57,NULL,NULL),(1302,1294,57,NULL,NULL),(1303,1295,58,NULL,NULL),(1304,1296,58,NULL,NULL),(1305,1297,58,NULL,NULL),(1306,1298,58,NULL,NULL),(1307,1299,58,NULL,NULL),(1308,1300,58,NULL,NULL),(1309,1301,58,NULL,NULL),(1310,1302,58,NULL,NULL),(1311,1303,58,NULL,NULL),(1312,1304,58,NULL,NULL),(1313,1305,58,NULL,NULL),(1314,1306,58,NULL,NULL),(1315,1307,58,NULL,NULL),(1316,1308,58,NULL,NULL),(1317,1309,58,NULL,NULL),(1318,1310,58,NULL,NULL),(1319,1311,58,NULL,NULL),(1320,1312,58,NULL,NULL),(1321,1313,58,NULL,NULL),(1322,1314,58,NULL,NULL),(1323,1315,58,NULL,NULL),(1324,1316,58,NULL,NULL),(1325,1317,58,NULL,NULL),(1326,1318,58,NULL,NULL),(1327,1319,58,NULL,NULL),(1328,229,1,'2015-07-20 00:00:00','2015-07-30 00:00:00'),(1329,1320,1,'2015-07-19 00:00:00','2015-07-24 00:00:00'),(1330,1321,59,NULL,NULL),(1331,1322,59,NULL,NULL),(1332,1323,59,NULL,NULL),(1333,1324,59,NULL,NULL),(1334,1325,59,NULL,NULL),(1335,1326,59,NULL,NULL),(1336,1327,59,NULL,NULL),(1337,1328,59,NULL,NULL),(1338,1329,59,NULL,NULL),(1339,1330,59,NULL,NULL),(1340,1331,59,NULL,NULL),(1341,1332,59,NULL,NULL),(1342,1333,59,NULL,NULL),(1343,1334,59,NULL,NULL),(1344,1335,59,NULL,NULL),(1345,1336,59,NULL,NULL),(1346,1337,59,NULL,NULL),(1347,1338,59,NULL,NULL),(1348,1339,59,NULL,NULL),(1349,1340,59,NULL,NULL),(1350,1341,59,NULL,NULL),(1351,1342,59,NULL,NULL),(1352,1343,59,NULL,NULL),(1353,1344,59,NULL,NULL),(1354,1345,59,NULL,NULL),(1355,1346,1,'2015-07-22 00:00:00','2015-07-30 00:00:00'),(1356,1347,60,NULL,NULL),(1357,1348,60,NULL,NULL),(1358,1349,60,NULL,NULL),(1359,1350,60,NULL,NULL),(1360,1351,60,NULL,NULL),(1361,1352,60,NULL,NULL),(1362,1353,60,NULL,NULL),(1363,1354,60,NULL,NULL),(1364,1355,60,NULL,NULL),(1365,1356,60,NULL,NULL),(1366,1357,60,NULL,NULL),(1367,1358,60,NULL,NULL),(1368,1359,60,NULL,NULL),(1369,1360,60,NULL,NULL),(1370,1361,60,NULL,NULL),(1371,1362,60,NULL,NULL),(1372,1363,60,NULL,NULL),(1373,1364,60,NULL,NULL),(1374,1365,60,NULL,NULL),(1375,1366,60,NULL,NULL),(1376,1367,60,NULL,NULL),(1377,1368,60,NULL,NULL),(1378,1369,60,NULL,NULL),(1379,1370,60,NULL,NULL),(1380,1371,60,NULL,NULL),(1381,1372,1,'2015-07-25 00:00:00',NULL),(1382,1373,61,NULL,NULL),(1383,1374,61,NULL,NULL),(1384,1375,61,NULL,NULL),(1385,1376,61,NULL,NULL),(1386,1377,61,NULL,NULL),(1387,1378,61,NULL,NULL),(1388,1379,61,NULL,NULL),(1389,1380,61,NULL,NULL),(1390,1381,61,NULL,NULL),(1391,1382,61,NULL,NULL),(1392,1383,61,NULL,NULL),(1393,1384,61,NULL,NULL),(1394,1385,61,NULL,NULL),(1395,1386,61,NULL,NULL),(1396,1387,61,NULL,NULL),(1397,1388,61,NULL,NULL),(1398,1389,61,NULL,NULL),(1399,1390,61,NULL,NULL),(1400,1391,61,NULL,NULL),(1401,1392,61,NULL,NULL),(1402,1393,61,NULL,NULL),(1403,1394,61,NULL,NULL),(1404,1395,61,NULL,NULL),(1405,1396,61,NULL,NULL),(1406,1397,61,NULL,NULL),(1407,1398,62,NULL,NULL),(1408,1399,62,NULL,NULL),(1409,1400,62,NULL,NULL),(1410,1401,62,NULL,NULL),(1411,1402,62,NULL,NULL),(1412,1403,62,NULL,NULL),(1413,1404,62,NULL,NULL),(1414,1405,62,NULL,NULL),(1415,1406,62,NULL,NULL),(1416,1407,62,NULL,NULL),(1417,1408,62,NULL,NULL),(1418,1409,62,NULL,NULL),(1419,1410,62,NULL,NULL),(1420,1411,62,NULL,NULL),(1421,1412,62,NULL,NULL),(1422,1413,62,NULL,NULL),(1423,1414,62,NULL,NULL),(1424,1415,62,NULL,NULL),(1425,1416,62,NULL,NULL),(1426,1417,62,NULL,NULL),(1427,1418,62,NULL,NULL),(1428,1419,62,NULL,NULL),(1429,1420,62,NULL,NULL),(1430,1421,62,NULL,NULL),(1431,1422,62,NULL,NULL),(1432,1423,62,NULL,NULL),(1433,1424,62,NULL,NULL),(1434,1425,62,NULL,NULL),(1435,1426,62,NULL,NULL),(1436,1427,62,NULL,NULL),(1437,1428,1,'2015-07-30 00:00:00',NULL),(1438,1429,1,'2015-07-30 00:00:00','2015-08-01 00:00:00'),(1439,1430,63,NULL,NULL),(1440,1431,63,NULL,NULL),(1441,1432,63,NULL,NULL),(1442,1433,63,NULL,NULL),(1443,1434,63,NULL,NULL),(1444,1435,63,NULL,NULL),(1445,1436,63,NULL,NULL),(1446,1437,63,NULL,NULL),(1447,1438,63,NULL,NULL),(1448,1439,63,NULL,NULL),(1449,1440,63,NULL,NULL),(1450,1441,63,NULL,NULL),(1451,1442,63,NULL,NULL),(1452,1443,63,NULL,NULL),(1453,1444,63,NULL,NULL),(1454,1445,64,NULL,NULL),(1455,1446,64,NULL,NULL),(1456,1447,64,NULL,NULL),(1457,1448,64,NULL,NULL),(1458,1449,64,NULL,NULL),(1459,1450,64,NULL,NULL),(1460,1451,64,NULL,NULL),(1461,1452,64,NULL,NULL),(1462,1453,64,NULL,NULL),(1463,1454,64,NULL,NULL),(1464,1455,64,NULL,NULL),(1465,1456,64,NULL,NULL),(1466,1457,64,NULL,NULL),(1467,1458,64,NULL,NULL),(1468,1459,64,NULL,NULL),(1469,1460,64,NULL,NULL),(1470,1461,64,NULL,NULL),(1471,1462,64,NULL,NULL),(1472,1463,64,NULL,NULL),(1473,1464,64,NULL,NULL),(1474,1465,1,'2015-08-01 00:00:00',NULL),(1475,1466,1,'2015-08-01 00:00:00',NULL),(1476,1467,1,'2015-08-01 00:00:00',NULL),(1477,1468,1,'2015-08-01 00:00:00',NULL),(1478,1469,1,'2015-08-01 00:00:00',NULL),(1479,1470,1,'2015-08-01 00:00:00',NULL),(1480,1471,1,'2015-08-01 00:00:00',NULL),(1481,1472,1,'2015-08-01 00:00:00',NULL),(1482,1473,1,'2015-08-01 00:00:00',NULL),(1483,1474,1,'2015-08-01 00:00:00',NULL),(1484,1475,1,'2015-08-01 00:00:00',NULL),(1485,1536,67,NULL,NULL),(1486,1537,67,NULL,NULL),(1487,1538,67,NULL,NULL),(1488,1539,67,NULL,NULL),(1489,1540,67,NULL,NULL),(1490,1541,67,NULL,NULL),(1491,1542,67,NULL,NULL),(1492,1543,67,NULL,NULL),(1493,1544,67,NULL,NULL),(1494,1545,67,NULL,NULL),(1495,1546,67,NULL,NULL),(1496,1547,67,NULL,NULL),(1497,1548,67,NULL,NULL),(1498,1549,67,NULL,NULL),(1499,1550,67,NULL,NULL),(1500,1551,67,NULL,NULL),(1501,1552,67,NULL,NULL),(1502,1553,67,NULL,NULL),(1503,1554,67,NULL,NULL),(1504,1555,67,NULL,NULL),(1505,1556,67,NULL,NULL),(1506,1557,67,NULL,NULL),(1507,1558,67,NULL,NULL),(1508,1559,67,NULL,NULL),(1509,1560,67,NULL,NULL),(1510,1561,67,NULL,NULL),(1511,1562,67,NULL,NULL),(1512,1563,67,NULL,NULL),(1513,1564,67,NULL,NULL),(1514,1565,67,NULL,NULL),(1515,19,1,'2015-08-03 00:00:00','2015-08-16 00:00:00'),(1516,1596,68,NULL,NULL),(1517,1597,68,NULL,NULL),(1518,1598,68,NULL,NULL),(1519,1599,68,NULL,NULL),(1520,1600,68,NULL,NULL),(1521,1601,68,NULL,NULL),(1522,1602,68,NULL,NULL),(1523,1603,68,NULL,NULL),(1524,1604,68,NULL,NULL),(1525,1605,68,NULL,NULL),(1526,1606,68,NULL,NULL),(1527,1607,68,NULL,NULL),(1528,1608,68,NULL,NULL),(1529,1609,68,NULL,NULL),(1530,1610,68,NULL,NULL),(1531,1611,68,NULL,NULL),(1532,1612,68,NULL,NULL),(1533,1613,68,NULL,NULL),(1534,1614,68,NULL,NULL),(1535,1615,68,NULL,NULL),(1536,1616,68,NULL,NULL),(1537,1617,68,NULL,NULL),(1538,1618,68,NULL,NULL),(1539,1619,68,NULL,NULL),(1540,1620,68,NULL,NULL),(1541,1621,68,NULL,NULL),(1542,1622,68,NULL,NULL),(1543,1623,68,NULL,NULL),(1544,1624,68,NULL,NULL),(1545,1625,68,NULL,NULL),(1546,1626,1,'2015-08-05 00:00:00',NULL),(1547,1627,69,NULL,NULL),(1548,1628,69,NULL,NULL),(1549,1629,69,NULL,NULL),(1550,1630,69,NULL,NULL),(1551,1631,69,NULL,NULL),(1552,1632,69,NULL,NULL),(1553,1633,69,NULL,NULL),(1554,1634,69,NULL,NULL),(1555,1635,69,NULL,NULL),(1556,1636,69,NULL,NULL),(1557,1637,69,NULL,NULL),(1558,1638,69,NULL,NULL),(1559,1639,69,NULL,NULL),(1560,1640,69,NULL,NULL),(1561,1641,69,NULL,NULL),(1562,1642,69,NULL,NULL),(1563,1643,69,NULL,NULL),(1564,1644,69,NULL,NULL),(1565,1645,69,NULL,NULL),(1566,1646,69,NULL,NULL),(1567,1647,69,NULL,NULL),(1568,1648,69,NULL,NULL),(1569,1649,69,NULL,NULL),(1570,1650,69,NULL,NULL),(1571,1651,69,NULL,NULL),(1572,1652,69,NULL,NULL),(1573,1653,69,NULL,NULL),(1574,1654,69,NULL,NULL),(1575,1655,69,NULL,NULL),(1576,1656,69,NULL,NULL),(1577,1657,1,'2015-08-07 00:00:00',NULL),(1578,1658,1,'2015-08-07 00:00:00',NULL),(1579,1659,1,'2015-08-07 00:00:00',NULL),(1580,1660,1,'2015-08-07 00:00:00',NULL),(1581,1661,70,NULL,NULL),(1582,1662,70,NULL,NULL),(1583,1663,70,NULL,NULL),(1584,1664,70,NULL,NULL),(1585,1665,70,NULL,NULL),(1586,1666,70,NULL,NULL),(1587,1667,70,NULL,NULL),(1588,1668,70,NULL,NULL),(1589,1669,70,NULL,NULL),(1590,1670,70,NULL,NULL),(1591,1671,70,NULL,NULL),(1592,1672,70,NULL,NULL),(1593,1673,70,NULL,NULL),(1594,1674,70,NULL,NULL),(1595,1675,70,NULL,NULL),(1596,1676,70,NULL,NULL),(1597,1677,70,NULL,NULL),(1598,1678,70,NULL,NULL),(1599,1679,70,NULL,NULL),(1600,1680,70,NULL,NULL),(1601,1681,70,NULL,NULL),(1602,1682,70,NULL,NULL),(1603,1683,70,NULL,NULL),(1604,1684,70,NULL,NULL),(1605,1685,70,NULL,NULL),(1606,1686,70,NULL,NULL),(1607,1687,70,NULL,NULL),(1608,1688,70,NULL,NULL),(1609,1689,70,NULL,NULL),(1610,1690,70,NULL,NULL),(1611,7,1,'2015-08-07 00:00:00','2015-08-11 00:00:00'),(1612,1691,1,'2015-08-10 00:00:00','2015-08-11 00:00:00'),(1614,1693,1,'2015-08-10 00:00:00','2015-08-11 00:00:00'),(1615,1694,71,NULL,NULL),(1616,1695,71,NULL,NULL),(1617,1696,71,NULL,NULL),(1618,1697,71,NULL,NULL),(1619,1698,71,NULL,NULL),(1620,1699,71,NULL,NULL),(1621,1700,71,NULL,NULL),(1622,1701,71,NULL,NULL),(1623,1702,71,NULL,NULL),(1624,1703,71,NULL,NULL),(1625,1704,71,NULL,NULL),(1626,1705,71,NULL,NULL),(1627,1706,71,NULL,NULL),(1628,1707,71,NULL,NULL),(1629,1708,71,NULL,NULL),(1630,1709,71,NULL,NULL),(1631,1710,71,NULL,NULL),(1632,1711,71,NULL,NULL),(1633,1712,71,NULL,NULL),(1634,1713,71,NULL,NULL),(1635,1714,71,NULL,NULL),(1636,1715,71,NULL,NULL),(1637,1716,71,NULL,NULL),(1638,1717,71,NULL,NULL),(1639,1718,71,NULL,NULL),(1640,1719,71,NULL,NULL),(1641,1720,71,NULL,NULL),(1642,1721,71,NULL,NULL),(1643,1722,71,NULL,NULL),(1644,1723,71,NULL,NULL),(1645,1724,71,NULL,NULL),(1646,1725,71,NULL,NULL),(1647,1726,71,NULL,NULL),(1648,1727,71,NULL,NULL),(1649,1728,71,NULL,NULL),(1650,1729,1,'2015-08-11 00:00:00',NULL),(1651,1730,72,NULL,NULL),(1652,1731,72,NULL,NULL),(1653,1732,72,NULL,NULL),(1654,1733,72,NULL,NULL),(1655,1734,72,NULL,NULL),(1656,1735,72,NULL,NULL),(1657,1736,72,NULL,NULL),(1658,1737,72,NULL,NULL),(1659,1738,72,NULL,NULL),(1660,1739,72,NULL,NULL),(1661,1740,72,NULL,NULL),(1662,1741,72,NULL,NULL),(1663,1742,72,NULL,NULL),(1664,1743,72,NULL,NULL),(1665,1744,72,NULL,NULL),(1666,1745,72,NULL,NULL),(1667,1746,72,NULL,NULL),(1668,1747,72,NULL,NULL),(1669,1748,72,NULL,NULL),(1670,1749,72,NULL,NULL),(1671,1750,72,NULL,NULL),(1672,1751,72,NULL,NULL),(1673,1752,72,NULL,NULL),(1674,1753,72,NULL,NULL),(1675,1754,72,NULL,NULL),(1676,1755,72,NULL,NULL),(1677,1756,72,NULL,NULL),(1678,1757,72,NULL,NULL),(1679,1758,72,NULL,NULL),(1680,1759,72,NULL,NULL),(1681,1760,72,NULL,NULL),(1682,1761,72,NULL,NULL),(1683,1762,72,NULL,NULL),(1684,1763,72,NULL,NULL),(1685,1764,72,NULL,NULL),(1686,1765,1,'2015-08-13 00:00:00',NULL),(1687,1766,1,'2015-08-15 00:00:00',NULL),(1688,1767,73,NULL,NULL),(1689,1768,73,NULL,NULL),(1690,1769,73,NULL,NULL),(1691,1770,73,NULL,NULL),(1692,1771,73,NULL,NULL),(1693,1772,73,NULL,NULL),(1694,1773,73,NULL,NULL),(1695,1774,73,NULL,NULL),(1696,1775,73,NULL,NULL),(1697,1776,73,NULL,NULL),(1698,1777,73,NULL,NULL),(1699,1778,73,NULL,NULL),(1700,1779,73,NULL,NULL),(1701,1780,73,NULL,NULL),(1702,1781,73,NULL,NULL),(1703,1782,73,NULL,NULL),(1704,1783,73,NULL,NULL),(1705,1784,73,NULL,NULL),(1706,1785,73,NULL,NULL),(1707,1786,73,NULL,NULL),(1708,1787,73,NULL,NULL),(1709,1788,73,NULL,NULL),(1710,1789,73,NULL,NULL),(1711,1790,73,NULL,NULL),(1712,1791,73,NULL,NULL),(1713,1792,1,'2015-08-17 00:00:00',NULL),(1714,1793,74,NULL,NULL),(1715,1794,74,NULL,NULL),(1716,1795,74,NULL,NULL),(1717,1796,74,NULL,NULL),(1718,1797,74,NULL,NULL),(1719,1798,74,NULL,NULL),(1720,1799,74,NULL,NULL),(1721,1800,74,NULL,NULL),(1722,1801,74,NULL,NULL),(1723,1802,74,NULL,NULL),(1724,1803,74,NULL,NULL),(1725,1804,74,NULL,NULL),(1726,1805,74,NULL,NULL),(1727,1806,74,NULL,NULL),(1728,1807,74,NULL,NULL),(1729,1808,74,NULL,NULL),(1730,1809,74,NULL,NULL),(1731,1810,74,NULL,NULL),(1732,1811,74,NULL,NULL),(1733,1812,74,NULL,NULL),(1734,1813,74,NULL,NULL),(1735,1814,74,NULL,NULL),(1736,1815,74,NULL,NULL),(1737,1816,74,NULL,NULL),(1738,1817,74,NULL,NULL),(1739,1818,75,NULL,NULL),(1740,1819,75,NULL,NULL),(1741,1820,75,NULL,NULL),(1742,1821,75,NULL,NULL),(1743,1822,75,NULL,NULL),(1744,1823,75,NULL,NULL),(1745,1824,75,NULL,NULL),(1746,1825,75,NULL,NULL),(1747,1826,75,NULL,NULL),(1748,1827,75,NULL,NULL),(1749,1828,75,NULL,NULL),(1750,1829,75,NULL,NULL),(1751,1830,75,NULL,NULL),(1752,1831,75,NULL,NULL),(1753,1832,75,NULL,NULL),(1754,1833,75,NULL,NULL),(1755,1834,75,NULL,NULL),(1756,1835,75,NULL,NULL),(1757,1836,75,NULL,NULL),(1758,1837,75,NULL,NULL),(1759,1838,75,NULL,NULL),(1760,1839,75,NULL,NULL),(1761,1840,75,NULL,NULL),(1762,1841,75,NULL,NULL),(1763,1842,75,NULL,NULL),(1764,4,1,'2015-08-19 00:00:00',NULL),(1765,1843,76,NULL,NULL),(1766,1844,76,NULL,NULL),(1767,1845,76,NULL,NULL),(1768,1846,76,NULL,NULL),(1769,1847,76,NULL,NULL),(1770,1848,76,NULL,NULL),(1771,1849,76,NULL,NULL),(1772,1850,76,NULL,NULL),(1773,1851,76,NULL,NULL),(1774,1852,76,NULL,NULL),(1775,1853,76,NULL,NULL),(1776,1854,76,NULL,NULL),(1777,1855,76,NULL,NULL),(1778,1856,76,NULL,NULL),(1779,1857,76,NULL,NULL),(1780,1858,76,NULL,NULL),(1781,1859,76,NULL,NULL),(1782,1860,76,NULL,NULL),(1783,1861,76,NULL,NULL),(1784,1862,76,NULL,NULL),(1785,1863,76,NULL,NULL),(1786,1864,76,NULL,NULL),(1787,1865,76,NULL,NULL),(1788,1866,76,NULL,NULL),(1789,1867,76,NULL,NULL),(1790,1868,77,NULL,NULL),(1791,1869,77,NULL,NULL),(1792,1870,77,NULL,NULL),(1793,1871,77,NULL,NULL),(1794,1872,77,NULL,NULL),(1795,1873,77,NULL,NULL),(1796,1874,77,NULL,NULL),(1797,1875,77,NULL,NULL),(1798,1876,77,NULL,NULL),(1799,1877,77,NULL,NULL),(1800,1878,77,NULL,NULL),(1801,1879,77,NULL,NULL),(1802,1880,77,NULL,NULL),(1803,1881,77,NULL,NULL),(1804,1882,77,NULL,NULL),(1805,1883,77,NULL,NULL),(1806,1884,77,NULL,NULL),(1807,1885,77,NULL,NULL),(1808,1886,77,NULL,NULL),(1809,1887,77,NULL,NULL),(1810,1888,77,NULL,NULL),(1811,1889,77,NULL,NULL),(1812,1890,77,NULL,NULL),(1813,1891,77,NULL,NULL),(1814,1892,77,NULL,NULL);
/*!40000 ALTER TABLE `Membership` ENABLE KEYS */;
UNLOCK TABLES;



LOCK TABLES `Clan` WRITE;
/*!40000 ALTER TABLE `Clan` DISABLE KEYS */;
INSERT INTO `Clan` VALUES (1,'#2V99GJ2U','Red Onslaught'),(2,'#YYJLQ9Q','Normannere'),(3,'#','R.B.N.'),(4,'#R9GR2RR','Keong Mas'),(5,'#298QUCC8','Polska PRO'),(11,'#LC2CLJY','EGYPT ARMY III'),(12,'#2CPGLYUP','Dark Obsidian'),(13,'#2ULUCL9R','The Black Lodge'),(14,'#JJUJQC','Hong Kong @ 2'),(15,'#2RRU8P9V','Ira de Odin'),(16,'#9QQ9C80J','Armored Titans'),(17,'#99VLOY9R','Reddit Rebels'),(18,'#20C9C8L8','Knights Templar'),(19,'#GGUC809','Vinaland'),(20,'#29PP8JY','Jaguar soldiers'),(21,'#2QJU88L0','Asian Clan #2QJU88L0'),(22,'#90VPYJVJ','Asian Clan #90VPYJVJ'),(23,'#2C990Y82','Leadline'),(24,'#2PURLJRV','UKRAINE 1'),(25,'#2LU8Y8PG','Ruth 66'),(26,'#9YC2VP98','Asian Clan #9YC2VP98'),(27,'#8C0J8LU2','Olympus Kings'),(28,'#8UCLP8CY','300'),(29,'#89RYY808','Neo IndoWars'),(30,'#2Q8U2QPQ','Asian Clan #2Q8U2QPQ'),(31,'#8PY9Q9YR','Web Rage War'),(32,'#2JGQJVJG','50 Rising'),(33,'#229YVR2C','FilipinoB@dass2'),(34,'#208JUL0Q','AE VIETNAM'),(35,'#2L9C890C','Asian Clan #2L9C890C'),(36,'#2LUPQUQ','Asian Clan #2LUPQUQ'),(37,'#2QPCJRC9','Asian Clan #2QPCJRC9'),(38,'#2R0LC2P8','VietNamPro'),(39,'#2JQJ8Y0U','ClashHeads'),(40,'#2VG9G0QY','Asian Clan #2VG9G0QY'),(41,'#00000000','Foo Fighters'),(42,'#L8RRPV0','THE IMMORTAL'),(43,'#8GJJL2CJ','Persian Wolf'),(44,'#L0LL9UV','sai gon chien'),(45,'#CPJU9LY','LP3 Chiron'),(46,'#G8LGGPL','Higgs Atom'),(47,'#9YRJQJ2L','Courage Empire'),(48,'#998LCL90','3TRQTR'),(49,'#92VR2URV','Quantum\'s Havoc'),(50,'#JYJ9YRQ','Donator Team'),(51,'#Y9JG28R','Asian Clan #Y9JG28R'),(52,'#PQLYJUGC','Asian Clan No.2 #PQLYJUGC'),(53,'#P8JY9PGQ','Asian Clan #P8JY9PGQ'),(54,'#9PC022QJ','Russian Dinasty'),(55,'#8QG898GG','Asian Clan #8QG898GG'),(56,'#2P0Q0V9C','KOR COC academy'),(57,'#8GUG8CYU','Asian Clan #8GUG8CYU'),(58,'#PL80PUC','Asian Clan #PL80PUC'),(59,'#C2V99PL','Czech - Titans'),(60,'#2Q9JGCJP','Asian Clan #2Q9JGCJP'),(61,'#2VYLQGRJ','Pigeonism'),(62,'#2Q222YYG','Centum Testudo'),(63,'#8U2JUP09','ocipala'),(64,'#2V9U2VPP','Clan India'),(67,'#22JVLVQC','R.B.N.'),(68,'#9802RC8V','Patanes PR Inc.'),(69,'#2CJUGUYU','Greek Anonymous'),(70,'#PJG8YR8','florida archers'),(71,'#2Y0U82GC','CaoS eSKiRoL'),(72,'#8JJGJCU9','ShangHai'),(73,'#2GL0Y8PJ','EMINENCIAS'),(74,'#2Q9J8CUP','GMTA'),(75,'#Y900YYR','Capito Caverna'),(76,'#89QR82GP','BLUE STAR'),(77,'#2CVUQ0V0','Chile CHAMP'),(78,'#9Q82QQJ8','Asian Clan #9Q82QQJ8');
/*!40000 ALTER TABLE `Clan` ENABLE KEYS */;
UNLOCK TABLES;

