-- THIS ONE
SELECT `urlaub`.*
FROM `urlaub` , `users`
WHERE `users`.`userid` = `urlaub`.`userid`
AND `users`.`enddate` > '2012-01-01'
AND `urlaub`.`status` =3

-- OR THIS ONE

SELECT `urlaub`.*
FROM `urlaub`
JOIN `users` ON `users`.`userid` = `urlaub`.`userid`
WHERE `users`.`enddate` > '2012-01-01'
AND `urlaub`.`status` =3