www.smarthjh.com 서버의 MySQL 에러 리포트 입니다.
◈ 서버IP 182.162.137.139
◈ 경로 http://www.smarthjh.com/prod/pass_view.php
◈ 메세지 query Error
[ 1064 ] 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.sal_cd = b.sal_cd AND b.del_yn = 'N' AND b.prod_cd = c.pass_cd' at line 10
◈ Query SELECT
a.sal_cd, a.sal_nm, a.sal_amt, a.state, a.grp_seq, a.sal_cate, a.sal_scate, a.basic_yn,
CASE WHEN IFNULL(a.sal_thum2,'') = '' THEN CONCAT('/pass/',c.pass_cd,'/',c.pass_thum) ELSE CONCAT('/good/',a.sal_cd,'/',a.sal_thum2) END sal_thum2,
c.pass_cd, c.tch_cd, c.std_days, c.state prod_state,
c.std_sdt, a.cost_price, a.etc_gb
FROM
GOODS a, GOODS_MAP b, PASS_INFO c
WHERE
a.sal_cd =
AND a.sal_cd = b.sal_cd AND b.del_yn = 'N'
AND b.prod_cd = c.pass_cd
◈ 시간 2018-02-25 16:58:34