# Pastebin jBEJGle7 sqlalchemy.exc.ProgrammingError sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column artist_credit_1.gid does not exist LINE 1: ...1.edits_pending AS artist_credit_1_edits_pending, artist_cre... ^ HINT: Perhaps you meant to reference the column "artist_credit_1.id". [SQL: SELECT musicbrainz.release_group.artist_credit AS musicbrainz_release_group_artist_credit, musicbrainz.release_group.type AS musicbrainz_release_group_type, musicbrainz.release_group.id AS musicbrainz_release_group_id, musicbrainz.release_group.gid AS musicbrainz_release_group_gid, musicbrainz.release_group.name AS musicbrainz_release_group_name, musicbrainz.release_group.comment AS musicbrainz_release_group_comment, musicbrainz.release_group.edits_pending AS musicbrainz_release_group_edits_pending, musicbrainz.release_group.last_updated AS musicbrainz_release_group_last_updated, musicbrainz.release_group_meta.id AS musicbrainz_release_group_meta_id, musicbrainz.release_group_meta.release_count AS musicbrainz_release_group_meta_release_count, musicbrainz.release_group_meta.first_release_date_year AS musicbrainz_release_group_meta_first_release_date_year, musicbrainz.release_group_meta.first_release_date_month AS musicbrainz_release_group_meta_first_release_date_month, musicbrainz.release_group_meta.first_release_date_day AS musicbrainz_release_group_meta_first_release_date_day, musicbrainz.release_group_meta.rating AS musicbrainz_release_group_meta_rating, musicbrainz.release_group_meta.rating_count AS musicbrainz_release_group_meta_rating_count, artist_credit_1.id AS artist_credit_1_id, artist_credit_1.name AS artist_credit_1_name, artist_credit_1.artist_count AS artist_credit_1_artist_count, artist_credit_1.ref_count AS artist_credit_1_ref_count, artist_credit_1.created AS artist_credit_1_created, artist_credit_1.edits_pending AS artist_credit_1_edits_pending, artist_credit_1.gid AS artist_credit_1_gid, artist_credit_name_1.artist_credit AS artist_credit_name_1_artist_credit, artist_credit_name_1.artist AS artist_credit_name_1_artist, artist_1.type AS artist_1_type, artist_1.area AS artist_1_area, artist_1.gender AS artist_1_gender, artist_1.begin_area AS artist_1_begin_area, artist_1.end_area AS artist_1_end_area, artist_1.id AS artist_1_id, artist_1.gid AS artist_1_gid, artist_1.name AS artist_1_name, artist_1.sort_name AS artist_1_sort_name, artist_1.begin_date_year AS artist_1_begin_date_year, artist_1.begin_date_month AS artist_1_begin_date_month, artist_1.begin_date_day AS artist_1_begin_date_day, artist_1.end_date_year AS artist_1_end_date_year, artist_1.end_date_month AS artist_1_end_date_month, artist_1.end_date_day AS artist_1_end_date_day, artist_1.comment AS artist_1_comment, artist_1.edits_pending AS artist_1_edits_pending, artist_1.last_updated AS artist_1_last_updated, artist_1.ended AS artist_1_ended, artist_credit_name_1.position AS artist_credit_name_1_position, artist_credit_name_1.name AS artist_credit_name_1_name, artist_credit_name_1.join_phrase AS artist_credit_name_1_join_phrase, release_group_primary_type_1.parent AS release_group_primary_type_1_parent, release_group_primary_type_1.id AS release_group_primary_type_1_id, release_group_primary_type_1.name AS release_group_primary_type_1_name, release_group_primary_type_1.child_order AS release_group_primary_type_1_child_order, release_group_primary_type_1.description AS release_group_primary_type_1_description, release_group_primary_type_1.gid AS release_group_primary_type_1_gid, release_group_meta_1.id AS release_group_meta_1_id, release_group_meta_1.release_count AS release_group_meta_1_release_count, release_group_meta_1.first_release_date_year AS release_group_meta_1_first_release_date_year, release_group_meta_1.first_release_date_month AS release_group_meta_1_first_release_date_month, release_group_meta_1.first_release_date_day AS release_group_meta_1_first_release_date_day, release_group_meta_1.rating AS release_group_meta_1_rating, release_group_meta_1.rating_count AS release_group_meta_1_rating_count FROM musicbrainz.release_group JOIN musicbrainz.release_group_meta ON musicbrainz.release_group.id = musicbrainz.release_group_meta.id JOIN musicbrainz.artist_credit AS artist_credit_1 ON artist_credit_1.id = musicbrainz.release_group.artist_credit LEFT OUTER JOIN (musicbrainz.artist_credit_name AS artist_credit_name_1 JOIN musicbrainz.artist AS artist_1 ON artist_1.id = artist_credit_name_1.artist) ON artist_credit_1.id = artist_credit_name_1.artist_credit LEFT OUTER JOIN musicbrainz.release_group_primary_type AS release_group_primary_type_1 ON release_group_primary_type_1.id = musicbrainz.release_group.type LEFT OUTER JOIN musicbrainz.release_group_meta AS release_group_meta_1 ON musicbrainz.release_group.id = release_group_meta_1.id WHERE musicbrainz.release_group.gid IN (%(gid_1)s) ORDER BY artist_credit_name_1.position] [parameters: {'gid_1': '0df90fea-35e2-3554-886b-7a806abdcb22'}] (Background on this error at: http://sqlalche.me/e/f405)