# Pastebin oHHvn4A7 query = """ WITH rf AS ( SELECT user_id, recording_msid::text, score FROM recording_feedback WHERE recording_feedback.user_id=:user_id ) SELECT COALESCE(rf.user_id, :user_id) AS user_id, "user".musicbrainz_id AS user_name, rec_msid AS recording_msid, COALESCE(rf.score, 0) AS score FROM UNNEST(:recording_list) rec_msid LEFT OUTER JOIN rf ON rf.recording_msid::text = rec_msid JOIN "user" ON "user".id = :user_id """