How to get node content in an sql query? I see that in D6 the node table has only the title of the node. How to query database to get  the body (content) of a particular node? 

Update: I figured out the content bodies are stored in node_revisions table.
Drupal 7

In Drupal 7 body content is saved in field_data_body and field_revision_body tables.

So example query to fetch title and body would be:

SELECT title, r.body_value, n.changed FROM node n LEFT JOIN field_data_body r ON n.nid = r.entity_id AND n.vid = r.revision_id


To query via drush, run drush sqlq following by above query.