SELECT nummer,COUNT(*) FROM gaw_sms_modtagere_log WITH (NOLOCK)
JOIN gaw_sms_beskeder_log WITH (NOLOCK) ON gaw_sms_beskeder_log.sms_beskeder_id = gaw_sms_modtagere_log.sms_beskeder_log_id
JOIN gaw_sms_bunker_log WITH (NOLOCK) ON gaw_sms_bunker_log.sms_bunker_id = gaw_sms_beskeder_log.sms_bunker_log_id
WHERE klasse_id = 337 AND afleveretleverandoertid > '2010-05-26 00:00:00'
GROUP BY nummer
HAVING COUNT(*) > 1
ORDER BY nummer