SELECT field_data_field_newsimage.field_newsimage_fid AS field_data_field_newsimage_field_newsimage_fid, node.created AS node_created, node.title AS node_title, node.nid AS nid_1, field_data_body.body_value AS field_data_body_body_value, field_data_field_location_address.field_location_address_country AS field_data_field_location_address_field_location_address_cou, MIN(node.nid) AS nid, 'node' AS field_data_field_newsimage_node_entity_type, 'node' AS field_data_body_node_entity_type, 'node' AS field_data_field_location_address_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_type_of_page} field_data_field_type_of_page ON node.nid = field_data_field_type_of_page.entity_id AND (field_data_field_type_of_page.entity_type = 'node' AND field_data_field_type_of_page.deleted = '0')
LEFT JOIN {domain_access} domain_access ON node.nid = domain_access.nid AND domain_access.realm = 'domain_id'
LEFT JOIN {field_data_field_newsimage} field_data_field_newsimage ON node.nid = field_data_field_newsimage.entity_id AND (field_data_field_newsimage.entity_type = 'node' AND field_data_field_newsimage.deleted = '0')
LEFT JOIN {field_data_body} field_data_body ON node.nid = field_data_body.entity_id AND (field_data_body.entity_type = 'node' AND field_data_body.deleted = '0')
LEFT JOIN {field_data_field_location_address} field_data_field_location_address ON node.nid = field_data_field_location_address.entity_id AND (field_data_field_location_address.entity_type = 'node' AND field_data_field_location_address.deleted = '0')
WHERE (( (node.status = '1') AND (field_data_field_type_of_page.field_type_of_page_value IN  ('1')) AND (((domain_access.realm = 'domain_id' AND domain_access.gid = ***CURRENT_DOMAIN***) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0))) AND (node.created > ***CURRENT_TIME***-63154800) )AND(( (node.type IN  ('book')) )))
GROUP BY field_data_field_newsimage_field_newsimage_fid, node_created, node_title, nid_1, field_data_body_body_value, field_data_field_location_address_field_location_address_cou
HAVING (( (COUNTnode.nid = '1') ))
ORDER BY node_created DESC