SQL ERROR on Prev You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY alb.AlbumDateCreate DESC
                              LIMIT 0,1' at line 6<br>SELECT DATE_FORMAT(alb.AlbumDateCreate,"%Y-%m-%d")
    	                      FROM mp3_Albums alb JOIN mp3_Artists art ON alb.ArtistID = art.ArtistID
        		              WHERE DATE_FORMAT(alb.AlbumDateCreate,"%Y-%m-%d")<DATE_SUB("2009-01-08",INTERVAL 1 DAY)
        		                  AND DATE_FORMAT(alb.AlbumDateCreate,"%Y-%m-%d")>="2008-01-01"
        		                  AND alb.AlbumName NOT LIKE "TemporaryAlbumName%" AND art.ArtistID=2011589
        		                   AND alb.AlbumGenreID = 23ORDER BY alb.AlbumDateCreate DESC
                              LIMIT 0,1