select t2.product_id,t2.cnt
from(
select t1.product_id
,count(*) as cnt
from(
select substring_index(order_id,"_",-1) as product_id
from order_log
) t1
group by t1.product_id
) t2
where product_id like "p%"
order by cnt desc
limit 1 offset 0