dberror
select m.shop_no,COUNT(*),m.shop_kana,m.shop_name,m.shop_name_e from m_shop as m , r_shop_category as r where m.shop_no NOT IN('3','4','32','33','34','35','36','37','38','39','40','41','42','43') and m.shop_no between 318 and 423 and m.shop_name != '' and m.status = '1' group by m.shop_no,m.shop_name,m.shop_name_e,m.shop_kana order by m.shop_kana,COUNT desc