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
FROM
{users} users
LEFT JOIN {node} node_users ON (SELECT nodeINNER.nid AS nidINNER
FROM
{node} nodeINNER
LEFT JOIN {users} users_nodeINNER ON nodeINNER.uid = users_nodeINNER.uid
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) )))
ORDER BY node_createdINNER. DESC
LIMIT 1 OFFSET 0) = node_users.nid
INNER JOIN {users_roles} users_roles ON users.uid = users_roles.uid
WHERE (( (users.STATUS <> '0') AND (users_roles.rid = '5') ))
LIMIT 3 OFFSET 0