22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT wpsxlb1
FROM xtm12
WHERE wpsxlb1 NOT IN ( SELECT DISTINCT
wpsxlb1
FROM xtm12
WHERE xtwpmc LIKE '%钱夹%'
OR xtwpmc LIKE '%盒'
OR xtwpmc LIKE '%箱%'
OR xtwpmc LIKE '%链'
OR xtwpmc LIKE '%袋'
OR xtwpmc LIKE '%杯%'
OR xtwpmc LIKE '%伞%'
OR xtwpmc LIKE '%盘%'
OR xtwpmc LIKE '%函%'
OR xtwpmc LIKE '%册%'
OR xtwpmc LIKE '%表%'
OR xtwpmc LIKE '%假%'
OR xtwpmc LIKE '%架%'
OR xtwpmc LIKE '%剂%'
OR xtwpmc LIKE '%团购%'
OR xtwpmc LIKE '%测试%'
OR xtwpmc LIKE '%剂%'
OR xtwpmc LIKE '%扣'
OR xtwpmc LIKE '%湿巾%'
OR xtwpmc LIKE '%包'
OR xtwpmc LIKE '%折页%'
OR xtwpmc LIKE '%枕%'
OR xtwpmc LIKE '%框%'
OR xtwpmc LIKE '%胸针%'
OR xtwpmc LIKE '%马'
OR xtwpmc LIKE '%眼镜%' ) 单纯子查询,执行实际不长30s以内
AND wpsxlb1 IN ( SELECT DISTINCT
wpsxlb1
FROM xtm12
WHERE wpsxlb37 LIKE '%100\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒' ESCAPE '\' )
SELECT DISTINCT wpsxlb1 --,wpxsdj --wpsxlb37, xtwpmc,
FROM xtm12 a
WHERE exists ( SELECT DISTINCT wpsxlb1
FROM xtm12 b
WHERE b.wpsxlb1=a.wpsxlb1
And (xtwpmc not LIKE '%钱夹%'
OR xtwpmc not LIKE '%盒'
OR xtwpmc not LIKE '%箱%'
OR xtwpmc not LIKE '%链'
OR xtwpmc not LIKE '%袋'
OR xtwpmc not LIKE '%杯%'
OR xtwpmc not LIKE '%伞%'
OR xtwpmc not LIKE '%盘%'
OR xtwpmc not LIKE '%函%'
OR xtwpmc not LIKE '%册%'
OR xtwpmc not LIKE '%表%'
OR xtwpmc not LIKE '%假%'
OR xtwpmc not LIKE '%架%'
OR xtwpmc not LIKE '%剂%'
OR xtwpmc not LIKE '%团购%'
OR xtwpmc not LIKE '%测试%'
OR xtwpmc not LIKE '%剂%'
OR xtwpmc not LIKE '%扣'
OR xtwpmc not LIKE '%湿巾%'
OR xtwpmc not LIKE '%包'
OR xtwpmc not LIKE '%折页%'
OR xtwpmc not LIKE '%枕%'
OR xtwpmc not LIKE '%框%'
OR xtwpmc not LIKE '%胸针%'
OR xtwpmc not LIKE '%马'
OR xtwpmc not LIKE '%眼镜%' ))
AND exists ( SELECT DISTINCT wpsxlb1
FROM xtm12 c
WHERE c.wpsxlb1=a.wpsxlb1
And (wpsxlb37 LIKE '%100\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒' ESCAPE '\' ))
SELECT DISTINCT wpsxlb1 --,wpxsdj --wpsxlb37, xtwpmc,
FROM xtm12
WHERE exists ( SELECT DISTINCT
wpsxlb1
FROM xtm12
WHERE xtwpmc not LIKE '%钱夹%'
OR xtwpmc not LIKE '%盒'
OR xtwpmc not LIKE '%箱%'
OR xtwpmc not LIKE '%链'
OR xtwpmc not LIKE '%袋'
OR xtwpmc not LIKE '%杯%'
OR xtwpmc not LIKE '%伞%'
OR xtwpmc not LIKE '%盘%'
OR xtwpmc not LIKE '%函%'
OR xtwpmc not LIKE '%册%'
OR xtwpmc not LIKE '%表%'
OR xtwpmc not LIKE '%假%'
OR xtwpmc not LIKE '%架%'
OR xtwpmc not LIKE '%剂%'
OR xtwpmc not LIKE '%团购%'
OR xtwpmc not LIKE '%测试%'
OR xtwpmc not LIKE '%剂%'
OR xtwpmc not LIKE '%扣'
OR xtwpmc not LIKE '%湿巾%'
OR xtwpmc not LIKE '%包'
OR xtwpmc not LIKE '%折页%'
OR xtwpmc not LIKE '%枕%'
OR xtwpmc not LIKE '%框%'
OR xtwpmc not LIKE '%胸针%'
OR xtwpmc not LIKE '%马'
OR xtwpmc not LIKE '%眼镜%' )
AND wpsxlb1 IN ( SELECT DISTINCT
wpsxlb1
FROM xtm12
WHERE wpsxlb37 LIKE '%100\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒' ESCAPE '\' )
SELECT * FROM xtm12
WHERE (xtwpmc NOT LIKE '%钱夹%'
AND xtwpmc LIKE '%盒'
AND xtwpmc LIKE '%箱%'
AND xtwpmc LIKE '%链'
AND xtwpmc LIKE '%袋'
AND xtwpmc LIKE '%杯%'
AND xtwpmc LIKE '%伞%'
AND xtwpmc LIKE '%盘%'
AND xtwpmc LIKE '%函%'
AND xtwpmc LIKE '%册%'
AND xtwpmc LIKE '%表%'
AND xtwpmc LIKE '%假%'
AND xtwpmc LIKE '%架%'
AND xtwpmc LIKE '%剂%'
AND xtwpmc LIKE '%团购%'
AND xtwpmc LIKE '%测试%'
AND xtwpmc LIKE '%剂%'
AND xtwpmc LIKE '%扣'
AND xtwpmc LIKE '%湿巾%'
AND xtwpmc LIKE '%包'
AND xtwpmc LIKE '%折页%'
AND xtwpmc LIKE '%枕%'
AND xtwpmc LIKE '%框%'
AND xtwpmc LIKE '%胸针%'
AND xtwpmc LIKE '%马'
AND xtwpmc LIKE '%眼镜%'
) AND (
wpsxlb37 LIKE '%100\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒' ESCAPE '\'
)
SELECT wpsxlb1
FROM xtm12
WHERE ( xtwpmc LIKE '%钱夹%'
OR xtwpmc LIKE '%盒'
OR xtwpmc LIKE '%箱%'
OR xtwpmc LIKE '%链'
OR xtwpmc LIKE '%袋'
OR xtwpmc LIKE '%杯%'
OR xtwpmc LIKE '%伞%'
OR xtwpmc LIKE '%盘%'
OR xtwpmc LIKE '%函%'
OR xtwpmc LIKE '%册%'
OR xtwpmc LIKE '%表%'
OR xtwpmc LIKE '%假%'
OR xtwpmc LIKE '%架%'
OR xtwpmc LIKE '%剂%'
OR xtwpmc LIKE '%团购%'
OR xtwpmc LIKE '%测试%'
OR xtwpmc LIKE '%剂%'
OR xtwpmc LIKE '%扣'
OR xtwpmc LIKE '%湿巾%'
OR xtwpmc LIKE '%包'
OR xtwpmc LIKE '%折页%'
OR xtwpmc LIKE '%枕%'
OR xtwpmc LIKE '%框%'
OR xtwpmc LIKE '%胸针%'
OR xtwpmc LIKE '%马'
OR xtwpmc LIKE '%眼镜%'
)
AND ( wpsxlb37 LIKE '%100\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '%100\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%山羊绒' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒%' ESCAPE '\'
OR wpsxlb37 LIKE '9[0-9]\%羊绒' ESCAPE '\'
);