codepad
[
create a new paste
]
login
|
about
Language:
C
C++
D
Haskell
Lua
OCaml
PHP
Perl
Plain Text
Python
Ruby
Scheme
Tcl
<?php $days7ago = date("Ymd",strtotime("-7 day")); $query = ""; $query .= "SELECT NU.*, MU.* "; $query .= "FROM T_NTT_UPD NU, M_USERS MU "; $query .= "WHERE "; $query .= "NU.CONSTRUCTION_SCHEDULE_DATE IS NOT NULL "; $query .= "AND NU.CONSTRUCTION_SCHEDULE_DATE != '0000-00-00' "; //--->20191010 Speedia Aoki Upd S コンテンツ代理店展開対応 // $query .= "AND NU.CONSTRUCTION_SCHEDULE_DATE <= CAST('".$days7ago."' AS DATE ) "; $query .= "AND ( "; $query .= " (NU.CONSTRUCTION_SCHEDULE_DATE <= CAST('".$days7ago."' AS DATE ) AND MU.ISP_CODE NOT BETWEEN '6500' AND '6699') "; $query .= " OR "; $query .= " (NU.CONSTRUCTION_SCHEDULE_DATE <= CAST(NOW() AS DATE ) AND MU.ISP_CODE BETWEEN '6500' AND '6699') "; $query .= ") "; //<---20191010 Speedia Aoki Upd E $query .= "AND NU.CSV_FLAG = '1' "; //--->2018-01-17 Ito Add $query .= "AND NU.CSV_OUTPUT_DATE = '0000-00-00 00:00:00' "; $query .= "AND NU.SNET_USER_CODE = MU.SNET_USER_CODE "; $query .= "AND NU.DELETE_FLG = '0' "; echo $query;
Private
[
?
]
Run code
Submit