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
, IF(spm.spm_soldout='Y' AND (pm.pm_notuse='N' AND pm.pm_soldout='N' AND IF(pm.pm_orderlimitdt='Y' AND pm.pm_orderlimitsdt<='2024-06-02' AND pm.pm_orderlimitedt>='2024-06-02', 'Y', 'N')='N'), ZPRO_INGJEGO(pm.pm_mkey, spm.spm_soldout), 0) AS ingjego
, 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_b2capproval AS pm_b2capproval
, pm.pm_price AS pm_price
, pm.pm_bigo AS pm_bigo
, spm.*
, IF(spm.spm_name>'', spm.spm_name, pm.pm_name) AS goods_name
, spm.spm_filesrc AS spm_filesrc
, spm.spm_stname AS spm_stname
, spm.spm_stcolor AS spm_stcolor
, pm.pm_barcode AS goods_barcode
, pm.pm_bookcode as goods_code
, pm.pm_taxrate AS pm_taxrate
, pm.pm_ipdkr AS pm_ipdkr
, IF(
el.el_sqno AND el.el_sldk13>0
, el.el_sldk13
, pm.pm_sldk13
) AS goods_sale_price
, pm.pm_sldk13 AS goods_nomem_sale_price
, pm.pm_price AS goods_market_price
, (100-((IF(
el.el_sqno AND el.el_sldk13>0
, el.el_sldk13
, pm.pm_sldk13
)/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
, scp.scp_cpkey AS cp_key
, IF(scp.scp_name>'', scp.scp_name, cp.cp_name) AS scp_name
, el.el_sqno AS el_sqno
, el.el_sqno AS event_uid
, el.em_gubn AS em_eventgubn
, el.em_start AS em_start
, el.em_end AS em_end
, spmdaa.spmda_pmuid
, spmdaa.spmda_counter
, IF(pm.pm_regdt>=DATE_ADD(NOW(), INTERVAL -1 MONTH), 1, 0) AS pm_newchk
, 0 AS pm_jego
, 'pm.pm_sldk13' AS pm_sldk
, IF(
pm.pm_notuse='Y'
OR pm.pm_soldout='Y'
OR IF(pm.pm_orderlimitdt='Y' AND pm.pm_orderlimitsdt<='2024-06-02' AND pm.pm_orderlimitedt>='2024-06-02', 'Y', 'N')='Y'
OR (spm.spm_soldout='Y' AND ZPRO_INGJEGO(pm.pm_mkey, spm.spm_soldout)<1)
, 1, 0) AS goods_stock
, IF(pm.pm_orderlimitdt='Y' AND pm.pm_orderlimitsdt<='2024-06-02' AND pm.pm_orderlimitedt>='2024-06-02', 'Y', 'N') AS pm_orderlimitdtuse
, pm.pm_orderlimitedt
, 0 AS goods_hits
, 0 AS goods_point_use
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.category_delete='N')
LEFT JOIN shop_pummok_data AS spmdaa
ON (pm.pm_uid=spmdaa.spmda_pmuid AND spmdaa.spmda_mode='best' AND spmdaa.spmda_regdate='2024-06-02')
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 AND scp.scp_cpkey=pm.pm_jejo AND scp.scp_use='Y')
LEFT JOIN (
SELECT
em.em_sqno AS el_sqno
, em.em_gubn AS em_gubn
, em.em_start AS em_start
, em.em_end AS em_end
, el.el_pmuid, el.el_price, el.el_sldk1, el.el_sldk2, el.el_sldk3, el.el_sldk4, el.el_sldk5, el.el_sldk6, el.el_sldk7, el.el_sldk8, el.el_sldk9, el.el_sldk10, el.el_sldk11, el.el_sldk12, el.el_sldk13, el.el_sldk14
FROM
eventpummokmast AS em
INNER JOIN eventpummoklist AS el ON (em.em_sqno=el.el_emsqno AND em.em_sid='1' AND em.em_start<='2024060206' AND em.em_end>'2024060206' AND em.em_gubn IN ('0', '2') AND el.el_sldk13>0)
) AS el
ON (el.el_pmuid=pm.pm_uid)
WHERE pm.pm_delete='N' AND pm.pm_b2capproval='Y' AND el.el_sqno IS NOT NULL ORDER BY pm.pm_uid DESC LIMIT 16
Mysql_Error : Lost connection to MySQL server during query
Mysql Error Num : 2013
Error!!
