Veldhockeyschoenen heren
Veldhockeyschoenen voor heren zijn ontworpen voor maximale grip, stabiliteit en comfort op elk type kunstgrasveld. Ze ondersteunen explosieve bewegingen en bieden bescherming tijdens intensieve duels. Bij Jumbo Sports vind je topmodellen van topmerken voor scherpe prijzen. Bekijk het assortiment veldhockeyschoenen voor heren op deze pagina.
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 (238495, 238473, 238451, 238429, 238407, 238363, 238348, 220915, 220892, 220869, 220848, 220827, 220804, 220781, 220756, 220733, 220710, 220253)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,238495,238473,238451,238429,238407,238363,238348,220915,220892,220869,220848,220827,220804,220781,220756,220733,220710,220253)
