--
-- Host: localhost    Database: goyallasercentre_DB
-- ------------------------------------------------------


--
-- Current Database: `goyallasercentre_DB`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `goyallasercentre_DB` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `goyallasercentre_DB`;

--
-- Table structure for table `about_webpulse_tbl`
--

CREATE TABLE `about_webpulse_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(255) DEFAULT NULL,
  `heading2` varchar(255) DEFAULT NULL,
  `short_desc` text,
  `description` longtext,
  `image` varchar(500) DEFAULT NULL,
  `video` varchar(500) DEFAULT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about_webpulse_tbl`
--


--
-- Table structure for table `attribute_tbl`
--

CREATE TABLE `attribute_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `brand_id` int(15) NOT NULL,
  `cat_id` int(15) NOT NULL,
  `price` int(15) NOT NULL,
  `validity` int(15) NOT NULL,
  `user_type` enum('Individuals','Organization') DEFAULT NULL,
  `updatetime` text,
  `required_doc` text NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `attribute_tbl`
--


--
-- Table structure for table `auto_emails`
--

CREATE TABLE `auto_emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_section` varchar(500) NOT NULL,
  `email_subject` varchar(500) NOT NULL,
  `email_content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auto_emails`
--


--
-- Table structure for table `award_banner_tbl`
--

CREATE TABLE `award_banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `personName` varchar(80) NOT NULL DEFAULT '',
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `bannerImage` varchar(500) NOT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `bannerorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `award_banner_tbl`
--


--
-- Table structure for table `banner_tbl`
--

CREATE TABLE `banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `personName` varchar(80) NOT NULL DEFAULT '',
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `bannerImage` varchar(500) NOT NULL,
  `mobilebanner` varchar(250) DEFAULT NULL,
  `bannerorder` int(11) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `tagline` varchar(250) DEFAULT NULL,
  `marqueeContent` varchar(255) DEFAULT NULL,
  `btn1` varchar(255) DEFAULT NULL,
  `bl1` varchar(255) DEFAULT NULL,
  `btn2` varchar(255) DEFAULT NULL,
  `bl2` varchar(255) DEFAULT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner_tbl`
--

INSERT INTO `banner_tbl` VALUES (1,'Piles Treatment','','2025-05-18','Y','Piles-Treatment.webp','Piles-Treatment-mobilebanner-111949.webp',NULL,'','','','','','','','Piles Treatment','Piles Treatment'),(2,'Piles Laser Treatment','','2025-05-18','Y','Piles-Laser-Treatment.webp','Piles-Laser-Treatment-mobilebanner-112017.webp',NULL,'','','','','','','','','');

--
-- Table structure for table `blog_heading_tbl`
--

CREATE TABLE `blog_heading_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(1000) DEFAULT NULL,
  `heading2` varchar(1000) DEFAULT NULL,
  `content` longtext,
  `image` varchar(500) DEFAULT NULL,
  `heading3` varchar(500) DEFAULT NULL,
  `content1` text,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_heading_tbl`
--


--
-- Table structure for table `blog_tbl`
--

CREATE TABLE `blog_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(1000) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) DEFAULT NULL,
  `catUrl` varchar(500) DEFAULT NULL,
  `blogDname` varchar(500) DEFAULT NULL,
  `blogDate` varchar(100) DEFAULT NULL,
  `blog_written` varchar(1000) DEFAULT NULL,
  `catDesc` text,
  `catDesc1` text,
  `pageshortDescription` text,
  `catImage` varchar(1000) DEFAULT NULL,
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `featureimage` varchar(1000) DEFAULT NULL,
  `banner1` varchar(250) DEFAULT NULL,
  `banner2` varchar(250) DEFAULT NULL,
  `banner3` varchar(250) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `heading1` varchar(1000) DEFAULT NULL,
  `content1` longtext,
  `ytvideo1` varchar(500) DEFAULT NULL,
  `image1` varchar(1000) DEFAULT NULL,
  `heading2` varchar(1000) DEFAULT NULL,
  `content2` longtext,
  `ytvideo2` varchar(500) DEFAULT NULL,
  `image2` varchar(1000) DEFAULT NULL,
  `heading3` varchar(1000) DEFAULT NULL,
  `content3` longtext,
  `ytvideo3` varchar(500) DEFAULT NULL,
  `image3` varchar(1000) DEFAULT NULL,
  `heading4` varchar(1000) DEFAULT NULL,
  `content4` longtext,
  `ytvideo4` varchar(500) DEFAULT NULL,
  `image4` varchar(1000) DEFAULT NULL,
  `heading5` varchar(1000) DEFAULT NULL,
  `content5` longtext,
  `ytvideo5` varchar(500) DEFAULT NULL,
  `image5` varchar(1000) DEFAULT NULL,
  `heading6` varchar(1000) DEFAULT NULL,
  `content6` longtext,
  `ytvideo6` varchar(500) DEFAULT NULL,
  `image6` varchar(1000) DEFAULT NULL,
  `heading7` varchar(1000) DEFAULT NULL,
  `content7` longtext,
  `ytvideo7` varchar(500) DEFAULT NULL,
  `image7` varchar(1000) DEFAULT NULL,
  `heading8` varchar(1000) DEFAULT NULL,
  `content8` longtext,
  `ytvideo8` varchar(500) DEFAULT NULL,
  `image8` varchar(1000) DEFAULT NULL,
  `heading9` varchar(1000) DEFAULT NULL,
  `content9` longtext,
  `ytvideo9` varchar(500) DEFAULT NULL,
  `image9` varchar(1000) DEFAULT NULL,
  `heading10` varchar(1000) DEFAULT NULL,
  `content10` longtext,
  `ytvideo10` varchar(500) DEFAULT NULL,
  `image10` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_tbl`
--

INSERT INTO `blog_tbl` VALUES (1,NULL,'how-to-find-the-right-piles-treatment-clinic-for-your-needs',0,'How To Find The Right Piles Treatment Clinic For Your Needs','how-to-find-the-right-piles-treatment-clinic-for-your-needs','How To Find The Right Piles Treatment Clinic For Your Needs?','','Admin','Piles treatment depends on finding the perfect clinic to provide effective care that lasts. You can recover your normal life through proper hemorrhoid treatment and support. Finding the Top Piles Treatment Clinic in Delhi helps you manage this condition better. This blog shows you how to pick a clinic that fits your healthcare requirements.','<p>Piles treatment depends on finding the perfect clinic to provide effective care that lasts. You can recover your normal life through proper hemorrhoid treatment and support. Finding the <strong>Top Piles Treatment Clinic in Delhi</strong> helps you manage this condition better. This blog shows you how to pick a clinic that fits your healthcare requirements.</p>\r\n\r\n<h2>Choose a Clinic That Focuses Only on Piles Treatment</h2>\r\n\r\n<p>Your search for a clinic should start with determining its specialty focus. Every medical facility provides different expertise when treating piles. Choose a medical center that employs doctors who specialize in treating haemorrhoids. Specialized clinics employ doctors who understand all available treatments, including simple and complex surgical procedures. Their specialized knowledge helps you get the highest quality medical treatment.</p>\r\n\r\n<h3>Look at All Available Treatment Choices</h3>\r\n\r\n<p>Because piles come in different levels of severity, you need a clinic that can treat them at any stage. You will get treatment that matches your unique medical situation when you receive personalized care. Patients with mild piles can benefit from non-invasive treatments that include food adjustments and lifestyle improvements plus medicine. When piles become serious, doctors perform minimal interventions or perform surgery.</p>\r\n\r\n<h3>Find doctors who have treated many cases of piles with empathy</h3>\r\n\r\n<p>Your treatment success depends on finding a doctor who knows how to treat piles. To find the best care at a clinic, you should verify that doctors have many years of practice diagnosing and treating piles. {companyName} offers the <strong>Best Piles Treatment Doctor in India</strong> who has treated numerous patients. He will thoroughly examine your condition and show you the best ways to address your issue.</p>\r\n\r\n<h3>Study What Patients Think About the Clinic</h3>\r\n\r\n<p>Reviews from past patients show you the best way to understand how well a clinic performs its work. You can learn about other patients&#39; clinic feedback to see how well they perform their services. When patients mention good results from treatments plus friendly staff and quality care they receive at the clinic, it builds trust. Check both positive and negative reviews to determine if the clinic has ongoing problems that may affect your choice.</p>\r\n\r\n<h3>Think About How Easy It Is to Reach the Clinic</h3>\r\n\r\n<p>Since hemorrhoid treatment needs repeated clinic visits, you should select a location that is easy to reach. The distance between your home and office and the clinic will make regular appointments harder to attend and slow down your treatment results. Choose a clinic that is easy to reach and offers flexible scheduling with good public transportation and parking options.</p>\r\n\r\n<h3>Select a Clinic that Creates a Relaxing Setting</h3>\r\n\r\n<p>Patients need a pleasant space to feel at ease when receiving medical care for their sensitive piles condition. Select a medical clinic that provides you with a relaxed experience both with its staff members and its physical setting. A quality clinic will offer a clean, professional space that helps you relax when you discuss your symptoms and receive medical care.</p>\r\n\r\n<p>Deciding on a qualified hemorrhoid treatment clinic helps you find relief from symptoms and achieve better health outcomes. Your decision will be more informed when you look at how specialized the clinic is and what treatments they offer, plus their doctor&#39;s experience and patient feedback. Contact a hemorrhoid treatment doctor today to explore your health condition and start your path to recovery. Your choice of clinic will determine how well you find relief from piles.</p>\r\n',NULL,'how-to-find-the-right-piles-treatment-clinic-for-your-needs67efa35bb6b87.jpg','N',1,'Y','blog of goyal laser centre1','How To Find The Right Piles Treatment Clinic For Your Needs?','How To Find The Right Piles Treatment Clinic For Your Needs?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-04 09:16:11','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),(2,NULL,'how-do-doctors-address-pain-and-discomfort-during-fissure-treatment',0,'How Do Doctors Address Pain And Discomfort During Fissure Treatment','how-do-doctors-address-pain-and-discomfort-during-fissure-treatment','How Do Doctors Address Pain And Discomfort During Fissure Treatment?','','Admin','Anal fissures create strong pain that makes basic daily tasks hard to perform. The thin tears on your anus develop from straining during bowel movements or from digestive problems like constipation and diarrhoea. You need medical help to treat your symptoms and make your fissure heal properly. What specific methods does the Best Doctor For Fissure Treatment in India use to assist patients in dealing with fissure pain? We will examine the medical approaches doctors use to help patients feel better and recover from their condition.','<p>Anal fissures create strong pain that makes basic daily tasks hard to perform. The thin tears on your anus develop from straining during bowel movements or from digestive problems like constipation and diarrhoea. You need medical help to treat your symptoms and make your fissure heal properly. What specific methods does the <strong>Best Doctor For Fissure Treatment in India</strong> use to assist patients in dealing with fissure pain? We will examine the medical approaches doctors use to help patients feel better and recover from their condition.</p>\r\n\r\n<h2>Doctors need to correctly identify the problem and create individual treatment plans</h2>\r\n\r\n<p>Doctors need to perform a complete evaluation to begin treating an anal fissure. A doctor who treats fissures will check the condition&#39;s severity to identify if it is short-term or long-term. The medical team uses this diagnosis to design a treatment plan that matches your needs to handle pain and promote healing right away. {companyName} offers <strong>Top Fissure Treatment in Delhi </strong>to help patients manage their pain and support their healing. Doctors use topical anaesthetics to block pain signals and make you more comfortable. Medicated creams with nitroglycerin and calcium channel blockers ease anal sphincter tension, which enhances blood flow to the fissure to heal it faster. The pain from anal fissures grows worse when you have hard stools and constipation. Doctors suggest eating more fibre and drinking more fluids to stop the fissure from getting worse. Eating fiber-rich foods such as fruits, vegetables and whole grains creates softer stools that help you use the bathroom more easily and decrease pressure on the fissure.</p>\r\n\r\n<h3>Using a sitz bath helps you feel better from your anal fissure.</h3>\r\n\r\n<p>Doctors usually recommend sitz baths as a basic and helpful way to reduce fissure pain. Warm water soaks for 10 to 15 minutes several times daily relax muscles and improve blood flow while easing the pain. This simple treatment method helps patients without surgery and lets other treatments work better. Doctors use small invasive procedures to treat chronic fissures that don&#39;t respond to regular methods. When conservative treatments fail to work or when the fissure becomes long-lasting, doctors use Botox injections and lateral internal sphincterotomy (LIS) procedures. The medicine Botox works by calming down the anal muscles, which eases the pain and lets the fissure repair itself. Through simple surgery, doctors can reduce the pressure on the fissure to give patients long-term pain relief. Doctors know that treatments affect both your body and mind. A professional doctor who treats fissures will guide you through the process while answering your questions and showing you how to reduce pain.</p>\r\n\r\n<p>Doctors treat fissure pain through medical methods while teaching patients about self-care and offering emotional support. Doctors use multiple methods, including topical medications, dietary adjustments and minimally invasive techniques, to support patients through their healing process and restore their normal life. Start your recovery journey by getting expert medical help now.</p>\r\n',NULL,'how-do-doctors-address-pain-and-discomfort-during-fissure-treatment67efa522da449.jpg','N',2,'Y','How Do Doctors Address Pain And Discomfort During Fissure Treatment?','How Do Doctors Address Pain And Discomfort During Fissure Treatment?','How Do Doctors Address Pain And Discomfort During Fissure Treatment?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-04 09:25:24','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),(3,NULL,'what-can-you-achieve-with-a-professional-chemical-peel-treatment',0,'What Can You Achieve With A Professional Chemical Peel Treatment','what-can-you-achieve-with-a-professional-chemical-peel-treatment','What Can You Achieve With A Professional Chemical Peel Treatment?','','Admin','Professional chemical peels work effectively to solve skin problems while making your face look younger. The Top Chemical Peel Treatment in Delhi helps both young and old clients get better skin by reducing aging signs and healing acne scars. This section explains how chemical peels work and why you need to work with a professional.','<p>Professional chemical peels work effectively to solve skin problems while making your face look younger. The <strong>Top Chemical Peel Treatment in Delhi</strong> helps both young and old clients get better skin by reducing aging signs and healing acne scars. This section explains how chemical peels work and why you need to work with a professional.</p>\r\n\r\n<h2>Brighten and Even Skin Tone</h2>\r\n\r\n<p>The skin shows dark patches and uneven pigmentation problems most often. A chemical peel removes damaged skin cells from the surface to produce a smoother and more balanced appearance. They work best to treat melasma and sun damage while lightening skin discolouration. The treatment helps smooth away tiny lines and wrinkles. Older skin develops visible lines and creases as it ages. The skin&#39;s natural collagen production increases and fine lines smooth out when you have chemical peels. The result? Your face looks younger and smoother because the wrinkles have decreased.</p>\r\n\r\n<h3>Treat Acne and Acne Scars</h3>\r\n\r\n<p>Chemical peels help acne patients by decreasing redness and clearing blocked pores while reducing their oil production. Deeper peels repair acne scars by smoothing out skin texture and making discolourations disappear. The method shows good results in making your skin appear better and softer. The treatment reduces pore size and smooths out skin texture Your skin surface appears dull when you have big pores and uneven texture. A chemical peel helps remove old skin cells and surface buildup to produce smoother and better-textured skin. As time passes, collagen growth helps smooth out skin texture and makes pores smaller.</p>\r\n\r\n<h3>Reverse Sun Damage</h3>\r\n\r\n<p>Chemical peels help treat sunspots and other sun damage while also preventing premature aging and restoring skin radiance. The treatment removes damaged skin layers to bring back natural radiance while reducing sun damage visibility.</p>\r\n\r\n<h3>Why Choose a Professional?</h3>\r\n\r\n<p>A doctor who specializes in chemical peel treatments delivers safer and better results than what you can achieve with over-the-counter products. To keep you safe and achieve the best results, {companyName} provides the <strong>Best Doctor Chemical Peel Treatment in India</strong>, which is tailored to your specific skin type and needs. They show you what to do before and after the treatment to achieve the best results. Specialist peels work at different levels to treat light or serious skin problems. Your doctor will select the best treatment option based on your desired results.</p>\r\n\r\n<p>A chemical peel does more than improve your skin condition because it creates both skin and self-esteem transformations. Consulting a professional helps you treat aging, acne scars, and sun damage safely and effectively. Through medical treatment, you can get better-looking skin that feels smoother and looks brighter as you gain more confidence in your appearance.</p>\r\n',NULL,'what-can-you-achieve-with-a-professional-chemical-peel-treatment67efa5d32e2c2.jpg','N',3,'Y','What Can You Achieve With A Professional Chemical Peel Treatment?','What Can You Achieve With A Professional Chemical Peel Treatment?','What Can You Achieve With A Professional Chemical Peel Treatment?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-04 09:26:43','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),(4,NULL,'how-do-hydrafacial-treatment-doctors-target-your-skins-unique-needs',0,'How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs','how-do-hydrafacial-treatment-doctors-target-your-skin-s-unique-needs','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?','','Admin','The HydraFacial treatment is a revolutionary skincare solution renowned for its ability to address a variety of skin concerns while leaving the complexion hydrated and glowing. The Best HydraFacial Treatment Doctor in India customize each session to address the unique needs of your skin, which is what makes it unique. Let’s explore how they do it.','<p>The HydraFacial treatment is a revolutionary skincare solution renowned for its ability to address a variety of skin concerns while leaving the complexion hydrated and glowing. The <strong>Best HydraFacial Treatment Doctor in India</strong> customize each session to address the unique needs of your skin, which is what makes it unique. Let&rsquo;s explore how they do it.</p>\r\n\r\n<h2>The HydraFacial Treatment Process</h2>\r\n\r\n<p>HydraFacial is a multi-step procedure that combines cleansing, exfoliation, extraction, hydration, and infusion of potent serums. Using patented technology, it removes impurities and nourishes the skin simultaneously. Its adaptability allows doctors to customize the treatment for individual skin concerns, making it a versatile option for all skin types. Every HydraFacial begins with an in-depth consultation and skin analysis. Doctors assess your skin type, texture, and concerns&mdash;whether it&rsquo;s acne, dullness, fine lines, or uneven tone. This assessment is crucial in creating a personalized treatment plan that ensures optimal results. The first step of the HydraFacial involves gentle exfoliation to remove dead skin cells and reveal a fresh layer of skin. Doctors adjust the exfoliation intensity based on your skin&#39;s sensitivity and needs. For those with sensitive skin, a mild approach ensures comfort, while deeper exfoliation may be applied for more resilient skin types.</p>\r\n\r\n<h3>Tailored Serum Infusion</h3>\r\n\r\n<p>One of the standout features of HydraFacial is the infusion of serums designed to address specific skin concerns. Doctors select serums based on your goals&mdash;hydration for dry skin, brightening agents for dullness, or acne-fighting ingredients for breakout-prone skin. This step delivers targeted nourishment and ensures your skin receives exactly what it needs. For more complex skin issues such as hyperpigmentation or deep wrinkles, HydraFacial doctors can incorporate booster treatments. These boosters are potent, highly concentrated formulas that amplify the results. The doctor at {companyName} can successfully treat even the most stubborn skin problems by adding boosters to the <strong>Top Hydra Facial Treatment in Delhi</strong>. The benefits of a HydraFacial extend beyond the clinic. Doctors provide tailored aftercare advice, recommending skincare products that complement the treatment and enhance its effects. This ensures long-lasting results and keeps your skin in top condition.</p>\r\n\r\n<p>A HydraFacial is more than just a facial; it&rsquo;s a personalized skincare experience. By understanding your skin&rsquo;s unique needs, Facial treatment doctors create a plan that delivers radiant, healthy skin tailored to you. With their expertise, you can achieve noticeable and lasting results that leave you glowing with confidence.</p>\r\n',NULL,'how-do-hydrafacial-treatment-doctors-target-your-skins-unique-needs67efa64444dd4.jpg','N',4,'Y','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-04 09:28:36','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');

--
-- Table structure for table `brand_tbl`
--

CREATE TABLE `brand_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `brandName` varchar(200) NOT NULL DEFAULT '',
  `brandImage` varchar(200) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `brandTitle` text NOT NULL,
  `brandKeyword` text NOT NULL,
  `brandDesc` text NOT NULL,
  `brandHeading` text NOT NULL,
  `brandDetail` text NOT NULL,
  `catID` int(11) NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brand_tbl`
--


--
-- Table structure for table `build_brand_tbl`
--

CREATE TABLE `build_brand_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content` longtext,
  `brand_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `build_brand_tbl`
--


--
-- Table structure for table `business_tbl`
--

CREATE TABLE `business_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `Business_Heading` varchar(500) DEFAULT NULL,
  `caption` longtext,
  `logo_image` varchar(800) NOT NULL,
  `heading_icon` longtext,
  `bn` varchar(100) NOT NULL,
  `bl` varchar(255) NOT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `client_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `business_tbl`
--


--
-- Table structure for table `case_heading_tbl`
--

CREATE TABLE `case_heading_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(255) DEFAULT NULL,
  `heading2` varchar(255) DEFAULT NULL,
  `heading3` varchar(255) DEFAULT NULL,
  `content_desc` text,
  `content_desc1` text,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `case_heading_tbl`
--


--
-- Table structure for table `casestudy_tbl`
--

CREATE TABLE `casestudy_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `usertype` varchar(100) DEFAULT NULL,
  `catName` varchar(255) DEFAULT NULL,
  `catIcon` varchar(200) DEFAULT NULL,
  `home_category` varchar(20) NOT NULL DEFAULT '0',
  `catDesc` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `catDesc1` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `catImage` varchar(500) DEFAULT NULL,
  `cat_home_image` varchar(500) DEFAULT NULL,
  `catBanner` varchar(500) DEFAULT NULL,
  `catVideo` varchar(250) DEFAULT NULL,
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `specification` text,
  `catalogImage` varchar(500) DEFAULT NULL,
  `displayName` varchar(500) DEFAULT NULL,
  `faq_icon` varchar(500) DEFAULT NULL,
  `catprice` int(11) NOT NULL,
  `heading3` varchar(60) DEFAULT NULL,
  `heading1` varchar(100) DEFAULT NULL,
  `heading2` varchar(100) DEFAULT NULL,
  `gst` int(11) NOT NULL,
  `mca` int(11) NOT NULL,
  `epf` int(11) NOT NULL,
  `iec` int(11) NOT NULL,
  `eticket` int(11) NOT NULL,
  `cp` int(11) NOT NULL,
  `ptr` int(11) NOT NULL,
  `cbe` int(11) NOT NULL,
  `etp` int(11) NOT NULL,
  `vb` int(11) NOT NULL,
  `dgft` int(11) NOT NULL,
  `iet` int(11) NOT NULL,
  `keyword1` varchar(50) DEFAULT NULL,
  `keyword2` varchar(50) DEFAULT NULL,
  `keyword3` varchar(50) DEFAULT NULL,
  `certificateUsed` text,
  `required_doc` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `casestudy_tbl`
--


--
-- Table structure for table `category_tbl`
--

CREATE TABLE `category_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` varchar(11) DEFAULT NULL,
  `catgurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `usertype` varchar(100) DEFAULT NULL,
  `catName` varchar(255) DEFAULT NULL,
  `catUrl` varchar(1000) DEFAULT NULL,
  `catOldUrl` varchar(1000) DEFAULT NULL,
  `catIcon` varchar(200) DEFAULT NULL,
  `header_icon_image` varchar(500) DEFAULT NULL,
  `home_category` varchar(20) NOT NULL DEFAULT '0',
  `homeOrder` int(11) DEFAULT NULL,
  `catDesc` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `catDesc1` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `catDesc2` longtext,
  `catDesc3` longtext,
  `catImage` varchar(500) DEFAULT NULL,
  `cat_home_image` varchar(500) DEFAULT NULL,
  `catBanner` varchar(500) DEFAULT NULL,
  `multi_image` text,
  `catVideo` varchar(250) DEFAULT NULL,
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `specification` text,
  `catalogImage` varchar(500) DEFAULT NULL,
  `displayName` varchar(500) DEFAULT NULL,
  `faq_icon` varchar(500) DEFAULT NULL,
  `catprice` int(11) NOT NULL,
  `heading3` text,
  `heading1` varchar(100) DEFAULT NULL,
  `heading2` varchar(100) DEFAULT NULL,
  `is_redirect` int(11) NOT NULL,
  `redirect_link` varchar(1000) DEFAULT NULL,
  `mca` int(11) NOT NULL,
  `keyword1` varchar(50) DEFAULT NULL,
  `keyword2` varchar(50) DEFAULT NULL,
  `keyword3` varchar(50) DEFAULT NULL,
  `certificateUsed` text,
  `required_doc` text NOT NULL,
  `header_menu` char(1) NOT NULL DEFAULT 'Y',
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `catHeading1` varchar(500) DEFAULT NULL,
  `catHeading2` varchar(500) DEFAULT NULL,
  `catHeading3` varchar(500) DEFAULT NULL,
  `catHeadingButton` varchar(50) DEFAULT NULL,
  `catHeadingLink` varchar(1000) DEFAULT NULL,
  `catHeadingImage` varchar(500) DEFAULT NULL,
  `catHeadingImageAlt` varchar(500) DEFAULT NULL,
  `catHeadingImageTitle` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_tbl`
--

INSERT INTO `category_tbl` VALUES (1,NULL,NULL,0,NULL,'Piles Treatment','piles-treatment','','','','0',NULL,'','<p>The term &quot;piles&quot; or &quot;hemorrhoids&quot; (in technical language, &quot;bawasir&quot;) stands for swelling and inflammation of blood vessels around the anal region. Freedom from piles, which affects approximately seventy-five percent of people at one time or another in their lives, can be plagued with a lot of discomfort, torment, and even bleeding. Surgery was a common mode of treatment for the piles in the earlier days; nowadays, advancements have developed a multitude of non-surgical treatments extremely useful in managing piles and providing relief from discomfort. The Goyal Piles Laser Centre, noted for its state-of-the-art techniques in treating hemorrhoids, is perhaps the foremost <strong>Piles Treatment Clinic in Delhi</strong>. Due to these advanced non-invasive methods, the center provides patients with relief from the painful, bleeding, and uncomfortable symptoms under the care of some of the best piles specialists in the area.</p>\r\n\r\n<h2>What Are The Unique Qualities Of A Piles Treatment Hospital in India?</h2>\r\n\r\n<p>Goel Piles Laser Centre houses modern diagnostic instruments, equipment, and advanced treatment facilities like laser therapy and minimally invasive procedures for faster recovery and less discomfort. For an effective and long-term solution without the hassles of traditional surgery, choosing the right <strong>Piles Treatment Hospital in India</strong> is of utmost importance. These hospitals are generally backed by specialized teams of experts who handle only anorectal conditions and thus work to draw out procedures individualized and tailor-made to meet the specific needs of their respective patients. With its growing reputation for excellence in medical care, patients from across India and abroad are already trusting the country&#39;s best hospitals to provide reliable yet affordable piles treatment.</p>\r\n\r\n<h3>What Are the Treatment Options for Piles (Hemorrhoids)</h3>\r\n\r\n<p>Changing some lifestyles and foods can help tremendously in the management of piles. Consuming fruit and vegetables rich in fiber, drinking a lot of water, will make the motions so much smoother, preventing constipation, which is one of the key causes of the development of piles. Overweight is another contributor to this problem. Weight loss through a combination of exercise, yoga, and other forms of physical activity will help in bringing down the severity as well as the frequency of hemorrhoids. Some of the common medications include topical creams and ointments and oral painkillers, which reduce swelling, inflammation, and burning in the anal area, thus giving much relief from symptoms.</p>\r\n','<p><strong>IRC (Infrared Coagulation)</strong>: Cutting-edge German technology makes this procedure one of the newest, non-invasive, and almost entirely painless methods of patient outpatient procedure transforming surgery globally for piles treatment IRC. This procedure is preferred for its convenience and safety and very short recuperation aside from the fact that it greatly enjoys massive usage by patients.</p>\r\n\r\n<p><strong>Laser Treatment</strong>: In cases where the disease has progressed to a much higher level, laser treatment (through a US FDA-approved diode laser) becomes the option of choice. This modern treatment is an alternative to traditional surgery with much less invasiveness, faster recovery, and better outcomes for patients.</p>\r\n','<p>A piles (hemorrhoids) treatment has made continuous development simpler and better in science and medical technology. One of the very latest techniques is <strong>Laser Treatment For Piles in India</strong>, and many patients have enthusiastically adopted it as their first choice. This treatment appears as a day-care surgery and has multiple advantages as compared to traditional surgical techniques, quick recovery and better comfort being a few examples of such advantages. This treatment is also minimally invasive; it does not cut or excise tissue with a scalpel and relies on a focused beam of light to treat an affected area with precision while preserving surrounding tissues. Very little pain is thus felt, and most patients may engage in their daily lives again in a day or two. Discharge on the same day is common. Among the benefits for the patient are the lack of cuts, wounds, stitches, and dressings.</p>\r\n','Piles-Treatment.jpg','Piles-Treatment6821b8cf8daa7.jpg','-banner59.jpg','piles-goyal-piles-56.jpg',NULL,'N',1,'Y','Piles Treatment Clinic in Delhi, Piles Treatment Hospital in India','Piles Treatment Clinic in Delhi, Piles Treatment Hospital in Delhi, Piles Treatment Clinic in India, Piles Treatment Hospital in India','Are you looking for Piles Treatment Clinic in Delhi ? Goyal Laser Centre offers Best Piles Treatment Hospital in India Over 30 Years of Experience Providing Piles Treatment at an affordable Price. Enquiry Now',NULL,NULL,'Piles Treatment',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Piles Treatment Clinic','','','','','',''),(2,NULL,NULL,0,NULL,'Cosmetology Services','cosmetology-services','','','','0',NULL,'At {companyName}, we committed to the enhancement of your natural beauty. We offer Top Cosmetology Treatment Services in Delhi that ensure every client is given personal, high-quality care. Our treatments include skin rejuvenation and advanced facial therapies, which promise to give a youthful look. We use the latest technology and techniques, thereby ensuring visible and long-lasting results, which we tailor according to your beauty needs.','<div class=\"cmTitle\">How Do Advanced Beauty Treatments Offer Faster Results Than Traditional Methods?</div>\r\n\r\n<p>At {companyName}, we committed to the enhancement of your natural beauty. We offer <strong>Top Cosmetology Treatment Services in Delhi</strong> that ensure every client is given personal, high-quality care. Our treatments include skin rejuvenation and advanced facial therapies, which promise to give a youthful look. We use the latest technology and techniques, thereby ensuring visible and long-lasting results, which we tailor according to your beauty needs.</p>\r\n\r\n<ul>\r\n	<li><strong>New Technology Innovations</strong>: Reap the fruit of the latest innovation in beauty care.</li>\r\n	<li><strong>Custom Solutions</strong>: Solutions targeted to address each individual&#39;s problems.</li>\r\n	<li><strong>Visible Effect</strong>: Enhance your beauty that is observable for everyone.</li>\r\n	<li><strong>Safe and Effective</strong>: It is safe professional care and it is efficient professional care.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">How Does a Beauty Professional Tailor Solutions to Your Unique Needs?</div>\r\n\r\n<h3>Best Cosmetology Doctor in Delhi</h3>\r\n\r\n<p>When cosmetic treatments are concerned, the right professional care becomes a matter of immense importance. We take pride in offering an experience with the <strong>Best Cosmetology Doctor in Delhi</strong>. Probably, there will be no one who can understand your needs more than us. We ensure that you have an amazing experience from consultation to the final result with our doctors, who have years of expertise along with a deep understanding of your procedure.</p>\r\n\r\n<ul>\r\n	<li><strong>Experienced Professionals</strong>: Trust the experts who understand your beauty goals.</li>\r\n	<li><strong>Comprehensive Consultations</strong>: Detailed assessments to create a personalized plan.</li>\r\n	<li><strong>Cutting-Edge Treatments</strong>: Procedures that offer the best results.</li>\r\n	<li><strong>Ongoing Support</strong>: Continuous care to ensure lasting outcomes.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">What Distinguishes Our Offerings from Competitors?</div>\r\n\r\n<h3>Best Cosmetologist in India</h3>\r\n\r\n<p>From permanent hair removal to revitalizing facials, our staff will make sure you receive the best possible care. We pride ourselves on making your beauty journey as smooth and rewarding as possible. {companyName} is known as the <strong>Best Cosmetologist in India</strong> because of our commitment to excellence in each treatment we provide. With a team of skilled professionals and advanced technologies, we provide you with the finest services that best fit your needs.</p>\r\n\r\n<ul>\r\n	<li><strong>Best Professionals</strong>: Work with some of the best professionals in the field.</li>\r\n	<li><strong>Advanced Equipment</strong>: We use the latest tools for perfect results.</li>\r\n	<li><strong>Comprehensive Treatments</strong>: A wide range of services to meet all your beauty needs.</li>\r\n	<li><strong>Patient-Focused Approach</strong>: We prioritize your comfort and satisfaction at every stage.</li>\r\n</ul>\r\n','','','Cosmetology-Services.jpg','','-banner36.jpg','',NULL,'N',2,'Y','Top Cosmetology Treatment Services in Delhi, Cosmetology Treatment Specialists in India','Top Cosmetology Treatment Services in Delhi, Cosmetology Treatment Specialists in Delhi, Top Cosmetology Treatment Services in India, Cosmetology Treatment Specialists in India','Are you looking for Top Cosmetology Treatment Services in Delhi ? Goyal Laser Centre offers Best Cosmetology Treatment Specialists in India Over 30 Years of Experience providing Top Cosmetology Treatment Services at an affordable Price. Enquiry Now',NULL,NULL,'Cosmetology Services',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Cosmetology Treatment Services','','','','','',''),(3,NULL,NULL,1,NULL,'Fissure Treatment','fissure-treatment','','Fissure-Treatment.jpg','','0',NULL,'Anal fissure, also known as fissure in ano, is a very painful small tear or cuts in the skin or during in the mucosal lining of the anal canal or just around the anus. It is a condition that describes a great deal of discomfort while passing stool and, at times, may bleed. The pain may be an agonizing sensation during defecation and very often tends to involve a sharp or burning sensation.','<p>Anal fissure, also known as fissure in ano, is a very painful small tear or cuts in the skin or during in the mucosal lining of the anal canal or just around the anus. It is a condition that describes a great deal of discomfort while passing stool and, at times, may bleed. The pain may be an agonizing sensation during defecation and very often tends to involve a sharp or burning sensation. Even within people of any age, these fissures mostly tend to affect people with chronic constipation or bowel problems. At Goyal Piles Laser Centre, we are equipped with advanced and effective treatments for <strong>Fissure Treatment in Delhi</strong>, aimed at relieving and healing.</p>\r\n\r\n<div class=\"cmTitle\">What do anal fissures tend to happen?</div>\r\n\r\n<p><strong>They are mainly due to an unhealthy diet leading to constipation and a sedentary lifestyle along with: </strong></p>\r\n\r\n<ul>\r\n	<li>Passing large, hard stools during bowel movements</li>\r\n	<li>Straining during bowel movements</li>\r\n	<li>Chronic &amp; severe constipation</li>\r\n	<li>Chronic diarrhea</li>\r\n	<li>Pregnancy</li>\r\n	<li>Anal intercourse, etc.</li>\r\n</ul>\r\n','<p>It is a small tear or cut injury to the skin surrounding the anus, which can present considerable discomfort. The patient usually complains of sharp intense pain during bowel movements. In addition to the pain, the patient may present complaints of a visible cut or tear near the anal passage. Another common presentation is blood-stained stools or blood on the toilet paper during bowel movements, which indicates that the fissure is bleeding. With Anal Fissure Treatment in India, you can get rid of these easily and safely.</p>\r\n\r\n<p><strong>Signs and symptoms of anal fissure:</strong></p>\r\n\r\n<ul>\r\n	<li>Pain while having a bowel movement</li>\r\n	<li>A visible cut or tear in skin surrounding anal passage</li>\r\n	<li>Stools stained with blood or blood present on the toilet tissue after having a bowel movement</li>\r\n	<li>Smaller lump (or small skin growth) at the site of the fissure</li>\r\n</ul>\r\n','<p>An anal fissure is usually diagnosed by a thorough examination by a doctor. The fissure is mostly visible in the anal region during the examination. However, a more thorough rectal examination is done for diagnosis. Here for examination, a lubricated anoscope is very carefully and slightly inserted into the anal canal so that discomfort or pain does not occur to the patient. This makes it possible for the examining doctor to see the area very well, excluding differential diagnoses such as polyps or ulcers or even cancer presenting with the symptoms. Thus to confirm the diagnosis of anal fissure, potentially serious conditions are not left out. If you are looking for the best Laser Treatment For Fissure in India, we have all the best facilities.</p>\r\n','Fissure-Treatment.jpg','Fissure-Treatment6821b8e3e2511.jpg','-banner39.jpg','',NULL,'N',1,'Y','Fissure Treatment in Delhi, Anal Fissure Treatment in India','Fissure Treatment in Delhi, Anal Fissure Treatment in Delhi, Top Fissure Treatment in Delhi, Best Anal Fissure Treatment in Delhi, Fissure Treatment in India, Anal Fissure Treatment in India, Top Fissure Treatment in India, Best Anal Fissure Treatment in India','Are you looking for Fissure Treatment in Delhi ? Goyal Laser Centre offers Best Anal Fissure Treatment in India Over 30 Years of Experience Providing Fissure Treatment at an affordable Price. Enquiry Now',NULL,NULL,'Fissure Treatment',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Fissure Treatment','','','','','',''),(4,NULL,NULL,1,NULL,'Anal Fistula Treatment','anal-fistula-treatment','fistula-treatment','Anal-Fistula-Treatment.jpg','','0',NULL,'An anal fistula is actually a tunnel or a passage that forms between the anal canal and the outer skin around the anus. Patients often complain of recurrent pus discharge and swelling around the anus. To treat this condition effectively, visit Goyal Piles Laser Centre, where you can get the best treatment with lasers for anal fistulas. With USFDA-approved laserized surgery, Fistula Treatment in Delhi has been made very much easier. Now a highly effective method, this painless procedure will give comfort through its advanced laser technology with a very smooth and speedy recovery.','<p>An anal fistula is actually a tunnel or a passage that forms between the anal canal and the outer skin around the anus. Patients often complain of recurrent pus discharge and swelling around the anus. To treat this condition effectively, visit Goyal Piles Laser Centre, where you can get the best treatment with lasers for anal fistulas. With USFDA-approved laserized surgery, <strong>Fistula Treatment in Delhi</strong> has been made very much easier. Now a highly effective method, this painless procedure will give comfort through its advanced laser technology with a very smooth and speedy recovery.</p>\r\n\r\n<p><strong>How Does It Occur?</strong></p>\r\n\r\n<p>Anal fistula usually occurs because the covering tissue lining the anal canal gets injured or infected in the surrounding area. Some possible causes are:</p>\r\n\r\n<ul>\r\n	<li>Constipation leading to injury in the anal tissues.</li>\r\n	<li>Infection in the crypt (cervices) glands lining the anal canal.</li>\r\n	<li>Crohn&#39;s disease, a disorder leading to long-lasting inflammation of the intestines.</li>\r\n</ul>\r\n','<p>In the beginning, the first sign of an anal fistula manifests with painful swelling or a lump close to the anus. After some days, this portion swells up and may burst, draining pus and relieving the individual for some time. But this relief is not long-lasting because the swelling tends to arise again in that same spot, usually accompanied by continuous or occasional discharges. Without medical treatment, the cycle of swelling, rupturing, and discharging continues leading to the occurrence of discomfort on a continuous basis and increased chances of an infection occurring. Timely intervention at a leading <strong>Anal Fistula Treatment Center in India</strong> like Goyal Piles Laser Centre can interrupt that ongoing cycle and ensure that healing is effective and lasting.</p>\r\n\r\n<p><strong>Anal Fistula Symptoms may include:</strong></p>\r\n\r\n<ul>\r\n	<li>Regular and intermittent discharges of mucus or pus.</li>\r\n	<li>Pain and swelling in the perianal region.</li>\r\n</ul>\r\n','<p>The anal fistula diagnosis usually starts with a very detailed physical examination of the anus and adjacent perianal area. The doctor will search for external openings, signs of infection, swelling, or discharge. A doctor might also gently palpate the area to feel for underlying tracts or abscesses. Accurate diagnosis is important for planning the correct management approach because many patients consider Goyal Piles Laser Centre for <strong>Fistula Treatment Without Surgery in India</strong>, where noninvasive and minimally invasive techniques can also promote effective recovery.</p>\r\n\r\n<p>To ensure an accurate and complete diagnosis, the physician may swear by some additional diagnostic tests, among which are the following:</p>\r\n\r\n<ul>\r\n	<li><strong>Anoscopy</strong>: A special instrument, the anoscope, is introduced into the rectum with great care to allow direct visualization of the anal canal and to look for associated abnormality.</li>\r\n	<li><strong>MRI Fistulogram</strong>: The test is used for positive diagnosis to confirm the presence of an anal fistula and map the course as well as extent of the fistula tract.</li>\r\n</ul>\r\n','Anal-Fistula-Treatment.jpg','Anal-Fistula-Treatment6821b8eb55011.jpg','-banner13.jpg','anal-fistula-goyal-piles-07.jpg',NULL,'N',2,'Y','Fistula Treatment in Delhi, Anal Fistula Treatment Center in India','Fistula Treatment in Delhi, Anal Fistula Treatment in Delhi, Top Fistula Treatment in Delhi, Best Anal Fistula Treatment in Delhi, Fistula Treatment in India, Anal Fistula Treatment in India, Top Fistula Treatment in India, Best Anal Fistula Treatment in India','Are you looking for Fistula Treatment in Delhi ? Goyal Laser Centre offers Best Anal Fistula Treatment in India Over 30 Years of Experience Providing Fistula Treatment at an affordable Price. Enquiry Now',NULL,NULL,'Anal Fistula Treatment',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Fistula Treatment','','','','','',''),(5,NULL,NULL,1,NULL,'Pilonidal Sinus Treatment','pilonidal-sinus-treatment','','Pilonidal-Sinus-Treatment.jpg','','0',NULL,'Pilonidal sinus would be those minor openings or holes in the skin that typically form at the upper part of the buttocks with the cleft. These holes may fill with pus and have hair inside. It is commonly found in hairy-bodied men and also in those who sit continuously. It becomes very painful and uncomfortable, associated with discharge at intervals that smell foul. ','<p>Pilonidal sinus would be those minor openings or holes in the skin that typically form at the upper part of the buttocks with the cleft. These holes may fill with pus and have hair inside. It is commonly found in hairy-bodied men and also in those who sit continuously. It becomes very painful and uncomfortable, associated with discharge at intervals that smell foul. Indeed, it is made easier at present with <strong>Pilonidal Sinus Treatment in Delhi </strong>by Goyal Piles Laser Centre, bringing the most effective and easy solution to patients.</p>\r\n\r\n<p><strong>Causes of Pilonidal Sinus: </strong></p>\r\n\r\n<ul>\r\n	<li>Hypertrophic hairs</li>\r\n	<li>Remaining for long in the seated position</li>\r\n	<li>Lack of sufficient hygiene</li>\r\n	<li>Use of tight clothing, which traps dirt and sweat</li>\r\n	<li>Hormonal imbalance</li>\r\n	<li>Punctured ingrown hair</li>\r\n</ul>\r\n','<p>The pilonidal sinus is one inconvenient condition that requires immediate attention if symptoms appear. Untreated symptoms of a pilonidal sinus would often lead to gradual worsening over time, hence early recognition provides the best opportunity for effective management. Hence, <strong>Laser Pilonidal Sinus Treatment Hospital in India</strong> is becoming the most sought-after option among patients because of the least invasive nature of the treatment and quick recovery time along with effective management of the condition.</p>\r\n\r\n<ul>\r\n	<li>Red, tender localized swelling, often with exquisite pain over the tailbone.</li>\r\n	<li>Pain aggravated on sitting.</li>\r\n	<li>A small dimple or quite a big swollen area in the gluteal cleft.</li>\r\n	<li>Recurrent purulent foul-smelling discharge from the sinus and/or blood discharge just above the cleft of the buttock.</li>\r\n	<li>Systemic symptoms like fever or malaise can accompany abscess formation.</li>\r\n</ul>\r\n','<p>The diagnosis of a pilonidal sinus usually starts with a physical examination of the affected area in which the doctor looks for signs of swelling, redness, or discharge adjacent to the coccyx. The examination would also take note of the presence of small openings or possibly cysts. MRI may also be recommended in some cases if the diagnosis is not straightforward or if there are concerns about the extent of the condition. An MRI provides detailed imaging of the area to assess the depth and spread of the sinus or any associated abscess. Anyone searching for Pilonidal Sinus Cure Without Surgery in India can consider non-surgical treatment based on the case severity from Goyal Piles Laser Centre. This method helps to manage symptoms well, reducing the need for invasive procedures.</p>\r\n','Pilonidal-Sinus-Treatment.jpg','Pilonidal-Sinus-Treatment6821b8f4d3987.jpg','-banner41.jpg','',NULL,'N',3,'Y','Pilonidal Sinus Treatment in Delhi, Laser Pilonidal Sinus Treatment Hospital in India','Pilonidal Sinus Treatment in Delhi, Laser Pilonidal Sinus Treatment Hospital in Delhi, Pilonidal Sinus Treatment in India, Laser Pilonidal Sinus Treatment Hospital in India','Are you looking for Pilonidal Sinus Treatment in Delhi ? Goyal Laser Centre offers Best Laser Pilonidal Sinus Treatment Hospital in India Over 30 Years of Experience Providing Pilonidal Sinus Treatment at an affordable Price. Enquiry Now',NULL,NULL,'Pilonidal Sinus Treatment',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Pilonidal Sinus Treatment','','','','','',''),(6,NULL,NULL,2,NULL,'Laser Hair Removal','laser-hair-removal','laser-hair-removal-services','','','0',NULL,'{companyName} provides you with reduced recovery time, increased confidence, and smoother skin. We proudly boast the Best Laser Hair Removal Treatment in Delhi for our patients to ensure them with the best of care. Permanent reduction of unwanted hair through this effective and long-lasting treatment has brought a sense of comfort to people in getting rid of unwanted hair from their bodies.','<div class=\"cmTitle\">How does laser hair removal compare to traditional waxing and shaving techniques?</div>\r\n\r\n<p>{companyName} provides you with reduced recovery time, increased confidence, and smoother skin. We proudly boast the <strong>Best Laser Hair Removal Treatment in Delhi</strong> for our patients to ensure them with the best of care. Permanent reduction of unwanted hair through this effective and long-lasting treatment has brought a sense of comfort to people in getting rid of unwanted hair from their bodies.</p>\r\n\r\n<ul>\r\n	<li><strong>Long-Term Effects</strong>: Hair growth decreases drastically after each treatment.</li>\r\n	<li><strong>Less Painful</strong>: This is less painful than the old techniques.</li>\r\n	<li><strong>Short and Effective</strong>: Most treatments take a short time depending on the area to be treated.</li>\r\n	<li><strong>All Skin Types are Safe</strong>: With modern technology, it can be applied to most skin tones.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">How Do You Distinguish Between a Generalist and a Specialist in Healthcare?</div>\r\n\r\n<h3>Laser Hair Removal Doctor in Delhi</h3>\r\n\r\n<p>The right professional should be chosen in order to get maximum results from laser hair removal. We ensure access to one of the best <strong>Laser Hair Removal Doctor in Delhi</strong> who are trained and experienced with these treatments. Our doctors can ensure that personalized care is given to every patient according to their needs because of their professionalism. They determine your skin type and hair color very carefully to customize the procedure for a better outcome.</p>\r\n\r\n<ul>\r\n	<li><strong>Personalized Consultation</strong>: The doctor assesses your specific needs and goals.</li>\r\n	<li><strong>Expert Techniques</strong>: Treatments are performed with precision and accuracy.</li>\r\n	<li><strong>Comprehensive Aftercare</strong>: You&rsquo;ll receive guidance on how to care for your skin post-treatment.</li>\r\n	<li><strong>Commitment to Comfort</strong>: The doctor prioritizes minimizing discomfort during the procedure.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">What Sets Our Team of Experts Apart in Providing Exceptional Care?</div>\r\n\r\n<h3>Top Laser Hair Removal Clinics in India</h3>\r\n\r\n<p>We work hard to deliver high-quality results that satisfy you and help you feel good about your skin. {companyName} proudly stands among the <strong>Top Laser Hair Removal Clinics in India</strong>. The state-of-the-art technology with our expert team gives us an edge over others. We offer you full-body treatments or small-area hair removal; our clinic caters to your needs.</p>\r\n\r\n<ul>\r\n	<li><strong>High Technology</strong>: We have the latest equipment to provide an accurate outcome.</li>\r\n	<li><strong>Trained Personnel</strong>: Our personnel are well trained for the safe delivery of treatments.</li>\r\n	<li><strong>Relaxing Ambiance</strong>: We strive to create a relaxing environment for our patients.</li>\r\n	<li><strong>Long-term Result</strong>: Clients always walk out satisfied with the long-term outcome.</li>\r\n</ul>\r\n','','','Laser-Hair-Removal-Services.jpg','','','',NULL,'N',1,'Y','Best Laser Hair Removal Treatment in Delhi, Top Laser Hair Removal Clinics in India','Laser Hair Removal Treatment in Delhi, Laser Hair Removal Clinics in Delhi, Top Laser Hair Removal Treatment in Delhi, Best Laser Hair Removal Clinics in Delhi, Laser Hair Removal Treatment in India, Laser Hair Removal Clinics in India, Top Laser Hair Removal Treatment in India, Best Laser Hair Removal Clinics in India','Are you looking for Laser Hair Removal Treatment in Delhi ? Goyal Laser Centre offers Best Laser Hair Removal Clinics in India Over 30 Years of Experience Providing Laser Hair Removal Treatment at an affordable Price. Enquiry Now',NULL,NULL,'Laser Hair Removal',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Best Laser Hair Removal Treatment','','','','','',''),(7,NULL,NULL,2,NULL,'Chemical Peel Treatment','chemical-peel-treatment','','','','0',NULL,'At {companyName}, we are concerned with the health and beauty of your skin. The Top Chemical Peel Treatment in Delhi that we offer will help you get radiant and refreshed skin without harming your skin through invasive methods. This treatment deeply exfoliates dullness, uneven tone, and even the scars of mild acne. It provides a visibly smoother look and gives you fresh, glowing skin. Our chemical peels are prepared to rejuvenate your skin inside and out by carefully targeting imperfections.','<div class=\"cmTitle\">How Can One Simple Procedure Boost Your Skin&#39;s Health?</div>\r\n\r\n<p>At {companyName}, we are concerned with the health and beauty of your skin. The <strong>Top Chemical Peel Treatment in Delhi</strong> that we offer will help you get radiant and refreshed skin without harming your skin through invasive methods. This treatment deeply exfoliates dullness, uneven tone, and even the scars of mild acne. It provides a visibly smoother look and gives you fresh, glowing skin. Our chemical peels are prepared to rejuvenate your skin inside and out by carefully targeting imperfections.</p>\r\n\r\n<ul>\r\n	<li><strong>Exfoliation at Its Best</strong>: Removes dead skin cells for a youthful glow.</li>\r\n	<li><strong>Targeted Care</strong>: Addresses hyperpigmentation, fine lines, and acne marks effectively.</li>\r\n	<li><strong>Quick Recovery</strong>: A minimally invasive option with fast healing time.</li>\r\n	<li><strong>Long-lasting Results</strong>: Helps maintain skin brightness for weeks.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Is Customization by Experts Essential for Effective Skin Care?</div>\r\n\r\n<h3>Best Doctor Chemical Peel Treatment in Delhi</h3>\r\n\r\n<p>We have well-experienced professionals to ensure each procedure is well-suited for your needs. We provide personalized <strong>Best Doctor Chemical Peel Treatment in Delhi</strong> with consideration for your type of skin and your goals. Experts select the specific pill to deal with your main issues so as to give maximum results with a minimum of pain. We offer you cutting-edge technology and use the best quality products to give you safe, effective treatments for healthier skin.</p>\r\n\r\n<ul>\r\n	<li><strong>Customized Solutions</strong>: Special treatments for varied skin types and conditions.</li>\r\n	<li><strong>Safe Procedures</strong>: Performed by trained professionals to avoid side effects.</li>\r\n	<li><strong>Enhanced Comfort</strong>: Soft procedures to make the experience comfortable.</li>\r\n	<li><strong>Proven Results</strong>: Effective treatment that meets international safety standards.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">How has this treatment impacted the medical landscape in India?</div>\r\n\r\n<h3>Best Chemical Skin Peeling Treatment in India</h3>\r\n\r\n<p>Our focus on precision and safety makes this process both effective and reliable for clients across India. The chemical peel helps exfoliate dead skin layers and stimulates fresh skin cells to produce brighter, more youthful-looking skin. We are proud to provide the <strong>Best Chemical Skin Peeling Treatment in India</strong> with state-of-the-art techniques and superior products. It makes visible changes to your appearance regardless of whether you are looking for a refresh or addressing deep skin concerns.</p>\r\n\r\n<ul>\r\n	<li><strong>Advanced Techniques</strong>: The scientifically proven approach for superior results.</li>\r\n	<li><strong>Quality Products</strong>: Only high-grade peels for safety and efficacy.</li>\r\n	<li><strong>Nationwide Recognition</strong>: Serving the nation with client trust.</li>\r\n	<li><strong>Affordable Luxury</strong>: Outstanding care at value-for-money prices.</li>\r\n</ul>\r\n','','','Chemical-Peel-Treatment.jpg','','','',NULL,'N',2,'Y','Chemical Peel Treatment in Delhi, Chemical Peel Treatment In India','Chemical Peel Treatment in Delhi, Chemical Peel Treatment in India, Best Doctors For Chemical Peels Treatment In Delhi, Chemical Peel Cost In Delhi,Chemical Peel Cost in India','Are you looking for Chemical Peel Treatment in Delhi ? Goyal Laser Centre offers Best Chemical Peel Treatment in India Over 30 Years of Experience offering customised chemical peel solutions for radiant and rejuvenated skin at an affordable Price. Enquiry Now',NULL,NULL,'Chemical Peel Treatment',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Chemical Peel Treatment','','','','','',''),(8,NULL,NULL,2,NULL,'Hydra Facial Treatment','hydra-facial-treatment','','','','0',NULL,'We offer cutting-edge skin care solutions at {companyName} for radiant, healthy skin. Our Top Hydra Facial Treatment in Delhi is one of the most sought-after treatments for those looking for a non-invasive, rejuvenating skincare treatment. The HydraFacial uses patented technology to cleanse, exfoliate, and hydrate your skin, providing visible results without any downtime. This treatment is appropriate for all skin types and can treat multiple issues such as dryness, fine lines, and uneven tone. Instant glow and confidence come with smoother, refreshed skin.','<div class=\"cmTitle\">How Does HydraFacial Address Skin Concerns Like Acne and Hyperpigmentation?</div>\r\n\r\n<p>We offer cutting-edge skin care solutions at {companyName} for radiant, healthy skin. Our <strong>Top Hydra Facial Treatment in Delhi</strong> is one of the most sought-after treatments for those looking for a non-invasive, rejuvenating skincare treatment. The HydraFacial uses patented technology to cleanse, exfoliate, and hydrate your skin, providing visible results without any downtime. This treatment is appropriate for all skin types and can treat multiple issues such as dryness, fine lines, and uneven tone. Instant glow and confidence come with smoother, refreshed skin.</p>\r\n\r\n<ul>\r\n	<li><strong>Deep Hydration</strong>: Your skin gets the moisture it needs to be healthy and glow.</li>\r\n	<li><strong>Instant Results</strong>: Visible change after the first session.</li>\r\n	<li><strong>Customizable treatment</strong>: Adjusted according to your skin, its needs and concerns.</li>\r\n	<li><strong>Non-invasive</strong>: No downtime or recovery period after the procedure.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">What Role Does Certification Play in Choosing a HydraFacial Specialist?</div>\r\n\r\n<h3>Best HydraFacial Treatment Doctor in Delhi</h3>\r\n\r\n<p>The best doctor is what it takes to have the best possible results. Whether you want to hydrate, minimize pores, or reduce fine lines, the right doctor will help you achieve your desired results. We pride ourselves on being the <strong>Best HydraFacial Treatment Doctor in Delhi</strong> who gives proper personalized care. A professional practitioner will make sure your skin receives the right kind of treatment that targets the problem area of your concern.</p>\r\n\r\n<ul>\r\n	<li><strong>Personalized Care</strong>: Treatment is tailored according to your skin type and needs.</li>\r\n	<li><strong>Expert Guidance</strong>: Knowledgeable doctors ensure that the procedure is safe and effective.</li>\r\n	<li><strong>Consistent Results</strong>: With the right specialist, you can expect ongoing improvements.</li>\r\n	<li><strong>Boosted Confidence</strong>: The expert treatment makes a person feel calm during the process.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Do Customers Keep Coming Back for Our HydraFacial Services in India?</div>\r\n\r\n<h3>Best HydraFacial Dermatologist in India</h3>\r\n\r\n<p>The face pack treatment is the best for keeping your skin looking young and radiant, and our team will ensure that you get the best care. {companyName} is known for having the <strong>Best HydraFacial Dermatologist in India</strong>. They follow the latest techniques and make use of state-of-the-art equipment so that each treatment can be carried out in an accurate manner.</p>\r\n\r\n<ul>\r\n	<li><strong>Advanced Technology</strong>: High-quality results through cutting-edge equipment.</li>\r\n	<li><strong>Experienced Dermatologists</strong>: Skilled professionals providing top-tier treatment.</li>\r\n	<li><strong>Comprehensive Consultations</strong>: A thorough approach to understanding and addressing your skin&#39;s needs.</li>\r\n	<li><strong>Holistic Care</strong>: We focus on long-term skin health and beauty.</li>\r\n</ul>\r\n','','','Hydra-Facial-Treatment.jpg','','','',NULL,'N',3,'Y','Hydra Facial Treatment in Delhi, HydraFacial Dermatologist in India','Hydra Facial Treatment in Delhi, HydraFacial Dermatologist in Delhi, Hydra Facial Treatment in India, HydraFacial Dermatologist in India','Are you looking for Hydra Facial Treatment in Delhi ? Goyal Laser Centre offers Best HydraFacial Dermatologist in India Over 30 Years of Experience Providing Hydra Facial Treatment at an affordable Price. Enquiry Now',NULL,NULL,'Hydra Facial Treatment',NULL,0,'','','',0,'',0,'','','',NULL,'','Y','','','','Top Hydra Facial Treatment','','','','','','');

--
-- Table structure for table `category_tooltip_tbl`
--

CREATE TABLE `category_tooltip_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) DEFAULT NULL,
  `heading` varchar(500) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_tooltip_tbl`
--


--
-- Table structure for table `certificate`
--

CREATE TABLE `certificate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `certificate`
--


--
-- Table structure for table `client_heading_tbl`
--

CREATE TABLE `client_heading_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(255) DEFAULT NULL,
  `heading2` varchar(255) DEFAULT NULL,
  `heading3` varchar(255) DEFAULT NULL,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_heading_tbl`
--


--
-- Table structure for table `client_heading_testi_tbl`
--

CREATE TABLE `client_heading_testi_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` text,
  `heading2` text,
  `heading3` text,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_heading_testi_tbl`
--


--
-- Table structure for table `client_tbl`
--

CREATE TABLE `client_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `logo_image` varchar(800) NOT NULL,
  `client_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_tbl`
--

INSERT INTO `client_tbl` VALUES (1,'Max','','Max.jpg',NULL,'Y'),(2,'Lumenis','','Lumenis.jpg',NULL,'Y'),(3,'Delhi Medical Council','','Delhi-Medical-Council.jpg',NULL,'Y'),(4,'Indian Medical Association','','Indian-Medical-Association.jpg',NULL,'Y'),(5,'Moolchand','','Moolchand.jpg',NULL,'Y'),(6,'SGRH','','SGRH.jpg',NULL,'Y'),(7,'BLK','','BLK.jpg',NULL,'Y');

--
-- Table structure for table `client_testi_video_tbl`
--

CREATE TABLE `client_testi_video_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `caption` text,
  `caption_text` text,
  `logo_image` varchar(800) NOT NULL,
  `client_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_testi_video_tbl`
--


--
-- Table structure for table `coupan_codes_tbl`
--

CREATE TABLE `coupan_codes_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(15) NOT NULL,
  `discount` int(15) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `startdate` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  `addeddate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `coupon_type` enum('GENRAL','SECRET') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coupan_codes_tbl`
--


--
-- Table structure for table `courier_partners`
--

CREATE TABLE `courier_partners` (
  `partner_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_name` varchar(150) NOT NULL,
  `create_date` datetime NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`partner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courier_partners`
--


--
-- Table structure for table `crm_tbl`
--

CREATE TABLE `crm_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `ip` varchar(200) NOT NULL,
  `post_url` text NOT NULL,
  `comment` text,
  `support_id` int(11) DEFAULT NULL,
  `status` enum('0','1','2') NOT NULL DEFAULT '1' COMMENT '0=inactive,1=active,2=delete',
  `status_remark` varchar(100) DEFAULT NULL,
  `recivedate` varchar(50) NOT NULL,
  `agentId` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crm_tbl`
--


--
-- Table structure for table `digital_marketing_tbl`
--

CREATE TABLE `digital_marketing_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `Business_Heading` varchar(500) DEFAULT NULL,
  `caption` longtext,
  `logo_image` varchar(800) NOT NULL,
  `heading_icon` longtext,
  `bn` varchar(100) NOT NULL,
  `bl` varchar(255) NOT NULL,
  `bn1` varchar(100) DEFAULT NULL,
  `bl1` varchar(500) DEFAULT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `client_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `digital_marketing_tbl`
--


--
-- Table structure for table `documents_tbl`
--

CREATE TABLE `documents_tbl` (
  `document_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(70) NOT NULL,
  `org_type` varchar(150) NOT NULL,
  `documents` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`document_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `documents_tbl`
--


--
-- Table structure for table `download_tbl`
--

CREATE TABLE `download_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token_name` varchar(150) NOT NULL,
  `link_window` varchar(150) NOT NULL,
  `link_linux` varchar(150) NOT NULL,
  `link_mac` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `download_tbl`
--


--
-- Table structure for table `ekyclink_tbl`
--

CREATE TABLE `ekyclink_tbl` (
  `link_id` int(11) NOT NULL AUTO_INCREMENT,
  `catID` int(11) NOT NULL,
  `brand` varchar(110) NOT NULL,
  `validity` int(11) NOT NULL,
  `user_type` varchar(50) NOT NULL,
  `org_type` varchar(100) NOT NULL,
  `ekyc_link` tinytext NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ekyclink_tbl`
--


--
-- Table structure for table `factsheet_tbl`
--

CREATE TABLE `factsheet_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(255) DEFAULT NULL,
  `heading2` varchar(255) DEFAULT NULL,
  `heading3` varchar(500) DEFAULT NULL,
  `heading4` varchar(100) DEFAULT NULL,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `factsheet_tbl`
--


--
-- Table structure for table `faq_tbl`
--

CREATE TABLE `faq_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` longtext NOT NULL,
  `recvDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `faqOrder` int(11) NOT NULL DEFAULT '0',
  `status` varchar(30) NOT NULL DEFAULT '1',
  `category_id` varchar(30) DEFAULT '0',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faq_tbl`
--

INSERT INTO `faq_tbl` VALUES (3,'What Is A Chemical Peel Treatment And Who Needs It?','A chemical peel uses a safe acid solution to exfoliate damaged skin layers. It’s ideal for those with acne scars, uneven skin tone, or sun damage. Depending on the peel depth, results range from mild glow to dramatic skin renewal. Multiple sessions may enhance and maintain long-term skin clarity.','0000-00-00 00:00:00',0,'1',''),(4,'Why Choose Hydra Facial Treatment Over A Regular Facial?','Hydra Facial is a non-invasive treatment that combines cleansing, exfoliation, extraction, and hydration in one session. Unlike traditional facials, it uses patented technology for deeper results. It suits all skin types, with no redness or downtime, making it perfect for monthly skin maintenance or a quick pre-event glow.','0000-00-00 00:00:00',0,'1',''),(5,'How Is Pilonidal Sinus Treated And Does It Come Back?','Pilonidal sinus is treated through surgical excision or advanced laser procedures. Laser treatment is less painful and promotes faster healing. Good hygiene and avoiding prolonged sitting help prevent recurrence. Regular follow-up and keeping the area hair-free can significantly reduce the chances of it coming back after treatment.','0000-00-00 00:00:00',0,'1',''),(6,'What Causes A Fissure And How Is It Managed?','Fissures often result from hard stools or chronic constipation. Initial management includes fiber-rich diets, topical creams, and warm baths. If symptoms persist, laser surgery offers long-term relief. Early treatment reduces pain quickly and prevents chronic fissures from developing into more complicated conditions.','0000-00-00 00:00:00',0,'1',''),(7,'What Can I Expect From Cosmetology Services?','Cosmetology services include personalized skin treatments like acne therapy, anti-aging care, chemical peels, and laser solutions. You will receive expert evaluation and a customized plan based on your goals and skin type. It is more than beauty—it is about restoring skin health, confidence, and long-term radiance with science-backed care.','0000-00-00 00:00:00',0,'1',''),(8,'Is Laser Piles Treatment Better Than Traditional Surgery?','Yes, laser piles treatment is quicker, safer, and causes minimal pain compared to traditional surgery. It is a daycare procedure, meaning no hospital stay is needed. Patients usually return to work within a day or two. Laser technology ensures precise removal, less bleeding, and significantly lower chances of recurrence.','0000-00-00 00:00:00',0,'1','');

--
-- Table structure for table `forms_tbl`
--

CREATE TABLE `forms_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(1000) DEFAULT NULL,
  `form_id` text,
  `added_on` date DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `tiltOrder` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forms_tbl`
--


--
-- Table structure for table `gallery_tbl`
--

CREATE TABLE `gallery_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` varchar(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery_tbl`
--

INSERT INTO `gallery_tbl` VALUES (4,'Our Achievement','gallery_67ef88fb0013b.jpg',NULL,NULL,'1'),(5,'Our Achievement','gallery_67ef891fc30a6.jpg',NULL,NULL,'2'),(6,'Our Achievement','gallery_67ef8927c9207.jpg',NULL,NULL,'3'),(7,'Our Achievement','gallery_67ef892fb5320.jpg',NULL,NULL,'4'),(8,'Our Achievement','gallery_67ef8935ef1a6.jpg',NULL,NULL,'5'),(9,'Our Achievement','gallery_67ef893d4b31c.jpg',NULL,NULL,'6'),(10,'Our Achievement','gallery_67ef89435e414.jpg',NULL,NULL,'7'),(11,'Our Achievement','gallery_67ef894961b97.jpg',NULL,NULL,'8');

--
-- Table structure for table `headingAll_tbl`
--

CREATE TABLE `headingAll_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(255) DEFAULT NULL,
  `heading2` varchar(250) DEFAULT NULL,
  `content_desc` text,
  `bn` varchar(250) DEFAULT NULL,
  `bl` varchar(500) DEFAULT NULL,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `headingAll_tbl`
--


--
-- Table structure for table `industries_we_serve_tbl`
--

CREATE TABLE `industries_we_serve_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `Business_Heading` varchar(500) DEFAULT NULL,
  `caption` longtext,
  `heading_icon` longtext,
  `bn` varchar(100) NOT NULL,
  `bl` varchar(255) NOT NULL,
  `client_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `industries_we_serve_tbl`
--


--
-- Table structure for table `life_at_webpulse_tbl`
--

CREATE TABLE `life_at_webpulse_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `personName` varchar(80) NOT NULL DEFAULT '',
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `bannerImage` varchar(500) NOT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `bannerorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `life_at_webpulse_tbl`
--


--
-- Table structure for table `location_content_tbl`
--

CREATE TABLE `location_content_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(20) DEFAULT NULL,
  `location_ids` varchar(5000) DEFAULT NULL,
  `category_id` varchar(20) DEFAULT NULL,
  `meta_title` varchar(300) DEFAULT NULL,
  `meta_description` text,
  `meta_keyword` text,
  `description` text,
  `description2` text,
  `short_description` text,
  `keyword1` varchar(50) DEFAULT NULL,
  `keyword2` varchar(50) DEFAULT NULL,
  `keyword3` varchar(50) DEFAULT NULL,
  `specification` text,
  `subheadingtwo` varchar(500) DEFAULT NULL,
  `description3` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `location_content_tbl`
--

INSERT INTO `location_content_tbl` VALUES (2,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','1','Piles Treatment Clinic in {location}, Piles Treatment Hospital in {location}','Are you looking for Piles Treatment Clinic in {location}? Goyal Laser Centre offers Best Piles Treatment Hospital in {location} Over 30 Years of Experience Providing Piles Treatment at an affordable Price. Enquiry Now','Piles Treatment Clinic in {location}, Piles Treatment Hospital in {location}, Piles Treatment Clinic in {location}, Piles Treatment Hospital in {location}','<p>Piles are known as Hemorrhoids or Bawasir and are swollen and inflamed blood vessels in the anal region and people in <strong>{location}</strong> have this condition and suffer severe discomfort. Research shows that 75% of people will get affected at least once in their life by this condition in <strong>{location}</strong>. Earlier surgery used to be the only treatment for piles, but now with the advancement of medical technology, non-surgical treatments can be availed in <strong>{location}</strong>. If you are looking for the best <strong>Piles Treatment Clinic in {location}</strong>, then Goyal Piles Laser Centre will be one of the best selections. Despite being based in Delhi it is popular for its most experienced doctors who are dedicated to offering patients in <strong>{location} </strong>permanent relief from symptoms like injury, pain, itching, and overall discomfort with modern minimally invasive techniques.</p>\r\n\r\n<h2>What Distinguishes a Piles Treatment Hospital in {location}?</h2>\r\n\r\n<p>For those out there looking for a lasting solution without really undergoing the surgery, it becomes very necessary to find the right <strong>Piles Treatment Hospital in {location}</strong>. Nowadays, quite a number of hospitals, scattered across <strong>{location}</strong> look forward to modern diagnostic technology and modern-day treatment modalities such as laser therapy or minimally invasive procedures, encouraging faster healing and less pain. These establishments have teams of experts working on anorectal disorders, offering personalized care suitable for each individual in <strong>{location}</strong>. The growing reputation of the region for excellent healthcare services makes patients in <strong>{location}</strong> alike turn to the leading hospitals for effective and less costly piles treatment.</p>\r\n','<p><strong>Infrared Coagulation (IRC)</strong>:</p>\r\n\r\n<p>IRC is one of the most favored non-surgical and pain-free procedures, typically performed on an outpatient basis. This method is beyond minimally invasive, so patients often escape the pain of conventional surgery. In IRC, infrared light is used to target and coagulate small blood vessels of the hemorrhoid and thus shrink it. It has changed the world of hemorrhoid treatment since it guarantees quick relief, little recovery time, and a rapid return to normal activities.</p>\r\n\r\n<p><strong>Laser Treatment</strong>:</p>\r\n\r\n<p>Laser Treatment makes use of a Diode Laser approved by the United States Food and Drug Administration, and it is the newest high-tech treatment modality for advanced hemorrhoid cases. Whenever patients are in later stages of the disease, laser treatment usually supersedes a conventional surgical treatment. It is a minimum invasion procedure that is less painful and requires a shorter recovery time compared to the conventional operations; thus, it is a highly favorable option for patients looking for effective results with a minimum of discomfort.</p>\r\n','Piles are known as Hemorrhoids or Bawasir and are swollen and inflamed blood vessels in the anal region and people in {location} have this condition and suffer severe discomfort. Research shows that 75% of people will get affected at least once in their life by this condition in {location}.',NULL,NULL,NULL,NULL,'','<p>Due to technological advancements in medicine in <strong>{location}</strong>, piles are now treated effectively using laser surgery. This new approach to piles laser treatment operates as a day-care procedure, which presents distinct advantages over conventional methods of surgery in <strong>{location}</strong>. Gradually, more and more patients in <strong>{location} </strong>are now opting for the minimally invasive approach. Unlike traditional surgery, <strong>Laser Treatment For Piles in {location} </strong>does not practically involve cutting tissue, meaning no stitching, no wounds, and no dressing. The procedure takes just 15 minutes to one hour in most instances, and patients in <strong>{location} </strong>return home within hours and back to normal activities within about one to two days, with no pain during the post-operative period and practically no bleeding and there is also practically no risk of fecal incontinence, as the anal sphincter muscle is intact.</p>\r\n'),(3,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','3','Fissure Treatment in {location}, Anal Fissure Treatment in {location}','Are you looking for Fissure Treatment in {location}? Goyal Laser Centre offers Best Anal Fissure Treatment in {location} Over 30 Years of Experience Providing Fissure Treatment at an affordable Price. Enquiry Now','Fissure Treatment in {location}, Anal Fissure Treatment in {location}, Top Fissure Treatment in {location}, Best Anal Fissure Treatment in {location}, Fissure Treatment in {location}, Anal Fissure Treatment in {location}, Top Fissure Treatment in {location}, Best Anal Fissure Treatment in {location}','<p>An anal fissure is a small tear or cut either in the skin or mucosal lining of the anal canal and/or around the opening of the anus and many people in<strong> {location}</strong> often suffer from this. This usually becomes very painful for patients in<strong> {location} </strong>and sometimes results in enough bleeding during defecation. Anal fissures can affect every age group in<strong> {location} </strong>and can cause significant discomfort. If you are looking for <strong>Fissure Treatment in {location}</strong>, despite being based in Delhi, Goyal Piles Laser Centre, provides the newest, world-class, and most efficient laser treatment for anal fissures with quick relief, and speedier healing.</p>\r\n\r\n<p><strong>What Causes an Anal Fissure?</strong></p>\r\n\r\n<p>Poor diet leading to constipation and lack of physical activities in<strong> {location}</strong> are the main causes of anal fissure. The factors that can lead to fissure among patients in<strong> {location} </strong>include:</p>\r\n\r\n<ul>\r\n	<li>Passing hard or large stools during defecation</li>\r\n	<li>Straining during defecating</li>\r\n	<li>Recurrent straining from chronic constipation</li>\r\n	<li>Persistent diarrhea, which irritates the anal area</li>\r\n	<li>Pregnancy which causes increased pressure on the anal area</li>\r\n	<li>Anal intercourse, which can sometimes result in tearing of the sensitive skin around the anus</li>\r\n</ul>\r\n','<p>Anal fissures are one of the most painful and distressing medical conditions that affect people in<strong> {location}</strong>. If you are experiencing any of these symptoms such as pain or bleeding associated with your bowel movements, it is time to pay an expert a visit in<strong> {location}</strong>. If you are looking for the best <strong>Anal Fissure Treatment in {location}</strong>, although based in Delhi, we provide expert treatment to reduce systemic pain and enhance the chances of faster recovery with more advanced medical options.</p>\r\n\r\n<p><strong>Signs and Symptoms of Anal Fissure</strong>:</p>\r\n\r\n<ul>\r\n	<li>Pain or discomfort on passing stool</li>\r\n	<li>A visible tear or cut in the skin that surrounds the anal orifice</li>\r\n	<li>Presence of blood either in stool or on the toilet paper after the act of defecation</li>\r\n	<li>A small lump or skin tag adjacent to the fissure site</li>\r\n</ul>\r\n','An anal fissure is a small tear or cut either in the skin or mucosal lining of the anal canal and/or around the opening of the anus and many people in {location} often suffer from this. This usually becomes very painful for patients in {location} and sometimes results in enough bleeding during defecation. ',NULL,NULL,NULL,NULL,'','<p>For fissure diagnosis, a good clinical examination is carried out by the qualified doctor in {location}. A thorough diagnosis of the patients from {location} requires rectal examination, in which a well-lubricated anoscope-a specialized medical instrument-is carefully inserted into the anal canal. This is done with utmost care to minimize discomfort to the patient in {location}. The affected area can be closely inspected by doctors in {location} with the aid of the anoscope, which also helps to rule out other potential conditions such as polyps, ulcers or even rectal cancer. If you are searching for the best Laser Treatment For Fissure in {location}, despite being based in Delhi, we provide the latest facilities and futuristic technology in medical treatment for accurate diagnosis.</p>\r\n'),(4,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','4','Fistula Treatment in {location}, Anal Fistula Treatment Center in {location}','Are you looking for Fistula Treatment in {location}? Goyal Laser Centre offers Best Anal Fistula Treatment in {location} Over 30 Years of Experience Providing Fistula Treatment at an affordable Price. Enquiry Now','Fistula Treatment in {location}, Anal Fistula Treatment in {location}, Top Fistula Treatment in {location}, Best Anal Fistula Treatment in {location}, Fistula Treatment in {location}, Anal Fistula Treatment in {location}, Top Fistula Treatment in {location}, Best Anal Fistula Treatment in {location}','<p>An anal fistula is an abnormality of a tunnel that communicates between the lining of the anal canal and the outside skin near the anus and people in<strong> {location}</strong> suffer from this. This condition is known to be very uncomfortable and recurrent for patients in<strong> {location}</strong>. The patients in<strong> {location} </strong>often complain of pus discharge, swelling, irritating sensations, and sometimes pain around the anal area. If this treatable condition is neglected by patients in<strong> {location} </strong>for a long, fistula formation may worsen by further infections or complications. If you are searching for the best <strong>Fistula Treatment in {location}</strong>, despite being based in Delhi, we offer laser surgery for anal fistula-approved by the USFDA, a latest minimally-for example intervention aimed towards safely and effectively treating this condition.</p>\r\n\r\n<p><strong>How Does It Occur?</strong></p>\r\n\r\n<p>An anal fistula usually forms when the anal canal tissue lining is injured, or there is some infection in that area and is often very uncomfortable for people in<strong> {location}</strong>. Factors that may contribute to the development of an anal fistula in patients in<strong> {location} </strong>may include:</p>\r\n\r\n<ul>\r\n	<li>Constipation with injury</li>\r\n	<li>Infection of the anal canal crypt gland</li>\r\n	<li>Crohn&#39;s disease, being a chronic inflammatory condition of the intestines</li>\r\n</ul>\r\n','<p>The first indication of an anal fistula is a typically sore, swollen area around the entrance to the anus of the patients in<strong> {location}</strong>. After a few days, the swelling may burst, allowing for the eventual drainage of pus and offering temporary relief to the patient in<strong> {location}</strong>. The swelling-drainage-recurrence cycle continues until the anal fistula is adequately treated in<strong> {location}</strong>. If you are looking for the best <strong>Anal Fistula Treatment Center in {location}</strong>, although based in Delhi, we introduce modern and non-invasive treatment methodologies, including advanced laser techniques, that greatly help treat anal fistulas without surgery. With proper treatment, comfort and recurrent episodes associated with anal fistulas can be alleviated and resolved, hence improving the quality of life among patients in<strong> {location}</strong>.</p>\r\n\r\n<p><strong>Some of the symptoms common to anal fistula are</strong>:</p>\r\n\r\n<ul>\r\n	<li>Regular or intermittent discharge of mucus or pus</li>\r\n	<li>Pain and swelling in perianal area</li>\r\n</ul>\r\n','An anal fistula is an abnormality of a tunnel that communicates between the lining of the anal canal and the outside skin near the anus and people in {location} suffer from this. This condition is known to be very uncomfortable and recurrent for patients in {location}. ',NULL,NULL,NULL,NULL,'','<p>Anal fistulas are typically diagnosed through careful physical examination of the anus and surrounding perianal area of the patients in<strong> {location}</strong>. If you are seeking <strong>Fistula Treatment Without Surgery in {location}</strong>, despite being based in Delhi, we offer patients alternatives to surgical intervention. They may work well to manage and completely clear anal fistulas with minimal discomfort-the very aspects keeping patients in<strong> {location} </strong>away from their quality of life-traditional surgery can be avoided. This diagnosis procedure may involve the following tests in<strong> {location}</strong>:</p>\r\n\r\n<ul>\r\n	<li><strong>Anoscopy</strong>: A procedure in which the doctor inserts an instrument called an anoscope into the rectum to inspect the annal canal.</li>\r\n	<li><strong>MRI Fistulogram</strong>: To Confirm the disease &amp; to find out the route of the anal fistula tract.</li>\r\n</ul>\r\n'),(5,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','5','Pilonidal Sinus Treatment in {location}, Laser Pilonidal Sinus Treatment Hospital in {location}','Are you looking for Pilonidal Sinus Treatment in {location}? Goyal Laser Centre offers Best Laser Pilonidal Sinus Treatment Hospital in {location} Over 30 Years of Experience Providing Pilonidal Sinus Treatment at an affordable Price. Enquiry Now','Pilonidal Sinus Treatment in {location}, Laser Pilonidal Sinus Treatment Hospital in {location}, Pilonidal Sinus Treatment in {location}, Laser Pilonidal Sinus Treatment Hospital in {location}','<p>Pilonidal sinus is a pathological condition in which little gaps, or holes, develop below skin, often from the juncture point inside the buttocks and is suffered by my people in<strong> {location}</strong>. This condition can get the openings filled with pus or liquid and cause considerable discomfort fo patients in<strong> {location}</strong>. With modern advancement in medicine, the treatment has also become easier and effective in<strong> {location}</strong>. If you are searching for the best <strong>Pilonidal Sinus Treatment in {location}</strong>, despite being based in Delhi, Goyal Piles Laser Centre provides the state-of-the-art laser procedure for the treatment and patients can expect fast relieve and clearing with the problem.</p>\r\n\r\n<p><strong>Causes of Pilonidal Sinus</strong>:</p>\r\n\r\n<ul>\r\n	<li>Excessive hair growth</li>\r\n	<li>Continued sitting</li>\r\n	<li>Unsanitary conditions</li>\r\n	<li>Close-fitting clothes that trap sweat and dirt</li>\r\n	<li>Hormonal alteration</li>\r\n	<li>Hair puncture</li>\r\n</ul>\r\n\r\n<h2>What Makes The Top Laser Pilonidal Sinus Treatment Hospital in {location} The Go-To Choice For Fast, Scar-Free Recovery?</h2>\r\n\r\n<p>It is important to get the right treatment for a pilonidal sinus as it can lead to infections and pain in the long run in <strong>{location}</strong>. If you&rsquo;re looking for <strong>Laser Pilonidal Sinus Treatment Hospital in {location}</strong>, we utilize advanced minimally invasive procedures that promise faster healing, much less pain, and reduced chances of recurrence. Our high-end technology and expertise have been effectively redefining the recovery of patients in <strong>{location}</strong> through high success and patient care models. Even if you are located in nearby areas, it doesn&#39;t make a difference because good ones like us extend such superior treatment facilities to patients from <strong>{location}</strong> so that nobody is deprived of expert care, uninterrupted.</p>\r\n','<p>A pilonidal sinus is a troublesome situation that can greatly cause inconvenience to those who suffer from it in<strong> {location}</strong>. It arises near the tailbone with some small holes or cavities forming beneath the skin and may be associated with swelling, pain, and sometimes foul discharge, which may recur for patients in<strong> {location}</strong>. Early detection and treatment in<strong> {location} </strong>will avoid other complications, which may include abscess formation and persistent infections. If you are looking for <strong>Laser Treatment For Pilonidal Sinus in {location}</strong>, although based in Delhi<strong>, </strong>our laser treatments facilitate the resolution of this problem, thus providing fast and prompt relief to patients.</p>\r\n\r\n<p><strong>Symptoms of Pilonidal Sinus</strong>:</p>\r\n\r\n<ul>\r\n	<li>There is a reddish swollen tender area around the tailbone.</li>\r\n	<li>Pain appears on sitting or pressure in that area.</li>\r\n	<li>There may be a little dimple or a larger lump between the buttocks.</li>\r\n	<li>There may be persistent discharge with pus and a foul smell or blood from the sinus opening.</li>\r\n	<li>This may sometimes be accompanied by fever and fatigue during the formation of the abscess.</li>\r\n</ul>\r\n','Pilonidal sinus is a pathological condition in which little gaps, or holes, develop below skin, often from the juncture point inside the buttocks and is suffered by my people in {location}. This condition can get the openings filled with pus or liquid and cause considerable discomfort fo patients in {location}.',NULL,NULL,NULL,NULL,'','<p>Diagnosis for pilonidal sinus is usually by thorough physical examination of the affected area by a qualified doctor in<strong> {location}</strong>. Most of the time it can easily be diagnosed by visual observation with minimal physical examination in<strong> {location}</strong>. However, in complicated or recurrent cases in<strong> {location} </strong>with suspicion of deeper infection or abscess formation, further imaging studies may be necessary, such as MRI (Magnetic Resonance Imaging) scanning, to obtain a detailed view of the distribution of the infection, possible formations of tracts beneath the skin, or to rule out other conditions. If you are looking for <strong>Pilonidal Sinus Cure Without Surgery in {location}</strong>, despite being based in Delhi, we use modern laser techniques that allow faster recovery with minimal discomfort.</p>\r\n'),(6,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','7','Chemical Peel Treatment in {location}, Chemical Peel Treatment In {location}','Are you looking for Chemical Peel Treatment in {location}? Goyal Laser Centre offers Best Chemical Peel Treatment in {location} Over 30 Years of Experience offering customised chemical peel solutions for radiant and rejuvenated skin at an affordable Price. Enquiry Now','Chemical Peel Treatment in {location}, Chemical Peel Treatment in {location}, Best Doctors For Chemical Peels Treatment In {location}, Chemical Peel Cost In {location},Chemical Peel Cost in {location}','<div class=\"cmTitle\">What Are the Hidden Benefits of Rejuvenated Skin for Confidence?</div>\r\n\r\n<h2>Top Chemical Peel Treatment in {location}</h2>\r\n\r\n<p>{companyName} provides a variety of solutions to help you achieve radiant, youthful skin in<strong> {location}</strong>. If you are searching for the <strong>Top Chemical Peel Treatment in {location}</strong>, despite not being situated there, we offer a highly effective method for rejuvenating and enhancing the skin. This treatment is known to address multiple concerns with skin by clearing away dead cells and creating a more healthy, active layer in<strong> {location}</strong>. Therefore, with these treatments and more personalized care, every patient walks out of the office looking more incredible in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Gentle Exfoliation</strong>: Remove dead layers for the perfect glowing face.</li>\r\n	<li><strong>Improves texture</strong>: Leaving your skin smoother to touch</li>\r\n	<li><strong>Effective targeting</strong>: The removal of fine lines, pigmentation, and scars due to acne.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Is Experience Crucial for Solving Complex Problems Efficiently?</div>\r\n\r\n<h3>Best Doctor Chemical Peel Treatment in {location}</h3>\r\n\r\n<p>From reversing signs of aging to the treatment of acne scars, a specialist at the centre will administer treatment using techniques that ensure utmost care and deliver noticeable improvements in<strong> {location}</strong>. If you are looking for the <strong>Best Doctor Chemical Peel Treatment in {location}</strong>, even though we don&rsquo;t reside there, with extensive knowledge and understanding of a variety of skin types, our doctor will know exactly how to treat you, as every skin type is unique.</p>\r\n\r\n<ul>\r\n	<li><strong>Customized Treatments</strong>: Solutions designed to suit individual skin types and concerns.</li>\r\n	<li><strong>Expert Guidance</strong>: Thorough consultations to address your goals and expectations.</li>\r\n	<li><strong>Safe Application</strong>: Procedures performed with precision for optimal safety and comfort.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">How Does Personalized Care Elevate a Clinic&rsquo;s Patient Experience?</div>\r\n\r\n<h3>Best Chemical Skin Peeling Treatment in {location}</h3>\r\n\r\n<p>Selecting the right clinic ensures both safety and results in<strong> {location}</strong>. Our advanced procedures use high-quality products and modern technologies, ensuring minimal downtime and remarkable outcomes in<strong> {location}</strong>. If you are searching for the <strong>Best Chemical Skin Peeling Treatment in {location}</strong>, while we&rsquo;re not located there, we work with a focus on patient satisfaction and long-term benefits. Patients trust us for our professionalism, compassionate care, and consistent delivery of superior results in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>State-of-the-art technology</strong>: Leveraging modern equipment for precise and effective results.</li>\r\n	<li><strong>High-Quality Products</strong>: Using premium-grade peels for enhanced safety and efficacy.</li>\r\n	<li><strong>Dedicated Care</strong>: A team focused on delivering outstanding patient experiences.</li>\r\n</ul>\r\n','','{companyName} provides a variety of solutions to help you achieve radiant, youthful skin in {location}. If you are searching for the Top Chemical Peel Treatment in {location}, despite not being situated there, we offer a highly effective method for rejuvenating and enhancing the skin. This treatment is known to address multiple concerns with skin by clearing away dead cells and creating a more healthy, active layer in {location}. Therefore, with these treatments and more personalized care, every patient walks out of the office looking more incredible in {location}.',NULL,NULL,NULL,NULL,'',''),(7,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','8','Hydra Facial Treatment in {location}, HydraFacial Dermatologist in {location}','Are you looking for Hydra Facial Treatment in {location}? Goyal Laser Centre offers Best HydraFacial Dermatologist in {location} Over 30 Years of Experience Providing Hydra Facial Treatment at an affordable Price. Enquiry Now','Hydra Facial Treatment in {location}, HydraFacial Dermatologist in {location}, Hydra Facial Treatment in {location}, HydraFacial Dermatologist in {location}','<div class=\"cmTitle\">Why Does Maintaining a Skin Care Routine Affect Your Mental Health?</div>\r\n\r\n<h2>Top Hydra Facial Treatment in {location}</h2>\r\n\r\n<p>{companyName}&rsquo;s speciality is helping people achieve healthier, more radiant skin in<strong> {location}</strong>. If you are searching for the <strong>Top Hydra Facial Treatment in {location}</strong>, while we&rsquo;re not located there, we offer one of the best solutions for deep cleansing, hydration, and rejuvenation. The non-invasive treatment is set to remove all impurities that infuse essential nutrients into your skin, giving you fresh, glowing skin in<strong> {location}</strong>. With our expert team and advanced techniques, we make sure you will see improvements right from the very first session in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Deep Cleansing</strong>: Purifies and clears pores, leaving you with a fresh feeling.</li>\r\n	<li><strong>Intensive Hydration</strong>: Provides your skin with the necessary moisture to enhance elasticity.</li>\r\n	<li><strong>Radiant Outcomes</strong>: Smoothes and brightens the skin for that radiant glow.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">What Makes a Skin Expert&rsquo;s Advice More Reliable Than Online Information?</div>\r\n\r\n<h3>Best HydraFacial Treatment Doctor in {location}</h3>\r\n\r\n<p>A skilled professional does make all the difference in results in<strong> {location}</strong>. Our specialist tailors each treatment to suit individual skin needs, ensuring you receive a customized experience that delivers long-lasting results in<strong> {location}</strong>. From addressing specific skin concerns to enhancing overall skin health, we focus on providing the best care possible in<strong> {location}</strong>. If you are looking for the <strong>Best HydraFacial Treatment Doctor in {location}</strong>, even though we don&rsquo;t reside there, we bring extensive expertise and knowledge to every session.</p>\r\n\r\n<ul>\r\n	<li><strong>Personalized Treatments</strong>: Tailored solutions to meet unique skin requirements.</li>\r\n	<li><strong>Expert Care</strong>: A specialist with years of experience ensures effective results.</li>\r\n	<li><strong>Safe and Comfortable</strong>: Procedures performed with precision to prioritize safety and comfort.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Do Some Clinics Deliver Better Results Than Others in Skincare?</div>\r\n\r\n<h3>Best HydraFacial Dermatologist in {location}</h3>\r\n\r\n<p>{companyName} connects state-of-the-art equipment with expert techniques to provide far superior results in<strong> {location}</strong>. We help everyone reach their specific goals, from keeping one&#39;s skin glowing to solving various issues, all through a seamless and satisfying experience for all our clients in<strong> {location}</strong>. Selection of a reliable clinic is highly important for efficient and safe treatments. If you are searching for the <strong>Best HydraFacial Dermatologist in {location}</strong>, while we&rsquo;re not located there, we have the highest technology provided and a patient-first approach.</p>\r\n\r\n<ul>\r\n	<li><strong>Advanced Technology</strong>: Utilizing the latest equipment for precise and effective results.</li>\r\n	<li><strong>Comprehensive Care</strong>: Addressing all aspects of skin health and beauty.</li>\r\n	<li><strong>Trusted Expertise</strong>: A reputation built on delivering consistent and exceptional results.</li>\r\n</ul>\r\n','','{companyName}’s speciality is helping people achieve healthier, more radiant skin in {location}. If you are searching for the Top Hydra Facial Treatment in {location}, while we’re not located there, we offer one of the best solutions for deep cleansing, hydration, and rejuvenation. The non-invasive treatment is set to remove all impurities that infuse essential nutrients into your skin, giving you fresh, glowing skin in {location}. With our expert team and advanced techniques, we make sure you will see improvements right from the very first session in {location}.',NULL,NULL,NULL,NULL,'',''),(8,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','6','Best Laser Hair Removal Treatment in {location}, Top Laser Hair Removal Clinics in {location}','Are you looking for Laser Hair Removal Treatment in {location}? Goyal Laser Centre offers Best Laser Hair Removal Clinics in {location} Over 30 Years of Experience Providing Laser Hair Removal Treatment at an affordable Price. Enquiry Now','Laser Hair Removal Treatment in {location}, Laser Hair Removal Clinics in {location}, Top Laser Hair Removal Treatment in {location}, Best Laser Hair Removal Clinics in {location}, Laser Hair Removal Treatment in {location}, Laser Hair Removal Clinics in {location}, Top Laser Hair Removal Treatment in {location}, Best Laser Hair Removal Clinics in {location}','<div class=\"cmTitle\">How Can Advanced Treatments Make Your Grooming Routine Even Easier?</div>\r\n\r\n<h2>Best Laser Hair Removal Treatment in {location}</h2>\r\n\r\n<p>{companyName} provides effective and long-term solutions for smooth skin for people in<strong> {location}</strong>. If you are looking for the <strong>Best Laser Hair Removal Treatment in {location}</strong>, although we don&#39;t operate from there, with all the advanced technology we offer, treatment that reaches deep into your root and gives the skin smoothness without any more unwanted hair growth, hence giving your skin silky smoothness. Our team is quite skilled and ready with all of this equipment for you in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Long-Lasting Results</strong>: Reduces hair growth for smoother, maintenance-free skin.</li>\r\n	<li><strong>Safe and Painless</strong>: Advanced techniques ensure maximum comfort during the procedure.</li>\r\n	<li><strong>Customizable Solutions</strong>: Treatment plans tailored to suit different skin and hair types.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Should You Rely on Experienced Professionals for High-Quality Results?</div>\r\n\r\n<h3>Laser Hair Removal Doctor in {location}</h3>\r\n\r\n<p>Choosing a professional ensures that any procedure is completed successfully and safely for you in<strong> {location}</strong>. If you are searching for <strong>Laser Hair Removal Doctor in {location}</strong>, even if we aren&#39;t stationed there, we are committed to providing exceptional results. It is the difference that our doctor&#39;s vast experience and personalized approach make between effective and safe treatments in<strong> {location}</strong>. From sensitive skin to specific concerns, you can count on our expertise for a smooth and worry-free experience in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Professional Consultation</strong>: Comprehensive assessments for personalized treatment plans for your concerns.</li>\r\n	<li><strong>Safe Practice</strong>: Ensure quality care and do not allow compromise on your skin condition.</li>\r\n	<li><strong>Skilled Experts</strong>: Experienced professionals who have spent decades and can deliver with consistent effectiveness.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">How Do Advanced Clinics Maintain Consistent High-Quality Standards?</div>\r\n\r\n<h3>Top Laser Hair Removal Clinics in {location}</h3>\r\n\r\n<p>The type of clinic and the level of professionalism displayed by our clinics determine this for you in<strong> {location}</strong>. If you are looking for <strong>Top Laser Hair Removal Clinics in {location}</strong>, despite not being situated there, {companyName} is well known for giving the most advanced treatments in the most patient-friendly environment. The advanced procedures in<strong> {location} </strong>we carry out ensure our patients receive the quality care they have been anticipating. We focus on making your visit comfortable, efficient, and geared to meeting individual needs in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>State-of-the-art equipment</strong>: Used for precise treatment to ensure optimal patient care.</li>\r\n	<li><strong>Patient-centered care</strong>: Supportive approaches guarantee comfort and satisfaction throughout the treatment.</li>\r\n	<li><strong>Proven results</strong>: Consistent delivery of outcomes that exceed expectations.</li>\r\n</ul>\r\n','','{companyName} provides effective and long-term solutions for smooth skin for people in {location}. If you are looking for the Best Laser Hair Removal Treatment in {location}, although we don&#039;t operate from there, with all the advanced technology we offer, treatment that reaches deep into your root and gives the skin smoothness without any more unwanted hair growth, hence giving your skin silky smoothness. Our team is quite skilled and ready with all of this equipment for you in {location}.',NULL,NULL,NULL,NULL,'',''),(9,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','2','Top Cosmetology Treatment Services in {location}, Cosmetology Treatment Specialists in {location}','Are you looking for Top Cosmetology Treatment Services in {location}? Goyal Laser Centre offers Best Cosmetology Treatment Specialists in {location} Over 30 Years of Experience providing Top Cosmetology Treatment Services at an affordable Price. Enquiry Now','Top Cosmetology Treatment Services in {location}, Cosmetology Treatment Specialists in {location}, Top Cosmetology Treatment Services in {location}, Cosmetology Treatment Specialists in {location}','<div class=\"cmTitle\">How does experimenting with different fashion styles empower self-expression?</div>\r\n\r\n<h2>Top Cosmetology Treatment Services in {location}</h2>\r\n\r\n<p>At {companyName}, we are committed to making you feel and look your best in<strong> {location}</strong>. If you are searching for the <strong>Top Cosmetology Treatment Services in {location}</strong>, despite not being situated there, we offer innovative solutions all designed with your needs in mind. We aim to improve natural beauty while helping you look good for skin texture, hair care, and, of course, reducing anti-ageing in<strong> {location}</strong>. We, with our state-of-the-art techniques and always being considerate of safety, can ensure that treatments are effective and long-lasting for you to look and feel great inside and out in <strong>{location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Advanced Skin Solutions</strong>: Radiant, healthy, and young-looking skin</li>\r\n	<li><strong>Hair care excellence</strong>: Customized approaches towards scalp and hair health.</li>\r\n	<li><strong>Customized Programs</strong>: Programs designed with your personal sense of beauty in mind</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">What Sets Experienced Specialists Apart from Less Experienced Ones?</div>\r\n\r\n<h3>Best Cosmetology Doctor in {location}</h3>\r\n\r\n<p>For getting the desired outcomes, the presence of a specialist doctor can change everything in<strong> {location}</strong>. If you are looking for the <strong>Best Cosmetology Doctor in {location}</strong>, although we don&#39;t operate from there, we specialize in taking care of their patients. So, our very knowledgeable doctor keeps each procedure strictly tailored to individuals&#39; needs using in-depth information about skin and hair treatments in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Tailored Consultations</strong>: Comprehensive evaluations to understand your unique needs.</li>\r\n	<li><strong>Expert Techniques</strong>: Cutting-edge methods for effective and safe treatments.</li>\r\n	<li><strong>Dedicated Care</strong>: A professional approach that prioritizes your comfort and satisfaction.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">What Is the Difference Between a Good Specialist and a Great One?</div>\r\n\r\n<h3>Best Cosmetologist in {location}</h3>\r\n\r\n<p>Patients in<strong> {location} </strong>feel secure with us due to the meticulous care and attentive treatment given to each of them, along with our commitment to excellence in every procedure. The right professional always makes the outcome exceptional in<strong> {location}</strong>. People seeking the <strong>Best Cosmetologist in {location},</strong> despite not being situated there, offer promising expertise that never goes wrong with the results. We concentrate entirely on safety and comfort along with efficiency in each and every treatment in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Advanced Technology</strong>: Enhances personalized treatment for optimal results</li>\r\n	<li><strong>Patient-Centric Approach</strong>: Ensuring your comfort and confidence at every step.</li>\r\n	<li><strong>Proven Excellence</strong>: Patients rely on us to consistently deliver quality.</li>\r\n</ul>\r\n','','At {companyName}, we are committed to making you feel and look your best in {location}. If you are searching for the Top Cosmetology Treatment Services in {location}, despite not being situated there, we offer innovative solutions all designed with your needs in mind. We aim to improve natural beauty while helping you look good for skin texture, hair care, and, of course, reducing anti-ageing in {location}. We, with our state-of-the-art techniques and always being considerate of safety, can ensure that treatments are effective and long-lasting for you to look and feel great inside and out in {location}.',NULL,NULL,NULL,NULL,'',''),(10,'0','3,5,23,4,24,25,26,27,28,29,30,31,32,33,34,35,36,37,11,12,13,14,15,16,17,18,19,20,21,22,82,83,84,85,86,87,88,89,7,8,9,10,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,38,40,41,39,42,43,44,45,46,47,48,49,50,51,52,53,6,91,100,99,92,93,94,95,96,97,98,90,103,101,102','0','Top Piles Treatment Centre in {location}, Best Advanced Laser Fistula Treatment in {location}','Goyal Laser Centre is one of the Best Piles Treatment Centers in {location}, Over 30 Years of Experience, Providing Advanced Laser Fistula Treatment in {location}, Fissure and Piles Treatment at an affordable Price. Enquiry Now','Piles Treatment Centre in {location}, Advanced Laser Fistula Treatment in {location}, Top Piles Treatment Centre in {location}, Best Advanced Laser Fistula Treatment in {location}','<div class=\"cmTitle\">How Can Your Health and Well-Being Be Changed by Advanced Laser Technology?</div>\r\n\r\n<p>Welcome to {companyName}, where we provide the best healthcare to our patients, and in treating piles, as we know how important it is to find not only a reliable clinic but also a newer solution in<strong> {location}</strong>. If you are looking for the <strong>Top Piles Treatment Centre in {location}</strong>, despite being based somewhere else, we pride ourselves on using the latest medical technologies and methods to help you find long-lasting relief. Our team of experienced professionals is committed to ensuring that your experience with us in<strong> {location} </strong>is as comfortable and effective as possible. We will not only address your symptoms but, more importantly, treat the source of your problem to ensure that you can resume life without the inconvenience of this disorder in<strong> {location}</strong>. We design the treatment especially to suit each case in<strong> {location}</strong>. Our purpose extends beyond treating your condition because we will guide you through every step of your journey in <strong>{location}</strong>. We accompany patients through their entire experience, starting from initial consultations until post-treatment care in <strong>{location}</strong>. Our medical team combines deep knowledge and extensive expertise to provide the best possible care for patients with mild symptoms and those requiring advanced medical treatment in <strong>{location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Experienced Doctors</strong>: Our specialists maintain extensive experience treating piles and comparable medical issues.</li>\r\n	<li><strong>Minimally Invasive Treatments</strong>: We use advanced laser technology to provide treatment that leads to both fast recovery and minimal patient discomfort.</li>\r\n	<li><strong>Patient-Centered Care</strong>: Our team hears your worries to develop personalized treatment plans for you</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Should You Put Your Trust in Contemporary Laser Care for Durable Outcomes?</div>\r\n\r\n<h2>Best Advanced Laser Fistula Treatment in {location}</h2>\r\n\r\n<p>Unlike conventional surgeries that often involve long recovery times and greater discomfort, our laser treatment ensures a faster recovery with minimal downtime in<strong> {location}</strong>. By utilizing modern science, we can target and treat the affected area specifically, which means that there will be a better healing process for clients in<strong> {location}</strong>. If you are searching for the <strong>Best Advanced Laser Fistula Treatment in {location}</strong>, even though we are not based there, our advanced method is designed to offer patients a quicker, less painful, and more effective alternative to traditional procedures. We use laser therapy for providing treatments to clients in<strong> {location}</strong>, avoiding damage to surrounding tissues, with a great probability of avoiding complications. Our team of medical professionals will assess your condition and decide on the proper treatment to get you the best possible outcome in<strong> {location}</strong>. We not only focus on treating your condition but also try to make sure you feel comfortable and well cared for while undergoing treatment in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Precision Treatment</strong>: This only targets the affected area of the fistula, leaving the rest of the surrounding tissues unharmed.</li>\r\n	<li><strong>Minimal Discomfort</strong>: The procedure with laser can be less invasive and will also have lesser pain than a traditional method.</li>\r\n	<li><strong>Faster Recovery</strong>: Patients can expect to get back to activities because of minimal downtime.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Should You Prefer Modern Laser Treatment for Permanent Relief from Piles?</div>\r\n\r\n<h3>Best Center for Piles Laser Treatment in {location}</h3>\r\n\r\n<p>Unlike traditional piles surgeries that take a long time for healing and are more painful, our patients in <strong>{location} </strong>can be offered the painless and very fast process of treatment at our clinic. If you are searching for the <strong>Best Center for Piles Laser Treatment in {location}</strong>, although we operate from Haryana, our treatments fit the expectations of many patients. Through laser energy concentrated, we target the tissues that are being worked on, which leaves the rest almost undamaged and minimizes the chances of complications after doing the treatment in <strong>{location}</strong>. Our method of treatment for patients in <strong>{location}</strong> is expected to speed up recovery time while minimizing pain and hassle remarkably. We offer effective treatments to patients in <strong>{location}</strong> along with a supportive, caring atmosphere for the well-being of patients. Each case has its treatment handled by experienced professionals who aim for a safe and result-oriented practice while making the process as easy as possible for clients in<strong> {location}</strong>.</p>\r\n\r\n<ul>\r\n	<li><strong>Targeted Precision</strong>: Laser therapy directly treats the problem area without harming nearby healthy tissues.</li>\r\n	<li><strong>Pain Less</strong>: Compared to traditional techniques, laser surgery is less painful and discomforting.</li>\r\n	<li><strong>Fastest Healing</strong>: Our patients normally present with more rapid recovery and an early return to individual activities.</li>\r\n</ul>\r\n','','',NULL,NULL,NULL,NULL,'','');

--
-- Table structure for table `location_pilescontent_tbl`
--

CREATE TABLE `location_pilescontent_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(20) DEFAULT NULL,
  `location_ids` varchar(5000) DEFAULT NULL,
  `category_id` varchar(20) DEFAULT NULL,
  `meta_title` varchar(300) DEFAULT NULL,
  `meta_description` text,
  `meta_keyword` text,
  `description` text,
  `description2` text,
  `short_description` text,
  `keyword1` varchar(50) DEFAULT NULL,
  `keyword2` varchar(50) DEFAULT NULL,
  `keyword3` varchar(50) DEFAULT NULL,
  `specification` text,
  `subheadingtwo` varchar(500) DEFAULT NULL,
  `description3` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `location_pilescontent_tbl`
--


--
-- Table structure for table `location_tbl`
--

CREATE TABLE `location_tbl` (
  `locationID` int(11) NOT NULL AUTO_INCREMENT,
  `locationType` varchar(11) DEFAULT NULL,
  `locationurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `locationName` varchar(800) DEFAULT NULL,
  `locationtDesc` text,
  `locationDesc1` text,
  `locationImage` varchar(50) DEFAULT NULL,
  `toplocation` char(1) NOT NULL DEFAULT 'N',
  `locationOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) DEFAULT NULL,
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `locationPosition` int(11) NOT NULL DEFAULT '0',
  `locationIcon` varchar(100) DEFAULT NULL,
  `loc_url` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`locationID`)
) ENGINE=MyISAM AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location_tbl`
--

INSERT INTO `location_tbl` VALUES (1,'',NULL,0,'India',NULL,NULL,NULL,'N',1,'N',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'india'),(5,'',NULL,3,'Alipur',NULL,NULL,NULL,'N',2,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'alipur'),(3,'',NULL,1,'Delhi',NULL,NULL,NULL,'N',1,'N',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'delhi'),(4,'',NULL,3,'Asola',NULL,NULL,NULL,'N',1,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'asola'),(6,'',NULL,3,'Shalimar Garden',NULL,NULL,NULL,'N',3,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'shalimar-garden'),(7,'',NULL,3,'Karol Bagh',NULL,NULL,NULL,'N',4,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'karol-bagh'),(8,'',NULL,3,'Kashmiri Gate',NULL,NULL,NULL,'N',5,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kashmiri-gate'),(9,'',NULL,3,'Keshav Puram',NULL,NULL,NULL,'N',6,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'keshav-puram'),(10,'',NULL,3,'Khan Market',NULL,NULL,NULL,'N',7,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'khan-market'),(11,'',NULL,3,'Dhaula Kuan',NULL,NULL,NULL,'N',8,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'dhaula-kuan'),(12,'',NULL,3,'Dilshad Garden',NULL,NULL,NULL,'N',9,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'dilshad-garden'),(13,'',NULL,3,'Dwarka',NULL,NULL,NULL,'N',10,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'dwarka'),(14,'',NULL,3,'East Delhi',NULL,NULL,NULL,'N',11,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'east-delhi'),(15,'',NULL,3,'Fateh Nagar',NULL,NULL,NULL,'N',12,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'fateh-nagar'),(16,'',NULL,3,'Gandhi Nagar',NULL,NULL,NULL,'N',13,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'gandhi-nagar'),(17,'',NULL,3,'Gautam Nagar',NULL,NULL,NULL,'N',14,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'gautam-nagar'),(18,'',NULL,3,'Geeta Colony',NULL,NULL,NULL,'N',15,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'geeta-colony'),(19,'',NULL,3,'Greater Kailash',NULL,NULL,NULL,'N',16,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'greater-kailash'),(20,'',NULL,3,'Hari Nagar',NULL,NULL,NULL,'N',17,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'hari-nagar'),(21,'',NULL,3,'Hauz Khas',NULL,NULL,NULL,'N',18,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'hauz-khas'),(22,'',NULL,3,'Inderlok',NULL,NULL,NULL,'N',19,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'inderlok'),(23,'',NULL,3,'Ashok Nagar',NULL,NULL,NULL,'N',20,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'ashok-nagar'),(24,'',NULL,3,'Baljit Nagar',NULL,NULL,NULL,'N',21,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'baljit-nagar'),(25,'',NULL,3,'Barakhamba Road',NULL,NULL,NULL,'N',22,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'barakhamba-road'),(26,'',NULL,3,'Bawana',NULL,NULL,NULL,'N',23,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'bawana'),(27,'',NULL,3,'Bhikaji Cama Place',NULL,NULL,NULL,'N',24,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'bhikaji-cama-place'),(28,'',NULL,3,'Bijwasan',NULL,NULL,NULL,'N',25,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'bijwasan'),(29,'',NULL,3,'Central Delhi',NULL,NULL,NULL,'N',26,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'central-delhi'),(30,'',NULL,3,'Chanakya Place',NULL,NULL,NULL,'N',27,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'chanakya-place'),(31,'',NULL,3,'Chanakyapuri',NULL,NULL,NULL,'N',28,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'chanakyapuri'),(32,'',NULL,3,'Chandni Chowk',NULL,NULL,NULL,'N',29,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'chandni-chowk'),(33,'',NULL,3,'Civil Lines',NULL,NULL,NULL,'N',30,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'civil-lines'),(34,'',NULL,3,'Connaught Place',NULL,NULL,NULL,'N',31,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'connaught-place'),(35,'',NULL,3,'Daryaganj',NULL,NULL,NULL,'N',32,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'daryaganj'),(36,'',NULL,3,'Defence Colony',NULL,NULL,NULL,'N',33,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'defence-colony'),(37,'',NULL,3,'Delhi Cantt',NULL,NULL,NULL,'N',34,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'delhi-cantt'),(38,'',NULL,3,'Punjabi Bagh',NULL,NULL,NULL,'N',35,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'punjabi-bagh'),(39,'',NULL,3,'Rama Krishna Puram',NULL,NULL,NULL,'N',36,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rama-krishna-puram'),(40,'',NULL,3,'Rajokri',NULL,NULL,NULL,'N',37,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rajokri'),(41,'',NULL,3,'Rajouri Garden',NULL,NULL,NULL,'N',38,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rajouri-garden'),(42,'',NULL,3,'Ramesh Nagar',NULL,NULL,NULL,'N',39,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'ramesh-nagar'),(43,'',NULL,3,'Rani Bagh',NULL,NULL,NULL,'N',40,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rani-bagh'),(44,'',NULL,3,'Rithala',NULL,NULL,NULL,'N',41,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rithala'),(45,'',NULL,3,'Rohini',NULL,NULL,NULL,'N',42,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rohini'),(46,'',NULL,3,'Sadar Bazar',NULL,NULL,NULL,'N',43,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'sadar-bazar'),(47,'',NULL,3,'Safdarjung',NULL,NULL,NULL,'N',44,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'safdarjung'),(48,'',NULL,3,'Saket',NULL,NULL,NULL,'N',45,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'saket'),(49,'',NULL,3,'Saraswati Vihar',NULL,NULL,NULL,'N',46,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'saraswati-vihar'),(50,'',NULL,3,'Sarita Vihar',NULL,NULL,NULL,'N',47,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'sarita-vihar'),(51,'',NULL,3,'Sarojini Nagar',NULL,NULL,NULL,'N',48,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'sarojini-nagar'),(52,'',NULL,3,'Seemapuri',NULL,NULL,NULL,'N',49,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'seemapuri'),(53,'',NULL,3,'Shadipur',NULL,NULL,NULL,'N',50,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'shadipur'),(54,'',NULL,3,'Kirti Nagar',NULL,NULL,NULL,'N',51,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kirti-nagar'),(55,'',NULL,3,'Lajpat Nagar',NULL,NULL,NULL,'N',52,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'lajpat-nagar'),(56,'',NULL,3,'Laxmi Nagar',NULL,NULL,NULL,'N',53,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'laxmi-nagar'),(57,'',NULL,3,'Lodhi Road',NULL,NULL,NULL,'N',54,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'lodhi-road'),(58,'',NULL,3,'Malviya Nagar',NULL,NULL,NULL,'N',55,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'malviya-nagar'),(59,'',NULL,3,'Mayapuri',NULL,NULL,NULL,'N',56,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'mayapuri'),(60,'',NULL,3,'Mayur Vihar',NULL,NULL,NULL,'N',57,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'mayur-vihar'),(61,'',NULL,3,'Mehrauli',NULL,NULL,NULL,'N',58,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'mehrauli'),(62,'',NULL,3,'Model Town',NULL,NULL,NULL,'N',59,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'model-town'),(63,'',NULL,3,'Moti Nagar',NULL,NULL,NULL,'N',60,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'moti-nagar'),(64,'',NULL,3,'Mundka',NULL,NULL,NULL,'N',61,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'mundka'),(65,'',NULL,3,'Najafgarh',NULL,NULL,NULL,'N',62,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'najafgarh'),(66,'',NULL,3,'Nangloi',NULL,NULL,NULL,'N',63,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'nangloi'),(67,'',NULL,3,'Naraina',NULL,NULL,NULL,'N',64,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'naraina'),(68,'',NULL,3,'Narela',NULL,NULL,NULL,'N',65,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'narela'),(69,'',NULL,3,'Nehru Place',NULL,NULL,NULL,'N',66,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'nehru-place'),(70,'',NULL,3,'New Delhi',NULL,NULL,NULL,'N',67,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'new-delhi'),(71,'',NULL,3,'New Friends Colony',NULL,NULL,NULL,'N',68,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'new-friends-colony'),(72,'',NULL,3,'Nizamuddin',NULL,NULL,NULL,'N',69,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'nizamuddin'),(73,'',NULL,3,'North Delhi',NULL,NULL,NULL,'N',70,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'north-delhi'),(74,'',NULL,3,'North East Delhi',NULL,NULL,NULL,'N',71,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'north-east-delhi'),(75,'',NULL,3,'North West Delhi',NULL,NULL,NULL,'N',72,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'north-west-delhi'),(76,'',NULL,3,'Okhla',NULL,NULL,NULL,'N',73,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'okhla'),(77,'',NULL,3,'Palam',NULL,NULL,NULL,'N',74,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'palam'),(78,'',NULL,3,'Paschim Vihar',NULL,NULL,NULL,'N',75,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'paschim-vihar'),(79,'',NULL,3,'Patel Nagar',NULL,NULL,NULL,'N',76,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'patel-nagar'),(80,'',NULL,3,'Pitampura',NULL,NULL,NULL,'N',77,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'pitampura'),(81,'',NULL,3,'Preet Vihar',NULL,NULL,NULL,'N',78,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'preet-vihar'),(82,'',NULL,3,'Jahangirpuri',NULL,NULL,NULL,'N',79,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'jahangirpuri'),(83,'',NULL,3,'Janakpuri',NULL,NULL,NULL,'N',80,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'janakpuri'),(84,'',NULL,3,'Kailash Colony',NULL,NULL,NULL,'N',81,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kailash-colony'),(85,'',NULL,3,'Kalkaji',NULL,NULL,NULL,'N',82,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kalkaji'),(86,'',NULL,3,'Kamla Nagar',NULL,NULL,NULL,'N',83,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kamla-nagar'),(87,'',NULL,3,'Kanjhawala',NULL,NULL,NULL,'N',84,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kanjhawala'),(88,'',NULL,3,'Kapashera',NULL,NULL,NULL,'N',85,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'kapashera'),(89,'',NULL,3,'Karawal Nagar',NULL,NULL,NULL,'N',86,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'karawal-nagar'),(90,'',NULL,1,'Uttar Pradesh',NULL,NULL,NULL,'N',2,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'uttar-pradesh'),(91,'',NULL,1,'Haryana',NULL,NULL,NULL,'N',3,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'haryana'),(92,'',NULL,91,'Gurgaon',NULL,NULL,NULL,'N',1,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'gurgaon'),(93,'',NULL,91,'Hisar',NULL,NULL,NULL,'N',2,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'hisar'),(94,'',NULL,91,'Jhajjar',NULL,NULL,NULL,'N',3,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'jhajjar'),(95,'',NULL,91,'Karnal',NULL,NULL,NULL,'N',4,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'karnal'),(96,'',NULL,91,'Panipat',NULL,NULL,NULL,'N',5,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'panipat'),(97,'',NULL,91,'Rohtak',NULL,NULL,NULL,'N',6,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'rohtak'),(98,'',NULL,91,'Sonipat',NULL,NULL,NULL,'N',7,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'sonipat'),(99,'',NULL,91,'Faridabad',NULL,NULL,NULL,'N',8,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'faridabad'),(100,'',NULL,91,'Bahadurgarh',NULL,NULL,NULL,'N',9,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'bahadurgarh'),(101,'',NULL,90,'Greater Noida',NULL,NULL,NULL,'N',1,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'greater-noida'),(102,'',NULL,90,'Noida',NULL,NULL,NULL,'N',2,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'noida'),(103,'',NULL,90,'Ghaziabad',NULL,NULL,NULL,'N',3,'Y',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'ghaziabad');

--
-- Table structure for table `manage_services_tbl`
--

CREATE TABLE `manage_services_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` longtext NOT NULL,
  `recvDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `faqOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `category_id` varchar(30) DEFAULT '0',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manage_services_tbl`
--


--
-- Table structure for table `media_tbl`
--

CREATE TABLE `media_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `logo_image` varchar(800) DEFAULT NULL,
  `client_order` int(20) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `media_tbl`
--


--
-- Table structure for table `news_media_tbl`
--

CREATE TABLE `news_media_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `personName` varchar(80) DEFAULT NULL,
  `bannerUrl` text,
  `recvDate` date DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `bannerImage` varchar(500) DEFAULT NULL,
  `alt` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `bannerorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news_media_tbl`
--


--
-- Table structure for table `newsletter_member`
--

CREATE TABLE `newsletter_member` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `snewsletter` char(1) NOT NULL DEFAULT 'N',
  `cnewsletter` char(1) NOT NULL DEFAULT 'N',
  `mType` char(1) NOT NULL DEFAULT 'B',
  `join_date` date NOT NULL DEFAULT '0000-00-00',
  `status` char(2) NOT NULL DEFAULT 'Y',
  `mail_status` char(2) NOT NULL DEFAULT 'N',
  `ip` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsletter_member`
--


--
-- Table structure for table `order_edit_history`
--

CREATE TABLE `order_edit_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(120) NOT NULL,
  `created_at` datetime NOT NULL,
  `old_order` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_edit_history`
--


--
-- Table structure for table `order_item_history`
--

CREATE TABLE `order_item_history` (
  `history_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(111) NOT NULL,
  `created_at` datetime NOT NULL,
  `label` varchar(50) NOT NULL,
  `remarks` text NOT NULL,
  `responcObjects` text NOT NULL,
  PRIMARY KEY (`history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_item_history`
--


--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `order_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(100) NOT NULL,
  `category_id` int(11) NOT NULL,
  `brand` varchar(30) NOT NULL,
  `validity` int(11) NOT NULL,
  `user_type` varchar(150) NOT NULL,
  `organizationType` varchar(150) NOT NULL,
  `quantity` int(11) NOT NULL,
  `token_type` varchar(20) NOT NULL,
  `price_each` decimal(10,2) NOT NULL,
  `delivery_address` tinytext NOT NULL,
  `delivery_city` varchar(111) NOT NULL,
  `delivery_state` varchar(111) NOT NULL,
  `delivery_zip` varchar(8) NOT NULL,
  `delivery_country` varchar(150) NOT NULL,
  `delivery_status` enum('PENDING','INPROCESS','DELIVERED','FAILED','ATTAMPED') NOT NULL,
  `remarks` text NOT NULL,
  `aadhar_file` varchar(150) NOT NULL,
  `pan_file` varchar(150) NOT NULL,
  `ekyc` int(1) NOT NULL,
  `video` int(1) NOT NULL,
  `download` int(1) NOT NULL,
  `dongle_dispatch` varchar(20) NOT NULL,
  PRIMARY KEY (`order_item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_items`
--


--
-- Table structure for table `order_payment_history`
--

CREATE TABLE `order_payment_history` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(50) NOT NULL,
  `payment_invoice_id` varchar(150) NOT NULL,
  `requested_amount` int(11) NOT NULL,
  `tracking_id` varchar(100) NOT NULL,
  `payment_mode` varchar(150) NOT NULL,
  `responceObject` text NOT NULL,
  `created_at` datetime NOT NULL,
  `payment_remark` varchar(150) NOT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_payment_history`
--


--
-- Table structure for table `orders_documents`
--

CREATE TABLE `orders_documents` (
  `docID` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(50) NOT NULL,
  `docName` varchar(150) NOT NULL,
  `docFile` varchar(150) NOT NULL,
  PRIMARY KEY (`docID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders_documents`
--


--
-- Table structure for table `orders_tbl`
--

CREATE TABLE `orders_tbl` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(50) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `product_id` int(11) NOT NULL,
  `user_type` varchar(50) NOT NULL,
  `brand_name` varchar(50) NOT NULL,
  `validity` varchar(15) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `gst_price` decimal(10,2) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `coupan_code` varchar(100) NOT NULL,
  `payment` varchar(20) NOT NULL DEFAULT 'Pending',
  `payment_date` varchar(20) DEFAULT NULL,
  `payment_mode` varchar(50) DEFAULT NULL,
  `order_status` enum('0','1','2','3','4','5') NOT NULL COMMENT '0 = pending, 1 = Success, 2 = Aborted, 3 = Invalid , 4 = Timeout,5= Failure',
  `bill_name` varchar(100) NOT NULL,
  `bill_mobile` varchar(15) NOT NULL,
  `bill_email` varchar(100) NOT NULL,
  `bill_gst` varchar(50) NOT NULL,
  `bill_ogname` varchar(200) NOT NULL,
  `bill_address` varchar(500) NOT NULL,
  `bill_zip` int(6) NOT NULL,
  `bill_city` varchar(50) NOT NULL,
  `bill_state` varchar(50) NOT NULL,
  `bill_country` varchar(50) NOT NULL,
  `token_address` varchar(500) NOT NULL,
  `token_zip` int(6) NOT NULL,
  `token_city` varchar(100) NOT NULL,
  `token_state` varchar(50) NOT NULL,
  `token_country` varchar(50) NOT NULL,
  `dongle_price` decimal(10,2) NOT NULL,
  `bussiness_type` varchar(50) NOT NULL,
  `aadhar_file` varchar(500) DEFAULT NULL,
  `pan_file` varchar(500) DEFAULT NULL,
  `ekyc` int(11) NOT NULL DEFAULT '0',
  `video` int(11) NOT NULL DEFAULT '0',
  `download` int(11) NOT NULL DEFAULT '0',
  `dongle_dispatch` varchar(50) NOT NULL DEFAULT '0',
  `delivered` varchar(50) NOT NULL DEFAULT '0',
  `dis_price` decimal(10,2) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `reciveDate` varchar(20) NOT NULL,
  `order_diliver_date` varchar(20) DEFAULT NULL,
  `updateDate` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`order_id`),
  UNIQUE KEY `invoice_no` (`invoice_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders_tbl`
--


--
-- Table structure for table `photo_tbl`
--

CREATE TABLE `photo_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `description` text,
  `photo_order` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photo_tbl`
--

INSERT INTO `photo_tbl` VALUES (4,NULL,'Waiting Area',NULL,'gallery_67efbae4ef617.jpg',NULL,1,'2025-04-04 10:56:36','2025-04-04 10:56:36'),(5,NULL,'Reception',NULL,'gallery_67efbafa5ad35.jpg',NULL,2,'2025-04-04 10:56:58','2025-04-04 10:56:58'),(6,NULL,'Clinic',NULL,'gallery_67efbb2a0d0dd.jpg',NULL,3,'2025-04-04 10:57:46','2025-04-04 10:57:46'),(7,NULL,'Reception Area',NULL,'gallery_67efbb3e99fa5.jpg',NULL,4,'2025-04-04 10:58:06','2025-04-04 10:58:06'),(8,NULL,'Reception Section',NULL,'gallery_67efbb577dc8f.jpg',NULL,5,'2025-04-04 10:58:31','2025-04-04 10:58:31'),(9,NULL,'Clinic Area',NULL,'gallery_67efbb7871b01.jpg',NULL,6,'2025-04-04 10:59:04','2025-04-04 10:59:04'),(10,NULL,'Rest Area',NULL,'gallery_67efbb924fe10.jpg',NULL,7,'2025-04-04 10:59:30','2025-04-04 10:59:30'),(11,NULL,'Appointment Area',NULL,'gallery_67efbbaf3d660.jpg',NULL,8,'2025-04-04 10:59:59','2025-04-04 10:59:59'),(12,NULL,'Patients',NULL,'gallery_67efbbd2e0bee.jpg',NULL,9,'2025-04-04 11:00:34','2025-04-04 11:00:34'),(13,NULL,'Waiting Room',NULL,'gallery_67efbbede5657.jpg',NULL,10,'2025-04-04 11:01:01','2025-04-04 11:01:01'),(14,NULL,'Modern Clinic Reception',NULL,'gallery_67efbc792864d.jpg',NULL,11,'2025-04-04 11:03:21','2025-04-04 11:03:21'),(15,NULL,'Comfortable Waiting Area',NULL,'gallery_67efbc8f841df.jpg',NULL,12,'2025-04-04 11:03:43','2025-04-04 11:03:43'),(16,NULL,'Clinic Infrastructure Overview',NULL,'gallery_67efbcbcb3f84.jpg',NULL,13,'2025-04-04 11:04:28','2025-04-04 11:04:28'),(17,NULL,'Clinic Interior Design',NULL,'gallery_67efbcdf283a9.jpg',NULL,14,'2025-04-04 11:05:03','2025-04-04 11:05:03'),(18,NULL,'Spacious Waiting Area',NULL,'gallery_67efbd0eed120.jpg',NULL,15,'2025-04-04 11:05:50','2025-04-04 11:05:50'),(19,NULL,'Family-Friendly Waiting Room',NULL,'gallery_67efbd354af99.jpg',NULL,16,'2025-04-04 11:06:29','2025-04-04 11:06:29'),(20,NULL,'Doctor’s Consultation Room',NULL,'gallery_67efbd8d124c9.jpg',NULL,17,'2025-04-04 11:07:57','2025-04-04 11:07:57'),(21,NULL,'Dr. Sushil Goyal',NULL,'gallery_67efbdba2c933.jpg',NULL,18,'2025-04-04 11:08:42','2025-04-04 11:08:42'),(22,NULL,'Dr. Sushil Goyal ( M.B.B.S., F.C.G.P )',NULL,'gallery_67efbdc7d1496.jpg',NULL,19,'2025-04-04 11:08:55','2025-04-04 11:08:55'),(23,NULL,'Awarded Best Laser Centre – GEA 2019',NULL,'gallery_67efbe6b78a02.jpg',NULL,20,'2025-04-04 11:11:39','2025-04-04 11:11:39'),(24,NULL,'Award-Winning Laser Clinic - GEA 2019',NULL,'gallery_67efbe8ae52b7.jpg',NULL,21,'2025-04-04 11:12:10','2025-04-04 11:12:10'),(25,NULL,'Recognized for Excellence in Laser Treatments',NULL,'gallery_67efbea7ccc13.jpg',NULL,22,'2025-04-04 11:12:39','2025-04-04 11:12:39'),(26,NULL,'Excellence in Laser Care – North India’s Best',NULL,'gallery_67efbebd52fe9.jpg',NULL,23,'2025-04-04 11:13:01','2025-04-04 11:13:01'),(27,NULL,'Recognized for Excellence in Laser Treatments - GEA 2019',NULL,'gallery_67efbed4ef1cf.jpg',NULL,24,'2025-04-04 11:13:24','2025-04-04 11:13:24'),(28,NULL,'Top-Rated Laser Centre in North India',NULL,'gallery_67efbee3ab053.jpg',NULL,25,'2025-04-04 11:13:39','2025-04-04 11:13:39');

--
-- Table structure for table `process_tbl`
--

CREATE TABLE `process_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `description` text,
  `photo_order` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `process_tbl`
--


--
-- Table structure for table `product_tbl`
--

CREATE TABLE `product_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_name` varchar(500) DEFAULT NULL,
  `product_code` varchar(700) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_image1` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image2` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image3` varchar(500) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL,
  `product_alt` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_metatitle` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metadesc` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metakeyword` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_cat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prodcut_subcat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_subsubcat` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_specfi` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_video` varchar(150) DEFAULT NULL,
  `product_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_status` int(11) NOT NULL DEFAULT '1',
  `product_finalcat` varchar(600) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_min_order` varchar(400) DEFAULT NULL,
  `product_supply` varchar(600) DEFAULT NULL,
  `product_origin` varchar(600) DEFAULT NULL,
  `product_pterms` varchar(600) DEFAULT NULL,
  `product_price` varchar(600) DEFAULT NULL,
  `product_swearType` varchar(100) DEFAULT NULL,
  `product_supplyType` varchar(100) DEFAULT NULL,
  `product_Gender` varchar(100) DEFAULT NULL,
  `product_ageGroup` varchar(100) DEFAULT NULL,
  `product_size` varchar(100) DEFAULT NULL,
  `catalog` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_tbl`
--


--
-- Table structure for table `safe_business_tbl`
--

CREATE TABLE `safe_business_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `person_city` varchar(1000) DEFAULT NULL,
  `description` longtext NOT NULL,
  `sbtOrder` int(11) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `safe_business_tbl`
--

INSERT INTO `safe_business_tbl` VALUES (1,'Ayan Sharma','Haryana','{companyName} provided excellent fistula treatment. The procedure was fast, nearly painless, and the doctor made everything easy to understand. I recovered quicker than expected and felt truly cared for throughout. If you’re struggling with a fistula, this is the best place to go for permanent relief.',1,'2025-04-02','Y','Amit-Chand040128.png'),(2,'Nishita Rane','Delhi','I booked a consultation for general cosmetology care and was blown away by the results. {companyName} offered a personalized treatment plan that really improved my skin. The clinic is spotless and the staff is professional. I’ve never felt better about my skin. Highly recommend their services!',2,'2025-04-02','Y','Prayga-Sharma040658.png'),(3,'Anika Purohit','','Tried the Hydra Facial Treatment at {companyName} and was amazed. My face felt clean, smooth, and refreshed immediately. The technician explained each step and was gentle throughout. It’s hard to find such good quality care and attention. This facial gave me visible glow. Definitely coming back!',3,'2025-04-04','Y',''),(4,'Mritika Saini','','{companyName} did a fantastic job with my chemical peel. The dermatologist carefully assessed my skin before starting. There was no irritation, and my complexion is brighter and clearer now. They really know what they’re doing, and I always felt safe. Great place for chemical peel treatment.',4,'2025-04-04','Y',''),(5,'Rudrajeet Singh','','After years of discomfort, I finally got piles treatment at {companyName}. The laser procedure was smooth, fast, and totally pain-free. The staff is supportive and explained everything in detail. I recovered quickly and feel so relieved. Can’t thank them enough for the amazing and best results.',5,'2025-04-04','Y',''),(6,'Shubham Trivedi','','{companyName} offers fantastic laser hair removal services. The sessions are quick, the results long-lasting, and the procedure is virtually painless. The staff is experienced and respectful, and the equipment is top-grade. I’m seeing real improvement already. Highly recommended for anyone looking for a professional experience.',6,'2025-04-04','Y','');

--
-- Table structure for table `seo_free_audit_tbl`
--

CREATE TABLE `seo_free_audit_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `heading1` varchar(255) DEFAULT NULL,
  `heading2` varchar(255) DEFAULT NULL,
  `heading3` varchar(500) DEFAULT NULL,
  `button_name` varchar(500) DEFAULT NULL,
  `button_link` varchar(500) DEFAULT NULL,
  `recvDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `seo_free_audit_tbl`
--


--
-- Table structure for table `serviceData_tbl`
--

CREATE TABLE `serviceData_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT NULL,
  `sname` longtext,
  `keywords` longtext,
  `ranking` int(11) DEFAULT NULL,
  `da` varchar(255) DEFAULT NULL,
  `das` varchar(255) DEFAULT NULL,
  `ra` varchar(255) DEFAULT NULL,
  `ras` varchar(255) DEFAULT NULL,
  `bl` varchar(255) DEFAULT NULL,
  `bls` varchar(255) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `image1` varchar(500) DEFAULT NULL,
  `media` varchar(1000) DEFAULT NULL,
  `sorder` int(11) DEFAULT NULL,
  `frmData` varchar(255) DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `serviceData_tbl`
--


--
-- Table structure for table `static_pages`
--

CREATE TABLE `static_pages` (
  `pageID` int(11) NOT NULL AUTO_INCREMENT,
  `pageBanner` varchar(500) DEFAULT NULL,
  `pageImage` varchar(500) DEFAULT NULL,
  `pageTitle` varchar(255) NOT NULL DEFAULT '',
  `pageDesc` text NOT NULL,
  `pageDesc1` longtext NOT NULL,
  `pageDesc2` longtext,
  `pageDesc3` longtext,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `page_metatitle` varchar(500) NOT NULL,
  `page_keyword` varchar(500) NOT NULL,
  `page_metadesc` text NOT NULL,
  `keyword1` varchar(50) DEFAULT NULL,
  `keyword2` varchar(50) DEFAULT NULL,
  `keyword3` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`pageID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `static_pages`
--

INSERT INTO `static_pages` VALUES (1,'banner37.jpg','image37.jpg','Home','','<div class=\"cmTitle\">How Can Advanced Laser Technology Transform Your Health and Well-Being?</div>\r\n\r\n<p>Welcome to {companyName}, the trusted healthcare companion that ensures all your health problems are taken care of by a professional. As <strong>Top Piles Treatment Centre in Delhi</strong>, we offer cutting-edge treatments designed to prioritize your comfort, safety, and long-term health. At our clinic, we realize how piles can be a nuisance, so we try to provide the most individualized treatment plan to each patient according to his or her specific needs. We make the recovery process smooth and hassle-free with our high-end laser technology and our experienced team of professionals. The approach we use here is that every patient, in our opinion, should receive the best form of care. This gives one a variety of treatment options to target the cause of the problem and not just masks it. It doesn&#39;t matter whether it is the first appointment or another follow-up treatment; we strive to offer an inviting atmosphere where your questions are answered. Our goal is to remove the pain, reduce the chances of recurrence, and enable you to get back to control of your life. We make sure that each step of the process is clear, concise, and as comfortable as possible for you.</p>\r\n\r\n<ul>\r\n	<li><strong>Expert Care</strong>: Our medical team is highly experienced in dealing with piles and hemorrhoid conditions.</li>\r\n	<li><strong>Minimal Discomfort</strong>: We make minimal discomfort during a treatment using our advanced laser.</li>\r\n	<li><strong>Faster Recovery</strong>: Minimally invasive techniques, so you quickly recover.</li>\r\n	<li><strong>Guidance Throughout The Treatment Process</strong>: We make the process stress-free for you while providing the appropriate care.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Should You Trust Modern Laser Care for Long-Term Results?</div>\r\n\r\n<h2>Best Advanced Laser Fistula Treatment in India</h2>\r\n\r\n<p>Fistulas, if left untreated, can go on to create long-term problems and have an effect on the quality of life. Our clinic uses the latest laser technology present in the market to make sure that the procedure is fast, effective, and minimally invasive so that the problem is eliminated without requiring a long recovery process. We are proud to offer the <strong>Best Advanced Laser Fistula Treatment in India</strong>, which helps provide relief from the discomfort and complications that come with this condition. The laser treatment method we use delivers precise results. The laser technique treats the fistula area by causing minimal tissue damage while achieving complete fistula treatment. Traditional treatment methods have slower recovery times and higher complication risks but our laser approach produces faster healing and fewer complications. The precise nature of our laser technology enables safe patient treatment that leads to fast recovery and immediate return to pain-free activities. Our clinic provides effective solutions to patients who need treatment for anal fistulas and complex medical conditions.</p>\r\n\r\n<ul>\r\n	<li><strong>Advanced Technology</strong>: The clinic provides exact treatments through modern laser technology under-regulated safety guidelines.</li>\r\n	<li><strong>Faster Recovery</strong>: Our minimally invasive treatment approaches allow patients to heal faster and need less time for recovery.</li>\r\n	<li><strong>High Success Rate</strong>: The treatment methods we use achieve the highest possible success rates during fistula patient treatments.</li>\r\n	<li><strong>Personalised Care</strong>: We tailor each treatment method to your individual needs to achieve your optimal outcomes.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Why Are More Patients Choosing Goyal Piles Laser Centre for Painless Recovery?</div>\r\n\r\n<h3>Best Centre for Piles Laser Treatment in India</h3>\r\n\r\n<p>Our every treatment plan is tailored to meet the individual needs of every patient making for an even safer, more comfortable, and relaxed experience. We are one of the <strong>Best Centre for Piles Laser Treatment in India</strong>. While using advanced laser technology, making it work for fast results, we simultaneously apply empathetic medical attention to our outpatients to present really efficacious treatments. By treating the root cause rather than merely symptomatic treatment, we assure a permanent cure clear of any recurrence. Nationwide, our investment in innovation and patient satisfaction has rightly earned us our reputation.</p>\r\n\r\n<ul>\r\n	<li><strong>Active Laser Technology</strong>: Precision Treatment with Minimal Discomfort and Rapid Healing.</li>\r\n	<li><strong>Well Experienced Specialities</strong>: Skilled Doctors with Depth in Laser-based Anorectal Procedures.</li>\r\n	<li><strong>Personalized Patient Care</strong>: Individualized Treatment Plans According to Each Patient&#39;s Condition and Lifestyle.</li>\r\n	<li><strong>Minimally Invasive</strong>: Quick Recovery and low post operative pain.</li>\r\n</ul>\r\n','','','Y','Top Piles Treatment Centre in Delhi, Best Advanced Laser Fistula Treatment in India','Piles Treatment Centre in Delhi, Advanced Laser Fistula Treatment in Delhi, Top Piles Treatment Centre in Delhi, Best Advanced Laser Fistula Treatment in Delhi, Piles Treatment Centre in India, Advanced Laser Fistula Treatment in India, Top Piles Treatment Centre in India, Best Advanced Laser Fistula Treatment in India','Goyal Laser Centre is one of the Best Piles Treatment Centers in Delhi, Over 30 Years of Experience, Providing Advanced Laser Fistula Treatment in India, Fissure and Piles Treatment at an affordable Price. Enquiry Now','','',''),(2,'banner47.jpg','image47.jpg','About us','Established in the year 1989, {companyName} has been an institution of advance, non-surgical healthcare solutions for over three decades. Under the expert leadership of Dr. Sushil Goyal, a distinguished professional in laser surgery, our centre has a reputation for the highest quality treatment in a humane and patient-centred environment.','<p><strong>Established in the year 1989</strong>, {companyName} has been an institution of advance, non-surgical healthcare solutions for over three decades. Under the expert leadership of <strong>Dr. Sushil Goyal</strong>, a distinguished professional in laser surgery, our centre has a reputation for the highest quality treatment in a humane and patient-centred environment. Our focus has always been on giving the latest and most advanced treatments that are less invasive, offering faster recovery time, fewer risks, and permanent results. In this pursuit of excellence with years of expertise in medical technology, we have made it our objective to innovate and transform the way treatment procedures of piles, fistula, and other intricate disorders are addressed. Our company has gained several accolades over the years. The Global Excellence Award that was received in 2019 recognises our dedication to providing patients with the highest standards of patient care and innovative treatments. As the <strong>Top Non-Surgical Piles Treatment Centre in Delhi, India</strong>, we provide tailored laser-based treatment, focusing on maximum comfort to the patient with the least amount of recovery time.</p>\r\n\r\n<p>Our centre is equipped with the latest technology in laser surgery, ensuring precise treatments that offer better outcomes with minimal discomfort. We believe in the power of advanced medical solutions to provide patients with quick, effective relief, helping them get back to their daily activities as soon as possible. Our focus is on treating the root cause and not the symptoms of whatever health concern is bothering a patient. We work with a culture that transcends trust, transparency, and a huge commitment to educating the patient so they can make proper decisions. Whether you are seeking piles, fistula, or any other condition treatment, we are here to guide you with the best care possible. As we look forward to the future, our company has always strived to maintain the highest standards of care and continue with non-surgical laser treatments, as pioneers in this field. Your health and well-being are our top priorities, and we are here to help you achieve a healthier, happier life.</p>\r\n','','','Y','Top Non-Surgical Piles Treatment Centre in Delhi, India - Goyal Laser Centre','Non-Surgical Piles Treatment Centre in Delhi, Non-Surgical Piles Treatment Centre in India, Top Non-Surgical Piles Treatment Centre in Delhi India, Best Non-Surgical Piles Treatment Centre in Delhi India','Goyal Laser Centre - Top Non-Surgical Piles Treatment Centre in Delhi, India, Providing Advanced Laser Treatment for Piles, Fissure, Fistula & Pilonidal Sinus at a reasonable cost.','','',''),(6,NULL,'image02.jpg','Piles Treatment','','','','','Y','','','','','',''),(7,NULL,'image18.jpg','Fissure Treatment','','','','','Y','','','','','',''),(8,NULL,'image36.jpg','Anal Fistula Treatment','','','','','Y','','','','','',''),(9,NULL,'image47.jpg','Pilonidal Sinus Treatment','','','','','Y','','','','','','');

--
-- Table structure for table `tbl_enquiry`
--

CREATE TABLE `tbl_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(150) DEFAULT NULL,
  `en_org_name` varchar(150) DEFAULT NULL,
  `en_mobile` varchar(100) DEFAULT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_address` tinytext,
  `en_comment` text,
  `enquiry_for` varchar(150) DEFAULT NULL,
  `en_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `system_detail` tinytext,
  `en_zcode` varchar(50) DEFAULT NULL,
  `en_country_name` varchar(500) DEFAULT NULL,
  `en_quantity` varchar(50) DEFAULT NULL,
  `en_country` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_enquiry`
--

INSERT INTO `tbl_enquiry` VALUES (33,'test',NULL,'7011701466',NULL,NULL,'WhatsApp Enquiry',NULL,'2025-08-20 11:19:00','https://www.goyallasercentre.com/contact-us.htm','223.226.84.129',NULL,NULL,NULL,NULL,NULL),(32,'Deepak ',NULL,'9992281824',NULL,NULL,'WhatsApp Enquiry',NULL,'2025-08-15 18:11:00','https://www.goyallasercentre.com/rohtak/?utm_source=chatgpt.com','14.139.224.131',NULL,NULL,NULL,NULL,NULL),(30,'Ayaan khan',NULL,'9717279786','khan2007ayaan@gmail.com',NULL,'I want lazer hair removal of my buts (men) ',NULL,'2025-07-28 12:52:43','https://www.goyallasercentre.com/daryaganj/laser-hair-removal.htm','122.176.194.117',NULL,NULL,NULL,NULL,'Ansari road daryaganj'),(31,'Ashwani Kumar',NULL,'8053715775','ashwani.vjim@gmail.com',NULL,'I have Anal fissure problem and also have internal piles. I want to be operated with a pricedure with minimum recovery time. Kindly suggest the Procedure, Recovery time and also the Cost of operation. ',NULL,'2025-08-05 09:44:11','https://www.goyallasercentre.com/rohtak/piles-treatment.htm','103.206.179.102',NULL,NULL,NULL,NULL,'Bhiwani');

--
-- Table structure for table `tbl_logs`
--

CREATE TABLE `tbl_logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `login_at` varchar(100) DEFAULT NULL,
  `log_details` text,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_logs`
--


--
-- Table structure for table `tbl_redirect_logs`
--

CREATE TABLE `tbl_redirect_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_data` text,
  `session_data` text,
  `remark` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_redirect_logs`
--


--
-- Table structure for table `testimonial_tbl`
--

CREATE TABLE `testimonial_tbl` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `image` varchar(60) NOT NULL,
  `email` varchar(80) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `addedBy` varchar(10) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `replyStatus` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial_tbl`
--


--
-- Table structure for table `tilt_scroller_tbl`
--

CREATE TABLE `tilt_scroller_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(1000) DEFAULT NULL,
  `added_on` date DEFAULT NULL,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `tiltOrder` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tilt_scroller_tbl`
--


--
-- Table structure for table `token_price_tbl`
--

CREATE TABLE `token_price_tbl` (
  `price_id` int(11) NOT NULL AUTO_INCREMENT,
  `pack_name` varchar(50) NOT NULL,
  `min_quantity` int(11) NOT NULL,
  `max_quantity` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `token_id` int(11) NOT NULL,
  PRIMARY KEY (`price_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `token_price_tbl`
--


--
-- Table structure for table `token_tbl`
--

CREATE TABLE `token_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_title` varchar(700) DEFAULT NULL,
  `slink_url` varchar(800) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `token_tbl`
--


--
-- Table structure for table `tutorials_tbl`
--

CREATE TABLE `tutorials_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `subtitle` varchar(200) NOT NULL,
  `link` varchar(200) NOT NULL,
  `thumbnail_img` varchar(200) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tutorials_tbl`
--


--
-- Table structure for table `tutorialspdf_tbl`
--

CREATE TABLE `tutorialspdf_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `pdf_file` varchar(500) NOT NULL,
  `thumbnail_img` varchar(500) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tutorialspdf_tbl`
--


--
-- Table structure for table `video_tbl`
--

CREATE TABLE `video_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_title` varchar(700) DEFAULT NULL,
  `slink_url` varchar(800) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video_tbl`
--

INSERT INTO `video_tbl` VALUES (2,'Goyal Piles Laser Centre Pvt. Ltd.','8oE0KOW_MAM'),(3,'Goyal Piles Laser Centre Pvt. Ltd.','1isfdP9IstM'),(4,'Goyal Piles Laser Centre Pvt. Ltd.','OAugL179Qlk');

--
-- Table structure for table `wps_meta_tags`
--

CREATE TABLE `wps_meta_tags` (
  `meta_id` int(11) NOT NULL AUTO_INCREMENT,
  `is_fixed` enum('Y','N','L','C') NOT NULL DEFAULT 'N',
  `entity_type` varchar(80) DEFAULT NULL,
  `entity_id` int(11) NOT NULL DEFAULT '0',
  `entity_name` varchar(500) DEFAULT NULL,
  `page_url` varchar(500) DEFAULT NULL,
  `page_table` varchar(250) DEFAULT NULL,
  `meta_title` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `meta_description` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `meta_keyword` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `keyword_1` varchar(100) DEFAULT NULL,
  `keyword_2` varchar(100) DEFAULT NULL,
  `keyword_3` varchar(100) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `page_heading` varchar(250) DEFAULT NULL,
  `page_content` text,
  `category_links` varchar(160) DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `page_url` (`page_url`),
  KEY `entity_type` (`entity_type`),
  KEY `entity_id` (`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wps_meta_tags`
--

INSERT INTO `wps_meta_tags` VALUES (1,'N','index/category',1,'category','piles-treatment','category_tbl','Piles Treatment Clinic in Delhi, Piles Treatment Hospital in India','Are you looking for Piles Treatment Clinic in Delhi ? Goyal Laser Centre offers Best Piles Treatment Hospital in India Over 30 Years of Experience Providing Piles Treatment at an affordable Price. Enquiry Now','Piles Treatment Clinic in Delhi, Piles Treatment Hospital in Delhi, Piles Treatment Clinic in India, Piles Treatment Hospital in India','','',NULL,NULL,NULL,NULL,NULL),(2,'N','index/category',2,'category','cosmetology-services','category_tbl','Top Cosmetology Treatment Services in Delhi, Cosmetology Treatment Specialists in India','Are you looking for Top Cosmetology Treatment Services in Delhi ? Goyal Laser Centre offers Best Cosmetology Treatment Specialists in India Over 30 Years of Experience providing Top Cosmetology Treatment Services at an affordable Price. Enquiry Now','Top Cosmetology Treatment Services in Delhi, Cosmetology Treatment Specialists in Delhi, Top Cosmetology Treatment Services in India, Cosmetology Treatment Specialists in India','','',NULL,NULL,NULL,NULL,NULL),(3,'N','index/category',3,'category','fissure-treatment','category_tbl','Fissure Treatment in Delhi, Anal Fissure Treatment in India','Are you looking for Fissure Treatment in Delhi? Goyal Laser Centre offers Best Anal Fissure Treatment in India Over 30 Years of Experience Providing Fissure Treatment at an affordable Price. Enquiry Now','Fissure Treatment in Delhi, Anal Fissure Treatment in Delhi, Top Fissure Treatment in Delhi, Best Anal Fissure Treatment in Delhi, Fissure Treatment in India, Anal Fissure Treatment in India, Top Fissure Treatment in India, Best Anal Fissure Treatment in ','','',NULL,NULL,NULL,NULL,NULL),(4,'N','index/category',4,'category','anal-fistula-treatment','category_tbl','Fistula Treatment in Delhi, Anal Fistula Treatment Center in India','Are you looking for Fistula Treatment in Delhi? Goyal Laser Centre offers Best Anal Fistula Treatment in India Over 30 Years of Experience Providing Fistula Treatment at an affordable Price. Enquiry Now','Fistula Treatment in Delhi, Anal Fistula Treatment in Delhi, Top Fistula Treatment in Delhi, Best Anal Fistula Treatment in Delhi, Fistula Treatment in India, Anal Fistula Treatment in India, Top Fistula Treatment in India, Best Anal Fistula Treatment in ','','',NULL,NULL,NULL,NULL,NULL),(5,'N','index/category',5,'category','pilonidal-sinus-treatment','category_tbl','Pilonidal Sinus Treatment in Delhi, Laser Pilonidal Sinus Treatment Hospital in India','Are you looking for Pilonidal Sinus Treatment in Delhi ? Goyal Laser Centre offers Best Laser Pilonidal Sinus Treatment Hospital in India Over 30 Years of Experience Providing Pilonidal Sinus Treatment at an affordable Price. Enquiry Now','Pilonidal Sinus Treatment in Delhi, Laser Pilonidal Sinus Treatment Hospital in Delhi, Pilonidal Sinus Treatment in India, Laser Pilonidal Sinus Treatment Hospital in India','','',NULL,NULL,NULL,NULL,NULL),(6,'N','index/category',6,'category','laser-hair-removal','category_tbl','Best Laser Hair Removal Treatment in Delhi, Top Laser Hair Removal Clinics in India','Are you looking for Laser Hair Removal Treatment in Delhi? Goyal Laser Centre offers Best Laser Hair Removal Clinics in India Over 30 Years of Experience Providing Laser Hair Removal Treatment at an affordable Price. Enquiry Now','Laser Hair Removal Treatment in Delhi, Laser Hair Removal Clinics in Delhi, Top Laser Hair Removal Treatment in Delhi, Best Laser Hair Removal Clinics in Delhi, Laser Hair Removal Treatment in India, Laser Hair Removal Clinics in India, Top Laser Hair Rem','','',NULL,NULL,NULL,NULL,NULL),(7,'N','index/category',7,'category','chemical-peel-treatment','category_tbl','Chemical Peel Treatment in Delhi, Chemical Peel Treatment In India','Are you looking for Chemical Peel Treatment in Delhi? Goyal Laser Centre offers Best Chemical Peel Treatment in India Over 30 Years of Experience offering customised chemical peel solutions for radiant and rejuvenated skin at an affordable Price. Enquiry ','Chemical Peel Treatment in Delhi, Chemical Peel Treatment in India, Best Doctors For Chemical Peels Treatment In Delhi, Chemical Peel Cost In Delhi,Chemical Peel Cost in India','','',NULL,NULL,NULL,NULL,NULL),(8,'N','index/category',8,'category','hydra-facial-treatment','category_tbl','Hydra Facial Treatment in Delhi, HydraFacial Dermatologist in India','Are you looking for Hydra Facial Treatment in Delhi ? Goyal Laser Centre offers Best HydraFacial Dermatologist in India Over 30 Years of Experience Providing Hydra Facial Treatment at an affordable Price. Enquiry Now','Hydra Facial Treatment in Delhi, HydraFacial Dermatologist in Delhi, Hydra Facial Treatment in India, HydraFacial Dermatologist in India','','',NULL,NULL,NULL,NULL,NULL),(9,'N','index/blog',1,'blog','how-to-find-the-right-piles-treatment-clinic-for-your-needs','blog_tbl','blog of goyal laser centre1','How To Find The Right Piles Treatment Clinic For Your Needs?','How To Find The Right Piles Treatment Clinic For Your Needs?',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'N','index/blog',2,'blog','how-do-doctors-address-pain-and-discomfort-during-fissure-treatment','blog_tbl','How Do Doctors Address Pain And Discomfort During Fissure Treatment?','How Do Doctors Address Pain And Discomfort During Fissure Treatment?','How Do Doctors Address Pain And Discomfort During Fissure Treatment?',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'N','index/market',1,'market','india','location_tbl','India','India','India',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'N','index/market',3,'market','delhi','location_tbl','Delhi','Delhi','Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'N','index/market',4,'market','asola','location_tbl','Asola','Asola','Asola',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'N','index/market',5,'market','alipur','location_tbl','Alipur','Alipur','Alipur',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'N','index/market',6,'market','shalimar-garden','location_tbl','Shalimar Garden','Shalimar Garden','Shalimar Garden',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'N','index/market',7,'market','karol-bagh','location_tbl','Karol Bagh','Karol Bagh','Karol Bagh',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'N','index/market',8,'market','kashmiri-gate','location_tbl','Kashmiri Gate','Kashmiri Gate','Kashmiri Gate',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'N','index/market',9,'market','keshav-puram','location_tbl','Keshav Puram','Keshav Puram','Keshav Puram',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'N','index/market',10,'market','khan-market','location_tbl','Khan Market','Khan Market','Khan Market',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'N','index/market',11,'market','dhaula-kuan','location_tbl','Dhaula Kuan','Dhaula Kuan','Dhaula Kuan',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'N','index/market',12,'market','dilshad-garden','location_tbl','Dilshad Garden','Dilshad Garden','Dilshad Garden',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'N','index/market',13,'market','dwarka','location_tbl','Dwarka','Dwarka','Dwarka',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'N','index/market',14,'market','east-delhi','location_tbl','East Delhi','East Delhi','East Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'N','index/market',15,'market','fateh-nagar','location_tbl','Fateh Nagar','Fateh Nagar','Fateh Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'N','index/market',16,'market','gandhi-nagar','location_tbl','Gandhi Nagar','Gandhi Nagar','Gandhi Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'N','index/market',17,'market','gautam-nagar','location_tbl','Gautam Nagar','Gautam Nagar','Gautam Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'N','index/market',18,'market','geeta-colony','location_tbl','Geeta Colony','Geeta Colony','Geeta Colony',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'N','index/market',19,'market','greater-kailash','location_tbl','Greater Kailash','Greater Kailash','Greater Kailash',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'N','index/market',20,'market','hari-nagar','location_tbl','Hari Nagar','Hari Nagar','Hari Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'N','index/market',21,'market','hauz-khas','location_tbl','Hauz Khas','Hauz Khas','Hauz Khas',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'N','index/market',22,'market','inderlok','location_tbl','Inderlok','Inderlok','Inderlok',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'N','index/market',23,'market','ashok-nagar','location_tbl','Ashok Nagar','Ashok Nagar','Ashok Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'N','index/market',24,'market','baljit-nagar','location_tbl','Baljit Nagar','Baljit Nagar','Baljit Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'N','index/market',25,'market','barakhamba-road','location_tbl','Barakhamba Road','Barakhamba Road','Barakhamba Road',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'N','index/market',26,'market','bawana','location_tbl','Bawana','Bawana','Bawana',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'N','index/market',27,'market','bhikaji-cama-place','location_tbl','Bhikaji Cama Place','Bhikaji Cama Place','Bhikaji Cama Place',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'N','index/market',28,'market','bijwasan','location_tbl','Bijwasan','Bijwasan','Bijwasan',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'N','index/market',29,'market','central-delhi','location_tbl','Central Delhi','Central Delhi','Central Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'N','index/market',30,'market','chanakya-place','location_tbl','Chanakya Place','Chanakya Place','Chanakya Place',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'N','index/market',31,'market','chanakyapuri','location_tbl','Chanakyapuri','Chanakyapuri','Chanakyapuri',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'N','index/market',32,'market','chandni-chowk','location_tbl','Chandni Chowk','Chandni Chowk','Chandni Chowk',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'N','index/market',33,'market','civil-lines','location_tbl','Civil Lines','Civil Lines','Civil Lines',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'N','index/market',34,'market','connaught-place','location_tbl','Connaught Place','Connaught Place','Connaught Place',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'N','index/market',35,'market','daryaganj','location_tbl','Daryaganj','Daryaganj','Daryaganj',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'N','index/market',36,'market','defence-colony','location_tbl','Defence Colony','Defence Colony','Defence Colony',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'N','index/market',37,'market','delhi-cantt','location_tbl','Delhi Cantt','Delhi Cantt','Delhi Cantt',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'N','index/market',38,'market','punjabi-bagh','location_tbl','Punjabi Bagh','Punjabi Bagh','Punjabi Bagh',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'N','index/market',39,'market','rama-krishna-puram','location_tbl','Rama Krishna Puram','Rama Krishna Puram','Rama Krishna Puram',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'N','index/market',40,'market','rajokri','location_tbl','Rajokri','Rajokri','Rajokri',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'N','index/market',41,'market','rajouri-garden','location_tbl','Rajouri Garden','Rajouri Garden','Rajouri Garden',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'N','index/market',42,'market','ramesh-nagar','location_tbl','Ramesh Nagar','Ramesh Nagar','Ramesh Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'N','index/market',43,'market','rani-bagh','location_tbl','Rani Bagh','Rani Bagh','Rani Bagh',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'N','index/market',44,'market','rithala','location_tbl','Rithala','Rithala','Rithala',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'N','index/market',45,'market','rohini','location_tbl','Rohini','Rohini','Rohini',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'N','index/market',46,'market','sadar-bazar','location_tbl','Sadar Bazar','Sadar Bazar','Sadar Bazar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'N','index/market',47,'market','safdarjung','location_tbl','Safdarjung','Safdarjung','Safdarjung',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'N','index/market',48,'market','saket','location_tbl','Saket','Saket','Saket',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'N','index/market',49,'market','saraswati-vihar','location_tbl','Saraswati Vihar','Saraswati Vihar','Saraswati Vihar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'N','index/market',50,'market','sarita-vihar','location_tbl','Sarita Vihar','Sarita Vihar','Sarita Vihar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'N','index/market',51,'market','sarojini-nagar','location_tbl','Sarojini Nagar','Sarojini Nagar','Sarojini Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'N','index/market',52,'market','seemapuri','location_tbl','Seemapuri','Seemapuri','Seemapuri',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'N','index/market',53,'market','shadipur','location_tbl','Shadipur','Shadipur','Shadipur',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'N','index/market',54,'market','kirti-nagar','location_tbl','Kirti Nagar','Kirti Nagar','Kirti Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'N','index/market',55,'market','lajpat-nagar','location_tbl','Lajpat Nagar','Lajpat Nagar','Lajpat Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'N','index/market',56,'market','laxmi-nagar','location_tbl','Laxmi Nagar','Laxmi Nagar','Laxmi Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'N','index/market',57,'market','lodhi-road','location_tbl','Lodhi Road','Lodhi Road','Lodhi Road',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'N','index/market',58,'market','malviya-nagar','location_tbl','Malviya Nagar','Malviya Nagar','Malviya Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'N','index/market',59,'market','mayapuri','location_tbl','Mayapuri','Mayapuri','Mayapuri',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'N','index/market',60,'market','mayur-vihar','location_tbl','Mayur Vihar','Mayur Vihar','Mayur Vihar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'N','index/market',61,'market','mehrauli','location_tbl','Mehrauli','Mehrauli','Mehrauli',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'N','index/market',62,'market','model-town','location_tbl','Model Town','Model Town','Model Town',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'N','index/market',63,'market','moti-nagar','location_tbl','Moti Nagar','Moti Nagar','Moti Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'N','index/market',64,'market','mundka','location_tbl','Mundka','Mundka','Mundka',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'N','index/market',65,'market','najafgarh','location_tbl','Najafgarh','Najafgarh','Najafgarh',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'N','index/market',66,'market','nangloi','location_tbl','Nangloi','Nangloi','Nangloi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'N','index/market',67,'market','naraina','location_tbl','Naraina','Naraina','Naraina',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'N','index/market',68,'market','narela','location_tbl','Narela','Narela','Narela',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'N','index/market',69,'market','nehru-place','location_tbl','Nehru Place','Nehru Place','Nehru Place',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'N','index/market',70,'market','new-delhi','location_tbl','New Delhi','New Delhi','New Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'N','index/market',71,'market','new-friends-colony','location_tbl','New Friends Colony','New Friends Colony','New Friends Colony',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'N','index/market',72,'market','nizamuddin','location_tbl','Nizamuddin','Nizamuddin','Nizamuddin',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'N','index/market',73,'market','north-delhi','location_tbl','North Delhi','North Delhi','North Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'N','index/market',74,'market','north-east-delhi','location_tbl','North East Delhi','North East Delhi','North East Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'N','index/market',75,'market','north-west-delhi','location_tbl','North West Delhi','North West Delhi','North West Delhi',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'N','index/market',76,'market','okhla','location_tbl','Okhla','Okhla','Okhla',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'N','index/market',77,'market','palam','location_tbl','Palam','Palam','Palam',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'N','index/market',78,'market','paschim-vihar','location_tbl','Paschim Vihar','Paschim Vihar','Paschim Vihar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'N','index/market',79,'market','patel-nagar','location_tbl','Patel Nagar','Patel Nagar','Patel Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'N','index/market',80,'market','pitampura','location_tbl','Pitampura','Pitampura','Pitampura',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'N','index/market',81,'market','preet-vihar','location_tbl','Preet Vihar','Preet Vihar','Preet Vihar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'N','index/market',82,'market','jahangirpuri','location_tbl','Jahangirpuri','Jahangirpuri','Jahangirpuri',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'N','index/market',83,'market','janakpuri','location_tbl','Janakpuri','Janakpuri','Janakpuri',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'N','index/market',84,'market','kailash-colony','location_tbl','Kailash Colony','Kailash Colony','Kailash Colony',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'N','index/market',85,'market','kalkaji','location_tbl','Kalkaji','Kalkaji','Kalkaji',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'N','index/market',86,'market','kamla-nagar','location_tbl','Kamla Nagar','Kamla Nagar','Kamla Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'N','index/market',87,'market','kanjhawala','location_tbl','Kanjhawala','Kanjhawala','Kanjhawala',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'N','index/market',88,'market','kapashera','location_tbl','Kapashera','Kapashera','Kapashera',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'N','index/market',89,'market','karawal-nagar','location_tbl','Karawal Nagar','Karawal Nagar','Karawal Nagar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'N','index/market',90,'market','uttar-pradesh','location_tbl','Uttar Pradesh','Uttar Pradesh','Uttar Pradesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'N','index/market',91,'market','haryana','location_tbl','Haryana','Haryana','Haryana',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,'N','index/market',92,'market','gurgaon','location_tbl','Gurgaon','Gurgaon','Gurgaon',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'N','index/market',93,'market','hisar','location_tbl','Hisar','Hisar','Hisar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'N','index/market',94,'market','jhajjar','location_tbl','Jhajjar','Jhajjar','Jhajjar',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'N','index/market',95,'market','karnal','location_tbl','Karnal','Karnal','Karnal',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'N','index/market',96,'market','panipat','location_tbl','Panipat','Panipat','Panipat',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,'N','index/market',97,'market','rohtak','location_tbl','Rohtak','Rohtak','Rohtak',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,'N','index/market',98,'market','sonipat','location_tbl','Sonipat','Sonipat','Sonipat',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,'N','index/market',99,'market','faridabad','location_tbl','Faridabad','Faridabad','Faridabad',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,'N','index/market',100,'market','bahadurgarh','location_tbl','Bahadurgarh','Bahadurgarh','Bahadurgarh',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,'N','index/market',101,'market','greater-noida','location_tbl','Greater Noida','Greater Noida','Greater Noida',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,'N','index/market',102,'market','noida','location_tbl','Noida','Noida','Noida',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'N','index/market',103,'market','ghaziabad','location_tbl','Ghaziabad','Ghaziabad','Ghaziabad',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'N','index/blog',3,'blog','what-can-you-achieve-with-a-professional-chemical-peel-treatment','blog_tbl','What Can You Achieve With A Professional Chemical Peel Treatment?','What Can You Achieve With A Professional Chemical Peel Treatment?','What Can You Achieve With A Professional Chemical Peel Treatment?',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'N','index/blog',4,'blog','how-do-hydrafacial-treatment-doctors-target-your-skin-s-unique-needs','blog_tbl','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?','How Do HydraFacial Treatment Doctors Target Your Skin’s Unique Needs?',NULL,NULL,NULL,NULL,NULL,NULL,NULL);


