Query
Template: /shared/controllers/racers.cfc:153
Execution Time: 333 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 = 71388
AND enabled = 1
AND (vp.deleted = 0 OR vp.deleted IS NULL)
IDRIDTIDvehNamevehBodyvehTiresvehRadiovehElecvehESCvehMotorvehPowervehCustomChassisvehTypevehFreq1vehFreq2vehFreq3PTNumberRCProNumberenabledshowDetailsvehModeltypeIDvehManCodevehManSitepublicViewsponsorListFirstNameLastNamenickNameemailmyDirectoryvehNitrocitystatecountryimageFileNitrovehicleMakevehicletypeactiveEventCountcoName
1713882752817rc10gt2STKJCOAIRSAVOSEBLU1/10th Scale Nitro Truck11101GT 217ASChttp://www.teamassociated.com1markbarhambarhammax@hotmail.combarhamrc1mariettaGAUS1ASC1/10th Scale Nitro Truck
RCSignup.com - Online registration for R/C Car Races in the United States and around the World

rc10gt2 - 1/10th Scale Nitro Truck

Equipment
Brand Body Tires Radio Servos ESC Motor Batteries
Associated JConcepts JConcepts Futaba Futaba LRP Reedy Reedy
Photos
Site Sponsors
Featured Events
ROCCK's 10th Annual Disco Brawl - Saturday Jan 4th

Date: 01/03/25 - 01/04/25

2025 JConcepts Offroad Jam

Date: 01/17/25 - 01/19/25

2025 RC Arena New Years Opener

Date: 01/17/25 - 01/18/25

© 2024 RCSignup.com