SELECT * FROM Race WHERE RaceID=;OUTPUT NIL SELECT OfficeName FROM Office WHERE OfficeID=;OUTPUT NIL SELECT Name CName FROM Container WHERE ContainerID=;OUTPUT NIL SELECT ContainerID RaceCountry,Category ConCat,ParentLink ConP FROM Container WHERE ContainerID=;OUTPUT FindCountry SELECT RaceID LastRaceID FROM Race WHERE ParentContainer= AND TakeOffice < AND TakesSeat='Y' ORDER BY TakeOffice DESC LIMIT 1;OUTPUT NIL SELECT RaceID NextRaceID FROM Race WHERE ParentContainer= AND TakeOffice > AND TakesSeat='Y' ORDER BY TakeOffice ASC LIMIT 1;OUTPUT NIL ='Y'> SELECT CandidateLink IncumbentID,PartyLink IncumbentPartyID FROM RaceMember WHERE RaceLink= and Won='Y' ORDER BY FinalVoteTotal;OUTPUT SetIncumbent
   - Edit Candidates
SELECT SecLink FROM Security WHERE SecLink=62 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=63 AND UserLink=;OUTPUT NIL ne ''> ='Y'>. SELECT DISTINCT r.AttachID CanData FROM Poll as p, PollResult as r where p.AttachTo='Race' and p.AttachID= and r.ParentPoll=p.PollID and r.AttachTo='Candidate';OUTPUT CHasData SELECT DISTINCT CandidateLink CanData FROM Endorsement where RaceLink=;CHasData SELECT RaceID GenRaceID FROM Race WHERE ParentContainer= AND OfficeLink= AND PollStart > ORDER BY TakeOffice,PollEnd LIMIT 1;OUTPUT NIL SELECT DISTINCT r.AttachID CanData FROM Poll as p, PollResult as r where p.AttachTo='Race' and p.AttachID= and r.ParentPoll=p.PollID and r.AttachTo='Candidate';OUTPUT CHasData DELETE FROM Leaning WHERE RaceLink= AND CandidateLink=;OUTPUT NIL DELETE FROM Prediction WHERE RaceLink= AND CandidateLink=;OUTPUT NIL DELETE FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL DELETE FROM RaceSub WHERE RaceLink= AND CandidateLink=;OUTPUT NIL UPDATE RaceMember SET PartyLink= WHERE RaceLink= AND CandidateLink=;FINISH SELECT COUNT(*) NumCRace FROM RaceMember WHERE CandidateLink=;OUTPUT NIL UPDATE Candidate SET PartyLink= WHERE CandidateID=;FINISH SELECT MAX(RoundNum)+1 BallotNum FROM RaceMemberRound WHERE RaceLink=;OUTPUT NIL SELECT CandidateLink,PartyLink FROM RaceMember WHERE RaceLink= LIMIT 1;OUTPUT NIL INSERT INTO RaceMemberRound (RoundVotes,RaceLink,CandidateLink,PartyLink,RoundNum) values (0,,,,);FINISH INSERT INTO RaceMemberFusion (PartyLink,RaceLink,CandidateLink) values (,,);FINISH DELETE FROM RaceMemberFusion WHERE RaceMemberFusionID=;FINISH UPDATE RaceMember SET PrimaryFECC= WHERE RaceLink= AND CandidateLink=;FINISH SELECT COUNT(*) RMCnt FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL SELECT RaceID TRID FROM RaceMember as m JOIN Race as r ON RaceID=RaceLink WHERE m.CandidateLink= AND m.Won='Y' AND r.TermEnd= AND TakesSeat='Y' AND OfficeLink= LIMIT 1;OUTPUT NIL SELECT PartyLink PLink FROM Candidate WHERE CandidateID=;OUTPUT NIL INSERT INTO RaceMember (RaceLink,CandidateLink,PartyLink,Incumbent,WriteIn,EntryDate) VALUES (,,,,,);OUTPUT NIL UPDATE Race SET LMBy=,LastModified= WHERE RaceID=;OUTPUT NIL SELECT COUNT(*) RMCnt FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL UPDATE RaceMember SET CandidateLink=,Incumbent=,WriteIn= WHERE RaceLink= AND CandidateLink=;OUTPUT NIL UPDATE RaceSub SET CandidateLink= WHERE RaceLink= AND CandidateLink=;OUTPUT NIL UPDATE Leaning SET CandidateLink= WHERE CandidateLink= AND RaceLink=;OUTPUT NIL UPDATE Prediction SET CandidateLink= WHERE CandidateLink= AND RaceLink=;OUTPUT NIL UPDATE Endorsement SET CandidateLink= WHERE CandidateLink= AND RaceLink=;OUTPUT NIL UPDATE PollResult SET AttachID= WHERE ParentPoll= AND AttachTo='Candidate' AND AttachID=;OUTPUT NIL SELECT PollID TPLID FROM Poll WHERE AttachTo='Race' AND AttachID=;OUTPUT RepEachPoll UPDATE Race SET LMBy=,LastModified= WHERE RaceID=;OUTPUT NIL
RACE DETAILS eq ) || (+0 > 200) || ( eq 'Y')>
Parent Race
Office
Type
Polls Close > , - :

eq 'Y'> eq 'Y' || $in{MaxWinners} > 1) && ,SQL> eq 'Y'>=> $in{'FinalVoteTotal'.$in{CID}}=~s/\,//g; UPDATE RaceMember SET EntryDate=,SQL>,EntryURI=,SQL>,DropoutDate=,SQL>,DropURI=,SQL>,WriteIn=,SQL>,BallotName=,SQL>,CampaignSite=,SQL>, Incumbent=,SQL>,FinalVoteTotal=,SQL>,Won=,SQL> WHERE RaceLink= AND CandidateLink=;OUTPUT NIL INSERT INTO RaceVoteHistory (RaceLink,CandidateLink,PartyLink,UpdateTime,FinalVoteTotal,Won) VALUES (,,,Now(),,F%d>,,F%d>);FINISH UPDATE RaceMember SET Incumbent='Y' WHERE RaceLink= AND CandidateLink=;FINISH $res=`mkdir $in{BIDIR}/campaignlogo/b$in{CPhotoBlock}`; $res=`chmod 0777 $in{BIDIR}/campaignlogo/b$in{CPhotoBlock}`; /campaignlogo/b/Full,FILE_DATA_clogo> /campaignlogo/b/,FILE_DATA_clogo> $res=`mogrify -geometry 150X150 $in{BIDIR}/candidates/b$in{CPhotoBlock}/$in{TPhoto}`; $res=`mogrify -unsharp 1X1000 $in{BIDIR}/candidates/b$in{CPhotoBlock}/$in{TPhoto}`; SELECT FECCommitteeID FROM FECCommittee WHERE FECID=,SQL>;OUTPUT NIL INSERT INTO FECCommittee (FECID) VALUES (,SQL>);FINISH UPDATE RaceMember SET PrimaryFECC= WHERE RaceLink= AND CandidateLink=;FINISH ":",Safe>",'> SELECT CandidateLink CID,PartyLink CPL,FinalVoteTotal CFVT FROM RaceMember WHERE RaceLink=;OUTPUT UPDATE RaceMember SET Won='' WHERE RaceLink=;OUTPUT NIL UPDATE RaceMember SET Won='Y' WHERE RaceLink= AND (CandidateLink= OR CandidateLink=);OUTPUT NIL SELECT RoundVotes ORV FROM RaceMemberRound WHERE RaceLink= AND CandidateLink= AND RoundNum= AND PartyLink=;OUTPUT NIL INSERT INTO RaceMemberRound (RoundVotes,RaceLink,CandidateLink,PartyLink,RoundNum) values (C,F%d>,,,,);FINISH UPDATE RaceMemberRound SET RoundVotes=C,F%d> WHERE RaceLink= AND CandidateLink= AND RoundNum= AND PartyLink=;FINISH DELETE FROM RaceMemberRound WHERE RaceLink= AND CandidateLink= AND RoundNum= AND PartyLink=;FINISH SELECT CandidateLink CID,PartyLink PLink FROM RaceMember WHERE RaceLink=;OUTPUT BRoundCan SELECT DISTINCT RoundNum FROM RaceMemberRound WHERE RaceLink= ORDER BY RoundNum DESC;OUTPUT BRound UPDATE RaceMemberFusion SET FusionVotes=,F%d> WHERE RaceMemberFusionID=;FINISH SELECT RaceMemberFusionID RMFID FROM RaceMemberFusion WHERE RaceLink=;OUTPUT SELECT CandidateLink,FinalVoteTotal FROM RaceMember WHERE RaceLink= AND Won='Y' ORDER BY FinalVoteTotal DESC LIMIT 1;OUTPUT NIL SELECT FinalVoteTotal SecPlace FROM RaceMember WHERE RaceLink= AND CandidateLink != ORDER BY FinalVoteTotal DESC LIMIT 1;OUTPUT NIL SELECT SUM(FinalVoteTotal) AllVote FROM RaceMember WHERE RaceLink=;OUTPUT NIL UPDATE Race SET DataSources=,OfficialCert=,Precincts=,RPrecincts=,Winner=,Winner2=,WinVotes=,SecondVotes=,AllVotes=,OverVotes=,UnderVotes= WHERE RaceID=;OUTPUT NIL
Saved Changes.
SELECT PartyLink WinParty,Incumbent WInc,EntryDate WEntry,WriteIn WWI,CampaignSite WCSt,PrimaryFECC WFEC FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL SELECT RaceID GElec FROM Race WHERE ParentContainer= AND Type='General Election' AND PollStart > ORDER BY PollStart LIMIT 1;OUTPUT NIL UPDATE RaceMember SET CandidateLink=,Incumbent=,EntryDate=,WriteIn=,CampaignSite=,PrimaryFECC= WHERE CandidateLink=3155 AND RaceLink=;OUTPUT NIL UPDATE Leaning SET CandidateLink= WHERE CandidateLink=3155 AND RaceLink=;OUTPUT NIL UPDATE Prediction SET CandidateLink= WHERE CandidateLink=3155 AND RaceLink=;OUTPUT NIL UPDATE Endorsement SET CandidateLink= WHERE CandidateLink=3155 AND RaceLink=;OUTPUT NIL UPDATE RaceMember SET CandidateLink=,Incumbent=,EntryDate=,WriteIn=,CampaignSite=,PrimaryFECC= WHERE CandidateLink=3156 AND RaceLink=;OUTPUT NIL UPDATE Leaning SET CandidateLink= WHERE CandidateLink=3156 AND RaceLink=;OUTPUT NIL UPDATE Prediction SET CandidateLink= WHERE CandidateLink=3156 AND RaceLink=;OUTPUT NIL UPDATE Endorsement SET CandidateLink= WHERE CandidateLink=3156 AND RaceLink=;OUTPUT NIL UPDATE RaceMember SET CandidateLink=,Incumbent=,EntryDate=,WriteIn=,CampaignSite=,PrimaryFECC= WHERE CandidateLink=3157 AND RaceLink=;OUTPUT NIL UPDATE Leaning SET CandidateLink= WHERE CandidateLink=3157 AND RaceLink=;OUTPUT NIL UPDATE Prediction SET CandidateLink= WHERE CandidateLink=3157 AND RaceLink=;OUTPUT NIL UPDATE Endorsement SET CandidateLink= WHERE CandidateLink=3157 AND RaceLink=;OUTPUT NIL UPDATE Race SET LMBy=,LastModified= WHERE RaceID=;OUTPUT NIL SELECT CandidateID CID,FirstName,LastName,BallotName,CampaignSite,RaceMember.PartyLink,PrimaryFECC,WriteIn,Photo,FinalVoteTotal,Abbr PName,EntryDate,EntryURI,DropoutDate,DropURI,Won,Incumbent FROM RaceMember,Candidate,Party WHERE RaceLink= AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink ORDER BY Won DESC,FinalVoteTotal DESC,DropoutDate!='0000-00-00',EntryDate='0000-00-00',Incumbent DESC,WriteIn,RaceMember.PartyLink!=,Party.Priority DESC,LastName;>+1> =$in{Photo}>=$in{Incumbent}>=$in{WriteIn}>=$in{FirstName}> =$in{LastName}>=$in{BallotName}>=$in{CampaignSite}>=$in{PartyLink}>=$in{EntryDate}>=$in{EntryURI}> =$in{DropoutDate}>=$in{DropURI}>=$in{FinalVoteTotal}>=$in{PName}>=$in{Won}> SELECT FECID FECID FROM FECCommittee WHERE FECCommitteeID=;OUTPUT NIL OUTPUT

Please read the Adding Candidates to Races/Endorsements/Etc FAQ before attempting to add Candidates.

SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NIL ='b'.$in{CPhotoBlock}.'/C'.$in{SPLIT_ITEM}.'D'.$in{PicDate}.'.jpg'> ge > lt > SELECT RoundVotes FROM RaceMemberRound WHERE RaceLink= AND CandidateLink= AND RoundNum=;OUTPUT NIL SELECT DISTINCT RoundNum FROM RaceMemberRound WHERE RaceLink= ORDER BY RoundNum DESC;OUTPUT BRound
CANDIDATES
First Name: Last Name:
Replace
,SQL> ne ''>
Photo
(I) (W),Safe> ,Safe>
Name
On Ballot As
Campaign Logo
,Safe> [Change]
Party
[Remove]
Remove
Website
[?]
FEC Committee
//
Entry
//
Dropout
,SQL> eq 'Y'> CHECKED>
Incumbent
,SQL> eq 'Y'> CHECKED>
Write-In
X
SELECT RaceMemberFusionID,p.Color FPColor,p.Name FPartyName,FusionVotes FROM RaceMemberFusion,Party as p WHERE RaceLink= AND CandidateLink= AND PartyID=PartyLink ORDER BY FusionVotes DESC,p.Priority DESC,p.Name;OUTPUT FPty
[+New]
Fusion Lines
Precinct of reporting (%)
eq '' && $in{MaxWinners} < 2>,SQL> eq 'Y'> CHECKED> ne '' || $in{MaxWinners} > 1>,SQL> eq 'Y'> CHECKED>
[Clear] Winner
Total Votes
Ballot
X
SELECT RaceMemberFusionID,p.Color FPColor,p.Name FPartyName,FusionVotes FROM RaceMemberFusion,Party as p WHERE RaceLink= AND CandidateLink= AND PartyID=PartyLink ORDER BY FusionVotes DESC,p.Priority DESC,p.Name;OUTPUT FPty
[+New]
Fusion Votes
Invalid Votes Over Votes: - Under Votes:
Officially Certified CHECKED> - Check if the vote totals above have been officially certified.
Data Sources



Add Write-Ins Candidate    Add D Primary Winner    Add R Primary Winner    Add Runoff Winner 1    Add Runoff Winner 2   


Add     SELECT CandidateID,FirstName,LastName FROM RaceMember AS rm JOIN Candidate AS c ON rm.RaceLink= AND c.CandidateID=rm.CandidateLink WHERE CandidateID != 22593 ORDER BY LastName, FirstName;OUTPUT