All pastes #440934 Raw Edit

hansbrix

public sql v1 · immutable
·published 2007-04-15 12:03 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 itemwhere item_id in(    select distinct item_id    from keyword    where (keyword like '%' + ? + '%'))or item.title = ?