Error message: Error while executing query: SELECT * FROM (SELECT p.id,ROW_NUMBER() OVER (ORDER BY CAST(p.Title AS VARCHAR(MAX)) ASC) AS ROW FROM ecmProducts AS p WHERE p.Published=1 AND ( p.Title LIKE '%ΑΚΑΔΗΜΑΙΚΑ%' OR p.Code LIKE '%ΑΚΑΔΗΜΑΙΚΑ%' OR p.Code2 LIKE '%ΑΚΑΔΗΜΑΙΚΑ%' OR p.Title LIKE '%ΑΚΑΔΗΜΑΙΚ%' OR p.Code LIKE '%ΑΚΑΔΗΜΑΙΚ%' OR p.Code2 LIKE '%ΑΚΑΔΗΜΑΙΚ%' OR p.Title LIKE '%AKADHMAIKA%' OR p.Code LIKE '%AKADHMAIKA%' OR p.Code2 LIKE '%AKADHMAIKA%' OR p.Title LIKE '%ΑΚΑΔΙΜΕΚ%' OR p.Code LIKE '%ΑΚΑΔΙΜΕΚ%' OR p.Code2 LIKE '%ΑΚΑΔΙΜΕΚ%') AND ( p.Title LIKE '%ΗΜΕΡΟΛΟΓΙΑ%' OR p.Code LIKE '%ΗΜΕΡΟΛΟΓΙΑ%' OR p.Code2 LIKE '%ΗΜΕΡΟΛΟΓΙΑ%' OR p.Title LIKE '%ΗΜΕΡΟΛΟΓ%' OR p.Code LIKE '%ΗΜΕΡΟΛΟΓ%' OR p.Code2 LIKE '%ΗΜΕΡΟΛΟΓ%' OR p.Title LIKE '%HMEROLOGIA%' OR p.Code LIKE '%HMEROLOGIA%' OR p.Code2 LIKE '%HMEROLOGIA%' OR p.Title LIKE '%ΙΜΕΡΟΛΟΓ%' OR p.Code LIKE '%ΙΜΕΡΟΛΟΓ%' OR p.Code2 LIKE '%ΙΜΕΡΟΛΟΓ%') AND ( p.Title LIKE '%ΗΜΕΡΗΣΙΑ%' OR p.Code LIKE '%ΗΜΕΡΗΣΙΑ%' OR p.Code2 LIKE '%ΗΜΕΡΗΣΙΑ%' OR p.Title LIKE '%ΗΜΕΡΗΣ%' OR p.Code LIKE '%ΗΜΕΡΗΣ%' OR p.Code2 LIKE '%ΗΜΕΡΗΣ%' OR p.Title LIKE '%HMERHSIA%' OR p.Code LIKE '%HMERHSIA%' OR p.Code2 LIKE '%HMERHSIA%' OR p.Title LIKE '%ΙΜΕΡΙΣ%' OR p.Code LIKE '%ΙΜΕΡΙΣ%' OR p.Code2 LIKE '%ΙΜΕΡΙΣ%') AND NetPrice>0 GROUP BY p.id,dbo.Lemma(p.Title, 'el')) AS TR WHERE ROW BETWEEN 1 AND 32

Url: https://allforoffice.gr/skin.aspx?lang=el&action=searchresults&idagent=CCC03C0A&sortby=title

Message: Error while executing query: SELECT * FROM (SELECT p.id,ROW_NUMBER() OVER (ORDER BY CAST(p.Title AS VARCHAR(MAX)) ASC) AS ROW FROM ecmProducts AS p WHERE p.Published=1 AND ( p.Title LIKE '%ΑΚΑΔΗΜΑΙΚΑ%' OR p.Code LIKE '%ΑΚΑΔΗΜΑΙΚΑ%' OR p.Code2 LIKE '%ΑΚΑΔΗΜΑΙΚΑ%' OR p.Title LIKE '%ΑΚΑΔΗΜΑΙΚ%' OR p.Code LIKE '%ΑΚΑΔΗΜΑΙΚ%' OR p.Code2 LIKE '%ΑΚΑΔΗΜΑΙΚ%' OR p.Title LIKE '%AKADHMAIKA%' OR p.Code LIKE '%AKADHMAIKA%' OR p.Code2 LIKE '%AKADHMAIKA%' OR p.Title LIKE '%ΑΚΑΔΙΜΕΚ%' OR p.Code LIKE '%ΑΚΑΔΙΜΕΚ%' OR p.Code2 LIKE '%ΑΚΑΔΙΜΕΚ%') AND ( p.Title LIKE '%ΗΜΕΡΟΛΟΓΙΑ%' OR p.Code LIKE '%ΗΜΕΡΟΛΟΓΙΑ%' OR p.Code2 LIKE '%ΗΜΕΡΟΛΟΓΙΑ%' OR p.Title LIKE '%ΗΜΕΡΟΛΟΓ%' OR p.Code LIKE '%ΗΜΕΡΟΛΟΓ%' OR p.Code2 LIKE '%ΗΜΕΡΟΛΟΓ%' OR p.Title LIKE '%HMEROLOGIA%' OR p.Code LIKE '%HMEROLOGIA%' OR p.Code2 LIKE '%HMEROLOGIA%' OR p.Title LIKE '%ΙΜΕΡΟΛΟΓ%' OR p.Code LIKE '%ΙΜΕΡΟΛΟΓ%' OR p.Code2 LIKE '%ΙΜΕΡΟΛΟΓ%') AND ( p.Title LIKE '%ΗΜΕΡΗΣΙΑ%' OR p.Code LIKE '%ΗΜΕΡΗΣΙΑ%' OR p.Code2 LIKE '%ΗΜΕΡΗΣΙΑ%' OR p.Title LIKE '%ΗΜΕΡΗΣ%' OR p.Code LIKE '%ΗΜΕΡΗΣ%' OR p.Code2 LIKE '%ΗΜΕΡΗΣ%' OR p.Title LIKE '%HMERHSIA%' OR p.Code LIKE '%HMERHSIA%' OR p.Code2 LIKE '%HMERHSIA%' OR p.Title LIKE '%ΙΜΕΡΙΣ%' OR p.Code LIKE '%ΙΜΕΡΙΣ%' OR p.Code2 LIKE '%ΙΜΕΡΙΣ%') AND NetPrice>0 GROUP BY p.id,dbo.Lemma(p.Title, 'el')) AS TR WHERE ROW BETWEEN 1 AND 32

   at Bone.DBConnection.Execute(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 92
   at Bone.BONE.Execute(String sql) in C:\Bone\Bone\src\BONE.cs:line 1527
   at Bone.BONE.Select[T](String where, String order, String innerjoinexpression, Nullable`1 offset, Nullable`1 limit, Boolean checkpermissions, Boolean nocache, Boolean nocacheifzerocount, String tableQueryAlias) in C:\Bone\Bone\src\BONE.cs:line 3820
   at Bone.DBAbstractItem`1.Select(String where, String order, String innerjoinexpression, Nullable`1 offset, Nullable`1 limit, Boolean checkpermissions, Boolean nocache, String tableQueryAlias) in C:\Bone\Bone\src\EngineDB\DBItem.cs:line 43
   at Ecommerce.ProductsControl.Render(TextWriter w) in C:\Bone\Ecommerce\src\Controls\ProductsControl.cs:line 1593
   at Bone.UIControl.ToString() in C:\Bone\Bone\src\EngineUI\_Control.cs:line 30
   at System.IO.TextWriter.Write(Object value)
   at ASP.tpl_actionsearchresults_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\allforoffice\tpl\ActionSearchResults.tpl.ascx:line 171
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 411
   at Bone.Action.ToString() in C:\Bone\Bone\src\Actions\_Action.cs:line 528
   at Bone.Base.get_Content() in C:\Bone\Bone\src\Classes\Base.cs:line 81
   at ASP.skin_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\allforoffice\skin.aspx:line 361
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Page.Render(HtmlTextWriter writer)
   at Bone.Asp.RenderSkin(TextWriter w) in C:\Bone\Bone\src\Classes\Asp.cs:line 71
   at Bone.ModalAction.RenderPage(TextWriter w) in C:\Bone\Bone\src\Actions\Modal.cs:line 81
   at Bone.Asp.Render(HtmlTextWriter w) in C:\Bone\Bone\src\Classes\Asp.cs:line 82
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Message: Column 'ecmProducts.Title' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

   at System.Data.SqlClient.SqlConnection.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 Bone.DBConnection.Execute(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 80