SELECT SecLink FROM Security WHERE SecLink=70 AND UserLink=;OUTPUT NIL SELECT * FROM PollingFirm WHERE PollingFirmID=;OUTPUT NIL SELECT count(*) NPolls FROM Poll WHERE PollingFirmLink=;OUTPUT NIL SELECT Nym FROM User WHERE UserID=;OUTPUT NIL SELECT Name PName FROM Party WHERE PartyID=;OUTPUT NIL
  
SELECT DISTINCT RaceID,Race.PollStart,Race.PollEnd,Title,AllVotes FROM Poll,Race WHERE PollingFirmLink= AND AttachTo='Race' AND RaceID=AttachID AND Race.Silly!='Y' ORDER BY Poll.PollEnd DESC LIMIT ,20;OUTPUT EachRace
eq ''> ne ''>
POLLING FIRM DETAILS +0 > 499>
Website
Polls Conducted
Points
Affiliation
Last Modified > , :
Description ne 'Y'>,plaintext>
SELECT 100-SUM(Result) Undecided,SUM(Result) SumResult FROM PollResult WHERE ParentPoll= AND Grouping=OUTPUT NIL
Race Polls Conducted
Race Results Polls
  %=$in{MPct}>
   
SELECT DISTINCT CandidateID CLK,FirstName,LastName,Color,Result FROM PollResult,Candidate,Party WHERE ParentPoll= AND AttachTo='Candidate' AND CandidateID=AttachID AND PartyID=Candidate.PartyLink ORDER BY Grouping,Result DESC,Party.Priority DESC,LastName;OUTPUT EachPollMember
//-// (% Undecided) //-// (% Undecided)
TOTAL
Firm='Y'> >

 SELECT DISTINCT CandidateID CLK,FirstName,LastName,Color,FinalVoteTotal FROM RaceMember,Candidate,Party WHERE RaceLink= AND DropoutDate='0000-00-00 00:00:00' AND CandidateID=CandidateLink AND PartyID=RaceMember.PartyLink ORDER BY FinalVoteTotal DESC,Incumbent DESC,WriteIn,Party.Priority DESC,LastName;OUTPUT EachResult
SELECT PollID,PollStart PPS,PollEnd PPE,WinGroup FROM Poll WHERE AttachTo='Race' AND AttachID= AND PollingFirmLink= ORDER BY PollEnd DESC,PollStart DESC;OUTPUT EachPoll
Next 20-->

Approval Polls Conducted
Candidate Poll (Approve/Disapprove/Don't Know)
SELECT Result FROM PollResult WHERE ParentPoll= ORDER BY AttachTo;OUTPUT EachPollMember
//-// //-//
> SELECT PollID,PollStart PPS,PollEnd PPE FROM Poll WHERE AttachTo='Candidate' AND AttachID= AND PollingFirmLink= ORDER BY PollEnd DESC,PollStart DESC;OUTPUT EachPoll SELECT DISTINCT CandidateID CLK,FirstName,LastName FROM Poll,Candidate WHERE PollingFirmLink= AND AttachTo='Candidate' AND CandidateID=AttachID ORDER BY Poll.PollEnd DESC LIMIT ,20;OUTPUT EachCandidate Next 20-->