SELECT DISTINCT Item.item_id, Item.seller_id, Item.title, Item.description, Item.current_price, Item.increment, Item.picture, Item.category_id, Keyword.item_id AS Expr1, Keyword.keyword, ItemPickup.item_id AS Expr2, ItemPickup.pickup_id FROM ((Item INNER JOIN Keyword ON Item.item_id = Keyword.item_id) INNER JOIN ItemPickup ON ItemPickup.item_id = Item.item_id) WHERE (Keyword.keyword LIKE '%' + ? + '%') OR (Item.title LIKE '%' + ? + '%') AND (ItemPickup.pickup_id = ?)