Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.73 KB | None | 0 0
  1. SELECT users_field_data.langcode AS users_field_data_langcode, users_field_data.uid AS uid, node_field_data_users_field_data.nid AS node_field_data_users_field_data_nid, 'polzovateli_s_citatami_:page_1' AS view_name
  2. FROM
  3. {users_field_data} users_field_data
  4. LEFT JOIN {node_field_data} node_field_data_users_field_data ON users_field_data.uid = node_field_data_users_field_data.uid
  5. LEFT JOIN {user__field_fio} user__field_fio ON users_field_data.uid = user__field_fio.entity_id AND (user__field_fio.deleted = '0' AND user__field_fio.langcode = users_field_data.langcode)
  6. WHERE (( (users_field_data.status = '1') AND (user__field_fio.field_fio_value IS NOT NULL ) AND (node_field_data_users_field_data.type IN  ('citaty')) ))
  7. LIMIT 10 OFFSET 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement