Warning: mysqli::query() [mysqli.query]: (HY000/1449): The user specified as a definer ('mkj0516'@'175.208.212.242') does not exist in /home/hosting_users/mkj0516/www/common/db_class.php on line 105
ERR NO:[1449]
ERR MSG:[The user specified as a definer ('mkj0516'@'175.208.212.242') does not exist]
SELECT A.sno, A.uid, A.cate_cd, A.trd_cd
, CASE A.trd_cd WHEN '1' THEN '매매'
WHEN '2' THEN '전세'
WHEN '3' THEN '월세'
WHEN '4' THEN '단기임대'
ELSE '' END AS trd_nm
/* 신규등록일 기준으로 며칠 경과했는지 */
, DATEDIFF(NOW(), A.dt_reg) day_ago
, CASE WHEN DATEDIFF(NOW(), A.dt_reg) <= 3 THEN A.dt_reg
ELSE A.dt_upd END dt
, A.addr_si, A.addr_dng, A.sell_dscr
, A.area_spl, A.area_lnd
, IFNULL(A.room_cnt,'') AS room_cnt, IFNULL(A.bathroom_cnt,'') AS bathroom_cnt
, A.flr_gbn, A.flr1, A.flr2, A.flr3, A.flr4
, CASE A.trd_cd WHEN '1' THEN CVT_NUM_TO_SHAN(A.prc_maemae*10000)
WHEN '2' THEN CVT_NUM_TO_SHAN(A.prc_jeonse*10000)
WHEN '3' THEN CONCAT(CVT_NUM_TO_SHAN(A.prc_bojeung*10000), '/', CVT_NUM_TO_SHAN(A.prc_wolse*10000))
WHEN '4' THEN CONCAT(CVT_NUM_TO_SHAN(A.prc_bojeung*10000), '/', CVT_NUM_TO_SHAN(A.prc_wolse*10000))
ELSE ' ' END AS prc
, B.cpn_nm, C.cate_nm_s AS cate_nm
FROM sell_tbl A
LEFT OUTER JOIN agent B ON A.uid = B.uid
LEFT OUTER JOIN sell_cate_reg C ON A.cate_cd = C.cate_cd
WHERE A.dt_reg >= DATE_SUB(NOW(), INTERVAL 6 MONTH)
AND A.ad_fg = 'A'
ORDER BY
A.dt_reg
LIMIT 10