Query Template: /tires/queries.cfc:204 Execution Time: 0.733 ms Record Count: 4 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 = 3949 AND bc.intConfigID = 404 ORDER BY decDiameter, vchrPartNumber
|