A complex query (due to jomsocial db structure)

Here's how my database is
[attachment=1]chrono2.jpg[/attachment]
Now I want to extract and display certain records using chronoconnectivity
Here are my requirements
I want to fetch user_id

whose field_id='130' AND value='Yes'

but show the

value where field_id='61'

of the user_id's so fetched

Hi,

I'm not sure I can understand your question, but there is a WHERE box where you can write your custom query, if you need to grab the logged in user's id then you can do this using the code below:

<?php
$user = JFactory::getUser();
$user_id = $user->get('id');
?>

Regards,
Max