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 '% 出铝%' ) 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 '% 出铝%' ) 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/鎵撳3 鍑洪摑.html