SELECT BannerID, Title, Script, PositionID FROM Banner WHERE PositionID = '1' AND RowStatus <> 'DE'SELECT BannerID, Title, Script, PositionID FROM Banner WHERE PositionID = '4' AND RowStatus <> 'DE'SELECT BannerID, Title, Script, PositionID FROM Banner WHERE PositionID = '2' AND RowStatus <> 'DE'SELECT BannerID, Title, Script, PositionID FROM Banner WHERE PositionID = '3' AND RowStatus <> 'DE' SELECT G.IssueID, G.IssueDate, G.IssueNumber, date_format(G.IssueDate,'%Y-%m') AS YearMonth FROM Issue AS G WHERE G.IssueDate IN (SELECT MAX(IssueDate) FROM Issue WHERE RowStatus <> 'DE') AND G.RowStatus <> 'DE'SELECT CategoryID, Name, TypeID, TemplateID FROM NewsTypeCategory WHERE CategoryID = '73' SELECT N.NewsID, N.Title, N.Summary, N.Content, N.ImageID, N.Image2ID, N.NewsDate, N.Source, N.CategoryID, C.Name AS CategoryName, N.Status, N.LastUpdate, N.IssueDate, N.Extract, N.Author, N.PreparedBy FROM News AS N INNER JOIN NewsTypeCategory AS C ON C.CategoryID = N.CategoryID WHERE N.RowStatus <> 'DE' AND N.CategoryID = '73' ORDER BY N.NewsDate DESC LIMIT 0,5 SELECT COUNT(NewsID) FROM News AS N INNER JOIN NewsTypeCategory AS C ON C.CategoryID = N.CategoryID WHERE N.RowStatus <> 'DE' AND N.CategoryID = '73' LIMIT 0,1
SELECT CategoryID, Name, TypeID, TemplateID FROM NewsTypeCategory WHERE RowStatus <> 'DE' AND TypeID = '1'SELECT CategoryID, Name, TypeID, TemplateID FROM NewsTypeCategory WHERE RowStatus <> 'DE' AND TypeID = '2'SELECT CategoryID, Name, TypeID, TemplateID FROM NewsTypeCategory WHERE RowStatus <> 'DE' AND TypeID = '3'SELECT CategoryID, Name, TypeID, TemplateID FROM NewsTypeCategory WHERE RowStatus <> 'DE' AND TypeID = '4'SELECT AlbumID, Name, Description, CreateDate, UNIX_TIMESTAMP(CreateDate) AS UnixDate, Status, AlbumDate FROM Album WHERE RowStatus <> 'DE'