SELECT * FROM Candidate WHERE CandidateID=;OUTPUT NIL DELETE FROM UserNewItems WHERE UserLink= AND ItemType='Candidate' AND ItemLink=;FINISH INSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'Candidate',,Now());FINISH SELECT SecLink FROM Security WHERE SecLink=71 AND UserLink=;OUTPUT NIL DELETE FROM PollResult WHERE ParentPoll=;OUTPUT NIL DELETE FROM Poll WHERE PollID=;OUTPUT NIL SELECT Name State FROM Container WHERE ContainerID=;OUTPUT NIL SELECT Name Country FROM Container WHERE ContainerID=;OUTPUT NIL SELECT Name PName,Color FROM Party WHERE PartyID=;OUTPUT NIL SELECT Nym MNym FROM User WHERE UserID=;OUTPUT NIL SELECT Nym CNym FROM User WHERE UserID=;OUTPUT NIL SELECT PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY ABS(TO_DAYS()-TO_DAYS(PicDate)) LIMIT 1;OUTPUT NIL SELECT PicDate TPD FROM CandidatePic WHERE CandidateLink= ORDER BY PicDate; FINISH

  ,

SELECT SecLink FROM Security WHERE SecLink=23 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=24 AND UserLink=;OUTPUT NIL SELECT * FROM CandidateNameChange WHERE CandidateLink= ORDER BY EndDate DESC,StartDate DESC;FINISH // - // SELECT * FROM MetaData WHERE AttachTo='Candidate' AND AttachLink= ORDER BY Priority DESC,DataName;OUTPUT CANDIDATE DETAILS Affiliation   <-   ->   Name Previous Names OUTPUT Email eq ''>None Website None [Link] Donate  Facebook  X (Twitter) Born Unknown ne '0000-00-00 00:00:00'>> , -> ( years) Died > , -> ( years) Contributor Last Modifed > , : Tags - SELECT TagName FROM TagAttach,Tag WHERE ParentType='Candidate' AND ParentID= AND TagID=TagLink ORDER BY Category,TagName;OUTPUT Info ne 'Y'>,plaintext> SELECT SecLink FROM Security WHERE SecLink=70 AND UserLink=;OUTPUT NIL SELECT PollID,PollStart PLS,PollEnd PLE,ErrorMargin,Name,PollingFirmID FROM Poll,PollingFirm WHERE Type='Job Approval' AND AttachTo='Candidate' AND GeographyLink=0 AND AttachID= AND PollingFirmID=PollingFirmLink ORDER BY PollEnd DESC,PollStart DESC LIMIT 10; >SELECT Result Approve FROM PollResult WHERE ParentPoll= AND AttachTo='Approve';OUTPUT NILSELECT Result Disapprove FROM PollResult WHERE ParentPoll= AND AttachTo='Disapprove';OUTPUT NILSELECT Result DontKnow FROM PollResult WHERE ParentPoll= AND AttachTo='DontKnow';OUTPUT NIL SELECT PollID LastPoll FROM Poll WHERE Type='Job Approval' AND AttachTo='Candidate' AND AttachID= AND PollingFirmLink= AND PollStart < AND GeographyLink=0 ORDER BY PollStart DESC LIMIT 1;OUTPUT NIL SELECT -Result DApprove FROM PollResult WHERE ParentPoll= AND AttachTo='Approve';OUTPUT NIL SELECT -Result DDisapprove FROM PollResult WHERE ParentPoll= AND AttachTo='Disapprove';OUTPUT NIL SELECT -Result DDontKnow FROM PollResult WHERE ParentPoll= AND AttachTo='DontKnow';OUTPUT NIL OUTPUT PollTempSELECT PollID,PollStart PLS,PollEnd PLE,ErrorMargin,f.Name,PollingFirmID,CAbbr,GeographyLink FROM Poll,PollingFirm as f,Container as c WHERE Type='Job Approval' AND AttachTo='Candidate' AND GeographyLink > 0 AND AttachID= AND PollingFirmID=PollingFirmLink AND ContainerID=GeographyLink ORDER BY PollEnd DESC,PollStart DESC LIMIT 10; >SELECT Result Approve FROM PollResult WHERE ParentPoll= AND AttachTo='Approve';OUTPUT NILSELECT Result Disapprove FROM PollResult WHERE ParentPoll= AND AttachTo='Disapprove';OUTPUT NILSELECT Result DontKnow FROM PollResult WHERE ParentPoll= AND AttachTo='DontKnow';OUTPUT NIL SELECT PollID LastPoll FROM Poll WHERE Type='Job Approval' AND AttachTo='Candidate' AND AttachID= AND PollingFirmLink= AND PollStart < AND GeographyLink= ORDER BY PollStart DESC LIMIT 1;OUTPUT NIL SELECT -Result DApprove FROM PollResult WHERE ParentPoll= AND AttachTo='Approve';OUTPUT NIL SELECT -Result DDisapprove FROM PollResult WHERE ParentPoll= AND AttachTo='Disapprove';OUTPUT NIL SELECT -Result DDontKnow FROM PollResult WHERE ParentPoll= AND AttachTo='DontKnow';OUTPUT NIL OUTPUT PollTempSELECT PollID,PollStart PLS,PollEnd PLE,ErrorMargin,Name,PollingFirmID FROM Poll,PollingFirm WHERE Type='Favorability' AND AttachTo='Candidate' AND GeographyLink=0 AND AttachID= AND PollingFirmID=PollingFirmLink ORDER BY PollEnd DESC,PollStart DESC LIMIT 10; >SELECT Result Favorable FROM PollResult WHERE ParentPoll= AND AttachTo='Favorable';OUTPUT NILSELECT Result Unfavorable FROM PollResult WHERE ParentPoll= AND AttachTo='Unfavorable';OUTPUT NILSELECT Result DontKnow FROM PollResult WHERE ParentPoll= AND AttachTo='DontKnow';OUTPUT NIL SELECT PollID LastPoll FROM Poll WHERE Type='Favorability' AND AttachTo='Candidate' AND AttachID= AND PollingFirmLink= AND PollStart < AND GeographyLink=0 ORDER BY PollStart DESC LIMIT 1;OUTPUT NIL SELECT -Result DFavorable FROM PollResult WHERE ParentPoll= AND AttachTo='Favorable';OUTPUT NIL SELECT -Result DUnfavorable FROM PollResult WHERE ParentPoll= AND AttachTo='Unfavorable';OUTPUT NIL SELECT -Result DDontKnow FROM PollResult WHERE ParentPoll= AND AttachTo='DontKnow';OUTPUT NIL OUTPUT PollTemp JOB APPROVAL POLLS Date Firm Approve Disapprove Don't Know //-// % ( ) % ( ) % ( ) PER-STATE JOB APPROVAL POLLS Date State Firm Approve Disapprove Don't Know //-// % ( ) % ( ) % ( ) FAVORABILITY POLLS Date Firm Favorable Unfavorable Don't Know //-// % ( ) % ( ) % ( ) TWITTER

SELECT SecLink FROM Security WHERE SecLink=64 AND UserLink=;OUTPUT NIL eq 'Y'> DELETE FROM CandidateRating WHERE CandidateLink= AND UserLink=;OUTPUT NIL INSERT INTO CandidateRating (CandidateLink,UserLink,Importance,LastModified) VALUES (,,,);OUTPUT NIL SELECT AVG(Importance) Import FROM CandidateRating WHERE CandidateLink=;OUTPUT NIL UPDATE Candidate SET Importance= WHERE CandidateID=;OUTPUT NIL SELECT Importance MyKey FROM CandidateRating WHERE CandidateLink= AND UserLink=;OUTPUT NIL Importance? Average Non CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> CHECKED onClick="document.KeyForm.submit()"> Very SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE SourceLink= AND Type='S' AND TargetLink NOT IN () AND CandidateID=TargetLink ORDER BY Type DESC,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE TargetLink= AND Type='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type DESC,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheFirstOnceElder SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheGreatUncleAunt SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE SourceLink= AND Type!='S' AND TargetLink NOT IN () AND CandidateID=TargetLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheGreatGrandParent SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheUncleAunt SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE SourceLink= AND Type!='S' AND TargetLink NOT IN () AND CandidateID=TargetLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheGrandParent SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheSibling SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE SourceLink= AND Type!='S' AND TargetLink NOT IN () AND CandidateID=TargetLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT OutPerson SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE TargetLink= AND Type!='S' AND SourceLink NOT IN () AND CandidateID=SourceLink ORDER BY Type DESC,StartDate,EndDate,BirthDate;OUTPUT TheChild SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE SourceLink= AND Type!='S' AND TargetLink NOT IN () AND CandidateID=TargetLink ORDER BY Type,StartDate,EndDate,BirthDate;OUTPUT TheParent SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE SourceLink= AND Type='S' AND CandidateID=TargetLink ORDER BY Type DESC,StartDate,EndDate,BirthDate;OUTPUT TheSpouse SELECT CandidateID,FirstName,LastName,Gender,BirthDate,DeathDate,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE TargetLink= AND Type='S' AND CandidateID=SourceLink ORDER BY Type DESC,StartDate,EndDate,BirthDate;OUTPUT TheSpouse FAMILY ,Safe> - ,Safe> , -,Safe> , > > SELECT RaceID,PollEnd,Title,Won,Winner,Color,WinVotes,SecondVotes,AllVotes,FinalVoteTotal,Race.Silly FROM RaceMember,Race,Party WHERE CandidateLink= AND ParentRace=0 AND DropoutDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly!='Y' AND PartyID=PartyLink ORDER BY PollEnd DESC LIMIT 100;OUTPUTSELECT RaceID,PollEnd,Title,Won,Winner,Color,WinVotes,SecondVotes,AllVotes,FinalVoteTotal,Race.Silly FROM RaceMember,Race,Party WHERE CandidateLink= AND ParentRace=0 AND EntryDate!='0000-00-00 00:00:00' AND DropoutDate!='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly!='Y' AND PartyID=PartyLink ORDER BY PollEnd DESC LIMIT 100;OUTPUTSELECT RaceID,PollEnd,Title,Won,Winner,Color,WinVotes,SecondVotes,AllVotes,FinalVoteTotal,Race.Silly FROM RaceMember,Race,Party WHERE CandidateLink= AND ParentRace=0 AND EntryDate='0000-00-00 00:00:00' AND DropoutDate!='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly!='Y' AND PartyID=PartyLink ORDER BY PollEnd DESC LIMIT 100;OUTPUT SELECT RaceID,PollEnd,Title,Won,Winner,Color,WinVotes,SecondVotes,AllVotes,FinalVoteTotal,Race.Silly FROM RaceMember,Race,Party WHERE CandidateLink= AND ParentRace=0 AND DropoutDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly='Y' AND PartyID=PartyLink ORDER BY PollEnd DESC LIMIT 100;OUTPUT OUTPUTSELECT RaceID,PollEnd,Title,Won,Winner,Color,WinVotes,SecondVotes,AllVotes,FinalVoteTotal,Race.Silly FROM RaceMember,Race,Party WHERE CandidateLink= AND ParentRace=0 AND EntryDate!='0000-00-00 00:00:00' AND DropoutDate!='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly='Y' AND PartyID=PartyLink ORDER BY PollEnd DESC LIMIT 100;OUTPUTSELECT RaceID,PollEnd,Title,Won,Winner,Color,WinVotes,SecondVotes,AllVotes,FinalVoteTotal,Race.Silly FROM RaceMember,Race,Party WHERE CandidateLink= AND ParentRace=0 AND EntryDate='0000-00-00 00:00:00' AND DropoutDate!='0000-00-00 00:00:00' AND RaceID=RaceLink AND Race.Silly='Y' AND PartyID=PartyLink ORDER BY PollEnd DESC LIMIT 100;OUTPUT RACES   // Counting % (%) Lost % (%) Won % (%) ??? ENTERED, DROPPED OUT SPECULATIVE, DID NOT RUN SILLY RACES SILLY RACES - ENTERED, DROPPED OUT SILLY RACES - SPECULATIVE, DID NOT RUN > SELECT RaceID,Race.Title,PollEnd,FirstName,LastName,Abbr,Color,AntiEndorse FROM Endorsement,Race,Candidate,Party WHERE Endorsement.Type='Candidate' AND TypeID= AND RaceID=RaceLink AND Race.Silly!='Y' AND CandidateID=CandidateLink AND Candidate.Silly!='Y' AND PartyID=PartyLink AND Party.Silly!='Y' ORDER BY PollStart DESC,Endorsement.LastModified;OUTPUT ENDORSEMENTS - ,Safe> , style="background-color:black;color:white">🚫 SELECT DISTINCT FECCommitteeID,FECID,f.Name FROM RaceMember,FECCommittee as f WHERE CandidateLink= AND PrimaryFECC > 0 AND FECCommitteeID=PrimaryFECC ORDER BY FECID; FINISH >SELECT CashOnHand FROM FEC_F3 WHERE FECCommitteeLink= ORDER BY EndDate DESC,StartDate DESC LIMIT 1;OUTPUT NILOUTPUT FEC COMMITTEES $