QUERY


SELECT et_seq, et_ec_seq, et_title, et_image1, et_area, et_chkpark, et_chkevent, et_order,
ed_seq, ed_ep_seq, ed_title,
ets_sdate, ets_edate,
etp_dprice, etp_sprice, etp_nprice,
ep_title
FROM en_tour A
LEFT OUTER JOIN en_division B ON A.et_seq = B.ed_et_seq
LEFT OUTER JOIN en_tour_season C ON A.et_seq = C.ets_et_seq
LEFT OUTER JOIN en_tour_price D ON B.ed_seq = D.etp_ed_seq AND C.ets_seq = D.etp_ets_seq
LEFT OUTER JOIN en_productkind E ON B.ed_ep_seq = E.ep_seq
WHERE A.et_seq = AND A.et_chkcoupon = 'Y' AND A.et_chkcoop = 'Y' AND ('2024-03-20' BETWEEN C.ets_sdate AND C.ets_edate)
ORDER BY B.ed_order

DEBUG BACK TRACE

show_debug /home2/uricupon.com/docs/lib/lib.dbexp.php(40 line)

fetchDatas /home2/uricupon.com/docs/coupon/cp_view.php(47 line)

Invalid query : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND A.et_chkcoupon = 'Y' AND A.et_chkcoop = 'Y' AND ('2024-03-20' BETWEEN C' at line 11