SELECT node_field_data.title AS node_field_data_title, node.nid AS nid, node_node__field_related_pages__node_field_data.title AS node_node__field_related_pages__node_field_data_title, node_node__field_related_pages.nid AS node_node__field_related_pages_nid
FROM
(node node
  INNER JOIN node_field_data node_field_data ON node.nid = node_field_data.nid)
LEFT JOIN node__field_related_pages node__field_related_pages ON node_field_data.nid = node__field_related_pages.entity_id AND (node__field_related_pages.deleted = '0' AND node__field_related_pages.langcode = node_field_data.langcode)
LEFT JOIN (node node_node__field_related_pages
  INNER JOIN node_field_data node_node__field_related_pages__node_field_data ON node_node__field_related_pages.nid = node_node__field_related_pages__node_field_data.nid)
  ON node__field_related_pages.field_related_pages_target_id = node_node__field_related_pages.nid
WHERE (( (node_field_data.status = '1') AND (node.type IN  ('article')) ))
LIMIT 10 OFFSET 0