Query
Template: /shared/controllers/racers.cfc:153
Execution Time: 402 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 = 133722
AND enabled = 1
AND (vp.deleted = 0 OR vp.deleted IS NULL)
IDRIDTIDvehNamevehBodyvehTiresvehRadiovehElecvehESCvehMotorvehPowervehCustomChassisvehTypevehFreq1vehFreq2vehFreq3PTNumberRCProNumberenabledshowDetailsvehModeltypeIDvehManCodevehManSitepublicViewsponsorListFirstNameLastNamenickNameemailmyDirectoryvehNitrocitystatecountryimageFileNitrovehicleMakevehicletypeactiveEventCountcoName
113372249653B7RAWRAWSANHITMLNMLNMLN373737011Kyosho Rawspeed Maclan Hitec Bones Motor SportsJJTruaxThe Unicornjtruax773@gmail.comJtruax773BrownsburgINUS0ASC1/10th Scale Electric Buggy1Associated
RCSignup.com - Online registration for R/C Car Races in the United States and around the World

B7 - 1/10th Scale Electric Buggy

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