Using Drupal 7 I have created a content type called 'fauna'. I simply want to filter by an attribute (eg: 'area') using Drupal database API.
As far as I have seen around, most of people follow queries like...
$query = db_select('my_table_name')
applying then some filters.
But I have no table at all regarding my content type where I could apply these filters, i just have a bunch of tables field_data_field_fauna_name, field_data_field_fauna_area ... (these are the fields defined for my Content type).