All pastes #441930 Raw Edit

Untitled

public sql v1 · immutable
·published 2007-04-15 22:46 UTC
rendered paste body
SELECT * FROM [Item] WHERE [item_id] IN (  SELECT [item_id]   FROM [Keyword] WHERE   (    [keyword] LIKE '%' + ? + '%'    AND [ItemPickup].[pickup_id] = ?  ) OR [Item].[title] LIKE '%' + ? + '%'  AND [ItemPickup].[pickup_id] = ?)