Golfschoenen Dames
Golfschoenen voor dames bieden grip, comfort en ondersteuning tijdens elke ronde, met pasvormen die speciaal zijn afgestemd op de vrouwelijke voet. Ze zijn licht, ademend en vaak waterafstotend, zodat je in elk weertype kunt blijven presteren. Bij Jumbo Sports vind je stijlvolle golfschoenen die techniek en uitstraling perfect combineren.
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 (243593, 238896, 238775, 237945, 235770, 235763, 235417, 235409, 224568, 224555, 224510, 222927, 221411, 221397, 219733, 219511, 219483, 218288)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,243593,238896,238775,237945,235770,235763,235417,235409,224568,224555,224510,222927,221411,221397,219733,219511,219483,218288)
