ne ''> SELECT Title TTitle,Category TCat FROM AdVideo WHERE AdVideoID=;OUTPUT NIL
  "" - Edit

SELECT SecLink FROM Security WHERE SecLink=12 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=14 AND UserLink=;OUTPUT NIL eq 'SaveIt'> SELECT FECCommitteeID FECCommitteeLink FROM FECCommittee WHERE FECID=;OUTPUT NIL - SELECT * FROM AdVideo WHERE AdVideoID=;OUTPUT NIL INSERT INTO AdVideoLog (LogDate,AdVideoID,StartDate,EndDate,Category,AdTone,LanguageLink,Title,Description,CodeType,URLLink,EmbedCode,RunTime,RaceLink,SponsorLink,CandidateLink,VsCandidateLink,PartyLink,IssueLink,Silly,FirstBy,FirstEnter,LMBy,LastModified) VALUES (,,,,,,,,,,,,, ,,,,,,,,,,);FINISH UPDATE AdVideo SET StartDate=,EndDate=,Category=,AdTone=,LanguageLink=,Title=,Description=,CodeType=,URLLink=, EmbedCode=,RunTime=,RaceLink=,CandidateLink=,VsCandidateLink=,PartyLink=,IssueLink=, FECCommitteeLink=,FilingCode=,TotalSpend=,SponsorLink=, Silly=,LMBy=,LastModified=Now() WHERE AdVideoID=;OUTPUT NIL - Saved Changes
 INSERT INTO AdVideo (StartDate,EndDate,Category,AdTone,LanguageLink,Title,Description,CodeType,URLLink,EmbedCode,RunTime,RaceLink,SponsorLink,CandidateLink,VsCandidateLink,PartyLink,IssueLink,FECCommitteeLink,FilingCode,TotalSpend,Silly,FirstBy,FirstEnter,LMBy,LastModified) VALUES (,,,,,,,,,,,,,,, ,,,,,,,,,);OUTPUT NIL - Saved New Video Advertisement
 DELETE FROM AdVideoIssue WHERE AdVideoLink=;FINISH INSERT INTO AdVideoIssue (AdVideoLink,IssueLink) VALUES (,);FINISH SELECT IssueID TCID FROM Issue WHERE Silly!='Y';OUTPUT DELETE FROM AdVideoDMA WHERE AdVideoLink=;FINISH INSERT INTO AdVideoDMA (AdVideoLink,DMALink) VALUES (,);FINISH SELECT ContainerID TCID FROM Container WHERE ParentLink=83852 ORDER BY Name;OUTPUT SELECT * FROM AdVideo WHERE AdVideoID=;OUTPUT NIL ='Y'> SELECT * FROM AdVideoIssue WHERE AdVideoLink=;OUTPUT ='Y'> SELECT * FROM AdVideoDMA WHERE AdVideoLink=;OUTPUT SELECT FECCommitteeID,FECID,Name FECName FROM FECCommittee WHERE FECCommitteeID=;OUTPUT NIL
SELECT Type RType,ParentContainer RParentContainer, PollEnd RPollEnd FROM Race WHERE RaceID=;OUTPUT NIL SELECT PollEnd IPollEnd FROM Race WHERE ParentContainer= AND (Type='General Election' OR Type='Running Mate') AND PollEnd < AND Silly!='Y' ORDER BY PollEnd DESC LIMIT 1;OUTPUT NIL SELECT RaceID PRaceID,PollEnd PPollEnd FROM Race WHERE ParentContainer= AND Type='Primary Election' AND PollEnd < AND PollEnd > ORDER BY PollEnd;OUTPUT CollectPrimaries
eq ''>ADD ne ''>EDIT VIDEO ADVERTISEMENT
Category
Major Ad Tone
Primary Language
Start Date
End Date
Run Time
Title
Code
Video
Description
Created By
For Candidate
Against Candidate
Issues
checked="checked"> SELECT IssueID,Name FROM Issue WHERE ParentIssue= AND Silly!='Y' ORDER BY Category,Priority DESC,Name;
FINISH
SELECT IssueID,Name FROM Issue WHERE ParentIssue=1 AND Silly!='Y' ORDER BY Category,Priority DESC,Name;OUTPUT
DMAs
checked="checked">
 SELECT ContainerID TCID,Name FROM Container WHERE ParentLink=83852 ORDER BY Name;OUTPUT
FEC Committee
FEC FilingFEC-
Total Spend
Silly? eq 'Y'> CHECKED> - Check if this AdVideo is not a serious political story.
 ne ''>
Return To View Video Advertisement