TENSOR TRUCKS

If it’s trucks you’re looking for, there’s a good chance Tensor trucks will fulfil your every skating need. As you will see when looking through them, these trucks are designed for both comfort and style, and they are manufactured using the finest materials and processes possible. This is why they are considered to be some of the best skateboard trucks on the market. There is no doubt that we will have the perfect tensor trucks for you, so be sure to use the search filters at the side if you know exactly what you are looking for.

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 = '1' 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')) 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 (112617, 112618, 112619, 112620, 112622, 112623, 125843, 125844, 125845, 133567, 133568, 133569, 133572, 133573))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,112617,112618,112619,112620,112622,112623,125843,125844,125845,133567,133568,133569,133572,133573)