Query Template: /tires/queries.cfc:204 Execution Time: 1.71 ms Record Count: 34 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 = 182 AND bc.intConfigID = 404 ORDER BY decDiameter, vchrPartNumber
|
| intTireSpecID | intTireID | intAccountID | intBrandID | intTireImageID | vchrPartNumber | vchrName | brandName | vchrQuickDraw | vchrSize | vchrSideWall | decDiameter | decSectWidth | decAspectRatio | decDiameterInch | decWidthInch | vchrSpeedRating | chrType | chrLoadRange | intLoadIndex | decWeight | decHeight | vchrTreadDepth | decOverDiameter | vchrRimRange | vchrTreadConstruction | vchrSideConstruction | decDynomicBalanceOz | vchrWarranty | decWidth | decLenth | intMaxLoad | vchrMaxPSI | dtCreatedUpdated |
1 | 629331 | 182 | 17 | 254 | 0 | RFNT331250R17 | GRIPPER M/T | Fuel Tires | 33X12.50R17LT | 33X12.50R17LT | Blackwall | 17 | 33 | 12.5 | | | 120Q | | E/10PR | 0 | 32 | 0 | 21 | 33 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 3085 | 65PSI | {ts '2024-01-29 14:39:12'} |
2 | 629361 | 182 | 17 | 254 | 0 | RFNT34575R17 | GRIPPER M/T | Fuel Tires | 345/75R17 | 345/75R17 | Blackwall | 17 | 345 | 75 | | | Q | | | 131 | 83.78 | 0 | 21 | 36.8 | 8.5-11.0 | | | 0 | | 0 | 0 | 4300 | | {ts '2024-01-29 14:39:13'} |
3 | 629332 | 182 | 17 | 254 | 0 | RFNT351250R17 | GRIPPER M/T | Fuel Tires | 35X12.50R17LT | 35X12.50R17LT | Blackwall | 17 | 35 | 12.5 | | | 125Q | | F/12PR | 0 | 34.6 | 0 | 21 | 34.8 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 3640 | 80PSI | {ts '2024-01-29 14:39:12'} |
4 | 629333 | 182 | 17 | 254 | 0 | RFNT371350R17 | GRIPPER M/T | Fuel Tires | 37X13.50R17LT | 37X13.50R17LT | Blackwall | 17 | 37 | 13.5 | | | 131Q | | E/10PR | 0 | 38 | 0 | 21 | 37 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 9 | 0 | 0 | 0 | 4300 | 65PSI | {ts '2024-01-29 14:39:12'} |
5 | 629334 | 182 | 17 | 254 | 0 | RFNT331250R18 | GRIPPER M/T | Fuel Tires | 33X12.50R18LT | 33X12.50R18LT | Blackwall | 18 | 33 | 12.5 | | | 118Q | | E/10PR | 0 | 31.5 | 0 | 21 | 33 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 2910 | 65PSI | {ts '2024-01-29 14:39:12'} |
6 | 629335 | 182 | 17 | 254 | 0 | RFNT351250R18 | GRIPPER M/T | Fuel Tires | 35X12.50R18LT | 35X12.50R18LT | Blackwall | 18 | 35 | 12.5 | | | 123Q | | E/10PR | 0 | 34 | 0 | 21 | 35 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 3415 | 65PSI | {ts '2024-01-29 14:39:12'} |
7 | 629336 | 182 | 17 | 254 | 0 | RFNT331250R20 | GRIPPER M/T | Fuel Tires | 33X12.50R20LT | 33X12.50R20LT | Blackwall | 20 | 33 | 125 | | | 114Q | | E/10PR | 0 | 30.5 | 0 | 21 | 32.8 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 2600 | 65PSI | {ts '2024-01-29 14:39:12'} |
8 | 629350 | 182 | 17 | 254 | 0 | RFNT341250R20 | GRIPPER M/T | Fuel Tires | 34x12.50R20LT | 34x12.50R20LT | Blackwall | 20 | 34 | 12.5 | | | 123Q | | | 0 | 34.5 | 0 | 21 | 33.8 | | | | 0 | | 0 | 0 | 0 | 80PSI | {ts '2024-01-29 14:39:13'} |
9 | 629358 | 182 | 17 | 254 | 0 | RFNT34555R20 | GRIPPER M/T | Fuel Tires | 345/55R20 | 345/55R20 | Blackwall | 20 | 345 | 55 | | | Q | | | 126 | 76.06 | 0 | 21 | 34.8 | 8.5-11.0 | | | 0 | | 0 | 0 | 3750 | | {ts '2024-01-29 14:39:13'} |
10 | 629360 | 182 | 17 | 254 | 0 | RFNT34560R20 | GRIPPER M/T | Fuel Tires | 345/60R20 | 345/60R20 | Blackwall | 20 | 345 | 60 | | | Q | | | 127 | 82.89 | 0 | 21 | 36.8 | 8.5-11.0 | | | 0 | | 0 | 0 | 3860 | | {ts '2024-01-29 14:39:13'} |
11 | 629355 | 182 | 17 | 254 | 0 | RFNT351250R20 | GRIPPER M/T | Fuel Tires | 35X12.50R20LT | 35X12.50R20LT | Blackwall | 20 | 35 | 12.5 | | | 121Q | | E/10PR | 0 | 73 | 0 | 21 | 34.8 | 8.5 - 11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 3195 | 65PSI | {ts '2024-01-29 14:39:13'} |
12 | 629354 | 182 | 17 | 254 | 0 | RFNT351250R20XL | GRIPPER M/T | Fuel Tires | 35X12.50R20LT | 35X12.50R20LT | Blackwall | 20 | 35 | 12.5 | | | 125Q | | F/12PR | 0 | 73.9 | 0 | 21 | 34.8 | 8.5 - 11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 3640 | 80PSI | {ts '2024-01-29 14:39:13'} |
13 | 629337 | 182 | 17 | 254 | 0 | RFNT351350R20 | GRIPPER M/T | Fuel Tires | 35X13.50R20LT | 35X13.50R20LT | Blackwall | 20 | 35 | 13.5 | | | 126Q | | F/12PR | 0 | 34.5 | 0 | 21 | 35 | 8.5-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 3750 | 80PSI | {ts '2024-01-29 14:39:13'} |
14 | 629338 | 182 | 17 | 254 | 0 | RFNT371350R20 | GRIPPER M/T | Fuel Tires | 37x13.50R20LT | 37x13.50R20LT | Blackwall | 20 | 37 | 13.5 | | | 127Q | | E/10PR | 0 | 38.5 | 0 | 21 | 37 | 8.5-11.0 | 3P+2S+2N | 0 | 9 | 0 | 0 | 0 | 3860 | 65PSI | {ts '2024-01-29 14:39:13'} |
15 | 629339 | 182 | 17 | 254 | 0 | RFNT381550R20 | GRIPPER M/T | Fuel Tires | 38X15.50R20LT | 38X15.50R20LT | Blackwall | 20 | 38 | 15.5 | | | 125Q | | D/8PR | 0 | 39.6 | 0 | 21 | 37.7 | 11.0-12.0-14.0 | 3P+2S+2N | 0 | 12 | 0 | 0 | 0 | 3640 | 50PSI | {ts '2024-01-29 14:39:13'} |
16 | 629364 | 182 | 17 | 254 | 0 | RFNT39560R20 | GRIPPER M/T | Fuel Tires | 395/60R20 | 395/60R20 | Blackwall | 20 | 395 | 60 | | | Q | | | 125 | 87.3 | 0 | 21 | 37.7 | 11.0-14.0 | | | 0 | | 0 | 0 | 3640 | | {ts '2024-01-29 14:39:13'} |
17 | 629340 | 182 | 17 | 254 | 0 | RFNT331250R22 | GRIPPER M/T | Fuel Tires | 33X12.50R22LT | 33X12.50R22LT | Blackwall | 22 | 33 | 12.5 | | | 109Q | | E/10PR | 0 | 30 | 0 | 21 | 32.8 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 2270 | 65PSI | {ts '2024-01-29 14:39:13'} |
18 | 629351 | 182 | 17 | 254 | 0 | RFNT341250R22 | GRIPPER M/T | Fuel Tires | 34x12.50R22LT | 34x12.50R22LT | Blackwall | 22 | 34 | 12.5 | | | 121Q | | | 0 | 33.6 | 0 | 21 | 33.8 | | | | 0 | | 0 | 0 | 0 | | {ts '2024-01-29 14:39:13'} |
19 | 629359 | 182 | 17 | 254 | 0 | RFNT34555R22 | GRIPPER M/T | Fuel Tires | 345/55R22 | 345/55R22 | Blackwall | 22 | 345 | 55 | | | Q | | | 123 | 82.67 | 0 | 21 | 36.8 | 8.5-11.0 | | | 0 | | 0 | 0 | 3420 | | {ts '2024-01-29 14:39:13'} |
20 | 629341 | 182 | 17 | 254 | 0 | RFNT351250R22 | GRIPPER M/T | Fuel Tires | 35X12.50R22LT | 35X12.50R22LT | Blackwall | 22 | 35 | 12.5 | | | 117Q | | E/10PR | 0 | 32.5 | 0 | 21 | 35 | 8.5-10.0-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 2835 | 65PSI | {ts '2024-01-29 14:39:13'} |
21 | 629342 | 182 | 17 | 254 | 0 | RFNT371350R22 | GRIPPER M/T | Fuel Tires | 37X13.50R22LT | 37X13.50R22LT | Blackwall | 22 | 37 | 13.5 | | | 123Q | | E/10PR | 0 | 37.5 | 0 | 21 | 37 | 8.5-11.0 | 3P+2S+2N | 0 | 9 | 0 | 0 | 0 | 3420 | 65PSI | {ts '2024-01-29 14:39:13'} |
22 | 629343 | 182 | 17 | 254 | 0 | RFNT381550R22 | GRIPPER M/T | Fuel Tires | 38X15.50R22LT | 38X15.50R22LT | Blackwall | 22 | 38 | 15.5 | | | 124Q | | D/8PR | 0 | 41.5 | 0 | 21 | 38 | 11.0-12.0-14.0 | 3P+2S+2N | 0 | 12 | 0 | 0 | 0 | 3525 | 50PSI | {ts '2024-01-29 14:39:13'} |
23 | 629353 | 182 | 17 | 254 | 0 | RFNT331250R24 | GRIPPER M/T | Fuel Tires | 33x12.50R24LT | 33x12.50R24LT | Blackwall | 24 | 33 | 12.5 | | | 106Q | | | 0 | 32.2 | 0 | 21 | 32.8 | | | | 0 | | 0 | 0 | 0 | | {ts '2024-01-29 14:39:13'} |
24 | 629352 | 182 | 17 | 254 | 0 | RFNT341250R24 | GRIPPER M/T | Fuel Tires | 34x12.50R24LT | 34x12.50R24LT | Blackwall | 24 | 34 | 12.5 | | | 116Q | | | 0 | 33.3 | 0 | 21 | 33.8 | | | | 0 | | 0 | 0 | 0 | | {ts '2024-01-29 14:39:13'} |
25 | 629357 | 182 | 17 | 254 | 0 | RFNT34545R24 | GRIPPER M/T | Fuel Tires | 345/45R24 | 345/45R24 | Blackwall | 24 | 345 | 45 | | | Q | | | 120 | 78.93 | 0 | 21 | 36.7 | 8.5-11.0 | | | 0 | | 0 | 0 | 3085 | | {ts '2024-01-29 14:39:13'} |
26 | 629345 | 182 | 17 | 254 | 0 | RFNT351350R24 | GRIPPER M/T | Fuel Tires | 35X13.50R24LT | 35X13.50R24LT | Blackwall | 24 | 35 | 13.5 | | | 118Q | | E/10PR | 0 | 33.5 | 0 | 21 | 34.7 | 8.5-11.0 | 3P+2S+2N | 0 | 7.5 | 0 | 0 | 0 | 2910 | 65PSI | {ts '2024-01-29 14:39:13'} |
27 | 629346 | 182 | 17 | 254 | 0 | RFNT371350R24 | GRIPPER M/T | Fuel Tires | 37X13.50R24LT | 37X13.50R24LT | Blackwall | 24 | 37 | 13.5 | | | 120Q | | E/10PR | 0 | 35.8 | 0 | 21 | 36.7 | 8.5-11.0 | 3P+2S+2N | 0 | 9 | 0 | 0 | 0 | 3085 | 65PSI | {ts '2024-01-29 14:39:13'} |
28 | 629363 | 182 | 17 | 254 | 0 | RFNT39550R24 | GRIPPER M/T | Fuel Tires | 395/50R24 | 395/50R24 | Blackwall | 24 | 395 | 50 | | | P | | | 128 | 108.03 | 0 | 21 | 39.7 | 11.0-14.0 | | | 0 | | 0 | 0 | 3970 | | {ts '2024-01-29 14:39:13'} |
29 | 629344 | 182 | 17 | 254 | 0 | RFNT401550R24 | GRIPPER M/T | Fuel Tires | 40X15.50R24LT | 40X15.50R24LT | Blackwall | 24 | 40 | 15.5 | | | 128P | | E/10PR | 0 | 49 | 0 | 21 | 39.7 | 11.0-12.0-14.0 | 3P+2S+2N | 0 | 12 | 0 | 0 | 0 | 3970 | 65PSI | {ts '2024-01-29 14:39:13'} |
30 | 629356 | 182 | 17 | 254 | 0 | RFNT34540R26 | GRIPPER M/T | Fuel Tires | 345/40R26 | 345/40R26 | Blackwall | 26 | 345 | 40 | | | Q | | | 117 | 79.81 | 0 | 21 | 36.8 | 9.5-12.0 | | | 0 | | 0 | 0 | 2835 | | {ts '2024-01-29 14:39:13'} |
31 | 629347 | 182 | 17 | 254 | 0 | RFNT371350R26 | GRIPPER M/T | Fuel Tires | 37X13.50R26LT | 37X13.50R26LT | Blackwall | 26 | 37 | 13.5 | | | 117Q | | F/12PR | 0 | 36.2 | 0 | 21 | 37 | 9.5-11.0-12.0 | 3P+2S+2N | 0 | 9 | 0 | 0 | 0 | 2385 | 80PSI | {ts '2024-01-29 14:39:13'} |
32 | 629362 | 182 | 17 | 254 | 0 | RFNT39545R26 | GRIPPER M/T | Fuel Tires | 395/45R26 | 395/45R26 | Blackwall | 26 | 395 | 45 | | | P | | | 127 | 102.74 | 0 | 21 | 39.7 | 11.0-14.0 | | | 0 | | 0 | 0 | 3860 | | {ts '2024-01-29 14:39:13'} |
33 | 629348 | 182 | 17 | 254 | 0 | RFNT401550R26 | GRIPPER M/T | Fuel Tires | 40X15.50R26LT | 40X15.50R26LT | Blackwall | 26 | 40 | 15.5 | | | 127P | | E/10PR | 0 | 46.6 | 0 | 21 | 39.7 | 11.0-12.0-14.0 | 3P+2S+2N | 0 | 12 | 0 | 0 | 0 | 3860 | 65PSI | {ts '2024-01-29 14:39:13'} |
34 | 629349 | 182 | 17 | 254 | 0 | RFNT401650R28 | GRIPPER M/T | Fuel Tires | 40X16.50R28LT | 40X16.50R28LT | Blackwall | 28 | 40 | 16.5 | | | 126P | | E/10PR | 0 | 46.6 | 0 | 21 | 39.7 | 13.0-14.0-16.0 | 3P+2S+2N | 0 | 12 | 0 | 0 | 0 | 3750 | 80PSI | {ts '2024-01-29 14:39:13'} |