"""Get track metadata by ISRC."""

SELECT_TRACK_METADATA_BY_ISRC = """
SELECT DISTINCT 
	t.id AS tuid,
	an.name AS artist_name,
	t.track_name,
	r.release_name,
	r.upc, 
	v.vendor_id,
	v.name AS vendor_name
FROM
    track t
    INNER JOIN releases r
        ON r.release_id = t.release_id
    INNER JOIN artist_info ai
        ON ai.artist_id = r.artist_id
    INNER JOIN artist_name an
    	ON ai.artist_id = an.artist_id
    INNER JOIN vendor v
        ON v.vendor_id = ai.vendor_id
WHERE
	t.isrc = %s;
"""