Error message: Error while executing query: SELECT COUNT(tbl.id) FROM ecmProducts tbl INNER JOIN ecmCategoryProducts as C ON tbl.id=c.idProduct WHERE c.idCategory IN (-191550815,1337110727,112208651,1991781862,1287159804,-1305450540,-1653923159 ) AND tbl.Published=1 AND tbl.Stock>0 and tbl.Discount>0 AND tbl.id IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=786070747 OR idOption=12697794 OR idOption=-1162726096 OR idOption=-1407318723 OR idOption=915261681 OR idOption=-1544228146) AND ObjectType=N'Product')

Url: https://yuppietoys.gr/skin.aspx?lang=el&action=sales&00000FA0=2EDA7CDB‡00C1C0C2‡BAB23530‡AC1E053D‡368DC8F1‡A3F4F2CE&splitter_products_offset=0

Message: Error while executing query: SELECT COUNT(tbl.id) FROM ecmProducts tbl INNER JOIN ecmCategoryProducts as C ON tbl.id=c.idProduct WHERE c.idCategory IN (-191550815,1337110727,112208651,1991781862,1287159804,-1305450540,-1653923159 ) AND tbl.Published=1 AND tbl.Stock>0 and tbl.Discount>0 AND tbl.id IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=786070747 OR idOption=12697794 OR idOption=-1162726096 OR idOption=-1407318723 OR idOption=915261681 OR idOption=-1544228146) AND ObjectType=N'Product')

   at Bone.DBConnection.ExecuteScalar(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 236
   at Bone.BONE.ExecuteScalar(String sql) in C:\Bone\Bone\src\BONE.cs:line 1777
   at ASP.tpl_actionsales_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\yuppietoys\tpl\ActionSales.tpl.ascx:line 353
   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 443
   at Bone.Action.ToString() in C:\Bone\Bone\src\Actions\_Action.cs:line 606
   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\yuppietoys\skin.aspx:line 345
   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 66
   at Bone.ModalAction.RenderPage(TextWriter w) in C:\Bone\Bone\src\Actions\Modal.cs:line 87
   at Bone.Asp.Render(HtmlTextWriter w) in C:\Bone\Bone\src\Classes\Asp.cs:line 77
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Message: Transaction (Process ID 82) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

   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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Bone.DBConnection.ExecuteScalar(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 222