Changeset 1146

Timestamp:

09/26/06 18:42:06 (2 years ago)

Author:

james

Message:

pagination on product pages

Files:

• peasantonline/app/controllers/catalog_controller.rb (modified) (4 diffs)
• peasantonline/app/views/catalog/_product_paginate.rhtml (added)
• peasantonline/app/views/catalog/browse_by_category.rhtml (modified) (1 diff)
• peasantonline/app/views/catalog/browse_by_designer.rhtml (modified) (1 diff)
• peasantonline/app/views/catalog/browse_by_gender.rhtml (modified) (1 diff)
• peasantonline/db/dump.sql (modified) (10 diffs)
• peasantonline/public/stylesheets/catalog.css (modified) (1 diff)

peasantonline/app/controllers/catalog_controller.rb

@@ -27 +27 @@
-          @categories = Category.find(:all, :order => "name")
-          @products = Product.find_tagged_with :all => @special
+          #@product_pages, @products = paginate(:products, :per_page => 9, :conditions => ["category = ?", @cat_obj.id])
-          @cart = find_cart
-        end
@@ -36 +37 @@
-
-                @des_obj    = Designer.find_by_name(@designer)
-
+
+
-                @designers  = Designer.find(:all, :order => "name")
-                @categories = Category.find(:all, :order => "name")
@@ -48 +50 @@
-
-                @cat_obj    = Category.find_by_name(@category)
-
+
+
-                @designers  = Designer.find(:all, :order => "name")
-                @categories = Category.find(:all, :order => "name")
@@ -62 +65 @@
-                end
-                
-
-
+
+
+
-                
-                @designers = Designer.find(:all, :order => "name")

peasantonline/app/views/catalog/browse_by_category.rhtml

@@ -2 +2 @@
-                <h1><%= @category %></h1>
-                <%= render(:partial => "product_list") %> 
-
+

peasantonline/app/views/catalog/browse_by_designer.rhtml

@@ -6 +6 @@
-                <h1> <%= @designer %> </h1>
-                <%= render(:partial => "product_list") %> 
-
+

peasantonline/app/views/catalog/browse_by_gender.rhtml

@@ -3 +3 @@
-                <h1> <%= @gender %> </h1>
-                <%= render(:partial => "product_list") %> 
+                <%= render(:partial => "product_paginate") %>

peasantonline/db/dump.sql

@@ -62 +62 @@
-/*!40000 ALTER TABLE `designers` DISABLE KEYS */;
-LOCK TABLES `designers` WRITE;
-DC','x','x',''),(8,'Rogan','x','x',''),(10,'Steven Alan','x','x',''),(11,'Troglodyte Homunculus','x','x',''),(12,'Obedient Sons','x','x',''),(13,'Habitual','x','x',''),(14,'Sharps','x','x',''),(16,'A.P.C.','art, production, creation','?',''),(17,'Brave Soldier','men\'s apothecary','Brave Soldier is specially formulated for those who demand the best. Because we believe that bravery takes many forms, we strive to serve not only the skin care needs of hard core sports enthusiasts like adventure racers, pro cyclists, rock climbers and \r\nx-gamers, but also the folks who blend a work week with a little rollerblading, jogging, or enjoying a ride along the bike path.\r\n',''),(18,'J Lindeberg','x','x',''),(19,'Rogues Gallery','x','x',''),(20,'mike & chris','x','x',''),(21,'stone island','x','x',''),(22,'s
+.D.C.','x','x',''),(8,'Rogan','x','x',''),(10,'Steven Alan','x','x',''),(11,'Troglodyte Homunculus','x','x',''),(12,'Obedient Sons','x','x',''),(13,'Habitual','x','x',''),(14,'Sharps','x','x',''),(16,'A.P.C.','art, production, creation','?',''),(17,'Brave Soldier','men\'s apothecary','Brave Soldier is specially formulated for those who demand the best. Because we believe that bravery takes many forms, we strive to serve not only the skin care needs of hard core sports enthusiasts like adventure racers, pro cyclists, rock climbers and \r\nx-gamers, but also the folks who blend a work week with a little rollerblading, jogging, or enjoying a ride along the bike path.\r\n',''),(18,'J Lindeberg','x','x',''),(19,'Rogues Gallery','x','x',''),(20,'Mike & Chris','x','x',''),(21,'Stone Island','x','x',''),(22,'S
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `designers` ENABLE KEYS */;
@@ -92 +92 @@
-/*!40000 ALTER TABLE `line_items` DISABLE KEYS */;
-LOCK TABLES `line_items` WRITE;
-,67,1,2,280,'31'),(2,67,1,1,140,'30'),(3,67,2,1,140,'31'),(4,67,3,1,140,'30'),(5,67,4,1,140,'30'),(6,67,5,1,140,'30'),(7,67,6,1,140,'30
+0,109,9,1,176,'M'),(11,85,9,1,179,'48
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `line_items` ENABLE KEYS */;
@@ -118 +118 @@
-  `first_name` varchar(255) default NULL,
-  `last_name` varchar(255) default NULL,
+  `shipping` float default NULL,
+  `country` varchar(255) default NULL,
-  PRIMARY KEY  (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@@ -128 +130 @@
-/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
-LOCK TABLES `orders` WRITE;
-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'23440 geneva','','','','','','j@mesv.org','','4111111111111111','05','05',NULL,NULL,'james','vreeland'),(3,'23440 geneva','','','','','','j@mesv.org','','4111111111111111','05','2006',NULL,NULL,'james','vreeland'),(4,'23440 geneva','','','','','','j@mesv.org','','4111111111111111','05','2006',NULL,NULL,'j','am'),(5,'23440 geneva','','','','','','j@mesv.org','','4111111111111111','','',NULL,NULL,'j','vreeland'),(6,'23440 geneva','','','','','','j@mesv.org','','4111111111111111','05','2006',NULL,NULL,'james','vreeland
+9,'536 south forest ave. #604','536 south forest ave., apt #604','ann arbor','MI','48104','734 717 2376','park9128@hotmail.com','','4217639938467905','05','2008',NULL,NULL,'hong woo','park',9.95,'United States
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
@@ -153 +155 @@
-/*!40000 ALTER TABLE `product_details` DISABLE KEYS */;
-LOCK TABLES `product_details` WRITE;
-9,67,'32','unwashed indigo',1),(10,68,'--','--',1),(11,69,'S','plaid',1),(12,69,'M','plaid',1),(13,69,'L','plaid',1),(14,70,'34','Blue',3),(15,71,'XS','Red',2),(16,71,'L','Black',1),(17,72,'M','Whatevs',3),(18,73,'L','120.50',3),(19,67,'29','unwashed indigo',1),(20,67,'33','unwashed indigo',1),(21,76,'M','black',1),(22,76,'L','black',0),(23,77,'S','drab',1),(24,77,'M','drab',1),(25,77,'L','drab',1),(26,78,'L','cream',1),(27,78,'XL','cream',1),(28,79,'S','driftwood',1),(29,79,'M','driftwood',1),(30,79,'L','driftwood',1),(31,79,'XL','driftwood',1),(32,80,'L','cream marl',1),(33,80,'XL','cream marl',1),(34,111,'S','driftwood',1),(35,111,'M','driftwood',1),(36,111,'L','driftwood',1),(37,111,'XL','driftwood',1),(38,84,'46','dk grey',1),(39,84,'50','dk grey',1),(40,85,'46','khaki',1),(41,85,'48','khaki',1),(42,85,'50','khaki',1),(43,86,'48','black',1),(44,86,'50','black',1),(45,87,'S','grey',1),(46,87,'M','grey',1),(47,87,'L','grey',1),(48,88,'46','dk grey',1),(49,88,'48','dk grey',1),(50,88,'52','dk grey',1),(51,89,'50','dk grey',1),(52,89,'52','dk grey',1),(53,90,'M','black',1),(54,90,'XXL','black',1),(55,91,'L','ecru',1),(56,91,'XXL','ecru',1),(57,92,'M','grey',1),(58,92,'L','grey',1),(59,92,'XL','grey',1),(60,93,'15','brwn gingham',1),(61,93,'16.5','brwn gingham',1),(62,94,'S','blk pinstripe',1),(63,94,'M','blk pinstripe',1),(64,94,'L','blk pinstripe',1),(65,94,'XL','blk pinstripe',1),(66,95,'S','kings plaid',1),(67,95,'M','kings plaid',1),(68,95,'L','kings plaid',1),(69,95,'XL','kings plaid',1),(70,96,'29','brown',1),(71,96,'30','brown',1),(72,96,'32','brown',1),(73,96,'36','brown',1),(74,107,'S','tan/navy',1),(75,107,'M','tan/navy',1),(76,106,'S','denim',1),(77,106,'L','denim',1),(78,105,'M','wht w/grn stripe',1),(79,105,'L','wht w/grn stripe',1),(80,105,'XL','wht w/grn stripe',1),(82,104,'M','dusty mauve',1),(83,104,'L','dusty mauve',1),(84,104,'XL','dusty mauve',1),(85,103,'29','low key',1),(86,103,'30','low key',1),(87,103,'32','low key',1),(88,103,'33','low key',1),(89,103,'34','low key',1),(90,103,'36','low key',1),(91,137,'S','grey',3),(92,137,'M','grey',1),(93,98,'25','ebony',1),(94,98,'26','ebony',1),(95,98,'27','ebony',1),(96,98,'30','ebony',1),(97,99,'25','platinum cord',1),(98,99,'26','platinum cord',1),(99,99,'27','platinum cord',1),(100,99,'28','platinum cord',1),(101,99,'29','platinum cord',1),(102,99,'30','platinum cord',1),(103,100,'S','porcelain',1),(104,100,'M','porcelain',1),(105,101,'S','buckskin',1),(106,101,'M','buckskin',1),(107,102,'S','heather blue',1),(108,102,'M','heather blue',1),(109,102,'L','heather blue',1),(110,102,'XL','heather blue',1),(111,108,'S','brwn tweed',1),(112,109,'S','khaki',1),(113,109,'M','khaki',1),(114,110,'S','charcoal',1),(115,112,'M','forge grey',1),(116,112,'L','forge grey',1),(117,112,'XL','forge grey',1),(118,113,'S','red marl',1),(119,113,'XL','red marl',1),(120,114,'S','steel',1),(121,114,'M','steel',1),(122,114,'L','steel',1),(123,114,'XL','steel',1),(126,115,'S','steel',1),(127,115,'M','steel',1),(128,115,'XL','steel',1),(129,115,'S','navy',1),(130,115,'M','navy',1),(131,115,'L','navy',1),(132,136,'M','blue',1),(133,136,'L','blue',1),(134,135,'--','spf 15',1),(135,134,'--','aftr shave',1),(136,133,'--','shave',1),(137,132,'--','',1),(138,131,'--','brwn skull',1),(139,131,'--','ram',1),(140,131,'--','skull tree',1),(141,129,'S','hand knit',1),(142,129,'M','hand knit',1),(143,128,'S','stone',1),(144,128,'M','stone',1),(145,127,'XS','gunmetal',1),(146,127,'S','gunmetal',1),(147,127,'L','gunmetal',1),(148,126,'S','black',1),(149,126,'M','black',1),(150,126,'L','black',1),(151,124,'S','grey',1),(152,124,'M','grey',1),(153,124,'L','grey',1),(154,123,'M','sable',1),(155,123,'L','sable',1),(156,122,'S','amethyst',1),(157,122,'M','amethyst',1),(158,122,'L','amethyst',1),(159,121,'XS','bamboo',1),(160,121,'S','bamboo',1),(161,121,'M','bamboo',1),(162,121,'L','bamboo',1),(163,120,'XS','grey',1),(164,120,'S','grey',1),(165,120,'M','grey',1),(166,119,'2','black',1),(167,119,'4','black',1),(168,119,'6','black',1),(169,119,'8','black',1),(170,118,'30','lumber',1),(171,118,'31','lumber',1),(172,118,'32','lumber',1),(173,118,'34','lumber',1),(174,118,'36','lumber',1),(175,117,'30','steel',1),(176,117,'31','steel',1),(177,117,'32','steel',1),(178,117,'34','steel',1),(179,117,'36','steel
+10,68,'--','--',1),(11,69,'S','plaid',1),(12,69,'M','plaid',1),(13,69,'L','plaid',1),(14,70,'34','Blue',3),(15,71,'XS','Red',2),(16,71,'L','Black',1),(17,72,'M','Whatevs',3),(18,73,'L','120.50',3),(19,67,'29','unwashed indigo',1),(20,67,'33','unwashed indigo',1),(21,76,'M','black',1),(22,76,'L','black',0),(23,77,'S','drab',1),(24,77,'M','drab',1),(25,77,'L','drab',1),(26,78,'L','cream',1),(27,78,'XL','cream',1),(28,79,'S','driftwood',1),(29,79,'M','driftwood',1),(30,79,'L','driftwood',1),(31,79,'XL','driftwood',1),(34,111,'S','driftwood',1),(35,111,'M','driftwood',1),(36,111,'L','driftwood',1),(37,111,'XL','driftwood',1),(38,84,'46','dk grey',1),(39,84,'50','dk grey',1),(40,85,'46','khaki',1),(41,85,'48','khaki',1),(42,85,'50','khaki',1),(43,86,'48','black',1),(44,86,'50','black',1),(46,87,'M','grey',1),(47,87,'L','grey',1),(48,88,'46','dk grey',1),(49,88,'48','dk grey',1),(50,88,'52','dk grey',1),(51,89,'50','dk grey',1),(52,89,'52','dk grey',1),(53,90,'M','black',1),(54,90,'XXL','black',1),(55,91,'L','ecru',1),(56,91,'XXL','ecru',1),(57,92,'M','grey',1),(58,92,'L','grey',1),(59,92,'XL','grey',1),(60,93,'15','brwn gingham',1),(61,93,'16.5','brwn gingham',1),(62,94,'S','blk pinstripe',1),(63,94,'M','blk pinstripe',1),(64,94,'L','blk pinstripe',1),(65,94,'XL','blk pinstripe',1),(66,95,'S','kings plaid',1),(67,95,'M','kings plaid',1),(68,95,'L','kings plaid',1),(69,95,'XL','kings plaid',1),(70,96,'29','brown',1),(71,96,'30','brown',1),(72,96,'32','brown',1),(73,96,'36','brown',1),(74,107,'S','tan/navy',1),(75,107,'M','tan/navy',1),(76,106,'S','denim',1),(77,106,'L','denim',1),(78,105,'M','wht w/grn stripe',1),(79,105,'L','wht w/grn stripe',1),(80,105,'XL','wht w/grn stripe',1),(82,104,'M','dusty mauve',1),(83,104,'L','dusty mauve',1),(84,104,'XL','dusty mauve',1),(85,103,'29','low key',1),(86,103,'30','low key',1),(87,103,'32','low key',1),(88,103,'33','low key',1),(89,103,'34','low key',1),(90,103,'36','low key',1),(91,137,'S','grey',3),(92,137,'M','grey',1),(93,98,'25','ebony',1),(94,98,'26','ebony',1),(95,98,'27','ebony',1),(96,98,'30','ebony',1),(97,99,'25','platinum cord',1),(98,99,'26','platinum cord',1),(99,99,'27','platinum cord',1),(100,99,'28','platinum cord',1),(101,99,'29','platinum cord',1),(102,99,'30','platinum cord',1),(103,100,'S','porcelain',1),(104,100,'M','porcelain',1),(105,101,'S','buckskin',1),(106,101,'M','buckskin',1),(107,102,'S','heather blue',1),(109,102,'L','heather blue',1),(110,102,'XL','heather blue',1),(111,108,'S','brwn tweed',1),(112,109,'S','khaki',1),(114,110,'S','charcoal',1),(115,112,'M','forge grey',1),(116,112,'L','forge grey',1),(117,112,'XL','forge grey',1),(118,113,'S','red marl',1),(119,113,'XL','red marl',1),(120,114,'S','steel',1),(121,114,'M','steel',1),(123,114,'XL','steel',1),(126,115,'S','steel',1),(127,115,'M','steel',1),(128,115,'XL','steel',1),(129,115,'S','navy',1),(130,115,'M','navy',1),(131,115,'L','navy',1),(132,136,'M','blue',1),(133,136,'L','blue',1),(134,135,'--','spf 15',1),(135,134,'--','aftr shave',1),(136,133,'--','shave',1),(137,132,'--','',1),(138,131,'--','brwn skull',1),(139,131,'--','ram',1),(140,131,'--','skull tree',1),(141,129,'S','hand knit',1),(142,129,'M','hand knit',1),(143,128,'S','stone',1),(144,128,'M','stone',1),(145,127,'XS','gunmetal',1),(146,127,'S','gunmetal',1),(147,127,'L','gunmetal',1),(148,126,'S','black',1),(149,126,'M','black',1),(150,126,'L','black',1),(151,124,'S','grey',1),(152,124,'M','grey',1),(153,124,'L','grey',1),(154,123,'M','sable',1),(155,123,'L','sable',1),(156,122,'S','amethyst',1),(157,122,'M','amethyst',1),(158,122,'L','amethyst',1),(159,121,'XS','bamboo',1),(160,121,'S','bamboo',1),(161,121,'M','bamboo',1),(162,121,'L','bamboo',1),(163,120,'XS','grey',1),(164,120,'S','grey',1),(165,120,'M','grey',1),(166,119,'2','black',1),(167,119,'4','black',1),(168,119,'6','black',1),(169,119,'8','black',1),(170,118,'30','lumber',1),(171,118,'31','lumber',1),(172,118,'32','lumber',1),(173,118,'34','lumber',1),(174,118,'36','lumber',1),(175,117,'30','steel',1),(176,117,'31','steel',1),(177,117,'32','steel',1),(178,117,'34','steel',1),(179,117,'36','steel',1),(180,138,'42','castorino wsh',1),(181,138,'43','castorino wsh',1),(182,138,'45','castorino wsh',1),(183,80,'--','sold out',1),(184,116,'L','steel',1),(185,116,'XL','steel',1),(186,153,'15','pink grid',1),(187,153,'17','pink grid',1),(188,152,'S','grey',1),(189,152,'M','grey',1),(190,152,'XL','grey',1),(191,150,'L','navy',1),(192,149,'L','denim',1),(193,146,'M','kyoto',1),(194,146,'L','kyoto',1),(195,145,'S','decker',1),(196,145,'M','decker',1),(197,145,'L','decker',1),(198,145,'XL','decker',1),(199,144,'37','delice wsh',1),(200,144,'38','delice wsh',1),(201,144,'40','delice wsh',1),(202,143,'42','',1),(203,143,'43','',1),(204,143,'45','',1),(205,142,'36','hemlock',1),(206,142,'38','hemlock',1),(207,141,'L','panama',1),(208,141,'XL','panama',1),(209,140,'L','black',1),(210,140,'XL','black',1),(211,140,'XXL','black',1),(212,139,'XL','pearl grey',1),(213,139,'XXL','pearl grey',1),(214,155,'--','shave',1),(215,160,'S','tan',1),(216,160,'M','tan',1),(217,160,'L','tan',1),(218,156,'--','aftr shave',1),(219,157,'--','pitguard',1),(220,158,'--','bodywash',1),(221,159,'--','cond.shampoo
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `product_details` ENABLE KEYS */;
@@ -175 +177 @@
-/*!40000 ALTER TABLE `product_images` DISABLE KEYS */;
-LOCK TABLES `product_images` WRITE;
-2,102),(53,103),(54,103),(55,104),(56,104),(57,105),(58,106),(59,106),(60,107),(61,107),(62,108),(63,108),(64,108),(65,109),(66,109),(67,110),(68,110),(69,111),(70,111),(71,112),(72,113),(73,113),(74,114),(75,115),(76,116),(77,117),(78,117),(79,118),(80,118),(81,119),(82,119),(83,120),(84,121),(85,122),(86,123),(87,123),(88,124),(89,125),(90,126),(91,127),(92,127),(94,128),(95,128),(96,129),(97,130),(98,130),(100,115),(101,132),(102,133),(103,134),(104,135),(105,136),(108,137),(110,131),(111,80),(125,84),(127,90),(130,91),(131,92),(132,93),(133,94),(134,95),(135,102),(136,104),(137,107),(138,106),(140,101),(141,89),(142,108),(143,109),(144,85),(145,77),(146,78),(147,79),(149,87),(150,88),(151,103),(152,105),(153,110),(154,111),(155,112),(156,113),(157,114),(158,115),(159,116),(160,86),(161,96),(162,118),(164,97),(165,98),(166,99),(167,100),(168,117),(169,119),(171,120),(172,121),(173,122),(174,123),(175,124),(176,125),(177,126),(178,127),(179,128),(180,129),(181,130),(182,136),(183,67),(184,133),(185,134),(186,132),(187,135),(188,76),(189,76
+3,103),(54,103),(55,104),(56,104),(57,105),(58,106),(59,106),(60,107),(61,107),(62,108),(63,108),(64,108),(65,109),(66,109),(67,110),(68,110),(69,111),(70,111),(71,112),(72,113),(73,113),(74,114),(75,115),(76,116),(77,117),(78,117),(79,118),(80,118),(81,119),(82,119),(83,120),(84,121),(85,122),(86,123),(87,123),(88,124),(89,125),(90,126),(91,127),(92,127),(94,128),(95,128),(96,129),(97,130),(98,130),(100,115),(101,132),(102,133),(103,134),(104,135),(105,136),(108,137),(110,131),(111,80),(125,84),(127,90),(130,91),(131,92),(132,93),(133,94),(134,95),(136,104),(137,107),(138,106),(140,101),(141,89),(142,108),(143,109),(144,85),(145,77),(146,78),(147,79),(149,87),(150,88),(151,103),(152,105),(153,110),(154,111),(155,112),(156,113),(157,114),(158,115),(159,116),(160,86),(161,96),(162,118),(164,97),(165,98),(166,99),(167,100),(168,117),(169,119),(171,120),(172,121),(173,122),(174,123),(175,124),(176,125),(177,126),(178,127),(179,128),(180,129),(181,130),(182,136),(183,67),(184,133),(185,134),(186,132),(187,135),(188,76),(189,76),(191,138),(192,138),(193,139),(194,139),(195,140),(196,140),(197,141),(198,141),(199,142),(200,142),(201,143),(202,143),(203,144),(204,144),(205,145),(206,145),(207,146),(208,146),(209,147),(210,147),(211,148),(212,148),(213,149),(214,149),(215,150),(216,150),(217,151),(218,151),(219,152),(220,152),(221,153),(222,153),(223,154),(224,154),(225,155),(226,155),(227,156),(228,156),(229,157),(230,157),(231,158),(232,158),(233,159),(234,159),(235,160),(236,160),(237,161),(238,161),(241,102),(242,102
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `product_images` ENABLE KEYS */;
@@ -205 +207 @@
-/*!40000 ALTER TABLE `products` DISABLE KEYS */;
-LOCK TABLES `products` WRITE;
-S/M/L',111),(84,'jesse dressed wool vest','J.Lindeberg','A tailored vest (fitted), three front pockets, five button closure, adjust to fit in the back, dark grey, 100% wool, approximate sizing: 46(s), 48(m), 50(l), 52(xl).',169,18,4,0,'0-52',125),(85,'maverick fine poplin shirt','J.Lindeberg','A fine poplin, button-up military inspired shirt, two front snap pockets, 100% cotton, sizing is a bit fitted 46(s), 48(m), 50(l), 52(xl).',179,18,6,0,'0-52',144),(86,'jules stretch dressed wool vest','J.Lindeberg','A tailored vest (fitted), three small welt pockets, banded pocket at left chest, four button closure, adjust to fit in the back, black, 95% wool / 5% lycra, approximate sizing: 46(s), 48(m), 50(l), 52(xl).',183,18,4,0,'0-52',160),(87,'ramon ultra fine merino knit','J.Lindeberg','A deep-v neckline cardigan, 5 button closure to the hem, 100% grey merino wool, slim fit.',242,18,12,0,'S/M/L',149),(88,'mark dressed wool pant','J.Lindeberg','x',169,18,5,0,'0-52',150),(89,'rick dressed wool blazer','J.Lindeberg','x',415,18,4,0,'0-52',141),(90,'4515 jacket','Stone Island','x',715,21,10,0,'S/M/L',127),(91,'52A4 sweater','Stone Island','x',310,21,12,0,'S/M/L',130),(92,'56A4 sweater','Stone Island','x',280,21,12,0,'S/M/L',131),(93,'model 1','by Troglodyte Homunculous','x',158,11,6,0,'14-18',132),(94,'percival blazer','Edun','x',265,3,4,0,'S/M/L',133),(95,'camelot button down','Edun','x',180,3,6,0,'S/M/L',134),(96,'magus trouser','Edun','twill',195,3,5,0,'0-52',161),(97,'sappho cropped jacket','Edun','x',335,3,10,1,'S/M/L',164),(98,'5 pkt straight leg','Edun','x',185,3,5,1,'0-52',165),(99,'5 pkt skinny cord','Edun','x',185,3,5,1,'0-52',166),(100,'crochet knit fleur top','Edun','x',170,3,6,1,'S/M/L',167),(101,'tent jacket','Rogan','x',440,8,10,0,'S/M/L',140),(102,'western shirt-gauze','Rogan','x',220,8,6,0,'S/M/L',135),(103,'original jean','Rogan','x',264,8,3,0,'0-52',151),(104,'reverse seam shirt','Steven Alan','x',168,10,6,0,'S/M/L',136),(105,'reverse collar','Steven Alan','x',168,10,6,0,'S/M/L',152),(106,'work shirt','Engineered Garments','x',176,4,6,0,'S/M/L',138),(107,'wide spread shirt','Engineered Garments','x',165,4,6,0,'S/M/L',137),(108,'fishing jacket','Engineered Garments','x',220,4,10,0,'S/M/L',142),(109,'tweed fleece hoody','Engineered Garments','x',176,4,11,0,'S/M/L',143),(110,'bdu tropical wool pant','Engineered Garments','x',286,4,5,0,'S/M/L',153),(111,'philips check crewneck','Rogues Gallery','x',176,19,12,0,'S/M/L',154),(112,'hexham tee chairs','Rogues Gallery','x',62,19,7,0,'S/M/L',155),(113,'shiloh flocked tee old bones','Rogues Gallery','',106,19,7,0,'S/M/L',156),(114,'raglan cashmere henley','Generra','',288,5,12,0,'S/M/L',157),(115,'long sleeve polo','Generra','x',82,5,7,0,'S/M/L',158),(116,'long sleeve tee','Generra','x',72,5,7,0,'S/M/L',159),(117,'classic chino','Generra','vintage brushed cotton steel',165,5,5,0,'0-52',168),(118,'classic cargo','Generra','vintage brushed cotton lumber',165,5,5,0,'0-52',162),(119,'skinny pant','Generra','stretch over-dye black',195,5,5,1,'0-52',169),(120,'scoop blouson cashmere','Generra','x',225,5,12,1,'S/M/L',171),(121,'combo tie dress','Generra','flame jersey, bamboo',160,5,13,1,'S/M/L',172),(122,'bubble crew','Generra','fine rayon, amethyst',168,5,6,1,'S/M/L',173),(123,'crop jacket ','Generra','washable leather, sable',395,5,4,1,'S/M/L',174),(124,'ballet neck tee','Generera','cotton jersey heather grey',68,5,6,1,'S/M/L',175),(125,'cotton jersey tank','Generra','x',48,5,7,1,'S/M/L',176),(126,'turtleneck','Generra','fine merino wool, black',195,5,12,1,'S/M/L',177),(127,'logan hoodie','Mike & Chris','long sleeve hoodie with hidden zipper, double front pockets and sailor collar, 100% cotton fleece.',209,20,11,1,'S/M/L',178),(128,'lucas hoodie','Mike & Chris','long sleeve vintage wash light weight fleece hoodie with button tabbed front pockets, 100% cotton fleece.',150,20,11,1,'S/M/L',179),(129,'oversize vest w/ belt','Stellapop','100% superfine merino (Merino Supreme)',242,22,12,1,'S/M/L',180),(130,'square neck tunic','Stellapop','100% extra fine merino',242,22,12,1,'S/M/L',181),(131,'belts','x','x',175,23,1,0,'0-52',NULL),(132,'antiseptic healing ointment','Brave Soldier','The original product in the Brave Soldier line, Antiseptic Healing Ointment was formulated specifically to speed the healing of road rash. A unique blend of healing botanicals and powerful pharmaceuticals helps wounds heal up to 40% faster and greatly reduces the chance of scarring. Tea tree oil, one of nature’s strongest antiseptics, combines with jojoba oil and vitamins in a soothing balm ideal for treating sports injuries as well as everyday cuts, scrapes and abrasions.\r\n\r\n',12,17,2,0,'0-52',186),(133,'brave shave','Brave Soldier','Brave Shave™ is the ultimate shave formula for men and women who demand the best. Luxurious, creamy, and enriched with natural ingredients, it naturally moisturizes sensitive skin as it softens facial and body hair allowing for an extraordinarily smooth, close shave.\r\n\r\n',15,17,2,0,'0-52',184),(134,'code blue','Brave Shave','Specially formulated by Brave Soldier founder, dermatologist\r\nDr. Ezra Kest, Code Blue dramatically reduces skin irritation\r\ndue to shaving, waxing and other cosmetic procedures. \r\nCode Blue greatly improves skin’s appearance and leaves you with a healthy, clean glow. Code Blue™ gently and effectively\r\nsoothes the “burn.”\r\n\r\n',18,17,2,0,'0-52',185),(135,'lip defender','Brave Soldier','The crystal clear formula hydrates and protects tender lips. Advanced formulation and SPF 15 prevent chapping, sunburn, windburn and leave lips soft and super kissable. Soothing, not sticky, Lip Defender, heals, moisturizes and protects. Lip Defender is available in tasty and refreshing Citrus Mint flavor.\r\n',8,17,2,0,'0-52',187),(136,'waxed linen jacket','120 Lino','x',372,1,10,0,'S/M/L',182
+0-52',111),(84,'jesse dressed wool vest','J.Lindeberg','A tailored vest (fitted), three front pockets, five button closure, adjust to fit in the back, dark grey, 100% wool, approximate sizing: 46(s), 48(m), 50(l), 52(xl).',169,18,4,0,'0-52',125),(85,'maverick fine poplin shirt','J.Lindeberg','A fine poplin, button-up military inspired shirt, two front snap pockets, 100% cotton, sizing is a bit fitted 46(s), 48(m), 50(l), 52(xl).',179,18,6,0,'0-52',144),(86,'jules stretch dressed wool vest','J.Lindeberg','A tailored vest (fitted), three small welt pockets, banded pocket at left chest, four button closure, adjust to fit in the back, black, 95% wool / 5% lycra, approximate sizing: 46(s), 48(m), 50(l), 52(xl).',183,18,4,0,'0-52',160),(87,'ramon ultra fine merino knit','J.Lindeberg','A deep-v neckline cardigan, 5 button closure to the hem, 100% grey merino wool, slim fit.',242,18,12,0,'S/M/L',149),(88,'mark dressed wool pant','J.Lindeberg','Slim fitting tailored 100% wool pant, pleated front (paired with rick dressed wool blazer makes the perfect suit), approximate sizing 46(29-30), 48(31-32), 50(32-33), 52(34-35).',169,18,5,0,'0-52',150),(89,'rick dressed wool blazer','J.Lindeberg','Slim fitting tailored 100% wool blazer, dark grey, one button, lined (paired with the slim fitting mark dressed wool pant in charcoal makes a perfect suit), approximate sizing 46(S), 48(M), 50(L), 52(XL).',415,18,4,0,'0-52',141),(90,'4515 jacket','Stone Island','A garment for life-- water and weather proof, four button, four pocket, arm badge, combed wool underneath collar, 65% nylon / 32% cotton / 3% elastane, made in italy, please size up one size.',715,21,10,0,'S/M/L',127),(91,'52A4 sweater','Stone Island','Ecru knit sweater, stand-up collar, 4 button, 80% wool / 20% nylon, made in Italy, please size up one size.',310,21,12,0,'S/M/L',130),(92,'56A4 sweater','Stone Island','Grey knit pull-over sweater, 80% wool / 20% nylon, made in Italy, please size up one size.',280,21,12,0,'S/M/L',131),(93,'model 1 gingham','Troglodyte Homunculous','The model 1 shirt is designed for the man who appreciates bespoke tailoring and wants the same custom qualities in his casual wear--Italian gingham check fabric, 100% cotton, sized true to size (neck/arm), cut short enough to wear untucked and not look sloppy, made in Italy.',158,11,6,0,'14-18',132),(94,'percival blazer','Edun','Blurring the lines between a sportcoat and outerwear, the percival blazer is constructed of sturdy cotton, black with a faint pinstripe, three button, signature s-seam on the back and all the usual amazing edun details that subtley blend into the garment (printed poem on inside lining, plaid fabric piping on interior of coat), fits true to size.',265,3,4,0,'S/M/L',133),(95,'camelot button down','Edun','An Edun staple--this camelot shirt body is created with a subtle vertically running metallic thread fabric, front button closure, single chest (button-closed) pocket, signature s-seam along the back, 5-button cuff, 65% poly / 35% cotton.',180,3,6,0,'S/M/L',134),(96,'magus trouser','Edun','A twill trouser pant straight leg which can be dressed up or worn casual, very sturdy material with a thin interior lining gets these pants through all seasons, front slash pockets, rear welt pockets and all the usuall Edun details that nobody can see but yourself (custom buttons, inside embroidered waist band, poem lined pockets, fits true to size.',195,3,5,0,'0-52',161),(97,'sappho cropped jacket','Edun','x',335,3,10,1,'S/M/L',164),(98,'5 pkt straight leg','Edun','x',185,3,5,1,'0-52',165),(99,'5 pkt skinny cord','Edun','x',185,3,5,1,'0-52',166),(100,'crochet knit fleur top','Edun','x',170,3,6,1,'S/M/L',167),(101,'tent jacket','Rogan','The tent jacket never feels like it should be removed when coming in from the outdoors--only unzipped, full length zip front closure + full length button closure (w/vintage-looking buttons), two front bucket pockets, single chest pocket, beat-up / stained inerior sleeve lining adds to the jacket\'s vintage appeal, three horizontal stitched lines around the right forearm vs. three vertical stitched lines down the left sleeve, 97% cotton / 3% polyurethane (lining 50/50) (sleeve lining 100% cupro), fits true to size.',440,8,10,0,'S/M/L',140),(102,'western shirt-gauze','Rogan','100% cotton made from a gauze material (extremely soft), dual chest pockets, white distressed buttons all the way up front closures (signature \"r\" on each button), dark grey contrast fabric under collar, fits true to size.',220,8,6,0,'S/M/L',242),(103,'original jean','Rogan','The original jean is at the top of the denim food-chain, japanese denim (100% cotton) that is broken in by Rogan\'s natural treatments creating unusually soft denim, workpant trouser (straight leg), red lined slash side pockets, pen and cell phone pockets, twisted outer seam (paying homage to the original workmen\'s Levi), pant sits at your waist (neither too low nor too high), button fly, made in U.S.A., fits true to size.',264,8,3,0,'0-52',151),(104,'reverse seam shirt','Steven Alan','The ultimate men\'s button-down--side seams sewn on the outside (reverse seam), single chest outside pocket, pearl buttons, limited edition fabrics, twisted placket, 100% cotton washed and beat-up to create that disheveled yet preppy look, fit is a bitter narrower in the sides and shorter in length (stopping above the bottom of your pant zipper), made in nyc.',168,10,6,0,'S/M/L',136),(105,'reverse collar','Steven Alan','A new twist on the infamous untucked reverse seam shirt.  Single chest pocket, pearl buttons, all seams are sewn correctly throughout the shirt with the exception of the collar, which is sewn reverse, allowing the collar to stand-up (creating a new disheveled / preppy look), 100% cotton washed and beat-up, made in nyc, fits boxier than the reverse seam shirt, yet, still true to size.',168,10,6,0,'S/M/L',152),(106,'work shirt','Engineered Garments','A signature piece from Engineered Garment-- dual pockets (with the left side appearing smaller and up-side down) and the bottom button always in red (replacing a lost button on your workshit never ends up matching), 100% cotton - washed japanese denim, made in nyc, fits true to size.',176,4,6,0,'S/M/L',138),(107,'wide spread shirt','Engineered Garments','single needle tailored shirt, wide spread collar, navy+tan plaid printed on a damask-like fabric, single chest pocket, made in nyc, fit true to size.',165,4,6,0,'S/M/L',137),(108,'fishing jacket','Engineered Garments','Snap front tweed fishing jacket, contrast corduroy collar, four front snap pockets, a true replica of a fly fishing shirt/jacket, cut shorter in length and boxier fit.',220,4,10,0,'S/M/L',142),(109,'tweed fleece hoody','Engineered Garments','Hoodie made from green-spun fabric--breathable, ecology minded, recycled yarns, each individual garment represents its own unique character, 65% recycled cotton, 20% acrylic, 20% polyester, made in nyc, fits true to size.',176,4,11,0,'S/M/L',143),(110,'bdu tropical wool pant','Engineered Garments','An all season pant, 100% grey tropical wool keeps cool in the summer / warm in the winter, zip fly, large side button pockets, front slash pockets, black 100% contrast black cotton lining hangs below the pant leg, drawsting at bottom of each leg, made in nyc, looser fit S(30-31), M(32-33), L(34-35).',286,4,5,0,'S/M/L',153),(111,'philips check crewneck','Rogues Gallery','Crewneck sweatshirt done Rogues Gallery style, beat-up hounds-tooth fabric, 100% cotton, frayed seams, raw edge rectangle elbow patches, marsupial pocket, contrast cuffs, fits true to size.',176,19,12,0,'S/M/L',154),(112,'hexham tee chairs','Rogues Gallery','x',62,19,7,0,'S/M/L',155),(113,'shiloh flocked tee old bones','Rogues Gallery','',106,19,7,0,'S/M/L',156),(114,'raglan cashmere henley','Generra','',288,5,12,0,'S/M/L',157),(115,'long sleeve polo','Generra','x',82,5,7,0,'S/M/L',158),(116,'long sleeve tee','Generra','x',72,5,7,0,'S/M/L',159),(117,'classic chino','Generra','vintage brushed cotton steel',165,5,5,0,'0-52',168),(118,'classic cargo','Generra','vintage brushed cotton lumber',165,5,5,0,'0-52',162),(119,'skinny pant','Generra','stretch over-dye black',195,5,5,1,'0-52',169),(120,'scoop blouson cashmere','Generra','x',225,5,12,1,'S/M/L',171),(121,'combo tie dress','Generra','flame jersey, bamboo',160,5,13,1,'S/M/L',172),(122,'bubble crew','Generra','fine rayon, amethyst',168,5,6,1,'S/M/L',173),(123,'crop jacket ','Generra','washable leather, sable',395,5,4,1,'S/M/L',174),(124,'ballet neck tee','Generera','cotton jersey heather grey',68,5,6,1,'S/M/L',175),(125,'cotton jersey tank','Generra','x',48,5,7,1,'S/M/L',176),(126,'turtleneck','Generra','fine merino wool, black',195,5,12,1,'S/M/L',177),(127,'logan hoodie','Mike & Chris','long sleeve hoodie with hidden zipper, double front pockets and sailor collar, 100% cotton fleece.',209,20,11,1,'S/M/L',178),(128,'lucas hoodie','Mike & Chris','long sleeve vintage wash light weight fleece hoodie with button tabbed front pockets, 100% cotton fleece.',150,20,11,1,'S/M/L',179),(129,'oversize vest w/ belt','Stellapop','100% superfine merino (Merino Supreme)',242,22,12,1,'S/M/L',180),(130,'square neck tunic','Stellapop','100% extra fine merino',242,22,12,1,'S/M/L',181),(131,'belts','x','x',175,23,1,0,'0-52',NULL),(132,'antiseptic healing ointment','Brave Soldier','The original product in the Brave Soldier line, Antiseptic Healing Ointment was formulated specifically to speed the healing of road rash. A unique blend of healing botanicals and powerful pharmaceuticals helps wounds heal up to 40% faster and greatly reduces the chance of scarring. Tea tree oil, one of nature’s strongest antiseptics, combines with jojoba oil and vitamins in a soothing balm ideal for treating sports injuries as well as everyday cuts, scrapes and abrasions.\r\n\r\n',12,17,2,0,'0-52',186),(133,'brave shave','Brave Soldier','Brave Shave™ is the ultimate shave formula for men and women who demand the best. Luxurious, creamy, and enriched with natural ingredients, it naturally moisturizes sensitive skin as it softens facial and body hair allowing for an extraordinarily smooth, close shave.\r\n\r\n',15,17,2,0,'0-52',184),(134,'code blue','Brave Shave','Specially formulated by Brave Soldier founder, dermatologist\r\nDr. Ezra Kest, Code Blue dramatically reduces skin irritation\r\ndue to shaving, waxing and other cosmetic procedures. \r\nCode Blue greatly improves skin’s appearance and leaves you with a healthy, clean glow. Code Blue™ gently and effectively\r\nsoothes the “burn.”\r\n\r\n',18,17,2,0,'0-52',185),(135,'lip defender','Brave Soldier','The crystal clear formula hydrates and protects tender lips. Advanced formulation and SPF 15 prevent chapping, sunburn, windburn and leave lips soft and super kissable. Soothing, not sticky, Lip Defender, heals, moisturizes and protects. Lip Defender is available in tasty and refreshing Citrus Mint flavor.\r\n',8,17,2,0,'0-52',187),(136,'waxed linen jacket','120 Lino','x',372,1,10,0,'S/M/L',182),(138,'suede brogue','N.D.C.','Hand-made and hand distressed suede brogue, leather sole, six hole lace-up, sizing 41(8.5-9), 42(9-9.5), 43(10-10.5), 44(11-11.5), 45(12-12.5).',383,7,8,0,'0-52',192),(139,'colibri blouson','Belstaff','A simple style with practical zips for adjusting fit and ventilation to suit any speed--Teflon treated waterproof zips.  Side and cuff zips for a windproof fit.  Style is a fitted size, please size up one size.',409,2,10,0,'S/M/L',194),(140,'warder summer blouson','Belstaff','Simple, elegant, great performance--practical key holder for scooter key is an integral part of the sleeve.  Style is fitted, please size up one size.',479,2,10,0,'S/M/L',196),(141,'xl500','Belstaff','Unlined (suitable for about-town use), taped seams, reflecting belt (wear with belt loose or fastened at the back for added appeal.  Belfresh material is the ideal solution for all weather conditions, in both day-to-day and professional use.  Style fits true to size.',561,2,10,0,'S/M/L',198),(142,'bow jean','Rogan','',264,8,3,0,'0-52',200),(143,'jules boot (men)','N.D.C.','Hand-made, hand-distressed, suede boot, leather sole, 2 hole lace-up.  This model runs large--please size down one size.',398,7,8,0,'0-52',202),(144,'cecilia','N.D.C.','',296,7,8,1,'0-52',204),(145,'western shirt (decker)','Rogan','',216,8,6,0,'S/M/L',206),(146,'western shirt (kyoto)','Rogan','',228,8,6,0,'S/M/L',208),(147,'eclipse straight leg','Edun','',165,3,3,0,'0-52',210),(148,'neo straight leg','Edun','',170,3,3,0,'0-52',212),(149,'8oz denim jacket','Engineered Garments','',286,4,4,0,'S/M/L',214),(150,'fishing shirt navy','Engineered Garments','',198,4,6,0,'S/M/L',216),(151,'almost gold','Obedient Sons','',180,12,6,0,'0-52',218),(152,'admirality (hexham)','Rogues Gallery','',60,19,7,0,'S/M/L',220),(153,'model 1 pink-grid','Troglodyte Homunculous','The model 1 shirt is designed for the man who appreciates bespoke tailoring and wants the same custom qualities in his casual wear--Italian gingham check fabric, 100% cotton, sized true to size (neck/arm), cut short enough to wear untucked and not look sloppy, made in Italy.',158,11,6,0,'14-18',222),(155,'kid glove shave gel','Sharps','This oil-free, guy-strength brew of botanicals instantly transforms into transparent gel when applied to the skin. \r\nGet better facial hair designs and avoid rocky road nicks.  No more burn. No more rashes. Easy glide - Great healthy glow - Kid Glove smooth.',13,14,2,0,'0-52',226),(156,'after shave','Sharps','Protect your mug. This light and oil-free gel is fully loaded with botanicals and anti-oxidants to combat the enemies: razor burn, dryness, sun damage\r\nand environmental pollutants. Dries invisible so even the most observant skin care cops won\'t know your secret.\r\nNot oily. Not heavy. Just enough fight. ',16,14,2,0,'0-52',228),(157,'pit guard','Sharps','0% fragrance. 0% Alcohol. 100% more confidence.  Pit Guard goes on silky and dries quickly without the telltale scent that announces you\'re covering\r\nsomething funky. Our anti-itch formula doesn\'t mask, it combats bacteria and unwelcome B.O.',11,14,2,0,'0-52',230),(158,'all over bodywash','Sharps','You can swab the whole deck with oil-free All Over Wash.  It\'s a lot more versatile and better for your skin than most soap bars. The lather you want, without the dryness. ',12,14,2,0,'0-52',232),(159,'conditioning shampoo','Sharps','Save time, save money, save space on your shelf or in your bag. This one step shampoo and conditioner is light yet super charged with all the right stuff. No tangles. No tears. A creamy lather. Total control for time freaks like you. ',12,14,2,0,'0-52',234),(160,'fishing shirt (tan)','Engineered Garments','',198,4,6,0,'S/M/L',236),(161,'almost gold','Obedient Sons','',180,12,6,0,'0-52',238
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `products` ENABLE KEYS */;
@@ -226 +228 @@
-/*!40000 ALTER TABLE `products_tags` DISABLE KEYS */;
-LOCK TABLES `products_tags` WRITE;
-1),(1,114),(1,80),(1,67),(1,85),(1,86
+4),(1,67),(1,85),(1,86),(1,111),(1,80
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `products_tags` ENABLE KEYS */;
@@ -246 +248 @@
-/*!40000 ALTER TABLE `schema_info` DISABLE KEYS */;
-LOCK TABLES `schema_info` WRITE;
-1),(21
+2),(22
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `schema_info` ENABLE KEYS */;
@@ -271 +273 @@
-/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
-LOCK TABLES `sessions` WRITE;
-KQHNp\nemUiBzMwOg1AcHJvZHVjdG86DFByb2R1Y3QGOhBAYXR0cmlidXRlc3sPIglu\nYW1lIhduZXcgc3RhbmRhcmQgZGVuaW0iDWNhdGVnb3J5IgYzIgpwcmljZSII\nMTQwIhNmZWF0dXJlZF9pbWFnZSIIMTgzIhZzaG9ydF9kZXNjcmlwdGlvbiIL\nQS5QLkMuIg1kZXNpZ25lciIHMTYiC2dlbmRlciIGMCIHaWQiBzY3IhVsb25n\nX2Rlc2NyaXB0aW9uIgIuATEwMCUgY290dG9uLCB1bndhc2hlZCBkZW5pbSwg\nbmVpdGhlciBsb3cgbm9yIGhpZ2ggcmlzZSwgZml2ZSBwb2NrZXQsIGNvaW4g\ncG9ja2V0LCBidXR0b24gZmx5LCB0aGUgZmlyc3QgYnV0dG9uIGlzIGVuZ3Jh\ndmVkICdBLlAuQy4gcGFyaXMgcHJlcyBkdSBsdXhlbWJvdXJnLCcgbmFycm93\nIGxlZywgc2xpZ2h0bHkgZml0dGVkIGF0IGJvdHRvbSB0byBnaXZlIHRoZSBh\ncHBlYXJhbmNlIG9mIGEgc3RyYWlnaHQgbGVnLCBkZW5pbSBmYWJyaWMgd2l0\naCByZWQgc2VsdmFnZS0td2VhciB0aGVtIHRpZ2h0LCBub3JtYWwgb3IgYmFn\nZ3kuIg9zaXplX2NsYXNzIgkwLTUyOg5AcXVhbnRpdHlpBiIKZmxhc2hJQzon\nQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7\nAA==\n','2006-09-19 21:25:15
+OQHF1\nYW50aXR5aQY6CkBzaXplIgczMDoNQHByb2R1Y3RvOgxQcm9kdWN0BjoQQGF0\ndHJpYnV0ZXN7DyIJbmFtZSIXbmV3IHN0YW5kYXJkIGRlbmltIg1jYXRlZ29y\neSIGMyIKcHJpY2UiCDE0MCITZmVhdHVyZWRfaW1hZ2UiCDE4MyIWc2hvcnRf\nZGVzY3JpcHRpb24iC0EuUC5DLiINZGVzaWduZXIiBzE2IgtnZW5kZXIiBjAi\nB2lkIgc2NyIVbG9uZ19kZXNjcmlwdGlvbiICLgExMDAlIGNvdHRvbiwgdW53\nYXNoZWQgZGVuaW0sIG5laXRoZXIgbG93IG5vciBoaWdoIHJpc2UsIGZpdmUg\ncG9ja2V0LCBjb2luIHBvY2tldCwgYnV0dG9uIGZseSwgdGhlIGZpcnN0IGJ1\ndHRvbiBpcyBlbmdyYXZlZCAnQS5QLkMuIHBhcmlzIHByZXMgZHUgbHV4ZW1i\nb3VyZywnIG5hcnJvdyBsZWcsIHNsaWdodGx5IGZpdHRlZCBhdCBib3R0b20g\ndG8gZ2l2ZSB0aGUgYXBwZWFyYW5jZSBvZiBhIHN0cmFpZ2h0IGxlZywgZGVu\naW0gZmFicmljIHdpdGggcmVkIHNlbHZhZ2UtLXdlYXIgdGhlbSB0aWdodCwg\nbm9ybWFsIG9yIGJhZ2d5LiIPc2l6ZV9jbGFzcyIJMC01MiIKZmxhc2hJQzon\nQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7\nAA==\n','2006-09-19 21:48:44'),(97,'0246eca00327e07662186262b48d890a','BAh7CDoRb3JpZ2luYWxfdXJpIgsvYWRtaW46DHVzZXJfaWQwIgpmbGFzaElD\nOidBY3Rpb25Db250cm9sbGVyOjpGbGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNl\nZHsA\n','2006-09-20 09:12:56'),(98,'6cb20938d8997a337cfd125f3718f6d8','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-20 21:41:31'),(99,'f4caff22f168070a861bff3bf2f0703c','BAh7CToRb3JpZ2luYWxfdXJpIgsvYWRtaW46DHVzZXJfaWRpBjoJY2FydG86\nCUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6\nRmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 14:11:09'),(100,'a82a4b9607ff7ddcdf6192f0710d3033','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:34:28'),(101,'197a7e20247302f5d95705f7154140e8','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:38:10'),(102,'966b9f742bf4aa8d5d259e0f5de16cd7','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:43:43'),(103,'bfd163d90a226c21e4b889ad521125ff','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:23'),(104,'8c23d1ba405aca3f21bd9b001b9f0034','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:28'),(105,'018012572e7624329db21ceaf4e8b2a0','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:35'),(106,'7efc11184da3666eff8652844a52a6dd','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:41'),(107,'45b9b0211c11405a998b7553ce3867fa','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:41'),(108,'2f6e67feff575ed4b181aaa390d873eb','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:41'),(109,'b24e610178d79a230b163867c98600db','BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo\nSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:44'),(110,'c01268890bd7b6123d067860b8132b01','BAh7ByIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo\nSGFzaHsABjoKQHVzZWR7ADoJY2FydG86CUNhcnQGOgtAaXRlbXNbAA==\n','2006-09-21 09:17:37'),(111,'edbeaafc8208b608449e1b90110a0f82','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:44:51'),(112,'4ef704efd4cefcb94accc8496eb8547a','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:45:04'),(113,'19382418c97145b8d4e501ad5d5e41b1','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:45:08'),(114,'998cf4c05db2ab16102a7bb4407e859e','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:45:15'),(115,'064fb0fc428054c430ee4d471729b2e9','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:45:19'),(116,'f98d404800cf368a35dd7b716e4217ee','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:58:50'),(117,'23b1a79b07f58c8580b00a7550914ab4','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:58:57'),(118,'1e04f819e47bc3553d243b4cac16e7f1','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:59:01'),(119,'4650d042b0722e6e7d75dcd0dbc123e0','BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo\nSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:59:06'),(120,'402ce5d9342f5d892bc38bd80560b535','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:59:30'),(121,'713343fdb5d8cafd5265a9c701f6d56e','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:59:36'),(122,'7c39c7d0a1b4d1da8ec511b03737a6e9','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:59:41'),(123,'d5e45c9960e96b0c9923113b0054abc0','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 08:59:44'),(124,'2c642ad39cc9291872974bf3901bf7c9','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 09:00:06'),(125,'6afba26ab66698704c4353bcb34b8d4a','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 09:00:14'),(126,'1d0d6166c9a29c0c248b19b4f3f109ce','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 09:00:21'),(127,'cb4428a31649dbd4627f1a8b7dd733e8','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 09:00:47'),(128,'4e851fd3ca60ca669e8ab4781212f9f3','BAh7CDoRb3JpZ2luYWxfdXJpIgsvYWRtaW46DHVzZXJfaWRpCCIKZmxhc2hJ\nQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVz\nZWR7AA==\n','2006-09-21 09:41:53'),(129,'175bbefa22296bff53f683f05018ad4c','BAh7CToRb3JpZ2luYWxfdXJpIgsvYWRtaW46DHVzZXJfaWRpBjoJY2FydG86\nCUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6\nRmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-22 07:12:16'),(130,'dc3b8b96f34261af624aaf60cb169620','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 20:39:44'),(131,'f724f931f13cb18a3916bee249a7f135','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 09:45:53'),(132,'e104af1cb70d2a1b6922a1069b271257','BAh7ByIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo\nSGFzaHsABjoKQHVzZWR7ADoJY2FydG86CUNhcnQGOgtAaXRlbXNbAA==\n','2006-09-21 09:47:17'),(133,'3e5ceab238b312c04d1b31361ddb0a6a','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 19:07:18'),(134,'161e5407478bf2d3f15668416512f3cd','BAh7ByIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo\nSGFzaHsABjoKQHVzZWR7ADoJY2FydG86CUNhcnQGOgtAaXRlbXNbAA==\n','2006-09-21 10:13:21'),(135,'b5edea0cd8abec0fa5e05e401976d645','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:44:54'),(136,'92fd6d4aefb6c39c1e66b86ca5a6e5ba','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:45:09'),(137,'4acdc89697f3a95c2ae222ab47a5d0b7','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:45:22'),(138,'44becce7571c149e0b87fceda6796f5a','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:45:29'),(139,'5c031b5ea98ea2a0fb259cab0cb49176','BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo\nSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:45:31'),(140,'be7bb5b31278400183c270f84c03be30','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:45:41'),(141,'008261046670e90121f5431bf09c8bb5','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:46:04'),(142,'4b5c7986d7865ef0a676022f9c813330','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:46:05'),(143,'a983b336750461ef206acf3b5d552076','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:46:40'),(144,'5e281b7a667f8d93cecfd8787fa2632b','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:46:48'),(145,'7ced240b8028d156d0eb6ecef8d49fb9','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:47:11'),(146,'309f680d3f3b6b0b32f905539fba75b6','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:47:16'),(147,'9ea21e4ede68c94a3fa1d830f8c55578','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:47:28'),(148,'b21c89bfebf60ebe570995cf31260ec8','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:47:31'),(149,'acf2bdd4b2a5b0133a25e7c58bd55334','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:47:54'),(150,'fcb5daac822a5b42cb3ab87ee62b1f2d','BAh7CToJY2FydG86CUNhcnQGOgtAaXRlbXNbADoRb3JpZ2luYWxfdXJpIgsv\nYWRtaW46DHVzZXJfaWRpCCIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6\nRmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 16:50:11'),(151,'346b34db89b79f9181b9bf29fb9b7e4b','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:53:35'),(152,'d0cefc7327441899edf659176f391ce9','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:53:40'),(153,'db74483ba6863b02ef032767d916415f','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 18:53:58'),(154,'c01f5d9f5a8ddc83a20e5aa2202acff3','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 10:59:25'),(155,'2cd72f6a30fcd2279e367463413ff8c8','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 11:00:27'),(156,'f92aeb2b77a369e7ae7280a9788fc1d7','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 11:01:24'),(157,'1b955414d937b2d661ded5368eb4af21','BAh7BzoJY2FydG86CUNhcnQGOgtAaXRlbXNbACIKZmxhc2hJQzonQWN0aW9u\nQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n','2006-09-21 11:07:25'),(158,'7046fd3bba2d58f25dfeeb11ad68b352','BAh7BzoJY2FydG86CUNhc