Veld sticks
Een veldhockeystick is onmisbaar voor krachtig en gecontroleerd spel op gras- en watervelden. Bij Jumbo Sports vind je een ruim aanbod sticks in verschillende materialen, krommingen en lengtes, afgestemd op elke speelstijl en elk niveau. Zo speel je altijd met vertrouwen en haal je het maximale uit je spel.
Â
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 (241262, 239600, 239597, 239594, 239591, 239588, 239585, 239582, 239579, 239574, 238690, 238686, 238683, 238680, 238677, 238672, 238667, 238664)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,241262,239600,239597,239594,239591,239588,239585,239582,239579,239574,238690,238686,238683,238680,238677,238672,238667,238664)
