sql: select m_s_amu_area.*, count(*) as cnt 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 and m_mall_pref_id=m_s_amu_area_pref_id INNER JOIN m_pref ON m_pref_id = m_mall_pref_id LEFT JOIN m_deli_amu_area AS deli_from_area ON deli_from_area.m_deli_amu_area_id = m_mall_location_deli_amu_area_id LEFT JOIN m_liking_category ON m_liking_cate_id = m_mall_liking_cate_id where m_pref_code='tokyo' and m_s_amu_area_delflg = 0 group by m_s_amu_area_id having cnt >0 order by m_s_amu_area_sort
Can't create/write to file '/tmp/#sql-temptable-5bae-1e2525-1d967.MAI' (Errcode: 28 "No space left on device")