[Top][All Lists]
[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)
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1845] fix the nowplaying sql,
Clint Adams <=