gistfile1.txt

SELECT DISTINCT node.title AS node_title, node.nid AS nid, field_data_field_yp_lastname.field_yp_lastname_value AS field_data_field_yp_lastname_field_yp_lastname_value, 'node' AS field_data_field_yp_title_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_yp_lastname} field_data_field_yp_lastname ON node.nid = field_data_field_yp_lastname.entity_id AND (field_data_field_yp_lastname.entity_type = 'node' AND field_data_field_yp_lastname.deleted = '0')
LEFT JOIN {search_index} search_index ON node.nid = search_index.sid
WHERE (( (node.status = '1') AND (node.type IN  ('faculty')) AND (field_data_field_yp_lastname.field_yp_lastname_value IS NOT NULL ) )AND(( (search_index.type = 'node') AND( (search_index.word = 'australia') ))AND( (search_index.type = 'node') AND( (search_index.word = 'astronomy') ))))
GROUP BY search_index.sid, nid, field_data_field_yp_title_node_entity_type
HAVING (( (COUNT(*) >= '1') AND (COUNT(*) >= '1') ))
ORDER BY field_data_field_yp_lastname_field_yp_lastname_value ASC
LIMIT 25 OFFSET 0