SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (2918, 2952, 17319, 15856, 13660, 11930, 2943)) AND (t_d.attribute_id IN ('179', '93', '146', '131', '128', '171', '159', '83', '149', '148', '151', '91', '117', '120', '115', '150', '121', '155', '118', '172', '175', '177', '134', '156', '99', '119', '154', '153')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (2918, 2952, 17319, 15856, 13660, 11930, 2943)) AND (t_d.attribute_id IN ('81', '145', '98', '122', '77', '170', '78', '176', '92', '137', '135', '136', '82')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (2918, 2952, 17319, 15856, 13660, 11930, 2943)) AND (t_d.attribute_id IN ('114', '100', '116', '96', '132', '87', '109', '130', '158', '86', '84', '123', '73', '106', '104', '129', '88', '110', '173', '174', '138', '133', '89', '111', '126', '127')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (2918, 2952, 17319, 15856, 13660, 11930, 2943)) AND (t_d.attribute_id IN ('101', '102', '157', '94', '95', '79', '80')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (2918, 2952, 17319, 15856, 13660, 11930, 2943)) AND (t_d.attribute_id IN ('103', '75', '85', '147', '76', '152')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))
Sunsilk Treatment Mask 250ml Damage Restore
FREE DELIVERY ABOVE $85. NO SAME DAY SELF-COLLECT. ALL ORDERS: UP TO 7 WORKING DAYS TO PROCESS.
Intensive Treatment Mask that penetrates deep into the hair to replace lost protein and restore hair for total reconstruction.
Directions: Massage to hair from mid-length to the ends. Avoid applying onto the scalp and leave on for 3 minutes. Rinse off thoroughly. Use at least once a week.
Write Your Own Review
Customer Reviews
Repeat buyer. Item received nicely in bubble wrapped to prevent denting. Fast delivery also.
Value
100%
Repeat buyer. Item received nicely in bubble wrapped to prevent denting. Fast delivery also.
Review bylee***
Posted on
Delivery is quite fast...price also cheaper than outside...worth to buy
Value
100%
Delivery is quite fast...price also cheaper than outside...worth to buy
Review byoct***
Posted on
Fats delivery and items are bubbled wrapped
Value
100%
Fats delivery and items are bubbled wrapped
Review byluv***
Posted on
Fast delivery good buy
Value
100%
Fast delivery good buy
Review byshe***
Posted on
This is a very trustworthy seller
Value
100%
This is a very trustworthy seller
Review bywoo***
Posted on
Satisfied!
Value
100%
Items came well packed in a box and bubble wrapped. Even came with a free gift! Delivery was really fast too, thank you seller!