Club Drupal

  $query = db_select('file_managed', 'fm')->extend('PagerDefault')->extend('TableSort');

  $query->leftJoin('file_usage', 'fu', 'fm.fid = fu.fid');

  $query->groupBy('fm.fid');

  $query->addExpression('SUM(fu.count)', 'total_count');

  file_entity_build_filter_query($query);

  $options = array();

  foreach ($files as $file) {

    $file_type = file_type_load($file->type);

    $options[$file->fid] = array(

      'title' => array(

        'data' => array(

      ),

      'type' => $file_type ? check_plain($file_type->label) : FILE_TYPE_NONE,

      'size' => format_size($file->filesize),

      'timestamp' => format_date($file->timestamp, 'short'),

      'usage' => format_plural((int) $result[$file->fid]->total_count, '1 place', '@count places'),

    );