[joshmn]

Don't get ahead of yourself: it's SELECT with GROUP BY.

[Justin_K]

Don't forget

AND keyword LIKE '%searchStr%'