Drupal 7 - Extract posts and user names New at Drupal. Trying to extract from MySql the list of the posts with body and user name. Apparently since Drupal 7, the content is stored in drupal_field_data_body. The problem is that it does not contain any user_id, so I have no clue how to join the two tables.
So far I am here:

SELECT *
FROM drupal_node node, drupal_node_revision revision, drupal_users users
WHERE 1=1 AND revision.vid=node.vid AND revision.nid=node.nid AND users.uid=node.uid


Need to JOIN drupal_field_data_body
Can I ask why you are not using views for this task?

Views 3 for drupal 7 is a powerful interactive SQL builder. And trivial tasks like this are can be easily sold without even knowing SQL or which tables to join on etc.