librefm-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Clint Adams
Subject: [Librefm-commits] [1845] fix the nowplaying sql
Date: Tue, 26 May 2009 23:42:06 +0000

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

Modified Paths:
--------------
    trunk/nixtape/data/Server.php

Modified: trunk/nixtape/data/Server.php
===================================================================
--- trunk/nixtape/data/Server.php       2009-05-26 23:34:10 UTC (rev 1844)
+++ trunk/nixtape/data/Server.php       2009-05-26 23:42:06 UTC (rev 1845)
@@ -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)





reply via email to

[Prev in Thread] Current Thread [Next in Thread]