--
-- Host: yellowpagelistingz.com    Database: sanket_yellowpage
-- ------------------------------------------------------


--
-- Table structure for table `directory_save_data`
--

CREATE TABLE `directory_save_data` (
  `id` bigint(100) NOT NULL AUTO_INCREMENT,
  `schedule_id` bigint(100) NOT NULL,
  `project_id` bigint(100) NOT NULL,
  `link_id` bigint(100) NOT NULL,
  `confirm_link` text NOT NULL,
  `category_id` int(10) NOT NULL,
  `category_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `directory_save_data`
--


--
-- Table structure for table `idx_admin_menu`
--

CREATE TABLE `idx_admin_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `menu_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `menu_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_admin_menu`
--



--
-- Table structure for table `idx_bad_link`
--

CREATE TABLE `idx_bad_link` (
  `bad_link_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`bad_link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_bad_link`
--


--
-- Table structure for table `idx_badwords`
--

CREATE TABLE `idx_badwords` (
  `word` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_badwords`
--


--
-- Table structure for table `idx_blocked_domain`
--

CREATE TABLE `idx_blocked_domain` (
  `blocked_id` int(11) NOT NULL AUTO_INCREMENT,
  `blocked` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('domain','ip') COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`blocked_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_blocked_domain`
--

INSERT INTO `idx_blocked_domain` VALUES (1,'buydomains.com','domain'),(2,'this-domain-for-sale.com ','domain'),(3,'oversee.net','domain'),(4,'eNom','domain'),(5,'sedoparking.com','domain');

--
-- Table structure for table `idx_category`
--

CREATE TABLE `idx_category` (
  `category_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `visible` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `links` mediumint(9) DEFAULT NULL,
  `meta_keyword` text COLLATE utf8_unicode_ci,
  `meta_description` text COLLATE utf8_unicode_ci,
  `permission` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `registered_only` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `header` text COLLATE utf8_unicode_ci NOT NULL,
  `footer` text COLLATE utf8_unicode_ci NOT NULL,
  `related` mediumint(6) NOT NULL DEFAULT '0',
  `page_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `order_num` smallint(6) NOT NULL DEFAULT '0',
  `basic_price` double unsigned NOT NULL DEFAULT '0',
  `premium_price` double unsigned NOT NULL DEFAULT '0',
  `sponsored_price` double unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=351 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_category`
--

INSERT INTO `idx_category` VALUES (339,0,'Medicine & Surgery','','folder.gif','','1',5,'','','0','0','','',0,'',0,0,0,0,0),(340,0,'Finance & Investment','','folder.gif','','1',15,'','','0','0','','',0,'',0,0,0,0,0),(341,0,'News & Media','','folder.gif','','1',2,'','','0','0','','',0,'',0,0,0,0,0),(342,0,'Plumbing Contractors','','folder.gif','','1',30,'','','0','0','','',0,'',0,0,0,0,0),(343,0,'Real Estate & Property','','folder.gif','','1',36,'','','0','0','','',0,'',0,0,0,0,0),(344,0,'Science ','','folder.gif','','1',12,'','','0','0','','',0,'',0,0,0,0,0),(345,0,'SEO ,SMO & PPC','','folder.gif','','1',17,'','','0','0','','',0,'',0,0,0,0,0),(346,0,'Shopping and Sales','','folder.gif','','1',60,'','','0','0','','',0,'',0,0,0,0,0),(347,0,'Sports & Recreation','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(348,0,'Transportation Services','','folder.gif','','1',38,'','','0','0','','',0,'',0,0,0,0,0),(349,0,'Travel & Tour','','folder.gif','','1',24,'','','0','0','','',0,'',0,0,0,0,0),(350,0,'Weddings','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(316,0,'Arts Gallery & Entertainment','','folder.gif','','1',13,'','','0','0','','',0,'',0,0,0,0,0),(317,0,'Automobiles','','folder.gif','','1',28,'','','0','0','','',0,'',0,0,0,0,0),(318,0,'Business & Investment','','folder.gif','','1',119,'','','0','0','','',0,'',0,0,0,0,0),(319,0,'Careers & Recruitment','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(320,0,'Clothing & Designers','','folder.gif','','1',10,'','','0','0','','',0,'',0,0,0,0,0),(321,0,'Communication ','','folder.gif','','1',14,'','','0','0','','',0,'',0,0,0,0,0),(322,0,'Computers','','folder.gif','','1',18,'','','0','0','','',0,'',0,0,0,0,0),(323,0,'Construction Services','','folder.gif','','1',68,'','','0','0','','',0,'',0,0,0,0,0),(324,0,'Dental Health','','folder.gif','','1',43,'','','0','0','','',0,'',0,0,0,0,0),(325,0,'Education & Training','','folder.gif','','1',27,'','','0','0','','',0,'',0,0,0,0,0),(326,0,'Employment & Recruitment','','folder.gif','','1',1,'','','0','0','','',0,'',0,0,0,0,0),(327,0,'Gifts & Novelties','','folder.gif','','1',20,'','','0','0','','',0,'',0,0,0,0,0),(328,0,'Software & Hardware','','folder.gif','','1',9,'','','0','0','','',0,'',0,0,0,0,0),(329,0,'Health Services','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(330,0,'Healthcare Industry','','folder.gif','','1',150,'','','0','0','','',0,'',0,0,0,0,0),(331,0,'Heating, Ventilating and Air Conditioning','','folder.gif','','1',47,'','','0','0','','',0,'',0,0,0,0,0),(332,0,'Home & Garden Making','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(333,0,'Home Improvement & Appliances ','','folder.gif','','1',286,'','','0','0','','',0,'',0,0,0,0,0),(334,0,'Hotels ','','folder.gif','','1',28,'','','0','0','','',0,'',0,0,0,0,0),(335,0,'Insurance Providers','','folder.gif','','1',23,'','','0','0','','',0,'',0,0,0,0,0),(336,0,'Law & Legal','','folder.gif','','1',0,'','','0','0','','',0,'',0,0,0,0,0),(337,0,'Lawyers & Attorneys','','folder.gif','','1',156,'','','0','0','','',0,'',0,0,0,0,0),(338,0,'Lifestyle & Society','','folder.gif','','1',6,'','','0','0','','',0,'',0,0,0,0,0);

--
-- Table structure for table `idx_category_path`
--

CREATE TABLE `idx_category_path` (
  `category_id` mediumint(9) NOT NULL DEFAULT '0',
  `path` text COLLATE utf8_unicode_ci,
  `path_with_url` text COLLATE utf8_unicode_ci,
  `parents` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_category_path`
--

INSERT INTO `idx_category_path` VALUES (21,'Law/Legal','<a href=\"http://www.yellowpagelistingz.com/law-legal/\" name=\"cat_21\" style=\"\">Law/Legal</a>',';0;'),(22,'Law/Legal > Bail Bonds','<a href=\"http://www.yellowpagelistingz.com/law-legal/\" name=\"cat_21\" style=\"\">Law/Legal</a> > <a href=\"http://www.yellowpagelistingz.com/law-legal/bail-bonds/\" name=\"cat_22\" style=\"\">Bail Bonds</a>',';21;0;'),(23,'Law/Legal > Lawyers/Attorneys','<a href=\"http://www.yellowpagelistingz.com/law-legal/\" name=\"cat_21\" style=\"\">Law/Legal</a> > <a href=\"http://www.yellowpagelistingz.com/law-legal/lawyers-attorneys/\" name=\"cat_23\" style=\"\">Lawyers/Attorneys</a>',';21;0;'),(24,'Law/Legal > Legal services','<a href=\"http://www.yellowpagelistingz.com/law-legal/\" name=\"cat_21\" style=\"\">Law/Legal</a> > <a href=\"http://www.yellowpagelistingz.com/law-legal/legal-services/\" name=\"cat_24\" style=\"\">Legal services</a>',';21;0;'),(25,'Law/Legal > Lawsuits','<a href=\"http://www.yellowpagelistingz.com/law-legal/\" name=\"cat_21\" style=\"\">Law/Legal</a> > <a href=\"http://www.yellowpagelistingz.com/law-legal/lawsuits/\" name=\"cat_25\" style=\"\">Lawsuits</a>',';21;0;'),(26,'Community Services','<a href=\"http://www.yellowpagelistingz.com/community-services/\" name=\"cat_26\" style=\"\">Community Services</a>',';0;'),(27,'Community Services > Child Care','<a href=\"http://www.yellowpagelistingz.com/community-services/\" name=\"cat_26\" style=\"\">Community Services</a> > <a href=\"http://www.yellowpagelistingz.com/community-services/child-care/\" name=\"cat_27\" style=\"\">Child Care</a>',';26;0;'),(28,'Community Services > Assisted Living','<a href=\"http://www.yellowpagelistingz.com/community-services/\" name=\"cat_26\" style=\"\">Community Services</a> > <a href=\"http://www.yellowpagelistingz.com/community-services/assisted-living/\" name=\"cat_28\" style=\"\">Assisted Living</a>',';26;0;'),(29,'Community Services > Senior Care','<a href=\"http://www.yellowpagelistingz.com/community-services/\" name=\"cat_26\" style=\"\">Community Services</a> > <a href=\"http://www.yellowpagelistingz.com/community-services/senior-care/\" name=\"cat_29\" style=\"\">Senior Care</a>',';26;0;'),(30,'Community Services > Libraries','<a href=\"http://www.yellowpagelistingz.com/community-services/\" name=\"cat_26\" style=\"\">Community Services</a> > <a href=\"http://www.yellowpagelistingz.com/community-services/libraries/\" name=\"cat_30\" style=\"\">Libraries</a>',';26;0;'),(31,'Community Services > Electric Company','<a href=\"http://www.yellowpagelistingz.com/community-services/\" name=\"cat_26\" style=\"\">Community Services</a> > <a href=\"http://www.yellowpagelistingz.com/community-services/electric-company/\" name=\"cat_31\" style=\"\">Electric Company</a>',';26;0;'),(32,'Insurance','<a href=\"http://www.yellowpagelistingz.com/insurance/\" name=\"cat_32\" style=\"\">Insurance</a>',';0;'),(33,'Insurance > Car Insurance','<a href=\"http://www.yellowpagelistingz.com/insurance/\" name=\"cat_32\" style=\"\">Insurance</a> > <a href=\"http://www.yellowpagelistingz.com/insurance/car-insurance/\" name=\"cat_33\" style=\"\">Car Insurance</a>',';32;0;'),(34,'Insurance > Home Insurance','<a href=\"http://www.yellowpagelistingz.com/insurance/\" name=\"cat_32\" style=\"\">Insurance</a> > <a href=\"http://www.yellowpagelistingz.com/insurance/home-insurance/\" name=\"cat_34\" style=\"\">Home Insurance</a>',';32;0;'),(35,'Insurance > Auto Insurance','<a href=\"http://www.yellowpagelistingz.com/insurance/\" name=\"cat_32\" style=\"\">Insurance</a> > <a href=\"http://www.yellowpagelistingz.com/insurance/auto-insurance/\" name=\"cat_35\" style=\"\">Auto Insurance</a>',';32;0;'),(36,'Insurance > Medical Insurance','<a href=\"http://www.yellowpagelistingz.com/insurance/\" name=\"cat_32\" style=\"\">Insurance</a> > <a href=\"http://www.yellowpagelistingz.com/insurance/medical-insurance/\" name=\"cat_36\" style=\"\">Medical Insurance</a>',';32;0;'),(37,'Insurance > Disability Insurance','<a href=\"http://www.yellowpagelistingz.com/insurance/\" name=\"cat_32\" style=\"\">Insurance</a> > <a href=\"http://www.yellowpagelistingz.com/insurance/disability-insurance/\" name=\"cat_37\" style=\"\">Disability Insurance</a>',';32;0;'),(38,'Recreation','<a href=\"http://www.yellowpagelistingz.com/recreation/\" name=\"cat_38\" style=\"\">Recreation</a>',';0;'),(39,'Recreation > Cruises','<a href=\"http://www.yellowpagelistingz.com/recreation/\" name=\"cat_38\" style=\"\">Recreation</a> > <a href=\"http://www.yellowpagelistingz.com/recreation/cruises/\" name=\"cat_39\" style=\"\">Cruises</a>',';38;0;'),(40,'Recreation > Travel ','<a href=\"http://www.yellowpagelistingz.com/recreation/\" name=\"cat_38\" style=\"\">Recreation</a> > <a href=\"http://www.yellowpagelistingz.com/recreation/travel/\" name=\"cat_40\" style=\"\">Travel </a>',';38;0;'),(41,'Recreation > Hotels/Restaurants','<a href=\"http://www.yellowpagelistingz.com/recreation/\" name=\"cat_38\" style=\"\">Recreation</a> > <a href=\"http://www.yellowpagelistingz.com/recreation/hotels-restaurants/\" name=\"cat_41\" style=\"\">Hotels/Restaurants</a>',';38;0;'),(42,'Recreation > Resorts','<a href=\"http://www.yellowpagelistingz.com/recreation/\" name=\"cat_38\" style=\"\">Recreation</a> > <a href=\"http://www.yellowpagelistingz.com/recreation/resorts/\" name=\"cat_42\" style=\"\">Resorts</a>',';38;0;'),(43,'Shopping','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a>',';0;'),(44,'Shopping > Consumer Electronics','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/consumer-electronics/\" name=\"cat_44\" style=\"\">Consumer Electronics</a>',';43;0;'),(45,'Shopping > eCommerce','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/ecommerce/\" name=\"cat_45\" style=\"\">eCommerce</a>',';43;0;'),(46,'Shopping > Gifts','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/gifts/\" name=\"cat_46\" style=\"\">Gifts</a>',';43;0;'),(47,'Shopping > Clothing','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/clothing/\" name=\"cat_47\" style=\"\">Clothing</a>',';43;0;'),(48,'Shopping > Florist','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/florist/\" name=\"cat_48\" style=\"\">Florist</a>',';43;0;'),(49,'Shopping > Grocery','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/grocery/\" name=\"cat_49\" style=\"\">Grocery</a>',';43;0;'),(50,'Shopping > Pets','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_43\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/pets/\" name=\"cat_50\" style=\"\">Pets</a>',';43;0;'),(51,'Handyman','<a href=\"http://www.yellowpagelistingz.com/handyman/\" name=\"cat_51\" style=\"\">Handyman</a>',';0;'),(52,'Handyman > Carpentry','<a href=\"http://www.yellowpagelistingz.com/handyman/\" name=\"cat_51\" style=\"\">Handyman</a> > <a href=\"http://www.yellowpagelistingz.com/handyman/carpentry/\" name=\"cat_52\" style=\"\">Carpentry</a>',';51;0;'),(53,'Handyman > Plumbers','<a href=\"http://www.yellowpagelistingz.com/handyman/\" name=\"cat_51\" style=\"\">Handyman</a> > <a href=\"http://www.yellowpagelistingz.com/handyman/plumbers/\" name=\"cat_53\" style=\"\">Plumbers</a>',';51;0;'),(54,'Handyman > Electricians','<a href=\"http://www.yellowpagelistingz.com/handyman/\" name=\"cat_51\" style=\"\">Handyman</a> > <a href=\"http://www.yellowpagelistingz.com/handyman/electricians/\" name=\"cat_54\" style=\"\">Electricians</a>',';51;0;'),(55,'Handyman > Woodworking','<a href=\"http://www.yellowpagelistingz.com/handyman/\" name=\"cat_51\" style=\"\">Handyman</a> > <a href=\"http://www.yellowpagelistingz.com/handyman/woodworking/\" name=\"cat_55\" style=\"\">Woodworking</a>',';51;0;'),(56,'Handyman > Cleaning Service','<a href=\"http://www.yellowpagelistingz.com/handyman/\" name=\"cat_51\" style=\"\">Handyman</a> > <a href=\"http://www.yellowpagelistingz.com/handyman/cleaning-service/\" name=\"cat_56\" style=\"\">Cleaning Service</a>',';51;0;'),(57,'Health and Wellness','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a>',';0;'),(58,'Health and Wellness > Dentists','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a> > <a href=\"http://www.yellowpagelistingz.com/health-and-wellness/dentists/\" name=\"cat_58\" style=\"\">Dentists</a>',';57;0;'),(59,'Health and Wellness > Surgeons','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a> > <a href=\"http://www.yellowpagelistingz.com/health-and-wellness/surgeons/\" name=\"cat_59\" style=\"\">Surgeons</a>',';57;0;'),(60,'Health and Wellness > Hospitals','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a> > <a href=\"http://www.yellowpagelistingz.com/health-and-wellness/hospitals/\" name=\"cat_60\" style=\"\">Hospitals</a>',';57;0;'),(61,'Health and Wellness > Fitness Centers','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a> > <a href=\"http://www.yellowpagelistingz.com/health-and-wellness/fitness-centers/\" name=\"cat_61\" style=\"\">Fitness Centers</a>',';57;0;'),(62,'Health and Wellness > Massage Therapy','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a> > <a href=\"http://www.yellowpagelistingz.com/health-and-wellness/massage-therapy/\" name=\"cat_62\" style=\"\">Massage Therapy</a>',';57;0;'),(63,'Health and Wellness > Yoga','<a href=\"http://www.yellowpagelistingz.com/health-and-wellness/\" name=\"cat_57\" style=\"\">Health and Wellness</a> > <a href=\"http://www.yellowpagelistingz.com/health-and-wellness/yoga/\" name=\"cat_63\" style=\"\">Yoga</a>',';57;0;'),(64,'Home Improvement','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a>',';0;'),(65,'Home Improvement > Plumbing','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/plumbing/\" name=\"cat_65\" style=\"\">Plumbing</a>',';64;0;'),(66,'Home Improvement > Fencing','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/fencing/\" name=\"cat_66\" style=\"\">Fencing</a>',';64;0;'),(67,'Home Improvement > Kitchen Remodeling','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/kitchen-remodeling/\" name=\"cat_67\" style=\"\">Kitchen Remodeling</a>',';64;0;'),(68,'Home Improvement > Heating & Cooling','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/heating-cooling/\" name=\"cat_68\" style=\"\">Heating & Cooling</a>',';64;0;'),(69,'Home Improvement > Roofing','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/roofing/\" name=\"cat_69\" style=\"\">Roofing</a>',';64;0;'),(70,'Home Improvement > Windows Repair','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/windows-repair/\" name=\"cat_70\" style=\"\">Windows Repair</a>',';64;0;'),(71,'Home Improvement > Garage Doors','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/garage-doors/\" name=\"cat_71\" style=\"\">Garage Doors</a>',';64;0;'),(72,'Home Improvement > Pest control','<a href=\"http://www.yellowpagelistingz.com/home-improvement/\" name=\"cat_64\" style=\"\">Home Improvement</a> > <a href=\"http://www.yellowpagelistingz.com/home-improvement/pest-control/\" name=\"cat_72\" style=\"\">Pest control</a>',';64;0;'),(73,'Business','<a href=\"http://www.yellowpagelistingz.com/business/\" name=\"cat_73\" style=\"\">Business</a>',';0;'),(74,'Business > Financial Services','<a href=\"http://www.yellowpagelistingz.com/business/\" name=\"cat_73\" style=\"\">Business</a> > <a href=\"http://www.yellowpagelistingz.com/business/financial-services/\" name=\"cat_74\" style=\"\">Financial Services</a>',';73;0;'),(75,'Business > B2B Services','<a href=\"http://www.yellowpagelistingz.com/business/\" name=\"cat_73\" style=\"\">Business</a> > <a href=\"http://www.yellowpagelistingz.com/business/b2b-services/\" name=\"cat_75\" style=\"\">B2B Services</a>',';73;0;'),(76,'Business > Corporate Services','<a href=\"http://www.yellowpagelistingz.com/business/\" name=\"cat_73\" style=\"\">Business</a> > <a href=\"http://www.yellowpagelistingz.com/business/corporate-services/\" name=\"cat_76\" style=\"\">Corporate Services</a>',';73;0;'),(77,'Business > Loans','<a href=\"http://www.yellowpagelistingz.com/business/\" name=\"cat_73\" style=\"\">Business</a> > <a href=\"http://www.yellowpagelistingz.com/business/loans/\" name=\"cat_77\" style=\"\">Loans</a>',';73;0;'),(78,'Moving','<a href=\"http://www.yellowpagelistingz.com/moving/\" name=\"cat_78\" style=\"\">Moving</a>',';0;'),(79,'Moving > Moving Companies','<a href=\"http://www.yellowpagelistingz.com/moving/\" name=\"cat_78\" style=\"\">Moving</a> > <a href=\"http://www.yellowpagelistingz.com/moving/moving-companies/\" name=\"cat_79\" style=\"\">Moving Companies</a>',';78;0;'),(80,'Moving > Local Movers','<a href=\"http://www.yellowpagelistingz.com/moving/\" name=\"cat_78\" style=\"\">Moving</a> > <a href=\"http://www.yellowpagelistingz.com/moving/local-movers/\" name=\"cat_80\" style=\"\">Local Movers</a>',';78;0;'),(81,'Moving > Self Storage','<a href=\"http://www.yellowpagelistingz.com/moving/\" name=\"cat_78\" style=\"\">Moving</a> > <a href=\"http://www.yellowpagelistingz.com/moving/self-storage/\" name=\"cat_81\" style=\"\">Self Storage</a>',';78;0;'),(82,'Moving > Truck Rentals','<a href=\"http://www.yellowpagelistingz.com/moving/\" name=\"cat_78\" style=\"\">Moving</a> > <a href=\"http://www.yellowpagelistingz.com/moving/truck-rentals/\" name=\"cat_82\" style=\"\">Truck Rentals</a>',';78;0;'),(83,'Real Estate','<a href=\"http://www.yellowpagelistingz.com/real-estate/\" name=\"cat_83\" style=\"\">Real Estate</a>',';0;'),(84,'Real Estate > Real Estate Agents','<a href=\"http://www.yellowpagelistingz.com/real-estate/\" name=\"cat_83\" style=\"\">Real Estate</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate/real-estate-agents/\" name=\"cat_84\" style=\"\">Real Estate Agents</a>',';83;0;'),(85,'Real Estate > Condos','<a href=\"http://www.yellowpagelistingz.com/real-estate/\" name=\"cat_83\" style=\"\">Real Estate</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate/condos/\" name=\"cat_85\" style=\"\">Condos</a>',';83;0;'),(86,'Real Estate > Homes for Sale','<a href=\"http://www.yellowpagelistingz.com/real-estate/\" name=\"cat_83\" style=\"\">Real Estate</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate/homes-for-sale/\" name=\"cat_86\" style=\"\">Homes for Sale</a>',';83;0;'),(87,'Real Estate > Vacation Rentals','<a href=\"http://www.yellowpagelistingz.com/real-estate/\" name=\"cat_83\" style=\"\">Real Estate</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate/vacation-rentals/\" name=\"cat_87\" style=\"\">Vacation Rentals</a>',';83;0;'),(88,'Real Estate > Property Management','<a href=\"http://www.yellowpagelistingz.com/real-estate/\" name=\"cat_83\" style=\"\">Real Estate</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate/property-management/\" name=\"cat_88\" style=\"\">Property Management</a>',';83;0;'),(89,'Employment','<a href=\"http://www.yellowpagelistingz.com/employment/\" name=\"cat_89\" style=\"\">Employment</a>',';0;'),(90,'Employment > Employment Agency','<a href=\"http://www.yellowpagelistingz.com/employment/\" name=\"cat_89\" style=\"\">Employment</a> > <a href=\"http://www.yellowpagelistingz.com/employment/employment-agency/\" name=\"cat_90\" style=\"\">Employment Agency</a>',';89;0;'),(91,'Employment > Head Hunters','<a href=\"http://www.yellowpagelistingz.com/employment/\" name=\"cat_89\" style=\"\">Employment</a> > <a href=\"http://www.yellowpagelistingz.com/employment/head-hunters/\" name=\"cat_91\" style=\"\">Head Hunters</a>',';89;0;'),(92,'Employment > Temp Agencies','<a href=\"http://www.yellowpagelistingz.com/employment/\" name=\"cat_89\" style=\"\">Employment</a> > <a href=\"http://www.yellowpagelistingz.com/employment/temp-agencies/\" name=\"cat_92\" style=\"\">Temp Agencies</a>',';89;0;'),(93,'Employment > Job Opportunities','<a href=\"http://www.yellowpagelistingz.com/employment/\" name=\"cat_89\" style=\"\">Employment</a> > <a href=\"http://www.yellowpagelistingz.com/employment/job-opportunities/\" name=\"cat_93\" style=\"\">Job Opportunities</a>',';89;0;'),(94,'Auotomobiles ','<a href=\"http://www.yellowpagelistingz.com/auotomobiles/\" name=\"cat_94\" style=\"\">Auotomobiles </a>',';0;'),(95,'Auotomobiles  > Car for Sales','<a href=\"http://www.yellowpagelistingz.com/auotomobiles/\" name=\"cat_94\" style=\"\">Auotomobiles </a> > <a href=\"http://www.yellowpagelistingz.com/auotomobiles/car-for-sales/\" name=\"cat_95\" style=\"\">Car for Sales</a>',';94;0;'),(96,'Auotomobiles  > Auto Parts','<a href=\"http://www.yellowpagelistingz.com/auotomobiles/\" name=\"cat_94\" style=\"\">Auotomobiles </a> > <a href=\"http://www.yellowpagelistingz.com/auotomobiles/auto-parts/\" name=\"cat_96\" style=\"\">Auto Parts</a>',';94;0;'),(97,'Auotomobiles  > Car Repair','<a href=\"http://www.yellowpagelistingz.com/auotomobiles/\" name=\"cat_94\" style=\"\">Auotomobiles </a> > <a href=\"http://www.yellowpagelistingz.com/auotomobiles/car-repair/\" name=\"cat_97\" style=\"\">Car Repair</a>',';94;0;'),(98,'Auotomobiles  > Brake Repair','<a href=\"http://www.yellowpagelistingz.com/auotomobiles/\" name=\"cat_94\" style=\"\">Auotomobiles </a> > <a href=\"http://www.yellowpagelistingz.com/auotomobiles/brake-repair/\" name=\"cat_98\" style=\"\">Brake Repair</a>',';94;0;'),(99,'Auotomobiles  > Mechanics','<a href=\"http://www.yellowpagelistingz.com/auotomobiles/\" name=\"cat_94\" style=\"\">Auotomobiles </a> > <a href=\"http://www.yellowpagelistingz.com/auotomobiles/mechanics/\" name=\"cat_99\" style=\"\">Mechanics</a>',';94;0;'),(100,'Accommodation','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a>',';0;'),(101,'Accommodation > Condos','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/condos/\" name=\"cat_101\" style=\"\">Condos</a>',';100;0;'),(102,'Accommodation > Holiday Resort','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/holiday-resort/\" name=\"cat_102\" style=\"\">Holiday Resort</a>',';100;0;'),(103,'Hotels','<a href=\"http://www.yellowpagelistingz.com/hotels/\" name=\"cat_103\" style=\"\">Hotels</a>',';0;'),(104,'Accommodation > Lodges','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/lodges/\" name=\"cat_104\" style=\"\">Lodges</a>',';100;0;'),(105,'Accommodation > Hotels','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/hotels/\" name=\"cat_105\" style=\"\">Hotels</a>',';100;0;'),(106,'Accommodation > Reservations','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/reservations/\" name=\"cat_106\" style=\"\">Reservations</a>',';100;0;'),(107,'Accommodation > Resorts','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/resorts/\" name=\"cat_107\" style=\"\">Resorts</a>',';100;0;'),(108,'Accommodation > Restaurants','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/restaurants/\" name=\"cat_108\" style=\"\">Restaurants</a>',';100;0;'),(109,'Accommodation > Villas','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/villas/\" name=\"cat_109\" style=\"\">Villas</a>',';100;0;'),(110,'Wedding venues','<a href=\"http://www.yellowpagelistingz.com/wedding-venues/\" name=\"cat_110\" style=\"\">Wedding venues</a>',';0;'),(111,'Arts & Humanities ','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a>',';0;'),(112,'Accommodation > Wedding venues','<a href=\"http://www.yellowpagelistingz.com/accommodation/\" name=\"cat_100\" style=\"\">Accommodation</a> > <a href=\"http://www.yellowpagelistingz.com/accommodation/wedding-venues/\" name=\"cat_112\" style=\"\">Wedding venues</a>',';100;0;'),(113,'Arts & Humanities  > Architecture','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/architecture/\" name=\"cat_113\" style=\"\">Architecture</a>',';111;0;'),(114,'Arts & Humanities  > Art Gallery','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/art-gallery/\" name=\"cat_114\" style=\"\">Art Gallery</a>',';111;0;'),(115,'Arts & Humanities  > Crafts','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/crafts/\" name=\"cat_115\" style=\"\">Crafts</a>',';111;0;'),(116,'Arts & Humanities  > Painting','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/painting/\" name=\"cat_116\" style=\"\">Painting</a>',';111;0;'),(117,'Arts & Humanities  > Performing Arts','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/performing-arts/\" name=\"cat_117\" style=\"\">Performing Arts</a>',';111;0;'),(118,'Arts & Humanities  > Photography','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/photography/\" name=\"cat_118\" style=\"\">Photography</a>',';111;0;'),(119,'Arts & Humanities  > Visual Arts','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/visual-arts/\" name=\"cat_119\" style=\"\">Visual Arts</a>',';111;0;'),(120,'Arts & Humanities  > Writing','<a href=\"http://www.yellowpagelistingz.com/arts-humanities/\" name=\"cat_111\" style=\"\">Arts & Humanities </a> > <a href=\"http://www.yellowpagelistingz.com/arts-humanities/writing/\" name=\"cat_120\" style=\"\">Writing</a>',';111;0;'),(121,'Automobile','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a>',';0;'),(122,'Automobile > Auto Services','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/auto-services/\" name=\"cat_122\" style=\"\">Auto Services</a>',';121;0;'),(123,'Automobile > Bus Service','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/bus-service/\" name=\"cat_123\" style=\"\">Bus Service</a>',';121;0;'),(124,'Automobile > Cars','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/cars/\" name=\"cat_124\" style=\"\">Cars</a>',';121;0;'),(125,'Automobile > Maintenance and Repair','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/maintenance-and-repair/\" name=\"cat_125\" style=\"\">Maintenance and Repair</a>',';121;0;'),(126,'Automobile > Motorcycles','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/motorcycles/\" name=\"cat_126\" style=\"\">Motorcycles</a>',';121;0;'),(127,'Automobile > Parts and Accessories','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/parts-and-accessories/\" name=\"cat_127\" style=\"\">Parts and Accessories</a>',';121;0;'),(128,'Automobile > Trucks','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/trucks/\" name=\"cat_128\" style=\"\">Trucks</a>',';121;0;'),(129,'Automobile > Used Vehicles','<a href=\"http://www.yellowpagelistingz.com/automobile/\" name=\"cat_121\" style=\"\">Automobile</a> > <a href=\"http://www.yellowpagelistingz.com/automobile/used-vehicles/\" name=\"cat_129\" style=\"\">Used Vehicles</a>',';121;0;'),(130,'Business & Economy','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a>',';0;'),(131,'Business & Economy > Accounting Services','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/accounting-services/\" name=\"cat_131\" style=\"\">Accounting Services</a>',';130;0;'),(132,'Business & Economy > Business Services','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/business-services/\" name=\"cat_132\" style=\"\">Business Services</a>',';130;0;'),(133,'Business & Economy > Cargo Service','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/cargo-service/\" name=\"cat_133\" style=\"\">Cargo Service</a>',';130;0;'),(134,'Business & Economy > Construction & Maintenance','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/construction-maintenance/\" name=\"cat_134\" style=\"\">Construction & Maintenance</a>',';130;0;'),(135,'Business & Economy > Consumer Goods and Services','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/consumer-goods-and-services/\" name=\"cat_135\" style=\"\">Consumer Goods and Services</a>',';130;0;'),(136,'Business & Economy > Industrial Goods and Services','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/industrial-goods-and-services/\" name=\"cat_136\" style=\"\">Industrial Goods and Services</a>',';130;0;'),(137,'Business & Economy > Management & Consulting','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/management-consulting/\" name=\"cat_137\" style=\"\">Management & Consulting</a>',';130;0;'),(138,'Business & Economy > Marketing and Advertising','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/marketing-and-advertising/\" name=\"cat_138\" style=\"\">Marketing and Advertising</a>',';130;0;'),(139,'Business & Economy > Publishing and Printing Business','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/publishing-and-printing-business/\" name=\"cat_139\" style=\"\">Publishing and Printing Business</a>',';130;0;'),(140,'Business & Economy > Small Business','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/small-business/\" name=\"cat_140\" style=\"\">Small Business</a>',';130;0;'),(141,'Business & Economy > Translation Services','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/translation-services/\" name=\"cat_141\" style=\"\">Translation Services</a>',';130;0;'),(142,'Business & Economy > Transportation and Logistics ','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/transportation-and-logistics%e2%a0/\" name=\"cat_142\" style=\"\">Transportation and Logistics </a>',';130;0;'),(143,'Business & Economy > Warehouse Storage','<a href=\"http://www.yellowpagelistingz.com/business-economy/\" name=\"cat_130\" style=\"\">Business & Economy</a> > <a href=\"http://www.yellowpagelistingz.com/business-economy/warehouse-storage/\" name=\"cat_143\" style=\"\">Warehouse Storage</a>',';130;0;'),(144,'Communication','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_144\" style=\"\">Communication</a>',';0;'),(145,'Communication > Cell Phone Accessories','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_144\" style=\"\">Communication</a> > <a href=\"http://www.yellowpagelistingz.com/communication/cell-phone-accessories/\" name=\"cat_145\" style=\"\">Cell Phone Accessories</a>',';144;0;'),(146,'Communication > Cell Phones / Mobile Phones','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_144\" style=\"\">Communication</a> > <a href=\"http://www.yellowpagelistingz.com/communication/cell-phones-mobile-phones/\" name=\"cat_146\" style=\"\">Cell Phones / Mobile Phones</a>',';144;0;'),(147,'Communication > Mobile Cell Phone SMS','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_144\" style=\"\">Communication</a> > <a href=\"http://www.yellowpagelistingz.com/communication/mobile-cell-phone-sms/\" name=\"cat_147\" style=\"\">Mobile Cell Phone SMS</a>',';144;0;'),(148,'Communication > Telecom','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_144\" style=\"\">Communication</a> > <a href=\"http://www.yellowpagelistingz.com/communication/telecom/\" name=\"cat_148\" style=\"\">Telecom</a>',';144;0;'),(149,'Communication > Wireless','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_144\" style=\"\">Communication</a> > <a href=\"http://www.yellowpagelistingz.com/communication/wireless/\" name=\"cat_149\" style=\"\">Wireless</a>',';144;0;'),(150,'Computers','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a>',';0;'),(151,'Computers > Email Marketing','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/email-marketing/\" name=\"cat_151\" style=\"\">Email Marketing</a>',';150;0;'),(152,'Computers > Hardware','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/hardware/\" name=\"cat_152\" style=\"\">Hardware</a>',';150;0;'),(153,'Computers > Information Technology Services','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/information-technology-services/\" name=\"cat_153\" style=\"\">Information Technology Services</a>',';150;0;'),(154,'Computers > Internet Marketing','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/internet-marketing/\" name=\"cat_154\" style=\"\">Internet Marketing</a>',';150;0;'),(155,'Computers > Internet Security','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/internet-security/\" name=\"cat_155\" style=\"\">Internet Security</a>',';150;0;'),(156,'Computers > Medical Software','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/medical-software/\" name=\"cat_156\" style=\"\">Medical Software</a>',';150;0;'),(157,'Computers > Search Engine Marketing','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/search-engine-marketing/\" name=\"cat_157\" style=\"\">Search Engine Marketing</a>',';150;0;'),(158,'Computers > SEO','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/seo/\" name=\"cat_158\" style=\"\">SEO</a>',';150;0;'),(159,'Computers > Software','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/software/\" name=\"cat_159\" style=\"\">Software</a>',';150;0;'),(160,'Computers > Web Design and Development','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/web-design-and-development/\" name=\"cat_160\" style=\"\">Web Design and Development</a>',';150;0;'),(161,'Computers > Web Hosting','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_150\" style=\"\">Computers</a> > <a href=\"http://www.yellowpagelistingz.com/computers/web-hosting/\" name=\"cat_161\" style=\"\">Web Hosting</a>',';150;0;'),(162,'Education & Research','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a>',';0;'),(163,'Education & Research > Careers','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/careers/\" name=\"cat_163\" style=\"\">Careers</a>',';162;0;'),(164,'Education & Research > Childhood Education','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/childhood-education/\" name=\"cat_164\" style=\"\">Childhood Education</a>',';162;0;'),(165,'Education & Research > Colleges & Universities','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/colleges-universities/\" name=\"cat_165\" style=\"\">Colleges & Universities</a>',';162;0;'),(166,'Education & Research > Employment ','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/employment/\" name=\"cat_166\" style=\"\">Employment </a>',';162;0;'),(167,'Education & Research > Jobs','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/jobs/\" name=\"cat_167\" style=\"\">Jobs</a>',';162;0;'),(168,'Education & Research > Language Learning','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/language-learning/\" name=\"cat_168\" style=\"\">Language Learning</a>',';162;0;'),(169,'Education & Research > Online Courses','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/online-courses/\" name=\"cat_169\" style=\"\">Online Courses</a>',';162;0;'),(170,'Education & Research > Online Education','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/online-education/\" name=\"cat_170\" style=\"\">Online Education</a>',';162;0;'),(171,'Education & Research > Online Tutoring ','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/online-tutoring/\" name=\"cat_171\" style=\"\">Online Tutoring </a>',';162;0;'),(172,'Education & Research > Schools','<a href=\"http://www.yellowpagelistingz.com/education-research/\" name=\"cat_162\" style=\"\">Education & Research</a> > <a href=\"http://www.yellowpagelistingz.com/education-research/schools/\" name=\"cat_172\" style=\"\">Schools</a>',';162;0;'),(173,'Entertainment','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a>',';0;'),(174,'Entertainment > Events','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/events/\" name=\"cat_174\" style=\"\">Events</a>',';173;0;'),(175,'Entertainment > Movies','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/movies/\" name=\"cat_175\" style=\"\">Movies</a>',';173;0;'),(176,'Entertainment > Music','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/music/\" name=\"cat_176\" style=\"\">Music</a>',';173;0;'),(177,'Entertainment > Online Media','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/online-media/\" name=\"cat_177\" style=\"\">Online Media</a>',';173;0;'),(178,'Entertainment > Performing Arts','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/performing-arts/\" name=\"cat_178\" style=\"\">Performing Arts</a>',';173;0;'),(179,'Entertainment > Videos','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/videos/\" name=\"cat_179\" style=\"\">Videos</a>',';173;0;'),(180,'Entertainment > Visual Graphic Arts','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/visual-graphic-arts/\" name=\"cat_180\" style=\"\">Visual Graphic Arts</a>',';173;0;'),(181,'Entertainment > Media Production ','<a href=\"http://www.yellowpagelistingz.com/entertainment/\" name=\"cat_173\" style=\"\">Entertainment</a> > <a href=\"http://www.yellowpagelistingz.com/entertainment/media-production/\" name=\"cat_181\" style=\"\">Media Production </a>',';173;0;'),(182,'Finance & Investment','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a>',';0;'),(183,'Finance & Investment > Auto Insurance','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/auto-insurance/\" name=\"cat_183\" style=\"\">Auto Insurance</a>',';182;0;'),(184,'Finance & Investment > Auto Loan','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/auto-loan/\" name=\"cat_184\" style=\"\">Auto Loan</a>',';182;0;'),(185,'Finance & Investment > Banking Services','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/banking-services/\" name=\"cat_185\" style=\"\">Banking Services</a>',';182;0;'),(186,'Finance & Investment > Bankruptcy','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/bankruptcy/\" name=\"cat_186\" style=\"\">Bankruptcy</a>',';182;0;'),(187,'Finance & Investment > Credit Card','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/credit-card/\" name=\"cat_187\" style=\"\">Credit Card</a>',';182;0;'),(188,'Finance & Investment > Debt Consolidation','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/debt-consolidation/\" name=\"cat_188\" style=\"\">Debt Consolidation</a>',';182;0;'),(189,'Finance & Investment > Debt Management','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/debt-management/\" name=\"cat_189\" style=\"\">Debt Management</a>',';182;0;'),(190,'Finance & Investment > Financial Planning','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/financial-planning/\" name=\"cat_190\" style=\"\">Financial Planning</a>',';182;0;'),(191,'Finance & Investment > Health Insurance','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/health-insurance/\" name=\"cat_191\" style=\"\">Health Insurance</a>',';182;0;'),(192,'Finance & Investment > Financial Services','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/financial-services/\" name=\"cat_192\" style=\"\">Financial Services</a>',';182;0;'),(193,'Finance & Investment > Home Loan','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/home-loan/\" name=\"cat_193\" style=\"\">Home Loan</a>',';182;0;'),(0,'','<a href=\"http://www.yellowpagelistingz.com//\" name=\"cat_0\" style=\"\"></a>',';;'),(194,'Finance & Investment > Investment','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/investment/\" name=\"cat_194\" style=\"\">Investment</a>',';182;0;'),(195,'Finance & Investment > Payday Loan','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/payday-loan/\" name=\"cat_195\" style=\"\">Payday Loan</a>',';182;0;'),(196,'Finance & Investment > Stocks and Bonds','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_182\" style=\"\">Finance & Investment</a> > <a href=\"http://www.yellowpagelistingz.com/finance-investment/stocks-and-bonds/\" name=\"cat_196\" style=\"\">Stocks and Bonds</a>',';182;0;'),(197,'Health','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a>',';0;'),(198,'Health > Addiction','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/addiction/\" name=\"cat_198\" style=\"\">Addiction</a>',';197;0;'),(199,'Health > Alternative Medicine','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/alternative-medicine/\" name=\"cat_199\" style=\"\">Alternative Medicine</a>',';197;0;'),(200,'Health > Beauty','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/beauty/\" name=\"cat_200\" style=\"\">Beauty</a>',';197;0;'),(201,'Health > Dentistry','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/dentistry/\" name=\"cat_201\" style=\"\">Dentistry</a>',';197;0;'),(202,'Health > Doctors & Clinics','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/doctors-clinics/\" name=\"cat_202\" style=\"\">Doctors & Clinics</a>',';197;0;'),(203,'Health > Hair Care','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/hair-care/\" name=\"cat_203\" style=\"\">Hair Care</a>',';197;0;'),(204,'Health > Healthcare ','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/healthcare/\" name=\"cat_204\" style=\"\">Healthcare </a>',';197;0;'),(205,'Health > Medical Services','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/medical-services/\" name=\"cat_205\" style=\"\">Medical Services</a>',';197;0;'),(206,'Health > Medicine','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/medicine/\" name=\"cat_206\" style=\"\">Medicine</a>',';197;0;'),(207,'Health > Mens Health','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/mens-health/\" name=\"cat_207\" style=\"\">Mens Health</a>',';197;0;'),(208,'Health > Mental Health','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/mental-health/\" name=\"cat_208\" style=\"\">Mental Health</a>',';197;0;'),(209,'Health > Pharmacy','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/pharmacy/\" name=\"cat_209\" style=\"\">Pharmacy</a>',';197;0;'),(210,'Health > Weight Loss','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/weight-loss/\" name=\"cat_210\" style=\"\">Weight Loss</a>',';197;0;'),(211,'Health > Womens Health','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/womens-health/\" name=\"cat_211\" style=\"\">Womens Health</a>',';197;0;'),(212,'Health > Bath and Shower','<a href=\"http://www.yellowpagelistingz.com/health/\" name=\"cat_197\" style=\"\">Health</a> > <a href=\"http://www.yellowpagelistingz.com/health/bath-and-shower/\" name=\"cat_212\" style=\"\">Bath and Shower</a>',';197;0;'),(213,'Home & Family','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a>',';0;'),(214,'Home & Family > Bath and Shower','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/bath-and-shower/\" name=\"cat_214\" style=\"\">Bath and Shower</a>',';213;0;'),(215,'Home & Family > Cleaning ','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/cleaning/\" name=\"cat_215\" style=\"\">Cleaning </a>',';213;0;'),(216,'Home & Family > Electrical','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/electrical/\" name=\"cat_216\" style=\"\">Electrical</a>',';213;0;'),(217,'Home & Family > Flooring','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/flooring/\" name=\"cat_217\" style=\"\">Flooring</a>',';213;0;'),(218,'Home & Family > Furniture','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/furniture/\" name=\"cat_218\" style=\"\">Furniture</a>',';213;0;'),(219,'Home & Family > Heating and Air Conditioning','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/heating-and-air-conditioning/\" name=\"cat_219\" style=\"\">Heating and Air Conditioning</a>',';213;0;'),(220,'Home & Family > Home Security','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/home-security/\" name=\"cat_220\" style=\"\">Home Security</a>',';213;0;'),(221,'Home & Family > Interior Design and Decorating','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/interior-design-and-decorating/\" name=\"cat_221\" style=\"\">Interior Design and Decorating</a>',';213;0;'),(222,'Home & Family > Kitchen Improvement','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/kitchen-improvement/\" name=\"cat_222\" style=\"\">Kitchen Improvement</a>',';213;0;'),(223,'Home & Family > Landscaping ','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/landscaping/\" name=\"cat_223\" style=\"\">Landscaping </a>',';213;0;'),(224,'Home & Family > Lighting','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/lighting/\" name=\"cat_224\" style=\"\">Lighting</a>',';213;0;'),(225,'Home & Family > Pest Control','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/pest-control/\" name=\"cat_225\" style=\"\">Pest Control</a>',';213;0;'),(226,'Home & Family > Plumbing','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/plumbing/\" name=\"cat_226\" style=\"\">Plumbing</a>',';213;0;'),(227,'Remodeling','<a href=\"http://www.yellowpagelistingz.com/remodeling/\" name=\"cat_227\" style=\"\">Remodeling</a>',';0;'),(228,'Remodeling > Roofing','<a href=\"http://www.yellowpagelistingz.com/remodeling/\" name=\"cat_227\" style=\"\">Remodeling</a> > <a href=\"http://www.yellowpagelistingz.com/remodeling/roofing/\" name=\"cat_228\" style=\"\">Roofing</a>',';227;0;'),(229,'Remodeling > Swimming Pool','<a href=\"http://www.yellowpagelistingz.com/remodeling/\" name=\"cat_227\" style=\"\">Remodeling</a> > <a href=\"http://www.yellowpagelistingz.com/remodeling/swimming-pool/\" name=\"cat_229\" style=\"\">Swimming Pool</a>',';227;0;'),(230,'Law','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a>',';0;'),(231,'Law > Criminal Law','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/criminal-law/\" name=\"cat_231\" style=\"\">Criminal Law</a>',';230;0;'),(232,'Law > Employment Law','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/employment-law/\" name=\"cat_232\" style=\"\">Employment Law</a>',';230;0;'),(233,'Law > Law Firms','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/law-firms/\" name=\"cat_233\" style=\"\">Law Firms</a>',';230;0;'),(234,'Law > Lawyers','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/lawyers/\" name=\"cat_234\" style=\"\">Lawyers</a>',';230;0;'),(235,'Law > Legal Information','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/legal-information/\" name=\"cat_235\" style=\"\">Legal Information</a>',';230;0;'),(236,'Law > Legal Services','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/legal-services/\" name=\"cat_236\" style=\"\">Legal Services</a>',';230;0;'),(237,'Law > Personal Injury Law','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/personal-injury-law/\" name=\"cat_237\" style=\"\">Personal Injury Law</a>',';230;0;'),(238,'Law > Family Law','<a href=\"http://www.yellowpagelistingz.com/law/\" name=\"cat_230\" style=\"\">Law</a> > <a href=\"http://www.yellowpagelistingz.com/law/family-law/\" name=\"cat_238\" style=\"\">Family Law</a>',';230;0;'),(239,'Home & Family > Remodeling','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/remodeling/\" name=\"cat_239\" style=\"\">Remodeling</a>',';213;0;'),(240,'Home & Family > Roofing','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/roofing/\" name=\"cat_240\" style=\"\">Roofing</a>',';213;0;'),(241,'Home & Family > Swimming Pool','<a href=\"http://www.yellowpagelistingz.com/home-family/\" name=\"cat_213\" style=\"\">Home & Family</a> > <a href=\"http://www.yellowpagelistingz.com/home-family/swimming-pool/\" name=\"cat_241\" style=\"\">Swimming Pool</a>',';213;0;'),(242,'News','<a href=\"http://www.yellowpagelistingz.com/news/\" name=\"cat_242\" style=\"\">News</a>',';0;'),(243,'News > Magazines','<a href=\"http://www.yellowpagelistingz.com/news/\" name=\"cat_242\" style=\"\">News</a> > <a href=\"http://www.yellowpagelistingz.com/news/magazines/\" name=\"cat_243\" style=\"\">Magazines</a>',';242;0;'),(244,'News > Media','<a href=\"http://www.yellowpagelistingz.com/news/\" name=\"cat_242\" style=\"\">News</a> > <a href=\"http://www.yellowpagelistingz.com/news/media/\" name=\"cat_244\" style=\"\">Media</a>',';242;0;'),(245,'News > Military','<a href=\"http://www.yellowpagelistingz.com/news/\" name=\"cat_242\" style=\"\">News</a> > <a href=\"http://www.yellowpagelistingz.com/news/military/\" name=\"cat_245\" style=\"\">Military</a>',';242;0;'),(246,'News > Politics','<a href=\"http://www.yellowpagelistingz.com/news/\" name=\"cat_242\" style=\"\">News</a> > <a href=\"http://www.yellowpagelistingz.com/news/politics/\" name=\"cat_246\" style=\"\">Politics</a>',';242;0;'),(247,'News > Weather','<a href=\"http://www.yellowpagelistingz.com/news/\" name=\"cat_242\" style=\"\">News</a> > <a href=\"http://www.yellowpagelistingz.com/news/weather/\" name=\"cat_247\" style=\"\">Weather</a>',';242;0;'),(248,'Real Estate Listings','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a>',';0;'),(249,'Real Estate Listings > Commercial Property','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/commercial-property/\" name=\"cat_249\" style=\"\">Commercial Property</a>',';248;0;'),(250,'Real Estate Listings > Condominiums','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/condominiums/\" name=\"cat_250\" style=\"\">Condominiums</a>',';248;0;'),(251,'Real Estate Listings > Buying Property','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/buying-property/\" name=\"cat_251\" style=\"\">Buying Property</a>',';248;0;'),(252,'Real Estate Listings > Foreclosures','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/foreclosures/\" name=\"cat_252\" style=\"\">Foreclosures</a>',';248;0;'),(253,'Real Estate Listings > Homes ','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/homes/\" name=\"cat_253\" style=\"\">Homes </a>',';248;0;'),(254,'Real Estate Listings > Homes for Sale ','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/homes-for-sale/\" name=\"cat_254\" style=\"\">Homes for Sale </a>',';248;0;'),(255,'Real Estate Listings > Leasing ','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/leasing/\" name=\"cat_255\" style=\"\">Leasing </a>',';248;0;'),(256,'Real Estate Listings > Mortgages','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/mortgages/\" name=\"cat_256\" style=\"\">Mortgages</a>',';248;0;'),(257,'Real Estate Listings > Property Management','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/property-management/\" name=\"cat_257\" style=\"\">Property Management</a>',';248;0;'),(258,'Real Estate Listings > Real Estate Agent','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/real-estate-agent/\" name=\"cat_258\" style=\"\">Real Estate Agent</a>',';248;0;'),(259,'Real Estate Listings > Residential Property','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/residential%e2%a0property/\" name=\"cat_259\" style=\"\">Residential Property</a>',';248;0;'),(260,'Real Estate Listings > Selling Property','<a href=\"http://www.yellowpagelistingz.com/real-estate-listings/\" name=\"cat_248\" style=\"\">Real Estate Listings</a> > <a href=\"http://www.yellowpagelistingz.com/real-estate-listings/selling-property/\" name=\"cat_260\" style=\"\">Selling Property</a>',';248;0;'),(261,'Relationships & Lifestyle','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a>',';0;'),(262,'Relationships & Lifestyle > Adult','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/adult/\" name=\"cat_262\" style=\"\">Adult</a>',';261;0;'),(263,'Relationships & Lifestyle > Dating','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/dating/\" name=\"cat_263\" style=\"\">Dating</a>',';261;0;'),(264,'Relationships & Lifestyle > Divorce','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/divorce/\" name=\"cat_264\" style=\"\">Divorce</a>',';261;0;'),(265,'Relationships & Lifestyle > Friendship','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/friendship/\" name=\"cat_265\" style=\"\">Friendship</a>',';261;0;'),(266,'Relationships & Lifestyle > Love & Romance','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/love-romance/\" name=\"cat_266\" style=\"\">Love & Romance</a>',';261;0;'),(267,'Relationships & Lifestyle > Society & People','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/society-people/\" name=\"cat_267\" style=\"\">Society & People</a>',';261;0;'),(268,'Relationships & Lifestyle > Weddings','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/weddings/\" name=\"cat_268\" style=\"\">Weddings</a>',';261;0;'),(269,'Relationships & Lifestyle > Religion and Spirituality','<a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/\" name=\"cat_261\" style=\"\">Relationships & Lifestyle</a> > <a href=\"http://www.yellowpagelistingz.com/relationships-lifestyle/religion-and-spirituality/\" name=\"cat_269\" style=\"\">Religion and Spirituality</a>',';261;0;'),(270,'Science & Technology','<a href=\"http://www.yellowpagelistingz.com/science-technology/\" name=\"cat_270\" style=\"\">Science & Technology</a>',';0;'),(271,'Science & Technology > Agricultural','<a href=\"http://www.yellowpagelistingz.com/science-technology/\" name=\"cat_270\" style=\"\">Science & Technology</a> > <a href=\"http://www.yellowpagelistingz.com/science-technology/agricultural/\" name=\"cat_271\" style=\"\">Agricultural</a>',';270;0;'),(272,'Science & Technology > Environment','<a href=\"http://www.yellowpagelistingz.com/science-technology/\" name=\"cat_270\" style=\"\">Science & Technology</a> > <a href=\"http://www.yellowpagelistingz.com/science-technology/environment/\" name=\"cat_272\" style=\"\">Environment</a>',';270;0;'),(273,'Science & Technology > Medical','<a href=\"http://www.yellowpagelistingz.com/science-technology/\" name=\"cat_270\" style=\"\">Science & Technology</a> > <a href=\"http://www.yellowpagelistingz.com/science-technology/medical/\" name=\"cat_273\" style=\"\">Medical</a>',';270;0;'),(274,'Science & Technology > Energy','<a href=\"http://www.yellowpagelistingz.com/science-technology/\" name=\"cat_270\" style=\"\">Science & Technology</a> > <a href=\"http://www.yellowpagelistingz.com/science-technology/energy/\" name=\"cat_274\" style=\"\">Energy</a>',';270;0;'),(275,'Science & Technology > Recycling & Waste Management','<a href=\"http://www.yellowpagelistingz.com/science-technology/\" name=\"cat_270\" style=\"\">Science & Technology</a> > <a href=\"http://www.yellowpagelistingz.com/science-technology/recycling-waste-management/\" name=\"cat_275\" style=\"\">Recycling & Waste Management</a>',';270;0;'),(276,'Shopping','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a>',';0;'),(277,'Shopping > Antiques and Collectibles','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/antiques-and-collectibles/\" name=\"cat_277\" style=\"\">Antiques and Collectibles</a>',';276;0;'),(278,'Shopping > Auctions','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/auctions/\" name=\"cat_278\" style=\"\">Auctions</a>',';276;0;'),(279,'Shopping > Baby Accessories','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/baby-accessories/\" name=\"cat_279\" style=\"\">Baby Accessories</a>',';276;0;'),(280,'Shopping > Beauty & Fashion','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/beauty-fashion/\" name=\"cat_280\" style=\"\">Beauty & Fashion</a>',';276;0;'),(281,'Shopping > Books','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/books/\" name=\"cat_281\" style=\"\">Books</a>',';276;0;'),(282,'Shopping > Clothing','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/clothing/\" name=\"cat_282\" style=\"\">Clothing</a>',';276;0;'),(283,'Shopping > Crafts ','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/crafts%e2%a0/\" name=\"cat_283\" style=\"\">Crafts </a>',';276;0;'),(284,'Shopping > Electronics and Electrical Components ','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/electronics-and-electrical-components/\" name=\"cat_284\" style=\"\">Electronics and Electrical Components </a>',';276;0;'),(285,'Shopping > Fashion & Style','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/fashion-style/\" name=\"cat_285\" style=\"\">Fashion & Style</a>',';276;0;'),(286,'Shopping > Flowers','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/flowers/\" name=\"cat_286\" style=\"\">Flowers</a>',';276;0;'),(287,'Shopping > Food & Drink','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/food-drink/\" name=\"cat_287\" style=\"\">Food & Drink</a>',';276;0;'),(288,'Shopping > Furniture','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/furniture/\" name=\"cat_288\" style=\"\">Furniture</a>',';276;0;'),(289,'Shopping > Gifts','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/gifts/\" name=\"cat_289\" style=\"\">Gifts</a>',';276;0;'),(290,'Shopping > Jewelry','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/jewelry/\" name=\"cat_290\" style=\"\">Jewelry</a>',';276;0;'),(291,'Shopping > Office Products','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/office-products/\" name=\"cat_291\" style=\"\">Office Products</a>',';276;0;'),(292,'Shopping > Pets','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/pets/\" name=\"cat_292\" style=\"\">Pets</a>',';276;0;'),(293,'Shopping > Toys and Games','<a href=\"http://www.yellowpagelistingz.com/shopping/\" name=\"cat_276\" style=\"\">Shopping</a> > <a href=\"http://www.yellowpagelistingz.com/shopping/toys-and-games/\" name=\"cat_293\" style=\"\">Toys and Games</a>',';276;0;'),(294,'Sports & Games','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a>',';0;'),(295,'Sports & Games > Boating','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/boating/\" name=\"cat_295\" style=\"\">Boating</a>',';294;0;'),(296,'Sports & Games > Casino','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/casino/\" name=\"cat_296\" style=\"\">Casino</a>',';294;0;'),(297,'Sports & Games > Fishing','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/fishing/\" name=\"cat_297\" style=\"\">Fishing</a>',';294;0;'),(298,'Sports & Games > Gambling','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/gambling/\" name=\"cat_298\" style=\"\">Gambling</a>',';294;0;'),(299,'Sports & Games > Skateboarding','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/skateboarding/\" name=\"cat_299\" style=\"\">Skateboarding</a>',';294;0;'),(300,'Sports & Games > Sports Accessories','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/sports-accessories/\" name=\"cat_300\" style=\"\">Sports Accessories</a>',';294;0;'),(301,'Sports & Games > Sports Apparel','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/sports-apparel/\" name=\"cat_301\" style=\"\">Sports Apparel</a>',';294;0;'),(302,'Sports & Games > Sports Betting','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/sports-betting/\" name=\"cat_302\" style=\"\">Sports Betting</a>',';294;0;'),(303,'Sports & Games > Water Sports','<a href=\"http://www.yellowpagelistingz.com/sports-games/\" name=\"cat_294\" style=\"\">Sports & Games</a> > <a href=\"http://www.yellowpagelistingz.com/sports-games/water-sports/\" name=\"cat_303\" style=\"\">Water Sports</a>',';294;0;'),(304,'Travel & Vacation','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a>',';0;'),(305,'Travel & Vacation > Air Travel','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/air-travel/\" name=\"cat_305\" style=\"\">Air Travel</a>',';304;0;'),(306,'Travel & Vacation > Apartments','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/apartments/\" name=\"cat_306\" style=\"\">Apartments</a>',';304;0;'),(307,'Travel & Vacation > Car Rentals','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/car-rentals/\" name=\"cat_307\" style=\"\">Car Rentals</a>',';304;0;'),(308,'Travel & Vacation > Charter Jets','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/charter-jets/\" name=\"cat_308\" style=\"\">Charter Jets</a>',';304;0;'),(309,'Travel & Vacation > Cruising','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/cruising/\" name=\"cat_309\" style=\"\">Cruising</a>',';304;0;'),(310,'Travel & Vacation > Limos & Shuttles','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/limos-shuttles/\" name=\"cat_310\" style=\"\">Limos & Shuttles</a>',';304;0;'),(311,'Travel & Vacation > Passport & Visa Services','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/passport-visa-services/\" name=\"cat_311\" style=\"\">Passport & Visa Services</a>',';304;0;'),(312,'Travel & Vacation > Tour Operators','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/tour-operators/\" name=\"cat_312\" style=\"\">Tour Operators</a>',';304;0;'),(313,'Travel & Vacation > Transportation','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/transportation/\" name=\"cat_313\" style=\"\">Transportation</a>',';304;0;'),(314,'Travel & Vacation > Vacation Homes','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/vacation-homes/\" name=\"cat_314\" style=\"\">Vacation Homes</a>',';304;0;'),(315,'Travel & Vacation > Vacation Rentals','<a href=\"http://www.yellowpagelistingz.com/travel-vacation/\" name=\"cat_304\" style=\"\">Travel & Vacation</a> > <a href=\"http://www.yellowpagelistingz.com/travel-vacation/vacation-rentals/\" name=\"cat_315\" style=\"\">Vacation Rentals</a>',';304;0;'),(316,'Arts Gallery & Entertainment','<a href=\"http://www.yellowpagelistingz.com/arts-gallery-entertainment/\" name=\"cat_316\" style=\"\">Arts Gallery & Entertainment</a>',';0;'),(317,'Automobiles','<a href=\"http://www.yellowpagelistingz.com/automobiles/\" name=\"cat_317\" style=\"\">Automobiles</a>',';0;'),(318,'Business & Investment','<a href=\"http://www.yellowpagelistingz.com/business-investment/\" name=\"cat_318\" style=\"\">Business & Investment</a>',';0;'),(319,'Careers & Recruitment','<a href=\"http://www.yellowpagelistingz.com/careers-recruitment/\" name=\"cat_319\" style=\"\">Careers & Recruitment</a>',';0;'),(320,'Clothing & Designers','<a href=\"http://www.yellowpagelistingz.com/clothing-designers/\" name=\"cat_320\" style=\"\">Clothing & Designers</a>',';0;'),(321,'Communication ','<a href=\"http://www.yellowpagelistingz.com/communication/\" name=\"cat_321\" style=\"\">Communication </a>',';0;'),(322,'Computers','<a href=\"http://www.yellowpagelistingz.com/computers/\" name=\"cat_322\" style=\"\">Computers</a>',';0;'),(323,'Construction Services','<a href=\"http://www.yellowpagelistingz.com/construction-services/\" name=\"cat_323\" style=\"\">Construction Services</a>',';0;'),(324,'Dental Health','<a href=\"http://www.yellowpagelistingz.com/dental-health/\" name=\"cat_324\" style=\"\">Dental Health</a>',';0;'),(325,'Education & Training','<a href=\"http://www.yellowpagelistingz.com/education-training/\" name=\"cat_325\" style=\"\">Education & Training</a>',';0;'),(326,'Employment & Recruitment','<a href=\"http://www.yellowpagelistingz.com/employment-recruitment/\" name=\"cat_326\" style=\"\">Employment & Recruitment</a>',';0;'),(327,'Gifts & Novelties','<a href=\"http://www.yellowpagelistingz.com/gifts-novelties/\" name=\"cat_327\" style=\"\">Gifts & Novelties</a>',';0;'),(328,'Software & Hardware','<a href=\"http://www.yellowpagelistingz.com/software-hardware/\" name=\"cat_328\" style=\"\">Software & Hardware</a>',';0;'),(329,'Health Services','<a href=\"http://www.yellowpagelistingz.com/health-services/\" name=\"cat_329\" style=\"\">Health Services</a>',';0;'),(330,'Healthcare Industry','<a href=\"http://www.yellowpagelistingz.com/healthcare-industry/\" name=\"cat_330\" style=\"\">Healthcare Industry</a>',';0;'),(331,'Heating, Ventilating and Air Conditioning','<a href=\"http://www.yellowpagelistingz.com/heating-ventilating-and-air-conditioning/\" name=\"cat_331\" style=\"\">Heating, Ventilating and Air Conditioning</a>',';0;'),(332,'Home & Garden Making','<a href=\"http://www.yellowpagelistingz.com/home-garden-making/\" name=\"cat_332\" style=\"\">Home & Garden Making</a>',';0;'),(333,'Home Improvement & Appliances ','<a href=\"http://www.yellowpagelistingz.com/home-improvement-appliances/\" name=\"cat_333\" style=\"\">Home Improvement & Appliances </a>',';0;'),(334,'Hotels ','<a href=\"http://www.yellowpagelistingz.com/hotels/\" name=\"cat_334\" style=\"\">Hotels </a>',';0;'),(335,'Insurance Providers','<a href=\"http://www.yellowpagelistingz.com/insurance-providers/\" name=\"cat_335\" style=\"\">Insurance Providers</a>',';0;'),(336,'Law & Legal','<a href=\"http://www.yellowpagelistingz.com/law-legal/\" name=\"cat_336\" style=\"\">Law & Legal</a>',';0;'),(337,'Lawyers & Attorneys','<a href=\"http://www.yellowpagelistingz.com/lawyers-attorneys/\" name=\"cat_337\" style=\"\">Lawyers & Attorneys</a>',';0;'),(338,'Lifestyle & Society','<a href=\"http://www.yellowpagelistingz.com/lifestyle-society/\" name=\"cat_338\" style=\"\">Lifestyle & Society</a>',';0;'),(339,'Medicine & Surgery','<a href=\"http://www.yellowpagelistingz.com/medicine-surgery/\" name=\"cat_339\" style=\"\">Medicine & Surgery</a>',';0;'),(340,'Finance & Investment','<a href=\"http://www.yellowpagelistingz.com/finance-investment/\" name=\"cat_340\" style=\"\">Finance & Investment</a>',';0;'),(341,'News & Media','<a href=\"http://www.yellowpagelistingz.com/news-media/\" name=\"cat_341\" style=\"\">News & Media</a>',';0;'),(342,'Plumbing Contractors','<a href=\"http://www.yellowpagelistingz.com/plumbing-contractors/\" name=\"cat_342\" style=\"\">Plumbing Contractors</a>',';0;'),(343,'Real Estate & Property','<a href=\"http://www.yellowpagelistingz.com/real-estate-property/\" name=\"cat_343\" style=\"\">Real Estate & Property</a>',';0;'),(344,'Science ','<a href=\"http://www.yellowpagelistingz.com/science/\" name=\"cat_344\" style=\"\">Science </a>',';0;'),(345,'SEO ,SMO & PPC','<a href=\"http://www.yellowpagelistingz.com/seo-smo-ppc/\" name=\"cat_345\" style=\"\">SEO ,SMO & PPC</a>',';0;'),(346,'Shopping and Sales','<a href=\"http://www.yellowpagelistingz.com/shopping-and-sales/\" name=\"cat_346\" style=\"\">Shopping and Sales</a>',';0;'),(347,'Sports & Recreation','<a href=\"http://www.yellowpagelistingz.com/sports-recreation/\" name=\"cat_347\" style=\"\">Sports & Recreation</a>',';0;'),(348,'Transportation Services','<a href=\"http://www.yellowpagelistingz.com/transportation-services/\" name=\"cat_348\" style=\"\">Transportation Services</a>',';0;'),(349,'Travel & Tour','<a href=\"http://www.yellowpagelistingz.com/travel-tour/\" name=\"cat_349\" style=\"\">Travel & Tour</a>',';0;'),(350,'Weddings','<a href=\"http://www.yellowpagelistingz.com/weddings/\" name=\"cat_350\" style=\"\">Weddings</a>',';0;');

--
-- Table structure for table `idx_category_suggession`
--

CREATE TABLE `idx_category_suggession` (
  `id_cat_suggession` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_description` text COLLATE utf8_unicode_ci,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id_cat_suggession`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_category_suggession`
--

INSERT INTO `idx_category_suggession` VALUES (1,294,'mountain wear','ItemNo: 3S OD0123\r\nName: Mountain \r\nDescription: \r\nnylon coated Pu, W/P:3000 -10000mm , MVP:3000 -5000g /m2/24hrs \r\n','2011-08-02 21:10:04'),(2,348,'Caro','Never seen a bteter post! ICOCBW','2011-11-03 00:46:36');

--
-- Table structure for table `idx_checkurl`
--

CREATE TABLE `idx_checkurl` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `live` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `reciprocal_found` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_checkurl`
--


--
-- Table structure for table `idx_cronjobs`
--

CREATE TABLE `idx_cronjobs` (
  `cronjobs_id` int(11) NOT NULL AUTO_INCREMENT,
  `cronjobs_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `schedule` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cronjobs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_cronjobs`
--

INSERT INTO `idx_cronjobs` VALUES (1,NULL,'clear_templates_c.php','1,*,*,*,*','0000-00-00 00:00:00',''),(2,NULL,'update_tag_cloud.php','*,24,*,*,*','0000-00-00 00:00:00',''),(3,NULL,'clear_rss_cache.php','*,24,*,*,*','0000-00-00 00:00:00','');

--
-- Table structure for table `idx_custom_field`
--

CREATE TABLE `idx_custom_field` (
  `field_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_text` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_type` enum('TEXT','TEXTAREA','SELECT','MULTISELECT','CHECKBOX','RADIO','FILE','IMAGE','DATE','DATETIME','RICHEDITOR') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TEXT',
  `field_option` text COLLATE utf8_unicode_ci NOT NULL,
  `field_img_width` int(10) unsigned NOT NULL DEFAULT '0',
  `field_img_height` int(10) unsigned NOT NULL DEFAULT '0',
  `field_file_size` int(10) unsigned NOT NULL DEFAULT '0',
  `field_file_extension` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `required` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `searchable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `permission` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_custom_field`
--

INSERT INTO `idx_custom_field` VALUES ('image','Image','IMAGE','',0,0,0,'','0','0','2'),('address','Address','TEXT','',0,0,0,'','0','0','0'),('city','City','TEXT','',0,0,0,'','0','0','0'),('state','State','TEXT','',0,0,0,'','0','0','0'),('country','Country','TEXT','',0,0,0,'','0','0','0'),('zip','Zip','TEXT','',0,0,0,'','0','0','0'),('phone','Phone','TEXT','',0,0,0,'','0','0','0'),('fax','Fax','TEXT','',0,0,0,'','0','0','0');

--
-- Table structure for table `idx_default_field`
--

CREATE TABLE `idx_default_field` (
  `field_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `required` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `visible` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `searchable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_default_field`
--

INSERT INTO `idx_default_field` VALUES ('title','1','1','1'),('url','1','1','1'),('description','1','1','1'),('keywords','1','1','0'),('contact_name','1','1','1'),('email','1','1','1'),('reciprocal_url','0','0','1');

--
-- Table structure for table `idx_discount_coupon`
--

CREATE TABLE `idx_discount_coupon` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coupon_value` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `expired_usage` int(11) DEFAULT NULL,
  `usage_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_discount_coupon`
--


--
-- Table structure for table `idx_editor`
--

CREATE TABLE `idx_editor` (
  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_id` mediumint(9) DEFAULT NULL,
  `category` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `review` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pick` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_editor`
--


--
-- Table structure for table `idx_email_template`
--

CREATE TABLE `idx_email_template` (
  `email_template_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `altbody` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`email_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_email_template`
--



--
-- Table structure for table `idx_favorites`
--

CREATE TABLE `idx_favorites` (
  `favorite_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`favorite_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_favorites`
--

INSERT INTO `idx_favorites` VALUES (1,'hlmudcleaning','2011-06-01','drilling fluid solid control equipment','HL Mud Cleaning Equipment Co.,Ltd is a hi-tech company in xi’an, Our company is mainly engaged in production of petroleum drilling solid control equipment. including SB serial sand pumps, JQ serial shear pumps, LW serial centrifuges, ZZS serial vibrating screens, CS Desanders, CN Desilters, QJ serial integrated cleansers, ZCQ vacuum Degasser, screen cloths of vibrating screen, mixing hoppers, cyclones, JB/W serial mud agitators, BRE barite reclaiming systems and drilling fluid-solid control circulatory systems. \r\n\r\nhttp://www.hlmudcleaning.com'),(2,'gavinli80','2011-08-02','My Favorites',NULL),(3,'sgjgems','2011-09-07','My Favorites',NULL),(4,'winchoice','2011-09-16','My Favorites',NULL),(5,'adaptive84','2011-12-07','My Favorites',NULL);

--
-- Table structure for table `idx_favorites_detail`
--

CREATE TABLE `idx_favorites_detail` (
  `favorite_id` int(11) DEFAULT NULL,
  `link_id` mediumint(9) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_favorites_detail`
--


--
-- Table structure for table `idx_hook_place`
--

CREATE TABLE `idx_hook_place` (
  `hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hookname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_hook_place`
--


--
-- Table structure for table `idx_invoice`
--

CREATE TABLE `idx_invoice` (
  `invoice_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `invoice_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `invoiced_to` text COLLATE utf8_unicode_ci,
  `service` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `total` double(8,2) DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  `paid` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `paid_date` date DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_invoice`
--


--
-- Table structure for table `idx_invoice_config`
--

CREATE TABLE `idx_invoice_config` (
  `company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(255) COLLATE utf8_unicode_ci DEFAULT '$',
  `currency_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'USD'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_invoice_config`
--

INSERT INTO `idx_invoice_config` VALUES ('Your website / Company','Billing Department','Your address','Your phone #','Billing<name@yourdomain.com>','$','USD');

--
-- Table structure for table `idx_link_temp_user`
--

CREATE TABLE `idx_link_temp_user` (
  `vid` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_link_temp_user`
--


--
-- Table structure for table `idx_link_user`
--

CREATE TABLE `idx_link_user` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_link_user`
--

INSERT INTO `idx_link_user` VALUES (1,'sgjgems'),(2,'sgjgems'),(48,'winchoice');

--
-- Table structure for table `idx_mailing_list`
--

CREATE TABLE `idx_mailing_list` (
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_mailing_list`
--


--
-- Table structure for table `idx_message`
--

CREATE TABLE `idx_message` (
  `message_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `subject` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_message`
--


--
-- Table structure for table `idx_notification`
--

CREATE TABLE `idx_notification` (
  `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `category_id` mediumint(9) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_notification`
--

INSERT INTO `idx_notification` VALUES ('admin',43);

--
-- Table structure for table `idx_pagerank`
--

CREATE TABLE `idx_pagerank` (
  `link_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `engine` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rank` tinyint(4) NOT NULL DEFAULT '0',
  `last_update` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`link_id`,`engine`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_pagerank`
--

INSERT INTO `idx_pagerank` VALUES (35,'g',3,'2011-09-26'),(36,'g',3,'2011-09-26'),(40,'g',2,'2011-09-26'),(42,'g',2,'2011-09-26'),(41,'g',2,'2011-09-26'),(3,'g',4,'2011-09-28'),(32,'g',6,'2011-09-29'),(34,'g',3,'2011-09-29'),(4,'g',4,'2011-09-29'),(37,'g',3,'2011-09-29'),(31,'g',0,'2011-10-15'),(19,'g',0,'2011-10-15'),(27,'g',0,'2011-10-15'),(10,'g',0,'2011-12-01'),(17,'g',0,'2011-10-15'),(50,'g',0,'2011-10-15'),(44,'g',0,'2011-10-15'),(43,'g',0,'2011-10-15'),(45,'g',0,'2011-10-15'),(46,'g',0,'2011-10-15'),(47,'g',0,'2011-10-15'),(49,'g',0,'2011-10-15'),(15,'g',0,'2011-10-15'),(48,'g',0,'2011-10-15'),(33,'g',0,'2011-10-15'),(6,'g',0,'2011-12-01'),(16,'g',0,'2011-10-15'),(20,'g',0,'2011-10-15'),(21,'g',0,'2011-10-15'),(24,'g',0,'2011-10-15'),(25,'g',0,'2011-10-15'),(26,'g',0,'2011-10-15'),(13,'g',0,'2011-10-15'),(30,'g',0,'2011-10-15'),(18,'g',0,'2011-10-15'),(2,'g',0,'2011-10-15'),(1,'g',0,'2011-10-15'),(23,'g',0,'2011-10-15'),(22,'g',0,'2011-10-15'),(5,'g',0,'2011-10-15'),(7,'g',0,'2011-11-18'),(14,'g',0,'2011-10-15'),(8,'g',0,'2011-11-30'),(11,'g',0,'2011-10-15'),(9,'g',0,'2011-11-03'),(136,'g',0,'2011-11-17'),(142,'g',0,'2011-11-17'),(160,'g',0,'2011-11-17'),(175,'g',0,'2011-11-17'),(114,'g',0,'2011-11-17'),(451,'g',0,'2011-11-17'),(453,'g',0,'2011-11-17'),(473,'g',0,'2011-11-17'),(79,'g',0,'2011-11-17'),(89,'g',0,'2011-11-17'),(64,'g',0,'2011-11-17'),(91,'g',0,'2011-11-17'),(69,'g',0,'2011-11-17'),(94,'g',0,'2011-11-17'),(203,'g',0,'2011-11-17'),(108,'g',0,'2011-11-17'),(442,'g',0,'2011-11-17'),(244,'g',0,'2011-11-17'),(245,'g',0,'2011-11-17'),(306,'g',0,'2011-11-17'),(297,'g',0,'2011-11-17'),(448,'g',0,'2011-11-17'),(60,'g',0,'2011-11-19'),(844,'g',0,'2011-11-21'),(81,'g',0,'2011-11-23'),(145,'g',0,'2011-11-24'),(109,'g',0,'2011-11-24'),(1098,'g',0,'2011-11-24'),(592,'g',0,'2011-11-24'),(817,'g',0,'2011-11-25'),(128,'g',0,'2011-11-28'),(180,'g',0,'2011-11-28'),(154,'g',0,'2011-11-29'),(87,'g',0,'2011-11-29'),(167,'g',0,'2011-11-29'),(174,'g',0,'2011-11-29'),(171,'g',0,'2011-11-29'),(205,'g',0,'2011-11-29'),(57,'g',0,'2011-11-29'),(83,'g',0,'2011-11-29'),(246,'g',0,'2011-11-29'),(269,'g',0,'2011-11-29'),(446,'g',0,'2011-11-29'),(107,'g',0,'2011-11-30'),(55,'g',0,'2011-11-30'),(54,'g',0,'2011-11-30'),(194,'g',0,'2011-11-30'),(90,'g',0,'2011-12-01'),(93,'g',0,'2011-12-01'),(92,'g',0,'2011-12-01'),(95,'g',0,'2011-12-01'),(96,'g',0,'2011-12-01'),(97,'g',0,'2011-12-01'),(98,'g',0,'2011-12-01'),(99,'g',0,'2011-12-01'),(100,'g',0,'2011-12-01'),(103,'g',0,'2011-12-01'),(117,'g',0,'2011-12-01'),(262,'g',0,'2011-12-01'),(101,'g',0,'2011-12-01'),(102,'g',0,'2011-12-01'),(84,'g',0,'2011-12-01'),(74,'g',0,'2011-12-01'),(71,'g',0,'2011-12-01'),(67,'g',0,'2011-12-01'),(66,'g',0,'2011-12-01'),(123,'g',0,'2011-12-01'),(72,'g',0,'2011-12-01'),(70,'g',0,'2011-12-01'),(566,'g',0,'2011-12-01'),(640,'g',0,'2011-12-01'),(641,'g',0,'2011-12-01'),(649,'g',0,'2011-12-01'),(699,'g',0,'2011-12-01'),(835,'g',0,'2011-12-01'),(1366,'g',0,'2011-12-01'),(659,'g',0,'2011-12-01'),(803,'g',0,'2011-12-01'),(88,'g',0,'2011-12-01'),(249,'g',0,'2011-12-01'),(1440,'g',0,'2011-12-01'),(863,'g',0,'2011-12-01'),(1299,'g',0,'2011-12-01'),(52,'g',0,'2011-12-01'),(2520,'g',0,'2012-02-19'),(2956,'g',0,'2012-01-10'),(56,'g',0,'2011-12-01'),(63,'g',0,'2011-12-01'),(339,'g',0,'2011-12-01'),(769,'g',0,'2011-12-01'),(791,'g',0,'2011-12-01'),(819,'g',0,'2011-12-01'),(856,'g',0,'2011-12-01'),(499,'g',0,'2011-12-01'),(1569,'g',0,'2011-12-01'),(1591,'g',0,'2011-12-01'),(1663,'g',0,'2011-12-01'),(2099,'g',0,'2011-12-01'),(1139,'g',0,'2011-12-01'),(131,'g',0,'2011-12-01'),(268,'g',0,'2011-12-01'),(469,'g',0,'2011-12-01'),(477,'g',0,'2011-12-01'),(483,'g',0,'2011-12-01'),(61,'g',0,'2011-12-01'),(151,'g',0,'2011-12-01'),(462,'g',0,'2011-12-01'),(482,'g',0,'2011-12-01'),(484,'g',0,'2011-12-01'),(251,'g',0,'2011-12-01'),(470,'g',0,'2011-12-01'),(896,'g',0,'2011-12-01'),(897,'g',0,'2011-12-01'),(899,'g',0,'2011-12-01'),(900,'g',0,'2011-12-01'),(901,'g',0,'2011-12-01'),(902,'g',0,'2011-12-01'),(917,'g',0,'2011-12-01'),(898,'g',0,'2011-12-01'),(903,'g',0,'2011-12-01'),(1062,'g',0,'2011-12-01'),(240,'g',0,'2011-12-01'),(513,'g',0,'2011-12-01'),(739,'g',0,'2011-12-01'),(1539,'g',0,'2011-12-01'),(1840,'g',0,'2011-12-01'),(2113,'g',0,'2011-12-01'),(2339,'g',0,'2011-12-01'),(2697,'g',0,'2012-01-09'),(68,'g',0,'2011-12-01'),(118,'g',0,'2011-12-01'),(124,'g',0,'2011-12-01'),(126,'g',0,'2011-12-01'),(132,'g',0,'2011-12-01'),(138,'g',0,'2011-12-01'),(141,'g',0,'2011-12-01'),(1040,'g',0,'2011-12-01'),(1313,'g',0,'2011-12-01'),(121,'g',0,'2011-12-01'),(147,'g',0,'2011-12-01'),(53,'g',0,'2011-12-02'),(192,'g',0,'2011-12-02'),(452,'g',0,'2011-12-02'),(455,'g',0,'2011-12-02'),(506,'g',0,'2011-12-02'),(1252,'g',0,'2011-12-02'),(1255,'g',0,'2011-12-02'),(1306,'g',0,'2011-12-02'),(1352,'g',0,'2011-12-02'),(1382,'g',0,'2011-12-02'),(552,'g',0,'2011-12-02'),(582,'g',0,'2011-12-02'),(787,'g',0,'2011-12-02'),(749,'g',0,'2011-12-02'),(1549,'g',0,'2011-12-02'),(2349,'g',0,'2011-12-02'),(3206,'g',0,'2012-01-11'),(209,'g',0,'2011-12-06'),(2412,'g',0,'2011-12-06'),(511,'g',0,'2011-12-06'),(1691,'g',0,'2011-12-06'),(532,'g',0,'2011-12-07'),(2461,'g',0,'2011-12-07'),(518,'g',0,'2011-12-08'),(3691,'g',0,'2012-02-19'),(3652,'g',0,'2011-12-15'),(2526,'g',0,'2012-02-19'),(2536,'g',0,'2012-02-19'),(2548,'g',0,'2012-02-19'),(2521,'g',0,'2011-12-15'),(2547,'g',0,'2012-02-19'),(2546,'g',0,'2012-02-19'),(2550,'g',0,'2012-02-19'),(2549,'g',0,'2012-02-19'),(2660,'g',0,'2012-03-06'),(2905,'g',0,'2012-03-06'),(2708,'g',0,'2012-03-06'),(2754,'g',0,'2012-03-06'),(2701,'g',0,'2012-03-06'),(2927,'g',0,'2011-12-15'),(2702,'g',0,'2012-03-06'),(2899,'g',0,'2012-03-06'),(2763,'g',0,'2012-03-06'),(3650,'g',0,'2011-12-16'),(2524,'g',0,'2011-12-16'),(3689,'g',0,'2011-12-16'),(2527,'g',0,'2011-12-16'),(3023,'g',0,'2012-01-24'),(3379,'g',0,'2012-02-20'),(3338,'g',0,'2012-02-20'),(3106,'g',0,'2012-02-16'),(3156,'g',0,'2012-02-20'),(3098,'g',0,'2012-02-16'),(3293,'g',0,'2011-12-19'),(2532,'g',0,'2012-02-19'),(2567,'g',0,'2012-02-19'),(3722,'g',0,'2012-02-19'),(2601,'g',0,'2012-02-19'),(2573,'g',0,'2011-12-23'),(2591,'g',0,'2012-02-19'),(2572,'g',0,'2012-02-19'),(2618,'g',0,'2012-02-19'),(2620,'g',0,'2012-02-19'),(3680,'g',0,'2012-02-20'),(3478,'g',0,'2011-12-28'),(2712,'g',0,'2012-02-02'),(3725,'g',0,'2012-02-19'),(3711,'g',0,'2012-02-19'),(3710,'g',0,'2012-02-02'),(2585,'g',0,'2012-02-19'),(3793,'g',0,'2012-02-19'),(2571,'g',0,'2012-01-03'),(2593,'g',0,'2012-02-19'),(2599,'g',0,'2012-02-19'),(2617,'g',0,'2012-01-03'),(2632,'g',0,'2012-02-19'),(3116,'g',0,'2012-02-16'),(3816,'g',0,'2012-02-20'),(3394,'g',0,'2012-02-20'),(2764,'g',0,'2012-01-07'),(3165,'g',0,'2012-02-20'),(3551,'g',0,'2012-02-20'),(3485,'g',0,'2012-02-19'),(3712,'g',0,'2012-02-19'),(3704,'g',0,'2012-01-08'),(2551,'g',0,'2012-02-19'),(3798,'g',0,'2012-02-20'),(3799,'g',0,'2012-02-20'),(3795,'g',0,'2012-02-20'),(3808,'g',0,'2012-01-09'),(3807,'g',0,'2012-02-20'),(3802,'g',0,'2012-02-20'),(3776,'g',0,'2012-02-20'),(3777,'g',0,'2012-02-20'),(3773,'g',0,'2012-02-20'),(3817,'g',0,'2012-02-20'),(3097,'g',0,'2012-02-20'),(3061,'g',0,'2012-01-09'),(3307,'g',0,'2012-01-09'),(3792,'g',0,'2012-02-20'),(2782,'g',0,'2012-02-20'),(3070,'g',0,'2012-02-20'),(3173,'g',0,'2012-02-20'),(2813,'g',0,'2012-02-20'),(2923,'g',0,'2012-01-09'),(3350,'g',0,'2012-02-20'),(3131,'g',0,'2012-01-09'),(3550,'g',0,'2012-02-20'),(3554,'g',0,'2012-02-20'),(3544,'g',0,'2012-02-20'),(3533,'g',0,'2012-01-09'),(3196,'g',0,'2012-01-09'),(2970,'g',0,'2012-02-20'),(3782,'g',0,'2012-03-06'),(3723,'g',0,'2012-03-04'),(2752,'g',0,'2012-02-27'),(3552,'g',0,'2012-03-04'),(3147,'g',0,'2012-03-04'),(3246,'g',0,'2012-03-04'),(3545,'g',0,'2012-02-27'),(2587,'g',0,'2012-02-27'),(3679,'g',0,'2012-01-09'),(3192,'g',0,'2012-03-04'),(2759,'g',0,'2012-03-04'),(3319,'g',0,'2012-03-06'),(3399,'g',0,'2012-03-06'),(3281,'g',0,'2012-03-06'),(2796,'g',0,'2012-01-09'),(3361,'g',0,'2012-03-06'),(3439,'g',0,'2012-03-06'),(2513,'g',0,'2012-03-06'),(3542,'g',0,'2012-03-06'),(3233,'g',0,'2012-01-09'),(3565,'g',0,'2012-03-06'),(3775,'g',0,'2012-01-09'),(3769,'g',0,'2012-02-20'),(3781,'g',0,'2012-02-20'),(3785,'g',0,'2012-02-20'),(3779,'g',0,'2012-01-09'),(3790,'g',0,'2012-02-20'),(3787,'g',0,'2012-02-20'),(3789,'g',0,'2012-02-20'),(3822,'g',0,'2012-02-20'),(3821,'g',0,'2012-02-20'),(3753,'g',0,'2012-01-09'),(3761,'g',0,'2012-02-20'),(3763,'g',0,'2012-02-20'),(3757,'g',0,'2012-02-20'),(3820,'g',0,'2012-02-20'),(3813,'g',0,'2012-02-20'),(3814,'g',0,'2012-02-20'),(3811,'g',0,'2012-02-20'),(3812,'g',0,'2012-02-20'),(3770,'g',0,'2012-02-20'),(2565,'g',0,'2012-01-09'),(3742,'g',0,'2012-01-09'),(2540,'g',0,'2012-01-09'),(2713,'g',0,'2012-01-09'),(2710,'g',0,'2012-02-20'),(3744,'g',0,'2012-02-20'),(2514,'g',0,'2012-02-20'),(2726,'g',0,'2012-02-20'),(2703,'g',0,'2012-02-20'),(2903,'g',0,'2012-01-09'),(3806,'g',0,'2012-02-20'),(3317,'g',0,'2012-02-20'),(2755,'g',0,'2012-02-20'),(3119,'g',0,'2012-02-20'),(3320,'g',0,'2012-02-20'),(3743,'g',0,'2012-02-20'),(3359,'g',0,'2012-02-20'),(3337,'g',0,'2012-02-20'),(3405,'g',0,'2012-02-20'),(3692,'g',0,'2012-02-20'),(3049,'g',0,'2012-02-20'),(3700,'g',0,'2012-02-20'),(3720,'g',0,'2012-02-20'),(3713,'g',0,'2012-02-20'),(3796,'g',0,'2012-02-20'),(3760,'g',0,'2012-02-20'),(3758,'g',0,'2012-02-20'),(3756,'g',0,'2012-02-20'),(3755,'g',0,'2012-02-20'),(3699,'g',0,'2012-02-20'),(3732,'g',0,'2012-02-20'),(3467,'g',0,'2012-02-20'),(2745,'g',0,'2012-02-20'),(3762,'g',0,'2012-02-19'),(3752,'g',0,'2012-02-19'),(3797,'g',0,'2012-02-19'),(3788,'g',0,'2012-02-19'),(3823,'g',0,'2012-02-19'),(3819,'g',0,'2012-02-19'),(3715,'g',0,'2012-02-19'),(3805,'g',0,'2012-02-19'),(3709,'g',0,'2012-02-19'),(3039,'g',0,'2012-02-19'),(2912,'g',0,'2012-02-19'),(3009,'g',0,'2012-01-10'),(2909,'g',0,'2012-02-19'),(2963,'g',0,'2012-02-19'),(3075,'g',0,'2012-03-07'),(3086,'g',0,'2012-01-10'),(3085,'g',0,'2012-02-21'),(3210,'g',0,'2012-03-07'),(3158,'g',0,'2012-03-07'),(3222,'g',0,'2012-03-07'),(3161,'g',0,'2012-03-07'),(3130,'g',0,'2012-03-07'),(3132,'g',0,'2012-03-07'),(3035,'g',0,'2012-03-07'),(3694,'g',0,'2012-02-20'),(3693,'g',0,'2012-02-20'),(3749,'g',0,'2012-02-20'),(3818,'g',0,'2012-02-20'),(3810,'g',0,'2012-02-20'),(3778,'g',0,'2012-02-20'),(3701,'g',0,'2012-02-20'),(3706,'g',0,'2012-02-20'),(3708,'g',0,'2012-02-20'),(3707,'g',0,'2012-02-20'),(2552,'g',0,'2012-02-19'),(2553,'g',0,'2012-03-07'),(2574,'g',0,'2012-03-07'),(2554,'g',0,'2012-03-07'),(2560,'g',0,'2012-03-07'),(2556,'g',0,'2012-03-07'),(2555,'g',0,'2012-03-07'),(2558,'g',0,'2012-03-07'),(2557,'g',0,'2012-03-07'),(2559,'g',0,'2012-03-07'),(2596,'g',0,'2012-02-19'),(2535,'g',0,'2012-02-19'),(2534,'g',0,'2012-02-19'),(2808,'g',0,'2012-02-19'),(3809,'g',0,'2012-02-19'),(2953,'g',0,'2012-02-19'),(3815,'g',0,'2012-02-19'),(2960,'g',0,'2012-02-19'),(2788,'g',0,'2012-02-19'),(2979,'g',0,'2012-02-19'),(3628,'g',0,'2012-02-20'),(3731,'g',0,'2012-02-19'),(3786,'g',0,'2012-02-19'),(3487,'g',0,'2012-02-19'),(3486,'g',0,'2012-02-19'),(3488,'g',0,'2012-02-19'),(3483,'g',0,'2012-01-10'),(3484,'g',0,'2012-02-19'),(3794,'g',0,'2012-02-19'),(2510,'g',0,'2012-02-19'),(2651,'g',0,'2012-02-19'),(2649,'g',0,'2012-01-10'),(3716,'g',0,'2012-02-19'),(2602,'g',0,'2012-02-19'),(2511,'g',0,'2012-02-19'),(2512,'g',0,'2012-02-19'),(2517,'g',0,'2012-02-19'),(2720,'g',0,'2012-02-19'),(3001,'g',0,'2012-01-10'),(2901,'g',0,'2012-03-07'),(2990,'g',0,'2012-03-07'),(2958,'g',0,'2012-03-07'),(2938,'g',0,'2012-01-10'),(2733,'g',0,'2012-01-10'),(2751,'g',0,'2012-03-07'),(2892,'g',0,'2012-03-07'),(2719,'g',0,'2012-01-10'),(2920,'g',0,'2012-03-07'),(3783,'g',0,'2012-02-19'),(3800,'g',0,'2012-02-19'),(2563,'g',0,'2012-01-10'),(2619,'g',0,'2012-02-19'),(3163,'g',0,'2012-02-19'),(2999,'g',0,'2012-02-19'),(3046,'g',0,'2012-01-10'),(2607,'g',0,'2012-02-19'),(3767,'g',0,'2012-02-19'),(2769,'g',0,'2012-02-19'),(2767,'g',0,'2012-02-19'),(2978,'g',0,'2012-02-19'),(2977,'g',0,'2012-02-19'),(3791,'g',0,'2012-02-19'),(3804,'g',0,'2012-02-19'),(3780,'g',0,'2012-02-19'),(3735,'g',0,'2012-02-19'),(2539,'g',0,'2012-02-19'),(2537,'g',0,'2012-02-19'),(2561,'g',0,'2012-02-19'),(3746,'g',0,'2012-02-19'),(3748,'g',0,'2012-02-19'),(2519,'g',0,'2012-02-19'),(3322,'g',0,'2012-03-07'),(3605,'g',0,'2012-02-20'),(3580,'g',0,'2012-03-06'),(3583,'g',0,'2012-03-06'),(3451,'g',0,'2012-03-07'),(3589,'g',0,'2012-02-20'),(3463,'g',0,'2012-03-07'),(3376,'g',0,'2012-01-10'),(3296,'g',0,'2012-03-07'),(2543,'g',0,'2012-01-10'),(2541,'g',0,'2012-01-10'),(2531,'g',0,'2012-01-10'),(2523,'g',0,'2012-01-10'),(2528,'g',0,'2012-01-10'),(2529,'g',0,'2012-01-10'),(3774,'g',0,'2012-01-10'),(3682,'g',0,'2012-01-10'),(3008,'g',0,'2012-01-10'),(3015,'g',0,'2012-01-10'),(2995,'g',0,'2012-01-10'),(3029,'g',0,'2012-01-10'),(2969,'g',0,'2012-01-10'),(2985,'g',0,'2012-01-10'),(2987,'g',0,'2012-01-10'),(3003,'g',0,'2012-01-10'),(3004,'g',0,'2012-01-10'),(2973,'g',0,'2012-01-10'),(2913,'g',0,'2012-01-10'),(2921,'g',0,'2012-01-10'),(2925,'g',0,'2012-01-10'),(2936,'g',0,'2012-01-10'),(2937,'g',0,'2012-01-10'),(2949,'g',0,'2012-01-10'),(3765,'g',0,'2012-01-10'),(2965,'g',0,'2012-01-10'),(2962,'g',0,'2012-01-10'),(3624,'g',0,'2012-01-10'),(3218,'g',0,'2012-01-10'),(3215,'g',0,'2012-01-10'),(3214,'g',0,'2012-01-10'),(3239,'g',0,'2012-01-10'),(3238,'g',0,'2012-01-10'),(3247,'g',0,'2012-01-10'),(3227,'g',0,'2012-01-10'),(3234,'g',0,'2012-01-10'),(3284,'g',0,'2012-01-10'),(3282,'g',0,'2012-01-10'),(2696,'g',0,'2012-01-10'),(2911,'g',0,'2012-01-10'),(2693,'g',0,'2012-01-10'),(2896,'g',0,'2012-01-10'),(2897,'g',0,'2012-01-10'),(2890,'g',0,'2012-01-10'),(2750,'g',0,'2012-01-10'),(2699,'g',0,'2012-01-10'),(2666,'g',0,'2012-01-10'),(2906,'g',0,'2012-01-10'),(3714,'g',0,'2012-01-10'),(3772,'g',0,'2012-02-20'),(3771,'g',0,'2012-01-10'),(3721,'g',0,'2012-01-10'),(3736,'g',0,'2012-01-10'),(3747,'g',0,'2012-01-10'),(3745,'g',0,'2012-01-10'),(3750,'g',0,'2012-01-10'),(3751,'g',0,'2012-01-10'),(3175,'g',0,'2012-01-10'),(3197,'g',0,'2012-01-10'),(3140,'g',0,'2012-01-10'),(3160,'g',0,'2012-01-10'),(3212,'g',0,'2012-01-10'),(3211,'g',0,'2012-01-10'),(3155,'g',0,'2012-01-10'),(3213,'g',0,'2012-01-10'),(3159,'g',0,'2012-01-10'),(3157,'g',0,'2012-01-10'),(3082,'g',0,'2012-01-10'),(3081,'g',0,'2012-01-10'),(3079,'g',0,'2012-01-10'),(3051,'g',0,'2012-01-10'),(3050,'g',0,'2012-01-10'),(3044,'g',0,'2012-01-10'),(3037,'g',0,'2012-01-10'),(3033,'g',0,'2012-01-10'),(3134,'g',0,'2012-01-10'),(3090,'g',0,'2012-01-10'),(2663,'g',0,'2012-01-10'),(2623,'g',0,'2012-01-10'),(2622,'g',0,'2012-01-10'),(2626,'g',0,'2012-01-10'),(2629,'g',0,'2012-01-10'),(2580,'g',0,'2012-01-10'),(2613,'g',0,'2012-01-10'),(2597,'g',0,'2012-01-10'),(2605,'g',0,'2012-01-10'),(2564,'g',0,'2012-01-10'),(3561,'g',0,'2012-01-10'),(3409,'g',0,'2012-01-10'),(3466,'g',0,'2012-01-10'),(3385,'g',0,'2012-02-20'),(3523,'g',0,'2012-01-10'),(3524,'g',0,'2012-01-10'),(3525,'g',0,'2012-01-10'),(3526,'g',0,'2012-01-10'),(3522,'g',0,'2012-01-10'),(3521,'g',0,'2012-01-10'),(3520,'g',0,'2012-01-10'),(3518,'g',0,'2012-01-10'),(3519,'g',0,'2012-01-10'),(3516,'g',0,'2012-02-20'),(3517,'g',0,'2012-02-20'),(3514,'g',0,'2012-02-20'),(3515,'g',0,'2012-02-20'),(3497,'g',0,'2012-01-10'),(2758,'g',0,'2012-01-10'),(3703,'g',0,'2012-01-10'),(3759,'g',0,'2012-01-10'),(2522,'g',0,'2012-01-10'),(2677,'g',0,'2012-01-10'),(2569,'g',0,'2012-01-10'),(3766,'g',0,'2012-01-10'),(3740,'g',0,'2012-01-11'),(3741,'g',0,'2012-01-11'),(3737,'g',0,'2012-01-11'),(3739,'g',0,'2012-01-11'),(3738,'g',0,'2012-01-11'),(3734,'g',0,'2012-01-11'),(3304,'g',0,'2012-01-11'),(3392,'g',0,'2012-01-11'),(3314,'g',0,'2012-01-11'),(3302,'g',0,'2012-01-11'),(3383,'g',0,'2012-01-11'),(3335,'g',0,'2012-01-11'),(3334,'g',0,'2012-01-11'),(3333,'g',0,'2012-01-11'),(3402,'g',0,'2012-01-11'),(3404,'g',0,'2012-01-11'),(3201,'g',0,'2012-01-11'),(3203,'g',0,'2012-01-11'),(3202,'g',0,'2012-01-11'),(3174,'g',0,'2012-01-11'),(3171,'g',0,'2012-01-11'),(3172,'g',0,'2012-01-11'),(3166,'g',0,'2012-01-11'),(3169,'g',0,'2012-01-11'),(3168,'g',0,'2012-01-11'),(3167,'g',0,'2012-01-11'),(2984,'g',0,'2012-01-11'),(2988,'g',0,'2012-01-11'),(2976,'g',0,'2012-01-11'),(2940,'g',0,'2012-01-11'),(2941,'g',0,'2012-01-11'),(2944,'g',0,'2012-01-11'),(2945,'g',0,'2012-01-11'),(2950,'g',0,'2012-01-11'),(3007,'g',0,'2012-01-11'),(3014,'g',0,'2012-01-11'),(3224,'g',0,'2012-01-11'),(3205,'g',0,'2012-01-11'),(3204,'g',0,'2012-01-11'),(3207,'g',0,'2012-01-11'),(3209,'g',0,'2012-01-11'),(3244,'g',0,'2012-01-11'),(3250,'g',0,'2012-01-11'),(3253,'g',0,'2012-01-11'),(3251,'g',0,'2012-01-11'),(3254,'g',0,'2012-01-11'),(3257,'g',0,'2012-01-11'),(3258,'g',0,'2012-01-11'),(3255,'g',0,'2012-01-11'),(3256,'g',0,'2012-01-11'),(3259,'g',0,'2012-01-11'),(3262,'g',0,'2012-01-11'),(3263,'g',0,'2012-01-11'),(3260,'g',0,'2012-01-11'),(3261,'g',0,'2012-01-11'),(3265,'g',0,'2012-01-11'),(3264,'g',0,'2012-01-11'),(3266,'g',0,'2012-01-11'),(3272,'g',0,'2012-01-11'),(3277,'g',0,'2012-01-11'),(3276,'g',0,'2012-01-11'),(3275,'g',0,'2012-01-11'),(3274,'g',0,'2012-01-11'),(3273,'g',0,'2012-01-11'),(3301,'g',0,'2012-01-11'),(3733,'g',0,'2012-01-11'),(2939,'g',0,'2012-01-11'),(2934,'g',0,'2012-01-11'),(2608,'g',0,'2012-01-11'),(2588,'g',0,'2012-01-11'),(2919,'g',0,'2012-01-11'),(2518,'g',0,'2012-01-11'),(2725,'g',0,'2012-01-11'),(2926,'g',0,'2012-01-11'),(3686,'g',0,'2012-01-11'),(3127,'g',0,'2012-01-11'),(3041,'g',0,'2012-01-11'),(3151,'g',0,'2012-01-11'),(3093,'g',0,'2012-01-11'),(3625,'g',0,'2012-01-11'),(3073,'g',0,'2012-01-11'),(3077,'g',0,'2012-01-11'),(3110,'g',0,'2012-01-11'),(3055,'g',0,'2012-01-11'),(3122,'g',0,'2012-01-11'),(2653,'g',0,'2012-01-11'),(2652,'g',0,'2012-01-11'),(2650,'g',0,'2012-01-11'),(2658,'g',0,'2012-01-11'),(2659,'g',0,'2012-01-11'),(2654,'g',0,'2012-01-11'),(3690,'g',0,'2012-01-12'),(3124,'g',0,'2012-01-20'),(3825,'g',0,'2012-02-02'),(3113,'g',0,'2012-02-15'),(3964,'g',0,'2012-02-19'),(3873,'g',0,'2012-02-19'),(3908,'g',0,'2012-02-19'),(2910,'g',0,'2012-02-19'),(2908,'g',0,'2012-02-19'),(3942,'g',0,'2012-02-19'),(3935,'g',0,'2012-02-19'),(2914,'g',0,'2012-02-19'),(3052,'g',0,'2012-02-20'),(3973,'g',0,'2012-02-20'),(3970,'g',0,'2012-02-20'),(3951,'g',0,'2012-02-20'),(3895,'g',0,'2012-02-20'),(3827,'g',0,'2012-02-20'),(3936,'g',0,'2012-02-20'),(3828,'g',0,'2012-02-20'),(3824,'g',0,'2012-02-20'),(3826,'g',0,'2012-02-20'),(4034,'g',0,'2012-03-06'),(3054,'g',0,'2012-03-06'),(2997,'g',0,'2012-03-06'),(3903,'g',0,'2012-03-06'),(4031,'g',0,'2012-03-06'),(2967,'g',0,'2012-03-07'),(2968,'g',0,'2012-03-07'),(2955,'g',0,'2012-03-07'),(2904,'g',0,'2012-03-07'),(2636,'g',0,'2012-03-07'),(3960,'g',0,'2012-03-07'),(2924,'g',0,'2012-03-07'),(2621,'g',0,'2012-03-07'),(3954,'g',0,'2012-03-07'),(3999,'g',0,'2012-03-07'),(3991,'g',0,'2012-03-07'),(2989,'g',0,'2012-03-07'),(2992,'g',0,'2012-03-07'),(4026,'g',0,'2012-03-07'),(3083,'g',0,'2012-03-07'),(2975,'g',0,'2012-03-07'),(4000,'g',0,'2012-03-07'),(3031,'g',0,'2012-03-07'),(3135,'g',0,'2012-03-07'),(3377,'g',0,'2012-03-07'),(3280,'g',0,'2012-03-07'),(3249,'g',0,'2012-03-07'),(3236,'g',0,'2012-03-07'),(3345,'g',0,'2012-03-07'),(3344,'g',0,'2012-03-07'),(3208,'g',0,'2012-03-07'),(3295,'g',0,'2012-03-07'),(3162,'g',0,'2012-03-07'),(4017,'g',0,'2012-03-07'),(3495,'g',0,'2012-03-07'),(3493,'g',0,'2012-03-07'),(3419,'g',0,'2012-03-07'),(3398,'g',0,'2012-03-07'),(3587,'g',0,'2012-03-07'),(3449,'g',0,'2012-03-07'),(3979,'g',0,'2012-03-07'),(3043,'g',0,'2012-03-07'),(3144,'g',0,'2012-03-07'),(3128,'g',0,'2012-03-07'),(3024,'g',0,'2012-03-07'),(3021,'g',0,'2012-03-07'),(3626,'g',0,'2012-03-07'),(3627,'g',0,'2012-03-07'),(3988,'g',0,'2012-03-07'),(3125,'g',0,'2012-03-07'),(3058,'g',0,'2012-03-07');

--
-- Table structure for table `idx_paid_listing`
--

CREATE TABLE `idx_paid_listing` (
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `premium` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sponsored` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expire` datetime DEFAULT NULL,
  `paid` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_paid_listing`
--


--
-- Table structure for table `idx_payment_gateway`
--

CREATE TABLE `idx_payment_gateway` (
  `payment_gateway_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enable` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setting` text COLLATE utf8_unicode_ci,
  `invoice_html` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`payment_gateway_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_payment_gateway`
--

INSERT INTO `idx_payment_gateway` VALUES (1,'paypal','1','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n	<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.paypal.com/images/x-click-but02.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>\r\n'),(2,'2co','0','a:6:{s:6:\"co_sid\";s:5:\"84932\";s:9:\"co_secret\";s:5:\"tango\";s:12:\"co_recurring\";s:1:\"0\";s:9:\"co_prod_1\";s:6:\"100.00\";s:9:\"co_prod_2\";s:6:\"250.00\";s:9:\"co_prod_3\";s:6:\"400.00\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=2co\'><img src=\'http://www.2checkout.com/images/overview/btns/25.jpg\' alt=\'Pay Now with 2checkout...\' border=\'0\' /></a> \r\n</p>'),(3,'authorizenet','0','a:2:{s:21:\"authorizenet_login_id\";s:0:\"\";s:21:\"authorizenet_tran_key\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=authorizenet\'><img src=\'http://www.authorize.net/upload/images/Images/Header/authorizenet_logo.gif\' alt=\'Pay Now with Authorize.Net...\' width=\'99\' height=\'39\' style=\'{border : 1px solid #c0c0c0;}\' /></a>\r\n</p>'),(4,'egold','0','a:2:{s:19:\"egold_payee_account\";s:0:\"\";s:16:\"egold_payee_name\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=egold\'>\r\n<img src=\'http://www.e-gold.com/gif/paywith.gif\' border=\'0\' alt=\'Pay Now with e-gold...\' />\r\n</a>\r\n</p>'),(5,'moneybookers','0','a:1:{s:18:\"moneybookers_email\";s:0:\"\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'http://www.moneybookers.com/images/banners/88_en_mb.gif\' border=\'0\' alt=\'Make payments with Moneybookers - it is fast, free and secure!\' /></a> \r\n</p>'),(6,'paypal-subscriptions','0','a:2:{s:13:\"payment_email\";s:0:\"\";s:21:\"enable_paypal_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=paypal\'><img src=\'https://www.paypal.com/en_US/i/btn/x-click-but20.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(7,'alertpay','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p> \r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/pay_now_3.gif\' border=\'0\' alt=\'Make payments with PayPal - it is fast, free and secure!\' /></a> \r\n</p>'),(8,'alertpay-subcriptions','0','a:2:{s:14:\"alertpay_email\";s:0:\"\";s:23:\"enable_alertpay_sandbox\";s:1:\"0\";}','<p>\r\n<a href=\'paynow.php?id={$invoice_id}&m=alertpay-subcriptions\'>\r\n<img src=\'https://www.alertpay.com/Images/BuyNow/subscribe_now_15.gif\' border=\'0\' alt=\'Make payments with Alert Pay - it is fast, free and secure!\' /></a> \r\n</p>');

--
-- Table structure for table `idx_payment_history`
--

CREATE TABLE `idx_payment_history` (
  `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8_unicode_ci,
  `amount` double DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `invoice_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_payment_history`
--


--
-- Table structure for table `idx_pl_sociable`
--

CREATE TABLE `idx_pl_sociable` (
  `sb_id` int(11) NOT NULL AUTO_INCREMENT,
  `sb_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sb_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sb_icon` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sb_enable` char(1) CHARACTER SET utf8 DEFAULT '0',
  PRIMARY KEY (`sb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_sociable`
--

INSERT INTO `idx_pl_sociable` VALUES (1,'BarraPunto','http://barrapunto.com/submit.pl?subj=TITLE&amp;story=PERMALINK','barrapunto.png','0'),(2,'Bitacoras.com','http://bitacoras.com/anotaciones/PERMALINK','bitacoras.png','0'),(3,'BlinkList','http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=PERMALINK&amp;Title=TITLE','blinklist.png','0'),(4,'blogmarks','http://blogmarks.net/my/new.php?mini=1&amp;simple=1&amp;url=PERMALINK&amp;title=TITLE','blogmarks.png','0'),(5,'Blogosphere News','http://www.blogospherenews.com/submit.php?url=PERMALINK&amp;title=TITLE','blogospherenews.png','0'),(6,'blogtercimlap','http://cimlap.blogter.hu/index.php?action=suggest_link&amp;title=TITLE&amp;url=PERMALINK','blogter.png','0'),(7,'Faves','http://faves.com/Authoring.aspx?u=PERMALINK&amp;title=TITLE','bluedot.png','0'),(8,'connotea','http://www.connotea.org/addpopup?continue=confirm&amp;uri=PERMALINK&amp;title=TITLE&amp;description=EXCERPT','connotea.png','0'),(9,'Current','http://current.com/clipper.htm?url=PERMALINK&amp;title=TITLE','current.png','0'),(10,'del.icio.us','http://delicious.com/post?url=PERMALINK&amp;title=TITLE&amp;notes=EXCERPT','delicious.png','0'),(11,'Digg','http://digg.com/submit?phase=2&amp;url=PERMALINK&amp;title=TITLE&amp;bodytext=EXCERPT','digg.png','1'),(12,'Diigo','http://www.diigo.com/post?url=PERMALINK&amp;title=TITLE','diigo.png','0'),(13,'DotNetKicks','http://www.dotnetkicks.com/kick/?url=PERMALINK&amp;title=TITLE','dotnetkicks.png','0'),(14,'DZone','http://www.dzone.com/links/add.html?url=PERMALINK&amp;title=TITLE','dzone.png','0'),(15,'eKudos','http://www.ekudos.nl/artikel/nieuw?url=PERMALINK&amp;title=TITLE&amp;desc=EXCERPT','ekudos.png','0'),(16,'email','mailto:?subject=TITLE&amp;body=PERMALINK','email_link.png','0'),(17,'Facebook','http://www.facebook.com/share.php?u=PERMALINK&amp;t=TITLE','facebook.png','1'),(18,'Fark','http://cgi.fark.com/cgi/fark/farkit.pl?h=TITLE&amp;u=PERMALINK','fark.png','0'),(19,'Fleck','http://beta3.fleck.com/bookmarklet.php?url=PERMALINK&amp;title=TITLE','fleck.png','0'),(20,'FriendFeed','http://www.friendfeed.com/share?title=TITLE&amp;link=PERMALINK','friendfeed.png','0'),(21,'FSDaily','http://www.fsdaily.com/submit?url=PERMALINK&amp;title=TITLE','fsdaily.png','0'),(22,'Global Grind','http://globalgrind.com/submission/submit.aspx?url=PERMALINK&amp;type=Article&amp;title=TITLE','globalgrind.png','0'),(23,'Google','http://www.google.com/bookmarks/mark?op=edit&amp;bkmk=PERMALINK&amp;title=TITLE&amp;annotation=EXCERPT','googlebookmark.png','0'),(24,'Gwar','http://www.gwar.pl/DodajGwar.html?u=PERMALINK','gwar.png','0'),(25,'HackerNews','http://news.ycombinator.com/submitlink?u=PERMALINK&amp;t=TITLE','hackernews.png','0'),(26,'Haohao','http://www.haohaoreport.com/submit.php?url=PERMALINK&amp;title=TITLE','haohao.png','0'),(27,'HealthRanker','http://healthranker.com/submit.php?url=PERMALINK&amp;title=TITLE','healthranker.png','0'),(28,'HelloTxt','http://hellotxt.com/?status=TITLE+PERMALINK','hellotxt.png','0'),(29,'Hemidemi','http://www.hemidemi.com/user_bookmark/new?title=TITLE&amp;url=PERMALINK','hemidemi.png','0'),(30,'Hyves','http://www.hyves.nl/profilemanage/add/tips/?name=TITLE&amp;text=EXCERPT+PERMALINK&amp;rating=5','hyves.png','0'),(31,'Identi.ca','http://identi.ca/notice/new?status_textarea=PERMALINK','identica.png','0'),(32,'IndianPad','http://www.indianpad.com/submit.php?url=PERMALINK','indianpad.png','0'),(33,'Internetmedia','http://internetmedia.hu/submit.php?url=PERMALINK','im.png','0'),(34,'Kirtsy','http://www.kirtsy.com/submit.php?url=PERMALINK&amp;title=TITLE','kirtsy.png','0'),(35,'laaik.it','http://laaik.it/NewStoryCompact.aspx?uri=PERMALINK&amp;headline=TITLE&amp;cat=5e082fcc-8a3b-47e2-acec-fdf64ff19d12','laaikit.png','0'),(36,'LinkArena','http://linkarena.com/bookmarks/addlink/?url=PERMALINK&amp;title=TITLE','linkarena.png','0'),(37,'LinkaGoGo','http://www.linkagogo.com/go/AddNoPopup?url=PERMALINK&amp;title=TITLE','linkagogo.png','0'),(38,'LinkedIn','http://www.linkedin.com/shareArticle?mini=true&amp;url=PERMALINK&amp;title=TITLE&amp;source=BLOGNAME&amp;summary=EXCERPT','linkedin.png','0'),(39,'Linkter','http://www.linkter.hu/index.php?action=suggest_link&amp;url=PERMALINK&amp;title=TITLE','linkter.png','0'),(40,'Live','https://favorites.live.com/quickadd.aspx?marklet=1&amp;url=PERMALINK&amp;title=TITLE','live.png','0'),(41,'Meneame','http://meneame.net/submit.php?url=PERMALINK','meneame.png','0'),(42,'MisterWong','http://www.mister-wong.com/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(43,'MisterWong.DE','http://www.mister-wong.de/addurl/?bm_url=PERMALINK&amp;bm_description=TITLE&amp;plugin=soc','misterwong.png','0'),(44,'Mixx','http://www.mixx.com/submit?page_url=PERMALINK&amp;title=TITLE','mixx.png','0'),(45,'muti','http://www.muti.co.za/submit?url=PERMALINK&amp;title=TITLE','muti.png','0'),(46,'MyShare','http://myshare.url.com.tw/index.php?func=newurl&amp;url=PERMALINK&amp;desc=TITLE','myshare.png','0'),(47,'MySpace','http://www.myspace.com/Modules/PostTo/Pages/?u=PERMALINK&amp;t=TITLE','myspace.png','0'),(48,'MSNReporter','http://reporter.nl.msn.com/?fn=contribute&amp;Title=TITLE&amp;URL=PERMALINK&amp;cat_id=6&amp;tag_id=31&amp;Remark=EXCERPT','msnreporter.png','0'),(49,'N4G','http://www.n4g.com/tips.aspx?url=PERMALINK&amp;title=TITLE','n4g.png','0'),(50,'Netvibes','http://www.netvibes.com/share?title=TITLE&amp;url=PERMALINK','netvibes.png','0'),(51,'NewsVine','http://www.newsvine.com/_tools/seed&amp;save?u=PERMALINK&amp;h=TITLE','newsvine.png','0'),(52,'Netvouz','http://www.netvouz.com/action/submitBookmark?url=PERMALINK&amp;title=TITLE&amp;popup=no','netvouz.png','0'),(53,'NuJIJ','http://nujij.nl/jij.lynkx?t=TITLE&amp;u=PERMALINK&amp;b=EXCERPT','nujij.png','0'),(54,'Ping.fm','http://ping.fm/ref/?link=PERMALINK&amp;title=TITLE&amp;body=EXCERPT','ping.png','0'),(55,'Posterous','http://posterous.com/share?linkto=PERMALINK&amp;title=TITLE&amp;selection=EXCERPT','posterous.png','0'),(56,'PDF','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','pdf.png','0'),(57,'Print','http://www.printfriendly.com/print?url=PERMALINK&amp;partner=sociable','printfriendly.png','0'),(58,'Propeller','http://www.propeller.com/submit/?url=PERMALINK','propeller.png','0'),(59,'Ratimarks','http://ratimarks.org/bookmarks.php/?action=add&address=PERMALINK&amp;title=TITLE','ratimarks.png','0'),(60,'Rec6','http://rec6.via6.com/link.php?url=PERMALINK&amp;=TITLE','rec6.png','0'),(61,'Reddit','http://reddit.com/submit?url=PERMALINK&amp;title=TITLE','reddit.png','0'),(62,'RSS','FEEDLINK','rss.png','0'),(63,'Scoopeo','http://www.scoopeo.com/scoop/new?newurl=PERMALINK&amp;title=TITLE','scoopeo.png','0'),(64,'Segnalo','http://segnalo.alice.it/post.html.php?url=PERMALINK&amp;title=TITLE','segnalo.png','0'),(65,'Simpy','http://www.simpy.com/simpy/LinkAdd.do?href=PERMALINK&amp;title=TITLE','simpy.png','0'),(66,'Slashdot','http://slashdot.org/bookmark.pl?title=TITLE&amp;url=PERMALINK','slashdot.png','0'),(67,'Socialogs','http://socialogs.com/add_story.php?story_url=PERMALINK&amp;story_title=TITLE','socialogs.png','0'),(68,'SphereIt','http://www.sphere.com/search?q=sphereit:PERMALINK&amp;title=TITLE','sphere.png','0'),(69,'Sphinn','http://sphinn.com/index.php?c=post&amp;m=submit&amp;link=PERMALINK','sphinn.png','0'),(70,'StumbleUpon','http://www.stumbleupon.com/submit?url=PERMALINK&amp;title=TITLE','stumbleupon.png','0'),(71,'Techmeme','http://twitter.com/home/?status=tip%20@Techmeme%20PERMALINK%20TITLE','techmeme.png','0'),(72,'Technorati','http://technorati.com/faves?add=PERMALINK','technorati.png','1'),(73,'ThisNext','http://www.thisnext.com/pick/new/submit/sociable/?url=PERMALINK&amp;name=TITLE','thisnext.png','0'),(74,'Tipd','http://tipd.com/submit.php?url=PERMALINK','tipd.png','0'),(75,'Tumblr','http://www.tumblr.com/share?v=3&amp;u=PERMALINK&amp;t=TITLE&amp;s=EXCERPT','tumblr.png','0'),(76,'Twitter','http://twitter.com/home?status=TITLE%20-%20PERMALINK','twitter.png','1'),(77,'Upnews','http://www.upnews.it/submit?url=PERMALINK&amp;title=TITLE','upnews.png','0'),(78,'Webnews.de','http://www.webnews.de/einstellen?url=PERMALINK&amp;title=TITLE','webnews.png','0'),(79,'Webride','http://webride.org/discuss/split.php?uri=PERMALINK&amp;title=TITLE','webride.png','0'),(80,'Wikio','http://www.wikio.com/vote?url=PERMALINK','wikio.png','0'),(81,'Wikio FR','http://www.wikio.fr/vote?url=PERMALINK','wikio.png','0'),(82,'Wikio IT','http://www.wikio.it/vote?url=PERMALINK','wikio.png','0'),(83,'Wists','http://wists.com/s.php?c=&amp;r=PERMALINK&amp;title=TITLE','wists.png','0'),(84,'Wykop','http://www.wykop.pl/dodaj?url=PERMALINK','wykop.png','0'),(85,'Xerpi','http://www.xerpi.com/block/add_link_from_extension?url=PERMALINK&amp;title=TITLE','xerpi.png','0'),(86,'YahooBuzz','http://buzz.yahoo.com/submit/?submitUrl=PERMALINK&amp;submitHeadline=TITLE&amp;submitSummary=EXCERPT&amp;submitCategory=science&amp;submitAssetType=text','yahoobuzz.png','0'),(87,'Yahoo! Bookmarks','http://bookmarks.yahoo.com/toolbar/savebm?u=PERMALINK&amp;t=TITLE&opener=bm&amp;ei=UTF-8&amp;d=EXCERPT','yahoomyweb.png','0'),(88,'Yigg','http://yigg.de/neu?exturl=PERMALINK&amp;exttitle=TITLE','yiggit.png','0'),(89,'Blogplay','http://blogplay.com','blogplay.png','0');

--
-- Table structure for table `idx_pl_twitter_account`
--

CREATE TABLE `idx_pl_twitter_account` (
  `ck` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cs` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `at` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ats` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `idx_pl_twitter_account`
--

INSERT INTO `idx_pl_twitter_account` VALUES ('G0mmEysTj6faSXo4t5tMXA','jTqwGZWl23dGm7ghVrOXfGVH6Dg4AZEObA4Dfry0yGg','https://api.twitter.com/oauth/authorize','https://api.twitter.com/oauth/access_token');

--
-- Table structure for table `idx_plugin`
--

CREATE TABLE `idx_plugin` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plugin_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8_unicode_ci DEFAULT NULL,
  `option_plugin` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_plugin`
--

INSERT INTO `idx_plugin` VALUES (1,'Sociable','sociable/sociable.php','1',NULL),(2,'AutoTweet','twitter_auto_tweet/twitter_auto_tweet.php','1',NULL);

--
-- Table structure for table `idx_review`
--

CREATE TABLE `idx_review` (
  `review_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `link_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `review` text COLLATE utf8_unicode_ci NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `subject` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_review`
--


--
-- Table structure for table `idx_searchlog`
--

CREATE TABLE `idx_searchlog` (
  `keyword` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `result` mediumint(9) unsigned DEFAULT NULL,
  `ip` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_searchlog`
--

INSERT INTO `idx_searchlog` VALUES ('automobiles','2011-06-10 00:18:44',0,'203.115.81.93'),('cutlery','2011-06-19 19:53:25',0,'125.115.36.211'),('music','2011-07-29 01:21:26',0,'203.92.47.195'),('search...clothes','2011-08-02 21:16:25',0,'121.29.132.113'),('clothes','2011-08-02 21:16:36',0,'121.29.132.113'),('gavinli80','2011-08-02 21:16:47',0,'121.29.132.113'),('3S Textile & Apparel Shijiazhuang Co., Ltd','2011-08-02 21:17:27',0,'121.29.132.113'),('corporate gifts','2011-08-07 09:37:33',0,'58.61.117.172'),('Paying for long term care','2011-10-28 03:45:07',0,'203.92.47.195'),('sinussurgerylosangeles.com','2011-12-02 16:35:15',4,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:05:15',4,'203.92.47.195'),('Hernialosangeles.com','2011-12-02 17:05:22',4,'203.92.47.195'),('netkidswear.com','2011-12-28 06:56:56',2,'203.92.47.195'),('o ring...','2012-01-03 02:40:47',0,'218.17.145.134'),('shawcoremodeling.com','2012-01-20 02:43:25',1,'203.92.47.195'),('GrowingStars','2012-02-15 02:28:48',1,'203.92.47.195');

--
-- Table structure for table `idx_set_hook_place`
--

CREATE TABLE `idx_set_hook_place` (
  `set_hook_place_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_hook_place` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`set_hook_place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_set_hook_place`
--


--
-- Table structure for table `idx_setting`
--

CREATE TABLE `idx_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setting_value` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_setting`
--

INSERT INTO `idx_setting` VALUES (4,'site_name','YELLOWPAGELISTINGZ.COM'),(5,'site_url','http://www.yellowpagelistingz.com'),(6,'email_address','steve-taiylor@gmail.com'),(7,'language_code','en_US'),(8,'theme_path','/home/sanket/public_html/themes/'),(9,'admin_template_path','/home/sanket/public_html/admin_tpl/'),(10,'plugin_path','/home/sanket/public_html/plugin/'),(12,'active_theme','facing'),(14,'spam_proof','1'),(15,'enable_user_validation','1'),(16,'allowed_file_extension','gif,jpg,png,pdf,zip,doc'),(17,'yahoo_appid',''),(18,'whosonline','600'),(19,'reciprocal_check','0'),(20,'urlcheck_limit','1'),(21,'pagerank_cache','30'),(22,'max_image_width','1024'),(23,'max_image_height','756'),(24,'max_file_size','500'),(25,'only_registered_can_add_link','1'),(26,'only_registered_can_add_review','1'),(27,'db_use_persistent','0'),(28,'paid_link_day_period','30,60,90,180'),(29,'paid_link_price_factor','1,1.5,2,3'),(30,'enable_html_tag','1'),(31,'allowed_html_tag','<b>,<strong>,<i>,<em>,<u>,<pre>,<blockquote>,<ol>,<ul>,<li>,<p>,<span>,<div>,<table>,<tr>,<td>'),(32,'enable_page_compression','0'),(33,'enable_category_ajax','1'),(34,'require_visit_category','0'),(35,'additional_category_price','0.5'),(36,'enable_rating_ajax','1'),(37,'service_nicecoder_avail','1'),(38,'enable_recaptcha','0'),(39,'recaptcha_publickey',''),(40,'recaptcha_privatekey',''),(41,'enable_bidding','0'),(42,'minimum_bid','5'),(43,'bid_increament','1'),(44,'charset','utf-8'),(45,'mailer','mail'),(46,'smtp_auth','0'),(47,'smtp_host',''),(48,'smtp_username',''),(49,'smtp_password',''),(50,'smtp_port','25'),(51,'emailbody_as_html','0'),(52,'indexu_version','2.4'),(53,'tos',''),(54,'submission_guidelines','');

--
-- Table structure for table `idx_tags`
--

CREATE TABLE `idx_tags` (
  `tag` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `total` int(11) NOT NULL DEFAULT '0',
  `tag_path` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`tag`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_tags`
--


--
-- Table structure for table `idx_unavailable`
--

CREATE TABLE `idx_unavailable` (
  `idx_unavailable` int(11) NOT NULL AUTO_INCREMENT,
  `link_id` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `who_is` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`idx_unavailable`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_unavailable`
--


--
-- Table structure for table `idx_unavailable_latest`
--

CREATE TABLE `idx_unavailable_latest` (
  `idx_link` int(11) DEFAULT NULL,
  `record_execution` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_unavailable_latest`
--


--
-- Table structure for table `idx_votes`
--

CREATE TABLE `idx_votes` (
  `link_id` mediumint(9) NOT NULL DEFAULT '0',
  `ip` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `idx_votes`
--



