[banshee] Limit RandomBy query to 1 result

[Gabriel Burt <gburt src gnome org>]

commit af270ce975c35268bf9b2c89840190606678c7f2
Author: Gabriel Burt <gabriel burt gmail com>
Date:   Tue Feb 16 15:32:03 2010 -0800

    Limit RandomBy query to 1 result

 .../Banshee.Collection.Database/RandomBy.cs        |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/src/Core/Banshee.Services/Banshee.Collection.Database/RandomBy.cs b/src/Core/Banshee.Services/Banshee.Collection.Database/RandomBy.cs
index 58058b0..8b34b15 100644
--- a/src/Core/Banshee.Services/Banshee.Collection.Database/RandomBy.cs
+++ b/src/Core/Banshee.Services/Banshee.Collection.Database/RandomBy.cs
@@ -78,7 +78,7 @@ namespace Banshee.Collection.Database
                             FROM {2} {3} LEFT OUTER JOIN CoreShuffles ON (CoreShuffles.ShufflerId = {4} AND CoreShuffles.TrackID = CoreTracks.TrackID)
                             WHERE {5} {6} AND {7} AND
                                 LastStreamError = 0 AND (CoreShuffles.LastShuffledAt < ? OR CoreShuffles.LastShuffledAt IS NULL)
-                            ORDER BY {8}",
+                            ORDER BY {8} LIMIT 1",
                         provider.Select, Select,
                         Model.FromFragment, From, Shuffler.DbId,
                         String.IsNullOrEmpty (provider.Where) ? "1=1" : provider.Where, Model.ConditionFragment ?? "1=1", Condition,