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: ('50110137%', '2278024')]
(Background on this error at: https://sqlalche.me/e/20/f405)