           (fields :a.id :a.name)
           (join [:mixpost_evaluator :me]
                 {:a.id :me.artist_id})
-          (join [:remixes :r]
-                {:me.remix_id :r.id})
-          (where {:r.id id})))
+          (where {:me.remix_id id})))
 
 (defn fetch-remix-songs
   [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 [:remix_artist :ra]
                {:a.id :ra.artist_id})
          (where {:ra.remix_id id})))

(defn fetch-remix-downloads
  [id]
