SQL ERROR

System.Data.SqlClient.SqlException (0x80131904): The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at ClassCommonFuncV2.CommonFunctionsV2.dbconnect(Object sql, Object sqlname) in h:\root\home\a2zevents-001\www\site1\App_Code\CommonFunctionsV2.vb:line 121
ClientConnectionId:4584f7ef-17b2-4c03-be42-3c55b6928d36
Error Number:1033,State:1,Class:15
SELECT top 100 * FROM ( SELECT f.ID, f.CLASSID,f.TEACHERID, f.VENUEID, f.USERID, f.EVENTID, f.datelogged, f.PROFILEID, f.TOPICID, f.NEWSID, f.LINKID, f.Code,f.WLURL2, f.Type, year(DATEADD(ss, datelogged, '19700101')) AS year1, month(DATEADD(ss, datelogged, '19700101')) AS month1, day(DATEADD(ss, datelogged, '19700101')) AS day1 FROM tbl_Feed as f INNER JOIN tbl_feedTemp ON ID = ID2 AND SITEID =1 and TYPE<>'TOPIC' ORDER BY f.dateLogged DESC ) AS a GROUP BY a.USERID,a.Type, ID, CLASSID, TEACHERID, VENUEID, EVENTID, DateLogged, PROFILEID, TOPICID, NEWSID, LINKID, Code, WLURL2, year1, month1, day1 Order by a.dateLogged desc