OpenWBS Error

[22]:Invalid query conditions, unable to get the record set!

  • Error.Message: OpenWBS.DB.GetRecordBySQL: Select Top 200 ID,Title,Thumbnail,Abstract,SeoUrl,Fn_System,sort,hot,ontop,elite from (SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'product' As Fn_System,'1' as sort,hot,ontop,elite from [owbs_Content_product] where Status=1 AND Recycle=0 And ClassID IN (1,59,57,2,39,40,43,44,5,3,16,17,20,21,18,19,4,7,8,9,10,11,12,13,14,15,41,42,47,48,49,50,51,52,53,54,55,56,58,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,6,22,45) And (Title Like '%调速阀 接头%' or Abstract Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'product' As Fn_System,'2' as sort,hot,ontop,elite from [owbs_Content_product] where Status=1 AND Recycle=0 And ClassID IN (1,59,57,2,39,40,43,44,5,3,16,17,20,21,18,19,4,7,8,9,10,11,12,13,14,15,41,42,47,48,49,50,51,52,53,54,55,56,58,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,6,22,45) And (Title Like '%调速阀%' or Abstract Like '%调速阀%') And (Title Not Like '%调速阀 接头%' And Abstract Not Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'product' As Fn_System,'2' as sort,hot,ontop,elite from [owbs_Content_product] where Status=1 AND Recycle=0 And ClassID IN (1,59,57,2,39,40,43,44,5,3,16,17,20,21,18,19,4,7,8,9,10,11,12,13,14,15,41,42,47,48,49,50,51,52,53,54,55,56,58,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,6,22,45) And (Title Like '%接头%' or Abstract Like '%接头%') And (Title Not Like '%调速阀 接头%' And Abstract Not Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'product' As Fn_System,'3' as sort,hot,ontop,elite from [owbs_Content_product] where Status=1 AND Recycle=0 And ClassID IN (1,59,57,2,39,40,43,44,5,3,16,17,20,21,18,19,4,7,8,9,10,11,12,13,14,15,41,42,47,48,49,50,51,52,53,54,55,56,58,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,6,22,45) And ( Title Like '%调速阀%' Or Abstract Like '%调速阀%' Or Title Like '%速阀 %' Or Abstract Like '%速阀 %' Or Title Like '%阀 接%' Or Abstract Like '%阀 接%' Or Title Like '% 接头%' Or Abstract Like '% 接头%' ) And (Title Not Like '%调速阀 接头%' And Abstract Not Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'imports' As Fn_System,'1' as sort,hot,ontop,elite from [owbs_Content_imports] where Status=1 AND Recycle=0 And ClassID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,24,25,26,27,28,29,22,23,286,287,288,289,290,291,292,293,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,277,278,279,280,281,282,283,284,285) And (Title Like '%调速阀 接头%' or Abstract Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'imports' As Fn_System,'2' as sort,hot,ontop,elite from [owbs_Content_imports] where Status=1 AND Recycle=0 And ClassID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,24,25,26,27,28,29,22,23,286,287,288,289,290,291,292,293,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,277,278,279,280,281,282,283,284,285) And (Title Like '%调速阀%' or Abstract Like '%调速阀%') And (Title Not Like '%调速阀 接头%' And Abstract Not Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'imports' As Fn_System,'2' as sort,hot,ontop,elite from [owbs_Content_imports] where Status=1 AND Recycle=0 And ClassID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,24,25,26,27,28,29,22,23,286,287,288,289,290,291,292,293,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,277,278,279,280,281,282,283,284,285) And (Title Like '%接头%' or Abstract Like '%接头%') And (Title Not Like '%调速阀 接头%' And Abstract Not Like '%调速阀 接头%') Union SELECT TOP 100 ID,Title,Thumbnail, convert(varchar(300),Abstract) As Abstract,SeoUrl,'imports' As Fn_System,'3' as sort,hot,ontop,elite from [owbs_Content_imports] where Status=1 AND Recycle=0 And ClassID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,24,25,26,27,28,29,22,23,286,287,288,289,290,291,292,293,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,277,278,279,280,281,282,283,284,285) And ( Title Like '%调速阀%' Or Abstract Like '%调速阀%' Or Title Like '%速阀 %' Or Abstract Like '%速阀 %' Or Title Like '%阀 接%' Or Abstract Like '%阀 接%' Or Title Like '% 接头%' Or Abstract Like '% 接头%' ) And (Title Not Like '%调速阀 接头%' And Abstract Not Like '%调速阀 接头%') ) As [allProduct2000] Order by sort asc,hot desc,ontop desc,elite desc
  • Error.Page: http://www.ekw6.com/index.asp?tag/璋冮闃鎺ュご.html