searchforchar.c

在一大串字符串中查找某一个字符或者字符串出现的次数.并且返回次数.

        1001,"SELECT CH_STATION_CD, NM_NOWVER_NO FROM M016_FAREVARMNG WHERE NM_UMACHINE_CD = %s",
        1190,"SELECT A.CH_STATION_CD, A.NM_INSTATION_CD, B.NM_CLOSE_NO, TO_CHAR(B.DT_JUNKEI2,'YYYYMMDD') || '0000' AS DT_INDATE FROM M002_EKI_V A, T603_JUNKANRI B WHERE TO_CHAR(B.DT_JUNKEI1,'YYYYMMDD') = '%s' AND A.CH_STATION_CD = B.CH_STATION_CD AND A.NM_VER_KBN = 1 AND A.CH_STATION_CD = '%s'",
        1151,"SELECT 墂柤,SUM(搶奀敪斞嶳枮),SUM(搶奀敪杒廗巙栰),SUM(搶奀敪慏嫶擔戝),SUM(搶奀敪敧愮戙椢偑媢),SUM(搶奀敪敧愮戙拞墰),SUM(搶奀敪懞忋),SUM(搶奀敪搶梩彑揷戜),SUM(搶奀敪儊僩儘),SUM(搶奀敪JR),SUM(斞嶳敪搶奀恄),SUM(斞嶳敪杒廗巙栰),SUM(斞嶳敪慏嫶擔戝),SUM(斞嶳敪敧愮戙椢偑媢),SUM(斞嶳敪敧愮戙拞墰),SUM(斞嶳敪懞忋),SUM(斞嶳敪搶梩彑揷戜),SUM(斞嶳敪儊僩儘),SUM(斞嶳敪JR),SUM(杒壓敪搶奀恄),SUM(杒壓敪斞嶳枮),SUM(杒壓敪慏嫶擔戝),SUM(杒壓敪敧愮戙椢偑媢),SUM(杒壓敪敧愮戙拞墰),SUM(杒壓敪懞忋),SUM(杒壓敪搶梩彑揷戜),SUM(杒壓敪儊僩儘),SUM(杒壓敪JR),SUM(擔戝敪搶奀恄),SUM(擔戝敪斞嶳枮),SUM(擔戝敪杒廗巙栰),SUM(擔戝敪敧愮戙椢偑媢),SUM(擔戝敪敧愮戙拞墰),SUM(擔戝敪懞忋),SUM(擔戝敪搶梩彑揷戜),SUM(擔戝敪儊僩儘),SUM(擔戝敪JR),SUM(椢偑媢敪搶奀恄),SUM(椢偑媢敪斞嶳枮),SUM(椢偑媢敪杒廗巙栰),SUM(椢偑媢敪慏嫶擔戝),SUM(椢偑媢敪敧愮戙拞墰),SUM(椢偑媢敪懞忋),SUM(椢偑媢敪搶梩彑揷戜),SUM(椢偑媢敪儊僩儘),SUM(椢偑媢敪JR),SUM(拞墰敪搶奀恄),SUM(拞墰敪斞嶳枮),SUM(拞墰敪杒廗巙栰),SUM(拞墰敪慏嫶擔戝),SUM(拞墰敪敧愮戙椢偑媢),SUM(拞墰敪懞忋),SUM(拞墰敪搶梩彑揷戜),SUM(拞墰敪儊僩儘),SUM(拞墰敪JR),SUM(懞忋敪搶奀恄),SUM(懞忋敪斞嶳枮),SUM(懞忋敪杒廗巙栰),SUM(懞忋敪慏嫶擔戝),SUM(懞忋敪敧愮戙椢偑媢),SUM(懞忋敪敧愮戙拞墰),SUM(懞忋敪搶梩彑揷戜),SUM(懞忋敪儊僩儘),SUM(懞忋敪JR),SUM(搶梩敪搶奀恄),SUM(搶梩敪斞嶳枮),SUM(搶梩敪杒廗巙栰),SUM(搶梩敪慏嫶擔戝),SUM(搶梩敪敧愮戙椢偑媢),SUM(搶梩敪敧愮戙拞墰),SUM(搶梩敪懞忋),SUM(搶梩敪儊僩儘),SUM(搶梩敪JR),SUM(惣慏嫶敪搶奀恄),SUM(惣慏嫶敪斞嶳枮),SUM(惣慏嫶敪杒廗巙栰),SUM(惣慏嫶敪慏嫶擔戝),SUM(惣慏嫶敪敧愮戙椢偑媢),SUM(惣慏嫶敪敧愮戙拞墰),SUM(惣慏嫶敪懞忋),SUM(惣慏嫶敪搶梩彑揷戜),SUM(儊僩儘敪搶奀恄),SUM(儊僩儘敪斞嶳枮),SUM(儊僩儘敪杒廗巙栰),SUM(儊僩儘敪慏嫶擔戝),SUM(儊僩儘敪敧愮戙椢偑媢),SUM(儊僩儘敪敧愮戙拞墰),SUM(儊僩儘敪懞忋),SUM(儊僩儘敪搶梩彑揷戜),SUM(JR敪搶奀恄),SUM(JR敪斞嶳枮),SUM(JR敪杒廗巙栰),SUM(JR敪慏嫶擔戝),SUM(JR敪敧愮戙椢偑媢),SUM(JR敪敧愮戙拞墰),SUM(JR敪懞忋),SUM(JR敪搶梩彑揷戜),SUM(怴嫗惉敪搶奀恄),SUM(怴嫗惉敪斞嶳枮),SUM(怴嫗惉敪杒廗巙栰),SUM(怴嫗惉敪慏嫶擔戝),SUM(怴嫗惉敪敧愮戙椢偑媢),SUM(怴嫗惉敪敧愮戙拞墰),SUM(怴嫗惉敪懞忋),SUM(怴嫗惉敪搶梩彑揷戜),SUM(嫗惉敪搶奀恄),SUM(嫗惉敪斞嶳枮),SUM(嫗惉敪杒廗巙栰),SUM(嫗惉敪慏嫶擔戝),SUM(嫗惉敪敧愮戙椢偑媢),SUM(嫗惉敪敧愮戙拞墰),SUM(嫗惉敪懞忋),SUM(嫗惉敪搶梩彑揷戜) FROM EKIMUTUAL_NOTTEIKI_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' GROUP BY 墂柤",
        1140,"SELECT SUM(廤1嬥),SUM(廤2悢),SUM(廤2嬥),SUM(廤3悢),SUM(廤3嬥),SUM(廤4悢),SUM(廤4嬥),SUM(廤5悢),SUM(廤5嬥),SUM(廤6悢),SUM(廤6嬥),SUM(廤7悢),SUM(廤7嬥),SUM(廤8悢),SUM(廤8嬥),SUM(廤9悢),SUM(廤9嬥),SUM(廤10悢),SUM(廤10嬥),SUM(廤11悢),SUM(廤11嬥),SUM(廤12枃),SUM(廤12嬥),SUM(廤13枃),SUM(廤13嬥),SUM(廤14枃),SUM(廤14嬥),SUM(廤15枃),SUM(廤15嬥),SUM(廤16枃),SUM(廤16嬥),SUM(廤17枃),SUM(廤17嬥),SUM(廤18枃),SUM(廤18嬥),SUM(廤19枃),SUM(廤19嬥),SUM(廤20枃),SUM(廤20嬥),SUM(廤21悢),SUM(廤21嬥),SUM(廤22悢),SUM(廤22嬥),SUM(廤23悢),SUM(廤23嬥),SUM(廤24悢),SUM(廤24嬥),SUM(廤25悢),SUM(廤25嬥),SUM(廤26悢),SUM(廤26嬥),SUM(廤27悢),SUM(廤27嬥),SUM(廤28悢),SUM(廤28嬥),SUM(廤29悢),SUM(廤29嬥),SUM(廤30悢),SUM(廤30嬥) FROM GATEMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s",
        725,"DELETE FROM T603_JUNKANRI WHERE CH_STATION_CD='%s' AND TO_CHAR(DT_JUNKEI1,'YYYYMMDDHH24MISS') = (SELECT MIN(TO_CHAR(DT_JUNKEI1,'YYYYMMDDHH24MISS')) FROM T603_JUNKANRI WHERE CH_STATION_CD='%s' HAVING COUNT(CH_STATION_CD) > 3)",
        740,"UPDATE T606_KIKIKANRI SET NM_SYUSYU_ST=0, DT_UPDATE = SYSDATE WHERE CH_STATION_CD='%s' AND NM_MACHINE_CD =%s",
        750,"SELECT (SELECT COUNT(CH_STATION_CD) FROM T401_HAND_WINDOW WHERE CH_STATION_CD='%s' AND DT_CLOSE IS NULL) + (SELECT COUNT(CH_STATION_CD) FROM T601_SIMEKANRI WHERE CH_STATION_CD='%s' AND DT_SYUNYU IS NULL),(SELECT MAX(NM_CLOSE_NO) FROM T603_JUNKANRI WHERE CH_STATION_CD='%s' AND DT_JUNKEI1=(SELECT MAX(DT_JUNKEI1) FROM T603_JUNKANRI WHERE CH_STATION_CD='%s')) FROM DUAL",
        1145,"SELECT 奐巒帪崗,SUM(捠嬑掕婜),SUM(捠妛掕婜),SUM(掕婜寁),SUM(晛捠寯),SUM(夞悢寯),SUM(偦偺懠),SUM(僇乕僪),SUM(掕婜奜寁) FROM AUTOGATE_STAFF_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' AND 奐巒帪崗 BETWEEN '%s' and '%s' AND 墂柤 = '%s' AND 擖弌応嬫暘 = %s GROUP BY 奐巒帪崗",
        1100,"SELECT MAX(NM_CLOSE_NO)AS NM_CLOSE_NO FROM T601_SIMEKANRI WHERE DT_CLOSE LIKE TO_DATE('%s','YYYYMMDD') AND CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s",
        623,"DELETE FROM T401_HAND_WINDOW WHERE CH_STATION_CD = '%s' AND TO_CHAR( DT_INS, 'YYYYMMDD') = '%s' AND NM_INS_NO = %s",
        624,"DELETE FROM T402_SCRAP_TICK WHERE CH_STATION_CD = '%s' AND TO_CHAR( DT_INS, 'YYYYMMDD') = '%s' AND NM_INS_NO = %s",
        625,"SELECT MAX(NM_KANRI_NO) FROM T403_HAND_CASH WHERE CH_STATION_CD = '%s'",
        1191,"SELECT A.CH_STATION_CD, A.NM_INSTATION_CD, %s, TO_CHAR(MAX(B.DT_DATE),'YYYYMMDDHH24MI') AS DT_DATE FROM M002_EKI_V A, T721_DAILY_DATA_SF B WHERE A.CH_STATION_CD = '%s' AND A.NM_VER_KBN = 1 AND A.CH_STATION_CD = B.CH_STATION_CD AND B.NM_MACHINE_CD = %s GROUP BY A.CH_STATION_CD, A.NM_INSTATION_CD",
        9009,"UPDATE T606_KIKIKANRI SET NM_DEVICE_ST=%s where CH_STATION_CD='%s' and NM_MACHINE_CD=%s and NM_CORNER_NO=%s and NM_GOUKI_NO=%s",
        9010,"SELECT NM_DEVICE_ST FROM T606_KIKIKANRI WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND NM_CORNER_NO = %s AND NM_GOUKI_NO = %s",
        631,"DELETE FROM T721_DAILY_DATA_SF WHERE CH_STATION_CD = '%s'",
        400,"SELECT NM_MACHINE_CD,NM_CORNER_NO,NM_GOUKI_NO,%s FROM T606_KIKIKANRI WHERE CH_STATION_CD = '%s' ORDER BY NM_MACHINE_CD,NM_CORNER_NO,NM_GOUKI_NO",
        401,"SELECT NM_NOWVER_NO,NM_NEWVER_NO from M016_FAREVARMNG WHERE CH_STATION_CD = '%s' AND NM_UMACHINE_CD = %s",
        402,"SELECT NM_UMACHINE_CD, NM_DEVTYPE_DV, NM_NOWVER_NO,TO_CHAR(DT_NOWKIRIKAE,'YYYYMMDD')as DT_NOWKIRIKAE, NM_NEWVER_NO, TO_CHAR(DT_NEWKIRIKAE,'YYYYMMDD')as DT_NEWKIRIKAE  FROM M016_FAREVARMNG WHERE CH_STATION_CD='%s'",
        9001,"SELECT * FROM M021_COM_SF_V WHERE NM_VER_KBN = %s",
        9002,"SELECT * FROM M022_COM_ILGL_V WHERE NM_VER_KBN = %s",
        9003,"SELECT * FROM M023_COM_HLDAY_V WHERE NM_VER_KBN = %s ORDER BY NM_COMPANY_DV",
        9004,"SELECT * FROM M031_GATE_OD_V WHERE NM_VER_KBN = %s",
        9005,"SELECT * FROM M032_GATE_TRM_V WHERE NM_VER_KBN = %s",
        9006,"SELECT * FROM M035_GATE_LOSS_V WHERE NM_VER_KBN = %s",
        50,"UPDATE M001_USER SET VC_KANJINAME='%s', NM_VER_NO=%s",
        700,"SELECT  MAX(NM_CLOSE_NO) FROM T601_SIMEKANRI WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND TO_CHAR( DT_CLOSE, 'YYYYMMDD') = '%s'",
        701,"UPDATE T101_DAILY_TICK SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        702,"UPDATE T102_DAILY_LQDN SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        703,"UPDATE T103_DAILY_GATE SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        704,"UPDATE T104_DAILY_CARD SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        711,"UPDATE T111_DAILY_SFCARD SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        712,"UPDATE T112_DAILY_DEMAND SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        713,"UPDATE T113_DAILY_ONEDTL SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        714,"UPDATE T114_DAILY_ROUTE SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        715,"UPDATE T115_DAILY_CARD SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        716,"UPDATE T116_DAILY_TTLSUM SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        717,"UPDATE T117_DAILY_SFRUTO SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND DT_CLOSE IS NULL",
        1127,"SELECT SUM(儊僩儘敪攧悢寁),SUM(儊僩儘敪攧嬥妟寁),SUM(儊僩儘暐栠枃悢寁),SUM(儊僩儘暐栠嬥妟寁),JR1戝扨,JR2戝扨,JR3戝扨,JR4戝扨,JR5戝扨,JR6戝扨,JR7戝扨,JR8戝扨,JR9戝扨,JR10戝扨,JR11戝扨,JR12戝扨,JR13戝扨,JR14戝扨,JR15戝扨,JR16戝扨,SUM(JR1戝敪攧悢),SUM(JR2戝敪攧悢),SUM(JR3戝敪攧悢),SUM(JR4戝敪攧悢),SUM(JR5戝敪攧悢),SUM(JR6戝敪攧悢),SUM(JR7戝敪攧悢),SUM(JR8戝敪攧悢),SUM(JR9戝敪攧悢),SUM(JR10戝敪攧悢),SUM(JR11戝敪攧悢),SUM(JR12戝敪攧悢),SUM(JR13戝敪攧悢),SUM(JR14戝敪攧悢),SUM(JR15戝敪攧悢),SUM(JR16戝敪攧悢),SUM(JR1戝暐栠),SUM(JR2戝暐栠),SUM(JR3戝暐栠),SUM(JR4戝暐栠),SUM(JR5戝暐栠),SUM(JR6戝暐栠),SUM(JR7戝暐栠),SUM(JR8戝暐栠),SUM(JR9戝暐栠),SUM(JR10戝暐栠),SUM(JR11戝暐栠),SUM(JR12戝暐栠),SUM(JR13戝暐栠),SUM(JR14戝暐栠),SUM(JR15戝暐栠),SUM(JR16戝暐栠),JR1彫扨,JR2彫扨,JR3彫扨,JR4彫扨,JR5彫扨,JR6彫扨,JR7彫扨,JR8彫扨,JR9彫扨,JR10彫扨,JR11彫扨,JR12彫扨,JR13彫扨,JR14彫扨,JR15彫扨,JR16彫扨,SUM(JR1彫敪攧悢),SUM(JR2彫敪攧悢),SUM(JR3彫敪攧悢),SUM(JR4彫敪攧悢),SUM(JR5彫敪攧悢),SUM(JR6彫敪攧悢),SUM(JR7彫敪攧悢),SUM(JR8彫敪攧悢),SUM(JR9彫敪攧悢),SUM(JR10彫敪攧悢),SUM(JR11彫敪攧悢),SUM(JR12彫敪攧悢),SUM(JR13彫敪攧悢),SUM(JR14彫敪攧悢),SUM(JR15彫敪攧悢),SUM(JR16彫敪攧悢),SUM(JR1彫暐栠),SUM(JR2彫暐栠),SUM(JR3彫暐栠),SUM(JR4彫暐栠),SUM(JR5彫暐栠),SUM(JR6彫暐栠),SUM(JR7彫暐栠),SUM(JR8彫暐栠),SUM(JR9彫暐栠),SUM(JR10彫暐栠),SUM(JR11彫暐栠),SUM(JR12彫暐栠),SUM(JR13彫暐栠),SUM(JR14彫暐栠),SUM(JR15彫暐栠),SUM(JR16彫暐栠),SUM(JR敪攧悢寁),SUM(JR敪攧嬥妟寁),SUM(JR暐栠枃悢寁),SUM(JR暐栠嬥妟寁),JR搶惣1戝扨,JR搶惣2戝扨,JR搶惣3戝扨,JR搶惣4戝扨,JR搶惣5戝扨,JR搶惣6戝扨,JR搶惣7戝扨,JR搶惣8戝扨,JR搶惣9戝扨,JR搶惣10戝扨,JR搶惣11戝扨,JR搶惣12戝扨,JR搶惣13戝扨,JR搶惣14戝扨,JR搶惣15戝扨,JR搶惣16戝扨  FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s GROUP BY JR1戝扨,JR2戝扨,JR3戝扨,JR4戝扨,JR5戝扨,JR6戝扨,JR7戝扨,JR8戝扨,JR9戝扨,JR10戝扨,JR11戝扨,JR12戝扨,JR13戝扨,JR14戝扨,JR15戝扨,JR16戝扨,JR1彫扨,JR2彫扨,JR3彫扨,JR4彫扨,JR5彫扨,JR6彫扨,JR7彫扨,JR8彫扨,JR9彫扨,JR10彫扨,JR11彫扨,JR12彫扨,JR13彫扨,JR14彫扨,JR15彫扨,JR16彫扨,JR搶惣1戝扨,JR搶惣2戝扨,JR搶惣3戝扨,JR搶惣4戝扨,JR搶惣5戝扨,JR搶惣6戝扨,JR搶惣7戝扨,JR搶惣8戝扨,JR搶惣9戝扨,JR搶惣10戝扨,JR搶惣11戝扨,JR搶惣12戝扨,JR搶惣13戝扨,JR搶惣14戝扨,JR搶惣15戝扨,JR搶惣16戝扨",
        1133,"SELECT SUM(婡娭1枃悢),SUM(婡娭1嬥妟),SUM(婡娭2枃悢),SUM(婡娭2嬥妟),SUM(婡娭3枃悢),SUM(婡娭3嬥妟),SUM(婡娭4枃悢),SUM(婡娭4嬥妟),SUM(婡娭5枃悢),SUM(婡娭5嬥妟),SUM(婡娭6枃悢),SUM(婡娭6嬥妟),SUM(婡娭7枃悢),SUM(婡娭7嬥妟),SUM(婡娭8枃悢),SUM(婡娭8嬥妟),SUM(婡娭9枃悢),SUM(婡娭9嬥妟),SUM(婡娭10枃悢),SUM(婡娭10嬥妟),SUM(婡娭11枃悢),SUM(婡娭11嬥妟),SUM(婡娭12枃悢),SUM(婡娭12嬥妟),SUM(婡娭13枃悢),SUM(婡娭13嬥妟),SUM(婡娭14枃悢),SUM(婡娭14嬥妟),SUM(婡娭15枃悢),SUM(婡娭15嬥妟),SUM(婡娭16枃悢),SUM(婡娭16嬥妟),SUM(婡娭17枃悢),SUM(婡娭17嬥妟),SUM(婡娭18枃悢),SUM(婡娭18嬥妟),SUM(婡娭19枃悢),SUM(婡娭19嬥妟),SUM(婡娭20枃悢),SUM(婡娭20嬥妟),SUM(婡娭21枃悢),SUM(婡娭21嬥妟),SUM(婡娭22枃悢),SUM(婡娭22嬥妟),SUM(婡娭23枃悢),SUM(婡娭23嬥妟),SUM(婡娭24枃悢),SUM(婡娭24嬥妟),SUM(婡娭25枃悢),SUM(婡娭25嬥妟),SUM(婡娭26枃悢),SUM(婡娭26嬥妟),SUM(婡娭27枃悢),SUM(婡娭27嬥妟),SUM(婡娭28枃悢),SUM(婡娭28嬥妟),SUM(婡娭29枃悢),SUM(婡娭29嬥妟),SUM(婡娭30枃悢),SUM(婡娭30嬥妟),SUM(寁枃悢),SUM(寁嬥妟),SUM(憤敪攧悢),SUM(憤敪攧嬥妟),SUM(憤暐栠枃悢),SUM(憤暐栠嬥妟),SUM(僇乕僪棙梡枃悢),SUM(僇乕僪棙梡嬥妟),SUM(崌寁憤尰嬥庢埖嬥妟),SUM(夞悢寯嵞敪峴枃悢),SUM(夞悢寯嵞敪峴嬥妟),SUM(帠慜敪寯枃悢),SUM(帠慜敪寯嬥妟),SUM(帋嶞枃悢),SUM(僇乕僪帋嶞枃悢),SUM(晛捠寯堎忢枃悢),SUM(晛捠寯堎忢嬥妟),SUM(夞悢寯堎忢枃悢),SUM(僇乕僪敪峴儈僗枃悢),SUM(扨敪10墌枃悢),SUM(扨敪50墌枃悢),SUM(扨敪100墌枃悢),SUM(扨敪500墌枃悢) FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s",
        1124,"SELECT NM_CLOSE_NO FROM T101_DAILY_TICK WHERE DT_CLOSE LIKE TO_DATE('%s','YYYYMMDD') AND CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND NM_GOUKI_NO = %s",
        1138,"SELECT NM_CLOSE_NO FROM T103_DAILY_GATE WHERE DT_CLOSE LIKE TO_DATE('%s','YYYYMMDD') AND CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND NM_GOUKI_NO = %s",
        1141,"SELECT NM_CLOSE_NO FROM T104_DAILY_CARD WHERE DT_CLOSE LIKE TO_DATE('%s','YYYYMMDD') AND CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND NM_GOUKI_NO = %s",
        1132,"SELECT 僇乕僪6戝扨,僇乕僪7戝扨,僇乕僪8戝扨,僇乕僪9戝扨,僇乕僪10戝扨,僇乕僪11戝扨,僇乕僪12戝扨,僇乕僪13戝扨,僇乕僪14戝扨,僇乕僪15戝扨,僇乕僪16戝扨,SUM(僇乕僪1戝敪攧悢),SUM(僇乕僪2戝敪攧悢),SUM(僇乕僪3戝敪攧悢),SUM(僇乕僪4戝敪攧悢),SUM(僇乕僪5戝敪攧悢),SUM(僇乕僪6戝敪攧悢),SUM(僇乕僪7戝敪攧悢),SUM(僇乕僪8戝敪攧悢),SUM(僇乕僪9戝敪攧悢),SUM(僇乕僪10戝敪攧悢),SUM(僇乕僪11戝敪攧悢),SUM(僇乕僪12戝敪攧悢),SUM(僇乕僪13戝敪攧悢),SUM(僇乕僪14戝敪攧悢),SUM(僇乕僪15戝敪攧悢),SUM(僇乕僪16戝敪攧悢),僇乕僪1彫扨,僇乕僪2彫扨,僇乕僪3彫扨,僇乕僪4彫扨,僇乕僪5彫扨,僇乕僪6彫扨,僇乕僪7彫扨,僇乕僪8彫扨,僇乕僪9彫扨,僇乕僪10彫扨,僇乕僪11彫扨,僇乕僪12彫扨,僇乕僪13彫扨,僇乕僪14彫扨,僇乕僪15彫扨,僇乕僪16彫扨,SUM(僇乕僪1彫敪攧悢),SUM(僇乕僪2彫敪攧悢),SUM(僇乕僪3彫敪攧悢),SUM(僇乕僪4彫敪攧悢),SUM(僇乕僪5彫敪攧悢),SUM(僇乕僪6彫敪攧悢),SUM(僇乕僪7彫敪攧悢),SUM(僇乕僪8彫敪攧悢),SUM(僇乕僪9彫敪攧悢),SUM(僇乕僪10彫敪攧悢),SUM(僇乕僪11彫敪攧悢),SUM(僇乕僪12彫敪攧悢),SUM(僇乕僪13彫敪攧悢),SUM(僇乕僪14彫敪攧悢),SUM(僇乕僪15彫敪攧悢),SUM(僇乕僪16彫敪攧悢),SUM(僇乕僪敪攧悢寁),SUM(僇乕僪敪攧嬥妟寁),SUM(僇乕僪嵞敪峴帺幮敪峴枃悢),SUM(僇乕僪嵞敪峴帺幮敪峴嬥妟),SUM(僇乕僪嵞敪峴懠幮敪峴枃悢),SUM(僇乕僪嵞敪峴懠幮敪峴嬥妟) FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s GROUP BY 僇乕僪6戝扨,僇乕僪7戝扨,僇乕僪8戝扨,僇乕僪9戝扨,僇乕僪10戝扨,僇乕僪11戝扨,僇乕僪12戝扨,僇乕僪13戝扨,僇乕僪14戝扨,僇乕僪15戝扨,僇乕僪16戝扨,僇乕僪1彫扨,僇乕僪2彫扨,僇乕僪3彫扨,僇乕僪4彫扨,僇乕僪5彫扨,僇乕僪6彫扨,僇乕僪7彫扨,僇乕僪8彫扨,僇乕僪9彫扨,僇乕僪10彫扨,僇乕僪11彫扨,僇乕僪12彫扨,僇乕僪13彫扨,僇乕僪14彫扨,僇乕僪15彫扨,僇乕僪16彫扨",