Truflo has been producing effective and good value bike pumps for cyclists since the 1980s. All Truflo pumps are strongly constructed and attractively styled and give reliable performance at high pressures and high volumes. You need a dependable pump that will be ready for action when you need it so that the inconvenience of a puncture does not turn into a crisis. The Truflo range offers something for every type of rider and every size of budget.
26 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 (421853, 421846, 421838, 421847, 421844, 421845, 421848, 421850, 421849, 421843, 421856, 421840, 430643, 421839, 421833, 421835, 421834, 499778, 421859, 421863, 421864, 421865, 421857, 421861, 421862, 421860))) AND (e.created_in '1627772401') ORDER BY FIELD(e.entity_id,421853,421846,421838,421847,421844,421845,421848,421850,421849,421843,421856,421840,430643,421839,421833,421835,421834,499778,421859,421863,421864,421865,421857,421861,421862,421860)
