select
    REGEXP_SUBSTR(order_id,'p[0-9]+') as product_id,
    count(REGEXP_SUBSTR(order_id,'p[0-9]+')) as cnt
from
    order_log
group by 
    1
order by 
    cnt desc
limit 1