Untitled

(SELECT
        `bo`.`id`,
        `bo`.`to`,
        `bo`.`message`,
        `bf`.`from`,
        `bo`.`priority`,
        NULL AS `gw_spam_id`,
        NULL AS `bb_id`
FROM
    `bulk_outbox` `bo`, `bulk_from` `bf`
WHERE
    `bo`.`bulk_batch_id` IS NULL
    AND `bo`.`status` = 'queued'
    AND (`bo`.`begin` < NOW() OR `bo`.`begin` IS NULL)
    AND `bo`.`created` + INTERVAL 1 MONTH > NOW()
    AND `bo`.`created` <= NOW()
    AND `bf`.`id` = `bo`.`bulk_from_id`
ORDER BY
    bo.priority DESC
LIMIT 100
)
UNION
(
SELECT
    `bo`.`id`,
    `bo`.`to`,
    `bo`.`message`,
    `bf`.`from`,
    `bo`.`priority`,
    `bb`.`gw_spam_id`,
    `bb`.`id` AS `bb_id`
FROM
    `bulk_batch` `bb`, `bulk_from` `bf`, `bulk_outbox` `bo`
WHERE
    `bo`.`bulk_batch_id` IS NOT NULL
    AND `bb`.`status` IN ('queued', 'sending')
    AND `bo`.`status` = 'queued'
    AND (`bb`.`begin` < NOW() OR `bb`.`begin` IS NULL)
    AND `bo`.`created` + INTERVAL 1 MONTH > NOW()
    AND `bo`.`created` <= NOW()
    AND `bf`.`id` = `bb`.`bulk_from_id`
    AND `bo`.`bulk_batch_id` = `bb`.`id`
ORDER BY
    `bb`.`status` DESC,
    `bb`.`priority` DESC
LIMIT 100
)
ORDER BY
    priority DESC
LIMIT 100