An error occurred: (MySQLdb.ProgrammingError) (1146, "Table 'mydb.apt_list_4' doesn't exist")
[SQL:
select a.con_rgnCode, a.conAptCode, a.aptName, b.conAptNo, round(b.aptUnit, 4) aptUnit, b.hoNum,
c.sido, c.gugun, c.dong, c.bjri, a.aptAddr, a.doroAddr, a.conYear, round(b.useArea, 4) useArea, ifnull(a.danjyHonum, 0) danjyHonum
from
(select con_rgnCode, conAptCode,
if(min(ifnull(danjyName, aptName)) != max(ifnull(danjyName, aptName)), max(conName), max(ifnull(danjyName, aptName))) aptName,
SUBSTRING_INDEX(MAX(CONCAT(LPAD(ifnull(hoNum, 0), 10, '0'), ' ', con_addrNum)), ' ', -1) aptAddr,
SUBSTRING_INDEX(MAX(CONCAT(LPAD(ifnull(hoNum, 0), 10, '0'), ' ', con_doroAddr)), ' ', -2) doroAddr,
max(if(ifnull(useDateMin, '') ='', conYear_min, useDateMin)) conYear, MAX(hoNum) danjyHonum,
min(ifnull(danjyName, aptName)) aptName_min, max(ifnull(danjyName, aptName)) aptName_max
from mydb.apt_list_4
where con_rgnCode like %s and addr_closed is null and conAptCode = %s
group by con_rgnCode, conAptCode
) a
left join
(select conAptCode, conAptNo, min(matchUnit) aptUnit, ifnull(max(useArea), 0) useArea, MAX(hoNum) hoNum
from mydb.apt_list_4
where conAptNo is not null and addr_closed is null and conAptCode = %s
group by conAptCode, conAptNo
) b on a.conAptCode=b.conAptCode
left join region_list c on a.con_rgnCode = c.rgnCode
order by b.aptUnit
]
[parameters: ('11230102%', '10495', '10495')]
(Background on this error at: https://sqlalche.me/e/20/f405)