データ取得エラーです。
SELECT `inside_id`, `p_date_yyyy`, `p_date_mm`, `p_date_dd`, `title`, `file_file_name` FROM `news_data`
WHERE `sc_code` = '1'
AND (kubun <> 1) AND (timer_flag = 0 OR (
cast(concat(timer_s_yyyy,lpad(timer_s_mm, 2, '0'), lpad(timer_s_dd, 2, '0'), lpad(timer_s_hour, 2, '0'), lpad(timer_s_min, 2, '0')) as SIGNED)
< DATE_FORMAT(NOW(), '%Y%m%d%H%i') AND
cast(concat(timer_e_yyyy,lpad(timer_e_mm, 2, '0'), lpad(timer_e_dd, 2, '0'), lpad(timer_e_hour, 2, '0'), lpad(timer_e_min, 2, '0')) as SIGNED)
> DATE_FORMAT(NOW(), '%Y%m%d%H%i')
))
ORDER BY `add_date` DESC
データ取得エラーです。
SELECT `inside_id`, `p_date_yyyy`, `p_date_mm`, `p_date_dd`, `title`, `file_file_name`, `contents`, `link` FROM `news_data`
WHERE `sc_code` = '1'
AND kubun = 1 AND (
cast(concat(timer_s_yyyy,lpad(timer_s_mm, 2, '0'), lpad(timer_s_dd, 2, '0'), lpad(timer_s_hour, 2, '0'), lpad(timer_s_min, 2, '0')) as SIGNED)
< DATE_FORMAT(NOW(), '%Y%m%d%H%i') AND
cast(concat(timer_e_yyyy,lpad(timer_e_mm, 2, '0'), lpad(timer_e_dd, 2, '0'), lpad(timer_e_hour, 2, '0'), lpad(timer_e_min, 2, '0')) as SIGNED)
> DATE_FORMAT(NOW(), '%Y%m%d%H%i')
)
ORDER BY `up_date` DESC limit 1
データ取得エラーです。
SELECT `inside_id`, `p_date_yyyy`, `p_date_mm`, `p_date_dd`, `title`, `home_view_flag`, `event_info_id`, `pdf_file_name`, `file_file_name` FROM `event_data`
WHERE `sc_code` = '1'
AND (timer_flag = 0 OR (
cast(concat(timer_s_yyyy,lpad(timer_s_mm, 2, '0'), lpad(timer_s_dd, 2, '0'), lpad(timer_s_hour, 2, '0'), lpad(timer_s_min, 2, '0')) as SIGNED)
< DATE_FORMAT(NOW(), '%Y%m%d%H%i') AND
cast(concat(timer_e_yyyy,lpad(timer_e_mm, 2, '0'), lpad(timer_e_dd, 2, '0'), lpad(timer_e_hour, 2, '0'), lpad(timer_e_min, 2, '0')) as SIGNED)
> DATE_FORMAT(NOW(), '%Y%m%d%H%i')
))
AND `home_view_flag` = 1
ORDER BY `add_date` DESC
日本ガイシ スポーツプラザ [HOME]
