select concat(called_class_name, '::', called_method_name) as called
from calls
where
concat(called_class_name, '::', called_method_name)
in (select concat(class_name, '::', method_name) from methods where info->>'soft_deprecated' like '1.%')
group by called_class_name, called_method_name
having count(*) = 1;

select
c1.caller_class_name,
c1.called_class_name
from calls c1 join calls c2 on c1.called_class_name = c2.caller_class_name
where
c1.caller_class_name = c2.called_class_name and
c1.caller_class_name != c1.called_class_name
group by c1.caller_class_name, c1.called_class_name;

select concat(caller_class_name, '::', caller_method_name) as caller, concat(called_class_name, '::', called_method_name) as called
from calls
where concat(called_class_name, '::', called_method_name)
in (select concat(class_name, '::', method_name) from methods where info->>'soft_deprecated' like '1.2%');

select method_name, count(*)
from methods
where method_name like 'on%'
group by method_name
order by count(*) desc
limit 20;