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 '%迷你气缸 小气缸 QGX%' or Abstract Like '%迷你气缸 小气缸 QGX%') 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 '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%QGX%' or Abstract Like '%QGX%') And (Title Not Like '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%缸 小%' Or Title Like '% 小气%' Or Abstract Like '% 小气%' Or Title Like '%小气缸%' Or Abstract Like '%小气缸%' Or Title Like '%气缸 %' Or Abstract Like '%气缸 %' Or Title Like '%缸 Q%' Or Abstract Like '%缸 Q%' Or Title Like '% QG%' Or Abstract Like '% QG%' Or Title Like '%QGX%' Or Abstract Like '%QGX%' ) And (Title Not Like '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%迷你气缸 小气缸 QGX%' or Abstract Like '%迷你气缸 小气缸 QGX%') 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 '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%QGX%' or Abstract Like '%QGX%') And (Title Not Like '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') 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 '%缸 小%' Or Title Like '% 小气%' Or Abstract Like '% 小气%' Or Title Like '%小气缸%' Or Abstract Like '%小气缸%' Or Title Like '%气缸 %' Or Abstract Like '%气缸 %' Or Title Like '%缸 Q%' Or Abstract Like '%缸 Q%' Or Title Like '% QG%' Or Abstract Like '% QG%' Or Title Like '%QGX%' Or Abstract Like '%QGX%' ) And (Title Not Like '%迷你气缸 小气缸 QGX%' And Abstract Not Like '%迷你气缸 小气缸 QGX%') ) As [allProduct2000] Order by sort asc,hot desc,ontop desc,elite desc
  • Error.Page: http://www.ekw6.com/index.asp?tag/杩蜂綘姘旂几 灏忔皵缂?QGX.html