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='257973' 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!!