Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.