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