SELECT node_field_data.title AS node_field_data_title, node_field_data.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__node_field_data.nid AS node_node__field_related_pages_nid
FROM
node_field_data node_field_data
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_field_data node_node__field_related_pages__node_field_data ON node__field_related_pages.field_related_pages_target_id = node_node__field_related_pages__node_field_data.nid
WHERE (( (node_field_data.status = '1') AND (node_field_data.type IN  ('article')) ))
LIMIT 10 OFFSET 0