SELECT * 
FROM [Item], [ItemPickup] 
WHERE [Item].[item_id] 
IN 
(
  SELECT [Keyword].[item_id] 
  FROM [Keyword] 
  WHERE 
  (
    [keyword] LIKE '%' + ? + '%'
  ) 
  AND [ItemPickup].[pickup_id] = ?
) 
OR [Item].[title] LIKE '%' + ? + '%' 
AND [ItemPickup].[pickup_id] = ?