PI数据库大批量位号数据匹配查询

艺帆风顺 发布于 2025-04-03 13 次阅读

1、问题背景

    PI数据库中有大量数据，需要匹配位号是否能够和数据库中匹配。

    该场景的处理有多种方法，下面仅列举文本批量处理匹配方式。

2、问题处理

借助Notepad列表模块进行处理：

1）列块插入，行首批量插入：

SELECT tag, time, value,status FROM piarchive..pisnapshot WHERE tag= '

2）正则表达式匹配换行首和行尾

       “^”替换为’

       “$”替换为'

换行符替换为位号分割：

       “ rn”替换为“ or tag = ”

3、处理结果

SELECT tag, time, value,status FROM piarchive..pisnapshot WHERE tag='6255LI10201A.PV' or tag = '6300-AT-24002' or tag = '6410GI90119.PV' or tag = '6122-GT-00011' or tag = '3201-GT90004.PV' or tag = '3201GIA90072.PV' or tag = 'GQ04:6113_GT_00015' or tag = '1620GIA91086.PV' or tag = '6240LI10601.PV' or tag = '3700GIA93003.PV' or tag = '6420GI90104.PV' or tag = '4140-GT-10003' or tag = '6320-LT-23401' or tag = '4130-GT-30004' or tag = '6242GIA90104.PV' or tag = '1110GIA00064.PV' or tag = '6221-GT-90104' or tag = '1500GIA90203.PV' or tag = '2400-GT91017.PV' or tag = '6420GI90128.PV' or tag = '1400GIA90175.PV' or tag = '1300GT901-034' or tag = '3700-GT93020' or tag = 'GQ04:6114T_01011' or tag = '2170GIA90106.PV' or tag = '2300GIA92005.PV' or tag = '6240GIA90108.PV' or tag = '1620GIA91056.PV' or tag = 'GQ04:6125_PT_04081.PV' or tag = '3202GIA90105.PV' or tag = '3300GIA93012.PV' or tag = '6410GI90415.PV' or tag = '6420GI90222.PV' or tag = '6231-LT-11002A' or tag = '4210-GT-10077' or tag = '1620GIA91051.PV' or tag = '1120AT-10226.PV' or tag = '1120AT-10103.PV' or tag = '5100AT-106078' or tag = '2100-GT90034.PV' or tag = '5610GT-10124' or tag = '3202-GT93011.PV' or tag = '6238LI10301.PV' or tag = '1700GIA90071.PV' or tag = '2400-GT90112.PV' or tag = '1110PIC02006.PV' or tag = '3202GIA93022.PV' or tag = '5100GT-14084' or tag = '1110GIA00057.PV' or tag = '1500GIA90205.PV' or tag = '3201GIA90026.PV' or tag = '1400GIA90183.PV' or tag = '2400-GT90133.PV' or tag = 'GQ04:6125_LT_03051_T1.PV' or tag = '6420GI90213.PV' or tag = '3300GIA93006.PV' or tag = '4130-GT-40019' or tag = '1700-GT90002.PV' or tag = '1700GIA92004.PV' or tag = '2300GIA90015.PV' or tag = '4140-GT-20147' or tag = '1500GIA90200.PV' or tag = '2400-GT91021.PV' or tag = '4130-GT-30019' or tag = '4210-GT-20123' or tag = '6125-GT-10103' or tag = '5310AT2100506B.PV' or tag = '3202-GT90088.PV' or tag = '1300GT901-0040' or tag = '6240GIA91004.PV' or tag = '1620GIA91015.PV' or tag = '1620GIA901066.PV' or tag = '6330-LT-35401' or tag = '3201GIA90102.PV' or tag = '1500GIA90117.PV' or tag = '3201GIA90095.PV' or tag = '6121-GT-00022' or tag = '2400GIA90131.PV' or tag = '4130-GT-20056' or tag = '1120AI10126.PV' or tag = '6420GI90407.PV' or tag = '4210-GT-20030' or tag = '6121-GT-00021' or tag = '1500GIA91043.PV' or tag = '1400GIA91051.PV' or tag = '5310AT2100502.PV' or tag = '6125-GT-10033' or tag = '3202GIA90007.PV' or tag = '3700-GT93014' or tag = '6310-LT-10202' or tag = '5310AT2100713.PV' or tag = '3700GIA93012.PV' or tag = '4210-GT-10079' or tag = '1700-GT90077.PV' or tag = '3500GIA90012.PV' or tag = '6122-GT-00111' or tag = '2160GIA90129.PV' or tag = '1610GIA91007.PV' or tag = '3100-GT90019.PV' or tag = '1400GIA91022.PV' or tag = '1610GIA902008.PV' or tag = '7460GIA90109.PV' or tag = '3100GIA90034.PV' or tag = '5350AT2100401.PV' or tag = '9820-GT-10102' or tag = '9820-GT-00101' or tag = '3202GIA90021.PV' or tag = '2400GIA90202.PV' or tag = '6125-GT-10021' or tag = '1620GIA901116.PV' or tag = '1700GIA90069.PV' or tag = '6420GI90205.PV' or tag = '1300GT901-094' or tag = '1110GIA00100.PV' or tag = '3100GIA90019.PV' or tag = '2100-GT90015.PV' or tag = '3300GIA93018.PV' or tag = '3300-GT93014' or tag = '9820-GT-10103' or tag = '1300GT91-031' or tag = '1400GIA90128.PV' or tag = '1820-GT-11001' or tag = '2300-GT90024.PV' or tag = '3700GIA90018.PV' or tag = '6410GI90156.PV' or tag = '6420GI90211.PV' or tag = '6242-GT-90103' or tag = '1110FIC08001.PV' or tag = '1700GIA90009.PV' or tag = '5100GT-14070' or tag = '9820-GT-00402' or tag = '2300-GT90050.PV' or tag = '5100GT-16014' or tag = '1120AT-10222.PV' or tag = '6420GI90121.PV' or tag = '1610GIA901020.PV' or tag = '3202GIA93020.PV' or tag = '3500-GT92003.PV' or tag = '1620GIA901065.PV' or tag = '6420GI90418.PV' or tag = '1110GIA10052.PV' or tag = '1400GIA90156.PV' or tag = '1700GIA90078.PV' or tag = '5310AT2100510.PV' or tag = '6125-GT-10085' or tag = '1110GIA10072.PV' or tag = '4130-GT-20017' or tag = '2400-GT91030.PV' or tag = '1610GIA91085.PV' or tag = '6238-LT-10701' or tag = '1120AT-10114.PV' or tag = '5100GT-11001' or tag = '6122-GT-00032' or tag = '2400GIA90133.PV' or tag = '3300-GT93012' or tag = '3500GIA90005.PV' or tag = '1110GIA00018.PV' or tag = '1610GIA901016.PV' or tag = '2400GIA91031.PV' or tag = '4240-GT-10221' or tag = '4210-GT-10066' or tag = '3300-LS11007.PV' or tag = '9820-GT-00102' or tag = '1610GIA901041.PV' or tag = 'GQ04:6114_GT_00035' or tag = '4210-GT-20105' or tag = '4130-GT-40104' or tag = '3201-GT90045.PV' or tag = '6410GI90417.PV' or tag = '1300-GT-901003' or tag = '6235GIA90104.PV' or tag = '2200-GT90041.PV' or tag = '1110GIA10086.PV' or tag = '1300GT901-053' or tag = '4140-GT-20152' or tag = '3202GIA90074.PV' or tag = '1810-GT-15101' or tag = '6122-GT-00041' or tag = '1300—GT—91056' or tag = 'GQ04:6122_LT_06091_L1.PV' or tag = '6236LI10403.PV' or tag = '1500GIA90197.PV' or tag = 'GQ04:9920_PT_01011.PV' or tag = '4140-GT-10014' or tag = '1110GIA10067.PV' or tag = '1300-GT-901016' or tag = '6238-LT-10103' or tag = '3201-GT90060.PV' or tag = '4210-GT-20013' or tag = '1620GIA902007.PV' or tag = '2200-GT90002.PV' or tag = '3202-GT90004.PV' or tag = '3500GIA93006.PV' or tag = '6238LI10303.PV' or tag = '7460GIA90112.PV' or tag = '4240-GT-10206' or tag = '3201GIA93003.PV' or tag = '2300-GT92002.PV' or tag = '6121-GT-00052' or tag = '9810-GT-00802' or tag = '6185-GT-10011' or tag = '1110LI10002.PV' or tag = '4130-GT-20104' or tag = '6300-AT-23042' or tag = 'GQ04:9830_PT_07071.PV' or tag = '9830-GT-10044' or tag = '2100-GT92005.PV' or tag = '2100-GT90029.PV' or tag = '3500-GT93012.PV' or tag = '1830-GT-51101' or tag = '1610GIA902014.PV' or tag = '3201GIA93015.PV' or tag = '6410GI90205.PV' or tag = '4130-GT-20105' or tag = '1810-GT-11203' or tag = '1110GIA00041.PV' or tag = '1620GIA91077.PV' or tag = 'GQ04:6113T_02041' or tag = '3201-GT90054.PV' or tag = '4210-GT-20107' or tag = '2100GIA90010.PV' or tag = '1610GIA91050.PV' or tag = '2300-GT92004.PV' or tag = '6125-GT-10001' or tag = '6420GI90125.PV' or tag = '3300GIA90016.PV' or tag = '5100GT-18056' or tag = '1610GIA901028.PV' or tag = '1610GIA91046.PV' or tag = '5310AT2100001.PV' or tag = '2100GIA90004.PV' or tag = '8617GIA90102.PV' or tag = '2160GIA90114.PV' or tag = '1300GT91-030' or tag = '1820-GT-10601' or tag = '1120AI10204.PV' or tag = '1110GIA10023.PV' or tag = 'GQ04:a9810_GT_00803' or tag = '3100GIA93007.PV' or tag = '6330-LT-33101' or tag = '3300-GT93006' or tag = '3100GIA93003.PV' or tag = '4210-GT-20079' or tag = 'GQ04:6115T_01021' or tag = '9810-GT-00502' or tag = '3201-GT90084.PV' or tag = '6210GIA90112.PV' or tag = '6241GIA91005.PV' or tag = '3500GIA93014.PV' or tag = '1810-GT-12001' or tag = '4140-GT-10211' or tag = '6420GI90401.PV' or tag = '4140-GT-10006' or tag = '4130-GT-20062' or tag = '2100GIA90008.PV' or tag = '1300GT91-034' or tag = '3500-GT90014.PV' or tag = 'GQ04:6125_LT_01011_T1.PV' or tag = '4130-GT-40102' or tag = '1400GIA90162.PV' or tag = '3300GIA90024.PV' or tag = '1500GIA90108.PV' or tag = '2200-GT90032.PV' or tag = '1610GIA901043.PV' or tag = '9810-GT-00004' or tag = '1620GIA91106.PV' or tag = '3100-GT92007.PV' or tag = '1400GIA91025.PV' or tag = '1300GT901-076' or tag = '4140-GT-10205' or tag = '1400GIA92002.PV' or tag = '5310AT2100703.PV' or tag = '1610GIA901059.PV' or tag = '1620GIA901113.PV' or tag = '6410GI90301.PV' or tag = '4140-GT-10115' or tag = '6310LI10501.PV' or tag = '6181-GT-10002' or tag = '1620GIA901035.PV' or tag = '4210-GT-10083' or tag = '6221-LT-10711B' or tag = '1610GIA902010.PV' or tag = '3300-GT90004.PV' or tag = '4140-GT-40147' or tag = '2100-GT90041.PV' or tag = '6185-GT-10020' or tag = '3100-GT93003.PV' or tag = '1610GIA91080.PV' or tag = '1110GIA00132.PV' or tag = '6330-LT-30501' or tag = '6232LI10901.PV' or tag = '1110FIC05003.PV' or tag = '1620GIA12102B.PV' or tag = '3201-GT90034.PV' or tag = '1400GIA90168.PV' or tag = '1610GIA91081.PV' or tag = 'GQ04:6122_LT_02011_L1.PV' or tag = '1610GIA91086.PV' or tag = '2100-GT90027.PV' or tag = '1120AI10122.PV' or tag = '2200-GT90037.PV' or tag = '3500-GT93013.PV' or tag = '1610GIA91037.PV' or tag = '3100GIA93025.PV' or tag = '6125-GT-10035' or tag = '1610GIA901069.PV' or tag = '6242LI10201.PV' or tag = '3700GIA93007.PV' or tag = '1700GIA90024.PV' or tag = '1400GIA91041.PV' or tag = '1610GIA901064.PV' or tag = '1110GIA10010.PV' or tag = '2300GIA90022.PV' or tag = '1700GIA90074.PV' or tag = '1110GIA00090.PV' or tag = '3202-GT90110.PV' or tag = '4210-GT-20144' or tag = '2200GIA92007.PV' or tag = '6300-AT-15012' or tag = 'GQ04:6125_LT_04071_L1.PV' or tag = '3202GIA90028.PV' or tag = '3500GIA90009.PV' or tag = '1620GIA901055.PV' or tag = '2200-GT90019.PV' or tag = '3201-GT90070.PV' or tag = 'GQ04:6123_LT_03031_T1.PV' or tag = '2200GIA90045.PV' or tag = '3100-GT90033.PV' or tag = '1620GIA902003.PV' or tag = '4130-GT-40055' or tag = '3500GIA90019.PV' or tag = '3500GIA93010.PV' or tag = '1110GIA10055.PV' or tag = '2400GIA91027.PV' or tag = '2400GIA90120.PV' or tag = '1110FIC05008.PV' or tag = '1110LI04001.PV' or tag = '1110FIQ07029.PV' or tag = '6125-GT-10091' or tag = '1120AT-10001.PV' or tag = '6300AIA23052.PV' or tag = 'GQ04:6111_TPJ_02041' or tag = '3700-GT90011' or tag = '6240LI10105.PV' or tag = '5310AT2100123.PV' or tag = 'GQ04:a9830_GT_10013' or tag = 'GQ04:6111_TPJ_02031' or tag = '1810-GT-11703' or tag = '1620GIA91075.PV' or tag = '3500GIA92007.PV' or tag = '3202-GT90082.PV' or tag = '6320-LT-26201' or tag = '2100-GT92010.PV' or tag = '1110LIC09005.PV' or tag = '1400GIA90157.PV' or tag = '9820-GT-10202' or tag = '6236GIA90114.PV' or tag = '3201-GT93013.PV' or tag = '4210-GT-20114' or tag = '9830-GT-00072' or tag = '4130-GT-30021' or tag = '3100-GT93005.PV' or tag = '4130-GT-40008' or tag = '6410GI90147.PV' or tag = '1400GIA90166.PV' or tag = '6185-GT-10018' or tag = '1610GIA901021.PV' or tag = '1110GIA00114.PV' or tag = '6222-LT-10211B' or tag = '5310AT2100309A.PV' or tag = '1110GIA10075.PV' or tag = '3202GIA90108.PV' or tag = '1500GIA91012.PV' or tag = '3700GIA93021.PV' or tag = '6273-LT-10101' or tag = '4130-GT-30014' or tag = '1300GT901-058' or tag = '3202GIA90015.PV' or tag = '4240-GT-10225' or tag = '6325-AT-2100-801A' or tag = '1610GIA901019.PV' or tag = '6150-GT-00027' or tag = '4140-GT-10131' or tag = '1500GIA91065.PV' or tag = '2100GIA90031.PV' or tag = '1610GIA91029.PV' or tag = '4210-GT-20008' or tag = '2300-GT90008.PV' or tag = '5100GT-11024B' or tag = '1620GIA901052.PV' or tag = '3201GIA90110.PV' or tag = '2100-GT90043.PV' or tag = '3202GIA93009.PV' or tag = '4210-GT-10105' or tag = '7850GIA1204' or tag = '9840-GT-10014' or tag = '4130-GT-20055' or tag = '4140-GT-10034' or tag = '9820-GT-00004' or tag = '9810-GT-00803' or tag = '1610GIA91069.PV' or tag = '1610GIA901047.PV' or tag = '6231LI10601A.PV' or tag = '6330-LT-30801' or tag = '6300AIA11005.PV' or tag = '1620GIA901085.PV' or tag = 'GQ04:6122_LT_06101_L1.PV' or tag = '3300-GT90022' or tag = '3100-GT93024.PV' or tag = '6410GI90209.PV' or tag = '6300-AT-23030' or tag = '3300-GT93022' or tag = '9840-GT-10004' or tag = '6330LI32901.PV' or tag = '4130-GT-10061' or tag = '6121-GT-00114' or tag = '1610GIA901008.PV' or tag = '1110GIA10022.PV' or tag = 'GQ04:6125_PT_06111.PV' or tag = '3201-GT90053.PV' or tag = '1700-GT90050.PV' or tag = '1700GIA90067.PV' or tag = '1400GIA90143.PV' or tag = '6222GIA90101.PV' or tag = 'GQ04:6123_PT_03031.PV' or tag = '1500GIA91048.PV' or tag = '3201GIA90088.PV' or tag = '1110GIA00115.PV' or tag = '1300GT91-049' or tag = 'GQ04:6111_GT_10016' or tag = '1300GT91-061' or tag = '4130-GT-40052' or tag = '2400GIA90118.PV' or tag = '3202GIA90043.PV' or tag = '3202GIA90032.PV' or tag = '6273GIA90305.PV' or tag = '5100GT-11003' or tag = '3202GIA90042.PV' or tag = '3500GIA90020.PV' or tag = '1810-GT-10501' or tag = '1110GIA00083.PV' or tag = '4130-GT-30002' or tag = '2200-GT90023.PV' or tag = '6300-AT-15005' or tag = '6121-GT-00082' or tag = '1700GIA92003.PV' or tag = '1300GT901-024' or tag = '6320LI25301.PV' or tag = '3700GIA93005.PV' or tag = '1110GIA10048.PV' or tag = '6320-LT-25101' or tag = '2100-GT90020.PV' or tag = '3300-GT93023' or tag = '3100GIA90005.PV' or tag = '1110LIC05014.PV' or tag = '2400GIA90112.PV' or tag = '2100GIA90025.PV' or tag = '5310AT2100130.PV' or tag = '1500GIA90158.PV' or tag = '2200-GT92011.PV' or tag = '2200-GT90039.PV' or tag = '1500GIA90188.PV' or tag = '1620GIA91054.PV' or tag = '4210-GT-10018' or tag = '3300GIA93014.PV' or tag = '3300-GT90014' or tag = '6121-GT-00003' or tag = '1620GIA91004.PV' or tag = '3100GIA90025.PV' or tag = 'GQ04:6121_PT_06111.PV' or tag = '1620GIA91079.PV' or tag = '6240GIA90112.PV' or tag = '6410GI90146.PV' or tag = '3201GIA90060.PV' or tag = '1620GIA91020.PV' or tag = '9810-GT-00006' or tag = '1110FIC08005.PV' or tag = '6124-GT-00003' or tag = '6150-GT-10011' or tag = '1620GIA902010.PV' or tag = '3202-GT90054.PV' or tag = '5100GT-14006' or tag = 'GQ04:6112_GT_00015' or tag = '1610GIA91021.PV' or tag = '6125-GT-10054' or tag = '3500GIA93024.PV' or tag = '3100-GT93019.PV' or tag = '1400GIA91056.PV' or tag = '2200GIA90027.PV' or tag = '5100GT-14060' or tag = '6320LI22201.PV' or tag = '2100GIA90024.PV' or tag = '1120AI10205.PV' or tag = '2200-GT90043.PV' or tag = '1700GIA90012.PV' or tag = '2400GIA91011.PV' or tag = '3202-GT90053.PV' or tag = '3202-GT90059.PV' or tag = '1110GIA00021.PV' or tag = '6238-LT-10603' or tag = '4210-GT-20067' or tag = '1610GIA91014.PV' or tag = '1500GIA90103.PV' or tag = '6330-LT-33001' or tag = '1500GIA90133.PV' or tag = '1700-GT92011.PV' or tag = '5350AT2100415.PV' or tag = '2200GIA90010.PV' or tag = 'GQ04:6111T_01011' or tag = '1500GIA91008.PV' or tag = '4210-GT-10022' or tag = '1620GIA901009.PV' or tag = '3201-GT90062.PV' or tag = '2200-GT90049.PV' or tag = '/' or tag = '6241LI10605.PV' or tag = '1610GIA91060.PV' or tag = '6122-GT-00093' or tag = '2400-GT90114.PV' or tag = '2300-GT90005.PV' or tag = '6410GI90129.PV' or tag = '3202-GT90029.PV' or tag = '6125-GT-10074' or tag = '3202-GT90080.PV' or tag = '9810-GT-00204' or tag = '6222LT10211B.PV' or tag = '6121-GT-00092' or tag = '4210-GT-10113' or tag = '1700-GT92002.PV' or tag = '1110GIA00112.PV' or tag = '4210-GT-20076' or tag = '1610GIA91022.PV' or tag = '9820-GT-10205' or tag = '9866-GT-10002' or tag = '3300GIA90020.PV' or tag = '6300AIA16922.PV' or tag = '6243-LT-10301A' or tag = '6125-GT-10015' or tag = '6420GI90233.PV' or tag = '4140-GT-10018' or tag = '2400-GT90130.PV' or tag = '6124-GT-10007' or tag = '1400GIA91024.PV' or tag = '5100GT-11015A' or tag = '3300-GT93019' or tag = '2100GIA90038.PV' or tag = '6320LI26601.PV' or tag = '6272GIA90104.PV' or tag = '3201GIA90012.PV' or tag = '4130-GT-40050' or tag = '7460GIA90116.PV' or tag = 'GQ04:a9820_GT_10503' or tag = 'test10' or tag = '6222LT10121B.PV' or tag = '2200-GT92004.PV' or tag = 'GQ04:6115T_01011' or tag = '2300GIA90044.PV' or tag = '1620GIA901019.PV' or tag = '4130-GT-20029' or tag = '4240-GT-10102' or tag = '1610GIA91083.PV' or tag = '5310AT2100306B.PV' or tag = '6420GI90108.PV' or tag = '6273-GT-90304' or tag = '6222GIA90104.PV' or tag = '1620GIA901050.PV' or tag = '3202-GT93004.PV' or tag = '4140-GT-40153' or tag = '6330-LT-31201' or tag = '3700-GT90002' or tag = 'GQ04:a6122_GT_00093' or tag = '1500GIA90126.PV' or tag = '6236GIA90116.PV' or tag = '1300GT901-090' or tag = '2100-GT90010.PV' or tag = '1400GIA31102A.PV' or tag = '3500-GT90027.PV' or tag = '6410GI90151.PV' or tag = '6325-LT-8112' or tag = '6125-GT-10052' or tag = '4140-GT-10133' or tag = '3202-GT90079.PV' or tag = '3201GIA90075.PV' or tag = '1620GIA91053.PV' or tag = '3201-GT90007.PV' or tag = '3500GIA90021.PV' or tag = '1110GIA00050.PV' or tag = '6410GI90109.PV' or tag = '6410GI90135.PV' or tag = '3300-GT90025' or tag = '6122-GT-00005' or tag = '6410GI90158.PV' or tag = '4210-GT-10081' or tag = '5310AT2100313A.PV' or tag = '5310AT2100505A.PV' or tag = '3202-GT90055.PV' or tag = '1620GIA91057.PV' or tag = '1110PI03001A.PV' or tag = '5310AT2100119.PV' or tag = '3202GIA90057.PV' or tag = '3201GIA90076.PV' or tag = '4130-GT-30057' or tag = '1700GIA90039.PV' or tag = '1610GIA91082.PV' or tag = '3202-GT90105.PV' or tag = '4140-GT-40154' or tag = '1400GIA91038.PV' or tag = '3500-GT90007.PV' or tag = 'GQ04:9830_LT_02031_L1.PV' or tag = '5310AT2100317.PV' or tag = '1300GT901-037' or tag = '1620GIA91019.PV' or tag = '5310AT2100315A.PV' or tag = 'GQ04:9920_PT_01021.PV' or tag = '3500-GT90025.PV' or tag = '4210-GT-20122' or tag = '6150-GT-10018' or tag = '6222-LT-10511B' or tag = '1500GIA90180.PV' or tag = '1620GIA901030.PV' or tag = '2170GIA90101.PV' or tag = '6150-GT-00023' or tag = '3202GIA90064.PV' or tag = '6121-GT-00042' or tag = '1620GIA91007.PV' or tag = '3202-GT90056.PV' or tag = '6300-AT-17002' or tag = '3300-LS11006' or tag = '1500GIA91006.PV' or tag = '3500GIA90013.PV' or tag = '4140-GT-10019' or tag = '2100GIA90049.PV' or tag = '2400-GT91033.PV' or tag = '1400GIA90144.PV' or tag = '1610GIA901078.PV' or tag = '3700GIA90001.PV' or tag = '6122-GT-00053' or tag = '1610GIA901045.PV' or tag = '3201GIA90001.PV' or tag = '3700-GT90005' or tag = '6272GIA90103.PV' or tag = '3700-GT90006' or tag = '2170GIA90102.PV' or tag = '1110GIA00135.PV' or tag = '6242LI10305.PV' or tag = '3500-GT90045.PV' or tag = '3201-GT90028.PV' or tag = '3300GIA93009.PV' or tag = '5610GT-10004' or tag = '2100GIA90011.PV' or tag = '3202-GT90010.PV' or tag = '3201-GT90080.PV' or tag = '1300GT901-0048' or tag = '6272-LT-10105' or tag = '1700GIA90045.PV' or tag = '1620GIA901054.PV' or tag = '1700-GT90066.PV' or tag = '4130-GT-30016' or tag = '4240-GT-10103' or tag = '6420GI90124.PV' or tag = '4210-GT-10015' or tag = '1620GIA901111.PV' or tag = '1620GIA902001.PV' or tag = '6241LI10405.PV' or tag = '6231LI10801A.PV' or tag = '2300GIA90028.PV' or tag = '2160GIA90106.PV' or tag = '6420GI90135.PV' or tag = '1400GIA92001.PV' or tag = '1700GIA92011.PV' or tag = '6125-GT-10003' or tag = '1810-GT-11802' or tag = '2400GIA90111.PV' or tag = '4210-GT-20103' or tag = '1620GIA901069.PV' or tag = '9866-GT-00004' or tag = '2200-GT90021.PV' or tag = '3202-GT90027.PV' or tag = '2400-GT91022.PV' or tag = '4210-GT-10028' or tag = '1700-GT90040.PV' or tag = '3300-GT93007' or tag = '3100-GT90012.PV' or tag = 'GQ04:6121_PT_05091.PV' or tag = '5100GT-15021' or tag = '1110GIA00031.PV' or tag = '6273LI10101.PV' or tag = '9810-GT-00605' or tag = '3202GIA90018.PV' or tag = '6320-LT-26601' or tag = '3201GIA90004.PV' or tag = '6271LI10301.PV' or tag = '3201GIA90064.PV' or tag = '2100GIA92002.PV' or tag = 'GQ04:9810_LT_02011_L1.PV' or tag = '1820-GT-11004' or tag = '1500GIA91013.PV' or tag = '1120AI10101.PV' or tag = '6150-GT-00011' or tag = '2100GIA90015.PV' or tag = '1300GT91-044' or tag = '1400GIA90112.PV' or tag = '3202-GT90049.PV' or tag = '3300-GT93004.PV' or tag = '6125-GT-10084' or tag = '1300GT91-040' or tag = '3100-GT92002.PV' or tag = '4210-GT-10016' or tag = '6185-GT-10008' or tag = '1700GIA90032.PV' or tag = '6310LI10102.PV' or tag = '6320-LT-24201' or tag = '6410GI90218.PV' or tag = '1620GIA91115.PV' or tag = '3201-GT90047.PV' or tag = '6125-GT-10135' or tag = '6410GI90149.PV' or tag = '6420GI90204.PV' or tag = '1700-GT92013.PV' or tag = '2400-GT90113.PV' or tag = '6271-GT-90107' or tag = '1700-GT92016.PV' or tag = '6410GI90101.PV' or tag = '5310AT2100617A.PV' or tag = '4140-GT-10118' or tag = '1400GIA91052.PV' or tag = '2100-GT92001.PV' or tag = '4140-GT-10058' or tag = 'GQ04:a9820_GT_10103' or tag = '3700GIA93004.PV' or tag = '1110GIA00003.PV' or tag = '1400GIA91028.PV' or tag = '9820-GT-10106' or tag = '4140-GT-10149' or tag = '3202-GT90017.PV' or tag = '3500-GT90032.PV' or tag = '1700GIA92033.PV' or tag = '1400GIA90198.PV' or tag = '2300-GT90038.PV' or tag = '1610GIA901022.PV' or tag = '5310AT2100310A.PV' or tag = '6410GI90107.PV' or tag = '6122-GT-00023' or tag = '1400GIA92007.PV' or tag = '5350AT2100429BA.PV' or tag = 'GQ04:6114_TPJ_01011' or tag = '2400-GT90118.PV' or tag = '3100GIA93018.PV' or tag = '3201GIA90108.PV' or tag = '1610GIA901004.PV' or tag = '4130-GT-40002' or tag = '6185-GT-10017' or tag = '6210GIA90115.PV' or tag = '3201GIA93009.PV' or tag = '3500GIA90022.PV' or tag = '6410GI90221.PV' or tag = '6122-GT-00121' or tag = '2200GIA90012.PV' or tag = '1300GT91-043' or tag = 'GQ04:6112_TPJ_01021' or tag = '4130-GT-20051' or tag = '1500GIA90143.PV' or tag = '1610GIA91018.PV' or tag = '2100-GT90014.PV' or tag = '2100GIA92006.PV' or tag = '9810-GT-00402' or tag = '1110PIC02004.PV' or tag = 'GQ04:6122_PT_05081.PV' or tag = '1110GIA00140.PV' or tag = '4140-GT-40210' or tag = '3202GIA93006.PV' or tag = '6410GI90153.PV' or tag = '2100GIA90002.PV' or tag = '3201GIA90100.PV' or tag = '1400GIA90108.PV' or tag = '4140-GT-10120' or tag = '1300—GT—91077' or tag = '1700-GT90074.PV' or tag = '3700-GT93022' or tag = '3202GIA90004.PV' or tag = '5630GT-30032' or tag = '1610GIA91077.PV' or tag = '3201GIA90048.PV' or tag = '1110GIA10040.PV' or tag = '4210-GT-20002' or tag = '3300GIA90026.PV' or tag = '3300GIA93004.PV' or tag = '6235-LT-10205' or tag = '5350AT2100406BB.PV' or tag = '3300GIA93007.PV' or tag = '5100GT-14055' or tag = '5310AT2100301BA.PV' or tag = '1110FIC07023.PV' or tag = '1610GIA901052.PV' or tag = '3500-GT93021.PV' or tag = '2100GIA92005.PV' or tag = '9840-GT-10007' or tag = '4130-GT-20007' or tag = '6122-GT-00021' or tag = '6150-GT-00013' or tag = '3700-GT90013' or tag = '3100-GT90040.PV' or tag = '6300-AT-24014' or tag = '1810-GT-AH005E' or tag = '6410GI90133.PV' or tag = '1620GIA901096.PV' or tag = '5310AT2100901.PV' or tag = '4130-GT-20010' or tag = '4130-GT-10051' or tag = '1620GIA901094.PV' or tag = '6420GI90202.PV' or tag = '2300GIA90024.PV' or tag = '3201GIA93018.PV' or tag = '2300-GT90034.PV' or tag = '3100GIA93004.PV' or tag = '6330-LT-33401' or tag = '2400-GT90129.PV' or tag = '4130-GT-40018' or tag = '3202-GT90021.PV' or tag = '6410GI90405.PV' or tag = '3201GIA90063.PV' or tag = '6125-GT-10065' or tag = '1400GIA90159.PV' or tag = '1400GIA90197.PV' or tag = '3202GIA90034.PV' or tag = '6237GIA90206.PV' or tag = '3202GIA90072.PV' or tag = '1110GIA00020.PV' or tag = '9820-GT-00403' or tag = '6125-GT-10131' or tag = '2300GIA90051.PV' or tag = '2400GIA90115.PV' or tag = '2400-GT91009.PV' or tag = '4210-GT-10012' or tag = '1620GIA901097.PV' or tag = '9830-GT-10024' or tag = '3202-GT90018.PV' or tag = '2100GIA90001.PV' or tag = '6420GI90223.PV' or tag = '1700GIA92015.PV' or tag = '4140-GT-10135' or tag = '3202GIA90065.PV' or tag = '3202GIA90091.PV' or tag = '4130-GT-30058' or tag = '1810-GT-10602' or tag = '1620GIA62151D.PV' or tag = '4210-GT-10071' or tag = '3202-GT90094.PV' or tag = 'GQ04:6122_PT_07111.PV' or tag = '2400-GT90104.PV' or tag = '9820-GT-10306' or tag = '1110GIA10054.PV' or tag = '1620GIA901048.PV' or tag = '6122-GT-00122' or tag = '4140-GT-10047' or tag = '1110GIA00030.PV' or tag = '4130-GT-30001' or tag = '1400GIA91007.PV' or tag = '6310-LT-10601' or tag = '3201-GT90033.PV' or tag = '1300GT901-005' or tag = '1700-GT90024.PV' or tag = '6310LI10202.PV' or tag = '1810-GT-15102' or tag = '3300-GT90023' or tag = '3100-GT93017.PV' or tag = '3201GIA90049.PV' or tag = 'GQ04:6124_PT_01011.PV' or tag = '6121-GT-00074' or tag = '3202GIA90078.PV' or tag = '4210-GT-20014' or tag = '2400-GT90127.PV' or tag = '3202-GT93021.PV' or tag = '9810-GT-00105' or tag = '1400GIA90177.PV' or tag = '1300—GT—91075' or tag = '6420GI90225.PV' or tag = '4210-GT-20120' or tag = '1300—GT—91005' or tag = '2200-GT90042.PV' or tag = 'GQ04:9920_LT_01021_L1.PV' or tag = '1820-GT-10801' or tag = '3202GIA90069.PV' or tag = '5100GT-14050' or tag = '4130-GT-20009' or tag = '2300GIA90032.PV' or tag = '1620GIA901013.PV' or tag = '3500GIA90002.PV' or tag = '9820-GT-00401' or tag = '6330-LT-32201' or tag = '2400GIA91029.PV' or tag = '1500GIA91007.PV' or tag = '6240LI10505.PV' or tag = '9820-GT-10505' or tag = '6238LI10703.PV' or tag = '1400GIA90116.PV' or tag = '4210-GT-20072' or tag = '6420GI90120.PV' or tag = '3700-GT93008' or tag = '6121-GT-00094' or tag = '2200-GT90035.PV' or tag = '2300-GT90015.PV' or tag = '3202GIA90094.PV' or tag = '9820-GT-10405' or tag = '6124-GT-00004' or tag = '3500GIA90001.PV' or tag = '1610GIA91052.PV' or tag = '3100-GT90004.PV' or tag = '3201-GT90039.PV' or tag = '3201-GT90075.PV' or tag = '3100GIA92004.PV' or tag = '6121-GT-00023' or tag = '3202GIA90025.PV' or tag = '3700GIA90008.PV' or tag = '6271-LT-10901' or tag = '1110GIA10021.PV' or tag = '6240GIA90126.PV' or tag = '9820-GT-00503' or tag = '2200-GT90001.PV' or tag = '1620GIA901112.PV' or tag = '1610GIA91024.PV' or tag = '3500-GT92008.PV' or tag = '1610GIA901051.PV' or tag = 'GQ04:6122_LT_04061_L1.PV' or tag = '1500GIA90165.PV' or tag = '6122-GT-00071' or tag = '2400GIA90132.PV' or tag = '1500GIA91058.PV' or tag = 'GQ04:6123_LT_02011_T1.PV' or tag = '6125-GT-10022' or tag = '1110GIA10032.PV' or tag = '2300-GT90025.PV' or tag = '1610GIA901031.PV' or tag = '1620GIA901036.PV' or tag = '6121-GT-00081' or tag = '1400GIA90139.PV' or tag = '5310AT2100623A.PV' or tag = 'GQ04:6112T_01011' or tag = '2100-GT90052.PV' or tag = '1110PIC02001.PV' or tag = '6125-GT-10101' or tag = '3202GIA90092.PV' or tag = '1500GIA90172.PV' or tag = '6330LI35401.PV' or tag = '3202-GT90006.PV' or tag = '1620GIA91074.PV' or tag = '1110GIA00070.PV' or tag = '1700GIA90075.PV' or tag = '3700GIA93001.PV' or tag = '6330-LT-33201' or tag = '9840-GT-10021' or tag = '9820-GT-10302' or tag = '4140-GT-30149' or tag = '1400GIA90189.PV' or tag = '6330LI30501.PV' or tag = '6125-GT-10075' or tag = '3700-GT90016' or tag = '6121-GT-00053' or tag = '2100GIA92008.PV' or tag = '4210-GT-10080' or tag = '2300GIA90031.PV' or tag = '2100-GT90018.PV' or tag = '2100-GT90024.PV' or tag = '1700GIA92029.PV' or tag = '7850GIA1204.PV' or tag = '3300-GT93024' or tag = '6420GI90415.PV' or tag = 'GQ04:6122_PT_02021.PV' or tag = 'GQ04:6114T_02041' or tag = 'GQ04:6111_GT_00035' or tag = '1620GIA91100.PV' or tag = '3201-GT90001.PV' or tag = '1500GIA41001B.PV' or tag = '1500GIA91009.PV' or tag = '6410GI90150.PV' or tag = '3202-GT90077.PV' or tag = '4130-GT-30060' or tag = '4140-GT-10208' or tag = '6330-LT-32901' or tag = '5350AT2100418.PV' or tag = '6330LI31101.PV' or tag = '6231-LT-10602A' or tag = '4140-GT-10013' or tag = '1110GIA00065.PV' or tag = '6325-LT-8122' or tag = '6240GIA91007.PV' or tag = '4210-GT-20082' or tag = '3201GIA90051.PV' or tag = '1610GIA901060.PV' or tag = '3201-GT90058.PV' or tag = '2200GIA92009.PV' or tag = '1700-GT90028.PV' or tag = '6410GI90152.PV' or tag = '3202-GT90086.PV' or tag = '2400-GT91014.PV' or tag = '2160GIA90120.PV' or tag = '3201GIA90103.PV' or tag = '1110GIA00051.PV' or tag = '3202-GT90022.PV' or tag = '1110GIA10088.PV' or tag = '1620GIA901075.PV' or tag = '3202-GT90024.PV' or tag = '1400GIA90140.PV' or tag = '1810PIC10802.PV' or tag = '1620GIA901072.PV' or tag = '6330LI36201.PV' or tag = '9810-GT-01001' or tag = 'GQ04:a6125_GT_10013' or tag = '2200-GT90033.PV' or tag = '5310AT2100903.PV' or tag = '1620GIA901026.PV' or tag = '6238-GT-90105' or tag = '3202-GT93002.PV' or tag = '6320-LT-23201' or tag = '1110GIA00036.PV' or tag = '1110GIA10019.PV' or tag = '2200-GT90015.PV' or tag = '1610GIA901086.PV' or tag = '1300—GT—91045' or tag = '6121-GT-00124' or tag = '3201-GT90027.PV' or tag = '1110LIC07014.PV' or tag = '3202-GT90098.PV' or tag = '1700GIA90059.PV' or tag = '4130-GT-20027' or tag = '3202GIA93016.PV' or tag = '1110GIA00055.PV' or tag = '1610GIA91011.PV' or tag = 'GQ04:6125_LT_07131_T1.PV' or tag = '3201GIA90061.PV' or tag = '3202-GT90033.PV' or tag = '3201-GT90100.PV' or tag = 'GQ04:6113T_02041' or tag = '1300GT91-039' or tag = '6330LI33101.PV' or tag = '6121-GT-00112' or tag = '3202GIA93011.PV' or tag = '3201-GT90088.PV' or tag = '6300AIA14003.PV' or tag = '1300GT91-023' or tag = '3201GIA90056.PV' or tag = '6235-LT-10201' or tag = '1610GIA902003.PV' or tag = '3201-GT90091.PV' or tag = '1400GIA90199.PV' or tag = '1110PI07001.PV'