HORNIT

Our Hornit bike horn selection comes in a vibrant array of colours, and leaves nothing to be desired in terms of volume. They may not sound like a hornet, but these bike horns are guaranteed to let unknowing pedestrians know that you are headed their way. The Hornit dB140 bike horn is actually the world’s loudest bike horn, so it is likely to get every living thing in your path shifting out of your way. The mini bike horns are perfect for children’s bikes and scooters, as they both make sound and light up. What more could a child want?

Loading...
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.customer_group_id = 0 AND price_index.website_id = '5' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (89112, 89113, 89115, 89117, 89118, 89119, 89122, 241382, 89116, 89120, 89121, 241381, 241383, 89114, 238782, 59033, 59035, 59036, 59039, 59040, 59041))) AND (e.created_in <= '1638957602') AND (e.updated_in > '1638957602') ORDER BY FIELD(e.entity_id,89112,89113,89115,89117,89118,89119,89122,241382,89116,89120,89121,241381,241383,89114,238782,59033,59035,59036,59039,59040,59041)