White Lightning was born out of necessity. Our original goal was to find a way to end the messy inconvenience and performance inefficiencies caused by the dirt, grease, and grime build up on his bicycle chain. White Lightning set out to develop the first and only chain lube that would “self clean”. Clean Ride™ is that product; the original White Lightning chain lube. Clean Ride has become world renown because it actually repels and sheds dirt and grime from the chain and other drivetrain components while you ride.
9 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 (422483, 430875, 428862, 430881, 428834, 422487, 431136, 430388, 428833))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,422483,430875,428862,430881,428834,422487,431136,430388,428833)
