Query
Template: /shared/controllers/racers.cfc:153
Execution Time: 336 ms
Record Count: 3
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 = 53693
AND enabled = 1
AND (vp.deleted = 0 OR vp.deleted IS NULL)
IDRIDTIDvehNamevehBodyvehTiresvehRadiovehElecvehESCvehMotorvehPowervehCustomChassisvehTypevehFreq1vehFreq2vehFreq3PTNumberRCProNumberenabledshowDetailsvehModeltypeIDvehManCodevehManSitepublicViewsponsorListFirstNameLastNamenickNameemailmyDirectoryvehNitrocitystatecountryimageFileNitrovehicleMakevehicletypeactiveEventCountcoName
15369320895486TLR SCTPROJCOFUTSPKHOWTRIVEN1/10th Scale Electric Short Course3737378120611122SCT486LOShttp://www.teamlosi.com1BarryScarboroughBrothergrmm@hotmail.comBscarborough0Villa RicaGAUSRID_20895_692773.jpg0LOS1/10th Scale Electric Short Course
25369320895486TLR SCTPROJCOFUTSPKHOWTRIVEN1/10th Scale Electric Short Course3737378120611122SCT486LOShttp://www.teamlosi.com1BarryScarboroughBrothergrmm@hotmail.comBscarborough0Villa RicaGAUSRID_20895_748432.jpg0LOS1/10th Scale Electric Short Course
35369320895486TLR SCTPROJCOFUTSPKHOWTRIVEN1/10th Scale Electric Short Course3737378120611122SCT486LOShttp://www.teamlosi.com1BarryScarboroughBrothergrmm@hotmail.comBscarborough0Villa RicaGAUSRID_20895_109943.jpg0LOS1/10th Scale Electric Short Course
RCSignup.com - Online registration for R/C Car Races in the United States and around the World

TLR SCT - 1/10th Scale Electric Short Course

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