-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.0.26


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema afterma_xcart
--

CREATE DATABASE IF NOT EXISTS afterma_xcart;
USE afterma_xcart;

--
-- Definition of table `xcart_categories`
--

DROP TABLE IF EXISTS `xcart_categories`;
CREATE TABLE `xcart_categories` (
  `categoryid` int(11) NOT NULL auto_increment,
  `parentid` int(11) NOT NULL default '0',
  `categoryid_path` varchar(255) NOT NULL default '',
  `image_x` int(11) NOT NULL default '0',
  `image_y` int(11) NOT NULL default '0',
  `category` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `meta_descr` varchar(255) NOT NULL default '',
  `avail` char(1) NOT NULL default 'Y',
  `views_stats` int(11) NOT NULL default '0',
  `order_by` int(11) NOT NULL default '0',
  `membership` varchar(32) NOT NULL default '',
  `threshold_bestsellers` int(11) NOT NULL default '1',
  `product_count` int(11) NOT NULL default '0',
  `meta_keywords` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`categoryid`),
  KEY `category_path` (`parentid`,`categoryid_path`),
  KEY `category_path2` (`categoryid`,`categoryid_path`),
  KEY `avail` (`avail`),
  KEY `membership` (`membership`),
  KEY `order_by` (`order_by`,`category`),
  KEY `am` (`avail`,`membership`),
  KEY `pam` (`categoryid_path`,`avail`,`membership`),
  KEY `ia` (`categoryid`,`avail`),
  KEY `iam` (`categoryid`,`avail`,`membership`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_categories`
--

/*!40000 ALTER TABLE `xcart_categories` DISABLE KEYS */;
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (569,568,'497/568/569',0,0,'Chevrolet','','','Y',10,0,'',1,0,''),
 (570,569,'497/568/569/570',0,0,'Tahoe','','','Y',4,0,'',1,4,''),
 (571,568,'497/568/571',0,0,'GMC','','','Y',2,0,'',1,0,''),
 (163,36,'36/163',75,75,'Chevrolet/GMC','Protect your front end.','','Y',200,0,'',1,1,''),
 (605,583,'497/573/580/583/605',0,0,'Yukon','','','Y',1,0,'',1,16,''),
 (606,581,'497/573/580/581/606',0,0,'Avalanche','','','Y',2,0,'',1,9,''),
 (600,599,'497/594/598/599/600',0,0,'Sierra','','','Y',2,0,'',1,3,''),
 (601,596,'497/594/595/596/601',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (602,581,'497/573/580/581/602',0,0,'Silverado','','','Y',5,0,'',1,8,''),
 (603,583,'497/573/580/583/603',0,0,'Sierra','','','Y',0,0,'',1,8,''),
 (574,573,'497/573/574',0,0,'Complete','','','Y',9,0,'',1,0,''),
 (575,574,'497/573/574/575',0,0,'Hummer','','','Y',1,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (576,575,'497/573/574/575/576',0,0,'H2','','','Y',1,0,'',1,3,''),
 (577,573,'497/573/577',0,0,'Buckets','','','Y',6,0,'',1,0,''),
 (578,577,'497/573/577/578',0,0,'Hummer','','','Y',0,0,'',1,0,''),
 (579,578,'497/573/577/578/579',0,0,'H2','','','Y',0,0,'',1,3,''),
 (580,573,'497/573/580',0,0,'Handles','','','Y',18,0,'',1,0,''),
 (581,580,'497/573/580/581',0,0,'Chevrolet','','','Y',12,0,'',1,0,''),
 (582,581,'497/573/580/581/582',0,0,'Colorado','','','Y',0,0,'',1,8,''),
 (583,580,'497/573/580/583',0,0,'GMC','','','Y',2,0,'',1,0,''),
 (584,583,'497/573/580/583/584',0,0,'Canyon','','','Y',0,0,'',1,8,''),
 (585,574,'497/573/574/585',0,0,'Chevrolet','','','Y',1,0,'',1,0,''),
 (586,585,'497/573/574/585/586',0,0,'Silverado','','','Y',0,0,'',1,3,''),
 (587,574,'497/573/574/587',0,0,'GMC','','','Y',2,0,'',1,0,''),
 (588,587,'497/573/574/587/588',0,0,'Sierra','','','Y',0,0,'',1,3,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (589,585,'497/573/574/585/589',0,0,'Tahoe','','','Y',0,0,'',1,5,''),
 (590,587,'497/573/574/587/590',0,0,'Yukon','','','Y',0,0,'',1,5,''),
 (591,585,'497/573/574/585/591',0,0,'Avalanche','','','Y',0,0,'',1,5,''),
 (592,574,'497/573/574/592',0,0,'Cadillac','','','Y',3,0,'',1,0,''),
 (593,592,'497/573/574/592/593',0,0,'Escalade','','','Y',0,0,'',1,5,''),
 (594,497,'497/594',0,0,'Tailgate Handles','','','Y',7,0,'',1,0,''),
 (595,594,'497/594/595',0,0,'Handles','','','Y',2,0,'',1,0,''),
 (596,595,'497/594/595/596',0,0,'Chevrolet','','','Y',0,0,'',1,0,''),
 (597,596,'497/594/595/596/597',0,0,'Silverado','','','Y',0,0,'',1,2,''),
 (598,594,'497/594/598',0,0,'Complete','','','Y',4,0,'',1,0,''),
 (599,598,'497/594/598/599',0,0,'GMC','','','Y',1,0,'',1,0,''),
 (36,0,'36',70,50,'Bug Shields','','bug shields','Y',304,0,'',1,0,'EGR, TFP, Wang\'s International, In Pro Car Wear, Husky, Nifty');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (561,560,'497/560/561',0,0,'Chevrolet','','','Y',4,0,'',1,0,''),
 (560,497,'497/560',0,0,'Sill Plates','','','Y',6,0,'',1,0,''),
 (286,273,'270/273/286',0,0,'Jimmy (S15)','','','Y',4,0,'',1,1,''),
 (287,273,'270/273/287',0,0,'S15 Pick-Up','','','Y',2,0,'',1,0,''),
 (288,273,'270/273/288',0,0,'Suburban','','','Y',8,0,'',1,5,''),
 (289,270,'270/289',0,0,'Hummer','','','Y',14,0,'',1,0,''),
 (285,273,'270/273/285',0,0,'Envoy','','','Y',1,0,'',1,1,''),
 (284,273,'270/273/284',0,0,'Canyon','','','Y',2,0,'',1,1,''),
 (248,0,'248',0,0,'Billet Grilles','','','Y',541,0,'',1,0,''),
 (462,456,'248/456/462',0,0,'GMC','','','Y',8,0,'',1,0,''),
 (452,451,'248/444/451/452',0,0,'Escalade','','','Y',0,0,'',1,4,''),
 (444,248,'248/444',0,0,'EZSolid','','','Y',4,0,'',1,0,''),
 (461,457,'248/456/457/461',0,0,'Avalanche','','','Y',3,0,'',1,3,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (463,462,'248/456/462/463',0,0,'Sierra','','','Y',2,0,'',1,6,''),
 (464,462,'248/456/462/464',0,0,'Yukon','','','Y',3,0,'',1,2,''),
 (460,457,'248/456/457/460',0,0,'Tahoe','','','Y',1,0,'',1,2,''),
 (459,457,'248/456/457/459',0,0,'Suburban','','','Y',0,0,'',1,2,''),
 (458,457,'248/456/457/458',0,0,'Silverado','','','Y',6,0,'',1,9,''),
 (457,456,'248/456/457',0,0,'Chevrolet','','','Y',15,0,'',1,0,''),
 (456,248,'248/456',0,0,'3D Solid','','','Y',35,0,'',1,0,''),
 (451,444,'248/444/451',0,0,'Cadillac','','','Y',1,0,'',1,0,''),
 (455,453,'248/444/453/455',0,0,'Yukon','','','Y',0,0,'',1,4,''),
 (454,453,'248/444/453/454',0,0,'Sierra','','','Y',0,0,'',1,9,''),
 (453,444,'248/444/453',0,0,'GMC','','','Y',0,0,'',1,0,''),
 (450,445,'248/444/445/450',0,0,'Avalanche','','','Y',0,0,'',1,4,''),
 (449,445,'248/444/445/449',0,0,'Silverado','','','Y',1,0,'',1,11,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (448,445,'248/444/445/448',0,0,'Tahoe','','','Y',0,0,'',1,4,''),
 (447,445,'248/444/445/447',0,0,'Suburban','','','Y',1,0,'',1,4,''),
 (446,445,'248/444/445/446',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (445,444,'248/444/445',0,0,'Chevrolet','','','Y',1,0,'',1,0,''),
 (270,0,'270',0,0,'Tail Lamps','','','Y',374,99,'',1,0,''),
 (292,0,'292',0,0,'Head Lamps','','','Y',402,0,'',1,0,''),
 (271,270,'270/271',0,0,'Cadillac','','','Y',26,0,'',1,0,''),
 (272,270,'270/272',0,0,'Chevrolet','','','Y',131,0,'',1,0,''),
 (273,270,'270/273',0,0,'GMC','','','Y',48,0,'',1,0,''),
 (274,271,'270/271/274',0,0,'Escalade','','','Y',35,0,'',1,8,''),
 (275,272,'270/272/275',0,0,'Silverado','','','Y',41,0,'',1,5,''),
 (276,273,'270/273/276',0,0,'Yukon','','','Y',15,0,'',1,9,''),
 (277,272,'270/272/277',0,0,'Suburban','','','Y',18,0,'',1,4,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (278,272,'270/272/278',0,0,'Tahoe','','','Y',15,0,'',1,6,''),
 (279,273,'270/273/279',0,0,'Sierra','','','Y',7,0,'',1,4,''),
 (280,272,'270/272/280',0,0,'Avalanche','','','Y',13,0,'',1,2,''),
 (281,272,'270/272/281',0,0,'Blazer (S10)','','','Y',8,0,'',1,1,''),
 (282,272,'270/272/282',0,0,'Colorado','','','Y',1,0,'',1,1,''),
 (283,272,'270/272/283',0,0,'S10 Pick-Up','','','Y',17,0,'',1,1,''),
 (290,289,'270/289/290',0,0,'H2','','','Y',4,0,'',1,2,''),
 (291,272,'270/272/291',0,0,'TrailBlazer','','','Y',2,0,'',1,1,''),
 (293,292,'292/293',0,0,'Chevrolet','','','Y',125,0,'',1,0,''),
 (294,292,'292/294',0,0,'GMC','','','Y',28,0,'',1,0,''),
 (295,292,'292/295',0,0,'Hummer','','','Y',18,0,'',1,0,''),
 (296,292,'292/296',0,0,'Cadillac','','','Y',18,0,'',1,0,''),
 (297,293,'292/293/297',0,0,'Silverado/Pick-Up','','','Y',60,0,'',1,4,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (298,293,'292/293/298',0,0,'Blazer S10','','','Y',24,0,'',1,2,''),
 (299,293,'292/293/299',0,0,'S10 Pick-Up','','','Y',25,0,'',1,2,''),
 (300,293,'292/293/300',0,0,'Suburban','','','Y',22,0,'',1,4,''),
 (301,293,'292/293/301',0,0,'Tahoe','','','Y',22,0,'',1,4,''),
 (302,294,'292/294/302',0,0,'Suburban','','','Y',3,0,'',1,2,''),
 (303,294,'292/294/303',0,0,'Yukon','','','Y',5,0,'',1,2,''),
 (304,294,'292/294/304',0,0,'Sierra/Pick-up','','','Y',13,0,'',1,2,''),
 (305,0,'305',0,0,'3rd Brake Lamps','','','Y',167,0,'',1,0,''),
 (306,305,'305/306',115,105,'Cadillac','','','Y',19,0,'',1,0,''),
 (307,305,'305/307',0,0,'Chevrolet','','','Y',62,0,'',1,0,''),
 (308,305,'305/308',0,0,'GMC','','','Y',26,0,'',1,0,''),
 (309,305,'305/309',0,0,'Hummer','','','Y',8,0,'',1,0,''),
 (310,295,'292/295/310',0,0,'H2','','','Y',13,0,'',1,2,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (311,295,'292/295/311',0,0,'H2 SUT','','','Y',7,0,'',1,2,''),
 (312,307,'305/307/312',0,0,'Silverado','','','Y',20,0,'',1,3,''),
 (313,307,'305/307/313',0,0,'Suburban','','','Y',5,0,'',1,1,''),
 (314,307,'305/307/314',0,0,'Tahoe','','','Y',7,0,'',1,2,''),
 (315,307,'305/307/315',0,0,'Avalanche','','','Y',4,0,'',1,0,''),
 (316,307,'305/307/316',0,0,'Blazer S10','','','Y',8,0,'',1,0,''),
 (317,307,'305/307/317',0,0,'S10 Pick-Up','','','Y',5,0,'',1,0,''),
 (318,307,'305/307/318',0,0,'Colorado','','','Y',3,0,'',1,1,''),
 (319,308,'305/308/319',0,0,'Sierra','','','Y',9,0,'',1,3,''),
 (320,308,'305/308/320',0,0,'Suburban','','','Y',26,0,'',1,2,''),
 (321,308,'305/308/321',0,0,'Yukon','','','Y',10,0,'',1,3,''),
 (378,377,'377/378',0,0,'EZStainless','','','Y',55,0,'',1,0,''),
 (377,0,'377',0,0,'Grilles','','','Y',344,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (324,0,'324',0,0,'Sale Items','','','Y',179,100,'',1,0,''),
 (325,0,'325',0,0,'Hidden Hitch','','','Y',50,0,'',1,0,''),
 (326,325,'325/326',0,0,'Chevrolet','','','Y',15,0,'',1,0,''),
 (327,326,'325/326/327',0,0,'Suburban','','','Y',0,0,'',1,2,''),
 (328,326,'325/326/328',0,0,'Tahoe','','','Y',6,0,'',1,2,''),
 (329,325,'325/329',0,0,'GMC','','','Y',5,0,'',1,0,''),
 (330,329,'325/329/330',0,0,'Yukon','','','Y',3,0,'',1,2,''),
 (331,329,'325/329/331',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (332,326,'325/326/332',0,0,'S10 Pick-Up','','','Y',2,0,'',1,1,''),
 (333,329,'325/329/333',0,0,'Sonoma','','','Y',0,0,'',1,1,''),
 (334,326,'325/326/334',0,0,'Silverado','','','Y',4,0,'',1,1,''),
 (335,329,'325/329/335',0,0,'Sierra','','','Y',1,0,'',1,1,''),
 (336,0,'336',0,0,'Roll Pans','','','Y',132,0,'',1,0,''),
 (337,336,'336/337',0,0,'Fiberglass','','','Y',54,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (338,337,'336/337/338',0,0,'Chevrolet','','','Y',29,0,'',1,0,''),
 (339,338,'336/337/338/339',0,0,'Suburban','','','Y',1,0,'',1,2,''),
 (340,338,'336/337/338/340',0,0,'Tahoe','','','Y',1,0,'',1,2,''),
 (381,379,'377/378/379/381',0,0,'Suburban','','','Y',4,0,'',1,9,''),
 (380,379,'377/378/379/380',0,0,'Silverado','','','Y',4,0,'',1,12,''),
 (343,338,'336/337/338/343',0,0,'S10 Pick-Up','','','Y',10,0,'',1,1,''),
 (344,338,'336/337/338/344',0,0,'Colorado','','','Y',2,0,'',1,1,''),
 (345,338,'336/337/338/345',0,0,'Silverado','','','Y',8,0,'',1,2,''),
 (346,337,'336/337/346',0,0,'GMC','','','Y',11,0,'',1,0,''),
 (347,346,'336/337/346/347',0,0,'Sierra','','','Y',4,0,'',1,2,''),
 (348,336,'336/348',0,0,'Steel','','','Y',37,0,'',1,0,''),
 (349,348,'336/348/349',0,0,'Chevrolet','','','Y',27,0,'',1,0,''),
 (350,349,'336/348/349/350',0,0,'Suburban','','','Y',0,0,'',1,2,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (351,349,'336/348/349/351',0,0,'Tahoe','','','Y',7,0,'',1,2,''),
 (379,378,'377/378/379',0,0,'Chevrolet','','','Y',20,0,'',1,0,''),
 (354,349,'336/348/349/354',0,0,'CK Pick-Up','','','Y',10,0,'',1,1,''),
 (355,348,'336/348/355',0,0,'GMC','','','Y',6,0,'',1,0,''),
 (356,355,'336/348/355/356',0,0,'CK Pick-Up','','','Y',2,0,'',1,1,''),
 (357,349,'336/348/349/357',0,0,'S10 Pick-Up','','','Y',6,0,'',1,1,''),
 (358,349,'336/348/349/358',0,0,'Colorado','','','Y',0,0,'',1,1,''),
 (359,349,'336/348/349/359',0,0,'Silverado','','','Y',3,0,'',1,2,''),
 (360,355,'336/348/355/360',0,0,'Sierra','','','Y',1,0,'',1,1,''),
 (361,0,'361',0,0,'Roll Pan Accessories','','','Y',76,0,'',1,0,''),
 (362,361,'361/362',0,0,'Chevrolet','','','Y',20,0,'',1,0,''),
 (363,362,'361/362/363',0,0,'S10 Pick-Up','','','Y',2,0,'',1,1,''),
 (364,362,'361/362/364',0,0,'Colorado','','','Y',0,0,'',1,1,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (365,362,'361/362/365',0,0,'Silverado','','','Y',9,0,'',1,1,''),
 (366,361,'361/366',0,0,'All','','','Y',23,0,'',1,2,''),
 (367,0,'367',0,0,'Hitch Accessories','','','Y',65,0,'',1,0,''),
 (368,367,'367/368',0,0,'Chevrolet','','','Y',23,0,'',1,0,''),
 (369,368,'367/368/369',0,0,'Silverado','','','Y',21,0,'',1,1,''),
 (370,367,'367/370',0,0,'GMC','','','Y',7,0,'',1,0,''),
 (371,370,'367/370/371',0,0,'Sierra','','','Y',6,0,'',1,1,''),
 (372,0,'372',0,0,'Grille Accessories','','','Y',163,0,'',1,0,''),
 (373,372,'372/373',0,0,'GMC','','','Y',34,0,'',1,0,''),
 (374,373,'372/373/374',0,0,'Sierra','','','Y',19,0,'',1,2,''),
 (375,346,'336/337/346/375',0,0,'Yukon','','','Y',1,0,'',1,2,''),
 (376,355,'336/348/355/376',0,0,'Yukon','','','Y',1,0,'',1,1,''),
 (382,379,'377/378/379/382',0,0,'Tahoe','','','Y',2,0,'',1,9,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (383,379,'377/378/379/383',0,0,'Avalanche','','','Y',1,0,'',1,9,''),
 (384,378,'377/378/384',0,0,'GMC','','','Y',7,0,'',1,0,''),
 (385,384,'377/378/384/385',0,0,'Sierra','','','Y',4,0,'',1,30,''),
 (386,384,'377/378/384/386',0,0,'Yukon','','','Y',1,0,'',1,27,''),
 (387,384,'377/378/384/387',0,0,'Envoy','','','Y',0,0,'',1,1,''),
 (390,377,'377/390',0,0,'Wire Mesh','','','Y',44,0,'',1,0,''),
 (391,390,'377/390/391',0,0,'Chevrolet','','','Y',6,0,'',1,0,''),
 (392,391,'377/390/391/392',0,0,'TrailBlazer','','','Y',1,0,'',1,1,''),
 (393,391,'377/390/391/393',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (394,391,'377/390/391/394',0,0,'Suburban','','','Y',0,0,'',1,5,''),
 (395,391,'377/390/391/395',0,0,'Tahoe','','','Y',0,0,'',1,5,''),
 (396,391,'377/390/391/396',0,0,'Silverado','','','Y',3,0,'',1,12,''),
 (397,391,'377/390/391/397',0,0,'Avalanche','','','Y',0,0,'',1,4,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (398,390,'377/390/398',0,0,'GMC','','','Y',7,0,'',1,0,''),
 (399,398,'377/390/398/399',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (400,398,'377/390/398/400',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (401,390,'377/390/401',0,0,'Cadillac','','','Y',6,0,'',1,0,''),
 (402,401,'377/390/401/402',0,0,'Escalade','','','Y',5,0,'',1,7,''),
 (403,401,'377/390/401/403',0,0,'SRX','','','Y',0,0,'',1,3,''),
 (404,398,'377/390/398/404',0,0,'Sierra','','','Y',7,0,'',1,20,''),
 (405,398,'377/390/398/405',0,0,'Yukon','','','Y',0,0,'',1,4,''),
 (406,248,'248/406',0,0,'EZBillet','','','Y',42,0,'',1,0,''),
 (407,406,'248/406/407',0,0,'Chevrolet','','','Y',14,0,'',1,0,''),
 (408,407,'248/406/407/408',0,0,'S10 Pick-Up','','','Y',0,0,'',1,2,''),
 (409,407,'248/406/407/409',0,0,'S10 Blazer','','','Y',5,0,'',1,2,''),
 (410,407,'248/406/407/410',0,0,'TrailBlazer','','','Y',0,0,'',1,8,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (411,407,'248/406/407/411',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (412,407,'248/406/407/412',0,0,'Suburban','','','Y',1,0,'',1,4,''),
 (413,407,'248/406/407/413',0,0,'Tahoe','','','Y',0,0,'',1,4,''),
 (414,407,'248/406/407/414',0,0,'Colorado','','','Y',1,0,'',1,3,''),
 (415,407,'248/406/407/415',0,0,'Silverado','','','Y',4,0,'',1,17,''),
 (416,407,'248/406/407/416',0,0,'Avalanche','','','Y',4,0,'',1,6,''),
 (417,407,'248/406/407/417',0,0,'Equinox','','','Y',0,0,'',1,1,''),
 (418,406,'248/406/418',0,0,'GMC','','','Y',3,0,'',1,0,''),
 (419,418,'248/406/418/419',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (420,418,'248/406/418/420',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (421,418,'248/406/418/421',0,0,'Sierra','','','Y',1,0,'',1,11,''),
 (422,418,'248/406/418/422',0,0,'Yukon','','','Y',5,0,'',1,5,''),
 (423,418,'248/406/418/423',0,0,'Envoy','','','Y',0,0,'',1,1,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (424,248,'248/424',0,0,'In-Pro','','','Y',20,0,'',1,0,''),
 (425,424,'248/424/425',0,0,'Cadillac','','','Y',4,0,'',1,0,''),
 (426,425,'248/424/425/426',0,0,'Escalade','','','Y',2,0,'',1,3,''),
 (427,425,'248/424/425/427',0,0,'SRX','','','Y',1,0,'',1,1,''),
 (428,424,'248/424/428',0,0,'Chevrolet','','','Y',4,0,'',1,0,''),
 (429,428,'248/424/428/429',0,0,'Avalanche','','','Y',0,0,'',1,3,''),
 (430,428,'248/424/428/430',0,0,'Blazer (S10)','','','Y',1,0,'',1,3,''),
 (431,428,'248/424/428/431',0,0,'Colorado','','','Y',0,0,'',1,2,''),
 (432,428,'248/424/428/432',0,0,'S10 Pick-Up','','','Y',0,0,'',1,3,''),
 (433,428,'248/424/428/433',0,0,'Silverado','','','Y',1,0,'',1,9,''),
 (434,428,'248/424/428/434',0,0,'Suburban','','','Y',0,0,'',1,5,''),
 (435,428,'248/424/428/435',0,0,'Tahoe','','','Y',0,0,'',1,6,''),
 (436,428,'248/424/428/436',0,0,'TrailBlazer','','','Y',0,0,'',1,1,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (437,424,'248/424/437',0,0,'GMC','','','Y',1,0,'',1,0,''),
 (438,437,'248/424/437/438',0,0,'Canyon','','','Y',0,0,'',1,1,''),
 (439,437,'248/424/437/439',0,0,'Envoy','','','Y',0,0,'',1,1,''),
 (440,437,'248/424/437/440',0,0,'Jimmy (S15)','','','Y',0,0,'',1,1,''),
 (441,437,'248/424/437/441',0,0,'Sierra','','','Y',0,0,'',1,5,''),
 (442,437,'248/424/437/442',0,0,'Sonoma','','','Y',0,0,'',1,1,''),
 (443,437,'248/424/437/443',0,0,'Yukon','','','Y',1,0,'',1,4,''),
 (465,377,'377/465',0,0,'EZSolid Designer Series','','','Y',51,0,'',1,0,''),
 (466,465,'377/465/466',0,0,'Chevrolet','','','Y',15,0,'',1,0,''),
 (467,466,'377/465/466/467',0,0,'Avalanche','','','Y',4,0,'',1,6,''),
 (468,466,'377/465/466/468',0,0,'Suburban','','','Y',0,0,'',1,3,''),
 (469,466,'377/465/466/469',0,0,'Tahoe','','','Y',0,0,'',1,3,''),
 (470,466,'377/465/466/470',0,0,'Silverado','','','Y',8,0,'',1,18,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (471,465,'377/465/471',0,0,'GMC','','','Y',12,0,'',1,0,''),
 (472,471,'377/465/471/472',0,0,'Sierra','','','Y',14,0,'',1,32,''),
 (473,471,'377/465/471/473',0,0,'Yukon','','','Y',4,0,'',1,13,''),
 (474,248,'248/474',0,0,'Classic Billet','','','Y',47,0,'',1,0,''),
 (475,474,'248/474/475',0,0,'Chevrolet','','','Y',13,0,'',1,0,''),
 (476,475,'248/474/475/476',0,0,'TrailBlazer','','','Y',0,0,'',1,1,''),
 (477,475,'248/474/475/477',0,0,'CK Pick-Up','','','Y',1,0,'',1,3,''),
 (478,475,'248/474/475/478',0,0,'Suburban','','','Y',0,0,'',1,7,''),
 (479,475,'248/474/475/479',0,0,'Tahoe','','','Y',2,0,'',1,7,''),
 (480,475,'248/474/475/480',0,0,'Colorado','','','Y',0,0,'',1,6,''),
 (481,475,'248/474/475/481',0,0,'Silverado','','','Y',2,0,'',1,18,''),
 (482,475,'248/474/475/482',0,0,'Avalanche','','','Y',1,0,'',1,4,''),
 (483,475,'248/474/475/483',0,0,'Kodiak','','','Y',0,0,'',1,3,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (484,474,'248/474/484',0,0,'GMC','','','Y',15,0,'',1,0,''),
 (497,0,'497',0,0,'Billet Accessories','','','Y',177,0,'',1,0,''),
 (486,484,'248/474/484/486',0,0,'S15 Jimmy','','','Y',0,0,'',1,1,''),
 (487,484,'248/474/484/487',0,0,'S15 Pick-Up','','','Y',2,0,'',1,1,''),
 (488,484,'248/474/484/488',0,0,'Envoy','','','Y',1,0,'',1,2,''),
 (489,484,'248/474/484/489',0,0,'Canyon','','','Y',0,0,'',1,1,''),
 (490,484,'248/474/484/490',0,0,'CK Pick-Up','','','Y',2,0,'',1,6,''),
 (491,484,'248/474/484/491',0,0,'Suburban','','','Y',0,0,'',1,6,''),
 (492,484,'248/474/484/492',0,0,'Yukon','','','Y',1,0,'',1,12,''),
 (493,474,'248/474/493',0,0,'Cadillac','','','Y',5,0,'',1,0,''),
 (494,493,'248/474/493/494',0,0,'Escalade','','','Y',2,0,'',1,4,''),
 (495,484,'248/474/484/495',0,0,'Sierra','','','Y',5,0,'',1,15,''),
 (496,484,'248/474/484/496',0,0,'Sonoma','','','Y',0,0,'',1,1,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (498,497,'497/498',0,0,'License Plate Frames','','','Y',18,0,'',1,2,''),
 (499,248,'248/499',0,0,'PHAT Billet','','','Y',26,0,'',1,0,''),
 (500,499,'248/499/500',0,0,'Chevrolet','','','Y',9,0,'',1,0,''),
 (501,500,'248/499/500/501',0,0,'CK Pick-Up','','','Y',1,0,'',1,1,''),
 (502,500,'248/499/500/502',0,0,'Suburban','','','Y',0,0,'',1,4,''),
 (503,500,'248/499/500/503',0,0,'Tahoe','','','Y',0,0,'',1,4,''),
 (504,500,'248/499/500/504',0,0,'Silverado','','','Y',1,0,'',1,7,''),
 (505,500,'248/499/500/505',0,0,'Avalanche','','','Y',0,0,'',1,3,''),
 (506,500,'248/499/500/506',0,0,'Kodiak','','','Y',1,0,'',1,2,''),
 (507,499,'248/499/507',0,0,'GMC','','','Y',7,0,'',1,0,''),
 (508,507,'248/499/507/508',0,0,'CK Pick-Up','','','Y',3,0,'',1,1,''),
 (509,507,'248/499/507/509',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (510,507,'248/499/507/510',0,0,'Sierra','','','Y',0,0,'',1,6,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (511,507,'248/499/507/511',0,0,'Yukon','','','Y',1,0,'',1,2,''),
 (512,248,'248/512',0,0,'Stainless Face Billet','','','Y',20,0,'',1,0,''),
 (513,512,'248/512/513',0,0,'Chevrolet','','','Y',5,0,'',1,0,''),
 (514,513,'248/512/513/514',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (515,513,'248/512/513/515',0,0,'Suburban','','','Y',0,0,'',1,4,''),
 (516,513,'248/512/513/516',0,0,'Tahoe','','','Y',2,0,'',1,5,''),
 (517,513,'248/512/513/517',0,0,'Avalanche','','','Y',0,0,'',1,3,''),
 (518,513,'248/512/513/518',0,0,'Silverado','','','Y',0,0,'',1,4,''),
 (519,512,'248/512/519',0,0,'GMC','','','Y',4,0,'',1,0,''),
 (520,519,'248/512/519/520',0,0,'CK Pick-Up','','','Y',4,0,'',1,1,''),
 (521,519,'248/512/519/521',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (522,519,'248/512/519/522',0,0,'Sierra','','','Y',1,0,'',1,4,''),
 (523,519,'248/512/519/523',0,0,'Yukon','','','Y',0,0,'',1,1,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (524,248,'248/524',0,0,'Vertical Billet','','','Y',10,0,'',1,0,''),
 (525,524,'248/524/525',0,0,'Chevrolet','','','Y',1,0,'',1,0,''),
 (526,525,'248/524/525/526',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (527,525,'248/524/525/527',0,0,'Suburban','','','Y',0,0,'',1,5,''),
 (528,525,'248/524/525/528',0,0,'Tahoe','','','Y',0,0,'',1,5,''),
 (529,525,'248/524/525/529',0,0,'Colorado','','','Y',0,0,'',1,1,''),
 (530,525,'248/524/525/530',0,0,'Silverado','','','Y',2,0,'',1,11,''),
 (531,525,'248/524/525/531',0,0,'Avalanche','','','Y',0,0,'',1,4,''),
 (532,524,'248/524/532',0,0,'GMC','','','Y',1,0,'',1,0,''),
 (533,532,'248/524/532/533',0,0,'Canyon','','','Y',0,0,'',1,1,''),
 (534,532,'248/524/532/534',0,0,'CK Pick-Up','','','Y',0,0,'',1,1,''),
 (535,532,'248/524/532/535',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (536,524,'248/524/536',0,0,'Cadillac','','','Y',0,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (537,536,'248/524/536/537',0,0,'Escalade','','','Y',0,0,'',1,2,''),
 (538,532,'248/524/532/538',0,0,'Sierra','','','Y',1,0,'',1,6,''),
 (539,532,'248/524/532/539',0,0,'Yukon','','','Y',0,0,'',1,2,''),
 (540,524,'248/524/540',0,0,'Hummer','','','Y',1,0,'',1,0,''),
 (541,540,'248/524/540/541',0,0,'H2','','','Y',0,0,'',1,1,''),
 (542,540,'248/524/540/542',0,0,'H3','','','Y',1,0,'',1,1,''),
 (543,497,'497/543',0,0,'Hooks','','','Y',17,0,'',1,0,''),
 (552,549,'248/549/552',0,0,'Chevrolet','','','Y',2,0,'',1,0,''),
 (549,248,'248/549',0,0,'AMI','','','Y',10,0,'',1,0,''),
 (550,549,'248/549/550',0,0,'GMC','','','Y',2,0,'',1,0,''),
 (551,550,'248/549/550/551',0,0,'Sierra','','','Y',1,0,'',1,1,''),
 (547,543,'497/543/547',0,0,'Universal','','','Y',6,0,'',1,1,''),
 (554,543,'497/543/554',0,0,'Chevrolet','','','Y',4,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (553,552,'248/549/552/553',0,0,'Silverado','','','Y',2,0,'',1,1,''),
 (555,554,'497/543/554/555',0,0,'Silverado','','','Y',3,0,'',1,3,''),
 (556,543,'497/543/556',0,0,'GMC','','','Y',1,0,'',1,0,''),
 (557,556,'497/543/556/557',0,0,'Sierra','','','Y',1,0,'',1,3,''),
 (558,554,'497/543/554/558',0,0,'Tahoe','','','Y',1,0,'',1,1,''),
 (559,556,'497/543/556/559',0,0,'Yukon','','','Y',0,0,'',1,1,''),
 (563,560,'497/560/563',0,0,'GMC','','','Y',2,0,'',1,0,''),
 (564,563,'497/560/563/564',0,0,'Sierra','','','Y',1,0,'',1,14,''),
 (565,561,'497/560/561/565',0,0,'Tahoe','','','Y',0,0,'',1,8,''),
 (566,563,'497/560/563/566',0,0,'Yukon','','','Y',0,0,'',1,8,''),
 (567,561,'497/560/561/567',0,0,'Avalanche','','','Y',2,0,'',1,8,''),
 (568,497,'497/568',0,0,'Pedal Pads','','','Y',20,0,'',1,0,''),
 (573,497,'497/573',0,0,'Door Handles','','','Y',43,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (607,580,'497/573/580/607',0,0,'Cadillac','','','Y',0,0,'',1,0,''),
 (608,607,'497/573/580/607/608',0,0,'Escalade','','','Y',0,0,'',1,16,''),
 (604,581,'497/573/580/581/604',0,0,'Tahoe','','','Y',4,0,'',1,16,''),
 (572,571,'497/568/571/572',0,0,'Yukon','','','Y',1,0,'',1,4,''),
 (562,561,'497/560/561/562',0,0,'Silverado','','','Y',3,0,'',1,14,''),
 (609,577,'497/573/577/609',0,0,'Chevrolet','','','Y',4,0,'',1,0,''),
 (610,609,'497/573/577/609/610',0,0,'Silverado','','','Y',1,0,'',1,3,''),
 (611,577,'497/573/577/611',0,0,'GMC','','','Y',0,0,'',1,0,''),
 (612,611,'497/573/577/611/612',0,0,'Sierra','','','Y',0,0,'',1,3,''),
 (613,609,'497/573/577/609/613',0,0,'Tahoe','','','Y',0,0,'',1,5,''),
 (614,611,'497/573/577/611/614',0,0,'Yukon','','','Y',0,0,'',1,5,''),
 (615,609,'497/573/577/609/615',0,0,'Avalanche','','','Y',1,0,'',1,5,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (616,577,'497/573/577/616',0,0,'Cadillac','','','Y',1,0,'',1,0,''),
 (617,616,'497/573/577/616/617',0,0,'Escalade','','','Y',0,0,'',1,5,''),
 (618,598,'497/594/598/618',0,0,'Chevrolet','','','Y',3,0,'',1,0,''),
 (619,618,'497/594/598/618/619',0,0,'Silverado','','','Y',5,0,'',1,3,''),
 (620,595,'497/594/595/620',0,0,'GMC','','','Y',2,0,'',1,0,''),
 (621,620,'497/594/595/620/621',0,0,'Sierra','','','Y',1,0,'',1,2,''),
 (622,594,'497/594/622',0,0,'Buckets','','','Y',3,0,'',1,0,''),
 (623,622,'497/594/622/623',0,0,'Chevrolet','','','Y',2,0,'',1,0,''),
 (624,623,'497/594/622/623/624',0,0,'Suburban','','','Y',1,0,'',1,1,''),
 (625,581,'497/573/580/581/625',0,0,'Kodiak','','','Y',1,0,'',1,2,''),
 (626,618,'497/594/598/618/626',0,0,'Suburban','','','Y',0,0,'',1,1,''),
 (627,596,'497/594/595/596/627',0,0,'Tahoe','','','Y',0,0,'',1,1,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (628,620,'497/594/595/620/628',0,0,'Yukon','','','Y',0,0,'',1,1,''),
 (629,618,'497/594/598/618/629',0,0,'Tahoe','','','Y',0,0,'',1,1,''),
 (630,599,'497/594/598/599/630',0,0,'Yukon','','','Y',0,0,'',1,1,''),
 (631,585,'497/573/574/585/631',0,0,'Colorado','','','Y',0,0,'',1,3,''),
 (632,587,'497/573/574/587/632',0,0,'Canyon','','','Y',0,0,'',1,3,''),
 (633,607,'497/573/580/607/633',0,0,'SRX','','','Y',0,0,'',1,7,''),
 (634,497,'497/634',0,0,'Fuel Doors','','','Y',11,0,'',1,0,''),
 (635,634,'497/634/635',0,0,'Chevrolet','','','Y',5,0,'',1,0,''),
 (636,635,'497/634/635/636',0,0,'Tahoe','','','Y',0,0,'',1,6,''),
 (637,635,'497/634/635/637',0,0,'S10 Blazer','','','Y',0,0,'',1,4,''),
 (638,635,'497/634/635/638',0,0,'Suburban','','','Y',0,0,'',1,4,''),
 (639,635,'497/634/635/639',0,0,'Avalanche','','','Y',0,0,'',1,6,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (640,634,'497/634/640',0,0,'Cadillac','','','Y',0,0,'',1,0,''),
 (641,640,'497/634/640/641',0,0,'Escalade','','','Y',0,0,'',1,12,''),
 (642,634,'497/634/642',0,0,'Hummer','','','Y',0,0,'',1,0,''),
 (643,642,'497/634/642/643',0,0,'H2','','','Y',0,0,'',1,4,''),
 (644,635,'497/634/635/644',0,0,'S10 Pick-Up','','','Y',0,0,'',1,2,''),
 (645,634,'497/634/645',0,0,'GMC','','','Y',1,0,'',1,0,''),
 (646,645,'497/634/645/646',0,0,'S15 Pick-Up','','','Y',0,0,'',1,2,''),
 (647,635,'497/634/635/647',0,0,'Trailblazer','','','Y',0,0,'',1,2,''),
 (648,645,'497/634/645/648',0,0,'Envoy','','','Y',0,0,'',1,2,''),
 (649,635,'497/634/635/649',0,0,'SSR','','','Y',0,0,'',1,2,''),
 (650,635,'497/634/635/650',0,0,'Colorado','','','Y',1,0,'',1,2,''),
 (651,645,'497/634/645/651',0,0,'Canyon','','','Y',0,0,'',1,2,''),
 (652,642,'497/634/642/652',0,0,'H3','','','Y',0,0,'',1,4,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (653,645,'497/634/645/653',0,0,'Yukon','','','Y',1,0,'',1,2,''),
 (654,635,'497/634/635/654',0,0,'Silverado','','','Y',2,0,'',1,2,''),
 (655,645,'497/634/645/655',0,0,'Sierra','','','Y',0,0,'',1,2,''),
 (656,377,'377/656',0,0,'Complete Grilles','','','Y',110,0,'',1,0,''),
 (657,656,'377/656/657',0,0,'Chevrolet','','','Y',44,0,'',1,0,''),
 (658,657,'377/656/657/658',0,0,'Silverado','','','Y',26,0,'',1,1,''),
 (659,0,'659',0,0,'Floor Mats/Interior','','','Y',33,0,'',1,0,''),
 (736,731,'730/731/736',0,0,'Non-Locking Pins','','','Y',0,0,'',1,3,''),
 (737,730,'730/737',0,0,'Coupler Locks','','','Y',0,0,'',1,0,''),
 (738,737,'730/737/738',0,0,'Universal Unattended Trailer Locks','','','Y',0,0,'',1,2,''),
 (739,737,'730/737/739',0,0,'Coupler Lever Locks','','','Y',0,0,'',1,4,''),
 (740,737,'730/737/740',0,0,'Keyed-Alike Receiver & Coupler Lock Sets','','','Y',0,0,'',1,8,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (741,730,'730/741',0,0,'Cable Locks','','','Y',2,0,'',1,0,''),
 (742,741,'730/741/742',0,0,'Multi-Use Cable Locking Systems','','','Y',0,0,'',1,4,''),
 (743,741,'730/741/743',0,0,'Spare Tire Cable Locks','','','Y',0,0,'',1,2,''),
 (744,730,'730/744',0,0,'Cables','','','Y',2,0,'',1,0,''),
 (745,744,'730/744/745',0,0,'TRIMFLEX Quadra-Braid Dual Loop Cables','','','Y',2,0,'',1,1,''),
 (746,741,'730/741/746',0,0,'IRONCLAD Series Armored Cables','','','Y',2,0,'',1,1,''),
 (747,741,'730/741/747',0,0,'TRIMAFLEX Cable Locks','','','Y',1,0,'',1,7,''),
 (748,730,'730/748',0,0,'Motorcycle Cables & Locks','','','Y',1,0,'',1,4,''),
 (749,730,'730/749',0,0,'Cable Locks/U-Locks','','','Y',2,0,'',1,0,''),
 (750,749,'730/749/750',0,0,'PVC Coated','','','Y',1,0,'',1,2,''),
 (751,730,'730/751',0,0,'U-Locks','','','Y',3,0,'',1,0,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (752,751,'730/751/752',0,0,'Large Shackle','','','Y',1,0,'',1,4,''),
 (753,730,'730/753',0,0,'Chains','','','Y',0,0,'',1,0,''),
 (754,753,'730/753/754',0,0,'T-HEX','','','Y',0,0,'',1,1,''),
 (755,754,'730/753/754/755',0,0,'Chain and Lock Sets','','','Y',0,0,'',1,2,''),
 (756,754,'730/753/754/756',0,0,'Chain and Lock Integrated','','','Y',0,0,'',1,1,''),
 (757,730,'730/757',0,0,'Pad Locks','','','Y',0,0,'',1,0,''),
 (758,757,'730/757/758',0,0,'Keyed','','','Y',0,0,'',1,10,''),
 (759,758,'730/757/758/759',0,0,'Marine Grade & Weather Proof','','','Y',0,0,'',1,7,''),
 (760,757,'730/757/760',0,0,'Combination','','','Y',0,0,'',1,2,''),
 (761,730,'730/761',0,0,'Water Craft Cables & Locks','','','Y',0,0,'',1,2,''),
 (762,730,'730/762',0,0,'Wall & Floor Anchors','','','Y',0,0,'',1,1,''),
 (763,730,'730/763',0,0,'Wheel Locks','','','Y',2,0,'',1,3,'');
INSERT INTO `xcart_categories` (`categoryid`,`parentid`,`categoryid_path`,`image_x`,`image_y`,`category`,`description`,`meta_descr`,`avail`,`views_stats`,`order_by`,`membership`,`threshold_bestsellers`,`product_count`,`meta_keywords`) VALUES 
 (764,730,'730/764',0,0,'Fifth Wheel Trailer Locks','','','Y',0,0,'',1,1,''),
 (765,751,'730/751/765',0,0,'PVC Coated','','','Y',1,0,'',1,2,''),
 (735,731,'730/731/735',0,0,'Anti-Rattle  Locking Pins','','','Y',0,0,'',1,1,''),
 (734,731,'730/731/734',0,0,'Universal Locking Pins','','','Y',0,0,'',1,2,''),
 (733,731,'730/731/733',0,0,'Stainless Steel Locking Pins','','','Y',0,0,'',1,2,''),
 (732,731,'730/731/732',0,0,'Locking Pins','','','Y',6,0,'',1,7,''),
 (731,730,'730/731',0,0,'Receiver Pins','','','Y',2,0,'',1,0,''),
 (730,0,'730',0,0,'Locks/Security','','','Y',12,0,'',1,0,'');
/*!40000 ALTER TABLE `xcart_categories` ENABLE KEYS */;


--
-- Definition of table `xcart_categories_lng`
--

DROP TABLE IF EXISTS `xcart_categories_lng`;
CREATE TABLE `xcart_categories_lng` (
  `code` char(2) NOT NULL default '',
  `categoryid` int(11) NOT NULL default '0',
  `category` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`code`,`categoryid`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_categories_lng`
--

/*!40000 ALTER TABLE `xcart_categories_lng` DISABLE KEYS */;
/*!40000 ALTER TABLE `xcart_categories_lng` ENABLE KEYS */;


--
-- Definition of table `xcart_categories_subcount`
--

DROP TABLE IF EXISTS `xcart_categories_subcount`;
CREATE TABLE `xcart_categories_subcount` (
  `categoryid` int(11) NOT NULL default '0',
  `subcategory_count` int(11) NOT NULL default '0',
  `product_count` int(11) NOT NULL default '0',
  `membership` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`categoryid`,`membership`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_categories_subcount`
--

/*!40000 ALTER TABLE `xcart_categories_subcount` DISABLE KEYS */;
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (254,0,0,'DeLillo Friends'),
 (2,0,0,'Premium'),
 (2,0,0,'Wholesale'),
 (2,0,0,''),
 (3,0,0,'Premium'),
 (3,0,0,'Wholesale'),
 (3,0,0,''),
 (4,0,0,'Premium'),
 (4,0,0,'Wholesale'),
 (4,0,0,''),
 (5,0,0,'Wholesale'),
 (5,0,0,'Premium'),
 (6,0,0,'Wholesale'),
 (6,0,0,'Premium'),
 (7,0,0,'Wholesale'),
 (7,0,0,'Premium'),
 (8,0,0,'Wholesale'),
 (8,0,0,'Premium'),
 (9,0,0,'Wholesale'),
 (9,0,0,'Premium'),
 (10,0,0,'Wholesale'),
 (10,0,0,'Premium'),
 (11,0,0,'Wholesale'),
 (11,0,0,'Premium'),
 (12,0,0,'Premium'),
 (12,0,0,'Wholesale'),
 (12,0,0,''),
 (13,0,0,'Wholesale'),
 (13,0,0,'Premium'),
 (14,0,0,'Premium'),
 (14,0,0,'Wholesale'),
 (14,0,0,''),
 (15,0,0,'Premium'),
 (15,0,0,'Wholesale'),
 (15,0,0,''),
 (16,0,0,'Wholesale'),
 (16,0,0,'Premium'),
 (17,0,0,'Wholesale'),
 (17,0,0,'Premium'),
 (18,0,0,'Wholesale'),
 (18,0,0,'Premium'),
 (19,0,0,'Wholesale'),
 (19,0,0,'Premium'),
 (20,0,0,'Wholesale'),
 (20,0,0,'Premium');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (448,0,4,'Wholesale'),
 (22,0,0,'Premium'),
 (22,0,0,'Wholesale'),
 (22,0,0,''),
 (23,0,0,'Wholesale'),
 (23,0,0,'Premium'),
 (24,0,0,'Wholesale'),
 (24,0,0,'Premium'),
 (25,0,0,'Wholesale'),
 (25,0,0,'Premium'),
 (26,0,0,'Premium'),
 (26,0,0,'Wholesale'),
 (26,0,0,''),
 (27,0,0,'Premium'),
 (27,0,0,'Wholesale'),
 (27,1,0,''),
 (28,0,0,'Premium'),
 (28,0,0,'Wholesale'),
 (28,0,0,''),
 (129,0,0,'Wholesale'),
 (29,0,1,'Premium'),
 (29,0,1,'Wholesale'),
 (29,0,1,''),
 (30,0,1,'Premium'),
 (30,0,1,'Wholesale'),
 (30,0,1,''),
 (273,0,0,'Employees'),
 (31,0,2,'Premium'),
 (31,0,2,'Wholesale'),
 (31,0,2,''),
 (137,0,0,''),
 (32,0,1,'Premium'),
 (32,0,1,'Wholesale'),
 (32,0,1,''),
 (33,0,0,'Wholesale'),
 (33,0,0,'Premium'),
 (143,0,0,'Wholesale'),
 (34,0,0,'Wholesale'),
 (34,0,0,'Premium'),
 (271,0,0,'Employees'),
 (35,0,0,'Wholesale'),
 (35,0,0,'Premium'),
 (24,0,0,''),
 (36,0,0,'Premium'),
 (36,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (36,3,0,''),
 (37,0,0,'Premium'),
 (37,0,0,'Wholesale'),
 (37,0,0,''),
 (141,0,0,'Premium'),
 (38,0,0,'Premium'),
 (38,0,0,'Wholesale'),
 (38,0,0,''),
 (47,0,0,''),
 (141,0,0,''),
 (39,0,0,'Wholesale'),
 (39,0,0,'Premium'),
 (274,0,8,'DeLillo Friends'),
 (40,0,0,'Premium'),
 (40,0,0,'Wholesale'),
 (40,0,0,''),
 (142,0,0,'Premium'),
 (41,0,0,'Premium'),
 (41,0,0,'Wholesale'),
 (41,0,0,''),
 (129,0,0,''),
 (42,0,0,'Premium'),
 (42,0,0,'Wholesale'),
 (42,0,0,''),
 (142,0,0,''),
 (43,0,0,'Wholesale'),
 (43,0,0,'Premium'),
 (18,0,0,''),
 (34,0,0,''),
 (44,0,0,'Premium'),
 (44,0,0,'Wholesale'),
 (44,0,0,''),
 (45,0,0,'Wholesale'),
 (45,0,0,'Premium'),
 (46,0,0,'Premium'),
 (46,0,0,'Wholesale'),
 (46,0,0,''),
 (47,0,0,'Wholesale'),
 (47,0,0,'Premium'),
 (273,7,0,''),
 (48,0,0,'Wholesale'),
 (48,0,0,'Premium'),
 (49,0,0,'Wholesale'),
 (49,0,0,'Premium'),
 (48,0,0,''),
 (50,0,0,'Premium'),
 (50,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (50,0,0,''),
 (51,0,0,'Wholesale'),
 (51,0,0,'Premium'),
 (52,0,0,'Premium'),
 (52,0,0,'Wholesale'),
 (52,0,0,''),
 (142,0,0,'Wholesale'),
 (51,0,0,''),
 (54,0,0,'Premium'),
 (444,0,0,'Premium'),
 (252,0,0,''),
 (145,0,0,''),
 (54,0,0,'Wholesale'),
 (54,0,0,''),
 (141,0,0,'Wholesale'),
 (55,0,0,'Premium'),
 (55,0,0,'Wholesale'),
 (55,0,0,''),
 (56,0,0,'Premium'),
 (56,0,0,'Wholesale'),
 (56,0,0,''),
 (57,0,0,'Premium'),
 (57,0,0,'Wholesale'),
 (57,0,0,''),
 (58,0,0,'Premium'),
 (58,0,0,'Wholesale'),
 (58,0,0,''),
 (59,0,0,'Premium'),
 (59,0,0,'Wholesale'),
 (59,0,0,''),
 (60,0,0,'Premium'),
 (60,0,0,'Wholesale'),
 (60,0,0,''),
 (61,0,0,'Premium'),
 (61,0,0,'Wholesale'),
 (61,0,0,''),
 (62,0,0,'Premium'),
 (62,0,0,'Wholesale'),
 (62,0,0,''),
 (63,0,0,'Premium'),
 (63,0,0,'Wholesale'),
 (63,0,0,''),
 (64,0,0,'Premium'),
 (64,0,0,'Wholesale'),
 (64,0,0,''),
 (65,0,0,'Premium'),
 (65,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (65,0,0,''),
 (66,0,0,'Premium'),
 (66,0,0,'Wholesale'),
 (66,0,0,''),
 (67,0,0,'Premium'),
 (67,0,0,'Wholesale'),
 (67,0,0,''),
 (68,0,0,'Premium'),
 (68,0,0,'Wholesale'),
 (68,0,0,''),
 (69,0,0,'Premium'),
 (69,0,0,'Wholesale'),
 (69,0,0,''),
 (70,0,0,'Premium'),
 (70,0,0,'Wholesale'),
 (70,0,0,''),
 (71,0,0,'Premium'),
 (71,0,0,'Wholesale'),
 (71,0,0,''),
 (72,0,0,'Premium'),
 (72,0,0,'Wholesale'),
 (72,0,0,''),
 (73,0,0,'Premium'),
 (73,0,0,'Wholesale'),
 (73,0,0,''),
 (74,0,0,'Premium'),
 (74,0,0,'Wholesale'),
 (74,0,0,''),
 (75,0,0,'Premium'),
 (75,0,0,'Wholesale'),
 (75,0,0,''),
 (76,0,0,'Premium'),
 (76,0,0,'Wholesale'),
 (76,0,0,''),
 (77,0,0,'Premium'),
 (77,0,0,'Wholesale'),
 (77,0,0,''),
 (78,0,0,'Premium'),
 (78,0,0,'Wholesale'),
 (78,0,0,''),
 (79,0,0,'Premium'),
 (79,0,0,'Wholesale'),
 (79,0,0,''),
 (80,0,0,'Premium'),
 (80,0,0,'Wholesale'),
 (80,0,0,''),
 (81,0,0,'Premium'),
 (81,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (81,0,0,''),
 (82,0,0,'Premium'),
 (82,0,0,'Wholesale'),
 (82,0,0,''),
 (83,0,0,'Premium'),
 (83,0,0,'Wholesale'),
 (83,0,0,''),
 (84,0,0,'Premium'),
 (84,0,0,'Wholesale'),
 (84,0,0,''),
 (85,0,0,'Premium'),
 (85,0,0,'Wholesale'),
 (85,0,0,''),
 (86,0,0,'Premium'),
 (86,0,0,'Wholesale'),
 (86,0,0,''),
 (87,0,0,'Premium'),
 (87,0,0,'Wholesale'),
 (87,0,0,''),
 (88,0,0,'Premium'),
 (88,0,0,'Wholesale'),
 (88,0,0,''),
 (89,0,0,'Premium'),
 (89,0,0,'Wholesale'),
 (89,0,0,''),
 (90,0,0,'Premium'),
 (90,0,0,'Wholesale'),
 (90,0,0,''),
 (91,0,0,'Premium'),
 (91,0,0,'Wholesale'),
 (91,0,0,''),
 (92,0,0,'Premium'),
 (92,0,0,'Wholesale'),
 (92,0,0,''),
 (93,0,0,'Premium'),
 (93,0,0,'Wholesale'),
 (93,0,0,''),
 (94,0,0,'Premium'),
 (94,0,0,'Wholesale'),
 (94,0,0,''),
 (95,0,0,'Premium'),
 (95,0,0,'Wholesale'),
 (95,0,0,''),
 (96,0,0,'Premium'),
 (96,0,0,'Wholesale'),
 (96,0,0,''),
 (97,0,0,'Premium'),
 (97,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (97,0,0,''),
 (98,0,0,'Premium'),
 (98,0,0,'Wholesale'),
 (98,0,0,''),
 (99,0,0,'Premium'),
 (99,0,0,'Wholesale'),
 (99,0,0,''),
 (100,0,0,'Premium'),
 (100,0,0,'Wholesale'),
 (100,0,0,''),
 (101,0,0,'Premium'),
 (101,0,0,'Wholesale'),
 (101,0,0,''),
 (102,0,0,'Premium'),
 (102,0,0,'Wholesale'),
 (102,0,0,''),
 (103,0,0,'Premium'),
 (103,0,0,'Wholesale'),
 (103,0,0,''),
 (104,0,0,'Premium'),
 (104,0,0,'Wholesale'),
 (104,0,0,''),
 (105,0,0,'Premium'),
 (105,0,0,'Wholesale'),
 (105,0,0,''),
 (106,0,0,'Premium'),
 (106,0,0,'Wholesale'),
 (106,0,0,''),
 (107,0,0,'Premium'),
 (107,0,0,'Wholesale'),
 (107,0,0,''),
 (108,0,0,'Premium'),
 (108,0,0,'Wholesale'),
 (108,0,0,''),
 (109,0,0,'Premium'),
 (109,0,0,'Wholesale'),
 (109,0,0,''),
 (110,0,0,'Premium'),
 (110,0,0,'Wholesale'),
 (110,0,0,''),
 (111,0,0,'Premium'),
 (111,0,0,'Wholesale'),
 (111,0,0,''),
 (112,0,0,'Premium'),
 (112,0,0,'Wholesale'),
 (112,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (113,0,0,'Premium'),
 (113,0,0,'Wholesale'),
 (113,0,0,''),
 (114,0,0,'Premium'),
 (114,0,0,'Wholesale'),
 (114,0,0,''),
 (115,0,0,'Premium'),
 (115,0,0,'Wholesale'),
 (115,0,0,''),
 (116,0,0,'Premium'),
 (116,0,0,'Wholesale'),
 (116,0,0,''),
 (117,0,0,'Premium'),
 (117,0,0,'Wholesale'),
 (117,0,0,''),
 (118,0,0,'Premium'),
 (118,0,0,'Wholesale'),
 (118,0,0,''),
 (119,0,0,'Premium'),
 (119,0,0,'Wholesale'),
 (119,0,0,''),
 (120,0,0,'Premium'),
 (120,0,0,'Wholesale'),
 (120,0,0,''),
 (121,0,0,'Premium'),
 (121,0,0,'Wholesale'),
 (121,0,0,''),
 (122,0,0,'Premium'),
 (122,0,0,'Wholesale'),
 (122,0,0,''),
 (123,0,0,'Premium'),
 (123,0,0,'Wholesale'),
 (123,0,0,''),
 (124,0,0,'Premium'),
 (124,0,0,'Wholesale'),
 (124,0,0,''),
 (125,0,0,'Premium'),
 (125,0,0,'Wholesale'),
 (125,0,0,''),
 (126,0,0,'Premium'),
 (126,0,0,'Wholesale'),
 (126,0,0,''),
 (127,0,0,'Premium'),
 (127,0,0,'Wholesale'),
 (127,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (128,0,0,'Premium'),
 (128,0,0,'Wholesale'),
 (128,0,0,''),
 (129,0,0,'Premium'),
 (130,0,0,'Wholesale'),
 (130,0,0,'Premium'),
 (131,0,0,'Wholesale'),
 (131,0,0,'Premium'),
 (132,0,0,'Premium'),
 (132,0,0,'Wholesale'),
 (132,0,0,''),
 (133,0,0,'Wholesale'),
 (133,0,0,'Premium'),
 (134,0,0,'Premium'),
 (134,0,0,'Wholesale'),
 (134,0,0,''),
 (135,0,0,'Premium'),
 (135,0,0,'Wholesale'),
 (135,0,0,''),
 (136,0,0,'Wholesale'),
 (136,0,0,'Premium'),
 (137,0,0,'Wholesale'),
 (137,0,0,'Premium'),
 (138,0,0,'Wholesale'),
 (138,0,0,'Premium'),
 (139,0,0,'Wholesale'),
 (139,0,0,'Premium'),
 (140,0,0,'Wholesale'),
 (140,0,0,'Premium'),
 (143,0,0,'Premium'),
 (144,0,0,'Wholesale'),
 (144,0,0,'Premium'),
 (145,0,0,'Wholesale'),
 (145,0,0,'Premium'),
 (146,0,0,'Premium'),
 (146,0,0,'Wholesale'),
 (146,0,0,''),
 (456,0,0,''),
 (457,0,0,'Premium'),
 (148,0,0,'Wholesale'),
 (148,0,0,'Premium'),
 (149,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (149,0,0,'Premium'),
 (133,0,0,''),
 (449,0,11,'Employees'),
 (148,0,0,''),
 (149,0,0,''),
 (139,0,0,''),
 (140,0,0,''),
 (138,0,0,''),
 (454,0,9,'DeLillo Friends'),
 (454,0,9,'Employees'),
 (446,0,1,''),
 (144,0,0,''),
 (143,0,0,''),
 (271,0,0,'Wholesale'),
 (25,0,0,''),
 (35,0,0,''),
 (448,0,4,'Premium'),
 (49,0,0,''),
 (45,0,0,''),
 (271,0,0,'DeLillo Friends'),
 (250,0,0,'Employees'),
 (250,0,0,'DeLillo Friends'),
 (250,0,0,'Premium'),
 (250,0,0,'Wholesale'),
 (136,0,0,''),
 (130,0,0,''),
 (131,0,0,''),
 (274,0,8,'Employees'),
 (43,0,0,''),
 (23,0,0,''),
 (16,0,0,''),
 (33,0,0,''),
 (7,0,0,''),
 (9,0,0,''),
 (8,0,0,''),
 (19,0,0,''),
 (20,0,0,''),
 (17,0,0,''),
 (13,0,0,''),
 (39,0,0,''),
 (5,0,0,''),
 (11,0,0,''),
 (10,0,0,''),
 (275,0,5,'Wholesale'),
 (6,0,0,''),
 (270,0,0,'DeLillo Friends'),
 (270,0,0,'Wholesale'),
 (447,0,4,''),
 (446,0,1,'Employees'),
 (446,0,1,'DeLillo Friends'),
 (163,0,1,'Premium');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (163,0,1,'Wholesale'),
 (163,0,1,''),
 (456,0,0,'Employees'),
 (456,0,0,'Premium'),
 (456,0,0,'Wholesale'),
 (251,0,0,''),
 (251,0,0,'Premium'),
 (251,0,0,'Wholesale'),
 (251,0,0,'DeLillo Friends'),
 (170,0,0,'Wholesale'),
 (170,0,0,'Premium'),
 (445,0,0,'Premium'),
 (445,0,0,'Wholesale'),
 (271,0,0,'Premium'),
 (270,21,0,''),
 (174,0,0,'Employees'),
 (173,0,0,'Wholesale'),
 (173,0,0,'Premium'),
 (174,0,0,'Premium'),
 (455,0,4,''),
 (455,0,4,'Premium'),
 (455,0,4,'Wholesale'),
 (455,0,4,'DeLillo Friends'),
 (276,0,9,'DeLillo Friends'),
 (178,0,0,'Wholesale'),
 (178,0,0,'Premium'),
 (179,0,0,'Wholesale'),
 (179,0,0,'Premium'),
 (275,0,5,'Employees'),
 (275,0,5,'DeLillo Friends'),
 (452,0,4,''),
 (182,0,0,'Wholesale'),
 (182,0,0,'Premium'),
 (183,0,0,'Wholesale'),
 (183,0,0,'Premium'),
 (447,0,4,'DeLillo Friends'),
 (448,0,4,'DeLillo Friends'),
 (186,0,0,'Wholesale'),
 (186,0,0,'Premium'),
 (187,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (187,0,0,'Premium'),
 (428,0,0,'DeLillo Friends'),
 (446,0,1,'Wholesale'),
 (445,0,0,'Employees'),
 (445,0,0,''),
 (446,0,1,'Premium'),
 (266,0,0,'Premium'),
 (266,0,0,'Wholesale'),
 (266,0,0,'DeLillo Friends'),
 (266,0,0,'Employees'),
 (266,0,0,''),
 (194,0,0,'Wholesale'),
 (194,0,0,'Premium'),
 (279,0,4,''),
 (279,0,4,'DeLillo Friends'),
 (279,0,4,'Wholesale'),
 (278,0,6,'Employees'),
 (278,0,6,'DeLillo Friends'),
 (277,0,4,''),
 (277,0,4,'Employees'),
 (277,0,4,'Wholesale'),
 (277,0,4,'Premium'),
 (194,0,0,''),
 (249,0,0,''),
 (249,0,0,'Premium'),
 (428,0,0,''),
 (451,0,0,'Premium'),
 (449,0,11,''),
 (450,0,4,'Premium'),
 (450,0,4,'Wholesale'),
 (450,0,4,'DeLillo Friends'),
 (176,0,0,''),
 (176,0,0,'Wholesale'),
 (176,0,0,'Premium'),
 (174,0,0,''),
 (179,0,0,''),
 (182,0,0,''),
 (177,0,0,''),
 (177,0,0,'Wholesale'),
 (177,0,0,'Premium'),
 (429,0,3,'Wholesale'),
 (248,20,0,''),
 (284,0,1,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (285,0,1,'Premium'),
 (285,0,1,'Wholesale'),
 (285,0,1,'DeLillo Friends'),
 (285,0,1,'Employees'),
 (285,0,1,''),
 (286,0,1,'Premium'),
 (286,0,1,'Wholesale'),
 (180,0,0,''),
 (215,0,0,'Wholesale'),
 (215,0,0,'Premium'),
 (453,0,0,'Wholesale'),
 (453,0,0,'DeLillo Friends'),
 (186,0,0,''),
 (181,0,0,''),
 (248,0,0,'Premium'),
 (248,0,0,'Wholesale'),
 (180,0,0,'Wholesale'),
 (180,0,0,'Premium'),
 (215,0,0,''),
 (181,0,0,'Wholesale'),
 (181,0,0,'Premium'),
 (272,0,0,'Wholesale'),
 (170,0,0,''),
 (223,0,0,'Employees'),
 (223,0,0,'Premium'),
 (451,0,0,'Employees'),
 (451,0,0,''),
 (452,0,4,'Premium'),
 (237,0,0,''),
 (237,0,0,'DeLillo Friends'),
 (237,0,0,'Wholesale'),
 (236,0,0,''),
 (236,0,0,'Premium'),
 (235,0,0,''),
 (235,0,0,'DeLillo Friends'),
 (235,0,0,'Wholesale'),
 (224,0,0,''),
 (224,0,0,'Wholesale'),
 (224,0,0,'Premium'),
 (273,0,0,'Premium'),
 (272,8,0,''),
 (273,0,0,'DeLillo Friends'),
 (270,0,0,'Premium');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (250,0,0,''),
 (427,0,1,'Premium'),
 (36,0,0,'DeLillo Friends'),
 (457,0,0,'DeLillo Friends'),
 (457,0,0,'Employees'),
 (457,0,0,''),
 (458,0,9,'Premium'),
 (252,0,0,'Employees'),
 (252,0,0,'Premium'),
 (252,0,0,'Wholesale'),
 (252,0,0,'DeLillo Friends'),
 (163,0,1,'DeLillo Friends'),
 (275,0,5,'Premium'),
 (274,0,8,'Wholesale'),
 (455,0,4,'Employees'),
 (254,0,0,'Premium'),
 (170,0,0,'Employees'),
 (428,0,0,'Wholesale'),
 (173,0,0,'Employees'),
 (174,0,0,'DeLillo Friends'),
 (453,0,0,''),
 (454,0,9,'Premium'),
 (276,0,9,''),
 (178,0,0,'Employees'),
 (179,0,0,'Employees'),
 (276,0,9,'Premium'),
 (452,0,4,'Employees'),
 (182,0,0,'Employees'),
 (183,0,0,'Employees'),
 (254,0,0,''),
 (447,0,4,'Premium'),
 (186,0,0,'Employees'),
 (187,0,0,'Employees'),
 (444,0,0,'Wholesale'),
 (444,0,0,'DeLillo Friends'),
 (270,0,0,'Employees'),
 (272,0,0,'Premium'),
 (279,0,4,'Employees'),
 (279,0,4,'Premium'),
 (278,0,6,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (249,0,0,'DeLillo Friends'),
 (249,0,0,'Wholesale'),
 (429,0,3,'Premium'),
 (176,0,0,'Employees'),
 (276,0,9,'Wholesale'),
 (178,0,0,''),
 (177,0,0,'Employees'),
 (451,0,0,'Wholesale'),
 (286,0,1,''),
 (286,0,1,'DeLillo Friends'),
 (248,0,0,'DeLillo Friends'),
 (284,0,1,'DeLillo Friends'),
 (284,0,1,'Employees'),
 (180,0,0,'Employees'),
 (181,0,0,'Employees'),
 (272,0,0,'Employees'),
 (452,0,4,'Wholesale'),
 (223,0,0,'DeLillo Friends'),
 (453,0,0,'Premium'),
 (237,0,0,'Employees'),
 (236,0,0,'DeLillo Friends'),
 (236,0,0,'Wholesale'),
 (235,0,0,'Employees'),
 (224,0,0,'Employees'),
 (273,0,0,'Wholesale'),
 (428,0,0,'Premium'),
 (254,0,0,'Employees'),
 (36,0,0,'Employees'),
 (251,0,0,'Employees'),
 (457,0,0,'Wholesale'),
 (449,0,11,'DeLillo Friends'),
 (448,0,4,'Employees'),
 (448,0,4,''),
 (449,0,11,'Premium'),
 (449,0,11,'Wholesale'),
 (163,0,1,'Employees'),
 (274,0,8,''),
 (274,0,8,'Premium');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (429,0,3,'DeLillo Friends'),
 (456,0,0,'DeLillo Friends'),
 (254,0,0,'Wholesale'),
 (170,0,0,'DeLillo Friends'),
 (445,0,0,'DeLillo Friends'),
 (173,0,0,'DeLillo Friends'),
 (174,0,0,'Wholesale'),
 (454,0,9,'Wholesale'),
 (276,0,9,'Employees'),
 (178,0,0,'DeLillo Friends'),
 (179,0,0,'DeLillo Friends'),
 (275,0,5,''),
 (454,0,9,''),
 (182,0,0,'DeLillo Friends'),
 (183,0,0,'DeLillo Friends'),
 (447,0,4,'Employees'),
 (447,0,4,'Wholesale'),
 (186,0,0,'DeLillo Friends'),
 (187,0,0,'DeLillo Friends'),
 (444,0,0,'Employees'),
 (444,0,0,''),
 (271,1,0,''),
 (278,0,6,''),
 (278,0,6,'Premium'),
 (277,0,4,'DeLillo Friends'),
 (249,0,0,'Employees'),
 (428,0,0,'Employees'),
 (450,0,4,'Employees'),
 (450,0,4,''),
 (176,0,0,'DeLillo Friends'),
 (173,0,0,''),
 (183,0,0,''),
 (177,0,0,'DeLillo Friends'),
 (451,0,0,'DeLillo Friends'),
 (286,0,1,'Employees'),
 (284,0,1,'Wholesale'),
 (284,0,1,'Premium'),
 (187,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (248,0,0,'Employees'),
 (180,0,0,'DeLillo Friends'),
 (181,0,0,'DeLillo Friends'),
 (272,0,0,'DeLillo Friends'),
 (452,0,4,'DeLillo Friends'),
 (223,0,0,'Wholesale'),
 (453,0,0,'Employees'),
 (237,0,0,'Premium'),
 (236,0,0,'Employees'),
 (223,0,0,''),
 (235,0,0,'Premium'),
 (224,0,0,'DeLillo Friends'),
 (280,0,2,'Premium'),
 (280,0,2,'Wholesale'),
 (280,0,2,'DeLillo Friends'),
 (280,0,2,'Employees'),
 (280,0,2,''),
 (281,0,1,'Premium'),
 (281,0,1,'Wholesale'),
 (281,0,1,'DeLillo Friends'),
 (281,0,1,'Employees'),
 (281,0,1,''),
 (282,0,1,'Premium'),
 (282,0,1,'Wholesale'),
 (282,0,1,'DeLillo Friends'),
 (282,0,1,'Employees'),
 (282,0,1,''),
 (283,0,1,'Premium'),
 (283,0,1,'Wholesale'),
 (283,0,1,'DeLillo Friends'),
 (283,0,1,'Employees'),
 (283,0,1,''),
 (287,0,0,'Premium'),
 (287,0,0,'Wholesale'),
 (287,0,0,'DeLillo Friends'),
 (287,0,0,'Employees'),
 (287,0,0,''),
 (288,0,5,'Premium'),
 (288,0,5,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (288,0,5,'DeLillo Friends'),
 (288,0,5,'Employees'),
 (288,0,5,''),
 (289,0,0,'Premium'),
 (289,0,0,'Wholesale'),
 (289,0,0,'DeLillo Friends'),
 (289,0,0,'Employees'),
 (289,1,0,''),
 (290,0,2,'Employees'),
 (290,0,2,'DeLillo Friends'),
 (290,0,2,'Wholesale'),
 (290,0,2,'Premium'),
 (290,0,2,''),
 (291,0,1,'Premium'),
 (291,0,1,'Wholesale'),
 (291,0,1,'DeLillo Friends'),
 (291,0,1,'Employees'),
 (291,0,1,''),
 (292,0,0,'Premium'),
 (292,0,0,'Wholesale'),
 (292,0,0,'DeLillo Friends'),
 (292,0,0,'Employees'),
 (292,14,0,''),
 (293,0,0,'Premium'),
 (293,0,0,'Wholesale'),
 (293,0,0,'DeLillo Friends'),
 (293,0,0,'Employees'),
 (293,5,0,''),
 (294,0,0,'Premium'),
 (294,0,0,'Wholesale'),
 (294,0,0,'DeLillo Friends'),
 (294,0,0,'Employees'),
 (294,3,0,''),
 (295,0,0,'Premium'),
 (295,0,0,'Wholesale'),
 (295,0,0,'DeLillo Friends'),
 (295,0,0,'Employees'),
 (295,2,0,''),
 (296,0,0,'Premium'),
 (296,0,0,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (296,0,0,'DeLillo Friends'),
 (296,0,0,'Employees'),
 (296,0,0,''),
 (297,0,4,'Premium'),
 (297,0,4,'Wholesale'),
 (297,0,4,'DeLillo Friends'),
 (297,0,4,'Employees'),
 (297,0,4,''),
 (298,0,2,'Premium'),
 (298,0,2,'Wholesale'),
 (298,0,2,'DeLillo Friends'),
 (298,0,2,'Employees'),
 (298,0,2,''),
 (299,0,2,'Premium'),
 (299,0,2,'Wholesale'),
 (299,0,2,'DeLillo Friends'),
 (299,0,2,'Employees'),
 (299,0,2,''),
 (300,0,4,'Premium'),
 (300,0,4,'Wholesale'),
 (300,0,4,'DeLillo Friends'),
 (300,0,4,'Employees'),
 (300,0,4,''),
 (301,0,4,'Premium'),
 (301,0,4,'Wholesale'),
 (301,0,4,'DeLillo Friends'),
 (301,0,4,'Employees'),
 (301,0,4,''),
 (302,0,2,'Premium'),
 (302,0,2,'Wholesale'),
 (302,0,2,'DeLillo Friends'),
 (302,0,2,'Employees'),
 (302,0,2,''),
 (303,0,2,'Premium'),
 (303,0,2,'Wholesale'),
 (303,0,2,'DeLillo Friends'),
 (303,0,2,'Employees'),
 (303,0,2,''),
 (304,0,2,'Premium'),
 (304,0,2,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (304,0,2,'DeLillo Friends'),
 (304,0,2,'Employees'),
 (304,0,2,''),
 (305,0,0,'Premium'),
 (305,0,0,'Wholesale'),
 (305,0,0,'DeLillo Friends'),
 (305,0,0,'Employees'),
 (305,14,0,''),
 (306,0,0,'Premium'),
 (306,0,0,'Wholesale'),
 (306,0,0,'DeLillo Friends'),
 (306,0,0,'Employees'),
 (306,0,0,''),
 (307,0,0,'Premium'),
 (307,0,0,'Wholesale'),
 (307,0,0,'DeLillo Friends'),
 (307,0,0,'Employees'),
 (307,7,0,''),
 (308,0,0,'Premium'),
 (308,0,0,'Wholesale'),
 (308,0,0,'DeLillo Friends'),
 (308,0,0,'Employees'),
 (308,0,0,''),
 (309,0,0,'Premium'),
 (309,0,0,'Wholesale'),
 (309,0,0,'DeLillo Friends'),
 (309,0,0,'Employees'),
 (309,0,0,''),
 (310,0,2,'Premium'),
 (310,0,2,'Wholesale'),
 (310,0,2,'DeLillo Friends'),
 (310,0,2,'Employees'),
 (310,0,2,''),
 (311,0,2,'Premium'),
 (311,0,2,'Wholesale'),
 (311,0,2,'DeLillo Friends'),
 (311,0,2,'Employees'),
 (311,0,2,''),
 (312,0,3,'Premium'),
 (312,0,3,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (312,0,3,'DeLillo Friends'),
 (312,0,3,'Employees'),
 (312,0,3,''),
 (313,0,1,'Premium'),
 (313,0,1,'Wholesale'),
 (313,0,1,'DeLillo Friends'),
 (313,0,1,'Employees'),
 (313,0,1,''),
 (314,0,2,'Premium'),
 (314,0,2,'Wholesale'),
 (314,0,2,'DeLillo Friends'),
 (314,0,2,'Employees'),
 (314,0,2,''),
 (315,0,0,'Premium'),
 (315,0,0,'Wholesale'),
 (315,0,0,'DeLillo Friends'),
 (315,0,0,'Employees'),
 (315,0,0,''),
 (316,0,0,'Premium'),
 (316,0,0,'Wholesale'),
 (316,0,0,'DeLillo Friends'),
 (316,0,0,'Employees'),
 (316,0,0,''),
 (317,0,0,'Premium'),
 (317,0,0,'Wholesale'),
 (317,0,0,'DeLillo Friends'),
 (317,0,0,'Employees'),
 (317,0,0,''),
 (318,0,1,'Premium'),
 (318,0,1,'Wholesale'),
 (318,0,1,'DeLillo Friends'),
 (318,0,1,'Employees'),
 (318,0,1,''),
 (319,0,3,'Premium'),
 (319,0,3,'Wholesale'),
 (319,0,3,'DeLillo Friends'),
 (319,0,3,'Employees'),
 (319,0,3,''),
 (320,0,2,'Premium'),
 (320,0,2,'Wholesale');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (320,0,2,'DeLillo Friends'),
 (320,0,2,'Employees'),
 (320,0,2,''),
 (321,0,3,'Premium'),
 (321,0,3,'Wholesale'),
 (321,0,3,'DeLillo Friends'),
 (321,0,3,'Employees'),
 (321,0,3,''),
 (377,38,0,''),
 (377,0,0,'Employees'),
 (378,0,0,'Premium'),
 (377,0,0,'Wholesale'),
 (377,0,0,'Premium'),
 (377,0,0,'DeLillo Friends'),
 (324,0,0,'Premium'),
 (324,0,0,'Wholesale'),
 (324,0,0,'DeLillo Friends'),
 (324,0,0,'Employees'),
 (324,0,0,''),
 (378,0,0,'DeLillo Friends'),
 (378,0,0,'Wholesale'),
 (325,0,0,'Premium'),
 (325,0,0,'Wholesale'),
 (325,0,0,'DeLillo Friends'),
 (325,0,0,'Employees'),
 (325,0,0,''),
 (326,0,0,'Premium'),
 (326,0,0,'Wholesale'),
 (326,0,0,'DeLillo Friends'),
 (326,0,0,'Employees'),
 (326,0,0,''),
 (327,0,2,'Premium'),
 (327,0,2,'Wholesale'),
 (327,0,2,'DeLillo Friends'),
 (327,0,2,'Employees'),
 (327,0,2,''),
 (328,0,2,'Premium'),
 (328,0,2,'Wholesale'),
 (328,0,2,'DeLillo Friends'),
 (328,0,2,'Employees');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (328,0,2,''),
 (329,0,0,'Premium'),
 (329,0,0,'Wholesale'),
 (329,0,0,'DeLillo Friends'),
 (329,0,0,'Employees'),
 (329,0,0,''),
 (330,0,2,'Premium'),
 (330,0,2,'Wholesale'),
 (330,0,2,'DeLillo Friends'),
 (330,0,2,'Employees'),
 (330,0,2,''),
 (331,0,1,'Premium'),
 (331,0,1,'Wholesale'),
 (331,0,1,'DeLillo Friends'),
 (331,0,1,'Employees'),
 (331,0,1,''),
 (332,0,1,'Premium'),
 (332,0,1,'Wholesale'),
 (332,0,1,'DeLillo Friends'),
 (332,0,1,'Employees'),
 (332,0,1,''),
 (333,0,1,'Premium'),
 (333,0,1,'Wholesale'),
 (333,0,1,'DeLillo Friends'),
 (333,0,1,'Employees'),
 (333,0,1,''),
 (334,0,1,'Premium'),
 (334,0,1,'Wholesale'),
 (334,0,1,'DeLillo Friends'),
 (334,0,1,'Employees'),
 (334,0,1,''),
 (335,0,1,'Premium'),
 (335,0,1,'Wholesale'),
 (335,0,1,'DeLillo Friends'),
 (335,0,1,'Employees'),
 (335,0,1,''),
 (336,0,0,'Premium'),
 (336,0,0,'Wholesale'),
 (336,0,0,'DeLillo Friends'),
 (336,0,0,'Employees');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (336,0,0,''),
 (337,0,0,'Premium'),
 (337,0,0,'Wholesale'),
 (337,0,0,'DeLillo Friends'),
 (337,0,0,'Employees'),
 (337,0,0,''),
 (338,0,0,'Premium'),
 (338,0,0,'Wholesale'),
 (338,0,0,'DeLillo Friends'),
 (338,0,0,'Employees'),
 (338,0,0,''),
 (339,0,2,'Premium'),
 (339,0,2,'Wholesale'),
 (339,0,2,'DeLillo Friends'),
 (339,0,2,'Employees'),
 (339,0,2,''),
 (340,0,2,'Premium'),
 (340,0,2,'Wholesale'),
 (340,0,2,'DeLillo Friends'),
 (340,0,2,'Employees'),
 (340,0,2,''),
 (341,0,0,''),
 (341,0,0,'Employees'),
 (378,0,0,''),
 (341,0,0,'Wholesale'),
 (341,0,0,'Premium'),
 (341,0,0,'DeLillo Friends'),
 (343,0,1,'Premium'),
 (343,0,1,'Wholesale'),
 (343,0,1,'DeLillo Friends'),
 (343,0,1,'Employees'),
 (343,0,1,''),
 (344,0,1,'Premium'),
 (344,0,1,'Wholesale'),
 (344,0,1,'DeLillo Friends'),
 (344,0,1,'Employees'),
 (344,0,1,''),
 (345,0,2,'Premium'),
 (345,0,2,'Wholesale'),
 (345,0,2,'DeLillo Friends'),
 (345,0,2,'Employees');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (345,0,2,''),
 (346,0,0,'Premium'),
 (346,0,0,'Wholesale'),
 (346,0,0,'DeLillo Friends'),
 (346,0,0,'Employees'),
 (346,0,0,''),
 (347,0,2,'Premium'),
 (347,0,2,'Wholesale'),
 (347,0,2,'DeLillo Friends'),
 (347,0,2,'Employees'),
 (347,0,2,''),
 (348,0,0,'Premium'),
 (348,0,0,'Wholesale'),
 (348,0,0,'DeLillo Friends'),
 (348,0,0,'Employees'),
 (348,0,0,''),
 (349,0,0,'Premium'),
 (349,0,0,'Wholesale'),
 (349,0,0,'DeLillo Friends'),
 (349,0,0,'Employees'),
 (349,0,0,''),
 (350,0,2,'Premium'),
 (350,0,2,'Wholesale'),
 (350,0,2,'DeLillo Friends'),
 (350,0,2,'Employees'),
 (350,0,2,''),
 (351,0,2,'Premium'),
 (351,0,2,'Wholesale'),
 (351,0,2,'DeLillo Friends'),
 (351,0,2,'Employees'),
 (351,0,2,''),
 (352,0,0,''),
 (352,0,0,'Employees'),
 (378,0,0,'Employees'),
 (352,0,0,'Wholesale'),
 (352,0,0,'Premium'),
 (352,0,0,'DeLillo Friends'),
 (354,0,1,'Premium'),
 (354,0,1,'Wholesale'),
 (354,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (354,0,1,'Employees'),
 (354,0,1,''),
 (355,0,0,'Premium'),
 (355,0,0,'Wholesale'),
 (355,0,0,'DeLillo Friends'),
 (355,0,0,'Employees'),
 (355,0,0,''),
 (356,0,1,'Premium'),
 (356,0,1,'Wholesale'),
 (356,0,1,'DeLillo Friends'),
 (356,0,1,'Employees'),
 (356,0,1,''),
 (357,0,1,'Premium'),
 (357,0,1,'Wholesale'),
 (357,0,1,'DeLillo Friends'),
 (357,0,1,'Employees'),
 (357,0,1,''),
 (358,0,1,'Premium'),
 (358,0,1,'Wholesale'),
 (358,0,1,'DeLillo Friends'),
 (358,0,1,'Employees'),
 (358,0,1,''),
 (359,0,2,'Premium'),
 (359,0,2,'Wholesale'),
 (359,0,2,'DeLillo Friends'),
 (359,0,2,'Employees'),
 (359,0,2,''),
 (360,0,1,'Premium'),
 (360,0,1,'Wholesale'),
 (360,0,1,'DeLillo Friends'),
 (360,0,1,'Employees'),
 (360,0,1,''),
 (361,0,0,'Premium'),
 (361,0,0,'Wholesale'),
 (361,0,0,'DeLillo Friends'),
 (361,0,0,'Employees'),
 (361,5,0,''),
 (362,0,0,'Premium'),
 (362,0,0,'Wholesale'),
 (362,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (362,0,0,'Employees'),
 (362,0,0,''),
 (363,0,1,'Premium'),
 (363,0,1,'Wholesale'),
 (363,0,1,'DeLillo Friends'),
 (363,0,1,'Employees'),
 (363,0,1,''),
 (364,0,1,'Premium'),
 (364,0,1,'Wholesale'),
 (364,0,1,'DeLillo Friends'),
 (364,0,1,'Employees'),
 (364,0,1,''),
 (365,0,1,'Premium'),
 (365,0,1,'Wholesale'),
 (365,0,1,'DeLillo Friends'),
 (365,0,1,'Employees'),
 (365,0,1,''),
 (366,0,2,'Premium'),
 (366,0,2,'Wholesale'),
 (366,0,2,'DeLillo Friends'),
 (366,0,2,'Employees'),
 (366,0,2,''),
 (367,0,0,'Premium'),
 (367,0,0,'Wholesale'),
 (367,0,0,'DeLillo Friends'),
 (367,0,0,'Employees'),
 (367,0,0,''),
 (368,0,0,'Premium'),
 (368,0,0,'Wholesale'),
 (368,0,0,'DeLillo Friends'),
 (368,0,0,'Employees'),
 (368,0,0,''),
 (369,0,1,'Premium'),
 (369,0,1,'Wholesale'),
 (369,0,1,'DeLillo Friends'),
 (369,0,1,'Employees'),
 (369,0,1,''),
 (370,0,0,'Premium'),
 (370,0,0,'Wholesale'),
 (370,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (370,0,0,'Employees'),
 (370,0,0,''),
 (371,0,1,'Premium'),
 (371,0,1,'Wholesale'),
 (371,0,1,'DeLillo Friends'),
 (371,0,1,'Employees'),
 (371,0,1,''),
 (372,0,0,'Premium'),
 (372,0,0,'Wholesale'),
 (372,0,0,'DeLillo Friends'),
 (372,0,0,'Employees'),
 (372,0,0,''),
 (373,0,0,'Premium'),
 (373,0,0,'Wholesale'),
 (373,0,0,'DeLillo Friends'),
 (373,0,0,'Employees'),
 (373,0,0,''),
 (374,0,2,'Premium'),
 (374,0,2,'Wholesale'),
 (374,0,2,'DeLillo Friends'),
 (374,0,2,'Employees'),
 (374,0,2,''),
 (375,0,2,'Premium'),
 (375,0,2,'Wholesale'),
 (375,0,2,'DeLillo Friends'),
 (375,0,2,'Employees'),
 (375,0,2,''),
 (376,0,1,'Premium'),
 (376,0,1,'Wholesale'),
 (376,0,1,'DeLillo Friends'),
 (376,0,1,'Employees'),
 (376,0,1,''),
 (379,0,0,'Premium'),
 (379,0,0,'Wholesale'),
 (379,0,0,'DeLillo Friends'),
 (379,0,0,'Employees'),
 (379,0,0,''),
 (380,0,12,'Premium'),
 (380,0,12,'Wholesale'),
 (380,0,12,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (380,0,12,'Employees'),
 (380,0,12,''),
 (381,0,9,'Premium'),
 (381,0,9,'Wholesale'),
 (381,0,9,'DeLillo Friends'),
 (381,0,9,'Employees'),
 (381,0,9,''),
 (382,0,9,'Premium'),
 (382,0,9,'Wholesale'),
 (382,0,9,'DeLillo Friends'),
 (382,0,9,'Employees'),
 (382,0,9,''),
 (383,0,9,'Premium'),
 (383,0,9,'Wholesale'),
 (383,0,9,'DeLillo Friends'),
 (383,0,9,'Employees'),
 (383,0,9,''),
 (384,0,0,'Premium'),
 (384,0,0,'Wholesale'),
 (384,0,0,'DeLillo Friends'),
 (384,0,0,'Employees'),
 (384,0,0,''),
 (385,0,30,'Premium'),
 (385,0,30,'Wholesale'),
 (385,0,30,'DeLillo Friends'),
 (385,0,30,'Employees'),
 (385,0,30,''),
 (386,0,27,'Premium'),
 (386,0,27,'Wholesale'),
 (386,0,27,'DeLillo Friends'),
 (386,0,27,'Employees'),
 (386,0,27,''),
 (387,0,1,'Premium'),
 (387,0,1,'Wholesale'),
 (387,0,1,'DeLillo Friends'),
 (387,0,1,'Employees'),
 (387,0,1,''),
 (388,0,0,''),
 (388,0,0,'Employees'),
 (390,0,0,'Premium');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (388,0,0,'Wholesale'),
 (388,0,0,'Premium'),
 (388,0,0,'DeLillo Friends'),
 (390,0,0,'Wholesale'),
 (390,0,0,'DeLillo Friends'),
 (390,0,0,'Employees'),
 (390,0,0,''),
 (391,0,0,'Premium'),
 (391,0,0,'Wholesale'),
 (391,0,0,'DeLillo Friends'),
 (391,0,0,'Employees'),
 (391,0,0,''),
 (392,0,1,'Premium'),
 (392,0,1,'Wholesale'),
 (392,0,1,'DeLillo Friends'),
 (392,0,1,'Employees'),
 (392,0,1,''),
 (393,0,1,'Premium'),
 (393,0,1,'Wholesale'),
 (393,0,1,'DeLillo Friends'),
 (393,0,1,'Employees'),
 (393,0,1,''),
 (394,0,5,'Premium'),
 (394,0,5,'Wholesale'),
 (394,0,5,'DeLillo Friends'),
 (394,0,5,'Employees'),
 (394,0,5,''),
 (395,0,5,'Premium'),
 (395,0,5,'Wholesale'),
 (395,0,5,'DeLillo Friends'),
 (395,0,5,'Employees'),
 (395,0,5,''),
 (396,0,12,'Premium'),
 (396,0,12,'Wholesale'),
 (396,0,12,'DeLillo Friends'),
 (396,0,12,'Employees'),
 (396,0,12,''),
 (397,0,4,'Premium'),
 (397,0,4,'Wholesale'),
 (397,0,4,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (397,0,4,'Employees'),
 (397,0,4,''),
 (398,0,0,'Premium'),
 (398,0,0,'Wholesale'),
 (398,0,0,'DeLillo Friends'),
 (398,0,0,'Employees'),
 (398,0,0,''),
 (399,0,1,'Premium'),
 (399,0,1,'Wholesale'),
 (399,0,1,'DeLillo Friends'),
 (399,0,1,'Employees'),
 (399,0,1,''),
 (400,0,1,'Premium'),
 (400,0,1,'Wholesale'),
 (400,0,1,'DeLillo Friends'),
 (400,0,1,'Employees'),
 (400,0,1,''),
 (401,0,0,'Premium'),
 (401,0,0,'Wholesale'),
 (401,0,0,'DeLillo Friends'),
 (401,0,0,'Employees'),
 (401,0,0,''),
 (402,0,7,'Premium'),
 (402,0,7,'Wholesale'),
 (402,0,7,'DeLillo Friends'),
 (402,0,7,'Employees'),
 (402,0,7,''),
 (403,0,3,'Premium'),
 (403,0,3,'Wholesale'),
 (403,0,3,'DeLillo Friends'),
 (403,0,3,'Employees'),
 (403,0,3,''),
 (404,0,20,'Premium'),
 (404,0,20,'Wholesale'),
 (404,0,20,'DeLillo Friends'),
 (404,0,20,'Employees'),
 (404,0,20,''),
 (405,0,4,'Premium'),
 (405,0,4,'Wholesale'),
 (405,0,4,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (405,0,4,'Employees'),
 (405,0,4,''),
 (406,0,0,'Premium'),
 (406,0,0,'Wholesale'),
 (406,0,0,'DeLillo Friends'),
 (406,0,0,'Employees'),
 (406,0,0,''),
 (407,0,0,'Premium'),
 (407,0,0,'Wholesale'),
 (407,0,0,'DeLillo Friends'),
 (407,0,0,'Employees'),
 (407,0,0,''),
 (408,0,2,'Premium'),
 (408,0,2,'Wholesale'),
 (408,0,2,'DeLillo Friends'),
 (408,0,2,'Employees'),
 (408,0,2,''),
 (409,0,2,'Premium'),
 (409,0,2,'Wholesale'),
 (409,0,2,'DeLillo Friends'),
 (409,0,2,'Employees'),
 (409,0,2,''),
 (410,0,8,'Premium'),
 (410,0,8,'Wholesale'),
 (410,0,8,'DeLillo Friends'),
 (410,0,8,'Employees'),
 (410,0,8,''),
 (411,0,1,'Premium'),
 (411,0,1,'Wholesale'),
 (411,0,1,'DeLillo Friends'),
 (411,0,1,'Employees'),
 (411,0,1,''),
 (412,0,4,'Premium'),
 (412,0,4,'Wholesale'),
 (412,0,4,'DeLillo Friends'),
 (412,0,4,'Employees'),
 (412,0,4,''),
 (413,0,4,'Premium'),
 (413,0,4,'Wholesale'),
 (413,0,4,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (413,0,4,'Employees'),
 (413,0,4,''),
 (414,0,3,'Premium'),
 (414,0,3,'Wholesale'),
 (414,0,3,'DeLillo Friends'),
 (414,0,3,'Employees'),
 (414,0,3,''),
 (415,0,17,'Premium'),
 (415,0,17,'Wholesale'),
 (415,0,17,'DeLillo Friends'),
 (415,0,17,'Employees'),
 (415,0,17,''),
 (416,0,6,'Premium'),
 (416,0,6,'Wholesale'),
 (416,0,6,'DeLillo Friends'),
 (416,0,6,'Employees'),
 (416,0,6,''),
 (417,0,1,'Premium'),
 (417,0,1,'Wholesale'),
 (417,0,1,'DeLillo Friends'),
 (417,0,1,'Employees'),
 (417,0,1,''),
 (418,0,0,'Premium'),
 (418,0,0,'Wholesale'),
 (418,0,0,'DeLillo Friends'),
 (418,0,0,'Employees'),
 (418,0,0,''),
 (419,0,1,'Premium'),
 (419,0,1,'Wholesale'),
 (419,0,1,'DeLillo Friends'),
 (419,0,1,'Employees'),
 (419,0,1,''),
 (420,0,1,'Premium'),
 (420,0,1,'Wholesale'),
 (420,0,1,'DeLillo Friends'),
 (420,0,1,'Employees'),
 (420,0,1,''),
 (421,0,11,'Premium'),
 (421,0,11,'Wholesale'),
 (421,0,11,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (421,0,11,'Employees'),
 (421,0,11,''),
 (422,0,5,'Premium'),
 (422,0,5,'Wholesale'),
 (422,0,5,'DeLillo Friends'),
 (422,0,5,'Employees'),
 (422,0,5,''),
 (423,0,1,'Premium'),
 (423,0,1,'Wholesale'),
 (423,0,1,'DeLillo Friends'),
 (423,0,1,'Employees'),
 (423,0,1,''),
 (424,0,0,'Premium'),
 (424,0,0,'Wholesale'),
 (424,0,0,'DeLillo Friends'),
 (424,0,0,'Employees'),
 (424,0,0,''),
 (425,0,0,'Premium'),
 (425,0,0,'Wholesale'),
 (425,0,0,'DeLillo Friends'),
 (425,0,0,'Employees'),
 (425,0,0,''),
 (426,0,3,'Premium'),
 (426,0,3,'Wholesale'),
 (426,0,3,'DeLillo Friends'),
 (426,0,3,'Employees'),
 (426,0,3,''),
 (427,0,1,'Wholesale'),
 (427,0,1,'DeLillo Friends'),
 (427,0,1,'Employees'),
 (427,0,1,''),
 (429,0,3,'Employees'),
 (429,0,3,''),
 (430,0,3,'Premium'),
 (430,0,3,'Wholesale'),
 (430,0,3,'DeLillo Friends'),
 (430,0,3,'Employees'),
 (430,0,3,''),
 (431,0,2,'Premium'),
 (431,0,2,'Wholesale'),
 (431,0,2,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (431,0,2,'Employees'),
 (431,0,2,''),
 (432,0,3,'Premium'),
 (432,0,3,'Wholesale'),
 (432,0,3,'DeLillo Friends'),
 (432,0,3,'Employees'),
 (432,0,3,''),
 (433,0,9,'Premium'),
 (433,0,9,'Wholesale'),
 (433,0,9,'DeLillo Friends'),
 (433,0,9,'Employees'),
 (433,0,9,''),
 (434,0,5,'Premium'),
 (434,0,5,'Wholesale'),
 (434,0,5,'DeLillo Friends'),
 (434,0,5,'Employees'),
 (434,0,5,''),
 (435,0,6,'Premium'),
 (435,0,6,'Wholesale'),
 (435,0,6,'DeLillo Friends'),
 (435,0,6,'Employees'),
 (435,0,6,''),
 (436,0,1,'Premium'),
 (436,0,1,'Wholesale'),
 (436,0,1,'DeLillo Friends'),
 (436,0,1,'Employees'),
 (436,0,1,''),
 (437,0,0,'Premium'),
 (437,0,0,'Wholesale'),
 (437,0,0,'DeLillo Friends'),
 (437,0,0,'Employees'),
 (437,0,0,''),
 (438,0,1,'Premium'),
 (438,0,1,'Wholesale'),
 (438,0,1,'DeLillo Friends'),
 (438,0,1,'Employees'),
 (438,0,1,''),
 (439,0,1,'Premium'),
 (439,0,1,'Wholesale'),
 (439,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (439,0,1,'Employees'),
 (439,0,1,''),
 (440,0,1,'Premium'),
 (440,0,1,'Wholesale'),
 (440,0,1,'DeLillo Friends'),
 (440,0,1,'Employees'),
 (440,0,1,''),
 (441,0,5,'Premium'),
 (441,0,5,'Wholesale'),
 (441,0,5,'DeLillo Friends'),
 (441,0,5,'Employees'),
 (441,0,5,''),
 (442,0,1,'Premium'),
 (442,0,1,'Wholesale'),
 (442,0,1,'DeLillo Friends'),
 (442,0,1,'Employees'),
 (442,0,1,''),
 (443,0,4,'Premium'),
 (443,0,4,'Wholesale'),
 (443,0,4,'DeLillo Friends'),
 (443,0,4,'Employees'),
 (443,0,4,''),
 (458,0,9,'Wholesale'),
 (458,0,9,'DeLillo Friends'),
 (458,0,9,'Employees'),
 (458,0,9,''),
 (459,0,2,'Premium'),
 (459,0,2,'Wholesale'),
 (459,0,2,'DeLillo Friends'),
 (459,0,2,'Employees'),
 (459,0,2,''),
 (460,0,2,'Premium'),
 (460,0,2,'Wholesale'),
 (460,0,2,'DeLillo Friends'),
 (460,0,2,'Employees'),
 (460,0,2,''),
 (461,0,3,'Premium'),
 (461,0,3,'Wholesale'),
 (461,0,3,'DeLillo Friends'),
 (461,0,3,'Employees');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (461,0,3,''),
 (462,0,0,'Premium'),
 (462,0,0,'Wholesale'),
 (462,0,0,'DeLillo Friends'),
 (462,0,0,'Employees'),
 (462,0,0,''),
 (463,0,6,'Premium'),
 (463,0,6,'Wholesale'),
 (463,0,6,'DeLillo Friends'),
 (463,0,6,'Employees'),
 (463,0,6,''),
 (464,0,2,'Premium'),
 (464,0,2,'Wholesale'),
 (464,0,2,'DeLillo Friends'),
 (464,0,2,'Employees'),
 (464,0,2,''),
 (465,0,0,'Premium'),
 (465,0,0,'Wholesale'),
 (465,0,0,'DeLillo Friends'),
 (465,0,0,'Employees'),
 (465,0,0,''),
 (466,0,0,'Premium'),
 (466,0,0,'Wholesale'),
 (466,0,0,'DeLillo Friends'),
 (466,0,0,'Employees'),
 (466,0,0,''),
 (467,0,6,'Premium'),
 (467,0,6,'Wholesale'),
 (467,0,6,'DeLillo Friends'),
 (467,0,6,'Employees'),
 (467,0,6,''),
 (468,0,3,'Premium'),
 (468,0,3,'Wholesale'),
 (468,0,3,'DeLillo Friends'),
 (468,0,3,'Employees'),
 (468,0,3,''),
 (469,0,3,'Premium'),
 (469,0,3,'Wholesale'),
 (469,0,3,'DeLillo Friends'),
 (469,0,3,'Employees');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (469,0,3,''),
 (470,0,18,'Premium'),
 (470,0,18,'Wholesale'),
 (470,0,18,'DeLillo Friends'),
 (470,0,18,'Employees'),
 (470,0,18,''),
 (471,0,0,'Premium'),
 (471,0,0,'Wholesale'),
 (471,0,0,'DeLillo Friends'),
 (471,0,0,'Employees'),
 (471,0,0,''),
 (472,0,32,'Premium'),
 (472,0,32,'Wholesale'),
 (472,0,32,'DeLillo Friends'),
 (472,0,32,'Employees'),
 (472,0,32,''),
 (473,0,13,'Premium'),
 (473,0,13,'Wholesale'),
 (473,0,13,'DeLillo Friends'),
 (473,0,13,'Employees'),
 (473,0,13,''),
 (474,0,0,'Premium'),
 (474,0,0,'Wholesale'),
 (474,0,0,'DeLillo Friends'),
 (474,0,0,'Employees'),
 (474,21,0,''),
 (475,0,0,'Premium'),
 (475,0,0,'Wholesale'),
 (475,0,0,'DeLillo Friends'),
 (475,0,0,'Employees'),
 (475,0,0,''),
 (476,0,1,'Premium'),
 (476,0,1,'Wholesale'),
 (476,0,1,'DeLillo Friends'),
 (476,0,1,'Employees'),
 (476,0,1,''),
 (477,0,3,'Premium'),
 (477,0,3,'Wholesale'),
 (477,0,3,'DeLillo Friends'),
 (477,0,3,'Employees');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (477,0,3,''),
 (478,0,7,'Premium'),
 (478,0,7,'Wholesale'),
 (478,0,7,'DeLillo Friends'),
 (478,0,7,'Employees'),
 (478,0,7,''),
 (479,0,7,'Premium'),
 (479,0,7,'Wholesale'),
 (479,0,7,'DeLillo Friends'),
 (479,0,7,'Employees'),
 (479,0,7,''),
 (480,0,6,'Premium'),
 (480,0,6,'Wholesale'),
 (480,0,6,'DeLillo Friends'),
 (480,0,6,'Employees'),
 (480,0,6,''),
 (481,0,18,'Premium'),
 (481,0,18,'Wholesale'),
 (481,0,18,'DeLillo Friends'),
 (481,0,18,'Employees'),
 (481,0,18,''),
 (482,0,4,'Premium'),
 (482,0,4,'Wholesale'),
 (482,0,4,'DeLillo Friends'),
 (482,0,4,'Employees'),
 (482,0,4,''),
 (483,0,3,'Premium'),
 (483,0,3,'Wholesale'),
 (483,0,3,'DeLillo Friends'),
 (483,0,3,'Employees'),
 (483,0,3,''),
 (484,0,0,'Premium'),
 (484,0,0,'Wholesale'),
 (484,0,0,'DeLillo Friends'),
 (484,0,0,'Employees'),
 (484,9,0,''),
 (485,0,0,'Wholesale'),
 (485,0,0,'Premium'),
 (485,0,0,'DeLillo Friends'),
 (486,0,1,'Premium');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (486,0,1,'Wholesale'),
 (486,0,1,'DeLillo Friends'),
 (486,0,1,'Employees'),
 (486,0,1,''),
 (487,0,1,'Premium'),
 (487,0,1,'Wholesale'),
 (487,0,1,'DeLillo Friends'),
 (487,0,1,'Employees'),
 (487,0,1,''),
 (488,0,2,'Premium'),
 (488,0,2,'Wholesale'),
 (488,0,2,'DeLillo Friends'),
 (488,0,2,'Employees'),
 (488,0,2,''),
 (489,0,1,'Premium'),
 (489,0,1,'Wholesale'),
 (489,0,1,'DeLillo Friends'),
 (489,0,1,'Employees'),
 (489,0,1,''),
 (490,0,6,'Premium'),
 (490,0,6,'Wholesale'),
 (490,0,6,'DeLillo Friends'),
 (490,0,6,'Employees'),
 (490,0,6,''),
 (491,0,6,'Premium'),
 (491,0,6,'Wholesale'),
 (491,0,6,'DeLillo Friends'),
 (491,0,6,'Employees'),
 (491,0,6,''),
 (492,0,12,'Premium'),
 (492,0,12,'Wholesale'),
 (492,0,12,'DeLillo Friends'),
 (492,0,12,'Employees'),
 (492,0,12,''),
 (493,0,0,'Premium'),
 (493,0,0,'Wholesale'),
 (493,0,0,'DeLillo Friends'),
 (493,0,0,'Employees'),
 (493,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (494,0,4,'Premium'),
 (494,0,4,'Wholesale'),
 (494,0,4,'DeLillo Friends'),
 (494,0,4,'Employees'),
 (494,0,4,''),
 (495,0,15,'Premium'),
 (495,0,15,'Wholesale'),
 (495,0,15,'DeLillo Friends'),
 (495,0,15,'Employees'),
 (495,0,15,''),
 (496,0,1,'Premium'),
 (496,0,1,'Wholesale'),
 (496,0,1,'DeLillo Friends'),
 (496,0,1,'Employees'),
 (496,0,1,''),
 (485,0,0,'Employees'),
 (485,0,0,''),
 (497,0,0,'Premium'),
 (497,0,0,'Wholesale'),
 (497,0,0,'DeLillo Friends'),
 (497,0,0,'Employees'),
 (497,106,0,''),
 (498,0,2,'Premium'),
 (498,0,2,'Wholesale'),
 (498,0,2,'DeLillo Friends'),
 (498,0,2,'Employees'),
 (498,0,2,''),
 (499,0,0,'Premium'),
 (499,0,0,'Wholesale'),
 (499,0,0,'DeLillo Friends'),
 (499,0,0,'Employees'),
 (499,0,0,''),
 (500,0,0,'Premium'),
 (500,0,0,'Wholesale'),
 (500,0,0,'DeLillo Friends'),
 (500,0,0,'Employees'),
 (500,0,0,''),
 (501,0,1,'Premium'),
 (501,0,1,'Wholesale'),
 (501,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (501,0,1,'Employees'),
 (501,0,1,''),
 (502,0,4,'Premium'),
 (502,0,4,'Wholesale'),
 (502,0,4,'DeLillo Friends'),
 (502,0,4,'Employees'),
 (502,0,4,''),
 (503,0,4,'Premium'),
 (503,0,4,'Wholesale'),
 (503,0,4,'DeLillo Friends'),
 (503,0,4,'Employees'),
 (503,0,4,''),
 (504,0,7,'Premium'),
 (504,0,7,'Wholesale'),
 (504,0,7,'DeLillo Friends'),
 (504,0,7,'Employees'),
 (504,0,7,''),
 (505,0,3,'Premium'),
 (505,0,3,'Wholesale'),
 (505,0,3,'DeLillo Friends'),
 (505,0,3,'Employees'),
 (505,0,3,''),
 (506,0,2,'Premium'),
 (506,0,2,'Wholesale'),
 (506,0,2,'DeLillo Friends'),
 (506,0,2,'Employees'),
 (506,0,2,''),
 (507,0,0,'Premium'),
 (507,0,0,'Wholesale'),
 (507,0,0,'DeLillo Friends'),
 (507,0,0,'Employees'),
 (507,0,0,''),
 (508,0,1,'Premium'),
 (508,0,1,'Wholesale'),
 (508,0,1,'DeLillo Friends'),
 (508,0,1,'Employees'),
 (508,0,1,''),
 (509,0,1,'Premium'),
 (509,0,1,'Wholesale'),
 (509,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (509,0,1,'Employees'),
 (509,0,1,''),
 (510,0,6,'Premium'),
 (510,0,6,'Wholesale'),
 (510,0,6,'DeLillo Friends'),
 (510,0,6,'Employees'),
 (510,0,6,''),
 (511,0,2,'Premium'),
 (511,0,2,'Wholesale'),
 (511,0,2,'DeLillo Friends'),
 (511,0,2,'Employees'),
 (511,0,2,''),
 (512,0,0,'Premium'),
 (512,0,0,'Wholesale'),
 (512,0,0,'DeLillo Friends'),
 (512,0,0,'Employees'),
 (512,0,0,''),
 (513,0,0,'Premium'),
 (513,0,0,'Wholesale'),
 (513,0,0,'DeLillo Friends'),
 (513,0,0,'Employees'),
 (513,0,0,''),
 (514,0,1,'Premium'),
 (514,0,1,'Wholesale'),
 (514,0,1,'DeLillo Friends'),
 (514,0,1,'Employees'),
 (514,0,1,''),
 (515,0,4,'Premium'),
 (515,0,4,'Wholesale'),
 (515,0,4,'DeLillo Friends'),
 (515,0,4,'Employees'),
 (515,0,4,''),
 (516,0,5,'Premium'),
 (516,0,5,'Wholesale'),
 (516,0,5,'DeLillo Friends'),
 (516,0,5,'Employees'),
 (516,0,5,''),
 (517,0,3,'Premium'),
 (517,0,3,'Wholesale'),
 (517,0,3,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (517,0,3,'Employees'),
 (517,0,3,''),
 (518,0,4,'Premium'),
 (518,0,4,'Wholesale'),
 (518,0,4,'DeLillo Friends'),
 (518,0,4,'Employees'),
 (518,0,4,''),
 (519,0,0,'Premium'),
 (519,0,0,'Wholesale'),
 (519,0,0,'DeLillo Friends'),
 (519,0,0,'Employees'),
 (519,0,0,''),
 (520,0,1,'Premium'),
 (520,0,1,'Wholesale'),
 (520,0,1,'DeLillo Friends'),
 (520,0,1,'Employees'),
 (520,0,1,''),
 (521,0,1,'Premium'),
 (521,0,1,'Wholesale'),
 (521,0,1,'DeLillo Friends'),
 (521,0,1,'Employees'),
 (521,0,1,''),
 (522,0,4,'Premium'),
 (522,0,4,'Wholesale'),
 (522,0,4,'DeLillo Friends'),
 (522,0,4,'Employees'),
 (522,0,4,''),
 (523,0,1,'Premium'),
 (523,0,1,'Wholesale'),
 (523,0,1,'DeLillo Friends'),
 (523,0,1,'Employees'),
 (523,0,1,''),
 (524,0,0,'Premium'),
 (524,0,0,'Wholesale'),
 (524,0,0,'DeLillo Friends'),
 (524,0,0,'Employees'),
 (524,0,0,''),
 (525,0,0,'Premium'),
 (525,0,0,'Wholesale'),
 (525,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (525,0,0,'Employees'),
 (525,0,0,''),
 (526,0,1,'Premium'),
 (526,0,1,'Wholesale'),
 (526,0,1,'DeLillo Friends'),
 (526,0,1,'Employees'),
 (526,0,1,''),
 (527,0,5,'Premium'),
 (527,0,5,'Wholesale'),
 (527,0,5,'DeLillo Friends'),
 (527,0,5,'Employees'),
 (527,0,5,''),
 (528,0,5,'Premium'),
 (528,0,5,'Wholesale'),
 (528,0,5,'DeLillo Friends'),
 (528,0,5,'Employees'),
 (528,0,5,''),
 (529,0,1,'Premium'),
 (529,0,1,'Wholesale'),
 (529,0,1,'DeLillo Friends'),
 (529,0,1,'Employees'),
 (529,0,1,''),
 (530,0,11,'Premium'),
 (530,0,11,'Wholesale'),
 (530,0,11,'DeLillo Friends'),
 (530,0,11,'Employees'),
 (530,0,11,''),
 (531,0,4,'Premium'),
 (531,0,4,'Wholesale'),
 (531,0,4,'DeLillo Friends'),
 (531,0,4,'Employees'),
 (531,0,4,''),
 (532,0,0,'Premium'),
 (532,0,0,'Wholesale'),
 (532,0,0,'DeLillo Friends'),
 (532,0,0,'Employees'),
 (532,0,0,''),
 (533,0,1,'Premium'),
 (533,0,1,'Wholesale'),
 (533,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (533,0,1,'Employees'),
 (533,0,1,''),
 (534,0,1,'Premium'),
 (534,0,1,'Wholesale'),
 (534,0,1,'DeLillo Friends'),
 (534,0,1,'Employees'),
 (534,0,1,''),
 (535,0,1,'Premium'),
 (535,0,1,'Wholesale'),
 (535,0,1,'DeLillo Friends'),
 (535,0,1,'Employees'),
 (535,0,1,''),
 (536,0,0,'Premium'),
 (536,0,0,'Wholesale'),
 (536,0,0,'DeLillo Friends'),
 (536,0,0,'Employees'),
 (536,0,0,''),
 (537,0,2,'Premium'),
 (537,0,2,'Wholesale'),
 (537,0,2,'DeLillo Friends'),
 (537,0,2,'Employees'),
 (537,0,2,''),
 (538,0,6,'Premium'),
 (538,0,6,'Wholesale'),
 (538,0,6,'DeLillo Friends'),
 (538,0,6,'Employees'),
 (538,0,6,''),
 (539,0,2,'Premium'),
 (539,0,2,'Wholesale'),
 (539,0,2,'DeLillo Friends'),
 (539,0,2,'Employees'),
 (539,0,2,''),
 (540,0,0,'Premium'),
 (540,0,0,'Wholesale'),
 (540,0,0,'DeLillo Friends'),
 (540,0,0,'Employees'),
 (540,0,0,''),
 (541,0,1,'Premium'),
 (541,0,1,'Wholesale'),
 (541,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (541,0,1,'Employees'),
 (541,0,1,''),
 (542,0,1,'Premium'),
 (542,0,1,'Wholesale'),
 (542,0,1,'DeLillo Friends'),
 (542,0,1,'Employees'),
 (542,0,1,''),
 (543,0,0,'Premium'),
 (543,0,0,'Wholesale'),
 (543,0,0,'DeLillo Friends'),
 (543,0,0,'Employees'),
 (543,1,0,''),
 (544,0,0,'Wholesale'),
 (544,0,0,'Premium'),
 (544,0,0,'DeLillo Friends'),
 (549,0,0,'Wholesale'),
 (549,0,0,'DeLillo Friends'),
 (544,0,0,''),
 (544,0,0,'Employees'),
 (549,0,0,'Premium'),
 (547,0,1,'Premium'),
 (547,0,1,'Wholesale'),
 (547,0,1,'DeLillo Friends'),
 (547,0,1,'Employees'),
 (547,0,1,''),
 (548,0,0,'Wholesale'),
 (548,0,0,'Premium'),
 (548,0,0,'DeLillo Friends'),
 (549,0,0,'Employees'),
 (549,0,0,''),
 (550,0,0,'Premium'),
 (550,0,0,'Wholesale'),
 (550,0,0,'DeLillo Friends'),
 (550,0,0,'Employees'),
 (550,0,0,''),
 (551,0,1,'Premium'),
 (551,0,1,'Wholesale'),
 (551,0,1,'DeLillo Friends'),
 (551,0,1,'Employees'),
 (551,0,1,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (552,0,0,'Premium'),
 (552,0,0,'Wholesale'),
 (552,0,0,'DeLillo Friends'),
 (552,0,0,'Employees'),
 (552,0,0,''),
 (553,0,1,'Premium'),
 (553,0,1,'Wholesale'),
 (553,0,1,'DeLillo Friends'),
 (553,0,1,'Employees'),
 (553,0,1,''),
 (548,0,0,'Employees'),
 (548,0,0,''),
 (554,0,0,'Premium'),
 (554,0,0,'Wholesale'),
 (554,0,0,'DeLillo Friends'),
 (554,0,0,'Employees'),
 (554,0,0,''),
 (555,0,3,'Premium'),
 (555,0,3,'Wholesale'),
 (555,0,3,'DeLillo Friends'),
 (555,0,3,'Employees'),
 (555,0,3,''),
 (556,0,0,'Premium'),
 (556,0,0,'Wholesale'),
 (556,0,0,'DeLillo Friends'),
 (556,0,0,'Employees'),
 (556,0,0,''),
 (557,0,3,'Premium'),
 (557,0,3,'Wholesale'),
 (557,0,3,'DeLillo Friends'),
 (557,0,3,'Employees'),
 (557,0,3,''),
 (558,0,1,'Premium'),
 (558,0,1,'Wholesale'),
 (558,0,1,'DeLillo Friends'),
 (558,0,1,'Employees'),
 (558,0,1,''),
 (559,0,1,'Premium'),
 (559,0,1,'Wholesale'),
 (559,0,1,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (559,0,1,'Employees'),
 (559,0,1,''),
 (560,0,0,'Premium'),
 (560,0,0,'Wholesale'),
 (560,0,0,'DeLillo Friends'),
 (560,0,0,'Employees'),
 (560,0,0,''),
 (561,0,0,'Premium'),
 (561,0,0,'Wholesale'),
 (561,0,0,'DeLillo Friends'),
 (561,0,0,'Employees'),
 (561,0,0,''),
 (562,0,14,'Premium'),
 (562,0,14,'Wholesale'),
 (562,0,14,'DeLillo Friends'),
 (562,0,14,'Employees'),
 (562,0,14,''),
 (563,0,0,'Premium'),
 (563,0,0,'Wholesale'),
 (563,0,0,'DeLillo Friends'),
 (563,0,0,'Employees'),
 (563,0,0,''),
 (564,0,14,'Premium'),
 (564,0,14,'Wholesale'),
 (564,0,14,'DeLillo Friends'),
 (564,0,14,'Employees'),
 (564,0,14,''),
 (565,0,8,'Premium'),
 (565,0,8,'Wholesale'),
 (565,0,8,'DeLillo Friends'),
 (565,0,8,'Employees'),
 (565,0,8,''),
 (566,0,8,'Premium'),
 (566,0,8,'Wholesale'),
 (566,0,8,'DeLillo Friends'),
 (566,0,8,'Employees'),
 (566,0,8,''),
 (567,0,8,'Premium'),
 (567,0,8,'Wholesale'),
 (567,0,8,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (567,0,8,'Employees'),
 (567,0,8,''),
 (568,0,0,'Premium'),
 (568,0,0,'Wholesale'),
 (568,0,0,'DeLillo Friends'),
 (568,0,0,'Employees'),
 (568,0,0,''),
 (569,0,0,'Premium'),
 (569,0,0,'Wholesale'),
 (569,0,0,'DeLillo Friends'),
 (569,0,0,'Employees'),
 (569,0,0,''),
 (570,0,4,'Premium'),
 (570,0,4,'Wholesale'),
 (570,0,4,'DeLillo Friends'),
 (570,0,4,'Employees'),
 (570,0,4,''),
 (571,0,0,'Premium'),
 (571,0,0,'Wholesale'),
 (571,0,0,'DeLillo Friends'),
 (571,0,0,'Employees'),
 (571,0,0,''),
 (572,0,4,'Premium'),
 (572,0,4,'Wholesale'),
 (572,0,4,'DeLillo Friends'),
 (572,0,4,'Employees'),
 (572,0,4,''),
 (573,0,0,'Premium'),
 (573,0,0,'Wholesale'),
 (573,0,0,'DeLillo Friends'),
 (573,0,0,'Employees'),
 (573,41,0,''),
 (574,0,0,'Premium'),
 (574,0,0,'Wholesale'),
 (574,0,0,'DeLillo Friends'),
 (574,0,0,'Employees'),
 (574,0,0,''),
 (575,0,0,'Premium'),
 (575,0,0,'Wholesale'),
 (575,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (575,0,0,'Employees'),
 (575,0,0,''),
 (576,0,3,'Premium'),
 (576,0,3,'Wholesale'),
 (576,0,3,'DeLillo Friends'),
 (576,0,3,'Employees'),
 (576,0,3,''),
 (577,0,0,'Premium'),
 (577,0,0,'Wholesale'),
 (577,0,0,'DeLillo Friends'),
 (577,0,0,'Employees'),
 (577,12,0,''),
 (578,0,0,'Premium'),
 (578,0,0,'Wholesale'),
 (578,0,0,'DeLillo Friends'),
 (578,0,0,'Employees'),
 (578,0,0,''),
 (579,0,3,'Premium'),
 (579,0,3,'Wholesale'),
 (579,0,3,'DeLillo Friends'),
 (579,0,3,'Employees'),
 (579,0,3,''),
 (580,0,0,'Premium'),
 (580,0,0,'Wholesale'),
 (580,0,0,'DeLillo Friends'),
 (580,0,0,'Employees'),
 (580,0,0,''),
 (581,0,0,'Premium'),
 (581,0,0,'Wholesale'),
 (581,0,0,'DeLillo Friends'),
 (581,0,0,'Employees'),
 (581,0,0,''),
 (582,0,8,'Premium'),
 (582,0,8,'Wholesale'),
 (582,0,8,'DeLillo Friends'),
 (582,0,8,'Employees'),
 (582,0,8,''),
 (583,0,0,'Premium'),
 (583,0,0,'Wholesale'),
 (583,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (583,0,0,'Employees'),
 (583,0,0,''),
 (584,0,8,'Premium'),
 (584,0,8,'Wholesale'),
 (584,0,8,'DeLillo Friends'),
 (584,0,8,'Employees'),
 (584,0,8,''),
 (585,0,0,'Premium'),
 (585,0,0,'Wholesale'),
 (585,0,0,'DeLillo Friends'),
 (585,0,0,'Employees'),
 (585,0,0,''),
 (586,0,3,'Premium'),
 (586,0,3,'Wholesale'),
 (586,0,3,'DeLillo Friends'),
 (586,0,3,'Employees'),
 (586,0,3,''),
 (587,0,0,'Premium'),
 (587,0,0,'Wholesale'),
 (587,0,0,'DeLillo Friends'),
 (587,0,0,'Employees'),
 (587,0,0,''),
 (588,0,3,'Premium'),
 (588,0,3,'Wholesale'),
 (588,0,3,'DeLillo Friends'),
 (588,0,3,'Employees'),
 (588,0,3,''),
 (589,0,5,'Premium'),
 (589,0,5,'Wholesale'),
 (589,0,5,'DeLillo Friends'),
 (589,0,5,'Employees'),
 (589,0,5,''),
 (590,0,5,'Premium'),
 (590,0,5,'Wholesale'),
 (590,0,5,'DeLillo Friends'),
 (590,0,5,'Employees'),
 (590,0,5,''),
 (591,0,5,'Premium'),
 (591,0,5,'Wholesale'),
 (591,0,5,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (591,0,5,'Employees'),
 (591,0,5,''),
 (592,0,0,'Premium'),
 (592,0,0,'Wholesale'),
 (592,0,0,'DeLillo Friends'),
 (592,0,0,'Employees'),
 (592,0,0,''),
 (593,0,5,'Premium'),
 (593,0,5,'Wholesale'),
 (593,0,5,'DeLillo Friends'),
 (593,0,5,'Employees'),
 (593,0,5,''),
 (594,0,0,'Premium'),
 (594,0,0,'Wholesale'),
 (594,0,0,'DeLillo Friends'),
 (594,0,0,'Employees'),
 (594,19,0,''),
 (595,0,0,'Premium'),
 (595,0,0,'Wholesale'),
 (595,0,0,'DeLillo Friends'),
 (595,0,0,'Employees'),
 (595,0,0,''),
 (596,0,0,'Premium'),
 (596,0,0,'Wholesale'),
 (596,0,0,'DeLillo Friends'),
 (596,0,0,'Employees'),
 (596,0,0,''),
 (597,0,2,'Premium'),
 (597,0,2,'Wholesale'),
 (597,0,2,'DeLillo Friends'),
 (597,0,2,'Employees'),
 (597,0,2,''),
 (598,0,0,'Premium'),
 (598,0,0,'Wholesale'),
 (598,0,0,'DeLillo Friends'),
 (598,0,0,'Employees'),
 (598,0,0,''),
 (599,0,0,'Premium'),
 (599,0,0,'Wholesale'),
 (599,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (599,0,0,'Employees'),
 (599,0,0,''),
 (600,0,3,'Premium'),
 (600,0,3,'Wholesale'),
 (600,0,3,'DeLillo Friends'),
 (600,0,3,'Employees'),
 (600,0,3,''),
 (601,0,1,'Premium'),
 (601,0,1,'Wholesale'),
 (601,0,1,'DeLillo Friends'),
 (601,0,1,'Employees'),
 (601,0,1,''),
 (602,0,8,'Premium'),
 (602,0,8,'Wholesale'),
 (602,0,8,'DeLillo Friends'),
 (602,0,8,'Employees'),
 (602,0,8,''),
 (603,0,8,'Premium'),
 (603,0,8,'Wholesale'),
 (603,0,8,'DeLillo Friends'),
 (603,0,8,'Employees'),
 (603,0,8,''),
 (604,0,16,'Premium'),
 (604,0,16,'Wholesale'),
 (604,0,16,'DeLillo Friends'),
 (604,0,16,'Employees'),
 (604,0,16,''),
 (605,0,16,'Premium'),
 (605,0,16,'Wholesale'),
 (605,0,16,'DeLillo Friends'),
 (605,0,16,'Employees'),
 (605,0,16,''),
 (606,0,9,'Premium'),
 (606,0,9,'Wholesale'),
 (606,0,9,'DeLillo Friends'),
 (606,0,9,'Employees'),
 (606,0,9,''),
 (607,0,0,'Premium'),
 (607,0,0,'Wholesale'),
 (607,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (607,0,0,'Employees'),
 (607,0,0,''),
 (608,0,16,'Premium'),
 (608,0,16,'Wholesale'),
 (608,0,16,'DeLillo Friends'),
 (608,0,16,'Employees'),
 (608,0,16,''),
 (609,0,0,'Premium'),
 (609,0,0,'Wholesale'),
 (609,0,0,'DeLillo Friends'),
 (609,0,0,'Employees'),
 (609,0,0,''),
 (610,0,3,'Premium'),
 (610,0,3,'Wholesale'),
 (610,0,3,'DeLillo Friends'),
 (610,0,3,'Employees'),
 (610,0,3,''),
 (611,0,0,'Premium'),
 (611,0,0,'Wholesale'),
 (611,0,0,'DeLillo Friends'),
 (611,0,0,'Employees'),
 (611,0,0,''),
 (612,0,3,'Premium'),
 (612,0,3,'Wholesale'),
 (612,0,3,'DeLillo Friends'),
 (612,0,3,'Employees'),
 (612,0,3,''),
 (613,0,5,'Premium'),
 (613,0,5,'Wholesale'),
 (613,0,5,'DeLillo Friends'),
 (613,0,5,'Employees'),
 (613,0,5,''),
 (614,0,5,'Premium'),
 (614,0,5,'Wholesale'),
 (614,0,5,'DeLillo Friends'),
 (614,0,5,'Employees'),
 (614,0,5,''),
 (615,0,5,'Premium'),
 (615,0,5,'Wholesale'),
 (615,0,5,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (615,0,5,'Employees'),
 (615,0,5,''),
 (616,0,0,'Premium'),
 (616,0,0,'Wholesale'),
 (616,0,0,'DeLillo Friends'),
 (616,0,0,'Employees'),
 (616,2,0,''),
 (617,0,5,'Premium'),
 (617,0,5,'Wholesale'),
 (617,0,5,'DeLillo Friends'),
 (617,0,5,'Employees'),
 (617,0,5,''),
 (618,0,0,'Premium'),
 (618,0,0,'Wholesale'),
 (618,0,0,'DeLillo Friends'),
 (618,0,0,'Employees'),
 (618,0,0,''),
 (619,0,3,'Premium'),
 (619,0,3,'Wholesale'),
 (619,0,3,'DeLillo Friends'),
 (619,0,3,'Employees'),
 (619,0,3,''),
 (620,0,0,'Premium'),
 (620,0,0,'Wholesale'),
 (620,0,0,'DeLillo Friends'),
 (620,0,0,'Employees'),
 (620,0,0,''),
 (621,0,2,'Premium'),
 (621,0,2,'Wholesale'),
 (621,0,2,'DeLillo Friends'),
 (621,0,2,'Employees'),
 (621,0,2,''),
 (622,0,0,'Premium'),
 (622,0,0,'Wholesale'),
 (622,0,0,'DeLillo Friends'),
 (622,0,0,'Employees'),
 (622,0,0,''),
 (623,0,0,'Premium'),
 (623,0,0,'Wholesale'),
 (623,0,0,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (623,0,0,'Employees'),
 (623,0,0,''),
 (624,0,1,'Premium'),
 (624,0,1,'Wholesale'),
 (624,0,1,'DeLillo Friends'),
 (624,0,1,'Employees'),
 (624,0,1,''),
 (625,0,2,'Premium'),
 (625,0,2,'Wholesale'),
 (625,0,2,'DeLillo Friends'),
 (625,0,2,'Employees'),
 (625,0,2,''),
 (626,0,1,'Premium'),
 (626,0,1,'Wholesale'),
 (626,0,1,'DeLillo Friends'),
 (626,0,1,'Employees'),
 (626,0,1,''),
 (627,0,1,'Premium'),
 (627,0,1,'Wholesale'),
 (627,0,1,'DeLillo Friends'),
 (627,0,1,'Employees'),
 (627,0,1,''),
 (628,0,1,'Premium'),
 (628,0,1,'Wholesale'),
 (628,0,1,'DeLillo Friends'),
 (628,0,1,'Employees'),
 (628,0,1,''),
 (629,0,1,'Premium'),
 (629,0,1,'Wholesale'),
 (629,0,1,'DeLillo Friends'),
 (629,0,1,'Employees'),
 (629,0,1,''),
 (630,0,1,'Premium'),
 (630,0,1,'Wholesale'),
 (630,0,1,'DeLillo Friends'),
 (630,0,1,'Employees'),
 (630,0,1,''),
 (631,0,3,'Premium'),
 (631,0,3,'Wholesale'),
 (631,0,3,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (631,0,3,'Employees'),
 (631,0,3,''),
 (632,0,3,'Premium'),
 (632,0,3,'Wholesale'),
 (632,0,3,'DeLillo Friends'),
 (632,0,3,'Employees'),
 (632,0,3,''),
 (633,0,7,'Premium'),
 (633,0,7,'Wholesale'),
 (633,0,7,'DeLillo Friends'),
 (633,0,7,'Employees'),
 (633,0,7,''),
 (634,0,0,'Premium'),
 (634,0,0,'Wholesale'),
 (634,0,0,'DeLillo Friends'),
 (634,0,0,'Employees'),
 (634,0,0,''),
 (635,0,0,'Premium'),
 (635,0,0,'Wholesale'),
 (635,0,0,'DeLillo Friends'),
 (635,0,0,'Employees'),
 (635,0,0,''),
 (636,0,6,'Premium'),
 (636,0,6,'Wholesale'),
 (636,0,6,'DeLillo Friends'),
 (636,0,6,'Employees'),
 (636,0,6,''),
 (637,0,4,'Premium'),
 (637,0,4,'Wholesale'),
 (637,0,4,'DeLillo Friends'),
 (637,0,4,'Employees'),
 (637,0,4,''),
 (638,0,4,'Premium'),
 (638,0,4,'Wholesale'),
 (638,0,4,'DeLillo Friends'),
 (638,0,4,'Employees'),
 (638,0,4,''),
 (639,0,6,'Premium'),
 (639,0,6,'Wholesale'),
 (639,0,6,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (639,0,6,'Employees'),
 (639,0,6,''),
 (640,0,0,'Premium'),
 (640,0,0,'Wholesale'),
 (640,0,0,'DeLillo Friends'),
 (640,0,0,'Employees'),
 (640,0,0,''),
 (641,0,12,'Premium'),
 (641,0,12,'Wholesale'),
 (641,0,12,'DeLillo Friends'),
 (641,0,12,'Employees'),
 (641,0,12,''),
 (642,0,0,'Premium'),
 (642,0,0,'Wholesale'),
 (642,0,0,'DeLillo Friends'),
 (642,0,0,'Employees'),
 (642,0,0,''),
 (643,0,4,'Premium'),
 (643,0,4,'Wholesale'),
 (643,0,4,'DeLillo Friends'),
 (643,0,4,'Employees'),
 (643,0,4,''),
 (644,0,2,'Premium'),
 (644,0,2,'Wholesale'),
 (644,0,2,'DeLillo Friends'),
 (644,0,2,'Employees'),
 (644,0,2,''),
 (645,0,0,'Premium'),
 (645,0,0,'Wholesale'),
 (645,0,0,'DeLillo Friends'),
 (645,0,0,'Employees'),
 (645,0,0,''),
 (646,0,2,'Premium'),
 (646,0,2,'Wholesale'),
 (646,0,2,'DeLillo Friends'),
 (646,0,2,'Employees'),
 (646,0,2,''),
 (647,0,2,'Premium'),
 (647,0,2,'Wholesale'),
 (647,0,2,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (647,0,2,'Employees'),
 (647,0,2,''),
 (648,0,2,'Premium'),
 (648,0,2,'Wholesale'),
 (648,0,2,'DeLillo Friends'),
 (648,0,2,'Employees'),
 (648,0,2,''),
 (649,0,2,'Premium'),
 (649,0,2,'Wholesale'),
 (649,0,2,'DeLillo Friends'),
 (649,0,2,'Employees'),
 (649,0,2,''),
 (650,0,2,'Premium'),
 (650,0,2,'Wholesale'),
 (650,0,2,'DeLillo Friends'),
 (650,0,2,'Employees'),
 (650,0,2,''),
 (651,0,2,'Premium'),
 (651,0,2,'Wholesale'),
 (651,0,2,'DeLillo Friends'),
 (651,0,2,'Employees'),
 (651,0,2,''),
 (652,0,4,'Premium'),
 (652,0,4,'Wholesale'),
 (652,0,4,'DeLillo Friends'),
 (652,0,4,'Employees'),
 (652,0,4,''),
 (653,0,2,'Premium'),
 (653,0,2,'Wholesale'),
 (653,0,2,'DeLillo Friends'),
 (653,0,2,'Employees'),
 (653,0,2,''),
 (654,0,2,'Premium'),
 (654,0,2,'Wholesale'),
 (654,0,2,'DeLillo Friends'),
 (654,0,2,'Employees'),
 (654,0,2,''),
 (655,0,2,'Premium'),
 (655,0,2,'Wholesale'),
 (655,0,2,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (655,0,2,'Employees'),
 (655,0,2,''),
 (656,0,0,'Premium'),
 (656,0,0,'Wholesale'),
 (656,0,0,'DeLillo Friends'),
 (656,0,0,'Employees'),
 (656,2,0,''),
 (657,0,0,'Premium'),
 (657,0,0,'Wholesale'),
 (657,0,0,'DeLillo Friends'),
 (657,0,0,'Employees'),
 (657,1,0,''),
 (658,0,1,'Premium'),
 (658,0,1,'Wholesale'),
 (658,0,1,'DeLillo Friends'),
 (658,0,1,'Employees'),
 (658,0,1,''),
 (659,0,0,'Premium'),
 (659,0,0,'Wholesale'),
 (659,0,0,'DeLillo Friends'),
 (659,0,0,'Employees'),
 (659,0,0,''),
 (761,0,2,'DeLillo Friends'),
 (738,0,2,'Employees'),
 (738,0,2,''),
 (739,0,4,'Premium'),
 (739,0,4,'Wholesale'),
 (739,0,4,'DeLillo Friends'),
 (739,0,4,'Employees'),
 (739,0,4,''),
 (740,0,8,'Premium'),
 (740,0,8,'Wholesale'),
 (740,0,8,'DeLillo Friends'),
 (740,0,8,'Employees'),
 (740,0,8,''),
 (741,0,0,'Premium'),
 (741,0,0,'Wholesale'),
 (741,0,0,'DeLillo Friends'),
 (741,0,0,'Employees'),
 (741,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (742,0,4,'Premium'),
 (742,0,4,'Wholesale'),
 (742,0,4,'DeLillo Friends'),
 (742,0,4,'Employees'),
 (742,0,4,''),
 (743,0,2,'Premium'),
 (743,0,2,'Wholesale'),
 (743,0,2,'DeLillo Friends'),
 (743,0,2,'Employees'),
 (743,0,2,''),
 (744,0,0,'Premium'),
 (744,0,0,'Wholesale'),
 (744,0,0,'DeLillo Friends'),
 (744,0,0,'Employees'),
 (744,0,0,''),
 (745,0,1,'Premium'),
 (745,0,1,'Wholesale'),
 (745,0,1,'DeLillo Friends'),
 (745,0,1,'Employees'),
 (745,0,1,''),
 (746,0,1,'Premium'),
 (746,0,1,'Wholesale'),
 (746,0,1,'DeLillo Friends'),
 (746,0,1,'Employees'),
 (746,0,1,''),
 (747,0,7,'Premium'),
 (747,0,7,'Wholesale'),
 (747,0,7,'DeLillo Friends'),
 (747,0,7,'Employees'),
 (747,0,7,''),
 (748,0,4,'Premium'),
 (748,0,4,'Wholesale'),
 (748,0,4,'DeLillo Friends'),
 (748,0,4,'Employees'),
 (748,0,4,''),
 (749,0,0,'Premium'),
 (749,0,0,'Wholesale'),
 (749,0,0,'DeLillo Friends'),
 (749,0,0,'Employees'),
 (749,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (750,0,2,'Premium'),
 (750,0,2,'Wholesale'),
 (750,0,2,'DeLillo Friends'),
 (750,0,2,'Employees'),
 (750,0,2,''),
 (751,0,0,'Premium'),
 (751,0,0,'Wholesale'),
 (751,0,0,'DeLillo Friends'),
 (751,0,0,'Employees'),
 (751,2,0,''),
 (752,0,4,'Premium'),
 (752,0,4,'Wholesale'),
 (752,0,4,'DeLillo Friends'),
 (752,0,4,'Employees'),
 (752,0,4,''),
 (753,0,0,'Premium'),
 (753,0,0,'Wholesale'),
 (753,0,0,'DeLillo Friends'),
 (753,0,0,'Employees'),
 (753,0,0,''),
 (754,0,1,'Premium'),
 (754,0,1,'Wholesale'),
 (754,0,1,'DeLillo Friends'),
 (754,0,1,'Employees'),
 (754,0,1,''),
 (755,0,2,'Premium'),
 (755,0,2,'Wholesale'),
 (755,0,2,'DeLillo Friends'),
 (755,0,2,'Employees'),
 (755,0,2,''),
 (756,0,1,'Premium'),
 (756,0,1,'Wholesale'),
 (756,0,1,'DeLillo Friends'),
 (756,0,1,'Employees'),
 (756,0,1,''),
 (757,0,0,'Premium'),
 (757,0,0,'Wholesale'),
 (757,0,0,'DeLillo Friends'),
 (757,0,0,'Employees'),
 (757,0,0,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (758,0,10,'Premium'),
 (758,0,10,'Wholesale'),
 (758,0,10,'DeLillo Friends'),
 (758,0,10,'Employees'),
 (758,0,10,''),
 (759,0,7,'Premium'),
 (759,0,7,'Wholesale'),
 (759,0,7,'DeLillo Friends'),
 (759,0,7,'Employees'),
 (759,0,7,''),
 (760,0,2,'Premium'),
 (760,0,2,'Wholesale'),
 (760,0,2,'DeLillo Friends'),
 (760,0,2,'Employees'),
 (760,0,2,''),
 (761,0,2,'Premium'),
 (761,0,2,'Wholesale'),
 (738,0,2,'DeLillo Friends'),
 (738,0,2,'Wholesale'),
 (737,0,0,''),
 (737,0,0,'Employees'),
 (738,0,2,'Premium'),
 (737,0,0,'DeLillo Friends'),
 (737,0,0,'Wholesale'),
 (736,0,3,''),
 (736,0,3,'Employees'),
 (737,0,0,'Premium'),
 (736,0,3,'DeLillo Friends'),
 (736,0,3,'Wholesale'),
 (735,0,1,''),
 (735,0,1,'Employees'),
 (736,0,3,'Premium'),
 (735,0,1,'DeLillo Friends'),
 (735,0,1,'Wholesale'),
 (734,0,2,''),
 (734,0,2,'Employees'),
 (735,0,1,'Premium'),
 (734,0,2,'DeLillo Friends'),
 (734,0,2,'Wholesale'),
 (733,0,2,'');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (733,0,2,'Employees'),
 (734,0,2,'Premium'),
 (733,0,2,'DeLillo Friends'),
 (733,0,2,'Wholesale'),
 (732,0,7,''),
 (732,0,7,'Employees'),
 (733,0,2,'Premium'),
 (732,0,7,'DeLillo Friends'),
 (732,0,7,'Wholesale'),
 (731,0,0,''),
 (731,0,0,'Employees'),
 (732,0,7,'Premium'),
 (731,0,0,'DeLillo Friends'),
 (731,0,0,'Wholesale'),
 (730,35,0,''),
 (730,0,0,'Employees'),
 (731,0,0,'Premium'),
 (730,0,0,'Wholesale'),
 (730,0,0,'Premium'),
 (730,0,0,'DeLillo Friends'),
 (761,0,2,'Employees'),
 (761,0,2,''),
 (762,0,1,'Premium'),
 (762,0,1,'Wholesale'),
 (762,0,1,'DeLillo Friends'),
 (762,0,1,'Employees'),
 (762,0,1,''),
 (763,0,3,'Premium'),
 (763,0,3,'Wholesale'),
 (763,0,3,'DeLillo Friends'),
 (763,0,3,'Employees'),
 (763,0,3,''),
 (764,0,1,'Premium'),
 (764,0,1,'Wholesale'),
 (764,0,1,'DeLillo Friends'),
 (764,0,1,'Employees'),
 (764,0,1,''),
 (765,0,2,'Premium'),
 (765,0,2,'Wholesale'),
 (765,0,2,'DeLillo Friends');
INSERT INTO `xcart_categories_subcount` (`categoryid`,`subcategory_count`,`product_count`,`membership`) VALUES 
 (765,0,2,'Employees'),
 (765,0,2,'');
/*!40000 ALTER TABLE `xcart_categories_subcount` ENABLE KEYS */;


--
-- Definition of table `xcart_cc_gestpay_data`
--

DROP TABLE IF EXISTS `xcart_cc_gestpay_data`;
CREATE TABLE `xcart_cc_gestpay_data` (
  `value` char(32) NOT NULL default '',
  `type` char(1) NOT NULL default 'C',
  PRIMARY KEY  (`value`,`type`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_cc_gestpay_data`
--

/*!40000 ALTER TABLE `xcart_cc_gestpay_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `xcart_cc_gestpay_data` ENABLE KEYS */;


--
-- Definition of table `xcart_cc_pp3_data`
--

DROP TABLE IF EXISTS `xcart_cc_pp3_data`;
CREATE TABLE `xcart_cc_pp3_data` (
  `ref` varchar(255) NOT NULL default '',
  `sessionid` varchar(255) NOT NULL default '',
  `param1` varchar(255) NOT NULL default '',
  `param2` varchar(255) NOT NULL default '',
  `param3` varchar(255) NOT NULL default '',
  `param4` varchar(255) NOT NULL default '',
  `param5` varchar(255) NOT NULL default '',
  `trstat` varchar(255) NOT NULL default '',
  UNIQUE KEY `refk` (`ref`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_cc_pp3_data`
--

/*!40000 ALTER TABLE `xcart_cc_pp3_data` DISABLE KEYS */;
INSERT INTO `xcart_cc_pp3_data` (`ref`,`sessionid`,`param1`,`param2`,`param3`,`param4`,`param5`,`trstat`) VALUES 
 ('2ec39429c8c9675b79197bd2711787c2','aae30b6f7f8a687d34e4075fba947820','','','','','','GO|4'),
 ('47e961ab93b486804fff3b0498ecc133','300f92d0d63ab9c676946878bda80937','','','','','','GO|5'),
 ('47b7384514d1aa66daa4d48d3c4d148c','300f92d0d63ab9c676946878bda80937','','','','','','GO|6'),
 ('72b943cc1bf5a3dc2aa14995b20b68a9','300f92d0d63ab9c676946878bda80937','','','','','','GO|7'),
 ('b369136b16ec56c56d2e33b5bd4ca237','300f92d0d63ab9c676946878bda80937','','','','','','GO|8'),
 ('d8db64c28d20ead7b24fe607d901c9e9','1cd9c28609ebccd207efea328f5c0a35','','','','','','GO|9'),
 ('7eb781914ec83586cd90876d16c79acd','19cd2aa005d01a72cb9bc5aed455e94b','','','','','','GO|10'),
 ('9dd842173995bfbc71bd677a1098c392','0c02355696d648c32e30c9d16719f716','','','','','','GO|11'),
 ('cbaa8ac019f87641209b724abd6b1c79','e5a07ae9b87de7fbc3c023809ad69261','','','','','','GO|12'),
 ('aa10bbabe5ba359c25659fb87ff4a63d','acf8f98a5e7311821a70120da52a18c5','','','','','','GO|13');
/*!40000 ALTER TABLE `xcart_cc_pp3_data` ENABLE KEYS */;


--
-- Definition of table `xcart_ccprocessors`
--

DROP TABLE IF EXISTS `xcart_ccprocessors`;
CREATE TABLE `xcart_ccprocessors` (
  `module_name` varchar(255) NOT NULL default '',
  `type` char(1) NOT NULL default '',
  `processor` varchar(255) NOT NULL default '',
  `template` varchar(255) NOT NULL default '',
  `param01` varchar(255) NOT NULL default '',
  `param02` varchar(255) NOT NULL default '',
  `param03` varchar(255) NOT NULL default '',
  `param04` varchar(255) NOT NULL default '',
  `param05` varchar(255) NOT NULL default '',
  `param06` varchar(255) NOT NULL default '',
  `param07` varchar(255) NOT NULL default '',
  `param08` varchar(255) NOT NULL default '',
  `param09` varchar(255) NOT NULL default '',
  `disable_ccinfo` char(1) NOT NULL default 'N',
  `background` char(1) NOT NULL default 'N',
  `testmode` char(1) NOT NULL default 'N',
  `is_check` char(1) NOT NULL default '',
  `is_refund` char(1) NOT NULL default '',
  `c_template` varchar(255) NOT NULL default '',
  `paymentid` int(11) NOT NULL default '0',
  `cmpi` char(1) NOT NULL default '',
  PRIMARY KEY  (`module_name`),
  KEY `module_name` (`module_name`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_ccprocessors`
--

/*!40000 ALTER TABLE `xcart_ccprocessors` DISABLE KEYS */;
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('AuthorizeNet: AIM','C','cc_authorizenet.php','cc_authorizenet.tpl','7f34fba2d03993eb','7f34fba2d03993eb','','123','AFA','123','A','','','N','Y','Y','','','',0,'Y'),
 ('iTransact (ProcessUSA). XML scheme','C','cc_processusa.php','cc_processusa.tpl','123','123','123','','','','','','','N','Y','N','','','',0,''),
 ('IntelliPay: ExpertLink','C','cc_intellipaycom.php','cc_intellipaycom.tpl','test','test_password','www.x-cart.com','','','','','','','C','Y','N','','','',0,''),
 ('2Checkout','C','cc_2checkoutcom.php','cc_2checkoutcom.tpl','1231111','123','123','','','','','','','Y','N','N','','','',0,''),
 ('WorldPay','C','cc_worldpay.php','cc_worldpay.tpl','','','','','','','','','','Y','N','A','','','',0,''),
 ('LinkPoint','C','cc_linkpoint.php','cc_linkpoint.tpl','123123123123','123','','not_provided','','','','','','N','Y','A','','','',0,''),
 ('VeriSign PayFlow Pro','C','cc_verisign.php','cc_verisign.tpl','','','','','','','','','','N','Y','Y','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('PlugnPay. Remote Auth method','C','cc_plugnpaycom.php','cc_plugnpaycom.tpl','','','pay1.plugnpay.com','','','','','','','N','Y','N','','','',0,''),
 ('PSiGate','C','cc_psigate.php','cc_psigate.tpl','','','','','','','','','','C','N','N','','','',0,''),
 ('SkipJack','C','cc_skipjack.php','cc_skipjack.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('GestPay','C','cc_gestpay.php','cc_gestpay.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('VeriSign Link','C','cc_verisignl.php','cc_verisignl.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('SECPay','C','cc_secpay.php','cc_secpay.tpl','secpay','true','false','','','','','','','Y','N','A','','','',0,''),
 ('Saferpay','C','cc_saferpay.php','cc_saferpay.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('GoChargeIt','C','cc_chargeit.php','cc_chargeit.tpl','merchant','test','','','','','','','','C','N','Y','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('ePDQ','C','cc_epdq.php','cc_epdq.tpl','merchantdisplayname','id0000','password','840','PreAuth','','','','','Y','N','N','','','',0,''),
 ('eWAY.XML payment','C','cc_eway.php','cc_eway.tpl','87654321','TRUE','','','','','','','','N','Y','A','','','',0,''),
 ('EFSnet','C','cc_efs.php','cc_efs.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('Bank of America','C','cc_bank.php','cc_bank.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('CyberCash','C','cc_ccash.php','cc_ccash.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('BluePay','C','cc_blue.php','cc_blue.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('MultiPay','C','cc_multi.php','cc_multi.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('ProxyPay3','C','cc_pp3.php','cc_pp3.tpl','https://ep.eurocommerce.gr/proxypay/apacs','','0840','Y','','','','','','Y','N','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('PayGateway (Paradata Systems)','C','cc_pgw.php','cc_pgw.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('USAePay','C','cc_usaepay.php','cc_usaepay.tpl','','','','','','','','','','N','Y','Y','','','',0,'Y'),
 ('PayNet','C','cc_paynet.php','cc_paynet.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('PaySystems','C','cc_paysystems.php','cc_paysystems.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('E-Gold','P','cc_egold.php','cc_egold.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('E-Dinar','P','cc_edinar.php','cc_edinar.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('InternetSecure','C','cc_isecure.php','cc_isecure.tpl','','','','','','','','','','Y','N','A','','','',0,''),
 ('TransFirst eLink (Server based solution)','C','cc_dpil.php','cc_dpil.tpl','','','','','','','','','','N','Y','Y','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('IO*NGATE','C','cc_iongatecom.php','cc_iongatecom.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('Netbilling','C','cc_netbilling.php','cc_netbilling.tpl','','','','','','','','','','N','Y','N','','','',0,'Y'),
 ('X-Cart TEST','C','cc_test.php','cc_test.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('CentiPaid','P','cc_centi.php','cc_centi.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('MerchantPartners','C','cc_gcomm.php','cc_gcomm.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('eSelect plus','C','cc_eselect.php','cc_eselect.tpl','','','43924','','','','','','','C','Y','Y','','','',0,''),
 ('ECHOnline','C','cc_echo.php','cc_echo.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('PayGate','C','cc_paygate.php','cc_paygate.tpl','','','','','','','','','','N','Y','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('GZS:PayMaster','C','cc_gzs.php','cc_gzs.tpl','123','USD','','123','123','','','','','N','Y','N','','','',0,''),
 ('NetRegistry e-commerce','C','cc_nrecom.php','cc_nrecom.tpl','','','','','','','','','','C','Y','N','','','',0,''),
 ('PayBox','C','cc_paybox.php','cc_paybox.tpl','1999888','99','','','','','','','','Y','N','N','','','',0,''),
 ('Protx VSP Form','C','cc_protx.php','cc_protx.tpl','TestVendor','testvendor','USD','Y','','','','','','Y','N','Y','','','',0,''),
 ('Cambist','C','cc_cambist.php','cc_cambist.tpl','DEMO','DEMO Merchant','','','','','','','','N','Y','Y','','','',0,''),
 ('DataTrans','C','cc_datatrans.php','cc_datatrans.tpl','1000011011','','','','','','','','','N','Y','N','','','',0,''),
 ('Direct Payment Solution: PX POST','C','cc_dps.php','cc_dps.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('3Delta Systems','C','cc_3delta.php','cc_3delta.tpl','','','','','','','','','','Y','N','Y','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('Pasat Internet','C','cc_pi.php','cc_pi.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('ZipZap','C','cc_zipzap.php','cc_zipzap.tpl','','','','','','','','','','C','Y','N','','','',0,''),
 ('SurePay','C','cc_surepay.php','cc_surepay.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('eSec.Direct','C','cc_esecd.php','cc_esec.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('eSec.ReDirect','C','cc_esec.php','cc_esec.tpl','','','','','','','','','','N','N','A','','','',0,''),
 ('Wells Fargo','C','cc_wells.php','cc_wells.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('VaultX','C','cc_vaultx.php','cc_vaultx.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('Scopus Tecnologia','C','cc_scopus.php','cc_scopus.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('SECURETRADING','C','cc_securetrading.php','cc_securetrading.tpl','','','GBP','','','','','','','Y','N','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('RTWare: ADC Direct Response','C','cc_rtware.php','cc_rtware.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('PayZip.Net: Web2Web','C','cc_payzip.php','cc_payzip.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('Protx VSP Direct','C','cc_protxdir.php','cc_protxdir.tpl','','','','','','','','','','N','Y','Y','','','',0,'Y'),
 ('Ogone','C','cc_ogone.php','cc_ogone.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('SmartPag','C','cc_smartpag.php','cc_smartpag.tpl','123','123123123','','','','','','','','Y','N','N','','','main/register_ccsmartpag.tpl',0,''),
 ('eProcessingNetwork. Transparent.','C','cc_eproc.php','cc_eproc.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('NetBanx','C','cc_netbanx.php','cc_netbanx.tpl','','','','','','','','','','Y','N','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('eWAY.Shared payment','C','cc_ewayweb.php','cc_ewayweb.tpl','87654321','TRUE','','','','','','','','Y','N','Y','','','',0,''),
 ('World Swift','P','cc_wswift.php','cc_wswift.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('PaySystems Client','C','cc_psclient.php','cc_psclient.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('AccessPoint (MerchantManager)','C','cc_mm.php','cc_mm.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('Clear Commerce (PayFuse)','C','cc_fuse.php','cc_fuse.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('TrustCommerce','C','cc_trustcommerce.php','cc_trustcommerce.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('viaKlix','C','cc_viaklix.php','cc_viaklix.tpl','','','','','','','','','','N','N','Y','','','',0,''),
 ('viaKlix 2.0','C','cc_viaklix2.php','cc_viaklix2.tpl','','','','','','','','','','N','N','Y','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('E-Gateway (Mantis Technologies)','C','cc_egateway.php','cc_egateway.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Slim CD','C','cc_slim.php','cc_slim.tpl','1','562519011','2','testmaster','','','','','','N','Y','N','','','',0,''),
 ('Transaction Central. XML Interface','C','cc_pri.php','cc_pri.tpl','10011','1234','','','','','','','','C','Y','N','','','',0,''),
 ('Transaction Central. WEB Interface','C','cc_priw.php','cc_priw.tpl','10011','1234','','','','','','','','Y','N','N','','','',0,''),
 ('Transaction Central. POST Interface','C','cc_prip.php','cc_prip.tpl','10011','1234','','','','','','','','N','Y','N','','','',0,''),
 ('Ezic. Direct mode V3.x','C','cc_ezic.php','cc_ezic.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('BiBiT','C','cc_bibit.php','cc_bibit.tpl','2342342','234','','','ARS','','','','','N','Y','Y','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('Velocity Pay','C','cc_vp.php','cc_vp.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Innovative E-Commerce','C','cc_innec.php','cc_innec.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('SecurePay','C','cc_securepay.php','cc_securepay.tpl','','','','','','','','','','C','Y','N','','','',0,''),
 ('Jettis','C','cc_jettis.php','cc_jettis.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('MultiCards','C','cc_multicard.php','cc_multicard.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Money Bookers','P','cc_mbookers.php','cc_mbookers.tpl','123','CZK','EN','3123','','','','','','Y','N','N','','','',0,''),
 ('Lynk Systems','C','cc_lynksystems.php','cc_lynksystems.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('DeltaPAY','C','cc_delta.php','cc_delta.tpl','','','','','','','','','','Y','N','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('AuthorizeNet: SIM','C','cc_authorizenet_sim.php','cc_authorizenet_sim.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Censeo (dialog)','C','cc_censeo_d.php','cc_censeo.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Censeo (no dialog)','C','cc_censeo.php','cc_censeo.tpl','','','','','','','','','','N','N','N','','','',0,''),
 ('CyberSource','C','cc_csrc.php','cc_csrc.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('PayByCheck','H','ch_paybycheck.php','ch_paybycheck.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('WTSbank','H','ch_wtsbank.php','ch_wtsbank.tpl','','','','','','','','','','N','N','N','','','',0,''),
 ('AuthorizeNet.eCheck','H','ch_authorizenet.php','ch_authorizenet.tpl','7f34fba2d03993eb','7f34fba2d03993eb','Y','123','AFA','222','A','','','','N','Y','','','customer/main/ch_authorizenet.tpl',0,''),
 ('PayPal','P','ps_paypal.php','ps_paypal.tpl','delilloebay@delillo.com','PayPal & Credit Cards','USD','','','','','','','Y','N','N','','','',17,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('Nochex','P','ps_nochex.php','ps_nochex.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('GoEmerchant','C','cc_goem.php','cc_goem.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('GoEmerchant XML','C','cc_goem_xml.php','cc_goem.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('Way2Pay','P','cc_w2p.php','cc_w2p.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('ANZ eGate','C','cc_anz.php','cc_anz.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('NetPay','P','cc_netpay.php','cc_netpay.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('YourPay','C','cc_yourpay.php','cc_yourpay.tpl','','','','','','','','','','N','Y','A','','','',0,''),
 ('Payment Express (Hosted payment page)','C','cc_dpilpx.php','cc_dpilpx.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Bean Stream','C','cc_bean.php','cc_bean.tpl','','','','','','','','','','N','Y','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('FirePay','C','cc_fire.php','cc_fire.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('uSight','C','cc_usight.php','cc_usight.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('PlugnPay. Smart Screen method','C','cc_pnpss.php','cc_pnpss.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('PayWeb','C','cc_payweb.php','cc_payweb.tpl','10011013800','','','','','','','','','Y','N','N','','','',0,''),
 ('Cardia Shop','C','cc_cardia2.php','cc_cardia2.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('Smart people','C','cc_people.php','cc_people.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('EZTP','C','cc_eztp.php','cc_eztp.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('iDeb','C','cc_ideb.php','cc_ideb.tpl','','','','','','','','','','N','Y','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('YellowPay','C','cc_yellow.php','cc_yellow.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('CyberPac (LaCaixa)','C','cc_cpac.php','cc_cpac.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('HSBC Secure E-Payment Service','C','cc_hsbc.php','cc_hsbc.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('EasyPay','C','cc_easypay.php','cc_easypay.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('Triple Deal','C','cc_triple.php','cc_triple.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('Ogone (web)','C','cc_ogoneweb.php','cc_ogoneweb.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('WebCraft','C','cc_webcraft.php','cc_webcraft.tpl','','','','','','','','','','N','Y','A','','','',0,''),
 ('Trolley Gateway','C','cc_trolley.php','cc_trolley.tpl','','','','','','','','','','Y','N','N','','','',0,'');
INSERT INTO `xcart_ccprocessors` (`module_name`,`type`,`processor`,`template`,`param01`,`param02`,`param03`,`param04`,`param05`,`param06`,`param07`,`param08`,`param09`,`disable_ccinfo`,`background`,`testmode`,`is_check`,`is_refund`,`c_template`,`paymentid`,`cmpi`) VALUES 
 ('PSW Billing','C','cc_pswbill.php','cc_pswbill.tpl','','','','','','','','','','Y','N','N','','','',0,''),
 ('PayByCheck.XML','H','ch_pbcxml.php','ch_pbcxml.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('Caledon','C','cc_caledon.php','cc_caledon.tpl','','','','','','','','','','N','Y','N','','','',0,''),
 ('2Checkout. Version 2','C','cc_2conew.php','cc_2conew.tpl','','','','','','','','','','Y','N','Y','','','',0,''),
 ('DirectOne direct','C','cc_directone.php','cc_directone.tpl','','','','','','','','','','N','Y','Y','','','',0,''),
 ('PayPal Pro','P','ps_paypal_pro.php','ps_paypal_pro.tpl','','','USD','','','','A','ExpressCheckout','DirectPayment','N','Y','Y','','','',18,'');
/*!40000 ALTER TABLE `xcart_ccprocessors` ENABLE KEYS */;


--
-- Definition of table `xcart_class_lng`
--

DROP TABLE IF EXISTS `xcart_class_lng`;
CREATE TABLE `xcart_class_lng` (
  `code` char(2) NOT NULL default 'US',
  `classid` int(11) NOT NULL default '0',
  `class` varchar(128) NOT NULL default '',
  `classtext` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`classid`,`code`)
) TYPE=MyISAM;

--
-- Dumping data for table `xcart_class_lng`
--

/*!40000 ALTER TABLE `xcart_class_lng` DISABLE KEYS */;
INSERT INTO `xcart_class_lng` (`code`,`classid`,`class`,`classtext`) VALUES 
 ('US',2079,'style','Select Style'),
 ('US',2083,'style','Select Style'),
 ('US',2077,'style','Select Style'),
 ('US',2081,'style','Select Style'),
 ('US',2078,'style','Select Style'),
 ('US',2082,'style','Select Style'),
 ('US',2084,'style','Select Style'),
 ('US',2080,'style','Select Style'),
 ('US',2275,'finish','Select Finish'),
 ('US',2276,'finish','Select Finish'),
 ('US',2277,'finish','Select Finish'),
 ('US',2278,'finish','Select Finish'),
 ('US',2279,'finish','Select Finish'),
 ('US',2280,'finish','Select Finish'),
 ('US',2281,'finish','Select Finish'),
 ('US',2282,'finish','Select Finish'),
 ('US',2283,'finish','Select Finish'),
 ('US',2284,'finish','Select Finish'),
 ('US',2285,'finish','Select Finish'),
 ('US',2286,'finish','Select Finish'),
 ('US',2287,'finish','Select Finish'),
 ('US',2288,'finish','Select Finish'),
 ('US',2289,'finish','Select Finish'),
 ('US',2290,'finish','Select Finish'),
 ('US',2291,'finish','Select Finish'),
 ('US',229