來自Global的錯誤處理
在應使用條件的上下文(在 'CHARINDE' 附近)中指定了非布爾類型的表達式。
“,”附近有語法錯誤。
SELECT TOP 0 IDENTITY(int,1,1) AS RowIndex,a.ProductID * 1 as ProductID,a.ProductName,a.ClassID,a.RlCode,a.MacCode,a.ProLabel,(SELECT ClassName + ',' FROM dbo.CNVP_Class WHERE ClassArea = 3 AND CHARINDEX(CAST(ClassID AS VARCHAR(200)),',' + a.FitCar + ',')>0 FOR XML PATH('') ) AS FitName,(SELECT COUNT(*) FROM dbo.CNVP_Favorite WHERE ProductID = a.ProductID) AS FavCnt,ProCnt=0,b.ImgAddress, case when ImgAddress is null then 0 else 1 end as IsHasImg INTO #tmpPage FROM CNVP_Product a LEFT JOIN (SELECT * FROM CNVP_ProductImg WHERE IsMain = 1) b ON a.ProductID = b.ProductID WHERE 1 = 1 and isnull(a.Status,0) = 0 and a.ClassID in (3015,3022,3055,3023,3056,3024,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3025,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3026,3078,3079,3080,3081,3082,3083,3084,3085,3086,3027,3087) and( CHARINDEX(',2753,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3237,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2800,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2801,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2802,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2803,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2804,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2805,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2806,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2807,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2808,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2809,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2810,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2811,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2812,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2954,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2971,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2981,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2982,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2759,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2813,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2814,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2815,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2816,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2817,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2818,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2998,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3000,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3001,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3002,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2763,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2829,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2830,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2831,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2832,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2986,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2760,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2819,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2820,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2821,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2761,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2822,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2823,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2824,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2825,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2765,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2835,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2836,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2837,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2838,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2839,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2764,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3222,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2833,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2834,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2767,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2843,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2844,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2768,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2845,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2846,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2955,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2956,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2972,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2973,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2974,',',' + a.FitCar + '
INSERT INTO #tmpPage SELECT TOP 20 a.ProductID * 1 as ProductID,a.ProductName,a.ClassID,a.RlCode,a.MacCode,a.ProLabel,(SELECT ClassName + ',' FROM dbo.CNVP_Class WHERE ClassArea = 3 AND CHARINDEX(CAST(ClassID AS VARCHAR(200)),',' + a.FitCar + ',')>0 FOR XML PATH('') ) AS FitName,(SELECT COUNT(*) FROM dbo.CNVP_Favorite WHERE ProductID = a.ProductID) AS FavCnt,ProCnt=0,b.ImgAddress, case when ImgAddress is null then 0 else 1 end as IsHasImg FROM CNVP_Product a LEFT JOIN (SELECT * FROM CNVP_ProductImg WHERE IsMain = 1) b ON a.ProductID = b.ProductID WHERE 1 = 1 and isnull(a.Status,0) = 0 and a.ClassID in (3015,3022,3055,3023,3056,3024,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3025,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3026,3078,3079,3080,3081,3082,3083,3084,3085,3086,3027,3087) and( CHARINDEX(',2753,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3237,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2800,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2801,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2802,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2803,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2804,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2805,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2806,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2807,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2808,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2809,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2810,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2811,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2812,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2954,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2971,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2981,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2982,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2759,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2813,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2814,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2815,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2816,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2817,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2818,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2998,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3000,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3001,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3002,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2763,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2829,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2830,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2831,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2832,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2986,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2760,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2819,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2820,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2821,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2761,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2822,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2823,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2824,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2825,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2765,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2835,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2836,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2837,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2838,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2839,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2764,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3222,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2833,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2834,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2767,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2843,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2844,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2768,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2845,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2846,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2955,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2956,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2972,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2973,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2974,',',' + a.FitCar + ',') > 0 or CHARINDEX(',
SELECT TOP 0 IDENTITY(int,1,1) AS RowIndex,a.ProductID * 1 as ProductID,a.ProductName,a.ClassID,a.RlCode,a.MacCode,a.ProLabel,(SELECT ClassName + ',' FROM dbo.CNVP_Class WHERE ClassArea = 3 AND CHARINDEX(CAST(ClassID AS VARCHAR(200)),',' + a.FitCar + ',')>0 FOR XML PATH('') ) AS FitName,(SELECT COUNT(*) FROM dbo.CNVP_Favorite WHERE ProductID = a.ProductID) AS FavCnt,ProCnt=0,b.ImgAddress, case when ImgAddress is null then 0 else 1 end as IsHasImg INTO #tmpPage FROM CNVP_Product a LEFT JOIN (SELECT * FROM CNVP_ProductImg WHERE IsMain = 1) b ON a.ProductID = b.ProductID WHERE 1 = 1 and isnull(a.Status,0) = 0 and a.ClassID in (3015,3022,3055,3023,3056,3024,3057,3058,3059,3060,3061,3062,3063,3064,3065,3066,3067,3025,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3026,3078,3079,3080,3081,3082,3083,3084,3085,3086,3027,3087) and( CHARINDEX(',2753,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3237,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2800,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2801,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2802,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2803,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2804,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2805,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2806,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2807,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2808,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2809,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2810,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2811,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2812,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2954,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2971,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2981,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2982,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2759,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2813,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2814,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2815,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2816,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2817,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2818,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2998,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3000,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3001,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3002,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2763,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2829,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2830,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2831,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2832,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2986,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2760,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2819,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2820,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2821,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2761,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2822,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2823,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2824,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2825,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2765,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2835,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2836,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2837,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2838,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2839,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2764,',',' + a.FitCar + ',') > 0 or CHARINDEX(',3222,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2833,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2834,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2767,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2843,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2844,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2768,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2845,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2846,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2955,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2956,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2972,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2973,',',' + a.FitCar + ',') > 0 or CHARINDEX(',2974,',',' + a.FitCar + '产精品视频在线观看免费
精品一区卡2卡3卡|
一本v亚洲v天堂一区二区|
黑色家族的秘婚魅宠7分77秒|
撸不停直播|
日本高清网站|
宝宝的水喷得到处都是小作文|
国产99精品成人免费视频|
精品毛卡卡1卡2卡3麻豆|
亚洲无码导航|
日本一本在线|
亚洲一日韩2卡3卡4卡5卡|
宋欢颜云简琛在水里|
把女朋友变成三孔插座|
视频一区国产第一页|
偷窥美女洗澡一区二区三区|
亚洲精品综合在线影院|
欧美日韩国产综合视频在线观看|
97人妻一区二区精品免费|
亚洲中文无码永久免费|
中文字幕无线观看不卡网站|
国产成人久久一区二区不卡|
国产色爽免费无码视频|
精品乱码亚洲一区二区不卡|
2018高清日本一道国产-在|
国产欧美日韩综合一区在线播放|
亚洲免费视频费观看在线|
掐着腰按在墙上|
日本一二三区免费不卡|
国产乱了伦视频大全亚琴影院|
欧美阿v高清资源不卡在线播放|
国色天香久久精品国产一区|
穿越古代做农妇继室|
日产一卡二卡福利|
日韩不卡在线观看视频不卡|
日产—卡2卡三卡四卡二卡|
嫁给首辅当继妻|
少妇一丝无挂毛片好看爽|
色妞AV永久一区二区国产AV|
亚洲国产精品一在线观看蜜桃AV|
亚洲一区二区三区四区不卡|
师父不可以(限)洛灵犀笔趣阁|
亚洲一卡2卡3卡4卡5卡国色天香|
亚洲国产精品一区二区久久第|
欧美日韩在线精品视频二区下载|
小小影视在线播放免费观看|
国内精品久久人妻无码HD浪潮|
新界名媛:总裁的第一爱妻|
日韩在线卡2卡3卡4卡5卡乱码|
亚洲精品天堂无码中文字幕影院|
色天香大豆行情网|
我等不及了就在这花园|
国产日产欧洲无码视频精品|
亚洲乱码国产乱码精品精天堂|
国产91日本一区二区三区|
韩国一卡二卡三卡四卡网站|
不知节制的索要了一整|
最新午夜国内自拍视频|
精品成人乱色一区二区|
一本一本久久a久久综合精品|
在线视频1卡二卡三卡|
亚州AV综合色区无码一区|
穿书后我成了首辅的心尖宠宋绵绵|
国产激情一区二区三区3D|
国产高清一级A片在线视频|
中文精品一卡2卡3卡4卡公司|
恶魔烙痕撒旦总裁请放手全集|
国产乱码精品一区二区三区人|
男女性爽大片在线观看|
AV无码九九久久|
成人欧美一区二区三区在线视频|
密桃直播|
成人国产免费Av一区二区三区|
性爱工作室|
偷窥美女洗澡一区二区三区|
重生军婚首长大人宠宠宠|
你说过不会碰我的别让我恨你|
高门恶毒主母重生了|
欧美一卡2卡三卡4卡公司动漫|
亚洲一卡二卡三卡|
一区二区三区擁有海量影視資源|
国产成人无码WWW免费视频在线|
国产精品成人图片一区|
总裁只婚不爱:天价弃妻|
亚洲高清无码视频在线|
久久综合亚洲色HEZYO国产|
国产在线视频欧美一区二区三区|
赵倩宋欣欣川藏线记忆|
国产一卡2卡3卡4卡新区乱码|
无码人妻久久一区二区|
学长~能把遥控器关了嘛作文文轩|
欧洲一卡2卡三卡4卡网站国色天香|
欧美日韩在线亚洲一|
成年午夜视频在线观看131|
欧美 日韩|
亚洲欧洲一区二区不卡|
无码一卡|
中日无码视频一区二区三区|
一卡二卡三卡,欧美,日韩,电影|
日本一卡|
日韩精品一区二区三区四区|
丰满人妻大屁股一区二区|
日韩欧美一卡2卡3卡4卡5卡免费|
丰满少妇|
亚洲AV成人无码国产电影|
糖豆直播|
日产一卡三卡四卡免费|
大肚子挺着还要上下抽插不停|
国产成人精品一区二区三区免费|