Need some help with SQL if anyone is so inclined!
I am importing a large amount of 'story' content type from an old outdated site into drupal 6 using the very handy node import module. I have managed to figure out how to bring in the nid, title, body and the only other columns of data I need is the vocab terms. I am running SQL queries on the old database using phpmyadmin, trying to figure out how I can get all the columns of data in one SQL export.
The SQL statement I have got so far is as follows:
SELECT title, body, teaser, tid
FROM `node_revisions`
INNER JOIN term_node ON node_revisions.nid = term_node.nid
LIMIT 0 , 600;
This gives me the data I require, but does so by repeating each record three times, in order to show the term id (tid) for each record. I am wondering which tables in the data base I have to query in order to get the node information from node revisions, as well as the three different term id numbers for each individual node.
Thankyou very much if anyone has the time and expertise to help with this issue.
Renaee.