8 Items

per page
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`.`stock_status` AS `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.website_id = '1' AND price_index.customer_group_id = 0 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')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (457953, 500479, 430141, 430140, 430142, 464052, 430143, 430144))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,457953,500479,430141,430140,430142,464052,430143,430144)
  1. Sale
    S-PHYRE X Glasses

    Shimano S-PHYRE X Glasses

    Was £139.99 From £109.99 (Save 21%)
     
  2. New
    Technium Glasses

    Shimano Technium Glasses

  3. Aerolite Glasses

    Shimano Aerolite Glasses

  4. Spark Glasses

    Shimano Spark Glasses

  5. New
    Tokyo Glasses

    Shimano Tokyo Glasses

  6. Best Seller
    Twinspark Glasses

    Shimano Twinspark Glasses

    From £39.99
     
  7. Sale
    Meteor Glasses

    Shimano Meteor Glasses

    £39.99 £29.99 (Save 25%)
     
  8. Sale
    Square Glasses

    Shimano Square Glasses

    £44.99 £29.99 (Save 33%)