select re.syocd, count(re.syocd) as ct_orders, it.sy_name From RE_T_KAGOMEI re , MST_ITEM it Where re.kago_cd > 2010072300000000000000 and re.kago_cd < 2010073000000000000000 and it.sy_cd = re.syocd GROUP BY re.syocd order by ct_orders desc limit 0,10