select a.secondcategory,b.secondcategory,count(a.device) from ( select a.secondcategory,a.device from q2game_category a where secondcategory like '%休闲%' group by secondcategory,device ) a join ( select b.secondcategory,b.device from q2game_category b where secondcategory like '%体育%' group by se...