Hockeypolo's en -shirts kinderen
Hockeyshirts en polo’s voor kinderen bieden comfort, ademend vermogen en bewegingsvrijheid tijdens elke training of wedstrijd. De shirts zijn gemaakt van lichte, duurzame materialen en sluiten goed aan zonder te knellen. Bij Jumbo Sports vind je stijlvolle en functionele modellen voor jonge hockeyers, passend bij elk team en elk seizoen.
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`.`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 = '2'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 23 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
INNER JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (231917, 230176, 230169, 230162, 230155, 230148, 215773, 215766, 215759, 215752, 189445, 189438, 189437, 189436, 187884, 187869, 186479, 186473)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,231917,230176,230169,230162,230155,230148,215773,215766,215759,215752,189445,189438,189437,189436,187884,187869,186479,186473)
