basicv

Vari mēģināt tā:

SELECT * FROM 
(SELECT `from` as dAll FROM `events` WHERE `from`>=NOW()
UNION
SELECT `to` FROM `events` WHERE `to`>=NOW()) dta ,
(SELECT *
FROM `events` 
WHERE  (NOW() BETWEEN `from` AND `to`)
OR (`to` >= NOW() AND `from` <= `to`)) dtb
WHERE (dta.dAll<=dtb.`from` AND dta.dAll>=dtb.`to`) OR (dta.dAll>=dtb.`from` AND dta.dAll<=dtb.`to`)

Bet, ja notikumu būs daudz, būs bremzes.