SHARE
TWEET

Untitled

a guest Mar 28th, 2014 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT node_users.nid AS node_users_nid, node_users.TYPE AS node_users_type, node_users.created AS node_users_created, node_users.title AS node_users_title, node_users.LANGUAGE AS node_users_language, 'node' AS field_data_field_body_node_entity_type, 'node' AS field_data_field_ebep_text_node_entity_type, 'node' AS field_data_field_ebep_news_media_node_entity_type, 'node' AS field_data_field_ebep_innovation_media_node_entity_type
  2. FROM
  3. {users} users
  4. LEFT JOIN {node} node_users ON (SELECT nodeINNER.nid AS nidINNER
  5. FROM
  6. {node} nodeINNER
  7. LEFT JOIN {users} users_nodeINNER ON nodeINNER.uid = users_nodeINNER.uid
  8. WHERE (( (users_nodeINNER.uid = users.uid ) )AND(( (nodeINNER.STATUS = '0') AND (nodeINNER.TYPE IN  ('5', :db_condition_placeholder_2)) AND (nodeINNER.LANGUAGE IN  (:db_condition_placeholder_3)) AND (nodeINNER.promote <> :db_condition_placeholder_4) )))
  9. ORDER BY node_createdINNER. DESC
  10. LIMIT 1 OFFSET 0) = node_users.nid
  11. INNER JOIN {users_roles} users_roles ON users.uid = users_roles.uid
  12. WHERE (( (users.STATUS <> '0') AND (users_roles.rid = '5') ))
  13. LIMIT 3 OFFSET 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