I am using Drupal 7 version and my requirement to get some records based on some conditions from custom content type. I created few CCk fields for my custom content type also. And using those custom fields want to fetch some nodes of that content type.
In this case which tables I should use ??? field_data_field_x or field_revision_field_x ??
What is the difference between these two tables and how?