SELECT node.title AS node_title, node.nid AS nid
FROM 
{node} node
LEFT JOIN {og_membership} og_membership_node ON node.nid = og_membership_node.etid AND og_membership_node.entity_type = 'node'
LEFT JOIN {node} node_og_membership ON og_membership_node.gid = node_og_membership.nid AND og_membership_node.group_type = 'node'
LEFT JOIN {field_data_field_contract_participant} node_og_membership__field_data_field_contract_participant ON node_og_membership.nid = node_og_membership__field_data_field_contract_participant.field_contract_participant_target_id
LEFT JOIN {users} field_contract_participant_node ON node_og_membership__field_data_field_contract_participant.entity_id = field_contract_participant_node.uid
WHERE (( (field_contract_participant_node.uid = '2' ) )AND(( (node.status = '1') AND (node.type IN  ('company_address')) AND (node_og_membership.type IN  ('company')) )))
ORDER BY node_title DESC
LIMIT 10 OFFSET 0