SELECT COUNT(*) ItemCnt FROM News WHERE 1=1 AND TO_DAYS(NewsDate)=TO_DAYS() AND Category= AND Headline LIKE AND Description LIKE AND FirstBy= ;OUTPUT NIL SELECT MediaID MedLink FROM Media where left(URL,) = LIMIT 1;OUTPUT NIL UPDATE News SET MediaLink= WHERE NewsID=;FINISH=
SELECT NewsID,URL FROM News WHERE MediaLink=0 AND URL != '';OUTPUT SeMeLi SELECT SecLink FROM Security WHERE SecLink=14 AND UserLink=;OUTPUT NIL

  News

News Deleted.
SELECT Headline FROM News WHERE NewsID=;OUTPUT NIL INSERT INTO DeleteLog (DeleteType,DeleteID,Person,Details) VALUES ('News',,,);FINISH DELETE FROM Discussion WHERE AttachTo='News' AND AttachLink=;FINISH DELETE FROM NewsAttach WHERE NewsLink=;FINISH DELETE FROM News WHERE NewsID=;FINISH

>SELECT NewsID,Headline,URL,UserID TUserID,Nym TNym,NewsDate,Category,Silly FROM News,User WHERE 1=1 AND TO_DAYS(NewsDate)=TO_DAYS() AND Category= AND Headline LIKE AND Description LIKE AND FirstBy= AND Silly!='Y' AND UserID=FirstBy ORDER BY NewsDate DESC LIMIT ,;OUTPUT NEWS - of Date Category -- selected> SELECT DISTINCT Category TCat FROM News ORDER BY TCat;OUTPUT Headline Article Contributor -- selected> SELECT DISTINCT UserID TUID,Nym TNym FROM News,User WHERE UserID=FirstBy ORDER BY TNym;OUTPUT > ,  :   eq ''>Not Available ne ''>Article