X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fsearch%2Frelated_strip_prefetch.t;h=419fd3220f6d8059f553117e525af038b303ff5f;hb=7f4433eb9bbe0650b4f5e2dff8bf817f4d28d3df;hp=10621aeecaf5b5cd665296688278f61aab5fe076;hpb=63e943c2fb6d8d4479fb7d2287dcf4fcad577e99;p=dbsrgits%2FDBIx-Class.git

diff --git a/t/search/related_strip_prefetch.t b/t/search/related_strip_prefetch.t
index 10621ae..419fd32 100644
--- a/t/search/related_strip_prefetch.t
+++ b/t/search/related_strip_prefetch.t
@@ -25,13 +25,12 @@ is_same_sql_bind (
         SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
           FROM cd me
           JOIN artist artist ON artist.artistid = me.artist
-          LEFT JOIN track tracks ON tracks.cd = me.cdid
+          LEFT JOIN track tracks ON tracks.cd = me.cdid 
         WHERE ( tracks.id != ? )
         LIMIT 2
       ) me
       JOIN artist artist ON artist.artistid = me.artist
-      LEFT JOIN track tracks ON tracks.cd = me.cdid
-      LEFT JOIN tags tags ON tags.cd = me.cdid
+      JOIN tags tags ON tags.cd = me.cdid
     WHERE ( tags.tag IS NOT NULL )
     GROUP BY tags.tagid, tags.cd, tags.tag
   )',