SELECT `y`.`id` , `x`.`date`, MAX( `x`.`date` ) AS `max_date`
FROM `x` , `y` 
WHERE `x`.`id` = `y`.`id`
GROUP BY `y`.`id`
HAVING (`max_date` < UNIX_TIMESTAMP())