sql: SELECT m_mall_id FROM (SELECT m_mall.m_mall_deli_flg, m_mall_info.m_minfo_deli_flg, m_mall_amu_area_id,m_mall_mallrank, m_mall.m_mall_id, m_mall_info.m_minfo_id, m_mall_info.m_minfo_mall_id, m_mall.m_mall_pref_id, m_mall.m_mall_business_id, m_mall_info.m_minfo_view_flg, m_mall.m_mall_view_flg, m_mall.m_mall_confirm_flg, m_mall.m_mall_app_flg, m_mall.m_mall_option_kb, m_mall_info.m_minfo_newsblock_disp FROM m_mall, m_mall_info WHERE m_mall.m_mall_id = m_mall_info.m_minfo_mall_id AND m_mall_view_flg = 1 AND m_minfo_view_flg = 1 AND m_mall_confirm_flg = 1 AND m_mall_app_flg = 1 AND m_mall_pref_id = 21) m_mall INNER JOIN t_site_view ON t_sv_mall_id = m_mall_id AND t_sv_site_id = 5 AND CASE WHEN t_sv_site_id = 4 AND m_mall_business_id IN (12,13) THEN m_mall.m_mall_deli_flg = 1 AND m_mall.m_minfo_deli_flg = 1 ELSE 1 END INNER JOIN m_pref ON m_pref_id = m_mall_pref_id INNER JOIN m_area ON m_area_id = m_pref_area_id INNER JOIN m_business ON m_business_id = m_mall_business_id INNER JOIN m_s_business ON m_s_business_id = m_business_s_business_id AND t_sv_view_flg = 1 AND m_s_business_id IN (SELECT t_ssb_s_business_id FROM t_site_s_business WHERE t_ssb_site_id = 5) WHERE m_mall_view_flg =1 AND m_mall_confirm_flg =1 AND m_mall_app_flg = 1 AND m_minfo_view_flg =1 AND m_minfo_newlevel_id > 3 AND m_minfo_newsblock_disp = 1 AND m_mall_pref_id = 21 AND m_mall_amu_area_id IN (286)
Unknown column 'm_minfo_newlevel_id' in 'where clause'