Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "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
- FROM
- node_field_data node_field_data
- 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'
- 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
- 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'
- 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'))
- ORDER BY node_field_data_created DESC"
Add Comment
Please, Sign In to add comment