Lifesystems

Lifesystems

The uncompromising values of quality and performance are built into each and every Lifesystems product. Lifesystems first aid kits not only have the best quality contents they also use weather and wear-resistant packs. Our mosquito nets have strong hexagonal mesh and an easy-adjust system. Insect repellents use individually tailored formulae to provide the best protection in different parts of the World.

38 items found

per page
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, 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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` 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 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (477594, 419588, 419558, 419594, 419562, 419580, 419587, 419600, 419592, 419599, 419591, 419556, 419579, 419593, 419560, 419555, 419559, 419561, 419586, 419557, 445041, 445050, 419554, 419585, 444051, 419596, 445029, 444048, 445026, 444039))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,477594,419588,419558,419594,419562,419580,419587,419600,419592,419599,419591,419556,419579,419593,419560,419555,419559,419561,419586,419557,445041,445050,419554,419585,444051,419596,445029,444048,445026,444039)
Page