my $sql = <<SQL;
    SELECT count(*)
    FROM files
    WHERE geo=? AND lob="is" AND country=?
  SQL
  my $sth = $dbh->prepare($sql);
  $sth->execute($geo, $country);
  my($count) = $sth->fetchrow_array();
  $sth->finish();