           (fields :a.id :a.name)
           (join [:composer_song :cs]
                 {:a.id :cs.composer_id})
-          (join [:songs :s]
-                {:cs.song_id :s.id})
-          (where {:s.id id})))
+          (where {:cs.song_id id})))
 
 (defn fetch-song-ost-names
   [song-id]

          (fields :s.id :s.name)
          (join [:remix_song :rs]
                {:s.id :rs.song_id})
          (join [:remixes :r]
                {:rs.remix_id :r.id})
          (where {:r.id id})))

(defn fetch-song-remixes
  [id]

          (fields :a.id :a.name)
          (join [:album_game :ag]
                {:ag.album_id :a.id})
          (where {:ag.game_id game-id})))

(defn fetch-game-remixes
  [game-id]
