Guest User

Untitled

a guest
Jun 25th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. "SELECT DISTINCT node_field_data.created AS node_field_data_created, node_field_data.nid AS nid, paragraphs_item_field_data_node__field_areas_of_specialization.id AS paragraphs_item_field_data_node__field_areas_of_specializati
  2. FROM
  3. node_field_data node_field_data
  4. LEFT JOIN node__field_areas_of_specialization node__field_areas_of_specialization ON node_field_data.nid = node__field_areas_of_specialization.entity_id AND node__field_areas_of_specialization.deleted = '0'
  5. LEFT JOIN paragraphs_item_field_data paragraphs_item_field_data_node__field_areas_of_specialization ON node__field_areas_of_specialization.field_areas_of_specialization_target_revision_id = paragraphs_item_field_data_node__field_areas_of_specialization.revision_id
  6. LEFT JOIN node__field_expert_is_active node__field_expert_is_active ON node_field_data.nid = node__field_expert_is_active.entity_id AND node__field_expert_is_active.deleted = '0'
  7. WHERE ((SUBSTRING(node_field_data.title, 1, 1) = 'A')) AND ((node_field_data.status = '1') AND (node_field_data.type IN ('air_cargo_experts')) AND (node__field_expert_is_active.field_expert_is_active_value = '1'))
  8. ORDER BY node_field_data_created DESC"
Add Comment
Please, Sign In to add comment