An error occurred: (MySQLdb.ProgrammingError) (1146, "Table 'mydb.apt_list_4' doesn't exist") [SQL: select a.rgnCode, a.danjyCode, a.aptName, a.conAptNo, a.aptUnit, a.hoNum, c.sido, c.gugun, c.dong, c.bjri, a.aptAddr, a.doroAddr, a.conYear, a.useArea from (select a.rgnCode, ifnull(a.conAptCode, concat(a.rgnCode,'-', a.aptCode)) danjyCode, b.conAptNo, if(min(a.aptName_max) = max(a.aptName_max), min(a.aptName_max), max(a.aptName_max)) aptName, b.aptUnit, ifnull(round(b.useArea, 2), 0) useArea, ifnull(b.hoNum, 0) hoNum, ifnull(a.con_addrNum, a.aptAddr) aptAddr, if(a.con_doroAddr='', a.doroAddr, a.con_doroAddr) doroAddr, ifnull(if(a.useDateMin='', a.conYear_min, a.useDateMin), a.conYear_max) conYear from mydb.apt_list_4 a left join mydb.apt_list_4 b on a.aptNo=b.aptCode where a.rgnCode like %s and ifnull(a.conAptCode, concat(a.rgnCode, '-', a.aptCode)) = %s and b.aptUnit is not null and a.rgnCode=a.con_rgnCode and b.conAptNo is not null group by a.rgnCode, danjyCode, conAptNo, b.aptUnit, useArea, hoNum, aptAddr, doroAddr, conYear ) a left join region_list c on a.rgnCode = c.rgnCode order by a.aptUnit ] [parameters: ('50110102%', '2274404')] (Background on this error at: https://sqlalche.me/e/20/f405)
※ 열이름 클릭 정렬
지 역 명 사진 매물종류 유형 가격 입주시기 면적(㎡) 용도지역 지목 등록자(일)
임대수익률 계산기
적정주택가격 계산기
유용한 부동산 사이트 모음