📄 searchforchar.c
字号:
2010,"SELECT DISTINCT NM_SYUNYU_NO FROM T602_NITIKANRI WHERE DT_SYUNYU IS NOT NULL AND DT_SYUNYU = TO_DATE('%s','YYYYMMDD') AND CH_STATION_CD = '%s'",
1146,"SELECT 墂柤,SUM(搶奀擖捠嬑掕婜),SUM(搶奀擖捠妛掕婜),SUM(搶奀擖掕婜寁),SUM(搶奀擖晛捠寯),SUM(搶奀擖夞悢寯),SUM(搶奀擖偦偺懠),SUM(搶奀擖僇乕僪),SUM(搶奀擖掕婜奜寁),SUM(搶奀弌捠嬑掕婜),SUM(搶奀弌捠妛掕婜),SUM(搶奀弌掕婜寁),SUM(搶奀弌晛捠寯),SUM(搶奀弌夞悢寯),SUM(搶奀弌偦偺懠),SUM(搶奀弌僇乕僪),SUM(搶奀弌掕婜奜寁),SUM(斞嶳擖捠嬑掕婜),SUM(斞嶳擖捠妛掕婜),SUM(斞嶳擖掕婜寁),SUM(斞嶳擖晛捠寯),SUM(斞嶳擖夞悢寯),SUM(斞嶳擖偦偺懠),SUM(斞嶳擖僇乕僪),SUM(斞嶳擖掕婜奜寁),SUM(斞嶳弌捠嬑掕婜),SUM(斞嶳弌捠妛掕婜),SUM(斞嶳弌掕婜寁),SUM(斞嶳弌晛捠寯),SUM(斞嶳弌夞悢寯),SUM(斞嶳弌偦偺懠),SUM(斞嶳弌僇乕僪),SUM(斞嶳弌掕婜奜寁),SUM(杒廗巙擖捠嬑掕婜),SUM(杒廗巙擖捠妛掕婜),SUM(杒廗巙擖掕婜寁),SUM(杒廗巙擖晛捠寯),SUM(杒廗巙擖夞悢寯),SUM(杒廗巙擖偦偺懠),SUM(杒廗巙擖僇乕僪),SUM(杒廗巙擖掕婜奜寁),SUM(杒廗巙弌捠嬑掕婜),SUM(杒廗巙弌捠妛掕婜),SUM(杒廗巙弌掕婜寁),SUM(杒廗巙弌晛捠寯),SUM(杒廗巙弌夞悢寯),SUM(杒廗巙弌偦偺懠),SUM(杒廗巙弌僇乕僪),SUM(杒廗巙弌掕婜奜寁),SUM(慏嫶擖捠嬑掕婜),SUM(慏嫶擖捠妛掕婜),SUM(慏嫶擖掕婜寁),SUM(慏嫶擖晛捠寯),SUM(慏嫶擖夞悢寯),SUM(慏嫶擖偦偺懠),SUM(慏嫶擖僇乕僪),SUM(慏嫶擖掕婜奜寁),SUM(慏嫶弌捠嬑掕婜),SUM(慏嫶弌捠妛掕婜),SUM(慏嫶弌掕婜寁),SUM(慏嫶弌晛捠寯),SUM(慏嫶弌夞悢寯),SUM(慏嫶弌偦偺懠),SUM(慏嫶弌僇乕僪),SUM(慏嫶弌掕婜奜寁),SUM(椢偑媢擖捠嬑掕婜),SUM(椢偑媢擖捠妛掕婜),SUM(椢偑媢擖掕婜寁) FROM AUTOGATE_STAFFEKI_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' AND 墂柤 = '%s' GROUP BY 墂柤",
1101,"SELECT NM_CLOSE_NO FROM T601_SIMEKANRI WHERE DT_CLOSE LIKE TO_DATE('%s','YYYYMMDD') AND CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s",
1131,"SELECT 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(夞悢寯敪攧嬥妟寁),拫媥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戝敪攧悢),拫媥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(拫媥敪攧嬥妟寁),僇乕僪1戝扨,僇乕僪2戝扨,僇乕僪3戝扨,僇乕僪4戝扨,僇乕僪5戝扨 FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s GROUP BY 夞悢寯1彫扨,夞悢寯2彫扨,夞悢寯3彫扨,夞悢寯4彫扨,夞悢寯5彫扨,夞悢寯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戝扨,拫媥1彫扨,拫媥2彫扨,拫媥3彫扨,拫媥4彫扨,拫媥5彫扨,拫媥6彫扨,拫媥7彫扨,拫媥8彫扨,拫媥9彫扨,拫媥10彫扨,拫媥11彫扨,拫媥12彫扨,拫媥13彫扨,拫媥14彫扨,拫媥15彫扨,拫媥16彫扨,僇乕僪1戝扨,僇乕僪2戝扨,僇乕僪3戝扨,僇乕僪4戝扨,僇乕僪5戝扨",
1125,"SELECT 掲愗擔帪,搶梩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(搶梩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(搶梩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彫暐栠) FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s GROUP BY 掲愗擔帪,搶梩1戝扨,搶梩2戝扨,搶梩3戝扨,搶梩4戝扨,搶梩5戝扨,搶梩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彫扨",
1126,"SELECT SUM(搶梩敪攧悢寁),SUM(搶梩敪攧嬥妟寁),SUM(搶梩暐栠枃悢寁),SUM(搶梩暐栠嬥妟寁),儊僩儘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(儊僩儘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(儊僩儘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彫暐栠) FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s GROUP BY 儊僩儘1戝扨,儊僩儘2戝扨,儊僩儘3戝扨,儊僩儘4戝扨,儊僩儘5戝扨,儊僩儘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彫扨",
1002,"SELECT NM_NOWVER_NO FROM M016_FAREVARMNG WHERE CH_STATION_CD = '%s' AND NM_UMACHINE_CD = %s AND NM_DEVTYPE_DV = %s",
721,"UPDATE T121_DAILY_DATA 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",
722,"UPDATE T401_HAND_WINDOW SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND DT_CLOSE IS NULL",
723,"UPDATE T402_SCRAP_TICK SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND DT_CLOSE IS NULL",
730,"SELECT COUNT( B.CH_STATION_CD ) FROM T601_SIMEKANRI A, T401_HAND_WINDOW B WHERE A.CH_STATION_CD = '%s' AND A.DT_SYUNYU IS NULL AND B.CH_STATION_CD = A.CH_STATION_CD AND TO_CHAR( B.DT_CLOSE, 'YYYYMMDD') = TO_CHAR( A.DT_CLOSE, 'YYYYMMDD') AND B.NM_CLOSE_NO = A.NM_CLOSE_NO",
731,"SELECT COUNT(*) FROM T401_HAND_WINDOW WHERE CH_STATION_CD = '%s' AND DT_CLOSE IS NULL",
732,"SELECT COUNT(*) FROM T402_SCRAP_TICK WHERE CH_STATION_CD = '%s' AND DT_CLOSE IS NULL AND(NM_SRPTICKALL_CNT >= 1 OR NM_SRPTICKALL_MON >= 1)",
733,"SELECT COUNT(*) FROM T403_HAND_CASH WHERE CH_STATION_CD = '%s' AND DT_SYUNYU IS NULL",
734,"UPDATE T401_HAND_WINDOW SET DT_CLOSE = TO_DATE('%s'), NM_CLOSE_NO = %s, NM_CLOSETICK_DV = 1, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND DT_CLOSE IS NULL",
735,"SELECT MAX(NM_SYUNYU_NO) FROM T602_NITIKANRI WHERE CH_STATION_CD = '%s' AND TO_CHAR( DT_SYUNYU, 'YYYYMMDD') = '%s'",
736,"UPDATE T601_SIMEKANRI SET DT_SYUNYU = TO_DATE('%s'), NM_SYUNYU_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND DT_SYUNYU IS NULL",
737,"UPDATE T403_HAND_CASH SET DT_SYUNYU = TO_DATE('%s'), NM_SYUNYU_NO = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND DT_SYUNYU IS NULL",
9007,"UPDATE T606_KIKIKANRI SET %s = %s where CH_STATION_CD='%s' AND NM_MACHINE_CD = %s AND NM_CORNER_NO = %s AND NM_GOUKI_NO = %s",
9008,"SELECT %s from T606_KIKIKANRI WHERE CH_STATION_CD = '%s' AND NM_MACHINE_CD = %s AND NM_CORNER_NO = %s AND NM_GOUKI_NO = %s",
1129,"SELECT 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(怴嫗惉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(怴嫗惉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(怴嫗惉暐栠嬥妟寁),嫗惉1戝扨,嫗惉2戝扨,嫗惉3戝扨,嫗惉4戝扨,嫗惉5戝扨,嫗惉6戝扨,嫗惉7戝扨,嫗惉8戝扨,嫗惉9戝扨,嫗惉10戝扨,嫗惉11戝扨,嫗惉12戝扨,嫗惉13戝扨,嫗惉14戝扨,嫗惉15戝扨,嫗惉16戝扨 FROM TICKETMACHINE_DAILY_REPORT_V WHERE 掲愗擔 = '%s' AND 墂柤 = '%s' AND 掲愗斣崋 = %s AND 崋婡斣崋 = %s GROUP BY 怴嫗惉1彫扨,怴嫗惉2彫扨,怴嫗惉3彫扨,怴嫗惉4彫扨,怴嫗惉5彫扨,怴嫗惉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戝扨",
601,"SELECT COUNT(*) FROM %s WHERE CH_STATION_CD = '%s' AND NM_CORNER_NO = %s AND NM_MACHINE_CD = %s AND NM_GOUKI_NO = %s AND TO_CHAR( DT_DATE, 'YYYYMMDDHH24MISS') = '%s'",
621,"SELECT MAX(NM_INS_NO) FROM T401_HAND_WINDOW WHERE CH_STATION_CD = '%s' AND TO_CHAR( DT_INS, 'YYYYMMDD') = '%s'",
622,"SELECT NM_UPD_CNT FROM T401_HAND_WINDOW WHERE CH_STATION_CD = '%s' AND TO_CHAR( DT_INS, 'YYYYMMDD') = '%s' AND NM_INS_NO = %s",
632,"DELETE FROM T821_DAILY_DATA_PR WHERE CH_STATION_CD = '%s'",
633,"UPDATE T301_MONIT_AUTO SET NM_MBDERRSTP_CNT=0,NM_MBDERRSND_CNT=0,NM_MBDERROTH_CNT=0,NM_CINTRW010_CNT=0,NM_CINTRW050_CNT=0,NM_CINTRW100_CNT=0,NM_CINTRW500_CNT=0,NM_CINRJCT_CNT=0,NM_CINSTOP_CNT=0,NM_CINERRMCA_CNT=0,NM_CINERRSNS_CNT=0,NM_CINERRCHG_CNT=0,NM_CINERROTH_CNT=0,NM_PMNTRW01000_CNT=0,NM_PMNTRW05000_CNT=0,NM_PMNTRW10000_CNT=0,NM_PMNRJCT_CNT=0,NM_PMNSTOP_CNT=0,NM_PMNERRMCA_CNT=0,NM_PMNERRSNS_CNT=0,NM_PMNERRCHG_CNT=0,NM_PMNERROTH_CNT=0,NM_PRTPUB_CNT=0,NM_PRTSTP_CNT=0,NM_PRTERRMCA_CNT=0,NM_PRTERRSNS_CNT=0,NM_PRTERRECD_CNT=0,NM_PRTERRRFD_CNT=0,NM_PRTERROTH_CNT=0,NM_CRDINSERT_CNT=0,NM_CRDPBLCTN_CNT=0,NM_CRDSTP1_CNT=0,NM_CRDSTP2_CNT=0,NM_CRDERRMCA_CNT=0,NM_CRDERRSNS_CNT=0,NM_CRDERRRED_CNT=0,NM_CRDERRECD_CNT=0,NM_CRDERRPRT_CNT=0,NM_CRDPNC_CNT=0,NM_CRDERRPNC_CNT=0,NM_CRDERROTH_CNT=0,NM_TTKSTP_CNT=0,NM_TTKERRMCA_CNT=0,NM_TTKERRSNS_CNT=0,NM_TTKERRECD_CNT=0,NM_TTKERRPNC_CNT=0,NM_TTKERRPRT_CNT=0,NM_TTKERROTH_CNT=0,DT_INDATE=SYSDATE,DT_UPDATE=SYSDATE WHERE CH_STATION_CD = '%s'",
1000,"UPDATE M016_FAREVARMNG SET NM_NOWVER_NO = NM_NEWVER_NO, DT_NOWKIRIKAE = DT_NEWKIRIKAE, DT_UPDATE = SYSDATE WHERE NM_NEWVER_NO > 0 AND TO_CHAR( DT_NEWKIRIKAE, 'YYYYMMDD') <= '%s'",
1164,"SELECT 嫗惉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(嫗惉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(嫗惉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(嫗惉暐栠嬥妟寁) FROM TICKET_TEST_REPORT_V WHERE 墂柤 = '%s' AND 崋婡斣崋 = %s GROUP BY 嫗惉1戝扨,嫗惉2戝扨,嫗惉3戝扨,嫗惉4戝扨,嫗惉5戝扨,嫗惉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彫扨",
1165,"SELECT 夞悢寯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戝敪攧悢),夞悢寯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(夞悢寯敪攧嬥妟寁) FROM TICKET_TEST_REPORT_V WHERE 墂柤 = '%s' AND 崋婡斣崋 = %s GROUP BY 夞悢寯1戝扨,夞悢寯2戝扨,夞悢寯3戝扨,夞悢寯4戝扨,夞悢寯5戝扨,夞悢寯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彫扨",
1121,"SELECT 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(廤嶥懁婡娭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嬥妟) FROM GATEMACHINE_SEASON_REPORT_V WHERE 掲愗擔 BETWEEN '%s' AND '%s' AND 墂柤 = '%s'",
1123,"SELECT SUM(捠夁價僢僩僋儕傾審悢),SUM(僄儞僐乕僪儈僗審悢),SUM(擖弌応彂姺審悢),SUM(楢懕價僢僩彂姺審悢),SUM(晄惓僋儕傾僇乕僪審悢),SUM(晄惓僋儕傾掕婜寯審悢),SUM(搶梩惛嶼枃悢),SUM(搶梩惛嶼嬥妟),SUM(儊僩儘惪媮枃悢),SUM(儊僩儘惪媮嬥妟),SUM(儊僩儘巟暐枃悢),SUM(儊僩儘巟暐嬥妟),SUM(JR惪媮枃悢),SUM(JR惪媮嬥妟),SUM(JR巟暐枃悢),SUM(JR巟暐嬥妟),SUM(怴嫗惉惪媮枃悢),SUM(怴嫗惉惪媮嬥妟),SUM(怴嫗惉巟暐枃悢),SUM(怴嫗惉巟暐嬥妟),SUM(嫗惉惪媮枃悢),SUM(嫗惉惪媮嬥妟),SUM(嫗惉巟暐枃悢),SUM(嫗惉巟暐嬥妟),SUM(搶嫗搒惪媮枃悢),SUM(搶嫗搒惪媮嬥妟),SUM(搶嫗搒巟暐枃悢),SUM(搶嫗搒巟暐嬥妟),SUM(搶媫惪媮枃悢),SUM(搶媫惪媮嬥妟),SUM(搶媫巟暐枃悢),SUM(搶媫巟暐嬥妟),SUM(惣晲惪媮枃悢),SUM(惣晲惪媮嬥妟),SUM(惣晲巟暐枃悢),SUM(惣晲巟暐嬥妟),SUM(搶晲惪媮枃悢),SUM(搶晲惪媮嬥妟),SUM(搶晲巟暐枃悢),SUM(搶晲巟暐嬥妟),SUM(彫揷媫惪媮枃悢),SUM(彫揷媫惪媮嬥妟),SUM(彫揷媫巟暐枃悢),SUM(彫揷媫巟暐嬥妟),SUM(嫗墹惪媮枃悢),SUM(嫗墹惪媮嬥妟),SUM(嫗墹巟暐枃悢),SUM(嫗墹巟暐嬥妟),SUM(憡揝惪媮枃悢),SUM(憡揝惪媮嬥妟),SUM(憡揝巟暐枃悢),SUM(憡揝巟暐嬥妟),SUM(嫗媫惪媮枃悢),SUM(嫗媫惪媮嬥妟),SUM(嫗媫巟暐枃悢),SUM(嫗媫巟暐嬥妟),SUM(杒憤惪媮枃悢),SUM(杒憤惪媮嬥妟),SUM(杒憤巟暐枃悢),SUM(杒憤巟暐嬥妟),SUM(嶉嬍崅懍惪媮枃悢),SUM(嶉嬍崅懍惪媮嬥妟),SUM(嶉嬍崅懍巟暐枃悢),SUM(嶉嬍崅懍巟暐嬥妟),SUM(墶昹崅懍惪媮枃悢),SUM(墶昹崅懍惪媮嬥妟),SUM(墶昹崅懍巟暐枃悢),SUM(墶昹崅懍巟暐嬥妟),SUM(敔崻搊嶳惪媮枃悢),SUM(敔崻搊嶳惪媮嬥妟),SUM(敔崻搊嶳巟暐枃悢),SUM(敔崻搊嶳巟暐嬥妟),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(寁嬥妟) FROM CARDMACHINE_SEASON_REPORT_V WHERE 掲愗擔 BETWEEN '%s' AND '%s' AND 墂柤 = '%s'",
801,"UPDATE T603_JUNKANRI SET NM_MO_DV = %s, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND DT_JUNKEI1 = TO_DATE('%s','YYYYMMDDHH24MISS')",
1152,"SELECT MAX(僋儕傾擔帪),MAX(廂廤擔晅),崋婡悢 FROM TICKET_OPERATION_REPORT_V WHERE 墂柤 = '%s' GROUP BY 崋婡悢",
1003,"UPDATE M016_FAREVARMNG SET NM_NEWVER_NO = %s, DT_NEWKIRIKAE = TO_DATE('%s'), DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_UMACHINE_CD = %s AND NM_DEVTYPE_DV = %s",
627,"DELETE FROM T403_HAND_CASH WHERE CH_STATION_CD = '%s' AND NM_KANRI_NO = %s",
1004,"UPDATE M016_FAREVARMNG SET NM_NOWVER_NO = NM_NEWVER_NO, DT_NOWKIRIKAE = DT_NEWKIRIKAE, DT_UPDATE = SYSDATE WHERE CH_STATION_CD = '%s' AND NM_UMACHINE_CD = %s",
9000,"SELECT NM_MST_DV,NM_NOWVER_NO FROM M011_MSTVERMNG WHERE NM_MST_DV = %s OR NM_MST_DV = %s OR NM_MST_DV = %s OR NM_MST_DV = %s ORDER BY NM_MST_DV",
1120,"SELECT SUM(僇乕僪棙梡審悢),SUM(僇乕僪棙梡嬥妟),SUM(夵嶥懁審悢),SUM(夵嶥懁嬥妟),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(怴嫗惉惪媮枃悢),SUM(怴嫗惉惪媮嬥妟),SUM(怴嫗惉巟暐枃悢),SUM(怴嫗惉巟暐嬥妟),SUM(嫗惉惪媮枃悢),SUM(嫗惉惪媮嬥妟),SUM(嫗惉巟暐枃悢),SUM(嫗惉巟暐嬥妟),SUM(搶嫗搒惪媮枃悢),SUM(搶嫗搒惪媮嬥妟),SUM(搶嫗搒巟暐枃悢),SUM(搶嫗搒巟暐嬥妟),SUM(搶媫惪媮枃悢),SUM(搶媫惪媮嬥妟),SUM(搶媫巟暐枃悢),SUM(搶媫巟暐嬥妟),SUM(惣晲惪媮枃悢),SUM(惣晲惪媮嬥妟),SUM(惣晲巟暐枃悢),SUM(惣晲巟暐嬥妟),SUM(搶晲惪媮枃悢),SUM(搶晲惪媮嬥妟),SUM(搶晲巟暐枃悢),SUM(搶晲巟暐嬥妟),SUM(彫揷媫惪媮枃悢),SUM(彫揷媫惪媮嬥妟),SUM(彫揷媫巟暐枃悢),SUM(彫揷媫巟暐嬥妟),SUM(嫗墹惪媮枃悢),SUM(嫗墹惪媮嬥妟),SUM(嫗墹巟暐枃悢),SUM(嫗墹巟暐嬥妟),SUM(憡揝惪媮枃悢),SUM(憡揝惪媮嬥妟),SUM(憡揝巟暐枃悢),SUM(憡揝巟暐嬥妟),SUM(嫗媫惪媮枃悢),SUM(嫗媫惪媮嬥妟),SUM(嫗媫巟暐枃悢),SUM(嫗媫巟暐嬥妟),SUM(杒憤惪媮枃悢),SUM(杒憤惪媮嬥妟),SUM(杒憤巟暐枃悢),SUM(杒憤巟暐嬥妟),SUM(嶉嬍崅懍惪媮枃悢),SUM(嶉嬍崅懍惪媮嬥妟),SUM(嶉嬍崅懍巟暐枃悢),SUM(嶉嬍崅懍巟暐嬥妟),SUM(墶昹崅懍惪媮枃悢),SUM(墶昹崅懍惪媮嬥妟),SUM(墶昹崅懍巟暐枃悢),SUM(墶昹崅懍巟暐嬥妟),SUM(敔崻搊嶳惪媮枃悢),SUM(敔崻搊嶳惪媮嬥妟),SUM(敔崻搊嶳巟暐枃悢),SUM(敔崻搊嶳巟暐嬥妟),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枃悢) FROM GATEMACHINE_SEASON_REPORT_V WHERE 掲愗擔 BETWEEN '%s' AND '%s' AND 墂柤 = '%s'",
1147,"SELECT SUM(椢偑媢擖晛捠寯),SUM(椢偑媢擖夞悢寯),SUM(椢偑媢擖偦偺懠),SUM(椢偑媢擖僇乕僪),SUM(椢偑媢擖掕婜奜寁),SUM(椢偑媢弌捠嬑掕婜),SUM(椢偑媢弌捠妛掕婜),SUM(椢偑媢弌掕婜寁),SUM(椢偑媢弌晛捠寯),SUM(椢偑媢弌夞悢寯),SUM(椢偑媢弌偦偺懠),SUM(椢偑媢弌僇乕僪),SUM(椢偑媢弌応掕婜奜寁),SUM(拞墰擖捠嬑掕婜),SUM(拞墰擖捠妛掕婜),SUM(拞墰擖掕婜寁),SUM(拞墰擖晛捠寯),SUM(拞墰擖夞悢寯),SUM(拞墰擖偦偺懠),SUM(拞墰擖僇乕僪),SUM(拞墰擖掕婜奜寁),SUM(拞墰弌捠嬑掕婜),SUM(拞墰弌捠妛掕婜),SUM(拞墰弌掕婜寁),SUM(拞墰弌晛捠寯),SUM(拞墰弌夞悢寯),SUM(拞墰弌偦偺懠),SUM(拞墰弌僇乕僪),SUM(拞墰弌掕婜奜寁),SUM(懞忋擖捠嬑掕婜),SUM(懞忋擖捠妛掕婜),SUM(懞忋擖掕婜寁),SUM(懞忋擖晛捠寯),SUM(懞忋擖夞悢寯),SUM(懞忋擖偦偺懠),SUM(懞忋擖僇乕僪),SUM(懞忋擖掕婜奜寁),SUM(懞忋弌捠嬑掕婜),SUM(懞忋弌捠妛掕婜),SUM(懞忋弌掕婜寁),SUM(懞忋弌晛捠寯),SUM(懞忋弌夞悢寯),SUM(懞忋弌偦偺懠),SUM(懞忋弌僇乕僪),SUM(懞忋弌掕婜奜寁),SUM(搶梩擖捠嬑掕婜),SUM(搶梩擖捠妛掕婜),SUM(搶梩擖掕婜寁),SUM(搶梩擖晛捠寯),SUM(搶梩擖夞悢寯),SUM(搶梩擖偦偺懠),SUM(搶梩擖僇乕僪),SUM(搶梩擖掕婜奜寁),SUM(搶梩弌捠嬑掕婜),SUM(搶梩弌捠妛掕婜),SUM(搶梩弌掕婜寁),SUM(搶梩弌晛捠寯),SUM(搶梩弌夞悢寯),SUM(搶梩弌偦偺懠),SUM(搶梩弌僇乕僪),SUM(搶梩弌掕婜奜寁) FROM AUTOGATE_STAFFEKI_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' AND 墂柤 = '%s'",
1148,"SELECT 奐巒帪崗,SUM(搶奀恄),SUM(斞嶳枮),SUM(杒廗巙栰),SUM(慏嫶擔戝慜),SUM(敧愮戙椢偑媢),SUM(敧愮戙拞墰),SUM(懞忋),SUM(搶梩彑揷戜) FROM EKISITUATION_TEIKI_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' AND 奐巒帪崗 BETWEEN '%s' and '%s' AND 墂柤 = '%s' AND 僐乕僫 = %s GROUP BY 奐巒帪崗",
1149,"SELECT 奐巒帪崗,SUM(搶奀恄),SUM(斞嶳枮),SUM(杒廗巙栰),SUM(慏嫶擔戝慜),SUM(敧愮戙椢偑媢),SUM(敧愮戙拞墰),SUM(懞忋),SUM(搶梩彑揷戜) FROM EKISITUATION_NOTTEIKI_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' AND 奐巒帪崗 BETWEEN '%s' and '%s' AND 墂柤 = '%s' AND 僐乕僫 = %s GROUP BY 奐巒帪崗",
1150,"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_TEIKI_REPORT_V WHERE 奐巒擔 BETWEEN '%s' AND '%s' GROUP BY 墂柤",
2001,"SELECT SUM(婡娭15戝恖枃悢),SUM(婡娭15戝恖嬥妟),SUM(婡娭15彫帣枃悢),SUM(婡娭15彫帣嬥妟),SUM(婡娭15戝恖妱堷枃悢),SUM(婡娭15戝恖妱堷嬥妟),SUM(婡娭15彫帣妱堷枃悢),SUM(婡娭15彫帣妱堷嬥妟),SUM(婡娭16戝恖枃悢),SUM(婡娭16戝恖嬥妟),SUM(婡娭16彫帣枃悢),SUM(婡娭16彫帣嬥妟),SUM(婡娭16戝恖妱堷枃悢),SUM(婡娭16戝恖妱堷嬥妟),SUM(婡娭16彫帣妱堷枃悢),SUM(婡娭16彫帣妱堷嬥妟),SUM(婡娭17戝恖枃悢),SUM(婡娭17戝恖嬥妟),SUM(婡娭17彫帣枃悢),SUM(婡娭17彫帣嬥妟),SUM(婡娭17戝恖妱堷枃悢),SUM(婡娭17戝恖妱堷嬥妟),SUM(婡娭17彫帣妱堷枃悢),SUM(婡娭17彫帣妱堷嬥妟),SUM(婡娭18戝恖枃悢),SUM(婡娭18戝恖嬥妟),SUM(婡娭18彫帣枃悢),SUM(婡娭18彫帣嬥妟),SUM(婡娭18戝恖妱堷枃悢),SUM(婡娭18戝恖妱堷嬥妟),SUM(婡娭18彫帣妱堷枃悢),SUM(婡娭18彫帣妱堷嬥妟),SUM(婡娭19戝恖枃悢),SUM(婡娭19戝恖嬥妟),SUM(婡娭19彫帣枃悢),SUM(婡娭19彫帣嬥妟),SUM(婡娭19戝恖妱堷枃悢),SUM(婡娭19戝恖妱堷嬥妟),SUM(婡娭19彫帣妱堷枃悢),SUM(婡娭19彫帣妱堷嬥妟),SUM(婡娭20戝恖枃悢),SUM(婡娭20戝恖嬥妟),SUM(婡娭20彫帣枃悢),SUM(婡娭20彫帣嬥妟),SUM(婡娭20戝恖妱堷枃悢),SUM(婡娭20戝恖妱堷嬥妟),SUM(婡娭20彫帣妱堷枃悢),SUM(婡娭20彫帣妱堷嬥妟),SUM(婡娭21戝恖枃悢),SUM(婡娭21戝恖嬥妟),SUM(婡娭21彫帣枃悢),SUM(婡娭21彫帣嬥妟),SUM(婡娭21戝恖妱堷枃悢),SUM(婡娭21戝恖妱堷嬥妟),SUM(婡娭21彫帣妱堷枃悢),SUM(婡娭21彫帣妱堷嬥妟),SUM(婡娭22戝恖枃悢),SUM(婡娭22戝恖嬥妟),SUM(婡娭22彫帣枃悢),SUM(婡娭22彫帣嬥妟),SUM(婡娭22戝恖妱堷枃悢),SUM(婡娭22戝恖妱堷嬥妟),SUM(婡娭22彫帣妱堷枃悢),SUM(婡娭22彫帣⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -