Golfschoenen Heren
Bij Jumbo Sports bieden we het meest uitgebreide assortiment golfschoenen voor heren van gerenommeerde merken met topkwaliteit. Of je nu golfschoenen voor de zomer zoekt, met een ander profiel, schoenen met spikes voor het hele jaar door, of speciale wintergolfschoenen, Jumbo Sports heeft ze allemaal.
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 (239107, 238887, 238877, 238867, 238857, 238837, 238827, 238760, 237958, 237935, 237242, 224526, 221444, 219531, 219521, 219493, 219475, 219465)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,239107,238887,238877,238867,238857,238837,238827,238760,237958,237935,237242,224526,221444,219531,219521,219493,219475,219465)
