SELECT *
FROM [Item]
JOIN (
SELECT DISTINCT [item_id]
FROM [Keyword]
WHERE [Keyword].[keyword] LIKE '%' + ? + '%'
)
ON [Keyword].[item_id] = [Item].[item_id]