Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- beskeder.id,
- beskeder.sms_bunker_id AS bunkeid,
- beskeder.besked,
- beskeder.overtakseringspris,
- beskeder.alphatekst,
- beskeder.sms_bunker_id,
- (SELECT url FROM dbo.gaw_sms_beskeder_wapurl WHERE sms_beskeder_id = beskeder.id) AS url,
- beskeder.donation
- FROM dbo.gaw_sms_beskeder beskeder
- WHERE
- EXISTS(
- SELECT TOP 1 id
- FROM gaw_sms_modtagere modtagere
- WHERE sms_beskeder_id = beskeder.id AND
- (modtagere.gaw_operator_id IS NOT NULL OR modtagere.landekode != '45')) AND
- (beskeder.udsendelsestid IS NULL OR beskeder.udsendelsestid <= GETDATE()
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement