daily pastebin goal
38%
SHARE
TWEET

Untitled

a guest Sep 23rd, 2016 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT SUBSTRING(user__field_fio.field_fio_value, 1, 1) AS field_fio_value_truncated,
  2.        COUNT(users_field_data.uid) AS num_records,
  3.        'polzovateli_s_citatami:attachment_1' AS view_name,
  4.        MIN(users_field_data.uid) AS UID,
  5.        MIN(node_field_data_users_field_data.nid) AS node_field_data_users_field_data_nid
  6. FROM {users_field_data} users_field_data
  7. LEFT JOIN {node_field_data} node_field_data_users_field_data ON
  8.   (SELECT node_field_dataINNER.nid AS nidINNER,
  9.           ':default' AS view_name
  10.    FROM {node_field_data} node_field_dataINNER
  11.    LEFT JOIN {users_field_data} users_field_data_node_field_dataINNER ON "node_field_dataINNER".uid = "users_field_data_node_field_dataINNER".uid
  12.    WHERE ((("users_field_data_node_field_dataINNER".uid = users_field_data.uid)))
  13.    ORDER BY node_field_dataINNER.nid DESC LIMIT 1
  14.    OFFSET 0) = node_field_data_users_field_data.nid
  15. LEFT JOIN {user__field_fio} user__field_fio ON users_field_data.uid = user__field_fio.entity_id
  16. AND (user__field_fio.deleted = :views_join_condition_0
  17.      AND user__field_fio.langcode = users_field_data.langcode)
  18. WHERE (((users_field_data.status = :db_condition_placeholder_2)
  19.         AND (node_field_data_users_field_data.type IN (:db_condition_placeholder_3))))
  20. GROUP BY field_fio_value_truncated,
  21.          view_name
  22. ORDER BY field_fio_value_truncated ASC LIMIT 10
  23. OFFSET 0;
  24.  
  25. Array ([:db_condition_placeholder_2] => 1 [:db_condition_placeholder_3] => citaty [:views_join_condition_0] => 0)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top