X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fsearch%2Frelated_strip_prefetch.t;h=419fd3220f6d8059f553117e525af038b303ff5f;hb=f3f6c13a8ed810cce53141b462f372140e2ab2cd;hp=c65e6969d3959f4ab28dfd4b218c8f0f0b6f43e5;hpb=8baabfd829beb0870a097dac8e2dd6fb69c04ae8;p=dbsrgits%2FDBIx-Class.git

diff --git a/t/search/related_strip_prefetch.t b/t/search/related_strip_prefetch.t
index c65e696..419fd32 100644
--- a/t/search/related_strip_prefetch.t
+++ b/t/search/related_strip_prefetch.t
@@ -25,12 +25,11 @@ 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
       JOIN tags tags ON tags.cd = me.cdid
     WHERE ( tags.tag IS NOT NULL )
     GROUP BY tags.tagid, tags.cd, tags.tag