Code: Select all
SELECT
bo.id, bo.bonus_code, rm.title
FROM
rb_bonus_offers AS bo
LEFT JOIN
rb_rooms AS rm
ON
bo.fk_room_id = rm.id
WHERE
bo.active = "1"
AND
bo.never_expires = "0"
AND
bo.expiration_date < NOW()
Moderator: General Moderators
Code: Select all
SELECT
bo.id, bo.bonus_code, rm.title
FROM
rb_bonus_offers AS bo
LEFT JOIN
rb_rooms AS rm
ON
bo.fk_room_id = rm.id
WHERE
bo.active = "1"
AND
bo.never_expires = "0"
AND
bo.expiration_date < NOW()
Code: Select all
SELECT
bo.id, bo.bonus_code, rm.title
FROM
rb_bonus_offers AS bo
LEFT JOIN
rb_rooms AS rm
ON
bo.fk_room_id = rm.id
WHERE
bo.active = "1"
AND
bo.never_expires = "0"
AND
bo.expiration_date < DATE_SUB(NOW(), 2 DAYS)
Code: Select all
DATE_SUB(NOW(), INTERVAL 2 DAY)Code: Select all
NOW() - INTERVAL 2 DAY