SELECT node.nid AS nid, node.title AS node_title, field_data_field_published_date.field_published_date_value AS field_data_field_published_date_field_published_date_value, 'node' AS field_data_field_teaser_image_node_entity_type
FROM 
node node
LEFT JOIN field_data_field_child_page field_data_field_child_page ON node.nid = field_data_field_child_page.field_child_page_nid
LEFT JOIN field_data_field_child_items field_data_field_child_items_field_data_field_child_page ON field_data_field_child_page.entity_id = field_data_field_child_items_field_data_field_child_page.field_child_items_value
LEFT JOIN node node_field_data_field_child_items_field_data_field_child_page ON field_data_field_child_items_field_data_field_child_page.entity_id = node_field_data_field_child_items_field_data_field_child_page.nid

LEFT JOIN field_data_field_published_date field_data_field_published_date ON node.nid = field_data_field_published_date.entity_id AND (field_data_field_published_date.entity_type = 'node' AND field_data_field_published_date.deleted = '0')

WHERE (( (node.status = '1') AND (node.nid IN  
	(
	SELECT tn.nid AS nid
	FROM 
	taxonomy_index tn
	LEFT OUTER JOIN taxonomy_term_hierarchy th ON th.tid = tn.tid
	LEFT OUTER JOIN taxonomy_term_hierarchy th1 ON th.parent = th1.tid
	WHERE ( (tn.tid = '60913') OR (th1.tid = '60913') )
	)
) 

AND (node_field_data_field_child_items_field_data_field_child_page.nid IS NULL ) ))
ORDER BY field_data_field_published_date_field_published_date_value DESC
LIMIT 2 OFFSET 0