entityQuery to get Nodes referenced by other nodes like an SQL JOIN
You can use 'entity' field query

$query = \Drupal::entityQuery('node');
$query-&gt;condition('status', 1);
$query-&gt;condition('type', 'article');
$query-&gt;condition('field_some_field.entity:node.title', 'Referenced node title');