...
# get vendor id:
SELECT id FROM vendor WHERE NAME=00 or NAME=440 ...

# check all words
foreach (@word) {
  SELECT product_id FROM words WHERE vendor_id=? and word=?
  for my $id (@ids)
    $cnt{$id}++
  }
}