gistfile1.txt

protected function query() {
  // Get the default query and modify it
  $query = parent::query();
  $query->join('users_roles', 'ur', 'u.uid = ur.uid');
  $query->condition('u.uid', "sammy");

  return $query;
}