I'm working with the data from a Drupal 7 site that I have and I need to extract the data from a table with a relation to another table. The problem is that one of the tables is Node table and the other is field_data_field... that has a target_id.
The queries I have tried are not connecting the data correctly between this tables. I know this because when I go to the content page (http://example.com/ca/content/aalto-erick) the data is not the same.
Is there a way to display the SQL queries that executes the server when displays this content page?
PD: I put the url to show that the info is displaying in a content page.