Error code: 08D7A4380AB63148

Error message: Error while executing query: SELECT Combination,COUNT(Combination) AS count FROM ecmProductOptionsCombinations WHERE Stock>0 AND idProduct IN (SELECT p.id FROM ecmProducts p INNER JOIN cmsObjectTags cp ON p.id=cp.idObject WHERE cp.idOption=20000062 AND cp.ObjectType=N'Product' AND p.Published=1 AND cp.idProduct IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=20000062) AND ObjectType=N'Product')) GROUP BY Combination

   at Bone.DBConnection.Execute(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 63
   at Bone.BONE.Execute(String sql) in C:\Bone\Bone\src\BONE.cs:line 1023
   at ASP.tpl_tagoption_view_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\tpl\TagOption.View.tpl.ascx:line 227
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at Bone.ActionView.Render(TextWriter w) in C:\Bone\Bone\src\Actions\DBActions\ActionView.cs:line 180
   at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 393
   at Bone.Action.ToString() in C:\Bone\Bone\src\Actions\_Action.cs:line 517
   at Bone.Base.get_Content() in C:\Bone\Bone\src\Classes\Base.cs:line 79
   at ASP.skin_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\skin.aspx:line 192
   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 99
   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)

   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 57

1. SELECT Combination,COUNT(Combination) AS count FROM ecmProductOptionsCombinations WHERE Stock>0 AND idProduct IN (SELECT p.id FROM ecmProducts p INNER JOIN cmsObjectTags cp ON p.id=cp.idObject WHERE cp.idOption=20000062 AND cp.ObjectType=N'Product' AND p.Published=1 AND cp.idProduct IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=20000062) AND ObjectType=N'Product')) GROUP BY Combination
2. SELECT ot.idtag,ot.idOption,COUNT(ot.idOption) count FROM ecmCategoryProducts cp INNER JOIN cmsObjectTags ot ON cp.idproduct=ot.idobject INNER JOIN cmsTags t ON ot.idTag=t.id INNER JOIN ecmProducts p ON cp.idproduct=p.id WHERE ot.ObjectType=N'Product' AND ot.idOption=20000062 AND p.Published=1 AND t.IsActive=1 AND t.IsFilter=1 AND cp.idProduct IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=20000062) AND ObjectType=N'Product') GROUP BY ot.idTag,ot.idOption ORDER BY ot.idtag, ot.idOption
3. SELECT ot.idtag,ot.idOption,COUNT(ot.idOption) count FROM ecmCategoryProducts cp INNER JOIN cmsObjectTags ot ON cp.idproduct=ot.idobject INNER JOIN cmsTags t ON ot.idTag=t.id INNER JOIN ecmProducts p ON cp.idproduct=p.id WHERE ot.ObjectType=N'Product' AND ot.idOption=20000062 AND p.Published=1 AND t.IsActive=1 AND t.IsFilter=1 GROUP BY ot.idTag,ot.idOption ORDER BY ot.idtag, ot.idOption
4. SELECT Max(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) FROM ecmProducts p INNER JOIN cmsObjectTags c ON p.id=c.idObject WHERE c.idOption=20000062 AND c.ObjectType=N'Product' AND p.Published=1
5. SELECT tbl.id FROM cmsPopupMessages AS tbl WHERE Display>0
6. SELECT tbl.id FROM cmsTagOptionData AS tbl WHERE idOption=20000062
7. SELECT Data FROM bon_sessions_data WHERE name=N'WCAG_FRIENDLY' AND idSession=-623339442
8. SELECT id FROM bon_SessionsStats WHERE idUser=1 AND Session=N'lzmycdthacoiyb5vnstr5h2d' ORDER BY SessionDate DESC
9. SELECT id FROM bon_objectpermissions WHERE iduser=1 OR idrole=1 ORDER BY objecttype, idobject DESC, iduser DESC, idrole DESC
10. INSERT INTO bon_sessions (id,dateexpires,iduser) VALUES (-623339442,'2020-01-28 21:51:30',1)
11. SELECT id FROM bon_sessions WHERE id=-623339442
12. DELETE FROM bon_sessions WHERE DateExpires<'2020-01-28 21:21:30'