All pastes #440925 Raw Edit

hansbrix

public sql v1 · immutable
·published 2007-04-15 11:57 UTC
rendered paste body
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 itemleft join(	select distinct item_id	from keyword	where (keyword like '%' + ? + '%')) derived on derived.item_id = item.item_id