SELECT
  'dk.'+(SELECT TOP 1 gaw_leverandoerer_operatorer.tekst FROM gaw_leverandoerer_operatorer WHERE gaw_sms_modtagere_log.gaw_operator_id = gaw_leverandoerer_operatorer.gaw_operatorer_id AND gaw_leverandoerer_operatorer.gaw_leverandoerer_kode = 5) AS operator,
  gaw_sms_modtagere_log.landekode+''+gaw_sms_modtagere_log.nummer AS msisdn,
  gaw_sms_modtagere_log.afleveretleverandoertid AS deliveredunwire,
  gaw_sms_modtagere_log.statusmodtaget AS statusreceived
FROM gaw_sms_bunker_log WITH (NOLOCK)
JOIN gaw_sms_beskeder_log WITH (NOLOCK) ON gaw_sms_beskeder_log.sms_bunker_log_id = gaw_sms_bunker_log.sms_bunker_id
JOIN gaw_sms_modtagere_log WITH (NOLOCK) ON gaw_sms_modtagere_log.sms_beskeder_log_id = gaw_sms_beskeder_log.sms_beskeder_id
JOIN gaw_klasser WITH (NOLOCK) ON gaw_klasser.id = gaw_sms_bunker_log.klasse_id
LEFT JOIN gaw_sms_statuskoder ON gaw_sms_modtagere_log.status = gaw_sms_statuskoder.id
WHERE
  sms_leverandoer_kode = 5 AND
  indkommendetid > '2010-05-24 00:00:00' AND
  status = 4 AND
  (gaw_sms_modtagere_log.statusmodtaget-gaw_sms_modtagere_log.afleveretleverandoertid) < '00:10:00'
ORDER BY gaw_sms_modtagere_log.afleveretleverandoertid