34.21 - views_plugin_query_default::execute

SELECT users.uid AS uid, taxonomy_term_data_field_data_field_unit.tid AS taxonomy_term_data_field_data_field_unit_tid, field_data_field_surname.field_surname_value AS field_data_field_surname_field_surname_value, field_data_field_first_name.field_first_name_value AS field_data_field_first_name_field_first_name_value, 'user' AS field_data_field_first_name_user_entity_type, 'user' AS field_data_field_surname_user_entity_type, 'taxonomy_term' AS field_data_field_orientation_taxonomy_term_entity_type, 'taxonomy_term' AS field_data_field_brand_taxonomy_term_entity_type FROM users users LEFT JOIN field_data_field_unit field_data_field_unit ON users.uid = field_data_field_unit.entity_id AND (field_data_field_unit.entity_type = :views_join_condition_0 AND field_data_field_unit.deleted = :views_join_condition_1) LEFT JOIN taxonomy_term_data taxonomy_term_data_field_data_field_unit ON field_data_field_unit.field_unit_tid = taxonomy_term_data_field_data_field_unit.tid LEFT JOIN field_data_field_surname field_data_field_surname ON users.uid = field_data_field_surname.entity_id AND (field_data_field_surname.entity_type = :views_join_condition_2 AND field_data_field_surname.deleted = :views_join_condition_3) LEFT JOIN field_data_field_first_name field_data_field_first_name ON users.uid = field_data_field_first_name.entity_id AND (field_data_field_first_name.entity_type = :views_join_condition_4 AND field_data_field_first_name.deleted = :views_join_condition_5) WHERE (( (users.status <> :db_condition_placeholder_6) AND (users.uid != :db_condition_placeholder_7) )) ORDER BY field_data_field_surname_field_surname_value ASC, field_data_field_first_name_field_first_name_value ASC