Veldhockeyschoenen dames
Veldhockeyschoenen voor dames zijn ontworpen voor maximale grip, stabiliteit en comfort op zand- en watervelden. Met topmerken en scherpe prijzen kies je uit modellen die passen bij jouw speelstijl en ondergrond. Bij Jumbo Sports vind je altijd het perfecte paar veldhockeyschoenen dat jouw prestaties ondersteunt.
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 (240236, 240219, 239993, 239972, 238807, 238786, 238495, 238473, 238451, 238429, 238407, 238392, 238378, 234545, 234490, 234489, 234488, 222016)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,240236,240219,239993,239972,238807,238786,238495,238473,238451,238429,238407,238392,238378,234545,234490,234489,234488,222016)
