sql:
select count(m_mall_id) as mall_cnt
from
(
SELECT
m_mall_id
FROM m_mall
INNER JOIN m_mall_info ON m_mall_id = 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
INNER JOIN t_site_view ON t_sv_mall_id = m_mall_id AND t_sv_site_id = 1 AND t_sv_view_flg = 1
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
INNER JOIN m_amu_area ON m_amu_area_id = m_mall_amu_area_id
INNER JOIN m_s_amu_area ON m_s_amu_area_id = m_amu_area_s_amu_area_id
INNER JOIN m_pref ON m_pref_id = m_mall_pref_id
WHERE 1=1 and m_mall_pref_id=
GROUP BY m_mall_id
) aaa
			<Br>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY m_mall_id
) aaa' at line 19