SQL query to access a field collection's data? At them moment, I'm only getting field_collection_item returned
You can use the field_collection_field_get_entity() function to obtain the desired result without writing SQL, like this:


$node = node_load(12);
$items = field_get_items('node', $node, 'field_fc_field');
foreach ($items as $item) {
$fc = field_collection_field_get_entity($item);
// Do something with $fc
dpm($fc);
}