Golftruien Heren
Golftruien voor heren bieden warmte, ademend comfort en volledige bewegingsvrijheid tijdens frisse rondes op de baan. Ze zijn ideaal als tussenlaag en combineren sportieve functionaliteit met een verzorgde uitstraling die past bij elke golfclub. Bij Jumbo Sports vind je truien die je golfspel ondersteunen én je stijl versterken.
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 (244271, 244264, 244243, 244229, 244223, 237278, 230605, 230456, 230434, 230407, 230400, 230392, 230384, 230354, 229680, 229678, 229676, 229655)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,244271,244264,244243,244229,244223,237278,230605,230456,230434,230407,230400,230392,230384,230354,229680,229678,229676,229655)
