Stuff

SELECT node.title AS node_title, node.nid AS nid, users_node.name AS users_node_name, users_node.uid AS users_node_uid, node.created AS node_created
FROM 
{node} node
INNER JOIN {relation_data} relation_data ON node.nid = relation_data.entity_id AND relation_data.entity_type = 'node'
INNER JOIN {relation_data} relation_data_2 ON relation_data_2.rid = relation_data.rid AND relation_data_2.r_index != relation_data.r_index AND relation_data_2.entity_type = 'user'
INNER JOIN {users} users ON users.uid = relation_data_2.entity_id
WHERE (( (node.status = '1') ))
ORDER BY node_created DESC
LIMIT 10 OFFSET 0