= CURDATE()
AND NEWS2.FLG_DISPLAY = 1
AND NEWS2.FLG_DELETE = 0
ORDER BY NEWS2.DATE_LAST_MODIFIED DESC
LIMIT 0, 1
) NEWS_ID
FROM (SELECT NEWS1.STORE_ID
FROM TR_NEWS NEWS1
WHERE NEWS1.DATE_ENDPOSTING >= CURDATE()
AND NEWS1.FLG_DISPLAY = 1
AND NEWS1.FLG_DELETE = 0
GROUP BY NEWS1.STORE_ID
) NEWS1
) BASE
WHERE NEWS.NEWS_ID = BASE.NEWS_ID
AND STORE.STORE_ID = BASE.STORE_ID
AND CATEGORY.CATEGORY_ID = STORE.CATEGORY_ID
AND USER.STORE_ID = BASE.STORE_ID
AND USER.FLG_DELETE = 0
) T
ORDER BY DATE_LAST_MODIFIED DESC
LIMIT 0, $NEWS_CNT
");
//SQLチェック
$sql_check = False;
if($db_news <> False){
if(0 < mysql_num_rows($db_news)){
$sql_check = True;
}
}
?>
ショッピングセンター ニットーモール｜NITTOH MALLスマートフォン版はこちら
