Balmarkeringen
Bij Jumbo Sports tref je een gevarieerd assortiment praktische accessoires om je golfbal te voorzien van een (persoonlijke) markering. Hierdoor kun je jouw bal gemakkelijk herkennen en helpen markeringen, zoals bijvoorbeeld een lijn, je nauwkeurig uit te lijnen voor putts op de green.
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 (72390, 32893, 32845, 32846, 32828, 32830, 32831, 32832, 32834, 32836, 32829)) AND (stock_status_index.is_salable = 1) ORDER BY FIELD(e.entity_id,72390,32893,32845,32846,32828,32830,32831,32832,32834,32836,32829)
