<?php

// Before

	$sql = "SELECT
			dext.activeDate,
			dext.inactiveDate,
			e.*
		FROM
			dailyEventXrefTemp AS dext
		INNER JOIN
			mod_Events AS e
		ON
			e.id = dext.eventid
		WHERE
			e.adid = $id
			AND (
				dext.activeDate >= CURDATE()
				OR (
					dext.activeDate < CURDATE()
					AND dext.inactiveDate >= CURDATE()
				)
			)
		ORDER BY
			dext.activeDate, e.time";

// After

	$sql        = "SELECT dext.activeDate, dext.inactiveDate, e.* FROM dailyEventXrefTemp AS dext INNER JOIN mod_Events AS e ON e.id = dext.eventid WHERE e.adid = $id AND (dext.activeDate >= CURDATE() OR (dext.activeDate < CURDATE() AND dext.inactiveDate >= CURDATE())) ORDER BY dext.activeDate, e.time";

?>