SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`customized_combo`, `e`.`description`, `e`.`drug_type`, `e`.`drug_type_value`, `e`.`for_concern`, `e`.`for_skin`, `e`.`for_skin_value`, `e`.`free_products`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`howtouse_video_link`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_tag`, `e`.`required_options`, `e`.`short_description`, `e`.`skin_type`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`sub_title`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`volume`, `e`.`weight`, `e`.`weight_type` FROM `tdc_catalog_product_flat_1` AS `e` INNER JOIN `tdc_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(4) AND cat_index.category_id=27 WHERE (e.type_id = 'simple') ORDER BY `cat_index`.`position` ASC
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`customized_combo`, `e`.`description`, `e`.`drug_type`, `e`.`drug_type_value`, `e`.`for_concern`, `e`.`for_skin`, `e`.`for_skin_value`, `e`.`free_products`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`howtouse_video_link`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_tag`, `e`.`required_options`, `e`.`short_description`, `e`.`skin_type`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`sub_title`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`volume`, `e`.`weight`, `e`.`weight_type` FROM `tdc_catalog_product_flat_1` AS `e` INNER JOIN `tdc_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(4) AND cat_index.category_id=28 WHERE (e.type_id = 'simple') ORDER BY `cat_index`.`position` ASC
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`customized_combo`, `e`.`description`, `e`.`drug_type`, `e`.`drug_type_value`, `e`.`for_concern`, `e`.`for_skin`, `e`.`for_skin_value`, `e`.`free_products`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`howtouse_video_link`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_tag`, `e`.`required_options`, `e`.`short_description`, `e`.`skin_type`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`sub_title`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`volume`, `e`.`weight`, `e`.`weight_type` FROM `tdc_catalog_product_flat_1` AS `e` INNER JOIN `tdc_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(4) AND cat_index.category_id=29 WHERE (e.type_id = 'simple') ORDER BY `cat_index`.`position` ASC
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`customized_combo`, `e`.`description`, `e`.`drug_type`, `e`.`drug_type_value`, `e`.`for_concern`, `e`.`for_skin`, `e`.`for_skin_value`, `e`.`free_products`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`howtouse_video_link`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_tag`, `e`.`required_options`, `e`.`short_description`, `e`.`skin_type`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`sub_title`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`volume`, `e`.`weight`, `e`.`weight_type` FROM `tdc_catalog_product_flat_1` AS `e` INNER JOIN `tdc_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(4) AND cat_index.category_id=30 WHERE (e.type_id = 'simple') ORDER BY `cat_index`.`position` ASC
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`customized_combo`, `e`.`description`, `e`.`drug_type`, `e`.`drug_type_value`, `e`.`for_concern`, `e`.`for_skin`, `e`.`for_skin_value`, `e`.`free_products`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`howtouse_video_link`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_tag`, `e`.`required_options`, `e`.`short_description`, `e`.`skin_type`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`sub_title`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`volume`, `e`.`weight`, `e`.`weight_type` FROM `tdc_catalog_product_flat_1` AS `e` INNER JOIN `tdc_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(4) AND cat_index.category_id=31 WHERE (e.type_id = 'simple') ORDER BY `cat_index`.`position` ASC
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`customized_combo`, `e`.`description`, `e`.`drug_type`, `e`.`drug_type_value`, `e`.`for_concern`, `e`.`for_skin`, `e`.`for_skin_value`, `e`.`free_products`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`howtouse_video_link`, `e`.`image`, `e`.`image_label`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_tag`, `e`.`required_options`, `e`.`short_description`, `e`.`skin_type`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`sub_title`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`volume`, `e`.`weight`, `e`.`weight_type` FROM `tdc_catalog_product_flat_1` AS `e` INNER JOIN `tdc_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(4) AND cat_index.category_id=32 WHERE (e.type_id = 'simple') ORDER BY `cat_index`.`position` ASC
Customer Reviews
-
Verified Customer Muneeta Aneja
Best Skincare for Sensitive Skin!
I have sensitive skin and The Derma Co. products didn’t irritate my skin with any side-effects and now I have even skin tone with no active acne on my face and neck area.
- Verified Customer
Priyanshi Jalan
The Derma Co. Changed My Life
Past few months have been stressful and I noticed that my skin was developing dark and uneven spots. I took The Derma Co. free skin test and got a dermatologist regimen in a few seconds. Today I’m almost done with the products and my skin has a radiant glow which proves that it is working!
- Verified Customer
Arshi Bharti
Fast & Visible Results!
This is how my skin looks on day 7 after using the customised skincare products from The Derma Co. Can't wait to see the end results. I'm satisfied with the products and I'm loving my skin’s new and healthy glow.
- Verified Customer
Dr. Mekhala Bawsay
Simply Magical Products
I have seen visible results on a daily basis and my skin looks healthy and nourished. I was suffering from acne issues that have now all disappeared. Thank you so much for the wonder range of products.
- Verified Customer
Polly Ghosh
No Side Effects Anti-Hair Fall Combo
The Anti-Hair Fall Oil has properties of Bhringraj & Onion oil, and it is Mineral oil-free. I used this along with Biotin & Vitamins Capsule every day for 6 weeks, and now my hair fall has considerably reduced. The Derma Co. anti-hair fall care range is amazing, safe & doctor-approved!
