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

You have no items in your shopping cart.

  • Lavera Lipsticks
    Green Brand 2013/2014
    magento_themes-Milano
    Natural Beauty
    since 1987

Lavera

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 = '172' 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) INNER JOIN `catalog_product_index_eav` AS `clearance_idx` ON clearance_idx.entity_id = e.entity_id AND clearance_idx.attribute_id = '175' AND clearance_idx.store_id = 1 AND clearance_idx.value = '276' INNER JOIN `catalog_product_index_eav` AS `certifications_idx` ON certifications_idx.entity_id = e.entity_id AND certifications_idx.attribute_id = '137' AND certifications_idx.store_id = 1 AND certifications_idx.value = '220' 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