select m.delivery_id, m.order_id, m.activated, dups.cnt from delivery_vroong_order_map as m
inner join (
  select delivery_id, COUNT(*) as cnt
  from delivery_vroong_order_map
  group by delivery_id
  having
  count(*) > 1
) dups on m.delivery_id = dups.delivery_id;