DELETE FROM UserNewItems WHERE UserLink= AND ItemType='Race' AND ItemLink=;FINISHINSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'Race',,Now());FINISH
if (1==0) { $in{PRC1}='#FF0000';$in{PRC2}='#0000FF';$in{PRC3}='#009900';$in{PRC4}='#FFFF00';$in{PRC5}='#00AAFF'; $in{PRC6}='#AA00BB';$in{PRC7}='#FF3300';$in{PRC8}='#663300';$in{PRC9}='#333333';$in{PRC10}='#FF6699'; $in{PRC11}='#FFBB99';$in{PRC12}='#660000';$in{PRC13}='#006600';$in{PRC14}='#000066';$in{PRC15}='#006666'; }
else { $in{PRC1}='#AA00BB';$in{PRC2}='#006666';$in{PRC3}='#663300';$in{PRC4}='#FF6699';$in{PRC5}='#00AAFF'; $in{PRC6}='#BBAAFF';$in{PRC7}='#FF7F27';$in{PRC8}='#90EE90';$in{PRC9}='#333333';$in{PRC10}='#0099AA'; $in{PRC11}='#FFBB99';$in{PRC12}='#FFFF00';$in{PRC13}='#B97A57';$in{PRC14}='#009900';$in{PRC15}='#FF0000';$in{PRC16}='#0000FF'; }
$in{OAB_Governor}='Gov.'; $in{'OAB_Lieutenant Governor'}='Lt. Gov.'; $in{OAB_Senate}='Sen.'; $in{'OAB_House of Representatives'}='Rep.'; $in{'OAB_Vice President'}='V.P.'; $in{'OAB_President'}='Pres.';
$in{'OAB_State House'}='St. Rep.'; $in{'OAB_State Senate'}='St. Sen.'; $in{'OAB_Parliament'}='MP';
SELECT RaceID,Color,Name,CandidateID,FirstName,LastName,Photo,PollEnd,TakeOffice,TermEnd,WinVotes,SecondVotes,MaxWinners,AllVotes FROM Race,Candidate,RaceMember,Party
WHERE ParentContainer= AND TakesSeat='Y' AND PollEnd < AND CandidateID=Winner AND RaceLink=RaceID AND CandidateLink=Winner AND PartyID=RaceMember.PartyLink ORDER BY PollEnd DESC,TakeOffice DESC LIMIT 1;OUTPUT NILSELECT RaceID,Color,Name,CandidateID,FirstName,LastName,Photo,PollEnd,TakeOffice,TermEnd,WinVotes,SecondVotes,MaxWinners,AllVotes FROM Race,Candidate,RaceMember,Party
WHERE ParentContainer= AND TakesSeat='Y' AND PollEnd > AND CandidateID=Winner AND RaceLink=RaceID AND CandidateLink=Winner AND PartyID=RaceMember.PartyLink ORDER BY PollEnd,TakeOffice LIMIT 1;OUTPUT NIL='Y'>=$in{PName}>SELECT ContainerID CID,ParentLink PLk,Name PName,CategoryType CatType FROM Container,ContainerCategory WHERE ContainerID= AND ContainerCategoryID=CategoryLink;OUTPUT CStreamSELECT ContainerID CID,ParentLink PLk,Name PName,CategoryType CatType FROM Container,ContainerCategory WHERE ContainerID= AND ContainerCategoryID=CategoryLink;OUTPUT CStreamSELECT Name CName,ParentLink PC2 FROM Container WHERE ContainerID=;OUTPUT NILSELECT Title PRace FROM Race WHERE RaceID=;OUTPUT NILSELECT Category CCategory,Name CCName FROM Container WHERE ContainerID=;OUTPUT NILSELECT ContainerID,Category,Name FROM Container WHERE ContainerID IN () AND CategoryLink=248;OUTPUT NILSELECT Nym FROM User WHERE UserID=;OUTPUT NILSELECT Nym CNym FROM User WHERE UserID=;OUTPUT NILSELECT Name PtyName FROM Party WHERE PartyID=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=73 AND UserLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=75 AND UserLink=;OUTPUT NIL ne ''>
SELECT SecLink FROM Security WHERE SecLink=74 AND UserLink=;OUTPUT NILDELETE FROM Endorsement WHERE EndorsementID=;FINISHEndorsement Deleted. DELETE FROM Endorsement WHERE EndorsementID= AND Type='User' AND TypeID=;FINISHEndorsement Deleted. SELECT SecLink FROM Security WHERE SecLink=71 AND UserLink=;OUTPUT NIL ne '' && $in{Security_PollDel} ne '0E0'>
DELETE FROM PollResult WHERE ParentPoll=;OUTPUT NILDELETE FROM Poll WHERE PollID=;OUTPUT NIL ne ''>
SELECT SecLink FROM Security WHERE SecLink=58 AND UserLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=60 AND UserLink=;OUTPUT NILSELECT * FROM Cart WHERE UserLink= AND ItemType='Race' AND ItemID=;OUTPUT NILUPDATE Cart SET Pickup=,Follow=,AmIn=,Email= WHERE UserLink= AND ItemType='Race' AND ItemID=;FINISHINSERT INTO Cart (Pickup,Follow,AmIn,Email,UserLink,ItemType,ItemID) VALUES (,,,,,'Race',);FINISH
SELECT DNumber TotalPop FROM DemographicNum WHERE AttachTo='Container' AND AttachID= AND DemographicLink=1 AND StartDate <= AND (EndDate >= OR EndDate ='0000-00-00');OUTPUT NILSELECT DNumber VAP FROM DemographicNum WHERE AttachTo='Container' AND AttachID= AND DemographicLink=108 AND StartDate <= AND (EndDate >= OR EndDate ='0000-00-00');OUTPUT NILSELECT SUM(Amount) RegVoter FROM PartyReg WHERE ParentContainer= AND PartyLink= AND StartDate <= AND (EndDate >= OR EndDate ='0000-00-00');OUTPUT NILSELECT SUM(FinalVoteTotal) AllVoteTotal FROM RaceMember WHERE RaceLink=;OUTPUT NIL
SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NILSELECT FirstName,LastName FROM CandidateNameChange WHERE CandidateLink= AND StartDate <= AND EndDate > LIMIT 1;OUTPUT NIL
SELECT FinalVoteTotal LoseVote FROM RaceMember WHERE RaceLink= AND Won='' ORDER BY FinalVoteTotal DESC LIMIT 1;OUTPUT NILSELECT FinalVoteTotal WinVotes,Color,Name,CandidateID,FirstName,LastName,Photo,PartyID FROM RaceMember,Candidate,Party
WHERE RaceLink= AND Won='Y' AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink
ORDER BY FinalVoteTotal DESC LIMIT ;OUTPUT EachLast
NEXT GENERAL ELECTION
SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NILSELECT FirstName,LastName FROM CandidateNameChange WHERE CandidateLink= AND StartDate <= AND EndDate > LIMIT 1;OUTPUT NIL
SELECT FinalVoteTotal LoseVote FROM RaceMember WHERE RaceLink= AND Won='' ORDER BY FinalVoteTotal DESC LIMIT 1;OUTPUT NILSELECT FinalVoteTotal WinVotes,Color,Name,CandidateID,FirstName,LastName,Photo,PartyID ncParty FROM RaceMember,Candidate,Party
WHERE RaceLink= AND Won='Y' AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink
ORDER BY FinalVoteTotal DESC LIMIT ;OUTPUT EachNext
PRIMARY/OTHER SCHEDULE
>
,Safe> ,
SELECT FirstName,LastName FROM Candidate WHERE CandidateID=;OUTPUT NILSELECT FirstName,LastName FROM RaceMember,Candidate WHERE RaceLink= AND (DropoutDate='0000-00-00 00:00:00' OR FinalVoteTotal > 0) AND CandidateID=CandidateLink ORDER BY LastName,FirstName;OUTPUT LCands
SELECT SUM(FinalVoteTotal) FVT, PartyLink, Abbr, Color FROM RaceMember JOIN Party ON PartyID=PartyLink WHERE RaceLink= GROUP BY PartyLink ORDER BY SUM(FinalVoteTotal) DESC;OUTPUT PrimaryTot
SELECT * FROM Race WHERE ParentContainer= AND TakesSeat!='Y' AND PollEnd < AND PollEnd > ORDER BY PollEnd;OUTPUT
SELECT RaceID,Title,TakeOffice,PollEnd,MaxWinners FROM Race WHERE ParentContainer= AND TakesSeat='Y' AND PollEnd > ORDER BY PollEnd,TakeOffice LIMIT 1;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=62 AND UserLink=;OUTPUT NILSELECT COUNT(DISTINCT PartyLink) NumParties FROM RaceMember WHERE RaceLink=;OUTPUT NILSELECT SUM(FinalVoteTotal) SumVotes FROM RaceMember WHERE RaceLink=;OUTPUT NILSELECT SUM(SubPredictVote) SumSPVotes FROM RaceMember WHERE RaceLink=;OUTPUT NILSELECT MAX(FinalVoteTotal) FirstVotes FROM RaceMember WHERE RaceLink=;OUTPUT NILSELECT CandidateLink CID FROM RaceMemberRound WHERE RaceLink= AND RoundNum=0 ORDER BY RoundVotes DESC;OUTPUT BRoundSELECT CandidateID CID,FirstName,LastName,RaceMember.PartyLink,Photo,FinalVoteTotal,SubPredictVote,PollAvg,rp.Name PName,rp.Color PColor,cp.Color CPColor,Won,Incumbent,PrimaryFECC,WriteIn,EntryDate,EntryURI,DropoutDate,DropURI,CanType,Candidate.Website,BallotName,CampaignSite,DonateURL,Longitude,Latitude FROM RaceMember,Candidate,Party as rp,Party as cp WHERE RaceLink= AND (DropoutDate='0000-00-00' OR FinalVoteTotal > 0) AND CandidateID=CandidateLink AND rp.PartyID=RaceMember.PartyLink AND cp.PartyID=Candidate.PartyLink ORDER BY Won DESC,FinalVoteTotal DESC,Incumbent DESC,(EntryDate='0000-00-00 00:00:00'),WriteIn,rp.PartyID!=,rp.Priority DESC,cp.Priority DESC,LastName LIMIT 250;SELECT FirstName,LastName FROM CandidateNameChange WHERE CandidateLink= AND StartDate <= AND EndDate > LIMIT 1;OUTPUT NIL
$in{CanOrder}=$in{CanOrder}.','.$in{CID};
$in{'Photo'.$in{CID}}=$in{Photo};
$in{'Incumbent'.$in{CID}}=$in{Incumbent};
$in{'WriteIn'.$in{CID}}=$in{WriteIn};
$in{'FirstName'.$in{CID}}=$in{FirstName};
$in{'LastName'.$in{CID}}=$in{LastName};
$in{'PartyLink'.$in{CID}}=$in{PartyLink};
$in{'PColor'.$in{CID}}=$in{PColor};
if ($in{NumParties} == 1) { $in{'HColor'.$in{CID}}=$in{CPColor}; $in{UseHeaderColor}='Y'; } else { $in{'HColor'.$in{CID}}=$in{PColor}; }
$in{'PRCU'.$in{PColor}}='Y';
$in{'PRCU'.$in{HColor}}='Y';
$in{'Votes'.$in{CID}}=$in{FinalVoteTotal};
$in{'SPVotes'.$in{CID}}=$in{SubPredictVote};
$in{'PollAvg'.$in{CID}}=$in{PollAvg};
$in{'PName'.$in{CID}}=$in{PName};
$in{'Won'.$in{CID}}=$in{Won};
$in{'EntryDate'.$in{CID}}=$in{EntryDate};
$in{'EntryURI'.$in{CID}}=$in{EntryURI};
$in{'DropoutDate'.$in{CID}}=$in{DropoutDate};
$in{'DropURI'.$in{CID}}=$in{DropURI};
$in{'CanType'.$in{CID}}=$in{CanType};
$in{'Website'.$in{CID}}=$in{Website};
$in{'BallotName'.$in{CID}}=$in{BallotName};
$in{'CampaignSite'.$in{CID}}=$in{CampaignSite};
$in{'DonateURL'.$in{CID}}=$in{DonateURL};
$in{'PrimaryFECC'.$in{CID}}=$in{PrimaryFECC};
$in{'Longitude'.$in{CID}}=$in{Longitude};
$in{'Latitude'.$in{CID}}=$in{Latitude};
if ($in{CanType} eq 'Placeholder') { $in{HasPlaceholder}='Y'; }
SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NIL='b'.$in{CPhotoBlock}.'/C'.$in{CID}.'D'.$in{PicDate}.'.jpg'>
OUTPUTSELECT SUM(PollAvg) NotUndecided FROM RaceMember WHERE RaceLink=;OUTPUT NIL$in{TCID}=','.$in{CID}.','; $in{CanOrder}=~s/$in{TCID}/\,/g; $in{CanOrder}=','.$in{CID}.$in{CanOrder};SELECT CandidateLink CID,PollAvg FROM RaceMember WHERE RaceLink= AND (DropoutDate='0000-00-00' OR FinalVoteTotal > 0) ORDER BY PollAvg;OUTPUT PollOrder,noparse>='Y'>
if ($in{'PRCA'.$in{'HColor'.$in{'SPLIT_ITEM'}}} eq 'Y') {
$prcc++;
while ( ($in{'PRCU'.$in{'PRC'.$prcc}} eq 'Y' || $in{'PRCA'.$in{'PRC'.$prcc}} eq 'Y') && $prcc<14 ) { $prcc++; }
$in{'HColor'.$in{'SPLIT_ITEM'}}=$in{'PRC'.$prcc}; $in{UseHeaderColor}='Y';
$in{'PRCA'.$in{'PRC'.$prcc}}='Y';
$in{SpCClr}.='&SPC'.$in{SPLIT_ITEM}.'='.&URLEncode($in{'PRC'.$prcc});
} else {
$in{'PRCA'.$in{'HColor'.$in{'SPLIT_ITEM'}}}='Y';
if ($in{NumParties} == 1) { $in{SpCClr}.='&SPC'.$in{SPLIT_ITEM}.'='.&URLEncode($in{'HColor'.$in{'SPLIT_ITEM'}}); }
}
SELECT MapImageID BDRMID,MapLocationID BDRLID,ST_Distance_Sphere(point(LngMin, LatMin), point(LngMin, LatMax))/ST_Distance_Sphere(point(LngMin, LatMin), point(LngMax, LatMin)) MRatio FROM MapLocation as l, MapLocationAttach as a,MapImage as i WHERE l.ContainerLink= AND (l.StartDate='0000-00-00' OR TO_DAYS(l.StartDate)<=TO_DAYS()) AND (TO_DAYS(l.EndDate)>=TO_DAYS() OR EndDate='0000-00-00') AND a.MapLocationLink=l.MapLocationID AND i.MapImageID=a.MapImageLink AND LLPolyCoords!='';OUTPUT NILSELECT ParentLink as TCID FROM Container WHERE ContainerID=;OUTPUT NILSELECT COUNT(*) NumVTD FROM RaceVTD WHERE RaceLink= AND CandidateLink= LIMIT 1OUTPUT NIL>SELECT MAX(d.StartDate) MaxStart,MIN(d.EndDate) MinEnd FROM RaceVTD as r JOIN VotingDistrict as d ON r.RaceLink= AND d.VotingDistrictID=r.VotingDistrictLink AND (d.StartDate='0000-00-00' OR TO_DAYS(d.StartDate)<=TO_DAYS()) AND (TO_DAYS(d.EndDate)>TO_DAYS() OR d.EndDate='0000-00-00')OUTPUT NIL
MAP
style="display:none;">
]=new Array(0'>SELECT ContainerLink FROM MapLocation WHERE MapImageLink=;OUTPUT PEachLocSELECT DISTINCT MapImageID,MapName,LLBoundary FROM RaceSub as s,MapLocation as l,MapLocationAttach as a,MapImage as m,Container as c,ContainerCategory as cc WHERE RaceLink= AND l.ContainerLink=s.SubLink AND (TO_DAYS(l.StartDate)<=TO_DAYS() OR l.StartDate='0000-00-00 00:00:00') AND (TO_DAYS(l.EndDate)>TO_DAYS() OR l.EndDate='0000-00-00 00:00:00') AND a.MapLocationLink=l.MapLocationID AND m.MapImageID=a.MapImageLink AND (TO_DAYS(m.MapStartDate)<=TO_DAYS() OR m.MapStartDate='0000-00-00 00:00:00') AND (TO_DAYS(m.MapEndDate)>TO_DAYS() OR m.MapEndDate='0000-00-00 00:00:00') AND ContainerID=l.ContainerLink AND ContainerCategoryID=c.CategoryLink ORDER BY cc.Priority DESC,MapName LIKE '%Merged%',MapName;OUTPUT
SELECT DISTINCT MapImageID,MapName,LLBoundary FROM RaceSub as s,MapLocation as l,MapLocationAttach as a,MapImage as m,Container as c,ContainerCategory as cc WHERE RaceLink= AND l.ContainerLink=s.SubLink AND (TO_DAYS(l.StartDate)<=TO_DAYS() OR l.StartDate='0000-00-00 00:00:00') AND (TO_DAYS(l.EndDate)>TO_DAYS() OR l.EndDate='0000-00-00 00:00:00') AND a.MapLocationLink=l.MapLocationID AND m.MapImageID=a.MapImageLink AND (TO_DAYS(m.MapStartDate)<=TO_DAYS() OR m.MapStartDate='0000-00-00 00:00:00') AND (TO_DAYS(m.MapEndDate)>TO_DAYS() OR m.MapEndDate='0000-00-00 00:00:00') AND ContainerID=l.ContainerLink AND ContainerCategoryID=c.CategoryLink ORDER BY cc.Priority DESC,MapName LIKE '%Merged%',MapName;FINISH
SELECT COUNT(*) NRSubs FROM Race WHERE ParentRace=;OUTPUT NIL
='Y'>
SELECT c.ParentLink as MPCID,MapImageID,MapName,MapLocationID,l.StartDate MLStart,l.EndDate MLEnd,FillCoords MCFill,PolyCoords MCPoly,LLPolyCoords MCLLPoly,Width MIWidth,Height MIHeight FROM Container as c LEFT JOIN MapLocation as l ON ContainerLink= AND (l.StartDate='0000-00-00 00:00:00' OR TO_DAYS(l.StartDate)<=TO_DAYS()) AND (l.EndDate='0000-00-00 00:00:00' OR TO_DAYS(l.EndDate)>TO_DAYS()) AND LLPolyCoords!='' LEFT JOIN MapLocationAttach as a ON a.MapLocationLink=l.MapLocationID LEFT JOIN MapImage ON MapImageID=a.MapImageLink WHERE c.ContainerID=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=64 AND UserLink=;OUTPUT NIL eq 'Y'>
DELETE FROM KeyRating WHERE RaceLink= AND UserLink=;OUTPUT NILINSERT INTO KeyRating (RaceLink,UserLink,KeyRating,LastModified) VALUES (,,,);OUTPUT NILSELECT AVG(KeyRating) KeyLevel FROM KeyRating WHERE RaceLink=;OUTPUT NILUPDATE Race SET KeyLevel= WHERE RaceID=;OUTPUT NILSELECT KeyRating MyKey FROM KeyRating WHERE RaceLink= AND UserLink=;OUTPUT NIL
SELECT COUNT(*) NumLeanPred FROM Leaning WHERE RaceLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=6 AND UserLink=;OUTPUT NILSELECT GenPredictor FROM User WHERE UserID= AND GenPredictor='Y';OUTPUT NILSELECT CandidateLink LastCand,Amount LastLean,DangerOrder LastDO FROM Leaning WHERE RaceLink= AND UserLink= AND EndDate='0000-00-00 00:00:00';OUTPUT NILUPDATE Leaning SET DangerOrder= WHERE RaceLink= AND UserLink= AND EndDate='0000-00-00 00:00:00';OUTPUT NILDELETE FROM Leaning WHERE RaceLink= AND UserLink= AND UNIX_TIMESTAMP(StartDate) > UNIX_TIMESTAMP()-600;OUTPUT NILUPDATE Leaning SET EndDate= WHERE RaceLink= AND UserLink= AND EndDate='0000-00-00 00:00:00';OUTPUT NILINSERT INTO Leaning (StartDate,EndDate,UserLink,RaceLink,CandidateLink,Amount,DangerOrder) VALUES (,'0000-00-00 00:00:00',,,,,);OUTPUT NILSELECT CandidateLink CID,FirstName FN,LastName LN,Color CClr,Abbr Tabbr FROM RaceMember,Candidate,Party WHERE RaceLink= AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink ORDER BY LastName;OUTPUT NILSELECT MIN(TO_DAYS(StartDate)) MinLeanVal,MIN(StartDate) MinLean,TO_DAYS(Now())+5 NowDateVal,TO_DAYS() PollEndVal FROM Leaning WHERE RaceLink=;OUTPUT NILSELECT COUNT(*) NumPolls,COUNT(DISTINCT PollingFirmLink) NumPollster FROM Poll WHERE InvalidPoll='' AND AttachTo='Race' AND AttachID=;OUTPUT NILSELECT SUM(Result) PGR FROM PollResult WHERE ParentPoll= AND Grouping= AND AttachTo='Candidate' AND AttachID IN ();OUTPUT NILSELECT DISTINCT Grouping FROM PollResult ORDER BY Grouping;OUTPUT PollGroupUPDATE Poll SET WinGroup= WHERE PollID=;FINISHSELECT PollID FROM Poll WHERE AttachTo='Race' AND AttachID= AND WinGroup=0;OUTPUTSELECT DISTINCT PollingFirmID,Name PFName FROM Poll,PollingFirm WHERE InvalidPoll='' AND AttachTo='Race' AND AttachID= AND PollingFirmID=PollingFirmLink ORDER BY PFName;OUTPUTSELECT MIN(PollStart) MinStart, MAX(PollEnd) MaxEnd,MIN(TO_DAYS(PollStart)) MnPd, MAX(TO_DAYS(PollEnd))+2 MxPd FROM Poll WHERE InvalidPoll='' AND AttachTo='Race' AND AttachID=;OUTPUT NILSELECT MAX(Result)+1 MaxPoll FROM Poll,PollResult WHERE Poll.InvalidPoll='' AND Poll.AttachTo='Race' AND Poll.AttachID= AND ParentPoll=PollID;OUTPUT NIL
