SELECT n.*
FROM {content_type_tasks} t
INNER JOIN {content_type_project} p
INNER JOIN {node} n ON p.nid = t.field_main_project_nid 
WHERE p.field_project_0_nid = '%d'", $node->nid);