select count(*) as sum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'VE' and acptkindlrgcd = 'Q') as v01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'VE' and acptkindlrgcd = 'S') as v02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'VE' and acptkindlrgcd = 'P') as v03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'VE' and acptkindlrgcd = 'C') as v04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'VE') as vsum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'TE' and acptkindlrgcd = 'Q') as t01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'TE' and acptkindlrgcd = 'S') as t02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'TE' and acptkindlrgcd = 'P') as t03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'TE' and acptkindlrgcd = 'C') as t04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'TE') as tsum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'PE' and acptkindlrgcd = 'Q') as p01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'PE' and acptkindlrgcd = 'S') as p02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'PE' and acptkindlrgcd = 'P') as p03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'PE' and acptkindlrgcd = 'C') as p04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'PE') as psum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'EE' and acptkindlrgcd = 'Q') as e01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'EE' and acptkindlrgcd = 'S') as e02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'EE' and acptkindlrgcd = 'P') as e03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'EE' and acptkindlrgcd = 'C') as e04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'EE') as esum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'HE' and acptkindlrgcd = 'Q') as h01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'HE' and acptkindlrgcd = 'S') as h02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'HE' and acptkindlrgcd = 'P') as h03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'HE' and acptkindlrgcd = 'C') as h04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'HE') as hsum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'FE' and acptkindlrgcd = 'Q') as f01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'FE' and acptkindlrgcd = 'S') as f02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'FE' and acptkindlrgcd = 'P') as f03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'FE' and acptkindlrgcd = 'C') as f04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'FE') as fsum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'DE' and acptkindlrgcd = 'Q') as d01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'DE' and acptkindlrgcd = 'S') as d02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'DE' and acptkindlrgcd = 'P') as d03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'DE' and acptkindlrgcd = 'C') as d04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'DE') as dsum, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'ZE' and acptkindlrgcd = 'Q') as z01, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'ZE' and acptkindlrgcd = 'S') as z02, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'ZE' and acptkindlrgcd = 'P') as z03, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'ZE' and acptkindlrgcd = 'C') as z04, (select count(*) from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}' and acpttypecd = 'ZE') as zsum, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'VE') as vname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'TE') as tname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'PE') as pname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'EE') as ename, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'HE') as hname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'FE') as fname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'DE') as dname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0001' and cdid = 'ZE') as zname, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0003' and cdid = 'Q') as name1, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0003' and cdid = 'S') as name2, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0003' and cdid = 'P') as name3, (SELECT cdnm FROM com.zbcmcode WHERE cdgrupid = 'C0003' and cdid = 'C') as name4 from crm.cuvhacpi where acptdd >= '{?srchacptdd1}' and acptdd <= '{?srchacptdd2}' and cnclyn = 'N' and instcd = '{?instcd}'