SELECT * FROM bids WHERE proxy != 1 ORDER BY amount DESC, time DESC
.. then do your sorting by item in Ruby. guess you could benchmark it to see which way is faster. not sure if that's what you were looking for...
On Jan 19, 2007, at 10:54 AM, Patrick Crowley wrote:
SELECT * FROM bids WHERE (item_id = 1 AND proxy != 1) ORDER BY amount DESC, time DESC
_______________________________________________ Sdruby mailing list [email protected] http://lists.sdruby.com/mailman/listinfo/sdruby
