Golfkleding
Golfkleding zorgt voor comfort, bewegingsvrijheid en een verzorgde uitstraling op de baan, ongeacht het weer. Bij Jumbo Sports vind je ademende, elastische en stijlvolle kleding voor zowel heren als dames, afgestemd op elk seizoen. Met de juiste outfit speel je met vertrouwen en blijf je comfortabel van de eerste tee tot de laatste putt.
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 (248463, 247516, 244278, 244271, 244264, 244258, 244251, 244236, 244229, 244223, 244217, 244204, 244197, 243968, 243960, 243952, 243950, 243942)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,248463,247516,244278,244271,244264,244258,244251,244236,244229,244223,244217,244204,244197,243968,243960,243952,243950,243942)
