SELECT Item.item_id, Item.seller_id, Item.title, Item.description, Item.current_price, Item.increment, Item.picture, Item.category_id, Derived.item_id AS Expr1 
from item
left join
(
	select distinct item_id
	from keyword
	where (keyword like '%' + ? + '%')
) derived on derived.item_id = item.item_id