SELECT article.id, article.title, article.cd_art_url, article.cover_image, article.dt_pub, article.artist_name, discography.album_cover_url, musician.thumb_img, person.photo_url AS photo, DATE_FORMAT(article.dt_pub, '%M %d, %Y') AS pretty_date FROM article LEFT JOIN discography ON discography.id=article.album_id LEFT JOIN musician ON musician.id = article.musician LEFT JOIN person ON person.id = article.author WHERE article.status=10 AND (article.article_type=100 or article.article_type=96) AND discography.label_id=10753 ORDER BY article.dt_pub DESC LIMIT 10 Baja/TSR Records - United States

Jazz Near You

United States Home » Directory » Record Label » Baja/TSR Records

Baja/TSR Records

Address

More Info

Page views: 3,827

All Reviews

  1. Ready to Play Nils
    Ready to Play
    August 14, 2007
Add Album

Recent Releases

comments powered by Disqus