SELECT * FROM AdVideo WHERE AdVideoID=;OUTPUT NIL SELECT * FROM AdVideoLog WHERE AdVideoLogID=;OUTPUT NIL DELETE FROM UserNewItems WHERE UserLink= AND ItemType='AdVideo' AND ItemLink=;FINISH INSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'AdVideo',,Now());FINISH SELECT Nym FROM User WHERE UserID=;OUTPUT NIL SELECT Nym CNym FROM User WHERE UserID=;OUTPUT NIL SELECT Name PName FROM Party WHERE PartyID=;OUTPUT NIL SELECT Name LName FROM Language WHERE LanguageID=;OUTPUT NIL

  ""

SELECT SecLink FROM Security WHERE SecLink=43 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=45 AND UserLink=;OUTPUT NIL SELECT PollEnd,Title FROM Race WHERE RaceID=;OUTPUT NIL SELECT IssueID,Name IssueName FROM AdVideoIssue,Issue WHERE AdVideoLink= AND IssueID=IssueLink ORDER BY Name;FINISH SELECT FirstName,LastName FROM Candidate WHERE CandidateID=;OUTPUT NIL SELECT FirstName,LastName FROM Candidate WHERE CandidateID=;OUTPUT NIL SELECT ContainerID DMAID,Name DMAName FROM AdVideoDMA,Container WHERE AdVideoLink= AND ContainerID=DMALink ORDER BY Name;FINISH SELECT FECCommitteeID,FECID,Name FECName FROM FECCommittee WHERE FECCommitteeID=;OUTPUT NIL SELECT Name MediaName FROM Media WHERE MediaID=;OUTPUT NIL SELECT Quality YRate FROM AdVideoRating WHERE AdVideoLink= AND UserLink=;OUTPUT NIL [X] LOGGED VIDEO ADVERTISEMENT DETAILS Race // - Video Run Date(s) - Run Time Category Ad Tone Issue(s) | OUTPUT Language For Candidate Against DMA(s) | OUTPUT FEC Committee - Filing Code FEC- Total Spend $ Media Contributor   Last Edited   > ,  : Logged SELECT COUNT(*) NumLogged FROM AdVideoLog WHERE AdVideoID=;OUTPUT NIL [Current] SELECT AdVideoLogID TNLID,LogDate TLD FROM AdVideoLog WHERE AdVideoID= AND LogDate > ORDER BY LogDate LIMIT 1;OUTPUT NIL [Newer] SELECT AdVideoLogID TNLID,LogDate TLD FROM AdVideoLog WHERE AdVideoID= AND LogDate < ORDER BY LogDate DESC LIMIT 1;OUTPUT NIL [Older] SELECT AdVideoLogID TNLID,LogDate TLD FROM AdVideoLog WHERE AdVideoID= ORDER BY LogDate DESC LIMIT 1;OUTPUT NIL [Older] Description ne 'Y'>,plaintext> User Ratings /10 Your Rating 2¢ 2¢ x SELECT Emote,COUNT(UserLink) NumEm FROM OtherEmote WHERE AttachType='AdVideo' AND AttachID= GROUP BY Emote;OUTPUT DoEmotes