<?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;