Query
Template: D:\WebSites\fuelWheels.com\tires\queries.cfc
Execution Time: 7.5 ms
Record Count: 5
Cached: No
Lazy: No
SQL:
SELECT ts.intTireSpecID
,ts.intTireID
,ts.intAccountID
,ts.intBrandID
,ts.intTireImageID
,ts.vchrPartNumber
,ts.vchrName
,b.vchrName as brandName
,ts.vchrQuickDraw
,ts.vchrSize
,ts.vchrSideWall
,ts.decDiameter
,ts.decSectWidth
,ts.decAspectRatio
,ts.decDiameterInch
,ts.decWidthInch
,ts.vchrSpeedRating
,ts.chrType
,ts.chrLoadRange
,ts.intLoadIndex
,ts.decWeight
,ts.decHeight
,ts.vchrTreadDepth
,ts.decOverDiameter
,ts.vchrRimRange
,ts.vchrTreadConstruction
,ts.vchrSideConstruction
,ts.decDynomicBalanceOz
,ts.vchrSideWall
,ts.vchrWarranty
,ts.decWidth
,ts.decLenth
,ts.intMaxLoad
,ts.vchrMaxPSI
,ts.dtCreatedUpdated
FROM tbl_TireSpec ts WITH (NOLOCK)
INNER JOIN tbl_brand b ON ts.intBrandID = b.intID
INNER JOIN tbl_brandConfig bc ON bc.intBrandID = b.intID
WHERE ts.intTireID = 3543
AND bc.intConfigID = 404
ORDER BY decDiameter, vchrPartNumber
 intTireSpecIDintTireIDintAccountIDintBrandIDintTireImageIDvchrPartNumbervchrNamebrandNamevchrQuickDrawvchrSizevchrSideWalldecDiameterdecSectWidthdecAspectRatiodecDiameterInchdecWidthInchvchrSpeedRatingchrTypechrLoadRangeintLoadIndexdecWeightdecHeightvchrTreadDepthdecOverDiametervchrRimRangevchrTreadConstructionvchrSideConstructiondecDynomicBalanceOzvchrWarrantydecWidthdecLenthintMaxLoadvchrMaxPSIdtCreatedUpdated
14452263543172540RFTT281000R14GRIPPER R/TFuel Tires28x10-14RBlackwall142810127P10031.100027.96.5-8.52P+2S+1N0 000085520PSI{ts '2021-10-27 10:35:49'}
24452283543172540RFTT301000R14GRIPPER R/TFuel Tires30X10-14RBlackwall143010127P10034.8000306.5-8.52P+2S+1N0 000090020PSI{ts '2021-10-27 10:35:49'}
34452303543172540RFTT321000R14GRIPPER R/TFuel Tires32x10-14RBlackwall143210126P10040.800031.66.5-8.52P+2S+1N0 0000107020PSI{ts '2021-10-27 10:35:49'}
44452293543172540RFTT301000R15GRIPPER R/TFuel Tires30X10-15RBlackwall153010127P10035.4000306.5-8.52P+2S+1N0 000090020PSI{ts '2021-10-27 10:35:49'}
54452273543172540RFTT321000R15GRIPPER R/TFuel Tires32x10-15RBlackwall153210126P10039.500031.66.5-8.52P+2S+1N0 0000105020PSI{ts '2021-10-27 10:35:49'}
GRIPPER R/T UTV - Fuel Off-Road Wheels

  Fuel Tires     Fuel Tires  

GRIPPER R/T UTV

Fuel Tires GRIPPER R/T UTV

28x10-14R
32x10-14R
32x10-15R
DOT APPROVED*

Technical Specifications

Part Number Size Speed Rating Load Range Weight (lb) Tread Depth Max Load Max PSI Overall Diameter Rim Range Tread Construction Side Construction Dynamic Balance (oz) Warranty (miles)
RFTT281000R14 28x10-14R 127P 10 31.10 0 855 20PSI 27.9 6.5-8.5 2P+2S+1N 0 0 0
RFTT301000R14 30X10-14R 127P 10 34.80 0 900 20PSI 30 6.5-8.5 2P+2S+1N 0 0 0
RFTT321000R14 32x10-14R 126P 10 40.80 0 1070 20PSI 31.6 6.5-8.5 2P+2S+1N 0 0 0
RFTT301000R15 30X10-15R 127P 10 35.40 0 900 20PSI 30 6.5-8.5 2P+2S+1N 0 0 0
RFTT321000R15 32x10-15R 126P 10 39.50 0 1050 20PSI 31.6 6.5-8.5 2P+2S+1N 0 0 0

These products can expose you to chemicals including chromium, nickel and lead which are known by the State of California to cause cancer, or birth defects, or other reproductive harm. For more information please visit: www.P65warnings.ca.gov