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