SKATEBOARD BEARINGS

Skate bearings can be used for most applications within the industry, skateboards, scooters, quads, longboards and inlines all use the same sized bearings, some bearings are measured on an ABEC scale ranging from 1 to 11 (in odd numbers) with 11 being the highest precision, however this does not account for the grade of material used which is also very important to the speed of a bearing. 2 bearings are used per wheel with a spacer in the middle. As usual all the best brands can be found at SkateHut.

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 (101359, 136643, 102034, 111497, 111464, 111467, 111500, 111469, 111475, 111466, 111480, 137145, 111502, 137147, 133405, 111478, 111471, 111479, 111476, 111468, 111499, 111489, 111501, 111491))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,101359,136643,102034,111497,111464,111467,111500,111469,111475,111466,111480,137145,111502,137147,133405,111478,111471,111479,111476,111468,111499,111489,111501,111491)
Page