SELECT * FROM FECCommittee WHERE FECCommitteeID=;OUTPUT NIL DELETE FROM UserNewItems WHERE UserLink= AND ItemType='FECCommittee' AND ItemLink=;FINISH INSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'FECCommittee',,Now());FINISH

  

DELETE FROM FECCommitteeAttach WHERE FECCommitteeLink= AND AttachType= AND AttachID=;FINISHFECCommittee Attachment Removed. SELECT SecLink FROM Security WHERE SecLink=43 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=45 AND UserLink=;OUTPUT NIL [X] LOGGED FECCommittee DETAILS FEC ID Name Address Committee Type ,Safe> Organization Type ,Safe> Lobbyist/Registrant PAC Leadership PAC Description ne 'Y'>,plaintext> SELECT RaceID,r.Title,r.PollEnd,CandidateID,c.FirstName,c.LastName FROM RaceMember as m,Race as r,Candidate as c WHERE PrimaryFECC= AND RaceID=RaceLink AND CandidateID=CandidateLink ORDER BY PollEnd DESC; FINISH >OUTPUT RACES Poll End Race Candidate SELECT MIN(EndDate) MinStart, MAX(EndDate) MaxEnd,MIN(TO_DAYS(EndDate)) MnPd, MAX(TO_DAYS(EndDate))+1 MxPd,MAX(CashOnHand) MaxCoH,MAX(TotalReceipts) MaxRcpt,MAX(TotalDisbursements) MaxDisb FROM FEC_F3 WHERE FECCommitteeLink=;OUTPUT NIL >SELECT * FROM FEC_F3 WHERE FECCommitteeLink= ORDER BY EndDate DESC, StartDate DESC;OUTPUT   LOGGED FINANCE REPORTS (F3) Contribution Graph Period PAC Receipts Disbursements Debts To Debts By Cash on Hand - SELECT SecLink FROM Security WHERE SecLink=62 AND UserLink=;OUTPUT NIL SELECT AdVideoID,StartDate,Category,AdTone,Title,URLLink,EmbedCode,RunTime,Description,Silly,FirstEnter,LMBy,UserID,Nym,CandidateLink FROM AdVideo as a LEFT JOIN User ON UserID=LMBy WHERE FECCommitteeLink= AND UserID=LMBy ORDER BY StartDate DESC,EndDate DESC,Title LIMIT 10; >OUTPUT VIDEO ADVERTISEMENTS Start Date Candidate Category Ad Tone Title Run Time Contributor // ,Safe> ,Safe> New!

>SELECT FECFromLink,Name,SUM(Amount) SAmt FROM FEC_F56,FECCommittee WHERE FECToLink= AND FECCommitteeID=FECFromLink GROUP BY FECFromLink ORDER BY SAmt DESC LIMIT 100;OUTPUT Top Total Contributions From Committee Amount >SELECT FECToLink,Name,Amount,ContributionDate FROM FEC_F56,FECCommittee WHERE FECFromLink= AND FECCommitteeID=FECToLink ORDER BY ContributionDate DESC LIMIT 100;OUTPUT Contributions To Date Committee Amount