Query
Template: /shared/controllers/racers.cfc:153
Execution Time: 294 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 = 120756
AND enabled = 1
AND (vp.deleted = 0 OR vp.deleted IS NULL)
IDRIDTIDvehNamevehBodyvehTiresvehRadiovehElecvehESCvehMotorvehPowervehCustomChassisvehTypevehFreq1vehFreq2vehFreq3PTNumberRCProNumberenabledshowDetailsvehModeltypeIDvehManCodevehManSitepublicViewsponsorListFirstNameLastNamenickNameemailmyDirectoryvehNitrocitystatecountryimageFileNitrovehicleMakevehicletypeactiveEventCountcoName
112075652560MBX8R ecoSTKSMKAIRSTKHOWHOWSTKSTK373737713626611YoniBettanyonibettan@gmail.comybettanHod HasharonALILRID_52560_977064.png0MUG1/8th Scale Brushless Offroad Buggy1Mugen Seiki
RCSignup.com - Online registration for R/C Car Races in the United States and around the World

MBX8R eco - 1/8th Scale Brushless Offroad 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