Query : SELECT pm.pm_uid AS pm_uid , pm.pm_sldk1 AS pm_sldk1, pm.pm_sldk2 AS pm_sldk2, pm.pm_sldk3 AS pm_sldk3, pm.pm_sldk4 AS pm_sldk4, pm.pm_sldk5 AS pm_sldk5, pm.pm_sldk6 AS pm_sldk6, pm.pm_sldk7 AS pm_sldk7, pm.pm_sldk8 AS pm_sldk8, pm.pm_sldk9 AS pm_sldk9, pm.pm_sldk10 AS pm_sldk10, pm.pm_sldk11 AS pm_sldk11, pm.pm_sldk12 AS pm_sldk12, pm.pm_sldk13 AS pm_sldk13, pm.pm_sldk14 AS pm_sldk14 , pm.pm_category AS pm_category , pm.pm_key AS pm_key , pm.pm_mkey AS pm_mkey , pm.pm_unit AS pm_unit /* 단위 */ , pm.pm_spec AS pm_spec /* 규격 */ , pm.pm_origin AS pm_origin /* 브랜드 */ , pm.pm_soldout AS pm_soldout /* 장기결품 */ , pm.pm_notuse AS pm_notuse /* 단종 */ , pm.pm_nodc AS pm_nodc /* 할인제외 */ , pm.pm_pointsw AS pm_pointsw /* 적립제외 */ , pm.pm_uqty AS pm_uqty , pm.pm_pmgroup2 , pm.pm_b2capproval AS pm_b2capproval , pm.pm_price AS pm_price , pm.pm_ordermin AS pm_ordermin , pm.pm_orderlimit AS pm_orderlimit , IF(pm.pm_jegogubn='1' AND ipgo.cm_key IS NOT NULL, ipgo.cm_key, 0) AS ipgo_key , spm.* , spm.spm_name AS goods_name , pm.pm_barcode AS goods_barcode , pm.pm_uid as goods_code , pm.pm_taxrate AS pm_taxrate , pm.pm_ipdkr AS pm_ipdkr , IF(pm.pm_regdt>=DATE_ADD(NOW(), INTERVAL -3 MONTH), 1, 0) AS newchk , IF( el.el_sqno AND el.el_sldk1>0 , el.el_sldk1 , IF (pm.pm_sldk3>0, pm.pm_sldk3, pm.pm_sldk1) ) AS goods_sale_price , pm.pm_sldk1 AS goods_nomem_sale_price , pm.pm_price AS goods_market_price , (100-((IF( el.el_sqno AND el.el_sldk1>0 , el.el_sldk1 , IF (pm.pm_sldk3>0, pm.pm_sldk3, pm.pm_sldk1) )/pm.pm_price)*100)) AS goods_dc , ROUND(spm.spm_add_delivery) AS goods_add_delivery , category.category_name AS category_name , category.category_fullname AS category_fullname , cp.cp_name AS cp_name , scp.scp_name AS scp_name , el.el_sqno AS el_sqno , em2.em_eventgubn AS em_eventgubn , em2.em_gubn AS em_gubn , em2.em_name AS em_name , em2.em_sdate AS em_sdate , em2.em_edate AS em_edate , el.el_sqno AS event_uid , el.el_giftpmuid AS event_pmuid , el.el_giftqty1 AS el_giftqty1 , el.el_giftqty2 AS el_giftqty2 , el_spm.spm_name AS el_pmname , el_pm.pm_spec AS el_pmspec , el_pm.pm_unit AS el_pmunit , IFNULL((SELECT jg.jg_jego FROM jego AS jg WHERE jg.jg_mkey=pm.pm_mkey AND jg.jg_sid='1' LIMIT 1), 0) AS pm_jego , 'pm.pm_sldk1' AS pm_sldk , 'IF(pm.pm_sldk3>0, 'Y', 'N')' AS goods_sldk3_check , 0 AS goods_hits , IF(spm.spm_soldout='Y' OR IF(pm.pm_orderlimitdt='Y' AND pm.pm_orderlimitsdt<='2024-04-25' AND pm.pm_orderlimitedt>='2024-04-25', 'Y', 'N')='Y', 1, 0) AS goods_stock , IF(spm.spm_soldout='Y', 1, 0) AS goods_stock2 , IF(spm.spm_soldout='N' AND IF(pm.pm_orderlimitdt='Y' AND pm.pm_orderlimitsdt<='2024-04-25' AND pm.pm_orderlimitedt>='2024-04-25', 'Y', 'N')='N', 0, NOT EXISTS( SELECT 1 FROM pummok AS stdpm INNER JOIN shop_pummok AS stdspm ON (stdpm.pm_uid=stdspm.spm_pmuid AND stdpm.pm_delete='N' AND stdpm.pm_b2capproval='Y' AND stdspm.spm_soldout='N' AND IF(stdpm.pm_orderlimitdt='Y' AND stdpm.pm_orderlimitsdt<='2024-04-25' AND stdpm.pm_orderlimitedt>='2024-04-25', 'Y', 'N')='N') INNER JOIN shop_pummok_option AS stdspmo ON (stdpm.pm_uid=stdspmo.spmo_pmouid) WHERE stdspmo.spmo_pmuid=pm.pm_uid LIMIT 1 ) ) AS goods_std_stock , IF(pm.pm_orderlimitdt='Y' AND pm.pm_orderlimitsdt<='2024-04-25' AND pm.pm_orderlimitedt>='2024-04-25', 'Y', 'N') AS pm_orderlimitdtuse , pm.pm_orderlimitedt , pm.pm_barcode , scp.scp_use, cp.cp_key , 0 AS goods_point_use , (SELECT COUNT(spmr.spmr_uid) FROM shop_pummok_relation AS spmr WHERE spmr.spmr_pmuid=pm.pm_uid) AS relation_counter , (SELECT COUNT(spmo.spmo_uid) FROM shop_pummok_option AS spmo WHERE spmo.spmo_pmuid=pm.pm_uid) AS option_counter , IF((SELECT spmo.spmo_uid FROM shop_pummok_option AS spmo WHERE spmo.spmo_pmouid=pm.pm_uid LIMIT 1), 'Y', '') AS goods_option_use , pm.pm_uid AS pmuid_link , (SELECT COUNT(sbbs.sbbs_uid) FROM shop_board AS sbbs WHERE sbbs.sbbs_sbbscuid='3' AND sbbs.sbbs_delete='N' AND sbbs.sbbs_show='Y' AND sbbs.sbbs_pmuid IN ( SELECT pm.pm_uid UNION SELECT spmo_pmouid FROM shop_pummok_option WHERE spmo_pmuid=pm.pm_uid ) ) AS board_review_counter , (SELECT COUNT(sbbs.sbbs_uid) FROM shop_board AS sbbs WHERE sbbs.sbbs_sbbscuid='4' AND sbbs.sbbs_delete='N' AND sbbs.sbbs_show='Y' AND sbbs.sbbs_pmuid IN ( SELECT pm.pm_uid UNION SELECT spmo_pmouid FROM shop_pummok_option WHERE spmo_pmuid=pm.pm_uid ) ) AS board_qna_counter , IFNULL(st.st_deliver, 'N') AS st_deliver, IFNULL(st.st_delivery_free, 0) AS st_delivery_free, IFNULL(st.st_delivery_price, 0) AS st_delivery_price FROM pummok AS pm INNER JOIN shop_pummok AS spm ON (pm.pm_uid=spm.spm_pmuid) LEFT JOIN category AS category ON (pm.pm_category=category.category_id AND category_delete='N') LEFT JOIN company AS cp ON (cp.cp_key=pm.pm_jejo AND pm.pm_jejo>0) LEFT JOIN shop_company AS scp ON (cp.cp_key=scp.scp_cpkey) LEFT JOIN eventpummoklist AS el ON (el.el_pmuid=pm.pm_uid AND el.el_emsqno IN ( SELECT em.em_sqno FROM eventpummokmast AS em WHERE em.em_sid='1' AND em.em_start<='2024042513' AND em.em_end>='2024042513' AND em.em_gubn IN ('0', '2') )) LEFT JOIN eventpummokmast AS em2 ON (em2.em_sqno=el.el_emsqno) LEFT JOIN pummok AS el_pm ON (el.el_giftpmuid=el_pm.pm_uid) LEFT JOIN shop_pummok AS el_spm ON (el_pm.pm_uid=el_spm.spm_pmuid) LEFT JOIN customer AS ipgo ON (pm.pm_ipgo=ipgo.cm_key AND ipgo.cm_delete='N' AND ipgo.cm_type='1') LEFT JOIN scm_setting AS st ON (ipgo.cm_key=st.st_cmkey) WHERE pm.pm_delete='N' AND pm.pm_b2capproval='Y' AND pm.pm_uid NOT IN (SELECT spmo.spmo_pmouid FROM shop_pummok_option AS spmo) AND pm.pm_uid='419937' LIMIT 1
Mysql_Error : 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 '', 'N')' AS goods_sldk3_check , 0 AS goods_hits , IF(spm.spm_soldout='Y' O' at line 64
Mysql Error Num : 1064
Error!!