Error message: Error while executing query: SELECT * FROM (SELECT p.id,ROW_NUMBER() OVER (ORDER BY (CASE WHEN (p.Discount=0) THEN p.NetPrice WHEN (p.Discount>0 AND p.DiscountType=0) THEN (p.NetPrice-(p.NetPrice * p.Discount/100)) WHEN (p.Discount>0 AND p.DiscountType=1) THEN (p.NetPrice- p.Discount) END) 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=priceasc

Message: Error while executing query: SELECT * FROM (SELECT p.id,ROW_NUMBER() OVER (ORDER BY (CASE WHEN (p.Discount=0) THEN p.NetPrice WHEN (p.Discount>0 AND p.DiscountType=0) THEN (p.NetPrice-(p.NetPrice * p.Discount/100)) WHEN (p.Discount>0 AND p.DiscountType=1) THEN (p.NetPrice- p.Discount) END) 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.Discount' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.NetPrice' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.Discount' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.DiscountType' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.NetPrice' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.NetPrice' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.Discount' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.Discount' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.DiscountType' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.NetPrice' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Column 'ecmProducts.Discount' 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