What about the highest mailshot id number?
SELECT T1.mailshot_id FROM mailshot_customers AS T1 JOIN customers AS T2 ON T1.customer_id   =   T2.customer_id GROUP BY T1.customer_id ORDER BY count ( * )  DESC LIMIT 1
highest mailshot id number refers to the mailshot_id associated with the customer who received the most mailshots;