Error message: Error while executing query: SELECT TOP 12 p.id FROM ecmProducts p INNER JOIN ecmCategoryProducts c ON p.id=c.idProduct AND (p.idMainCategory IN (10011100,1001 1120,10013120) or c.idCategory IN (10011100,1001 1120,10013120)) AND p.Published=1 GROUP BY p.id ORDER BY (SELECT COUNT(ot.idOption) FROM cmsObjectTags ot WHERE ot.idTag=1000 and ot.idOption=10001106 and ot.idobject=p.id) DESC, NEWID()

Url: http://pharmacyclub.gr/skin.aspx?lang=el&itemtype=Product&itemid=0003A0F7&action=view&

Message: Error while executing query: SELECT TOP 12 p.id FROM ecmProducts p INNER JOIN ecmCategoryProducts c ON p.id=c.idProduct AND (p.idMainCategory IN (10011100,1001 1120,10013120) or c.idCategory IN (10011100,1001 1120,10013120)) AND p.Published=1 GROUP BY p.id ORDER BY (SELECT COUNT(ot.idOption) FROM cmsObjectTags ot WHERE ot.idTag=1000 and ot.idOption=10001106 and ot.idobject=p.id) DESC, NEWID()

   at Bone.DBConnection.Execute(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 92
   at Bone.DBConnection.ExecuteDBList[T](String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 251
   at Bone.BONE.ExecuteDBList[T](String sql) in C:\Bone\Bone\src\BONE.cs:line 1593
   at ASP.tpl_product_view_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\tpl\Product.View.tpl.ascx:line 393
   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 193
   at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 402
   at Bone.Action.ToString() in C:\Bone\Bone\src\Actions\_Action.cs:line 526
   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\wwwroot\skin.aspx:line 334
   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: Incorrect syntax near '1120'. Incorrect syntax near the keyword 'DESC'.

   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