albums_reviews_flat (view)

33,937 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW albums_reviews_flat AS
select
  artists.display_name as artist,
  albums.display_name as album,
  genres.display_name as genre,
  albums.release_year as release_year,
  albums.display_rating as rating,
  reviews.pub_date as pub_date,
  'https://pitchfork.com' || reviews.url as url
from
  albums
  left join albums_artists on albums_artists.album_id = albums.id
  left join artists on albums_artists.artist_id = artists.id
  left join reviews_albums on reviews_albums.album_id = albums.id
  left join reviews on reviews_albums.review_id = reviews.id
  left join albums_genres on albums_genres.album_id = albums.id
  left join genres on albums_genres.genre_id = genres.id
order by
  pub_date desc,
  release_year asc;