K2

The K2 Skate mission is to create unforgettable products that will assist consumers in creating unforgettable skating experiences. Inline skaters need reliable, intuitive, cool products in all sizes for all ability levels. K2 Skates offer adjustable that can grow with your children, beginner level inline skates and comfortable, durable plastic protection pads.

Loading...
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.customer_group_id = 0 AND price_index.website_id = '1' 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')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (153152, 153153, 153154, 153185, 153186, 158514, 167845, 167848, 167851, 173826, 173828, 173829, 173830, 173832))) AND (e.created_in <= '1638698403') AND (e.updated_in > '1638698403') ORDER BY FIELD(e.entity_id,153152,153153,153154,153185,153186,158514,167845,167848,167851,173826,173828,173829,173830,173832)