category service. use inner join in place of left join