Verzorging golfschoenen
Goede verzorging van je golfschoenen is belangrijk en vaak een ondergeschoven kindje. Toch kun je door goede verzorgingmiddelen te gebruiken je golfschoenen een langere levensduur meegeven. Bij Jumbo Sports hebben we diverse middelen die je schoenen beschermen tegen weersinvloeden en zorgen dat je langer van je golfschoenen kunt genieten.
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 (170562, 142663, 141903, 141902, 117169)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,170562,142663,141903,141902,117169)
