The official site for Lavera, True Natural & Benecos Organic Cosmetics & Skincare
Shopping Cart $0.00

You have no items in your shopping cart.

True Natural

Featuring only products made in the U.S. or Germany, True Natural skin care is specifically designed to provide effective and innovative skin care with European sensibility and commitment to use only 100% natural and high quality ingredients. The company uses sustainable ingredients and packaging, and certified organic ingredients are used whenever possible. All products are 100% biodegradable and never tested on animals.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, price_index.price AS `indexed_price`, `price_index`.`price`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_price.value_id > 0, at_price.value, at_price_default.value) AS `price`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_bestseller.value_id > 0, at_bestseller.value, at_bestseller_default.value) AS `bestseller` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.category_id = '142' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_entity_decimal` AS `at_price_default` ON (`at_price_default`.`entity_id` = `e`.`entity_id`) AND (`at_price_default`.`attribute_id` = '67') AND `at_price_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_price` ON (`at_price`.`entity_id` = `e`.`entity_id`) AND (`at_price`.`attribute_id` = '67') AND (`at_price`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '93') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '93') AND (`at_visibility`.`store_id` = 1) LEFT JOIN `catalog_product_entity_int` AS `at_bestseller_default` ON (`at_bestseller_default`.`entity_id` = `e`.`entity_id`) AND (`at_bestseller_default`.`attribute_id` = '207') AND `at_bestseller_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_bestseller` ON (`at_bestseller`.`entity_id` = `e`.`entity_id`) AND (`at_bestseller`.`attribute_id` = '207') AND (`at_bestseller`.`store_id` = 1) WHERE (IF(at_price.value_id > 0, at_price.value, at_price_default.value) > 0) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) IN(2, 4)) ORDER BY `bestseller` desc