1/20用友股份-LE支持服务业务本部技术方案--《NC56科目汇总表查询导致数据库压力巨大问题解决案例》建立日期：2013-10-20修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-JS-2013-01232/20文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围发布人姓名所属部门发布时间内部员工伙伴客户日期作者所属部门邮件地址版本2013-10-20李楠技术支持部V1.0版本领域模块备注NC563/20目录NC56科目汇总表查询导致数据库压力巨大问题解决案例..................................4一.系统环境...............................................................................................................4二.问题描述.............................................................................................................4三.检查分析.............................................................................................................4四.解决方法...........................................................................................................204/20NC56科目汇总表查询导致数据库压力巨大问题解决案例一.系统环境NC56Oracle二.问题描述科目汇总表查询条件为：客户1-7级，包含未记账凭证，按照凭证类别查询，在后台跟踪发现此查询语句为笛卡尔查询，造成数据库压力巨大三.检查分析Sql语句如下：SELECTbd_vouchertype.forshortvouchtypename,min(no)minno,max(no)maxnofromgl_detailgl_detail,gl_vouchergl_voucher,bd_accsubjsubj,bd_vouchertypebd_vouchertypewheregl_voucher.pk_glorgbook='0001A110000000009AZ0'andgl_voucher.year='2013'andgl_voucher.free1<='08'andgl_voucher.free1>='08'and(subj.subjcodelike'1001%'orsubj.subjcodelike'1002%'orsubj.subjcodelike'100201%'orsubj.subjcodelike'1004%'orsubj.subjcodelike'100401%'orsubj.subjcodelike'10040101%'orsubj.subjcodelike'1005%'orsubj.subjcodelike'1012%'orsubj.subjcodelike'101201%'orsubj.subjcodelike'101202%'orsubj.subjcodelike'101203%'orsubj.subjcodelike'101204%'orsubj.subjcodelike'101205%'orsubj.subjcodelike'101206%'orsubj.subjcodelike'1101%'orsubj.subjcodelike'110101%'orsubj.subjcodelike'11010101%'orsubj.subjcodelike'11010102%'orsubj.subjcodelike'110102%'orsubj.subjcodelike'11010201%'orsubj.subjcodelike'11010202%'orsubj.subjcodelike'110103%'orsubj.subjcodelike'11010301%'orsubj.subjcodelike'11010302%'orsubj.subjcodelike'110104%'orsubj.subjcodelike'11010401%'orsubj.subjcodelike'11010402%'orsubj.subjcodelike'1121%'orsubj.subjcodelike'112101%'orsubj.subjcodelike'112102%'orsubj.subjcodelike'1122%'or5/20subj.subjcodelike'112201%'orsubj.subjcodelike'112202%'orsubj.subjcodelike'112203%'orsubj.subjcodelike'112204%'orsubj.subjcodelike'112205%'orsubj.subjcodelike'1123%'orsubj.subjcodelike'112301%'orsubj.subjcodelike'112302%'orsubj.subjcodelike'112303%'orsubj.subjcodelike'1131%'orsubj.subjcodelike'1132%'orsubj.subjcodelike'1136%'orsubj.subjcodelike'113601%'orsubj.subjcodelike'113602%'orsubj.subjcodelike'113603%'orsubj.subjcodelike'11360301%'orsubj.subjcodelike'11360302%'orsubj.subjcodelike'11360303%'orsubj.subjcodelike'113604%'orsubj.subjcodelike'11360401%'orsubj.subjcodelike'1221%'orsubj.subjcodelike'122101%'orsubj.subjcodelike'12210101%'orsubj.subjcodelike'12210102%'orsubj.subjcodelike'12210103%'orsubj.subjcodelike'12210104%'orsubj.subjcodelike'12210105%'orsubj.subjcodelike'12210106%'orsubj.subjcodelike'12210107%'orsubj.subjcodelike'12210108%'orsubj.subjcodelike'12210109%'orsubj.subjcodelike'12210110%'orsubj.subjcodelike'12210111%'orsubj.subjcodelike'12210112%'orsubj.subjcodelike'12210113%'orsubj.subjcodelike'12210114%'orsubj.subjcodelike'12210115%'orsubj.subjcodelike'12210116%'orsubj.subjcodelike'12210117%'orsubj.subjcodelike'12210118%'orsubj.subjcodelike'12210119%'orsubj.subjcodelike'12210120%'orsubj.subjcodelike'12210121%'orsubj.subjcodelike'12210122%'orsubj.subjcodelike'12210123%'orsubj.subjcodelike'12210124%'orsubj.subjcodelike'12210125%'orsubj.subjcodelike'12210126%'orsubj.subjcodelike'122102%'orsubj.subjcodelike'122103%'orsubj.subjcodelike'122104%'orsubj.subjcodelike'12210401%'orsubj.subjcodelike'1221040101%'orsubj.subjcodelike'1221040102%'orsubj.subjcodelike'1221040103%'orsubj.subjcodelike'1221040104%'orsubj.subjcodelike'12210402%'orsubj.subjcodelike'12210403%'orsubj.subjcodelike'122105%'orsubj.subjcodelike'12210501%'orsubj.subjcodelike'1221050101%'orsubj.subjcodelike'1221050102%'orsubj.subjcodelike'12210502%'orsubj.subjcodelike'1221050201%'orsubj.subjcodelike'1221050202%'orsubj.subjcodelike'122106%'orsubj.subjcodelike'122107%'orsubj.subjcodelike'122108%'orsubj.subjcodelike'122109%'orsubj.subjcodelike'122110%'orsubj.subjcodelike'122111%'orsubj.subjcodelike'122112%'orsubj.subjcodelike'122113%'orsubj.subjcodelike'122118%'orsubj.subjcodelike'1231%'orsubj.subjcodelike'123101%'orsubj.subjcodelike'12310101%'orsubj.subjcodelike'12310102%'orsubj.subjcodelike'1231010201%'orsubj.subjcodelike'1231010202%'orsubj.subjcodelike'1231010203%'orsubj.subjcodelike'1231010204%'orsubj.subjcodelike'123102%'orsubj.subjcodelike'12310201%'orsubj.subjcodelike'12310202%'orsubj.subjcodelike'1231020201%'orsubj.subjcodelike'1231020202%'orsubj.subjcodelike'1231020203%'orsubj.subjcodelike'1231020204%'orsubj.subjcodelike'123103%'orsubj.subjcodelike6/20'12310301%'orsubj.subjcodelike'12310302%'orsubj.subjcodelike'1231030201%'orsubj.subjcodelike'1231030202%'orsubj.subjcodelike'1231030203%'orsubj.subjcodelike'1231030204%'orsubj.subjcodelike'123104%'orsubj.subjcodelike'12310401%'orsubj.subjcodelike'12310402%'orsubj.subjcodelike'1231040201%'orsubj.subjcodelike'1231040202%'orsubj.subjcodelike'1231040203%'orsubj.subjcodelike'1231040204%'orsubj.subjcodelike'123105%'orsubj.subjcodelike'12310501%'orsubj.subjcodelike'12310502%'orsubj.subjcodelike'1231050201%'orsubj.subjcodelike'1231050202%'orsubj.subjcodelike'1231050203%'orsubj.subjcodelike'1231050204%'orsubj.subjcodelike'123106%'orsubj.subjcodelike'12310601%'orsubj.subjcodelike'1321%'orsubj.subjcodelike'1401%'orsubj.subjcodelike'140101%'orsubj.subjcodelike'140102%'orsubj.subjcodelike'1402%'orsubj.subjcodelike'1403%'orsubj.subjcodelike'140301%'orsubj.subjcodelike'140302%'orsubj.subjcodelike'140303%'orsubj.subjcodelike'140305%'orsubj.subjcodelike'140306%'orsubj.subjcodelike'140307%'orsubj.subjcodelike'1404%'orsubj.subjcodelike'1405%'orsubj.subjcodelike'140501%'orsubj.subjcodelike'14050101%'orsubj.subjcodelike'1405010101%'orsubj.subjcodelike'1405010102%'orsubj.subjcodelike'1405010103%'orsubj.subjcodelike'1405010104%'orsubj.subjcodelike'1405010105%'orsubj.subjcodelike'1405010106%'orsubj.subjcodelike'1405010107%'orsubj.subjcodelike'14050102%'orsubj.subjcodelike'140502%'orsubj.subjcodelike'1406%'orsubj.subjcodelike'140601%'orsubj.subjcodelike'140602%'orsubj.subjcodelike'1407%'orsubj.subjcodelike'1408%'orsubj.subjcodelike'1411%'orsubj.subjcodelike'141101%'orsubj.subjcodelike'14110101%'orsubj.subjcodelike'14110102%'orsubj.subjcodelike'14110103%'orsubj.subjcodelike'141102%'orsubj.subjcodelike'14110201%'orsubj.subjcodelike'14110202%'orsubj.subjcodelike'14110203%'orsubj.subjcodelike'141103%'orsubj.subjcodelike'14110301%'orsubj.subjcodelike'14110302%'orsubj.subjcodelike'14110303%'orsubj.subjcodelike'1412%'orsubj.subjcodelike'1421%'orsubj.subjcodelike'1422%'orsubj.subjcodelike'1461%'orsubj.subjcodelike'146101%'orsubj.subjcodelike'146102%'orsubj.subjcodelike'146103%'orsubj.subjcodelike'146104%'orsubj.subjcodelike'146105%'orsubj.subjcodelike'146106%'orsubj.subjcodelike'146107%'orsubj.subjcodelike'146108%'orsubj.subjcodelike'146109%'orsubj.subjcodelike'146110%'orsubj.subjcodelike'1471%'orsubj.subjcodelike'1501%'orsubj.subjcodelike'150101%'orsubj.subjcodelike'15010101%'orsubj.subjcodelike'1501010101%'orsubj.subjcodelike'1501010102%'orsubj.subjcodelike'1501010103%'orsubj.subjcodelike'15010102%'orsubj.subjcodelike'1501010201%'orsubj.subjcodelike'1501010202%'orsubj.subjcodelike'1501010203%'orsubj.subjcodelike'150102%'orsubj.subjcodelike'15010201%'orsubj.subjcodelike'15010202%'orsubj.subjcodelike7/20'15010203%'orsubj.subjcodelike'1502%'orsubj.subjcodelike'1503%'orsubj.subjcodelike'150301%'orsubj.subjcodelike'15030101%'orsubj.subjcodelike'15030102%'orsubj.subjcodelike'15030103%'orsubj.subjcodelike'15030104%'orsubj.subjcodelike'150302%'orsubj.subjcodelike'15030201%'orsubj.subjcodelike'15030202%'orsubj.subjcodelike'15030203%'orsubj.subjcodelike'15030204%'orsubj.subjcodelike'150303%'orsubj.subjcodelike'15030301%'orsubj.subjcodelike'15030302%'orsubj.subjcodelike'15030303%'orsubj.subjcodelike'15030304%'orsubj.subjcodelike'1504%'orsubj.subjcodelike'1511%'orsubj.subjcodelike'151101%'orsubj.subjcodelike'15110101%'orsubj.subjcodelike'15110102%'orsubj.subjcodelike'15110103%'orsubj.subjcodelike'151102%'orsubj.subjcodelike'1512%'orsubj.subjcodelike'1521%'orsubj.subjcodelike'1522%'orsubj.subjcodelike'1523%'orsubj.subjcodelike'1531%'orsubj.subjcodelike'1532%'orsubj.subjcodelike'1601%'orsubj.subjcodelike'160101%'orsubj.subjcodelike'16010101%'orsubj.subjcodelike'16010102%'orsubj.subjcodelike'16010103%'orsubj.subjcodelike'16010104%'orsubj.subjcodelike'16010105%'orsubj.subjcodelike'16010106%'orsubj.subjcodelike'16010107%'orsubj.subjcodelike'16010108%'orsubj.subjcodelike'16010109%'orsubj.subjcodelike'160102%'orsubj.subjcodelike'16010201%'orsubj.subjcodelike'1601020101%'orsubj.subjcodelike'1601020102%'orsubj.subjcodelike'1601020103%'orsubj.subjcodelike'16010202%'orsubj.subjcodelike'16010203%'orsubj.subjcodelike'16010204%'orsubj.subjcodelike'16010205%'orsubj.subjcodelike'16010206%'orsubj.subjcodelike'160103%'orsubj.subjcodelike'160104%'orsubj.subjcodelike'160105%'orsubj.subjcodelike'160106%'orsubj.subjcodelike'160107%'orsubj.subjcodelike'160108%'orsubj.subjcodelike'160109%'orsubj.subjcodelike'1602%'orsubj.subjcodelike'160201%'orsubj.subjcodelike'16020101%'orsubj.subjcodelike'16020102%'orsubj.subjcodelike'16020103%'orsubj.subjcodelike'16020104%'orsubj.subjcodelike'16020105%'orsubj.subjcodelike'16020106%'orsubj.subjcodelike'16020107%'orsubj.subjcodelike'16020108%'orsubj.subjcodelike'16020109%'orsubj.subjcodelike'160202%'orsubj.subjcodelike'16020201%'orsubj.subjcodelike'1602020101%'orsubj.subjcodelike'1602020102%'orsubj.subjcodelike'1602020103%'orsubj.subjcodelike'16020202%'orsubj.subjcodelike'16020203%'orsubj.subjcodelike'16020204%'orsubj.subjcodelike'16020205%'orsubj.subjcodelike'16020206%'orsubj.subjcodelike'160203%'orsubj.subjcodelike'160204%'orsubj.subjcodelike'160205%'orsubj.subjcodelike'160206%'orsubj.subjcodelike'160207%'orsubj.subjcodelike'160208%'orsubj.subjcodelike'1603%'orsubj.subjcodelike'1604%'orsubj.subjcodelike'160401%'orsubj.subjcodelike'16040101%'orsubj.subjcodelike'1604010101%'orsubj.subjcodelike'1604010102%'orsubj.subjcodelike8/20'16040102%'orsubj.subjcodelike'1604010201%'orsubj.subjcodelike'1604010202%'orsubj.subjcodelike'16040103%'orsubj.subjcodelike'1604010301%'orsubj.subjcodelike'1604010302%'orsubj.subjcodelike'16040104%'orsubj.subjcodelike'1604010401%'orsubj.subjcodelike'1604010402%'orsubj.subjcodelike'16040105%'orsubj.subjcodelike'16040106%'orsubj.subjcodelike'16040107%'orsubj.subjcodelike'16040108%'orsubj.subjcodelike'16040109%'orsubj.subjcodelike'160402%'orsubj.subjcodelike'16040201%'orsubj.subjcodelike'1604020101%'orsubj.subjcodelike'1604020102%'orsubj.subjcodelike'1604020103%'orsubj.subjcodelike'1604020104%'orsubj.subjcodelike'16040202%'orsubj.subjcodelike'1604020201%'orsubj.subjcodelike'1604020202%'orsubj.subjcodelike'1604020203%'orsubj.subjcodelike'1604020204%'orsubj.subjcodelike'160403%'orsubj.subjcodelike'16040301%'orsubj.subjcodelike'160404%'orsubj.subjcodelike'16040401%'orsubj.subjcodelike'1604040101%'orsubj.subjcodelike'1604040102%'orsubj.subjcodelike'16040402%'orsubj.subjcodelike'1604040201%'orsubj.subjcodelike'16040403%'orsubj.subjcodelike'1604040301%'orsubj.subjcodelike'1604040302%'orsubj.subjcodelike'16040404%'orsubj.subjcodelike'1604040401%'orsubj.subjcodelike'1604040402%'orsubj.subjcodelike'16040405%'orsubj.subjcodelike'1604040501%'orsubj.subjcodelike'1604040502%'orsubj.subjcodelike'16040406%'orsubj.subjcodelike'16040407%'orsubj.subjcodelike'16040408%'orsubj.subjcodelike'160405%'orsubj.subjcodelike'16040501%'orsubj.subjcodelike'16040502%'orsubj.subjcodelike'16040503%'orsubj.subjcodelike'16040504%'orsubj.subjcodelike'16040505%'orsubj.subjcodelike'16040506%'orsubj.subjcodelike'16040507%'orsubj.subjcodelike'16040508%'orsubj.subjcodelike'16040509%'orsubj.subjcodelike'16040510%'orsubj.subjcodelike'160406%'orsubj.subjcodelike'16040601%'orsubj.subjcodelike'16040602%'orsubj.subjcodelike'16040603%'orsubj.subjcodelike'16040604%'orsubj.subjcodelike'16040605%'orsubj.subjcodelike'160407%'orsubj.subjcodelike'16040701%'orsubj.subjcodelike'16040702%'orsubj.subjcodelike'16040703%'orsubj.subjcodelike'16040704%'orsubj.subjcodelike'16040705%'orsubj.subjcodelike'16040706%'orsubj.subjcodelike'16040707%'orsubj.subjcodelike'160408%'orsubj.subjcodelike'1605%'orsubj.subjcodelike'160501%'orsubj.subjcodelike'160502%'orsubj.subjcodelike'160503%'orsubj.subjcodelike'160504%'orsubj.subjcodelike'1606%'orsubj.subjcodelike'1607%'orsubj.subjcodelike'1611%'orsubj.subjcodelike'1621%'orsubj.subjcodelike'1622%'orsubj.subjcodelike'1623%'orsubj.subjcodelike'1624%'orsubj.subjcodelike'1701%'orsubj.subjcodelike'170101%'orsubj.subjcodelike'1702%'orsubj.subjcodelike'1703%'orsubj.subjcodelike'1711%'orsubj.subjcodelike'1712%'orsubj.subjcodelike'1801%'orsubj.subjcodelike'180101%'orsubj.subjcode9/20like'180102%'orsubj.subjcodelike'180103%'orsubj.subjcodelike'180104%'orsubj.subjcodelike'180105%'orsubj.subjcodelike'1811%'orsubj.subjcodelike'1901%'orsubj.subjcodelike'190101%'orsubj.subjcodelike'190102%'orsubj.subjcodelike'2001%'orsubj.subjcodelike'2101%'orsubj.subjcodelike'210101%'orsubj.subjcodelike'210102%'orsubj.subjcodelike'210103%'orsubj.subjcodelike'2102%'orsubj.subjcodelike'210201%'orsubj.subjcodelike'21020101%'orsubj.subjcodelike'2103%'orsubj.subjcodelike'2201%'orsubj.subjcodelike'220101%'orsubj.subjcodelike'220102%'orsubj.subjcodelike'2202%'orsubj.subjcodelike'220201%'orsubj.subjcodelike'220202%'orsubj.subjcodelike'22020201%'orsubj.subjcodelike'22020202%'orsubj.subjcodelike'22020203%'orsubj.subjcodelike'22020204%'orsubj.subjcodelike'220203%'orsubj.subjcodelike'220204%'orsubj.subjcodelike'220205%'orsubj.subjcodelike'220206%'orsubj.subjcodelike'2203%'orsubj.subjcodelike'220301%'orsubj.subjcodelike'220302%'orsubj.subjcodelike'220303%'orsubj.subjcodelike'220304%'orsubj.subjcodelike'22030401%'orsubj.subjcodelike'22030402%'orsubj.subjcodelike'22030403%'orsubj.subjcodelike'22030404%'orsubj.subjcodelike'22030405%'orsubj.subjcodelike'22030406%'orsubj.subjcodelike'22030407%'orsubj.subjcodelike'22030408%'orsubj.subjcodelike'22030409%'orsubj.subjcodelike'220305%'orsubj.subjcodelike'2211%'orsubj.subjcodelike'221101%'orsubj.subjcodelike'22110101%'orsubj.subjcodelike'2211010101%'orsubj.subjcodelike'2211010102%'orsubj.subjcodelike'2211010103%'orsubj.subjcodelike'2211010104%'orsubj.subjcodelike'2211010105%'orsubj.subjcodelike'2211010106%'orsubj.subjcodelike'2211010107%'orsubj.subjcodelike'2211010109%'orsubj.subjcodelike'2211010110%'orsubj.subjcodelike'22110102%'orsubj.subjcodelike'2211010201%'orsubj.subjcodelike'221101020101%'orsubj.subjcodelike'22110102010101%'orsubj.subjcodelike'22110102010102%'orsubj.subjcodelike'221101020102%'orsubj.subjcodelike'221101020103%'orsubj.subjcodelike'221101020104%'orsubj.subjcodelike'22110102010401%'orsubj.subjcodelike'22110102010402%'orsubj.subjcodelike'22110102010403%'orsubj.subjcodelike'22110102010404%'orsubj.subjcodelike'22110102010405%'orsubj.subjcodelike'22110102010406%'orsubj.subjcodelike'22110102010407%'orsubj.subjcodelike'22110102010408%'orsubj.subjcodelike'22110102010409%'orsubj.subjcodelike'22110102010410%'orsubj.subjcodelike'22110102010411%'orsubj.subjcodelike'22110102010412%'orsubj.subjcodelike'221101020105%'orsubj.subjcodelike'22110102010501%'orsubj.subjcodelike'22110102010502%'orsubj.subjcodelike'22110102010503%'orsubj.subjcodelike'22110102010504%'orsubj.subjcodelike'2211010202%'orsubj.subjcodelike'2211010204%'orsubj.subjcodelike'22110103%'orsubj.subjcodelike'221102%'orsubj.subjcodelike'22110201%'orsubj.subjcodelike10/20'22110202%'orsubj.subjcodelike'22110203%'orsubj.subjcodelike'22110205%'orsubj.subjcodelike'22110206%'orsubj.subjcodelike'22110207%'orsubj.subjcodelike'22110208%'orsubj.subjcodelike'22110209%'orsubj.subjcodelike'22110210%'orsubj.subjcodelike'22110211%'orsubj.subjcodelike'22110212%'orsubj.subjcodelike'22110213%'orsubj.subjcodelike'22110214%'orsubj.subjcodelike'22110215%'orsubj.subjcodelike'22110216%'orsubj.subjcodelike'22110217%'orsubj.subjcodelike'22110218%'orsubj.subjcodelike'2211021801%'orsubj.subjcodelike'2211021802%'orsubj.subjcodelike'22110219%'orsubj.subjcodelike'221103%'orsubj.subjcodelike'22110301%'orsubj.subjcodelike'2211030101%'orsubj.subjcodelike'221103010101%'orsubj.subjcodelike'221103010102%'orsubj.subjcodelike'2211030102%'orsubj.subjcodelike'22110302%'orsubj.subjcodelike'22110303%'orsubj.subjcodelike'22110304%'orsubj.subjcodelike'22110305%'orsubj.subjcodelike'22110306%'orsubj.subjcodelike'221104%'orsubj.subjcodelike'221105%'orsubj.subjcodelike'22110501%'orsubj.subjcodelike'22110502%'orsubj.subjcodelike'221106%'orsubj.subjcodelike'221107%'orsubj.subjcodelike'221108%'orsubj.subjcodelike'221109%'orsubj.subjcodelike'221110%'orsubj.subjcodelike'22111001%'orsubj.subjcodelike'2221%'orsubj.subjcodelike'222101%'orsubj.subjcodelike'22210101%'orsubj.subjcodelike'2221010101%'orsubj.subjcodelike'2221010102%'orsubj.subjcodelike'22210102%'orsubj.subjcodelike'22210103%'orsubj.subjcodelike'22210104%'orsubj.subjcodelike'22210105%'orsubj.subjcodelike'22210106%'orsubj.subjcodelike'22210107%'orsubj.subjcodelike'22210108%'orsubj.subjcodelike'22210109%'orsubj.subjcodelike'22210110%'orsubj.subjcodelike'22210111%'orsubj.subjcodelike'222102%'orsubj.subjcodelike'222103%'orsubj.subjcodelike'222104%'orsubj.subjcodelike'222105%'orsubj.subjcodelike'222106%'orsubj.subjcodelike'222107%'orsubj.subjcodelike'222108%'orsubj.subjcodelike'222109%'orsubj.subjcodelike'222110%'orsubj.subjcodelike'222111%'orsubj.subjcodelike'222112%'orsubj.subjcodelike'22211201%'orsubj.subjcodelike'22211202%'orsubj.subjcodelike'222113%'orsubj.subjcodelike'22211301%'orsubj.subjcodelike'22211302%'orsubj.subjcodelike'22211303%'orsubj.subjcodelike'22211304%'orsubj.subjcodelike'222114%'orsubj.subjcodelike'2231%'orsubj.subjcodelike'2232%'orsubj.subjcodelike'2241%'orsubj.subjcodelike'224101%'orsubj.subjcodelike'22410101%'orsubj.subjcodelike'22410102%'orsubj.subjcodelike'22410103%'orsubj.subjcodelike'22410104%'orsubj.subjcodelike'224102%'orsubj.subjcodelike'22410201%'orsubj.subjcodelike'22410202%'orsubj.subjcodelike'22410203%'orsubj.subjcodelike'22410204%'orsubj.subjcodelike'22410205%'orsubj.subjcodelike'22410206%'orsubj.subjcodelike'22410207%'or11/20subj.subjcodelike'224103%'orsubj.subjcodelike'22410301%'orsubj.subjcodelike'22410302%'orsubj.subjcodelike'22410303%'orsubj.subjcodelike'22410304%'orsubj.subjcodelike'22410305%'orsubj.subjcodelike'22410306%'orsubj.subjcodelike'22410307%'orsubj.subjcodelike'22410308%'orsubj.subjcodelike'22410309%'orsubj.subjcodelike'22410310%'orsubj.subjcodelike'224104%'orsubj.subjcodelike'22410401%'orsubj.subjcodelike'2241040101%'orsubj.subjcodelike'2241040102%'orsubj.subjcodelike'22410402%'orsubj.subjcodelike'2241040201%'orsubj.subjcodelike'2241040202%'orsubj.subjcodelike'22410403%'orsubj.subjcodelike'22410404%'orsubj.subjcodelike'22410405%'orsubj.subjcodelike'2241040501%'orsubj.subjcodelike'2241040502%'orsubj.subjcodelike'2241040503%'orsubj.subjcodelike'22410406%'orsubj.subjcodelike'224105%'orsubj.subjcodelike'22410501%'orsubj.subjcodelike'22410502%'orsubj.subjcodelike'22410503%'orsubj.subjcodelike'22410504%'orsubj.subjcodelike'22410505%'orsubj.subjcodelike'22410506%'orsubj.subjcodelike'22410507%'orsubj.subjcodelike'22410508%'orsubj.subjcodelike'22410509%'orsubj.subjcodelike'224106%'orsubj.subjcodelike'22410601%'orsubj.subjcodelike'22410602%'orsubj.subjcodelike'224107%'orsubj.subjcodelike'22410701%'orsubj.subjcodelike'22410702%'orsubj.subjcodelike'22410703%'orsubj.subjcodelike'22410704%'orsubj.subjcodelike'224108%'orsubj.subjcodelike'22410801%'orsubj.subjcodelike'22410802%'orsubj.subjcodelike'224109%'orsubj.subjcodelike'224110%'orsubj.subjcodelike'22411001%'orsubj.subjcodelike'22411002%'orsubj.subjcodelike'2241100201%'orsubj.subjcodelike'2241100202%'orsubj.subjcodelike'224111%'orsubj.subjcodelike'224112%'orsubj.subjcodelike'224113%'orsubj.subjcodelike'224114%'orsubj.subjcodelike'224115%'orsubj.subjcodelike'224116%'orsubj.subjcodelike'22411601%'orsubj.subjcodelike'2241160101%'orsubj.subjcodelike'22411602%'orsubj.subjcodelike'22411603%'orsubj.subjcodelike'22411604%'orsubj.subjcodelike'22411605%'orsubj.subjcodelike'22411609%'orsubj.subjcodelike'2314%'orsubj.subjcodelike'2401%'orsubj.subjcodelike'240101%'orsubj.subjcodelike'240102%'orsubj.subjcodelike'2501%'orsubj.subjcodelike'250101%'orsubj.subjcodelike'250102%'orsubj.subjcodelike'2502%'orsubj.subjcodelike'250201%'orsubj.subjcodelike'250202%'orsubj.subjcodelike'250203%'orsubj.subjcodelike'2701%'orsubj.subjcodelike'270101%'orsubj.subjcodelike'270102%'orsubj.subjcodelike'270103%'orsubj.subjcodelike'270104%'orsubj.subjcodelike'270105%'orsubj.subjcodelike'270106%'orsubj.subjcodelike'270107%'orsubj.subjcodelike'270108%'orsubj.subjcodelike'270109%'orsubj.subjcodelike'270110%'orsubj.subjcodelike'270111%'orsubj.subjcodelike'2702%'orsubj.subjcodelike'270201%'orsubj.subjcode12/20like'270202%'orsubj.subjcodelike'2711%'orsubj.subjcodelike'271101%'orsubj.subjcodelike'271102%'orsubj.subjcodelike'271103%'orsubj.subjcodelike'271104%'orsubj.subjcodelike'2801%'orsubj.subjcodelike'280101%'orsubj.subjcodelike'280102%'orsubj.subjcodelike'280103%'orsubj.subjcodelike'280104%'orsubj.subjcodelike'280105%'orsubj.subjcodelike'280106%'orsubj.subjcodelike'2901%'orsubj.subjcodelike'4001%'orsubj.subjcodelike'400101%'orsubj.subjcodelike'400102%'orsubj.subjcodelike'40010201%'orsubj.subjcodelike'40010202%'orsubj.subjcodelike'40010203%'orsubj.subjcodelike'400103%'orsubj.subjcodelike'400104%'orsubj.subjcodelike'4002%'orsubj.subjcodelike'400201%'orsubj.subjcodelike'400202%'orsubj.subjcodelike'40020201%'orsubj.subjcodelike'40020202%'orsubj.subjcodelike'40020203%'orsubj.subjcodelike'40020204%'orsubj.subjcodelike'40020205%'orsubj.subjcodelike'40020206%'orsubj.subjcodelike'40020207%'orsubj.subjcodelike'40020208%'orsubj.subjcodelike'40020209%'orsubj.subjcodelike'4101%'orsubj.subjcodelike'410101%'orsubj.subjcodelike'410102%'orsubj.subjcodelike'410103%'orsubj.subjcodelike'410104%'orsubj.subjcodelike'410105%'orsubj.subjcodelike'4103%'orsubj.subjcodelike'410301%'orsubj.subjcodelike'410302%'orsubj.subjcodelike'410303%'orsubj.subjcodelike'410304%'orsubj.subjcodelike'410305%'orsubj.subjcodelike'410306%'orsubj.subjcodelike'410307%'orsubj.subjcodelike'410308%'orsubj.subjcodelike'410309%'orsubj.subjcodelike'4104%'orsubj.subjcodelike'410401%'orsubj.subjcodelike'410402%'orsubj.subjcodelike'410403%'orsubj.subjcodelike'410404%'orsubj.subjcodelike'410405%'orsubj.subjcodelike'410406%'orsubj.subjcodelike'410407%'orsubj.subjcodelike'410408%'orsubj.subjcodelike'410409%'orsubj.subjcodelike'410410%'orsubj.subjcodelike'410411%'orsubj.subjcodelike'410412%'orsubj.subjcodelike'410413%'orsubj.subjcodelike'4201%'orsubj.subjcodelike'4301%'orsubj.subjcodelike'430101%'orsubj.subjcodelike'43010101%'orsubj.subjcodelike'43010102%'orsubj.subjcodelike'430102%'orsubj.subjcodelike'43010201%'orsubj.subjcodelike'43010202%'orsubj.subjcodelike'5001%'orsubj.subjcodelike'500101%'orsubj.subjcodelike'50010101%'orsubj.subjcodelike'5001010101%'orsubj.subjcodelike'5001010102%'orsubj.subjcodelike'5001010103%'orsubj.subjcodelike'5001010104%'orsubj.subjcodelike'5001010105%'orsubj.subjcodelike'5001010106%'orsubj.subjcodelike'5001010107%'orsubj.subjcodelike'5001010108%'orsubj.subjcodelike'5001010109%'orsubj.subjcodelike'5001010110%'orsubj.subjcodelike'5001010111%'orsubj.subjcodelike'500101011101%'orsubj.subjcodelike'500101011102%'orsubj.subjcodelike'5001010112%'orsubj.subjcodelike'50010102%'orsubj.subjcodelike'50010103%'orsubj.subjcodelike'5001010301%'orsubj.subjcodelike'5001010302%'or13/20subj.subjcodelike'5001010303%'orsubj.subjcodelike'50010104%'orsubj.subjcodelike'50010105%'orsubj.subjcodelike'50010106%'orsubj.subjcodelike'5001010601%'orsubj.subjcodelike'5001010602%'orsubj.subjcodelike'5001010603%'orsubj.subjcodelike'5001010604%'orsubj.subjcodelike'5001010605%'orsubj.subjcodelike'5001010606%'orsubj.subjcodelike'5001010607%'orsubj.subjcodelike'5001010608%'orsubj.subjcodelike'5001010609%'orsubj.subjcodelike'50010107%'orsubj.subjcodelike'50010108%'orsubj.subjcodelike'50010109%'orsubj.subjcodelike'50010111%'orsubj.subjcodelike'500102%'orsubj.subjcodelike'50010201%'orsubj.subjcodelike'50010202%'orsubj.subjcodelike'50010203%'orsubj.subjcodelike'5001020301%'orsubj.subjcodelike'5001020302%'orsubj.subjcodelike'5001020303%'orsubj.subjcodelike'5001020304%'orsubj.subjcodelike'5001020305%'orsubj.subjcodelike'5001020306%'orsubj.subjcodelike'5001020307%'orsubj.subjcodelike'5001020308%'orsubj.subjcodelike'5001020309%'orsubj.subjcodelike'50010204%'orsubj.subjcodelike'50010210%'orsubj.subjcodelike'500103%'orsubj.subjcodelike'50010301%'orsubj.subjcodelike'50010302%'orsubj.subjcodelike'5001030201%'orsubj.subjcodelike'5001030202%'orsubj.subjcodelike'5001030203%'orsubj.subjcodelike'50010303%'orsubj.subjcodelike'5001030301%'orsubj.subjcodelike'5001030302%'orsubj.subjcodelike'5001030303%'orsubj.subjcodelike'5001030304%'orsubj.subjcodelike'5001030305%'orsubj.subjcodelike'5001030306%'orsubj.subjcodelike'5001030307%'orsubj.subjcodelike'5001030308%'orsubj.subjcodelike'5001030309%'orsubj.subjcodelike'50010304%'orsubj.subjcodelike'50010305%'orsubj.subjcodelike'50010310%'orsubj.subjcodelike'5101%'orsubj.subjcodelike'510101%'orsubj.subjcodelike'51010101%'orsubj.subjcodelike'5101010101%'orsubj.subjcodelike'5101010102%'orsubj.subjcodelike'5101010103%'orsubj.subjcodelike'5101010104%'orsubj.subjcodelike'5101010105%'orsubj.subjcodelike'5101010106%'orsubj.subjcodelike'5101010107%'orsubj.subjcodelike'5101010108%'orsubj.subjcodelike'5101010109%'orsubj.subjcodelike'5101010110%'orsubj.subjcodelike'5101010111%'orsubj.subjcodelike'5101010112%'orsubj.subjcodelike'5101010113%'orsubj.subjcodelike'51010102%'orsubj.subjcodelike'51010103%'orsubj.subjcodelike'5101010301%'orsubj.subjcodelike'5101010302%'orsubj.subjcodelike'5101010303%'orsubj.subjcodelike'5101010304%'orsubj.subjcodelike'5101010305%'orsubj.subjcodelike'5101010306%'orsubj.subjcodelike'5101010307%'orsubj.subjcodelike'5101010308%'orsubj.subjcodelike'5101010309%'orsubj.subjcodelike'51010104%'orsubj.subjcodelike'51010105%'orsubj.subjcodelike'51010106%'orsubj.subjcodelike'51010107%'orsubj.subjcodelike'51010108%'orsubj.subjcodelike'51010109%'orsubj.subjcodelike'51010110%'orsubj.subjcodelike'51010111%'orsubj.subjcodelike'5101011101%'orsubj.subjcodelike'5101011102%'or14/20subj.subjcodelike'5101011103%'orsubj.subjcodelike'5101011104%'orsubj.subjcodelike'5101011105%'orsubj.subjcodelike'5101011106%'orsubj.subjcodelike'51010...
