[Librefm-commits] [1846] fix the nowplaying sql

[Clint Adams]

Revision: 1846
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1846
Author:   clint
Date:     2009-05-26 23:43:11 +0000 (Tue, 26 May 2009)
Log Message:
-----------
fix the nowplaying sql

Modified Paths:
--------------
    branches/stable/nixtape/data/Server.php

Modified: branches/stable/nixtape/data/Server.php
===================================================================
--- branches/stable/nixtape/data/Server.php     2009-05-26 23:42:06 UTC (rev 
1845)
+++ branches/stable/nixtape/data/Server.php     2009-05-26 23:43:11 UTC (rev 
1846)
@@ -198,9 +198,9 @@
                                                t.license
                                        FROM Now_Playing n
                                        LEFT OUTER JOIN Scrobble_Sessions ss
-                                               ON 
n.sessionid=Scrobble_Sessions.sessionid
+                                               ON n.sessionid=ss.sessionid
                                        LEFT OUTER JOIN ClientCodes
-                                               ON 
Scrobble_Sessions.client=ClientCodes.code
+                                               ON ss.client=ClientCodes.code
                                        LEFT OUTER JOIN Track t
                                                ON lower(n.artist) = 
lower(t.artist_name)
                                                AND lower(n.album) = 
lower(t.album_name)
@@ -222,9 +222,9 @@
                                                t.license
                                        FROM Now_Playing n
                                        LEFT OUTER JOIN Scrobble_Sessions ss
-                                               ON 
n.sessionid=Scrobble_Sessions.sessionid
+                                               ON n.sessionid=ss.sessionid
                                        LEFT OUTER JOIN ClientCodes
-                                               ON 
Scrobble_Sessions.client=ClientCodes.code
+                                               ON ss.client=ClientCodes.code
                                        LEFT OUTER JOIN Track t
                                                ON lower(n.artist) = 
lower(t.artist_name)
                                                AND lower(n.album) = 
lower(t.album_name)