SELECT SecLink FROM Security WHERE SecLink=62 AND UserLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=44 AND UserLink=;OUTPUT NILDELETE FROM AdVideo WHERE AdVideoID=;FINISHPicking Up Ad Video. INSERT INTO Cart (UserLink,ItemType,ItemID) VALUES (,'AdVideo',);FINISHSELECT AdVideoID FROM AdVideo WHERE RaceLink=;OUTPUTDropping Ad Video. DELETE FROM Cart WHERE UserLink= AND ItemType='AdVideo' AND ItemID=;FINISHUPDATE AdVideo SET RaceLink= WHERE AdVideoID=;FINISHSELECT ItemID FROM Cart WHERE UserLink= AND ItemType='AdVideo';OUTPUT
VIDEO ADVERTISEMENTS
Start Date
Candidate
Category
Ad Tone
Lng
Title
Run Time
Contributor
SELECT AdVideoID,StartDate,Category,AdTone,Title,URLLink,CodeType,RunTime,Description,Silly,FirstEnter,LMBy,UserID,Nym,CandidateLink,VsCandidateLink,Code3 FROM AdVideo as a LEFT JOIN Language ON LanguageID=LanguageLink LEFT JOIN User ON UserID=LMBy WHERE RaceLink= AND UserID=LMBy ORDER BY StartDate DESC,EndDate DESC,Title LIMIT 100;
>
//
,Safe> ,Safe> vs ,Safe> ,Safe>
New!
OUTPUTSELECT AdVideoID,StartDate,Category,AdTone,Title,URLLink,CodeType,RunTime,Description,Silly,FirstEnter,LMBy,UserID,Nym,CandidateLink,VsCandidateLink,Code3 FROM Cart as ct LEFT JOIN AdVideo as a ON ct.UserLink= AND ct.ItemType='AdVideo' and AdVideoID=ct.ItemID LEFT JOIN Language ON LanguageID=LanguageLink LEFT JOIN User ON UserID=LMBy WHERE UserID=LMBy ORDER BY StartDate DESC,EndDate DESC,Title LIMIT 100;
