Eb - 1/8th Scale Brushless Offroad Buggy
Site Sponsors
Featured Events
ROCCK's 10th Annual Disco Brawl - Saturday Jan 4th
- ROCCK Racing
- Knoxville, TN, US
Date: 01/03/25 - 01/04/25
Query Template: /shared/controllers/racers.cfc:153 Execution Time: 335 ms Record Count: 1 Cached: No Datasource: rcs_prod Lazy: No SQL: SELECT vp.ID,RID,TID,vehName,vehBody,vehTires,vehRadio,vehElec,vehESC,vehMotor,vehPower,vehCustomChassis,vt.vehType,vehFreq1, vehFreq2,vehFreq3,PTNumber,RCProNumber,enabled,showDetails,vt.vehModel,vt.ID AS typeID,vt.vehManCode, vt.vehType,vt.vehManSite AS vehManSite,rp.publicView,rp.sponsorList, rp.FirstName, rp.LastName, rp.nickName,rp.email,rp.myDirectory,vt.vehNitro, city,state,country,imageFile, CASE WHEN vt.vehNitro IS NOT NULL THEN vt.vehNitro ELSE vtc.nitroPower END as Nitro , CASE WHEN vp.vehicleMake IS NOT NULL THEN vp.vehicleMake ELSE vt.vehManCode END as vehicleMake, CASE WHEN vtc.typeName IS NOT NULL THEN vtc.typeName ELSE vt.vehType END as vehicletype, activeEntries.entryCount as activeEventCount, c.coName FROM vehicleprofile vp LEFT JOIN companies c ON vehicleMake = c.coCode AND coType = 'Chassis' LEFT JOIN vehicletype vt ON vp.TID = vt.ID LEFT JOIN vehicletypecodes vtc on vp.vehTypeCode = vtc.vehTypeID LEFT JOIN vehicletype vt2 ON vp.vehicleMake = vt2.vehManCode AND vehicleMake IS NULL LEFT JOIN ( SELECT count(EID) as entryCount,VID FROM entrylist el JOIN eventprofile ep on el.EID = ep.ID WHERE ep.postDT <= date_sub(now(),interval +1 HOUR) AND ( OpracticeDTS >= date_sub(now(),interval +1 HOUR) OR ep.OpracticeDTS IS NULL ) GROUP BY VID ) activeEntries ON activeEntries.VID = vp.ID INNER JOIN racerprofile rp ON vp.RID = rp.ID LEFT OUTER JOIN userimages ON rp.ID = userimages.UID AND vp.ID = userimages.OID AND userimages.objectType = 'vehicle' AND userimages.defaultImage = 1 WHERE vp.ID = 123915 AND enabled = 1 AND (vp.deleted = 0 OR vp.deleted IS NULL) | ||||||||||||||||||||||||||||||||||||||||||
ID | RID | TID | vehName | vehBody | vehTires | vehRadio | vehElec | vehESC | vehMotor | vehPower | vehCustomChassis | vehType | vehFreq1 | vehFreq2 | vehFreq3 | PTNumber | RCProNumber | enabled | showDetails | vehModel | typeID | vehManCode | vehManSite | publicView | sponsorList | FirstName | LastName | nickName | myDirectory | vehNitro | city | state | country | imageFile | Nitro | vehicleMake | vehicletype | activeEventCount | coName | |||
1 | 123915 | 54257 | Eb | JCO | JCO | SAN | NPR | HOW | HOW | GEN | 37 | 37 | 37 | 6907546 | 1 | 1 | Ryan | Rand | rrand403@gmail.com | rrand | Wilson | NC | US | 0 | TRC | 1/8th Scale Brushless Offroad Buggy | Tekno RC |
Date: 01/03/25 - 01/04/25