Accessing content type data using mysql I'm trying to use data captured within my drupal database to drive some analytics in another tool.
I am trying to develop a view which gets the field data for a content type i've created.
The db model seems rather complicated, can anyone give me any tips on how to join the tables together to find fields for a given content type.

Cheers
A
I would advise you to learn how to use the views module.

In order to achieve what you want. Make sure to install the views module first. To add a new view go to admin/structure/views/add and you should see the page below. Select the content type you want 

On the same page change teasers to fields. And then click continue and edit. It should take you to a new page. To add more fields from the content type you want, click on the Add link under the fields category. To make it better formatted, you can change the format type under the format category. Once you have added all your fields, click on the save button at the top.