string(635) "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` 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 = '1' WHERE (`e`.`entity_id` IN('32803', '32802', '32801', '32800', '32799', '32798', '32797', '32796', '32795', '32134'))" string(1079) "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` 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 = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) WHERE (`e`.`entity_id` IN('32803', '32802', '32801', '32800', '32799', '32798', '32797', '32796', '32795', '32134')) AND (e.entity_id IN (32134)) ORDER BY FIELD(e.entity_id,32134) " DiscDotUSA

DiscDotUSA

Contact
Reviews
10
Orders
Products
View as Grid List

1 Item

per page
  1. DiscDot Putting Aide
    DiscDot high-visibility disc golf target aide Vivid colors improves focus & reduces eye strain for a maximized practice routine! Instant feedback - find your sweet spot! Improved muscle memory and visualization = fewer missed putts on the course! Classic color DiscDots are bright and UV resistant made to last years of exposure to the elements! UV color DiscDots are infused with UV reactive pigments and glow when exposed to UV (Sunlight and blacklight) - these colors are very vibrant in the sunlight! **Does not Glow-In-The-Dark** Glow-In-The-Dark DiscDots are infused with highly-concentrated Glow-In-The-Dark pigment that charges fast when exposed to UV (Sunlight and blacklight) - great for late night rounds and putting leagues! ** DiscDots fit a variety of chain sizes, however a minimum chain link spacing of 1" (space in between the links the long way) is required to fit a DiscDot. Please measure your chains to ensure proper fitment. DiscDot fits all the most common baskets except some "marksman" style baskets.
    Close
View as Grid List

1 Item

per page