TSG

For the best in helmets and protective gear, TSG is the brand to go for. Designed by riders, TSG helmets, TSG knee pads, TSG shin pads, elbow pads and wrist guards are all available at SkateHut to give you the best protection when out riding or skating.

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 (131118, 131120, 89318, 89324, 92572, 225140, 225142, 87990, 87991, 89317, 131119, 131124, 87989, 131122, 131123, 89319, 89320, 89321, 89326, 225141, 151411, 151412, 151413, 151414))) AND (e.created_in <= '1638144073') AND (e.updated_in > '1638144073') ORDER BY FIELD(e.entity_id,131118,131120,89318,89324,92572,225140,225142,87990,87991,89317,131119,131124,87989,131122,131123,89319,89320,89321,89326,225141,151411,151412,151413,151414)
Page