"""Query for retrieving details for the asset file."""
get_flac_file_details = """SELECT ald.audio_channels,
       ald.frequency,
       ald.bits_per_sample,
       ald.filename,
       ald.md5_hash
FROM asset a
    INNER JOIN asset_location al
        ON a.asset_id = al.asset_id
    INNER JOIN asset_location_detail ald
        ON al.asset_location_id = ald.asset_location_id
    INNER JOIN storage_drive sd
        ON al.storage_drive_id = sd.storage_drive_id
    INNER JOIN storage s
        ON sd.storage_id = s.storage_id
WHERE a.upc = :upc
AND s.physical_location_id = 1
AND asset_type_id = 440
AND filename = :filename;"""