##
00
440
100
Compaq
Laptop
Model
No
Presario
Series
PSLA
####
...
# 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}++
}
}