select item_id,sum(num) as num
from siteitem a,(
select siteanme,count(siteanme) as num from search_content
group by siteanme) as b
where b.siteanme like rtrim(a.item_id)+'%'
group by item_id
from siteitem a,(
select siteanme,count(siteanme) as num from search_content
group by siteanme) as b
where b.siteanme like rtrim(a.item_id)+'%'
group by item_id
from siteitem a,(
select item_name,count(siteanme) as num from search_content
group by item_name) as b
where b.item_name like rtrim(a.item_id)+'%'
group by item_id