your code to find the age should be:
((date_format(now(),'%Y') - date_format(profile.age,'%Y')) - (date_format(now(),'00-%m-%d') < date_format(profile.age,'00-%m-%d'))) AS age
if your still having problems add this code in the body:
<?php echo($query_alles); ?>
to write the query to the page, then bring this into PHPMyAdmin or another MySQL GUI tool to run the query directly on the database.
simplify the query as much as possible to see if a simplified version will work, to rule out your joins causing an issue.