Error message: Error while executing query: SELECT * FROM (SELECT tbl.id,ROW_NUMBER() OVER (ORDER BY tbl.Title ) AS ROW FROM ecmProducts AS tbl INNER JOIN ecmCategoryProducts AS tbl2 ON tbl.id=tbl2.idProduct WHERE (tbl.Published=1 AND tbl.Stock>0 ) AND tbl2.idCategory=-531918122 AND tbl.id IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=1370107861 OR idOption=-1948703821 OR idOption=-386481361 OR idOption=799386855 OR idOption=846006172 OR idOption=-881428350 OR idOption=-1161563934) AND ObjectType=N'Product') AND tbl.id NOT IN (SELECT idObject FROM bonExtraFieldData WHERE name=N'relitem' AND cast(fielddata as nvarchar(max)) IS NOT NULL AND cast(fielddata as nvarchar(max))<>'' AND cast(fielddata as nvarchar(max))<>'0')) AS TR WHERE ROW BETWEEN 97 AND 120

Url: http://www.deltabox.gr/skin.aspx?lang=el&itemtype=ProductCategory&itemid=E04B92D6&action=view&F7DA7F85=51AA2FD5‡8BD923B3‡E8F6C32F‡2FA5ACE7‡326D079C‡CB767882‡BAC3F0E2&splitter_products_offset=96

Message: Error while executing query: SELECT * FROM (SELECT tbl.id,ROW_NUMBER() OVER (ORDER BY tbl.Title ) AS ROW FROM ecmProducts AS tbl INNER JOIN ecmCategoryProducts AS tbl2 ON tbl.id=tbl2.idProduct WHERE (tbl.Published=1 AND tbl.Stock>0 ) AND tbl2.idCategory=-531918122 AND tbl.id IN (SELECT idObject FROM cmsObjectTags WHERE ( idOption=1370107861 OR idOption=-1948703821 OR idOption=-386481361 OR idOption=799386855 OR idOption=846006172 OR idOption=-881428350 OR idOption=-1161563934) AND ObjectType=N'Product') AND tbl.id NOT IN (SELECT idObject FROM bonExtraFieldData WHERE name=N'relitem' AND cast(fielddata as nvarchar(max)) IS NOT NULL AND cast(fielddata as nvarchar(max))<>'' AND cast(fielddata as nvarchar(max))<>'0')) AS TR WHERE ROW BETWEEN 97 AND 120

   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 1577
   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 3907
   at Bone.BONE.Select[T](String where, String order, String innerjoinexpression, Nullable`1 offset, Nullable`1 limit, Boolean checkpermissions, Boolean nocache, Boolean nocacheifzerocount) in C:\Bone\Bone\src\BONE.cs:line 3821
   at Bone.DBAbstractItem`1.Select(String where, String order, String innerjoinexpression, Nullable`1 offset, Nullable`1 limit, Boolean checkpermissions, Boolean nocache) in C:\Bone\Bone\src\EngineDB\DBItem.cs:line 45
   at ASP.tpl_productcategory_view_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\vhosts\deltabox.gr\tpl\ProductCategory.View.tpl.ascx:line 288
   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 230
   at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 436
   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\vhosts\deltabox.gr\skin.aspx:line 235
   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: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

   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