All pastes #442671 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-04-16 12:11 UTC
rendered paste body
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 = ?)