           (fields :a.id :a.name)
           (join [:album_game :ag]
                 {:ag.album_id :a.id})
-          (join [:games :g]
-                {:g.id :ag.game_id})
-          (where {:g.id game-id})))
+          (where {:ag.game_id game-id})))
 
 (defn fetch-game-remixes
   [game-id]

          (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})))

(defn fetch-song-ost-names
  [song-id]

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

(defn fetch-song-composers
  [id]
